FelixBeta

Those are commands from 2232 server. You may need tweak offset to use gm commands or use some gameguard

Consider following video guide Run apps as admin

Works perfectly as long as you use it on SQL 2014 or newer (2014 recommended). Older version may have issues

Updated tool, gives better naming without removing .RFS or adding extra one.

If you mean 2022 "timegate" thing, for that you would need a game guard or if you are using yorozuya, there was somewhere a dll shared with fix. But no one knows what's inside it

For that you would need to be a Odin Secure customer. It's just part of guide for customers It's a paid product, so just skip that part.

Video tutorial of how to install Microsoft SQL Server 2014 and RF Online 2.2.3.2 server and client. Server and client files:

I've been using various RFS Unpack and Repack tools for quite some time. Each has its own set of advantages and disadvantages. For instance, some tools unpack files into the current folder, while others require you to drag and drop all the files from a folder to create an RFS file. I've developed my own tool that operates in a way that makes sense to me, and I hope you'll find it useful as well. Basic usage: 1. To unpack, simply drag and drop your .RFS file onto the executable. The files will be unpacked into a folder named %RFSNAME%.extract. You can drop multiple files simultaneously. 2. To repack, drag and drop your %RFSNAME%.extract folder onto the executable to create an RFS file. Again, you can drop multiple folders at once. Download: https://www.mediafire.com/file/7ddkxcxus0mjtgb/RFSTool.exe/file

I believe this can be fixed by changing sql connection driver in zone server rfacc.ini (I don't remember for sure since I don't work with AoP) To something like this: [Options] DBSTR = Provider=MSDASQL;DSN=BILLING;Source=BILLING;UID=sa;PWD=123456;Initial Catalog=BILLING; ErrDBSTR = LogLevel = 2 But this will work only if custom billing reads it

Certainly. Original forum had plenty of great guides and releases, sadly it got lost. If you can post something - feel free to do it. Just don't forget to include original author mention

perhaps you break the client formula, or didn't compile client side. Can be anything Be careful with what you edit and compile, looks at files dates, and don't forget to do client dat->edf

you missed 2 step sir. You should just edit 1 path in the beginning. You don't need to edit file path. All you need is to change WorkDir = "C:/RF_Online/Parser" to WorkDir = "D:/RF/Parser"

Making path with spaces is not good idea in any situation, consider just rename it

You can use xammp from PHP Parser topic, works fine. But for CCR launcher you would need to edit configs for sure

Downloaded via different pc, worked fine. Maybe try vpn?

I would like to share with you guys my tool for saving each spreadsheet list in excel file to make life easier when you work with PHP parser. Everyone knows how it's tricky to save each text file when you work on excel files for your server/client. Now you can just save excel files and run this tool, it will save all lists as tab delimited text files (be careful to name your lists the way parser wants, otherwise it will compile different file). Tool configured for 2.2.3.2 excels (default parser from forum fits well), but you can change ini for any version. Basic usage: 1. Unpack it somewhere, preferably near parser folder. 2. Open config.ini and edit path to your parser folder where gu_in folder is located. 3. Run ExcelTxt.exe Download: https://www.mediafire.com/file/1q0zuj8rextb7pz/ExcelTxt.7z/file Author: FelixBeta

Here is fixed default php excel parser from TriRozhka. For most of my projects I use specifically php version due to more flexibility. This is end of sale free version that does not include map parser. It will be a great tool for learning and developing your server. Forget about DatEdit and 010 You can also purchase C++ version directly from him. There is no guide for now, but your basic steps would be: - Edit Excel file and save it. - Click on spreadsheet list and click Save As (pick tab delimited txt file) and save your txt file. - Do this for server/client files that are changed. Most client spreadsheet data is linked to server via formula, so you don't need edit it. Only when you add/remove rows. - Compile via php in browser or cmd. Parser (English): https://www.mediafire.com/file/0ozhc4ifgmcoofo/Parser_GU_Clean_English_Fixed_2019.7z/file Parser (Russian): https://www.mediafire.com/file/2ov66e964i2fdw0/Parser_GU_Clean_Russian_Fixed_2019.7z/file Xamp (Apache + PHP) 1.7.0 (Suitable php version for running this parser): https://sourceforge.net/projects/xampp/files/XAMPP Windows/1.7/xampp-win32-1.7.0-installer.exe/download

Here is my full list of 2.2.3.2 GM commands that you can use on your server. Please note that some commands duplicate each other, some may require various situations to work, most commands require own syntax after command, like serial, type etc. Some default commands don't have names, but they are here in list and available in Odin Secure. ;;Add race currency. %show me the dalant ;;Add gold %show me the gold ;;Make yourself race leader %BossMe ;;Alter CW schedule, rough example %OneHourAfter 0 1 %OneHourAfter ;;Set owning neutrals guild %Set Settle Owner Guild ;;Clear owning neutrals guild %Clear Settle Owner Guild ;;Teleport to character %gotochar ;;Teleport to monster %gotomon ;;Give yourself premium %premium ;;Set guild grade to guild serial and grade. Example %Set Guild Grade 5 1 %Set Guild Grade ;;Set guild grade by the guild name %Set Guild Grade By Name ;;Set guild grade by the guild serial %Set Guild Grade By GuildSerial ;;Set yourself guild leader %MasterMe ;;Set your maximum level %altlv ;;Set server exp rate %setexprate ;;Teleport to npc by serial %gotonpc ;;Get npc quest %npcquest ;;Remove npc quest %delquest ;;Manage guild (propose GvG, add funds, expel players etc) %manageguild ;;Start guild master election %masterelect ;;Start cash shop event %conevent ;;Spawn item %* ;;Change account grade %change degree ;;Start event respawn %respawn start ;;Stop event respawn %respawn stop ;;Upgrade weapon %allmuzi ;;Show your xyz coordinates %xyz ;;Set your exp %altexp ;;Teleport to map (%jump Exile_land 0 0 0) %jump ;;Pass dungeon quest %pass dungeon ;;Make yourself invisible to any detect %transparent ;;Make yourself visiable %no transparent ;;Max attacking damage %max attack point ;;Min attacking damage %min attack point ;;Revert to normal attacking damage %normal attack point ;;Enable oneshot kill %matchless ;;Disable oneshot kill %no matchless ;;Teleport to racial HQ port (%port 0) %port ;;Teleport to racial Ether port (%eder 0) %eder ;;Teleport to transport ship %goto ship ;;Start chip war %start holy ;;Same as start holy %stone ;;Empty %stone bye ;;Same as stone bye (both commands does nothing) %keeper bye ;;Empty %servant ;;Same as servant %start keeper ;;Teleport to chip terminal %goto stone ;;Enable all loot from monster %beggar ;;Disable all loot from monster %no beggar ;;Send message to GM chat %# ;;Kick player %kick ;;Pass your quest one by one %pass quest ;;Summon player to you %charcall ;;Summon monster %moncall ;;Teleport to crag mines %goto mine ;;Copy player of same race and gender %copy ;;View total online %total ;;Kill yourself %die ;;Restore half of your hp/fp/sp %miracle ;;Restore full hp/fp/sp %fullmiracle ;;Make yourself invincible %neverdie ;;Make yourself mortal %no neverdie ;;Set level %lv ;;Set force skills PT %upfcitem ;;Set skill PT %upskill ;;Set force PT %upforce ;;Set all PT %allskill ;;Set contribute points %contribute_p ;;Set pvp points (currency) %contribute_m ;;Set animus recall time %recalltime ;;Set animus exp %recallexp ;;Enable/Disable monster respawn %monset ;;Set all force skills %full force ;;Spawn 4 inventory bags %threeseven ;;Clear your inventory %clear inven ;;Enable successful upgrade %god hand ;;Disable successful upgrade %chicken hand ;;Set buffs time %effect time ;;Clear all effects %effect clear ;;Show players number around you %circle ;;Set your set level and spawn equipment %fullset ;;Upgrade your armor %dfgrace ;;Set animus max/min/normal attack %recallattack ;;Set all your PT and skill PT to level 0-99 %allskillpt ;;Resurrect after death %resurrect ;;Create GvG field %createfield ;;Destroy GvG field %destroyfield ;;Regenerate gravity stone %regenstone ;;Destroy gravity stone %destroystone ;;Take gravity stone %takestone ;;Get gravity stone %getstone ;;Drop gravity stone %dropstone ;;Force take gravity stone %forcestone ;;Check goal %checkgoal ;;Show GvG schedule list %recvschedule ;;Show GvG battle info %recvbattleinfo ;;Show total guild rank %recvtotalguildrank ;;Show pvp guild rank %recvpvpguildrank ;;Change tax rate %changetaxrate ;;Set UMT delay %amp-set ;;Fill UMT storage %amp-full ;;Show server time %servertime ;;Summon party by part leader name %partycall ;;Summon guild by guild name %guildcall ;;Load your cash points amount %cashamount ;;Purchase cash shop item %csbuy ;;Set premium rates %primium ;;Set class refine event status %classevent ;;Take holy mental scanner %takeholymental ;;Set chip war status, start/end/keeper status like invincible or chaos etc %war ;;Set animus level %recalllv ;;Recover animus hp/fp %AniPow ;;Set nuclear effect %AfterEff ;;Remove skill/force delay %removesfdelay ;;Cancel auction registered items with logout %utcancellogout ;;Cancel auction registered items %utcancel ;;Save chat %chatsave ;;Drop jade by code %drop ;;Set ore amount %oreamount ;;Show remaining ore %remainore ;;Show server rates %serverrate ;;Show premium server rate %premiumrate ;;Set max/min/normal trap attacking point %trapattack ;;Set damaged body part %hitme ;;Start eventset %eventset start ;;Stop eventset %eventset stop ;;Set temporary pvp points %temp point ;;Refresh pvp killer list %new killerlist ;;End potion effect %buf ;;Attach/dettach lua script %lua ;;Ban player chat %userchatban ;;Set item loot rate %itemloot ;;Set mining speed rate %minespeed ;;Set skillforce PT rate %sfmastery ;;Set base PT rate %basemastery ;;Set animus exp rate %animuexp ;;Set player rate %playerexp ;;Set dungeon reward rate %darkholereward ;;Set premium item loot rate %pcitemloot ;;Set premium mining speed rate %pcminespeed ;;Set premium skillforce PT rate %pcsfmastery ;;Set premium base PT rate %pcbasemastery ;;Set premium animus exp rate %pcanimuexp ;;Set premium player rate %pcplayerexp ;;Give yourself premium %mepcbang ;;Get premium items %pcbangitemget ;;Expire premium %expirepcbang ;;Enable vote %voteenable ;;Show vote info %voteinfo ;;Set information for vote %playerset ;;Set vote conditions %envset ;;Set vote period %timeset ;;Set player timelimit %tlinfoset ;;View player timelimit %tlinfo ;;Set timelimit status %tlsysset ;;Set action points (0 - Process point, 1 - Kill point, 2 - Gold point) %actpset ;;Show action points event status %eventst ;;Set action point event status %setevent ;;Get golden boxes count %getboxcnt ;;Set hp % %sethp ;;Set full hp/fp/sp %hfs full ;;Punish player %punish ;;Remove punishment %unpunish ;;Update honor guilds list %update honor guild ;;Start cash shop discount event %startcashdiscountevent ;;End cash shop discount event %endcashdiscountevent ;;Start cash shop event %startcashevent ;;Look like race leader %BossLook ;;Set specific PT amount %changemastery ;;Empty %reportcrihp ;;Skip chip war schedule stage to next one %pass schedule ;;Empty %exit stone ;;Change all items amount in inventory to 1-99 %alterinvendur ;;Not sure, but something about PT %freesfbyclass ;;Spawn all craft materials %lootmaterial ;;Spawn all towers and materials %loottower ;;Spawn mine and battery %lootmine ;;Collect own or player stats information in txt file %charlog ;;Set guard tower. Cleans SystemGuardTower.ini! %makesystemtower ;;Destroy system tower %destroysystemtower ;;Remove archon message %removebossnotice ;;Create bank %trunkinit ;;Spawn everything for upgrade %lootupgrade ;;Spawn dungeon keys %lootdungeon ;;Spawn everything around you %powerloot ;;Kill monsters around you %powerkill ;;Complete another player quest %completequest ;;Loots upgraded item, but way not work %lootugradeitem ;;Add guild battle to schedule. Something like %addguildschedule Guild1 Guild2 23 1 0 (23 hour, 1 dunno what, 0 is bellato (1 cora, 2 acc)) %addguildschedule ;;%Setguildcolor 0 or 1 %setguildcolor ;;Current guild color %curguildcolor ;;Add one day to guild schedule, but needs many names :D %addonedayguildbattle ;;Empty %guildsuggest ;;Empty %guildinfo ;;Send combine result %excombineresult ;;Set damage to keeper %keeperdamage ;; %PatriarchAuto - Set Race Leader Voting with Cheat Possible.[Number 0 : Able to Vote with Cheat, 1 : Not Able to Vote with Cheat]. Example: %PatriarchAuto 0 %PatriarchAuto ;; %PatriarchProc - Set Race Leader Progress in order from 0 to 5. This cheat code needs to be preceded by %PatriarchAuto 0. [0 : Register Candidate, 1 : Additional Candidate, 2 : Start Voting 3 : Result Calculation, 4 : Apply for Board Members, 5 : Nominate Board Members] %PatriarchProc ;; %PatriarchInfo - VoteInfo Patriarch %PatriarchInfo ;;Remove pvp point limit %pvplimit ;;Increase playtime for coupons %playtimeinc

Here are various SQL queries that can help some administrators/developers to work with accounts and characters. All queries are mostly for 2.2.3 and newer versions. Feel free to add your own useful queries (place them in hide for portability).

A simple and straightforward guide on how to install Microsoft SQL Server 2014 database and management tool on your server. I strongly recommend to avoid any lower versions such as 2005 or 2008/R2 due to their total obsolescence and compatibility issues on modern systems. I'm using SQL 2014 Enterprise Edition, you can easily find it all over internet (prefer respected forums/torrents). Step 1: Unpack your sql 2014 .iso to any folder and run setup.exe as Administrator. Select installation tab and click New SQL Server stand-alone installation. Step 2: Don't mark option to check for updates and just click Next. Step 3: Wait till it scans for requirements and click Next. if needed - install .NET Framework, but usually it don't ask. Step 4: Select SQL Server Feature Installation and click Next. Step 5: Select Database Engine Services, Analysis Services, Management Tools - Complete and click Next. Step 6: As you are installing SQL Server on clean machine, just select Default Instance and leave ID default. Click Next. Step 7: Select Automatic as Startup Type for all services and configure Collation if needed. Russian users may need to make cyrillic collation. Step 8: Click Add Current User, it will automatically add system user in list. Then click Next. Step 9: Select Mixed Mode and enter password that will be used for "sa" login. After this, click Add Current User, it will automatically add system user in list. Step 10: Now just click Install and wait for installation complete. Step 11: Once installation complete you can start SQL Management Tool and connect to your server via default credentials or using sa user with defined password.

Re-check your ODBC setting for BILLING db. Also start your server as administrator You can also adjust zoneserver rfacc.ini: [Options] DBSTR = Provider=MSDASQL;DSN=BILLING;Source=BILLING;UID=sa;PWD=123456;Initial Catalog=BILLING; ErrDBSTR = LogLevel = 2

Hello RF Online Community, We understand the importance of third-party services like security solutions, script development,hosting and Game Control Panels (GameCP) in running a successful RF Online server. This thread aims to collect your valuable feedback, experiences, and recommendations regarding these services. Whether you had an excellent experience or ran into some issues, your insights can help others make informed decisions. Please share your thoughts using the template below: Product/Service Name: Website or Forum Link: Owner Name: Feedback: Thank you for taking the time to share your feedback. Your experiences can go a long way in helping others in our community. Best regards, FelixBeta

Heh Only made this long time ago, and since I don't use AoP, no intention to make newer. 2232 power!

Those are community default RF Online Age Of Patron files. Core of the files are PlayPark updated client as of 12.04.2021 and TriRozhka modified server files Nov 2016 build. Client Information: - Client scripts are synced with server scripts including general portion of Belzeebub update. - Added Russian datatable with 2232 translation, Age of Patron content remains English. Server Information: - Server scripts are synced with client scripts including general portion of Belzeebub update. Server: https://www.mediafire.com/file/ej35qebrswnmhl1/Default_AoP_Server.7z/file Client: https://www.mediafire.com/file/87klwsusfg2j6hh/Default_AoP_Client.7z/file

Those are default server and client files, suitable for learning RF Online game. As any retail file, it has some imperfections that you can adjust or change. From my side, I would recommend you to use Microsoft SQL Server 2014 (Please, don't use old stuff like 2008 that will cause you issues eventually). You can use later versions, but they have external Management tools, which are slow. Don't restore .bak files if you don't know their origin, always try to use database creation scripts from RF_User and RF_World folders, one by one. Server: https://www.mediafire.com/file/e19rrbx4gqvq01e/Default_2232_Server.7z/file RF_User creation sql script (Ready to use) https://www.mediafire.com/file/niatallpdbxjr1i/RF_User_clean_sql2014.sql/file RF_World creation sql script (Ready to use) https://www.mediafire.com/file/ja5t5kgiazs44oz/RF_World_clean_sql2014.sql/file BILLING creation sql script (Ready to use) https://www.mediafire.com/file/eb1p45ao5dzo4za/BILLING_clean_sql2014.sql/file Client: https://www.mediafire.com/file/2hxg0gzvlh9gdvn/Default_2232_Client.7z/file Small developer launcher: https://www.mediafire.com/file/7ag1pk4md503sbu/DevLauncher.7z/file Default R3Engine.ini for english client language: You can create simple .bat file to register your db ODBC. Feel free to change SQL connection provider, names or other data. Start your server As Administrator. ODBC.bat code: @echo off set bil=BILLING set acc=RF_User set wld=RF_World %WINDIR%\System32\odbcconf.exe CONFIGDSN "SQL Server" "DSN=%bil%|Description=|SERVER=(local)|Trusted_Connection=Yes|Database=%bil%" %WINDIR%\System32\odbcconf.exe CONFIGDSN "SQL Server" "DSN=%acc%|Description=|SERVER=(local)|Trusted_Connection=Yes|Database=%acc%" %WINDIR%\System32\odbcconf.exe CONFIGDSN "SQL Server" "DSN=%wld%|Description=|SERVER=(local)|Trusted_Connection=Yes|Database=%wld%"