R2 Online server files

[hthappy]

Hi everyone, does anyone know how to modify the contents of a Special Chest in a character's backpack? Which function is related to the information of the supply box? I want to change the ID of the items inside. Thank you.

 

[defo854]

Hi everyone, does anyone know how to modify the contents of a Special Chest in a character's backpack? Which function is related to the information of the supply box? I want to change the ID of the items inside. Thank you.

FNLParm - dbo.tblmaterialDrawMaterial and dbo.tblMaterialDrawResult

 

[coolstars90]

I want to know how to change the Russian language to Korean after accessing the launcher

 

[xxodnr12]

How do I recharge the cash? Couldn't find it in the table.

 

[hthappy]

Thank you for your guidance

FNLParm - dbo.tblmaterialDrawMaterial 和 dbo.tblMaterialDrawResult

 

[defo854]

How do I recharge the cash? Couldn't find it in the table.

FnlAccaunt - dbo.Member

 

[iamrgb]

gm tools
https://www.youtube.com/watch?v=xskDZMYlFtA

 

[xxodnr12]

Can I get GM commands and Korean item codes?

 

[TheReverend]

gm tools

Nice work but it's easier to use PTS client with official GM panel, which has a lot more options apart from item creation.

 

[TheReverend]

Can I get GM commands and Korean item codes?

What you mean Korean codes, Item ID are all the same in any version, open GUI Folder, then gui archive inside of it, look for Lang Pack.tsv file it contains 90% of the Client text, you can search items opening this file with any text editor, look for client that has Korean Langpack file, or use google translator and translate it from russian or chinese.

 

[@Aksel]

List of admin commands, use the admin client and enter them via chat:

Command	Desc_Rus	Desc_Eng
!ability	Включает/выключает отображение статов персонажа в правой части экрана	Enables / disables the display of character stats on the right side of the screen
!qstate	Выводит статус задания (quest) (1/0)	Displays the status of a quest (1/0)
!combineservant	Объединяет двух питомцев	Combines two pets
!effectscale	Изменяет размер спецэффектов	Changes the size of special effects
!monsterequipservant	Одевает экипировку на питомца	Equips pet equipment
!servantfriendlyskill	Устанавливает дружелюбный скилл на питомца	Sets a friendly skill on a pet
!servantfriendlymax	Устанавливает максимальный уровень доверия питомца	Sets the pet's maximum trust level
!servantlevelup (lvl)	Повышает уровень питомца	Levels up your pet
!rqcomplete	Завершает все квесты	Completes all quests
!changeweather	Меняет погоду	Changes the weather
!qmakinginit	Сбрасывает прогресс крафта	Resets crafting progress
!logoutguild	Выходит из гильдии	Leaving the guild
!qcheck	Выводит номер задания (quest) системным сообщением	Displays the job number (quest) as a system message
!qmoncnt (количество)	Убить указанное количество монстров для выполнения задания (quest)	Kill the specified number of monsters to complete the quest (quest)
!csnresume	Возобновляет работу игрового магазина	Resumes the work of the game store
!csnpause	Приостанавливает работу игрового магазина	Suspends the game store
!popup	Настройки всплывающих подсказок (нажать g)	Tooltip settings (press g)
!ccheck	Выводит информацию о drop, exp, silver rate в чат	Displays information about drop, exp, silver rate in chat
!creset	Сбрасывает настройки в чате	Resets chat settings
!cnoexpd	Отключает отображение получаемого опыта в чате	Disables the display of experience gained in chat
!cnodrop	Отключает отображение получаемого дропа в чате	Disables the display of the received drop in the chat
!csilverr	Отображает получаемое серебро в чате	Displays received silver in chat
!cexpr	Отображает получаемый опыт в чате	Displays experience gained in chat
!cdropr	Отображает получаемый дроп в чате	Displays received drop in chat
!checkwall	Проверка на вх	Check for input
!rum (hz)	Меняет скорость передвижения персонажа??	Changes character's movement speed
!sumauto	Автоматический режим убийства монстров	Automatic monster killing mode
!setmodel (номер монстра)	Устанавливает модель монстра (для отключения ввести 0)	Sets the monster model (enter 0 to disable)
!incsyscheckend	Выключает проверку изменений шанса действия предмета	Turns off checking for item effect chance changes
!incsyscheckrefresh	Обновляет список предметов для проверки изменений шанса действия	Updates the list of items to check for changes to the chance of an action
!checkincsyslist	Выводит список предметов для проверки изменений шанса действия	Displays a list of items to check for changes to the chance of an action
!incsyscheckstart	Включает проверку изменений шанса действия предмета	Enables checking for item effect chance changes
!mallmaintenanceend	Выключает профилактику магазина	Turns off Store Prevention
!applymalllist	Обновляет список магазина	Refreshes the store list
!mallmaintenancestart	Включает профилактику магазина	Includes store prevention
!checkmalllist	Сбор информации о новом магазине предметов	Gathering information about the new item shop
!checkinven (имя игрока)	Проверить инвентарь игрока	Check Player Inventory
!moninfo	Выводит hp/mp монстра по его серийному номеру	Displays the hp/mp of a monster by its serial number
!monnum	Показывает имена монстров вместо их серийных номеров, и наоборот (повторное использование команды)	Shows monster names instead of their serial numbers, and vice versa (command reuse)
!gucall	Вызов агента гильдии	Guild Agent Summon
!rangeauto (5-20)	Автоматическая проверка в пределах указанного радиуса	Automatic check within the specified radius
!guilditemefftime	Выводит время, оставшееся до окончания эффекта гильдейского предмета	Displays the time remaining until the end of the effect of the guild item
!pcitemefftime	Выводит время, оставшееся до окончания эффекта персонального предмета	Displays the time remaining until the effect of a personal item ends.
!eventmsg	Отправляет ивентовое сообщение всем игрокам	Sends an event message to all players
!weapon	Отображает информацию о оружии	Displays weapon information
!guiname	Отображает названия всех персонажей и npc	Displays the names of all characters and npc
!observer	Переводит в режим свободной камеры и возвращает в исходное место	Switches to free camera mode and returns to the original location
!cam	Свободная камера	free camera
!disg (размер)	Изменяет размер персонажа и даёт рандомный морф в зависимости от размера	Changes the size of the character and gives a random morph depending on the size
!inf	Режим отладки	Debug Mode
!col	Режим коллизии	Collision mode
!ctmon	Отображает номер npc в системном чате	Displays npc number in system chat
!ejps	Отображает статы юпитера	Displays Jupiter's stats
!ejpp	Отображает статы баальбека руб.	Displays the stats of the baalbek rub.
!tmon	Включает/выключает режим ввода сообщений npc	Enables/disables npc message entry mode
!dmon	Удаляет npc	Removes npc
!cmon (MID монстра)	Призывает монстра с указанным mid	Summons a monster with the specified mid
!refreshutgwrank	Обновляет рейтинг UTG War	Updates UTG War rating
!standardfps	Сбрасывает настройки камеры	Reset camera settings
!hide	Скрывает персонажа	Hides a character
!show	Отображает персонажа	Displays character
!off	Выключает чат	Turns off chat
!flag	Устанавливает флаг на местности	Sets a flag on the terrain
!fly	Устанавливает силу тяжести персонажа администратора равной 0, позволяя подниматься вверх без ограничений (для отмены повторите команду)	Sets the admin character's gravity to 0, allowing it to ascend without restriction (repeat the command to cancel)
Ctrl+0	Повышает скорость игрока	Increases the player's speed
Ctrl+9	Понижает скорость игрока	Decreases the player's speed

 

[BountyHunter]

List of admin commands, use the admin client and enter them via chat:

• !ability -- Stats on/off on the right side
• !qstate
• !combineservant
• !effectscale
• !monsterequipservant
• !servantfriendlyskill
• !servantfriendlymax -- maximum pet trust level
• !servantlevelup (lvl)-- increase pet level
• !rqcomplete
• !changeweather
• !qmakinginit
• !logoutguild
• !qcheck -- Command to display the quest number as a system message. To do this, select the quest from the list and enter the command.
• !qstate -- quest status 1/0
• !qmoncnt (quantity) -- Kill the required number of monsters with the given ID to complete the quest
• !csnresume
• !csnpause
• !popup -- settings for pop-up tooltips (press G)
• !ccheck -- Info on Drop, Exp, Silver Rate in chat
• !creset
• !cnoexpd
• !cnodrop
• !csilverr
• !cexpr
• !cdropr
• !checkwall -- check for wall hack
• !rum (hz)
• !sumauto
• !setmodel -- !setmodel some strange monster number, !setmodel - 0 turn off.
• !incsyscheckend -- Turn off item action chance change check
• !incsyscheckrefresh
• !checkincsyslist
• !incsyscheckstart -- Turn on item action chance change check
• !mallmaintenanceend -- Turn off shop maintenance
• !applymalllist -- Update shop list
• !mallmaintenancestart -- Turn on shop maintenance
• !checkmalllist -- Collect information on new item shop
• !checkinven -- !checkinven Player Name -- Check player's inventory
• !moninfo -- Enter in the dialog box: (Monster serial number)(Serial number) Monster's HP/MP
• !monnum -- Display names of monsters within 12 sectors around the character instead of their serial numbers. Entering the command again changes names back to numbers.
• !gucall
• !rangeauto (5-20) -- Automatic check within radius
• !checkauto (Player Name) -- Check character's statistics
• !guilditemefftime
• !pcitemefftime
• !eventmsg -- Event message to everyone
• !weapon --
• !ability -- Enable stats panel on the right side
• !guiname -- Display names of all characters and NPCs
• !observer -- Free camera mode (returns you to the original location)
• !cam -- Free camera
• !disg (hz)
• !inf -- Debug mode
• !col -- Collision mode
• !ctmon - Display NPC number in system chat
• !ejps
• !ejpp -- Jupiter and Baalbek Rub stats
• !tmon -- Message input mode on/off
• !dmon -- NPC deletion mode
• !cmon -- Summon a monster !cmon MID of the monster
• !refreshutgwrank
• !standardfps -- Reset camera settings
• !hide
• !show
• !off
• !flag
• !fly -- Enter the command to set the administrator character's gravity to 0. Repeat the command to cancel it. With gravity set to 0, you can continuously move upward, but you cannot descend.
• !monnum -- Display unique serial code of NPCs
• !disg (size)-- Change character size + gives a random morph depending on size
• Ctrl + 0 -- Increase player speed
• Ctrl + 9 -- Decrease player speed

thanks you so much. .

 

[Roland667]

To those who want to keep further work on the server, or share new files or info about server management or modifications, here i leave to my google drive with fullyworking server (1502) version,you just need to unpack and is ready to play, only thing you need to do is set your host (PC) IP to 192.168.1.103 and virtual machine to 192.168.1.133 (only if it resets for some reason after you unpack virtual machine.) ingame shop is configured and working, only thing i left outside of virtual machine is web admin, i have it configured on my host (pc) and not inside virtual machine, if you need webadmin configure it yourself inside or outside of VM. To enter inside database use login 11 and password is 777777 (this user is used in config for in game shop (isapifilter.dll)) don't delete this user, and other important user is ghostface, server configs are configured to this 2 sql users, if you want to delete them or modificate passwords, you should modify all DLL and config files first. if you just wan't to play, then just change your host pc IP and thats all. Server is compressed, databases cleared from 50GB to less than 500Mb whole virtual machine including windows server is 12,6 GB only. To launch and shut down server use desktop icon "R2 Server - v4.81" (Run as administrator) , there's some garbage on desktop, since it's test build so feel free to delete it yourself if you don't need it. Also u can disable auto updates if you don't need them, windows server is cracked with KMS pico so it receives official security updates time to time. If you have any questions ask here or in discord Mr.Shadows#4261 Link to client without lag while teleporting use "Launcher" exe just type in login and click play don't need to write password, to create new account same just type login and play

can you please give a link to r2 free day ver 2.0? previous link is broken

 

[Roland667]

To those who want to keep further work on the server, or share new files or info about server management or modifications, here i leave to my google drive with fullyworking server (1502) version,you just need to unpack and is ready to play, only thing you need to do is set your host (PC) IP to 192.168.1.103 and virtual machine to 192.168.1.133 (only if it resets for some reason after you unpack virtual machine.) ingame shop is configured and working, only thing i left outside of virtual machine is web admin, i have it configured on my host (pc) and not inside virtual machine, if you need webadmin configure it yourself inside or outside of VM. To enter inside database use login 11 and password is 777777 (this user is used in config for in game shop (isapifilter.dll)) don't delete this user, and other important user is ghostface, server configs are configured to this 2 sql users, if you want to delete them or modificate passwords, you should modify all DLL and config files first. if you just wan't to play, then just change your host pc IP and thats all. Server is compressed, databases cleared from 50GB to less than 500Mb whole virtual machine including windows server is 12,6 GB only. To launch and shut down server use desktop icon "R2 Server - v4.81" (Run as administrator) , there's some garbage on desktop, since it's test build so feel free to delete it yourself if you don't need it. Also u can disable auto updates if you don't need them, windows server is cracked with KMS pico so it receives official security updates time to time. If you have any questions ask here or in discord Mr.Shadows#4261 Link to client without lag while teleporting use "Launcher" exe just type in login and click play don't need to write password, to create new account same just type login and play

can you please give a link to r2 free day ver 2.0? previous link is broken

 

[TheReverend]

can you please give a link to r2 free day ver 2.0? previous link is broken

updated the link for client..

 

[Roland667]

updated the link for client..

you are the best, thank you)

 

[Mr.AlexXIII]

Good day to everyone who is alive in this thread! I am writing through google translator, so the translation will be incorrect. I play on a virtual machine that TheReverend threw off, EVERYTHING IS EXCELLENT, EVERYTHING IS WELL, I figured out more with the base, the main questions remain:
1. How to add through the base through gifts or inventory?
2. How to start WebAdmin?
3. How do I start the PTS administration client?
Please describe everything step by step, thanks in advance!

 

[jeong yeong sik]

I got a lot of information from here and succeeded in building it. thank you
Thanks.R2 Online server files.감사합니다.

It was built based on the file of the (R2 ghostface).

TheReverend <<<<very very Thanks​

Discord jys5460#7873

 

[defo854]

Good day to everyone who is alive in this thread! I am writing through google translator, so the translation will be incorrect. I play on a virtual machine that TheReverend threw off, EVERYTHING IS EXCELLENT, EVERYTHING IS WELL, I figured out more with the base, the main questions remain:
1. How to add through the base through gifts or inventory?
2. How to start WebAdmin?
3. How do I start the PTS administration client?
Please describe everything step by step, thanks in advance!

ВЫДАТЬ ПОДАРОК

DECLARE @mSysID BIGINT = 196490 /* TBLSysOrder.mSysID */

DECLARE @mUserNo INT = 2139833 /* ID аккаунта */

DECLARE @mSvrNo SMALLINT = 2156 /* номер сервера */

DECLARE @mItemID INT = 8432 /* ID предмета */

DECLARE @mCnt INT = 10 /* количество */

DECLARE @mAvailablePeriod INT = 0 /* срок действия предмета */

DECLARE @mPracticalPeriod INT = 0 /* длительность эффекта */

DECLARE @mBindingType TINYINT = 0 /* замок */

DECLARE @mLimitedDate SMALLDATETIME = '2079-06-06' /* лимит времени */

DECLARE @mItemStatus TINYINT = 1 /* проклятый, обычный, благой */



INSERT INTO [FNLBilling].[dbo].[TBLSysOrderList] (mAvailablePeriod, mCnt, mItemID, mPracticalPeriod, mSvrNo, mSysID,

mUserNo, mBindingType, mLimitedDate, mItemStatus)

VALUES (@mAvailablePeriod, @mCnt, @mItemID, @mPracticalPeriod, @mSvrNo, @mSysID, @mUserNo, @mBindingType, @mLimitedDate,

@mItemStatus)

 

[defo854]

1please tell me where to get the admin client.
2how do I configure the game client to change the crafting menu. I understood how to do it in the database. and I can't figure out the client.
3what kind of files are in the client in a folder called env.