G-OP (Tool)

G-OP is an Operator-only tool for sending certain "commands" to the database.

How to set up G-OP

Thanks to altasking for their tutorial on the RageZone Forums! It's been slightly modified for here and with added verbage.

1. Create a .bat Batch file with this code:

Note: When you launch G-OP after this method, choose the server group then click Login and click OK and it will log you in.

Code:

@Echo off
set /p id=insert GM Character : 
echo login : %id%
set /p pw=insert GM Password : 
echo login : %pw%
G-OP gmtool0831 %id% %pw%

G-OP Shortcut

or

you can create a Shortcut of g-op.exe

Code:

Path\to\G-OP.exe gmtool0831 yourCHARname yourpassword

It's very important here: you do not use your username, just your character name.

So for example:

E:\G-OP\G-OP.exe gmtool0831 [GM]Ntreev test1

2. Edit G-OP.INI

Note: copy your libconfig_twn.dat and rename it to libconfig_eng.dat (can't guarantee if this works with ours but ours is split xml then rebuilt instead of the prebuilt libconfig--I just use the one provided with the files)

Code:

[Main]
; =============================================================================
; Language Definition File
Lang = lang\english.lang
; Login Configurations
RemeberAccountInfo =1
; Map Information File
zoneid_table = zoneid_table.xml
; =============================================================================
; Server Group
; =============================================================================
ServerGroup = USA_MAIN
userid= Username
; =============================================================================
; World Definition
; =============================================================================
[USA_MAIN]
WorldList = World-1
; =============================================================================
; Island(Channel) Definition
; =============================================================================
; Island# = [islandname], [IP], [PORT], [IsChecked]; [World-1]
NumberOfIsland = 1
Island0 = Island1, Online IP, LoginServer Port, 1
; =============================================================================
[USERPREF]
DestDir = \G-OP\ny\data\libconfig_eng.dat

Make sure to configure the bold to your specifications. That's Username, Online IP, LoginServer Port, and Destination Directory. Did you get all those? Good. Let's move on.

3. Update Database table/ columns, With Stored Procedures:

The exp password is: ?whtlagkqtlek!

Stored Procedures:

usprfg_gm_char_select_gm_client_login

USPT_GM_USER_ADD

uspt_user_update_register_gm

uspt_user_update_register_gm_char

Tables to change:

Note: If you can't figure out the stored procedures, reverse-engineering this is easier

tbl_gm_char:

Permitted_IP: use your Online IP.

tbl_gm_char_permit_ip:

Permit_IP: use your Online IP.