[Share] Add GM + Cubi-Coin on MySQL + Commands

[segredu]

add GM and Cubi-Coin in MySQL database

1- Open your browser with http:// server IP /phpmyadmin/
2- Select privilegious tab and add :
user = "your server name"
server = localhost
pass = "your pass"
3- Select you dbo database and select SQL tab
4- Digit this code (change 32 for your Char ID) and click Execute

ADD GM

call addGM (32 , 1)

ADD 10.000 CUBI-COIN

call usecash (32 , 1, 0, 1, 0, 1000000, 1, @error)

Good Luck

Console commands Press: CTRL J for Debug, CTRL G for GM

Debug console commands:
d_cameramode
d_boundbox
d_rtdebug
d_npcid
d_runspeed
d_goto
d_fly
d_c2scmd
d_viewradius
d_relogin
d_skill
d_render_water
d_render_grass
d_render_forest
d_render_shadow
d_render_outline
d_turnaround
d_testdist
d_gfx
d_showpos
d_trnlayer
d_a3dstat
d_gamestat
d_treelod
d_fps
d_playerradius
d_showid
d_skipframe
d_modelupdate
d_minidump
d_settimeofday
d_getservertime
d_task
d_mipmapbias
d_trncull
d_gscmd
d_delcmd

GM console commands:
gm_kickout_role
gm_kickout_user
gm_list_user
gm_online_num
gm_restart_sev
gm_shutup_role
gm_shutup_user
gm_moveto_player
gm_callin_player
gm_broadcast
gm_showid
gm_forbid_role
gm_trigger_chat
gm_generate

Event command GM

To use, GM says the console Activate monster creater ID
Where ID is the number eventa (to choose from the list below) ID - Events

Christmas Events
2 - Christmas Meeting (in Snowmans ADC dropping celestial stones, etc.)
3 - Santa Claus NPC close to the city Ethersword Elder
4 - Santa's NPC close to the city of feathers Elder
5 - Santa Claus NPC disappeared near the town of Big
6 - Santa Claus NPC close to the Rose and Eunice in the ancient town of Dragon
8 - activate boxes in the arena (the GM should be within the start)

Horse racing
9 - Activate monthly / annually in Horserace feathers (the GM should be in place)
10 - the same as 9
11 - the same as 9

Communication event
12 - mailboxes (by default set to remeove them using Close monster creater)
13 - Messenger Angel Chiling (NPC all mailboxes for sale World Pipes, and postal service), also adds a replacement for the Perfect Present NPCs Ambassadors
14 - Perfect Present Ambassador (defauld installed to remove them using Close monster creater)

Event feelings vengeful
66 - Invisible Town Hero feelings vengeful 20
67 - Cambridge Village feelings vengeful 20
68 - Bamboo Village feelings vengeful 20
69 - Walled Fortress feelings vengeful 20
70 - Ancient Entreance feelings vengeful 20
71 - South Fortress feelings vengeful psychological level of 20
72 - Ground Logging feelings vengeful 20
73 - around the city feeling vengeful 20
74 - Barbarian Village feelings vengeful 20
75 - Mirror Lake feelings vengeful 40
76 - orchis Sereene level of feelings vengeful 40
77 - Allied army camp level feelings vengeful 40
78 - Fishing village level feelings vengeful 40
79 - clan haste level feelings vengeful 50
80 - Town Forward wind feelings vengeful 50
81 - Camp Sumor level of feelings vengeful 50
82 - Sundown Town level feelings vengeful 50
83 - City-level feelings come vengeful 50
84 - Arrow Manor level will intensify feelings vengeful 70
85 - City-level feelings of unhappiness vengeful 70
86 - Fangs Town level feelings vengeful 70
87 - Dreaming Cloud Village level feelings vengeful 70
88 - Whetstone Stronghold level feelings vengeful 70
89 - Village of Lost feelings vengeful level 90 flying
90 - Sanctuary of the city of senses vengeful of 90 flying
91 - Nottingham Village vengeful feelings of 90 flying
92 - despite the beauty village level feelings vengeful 90
93 - Fire Bathing Village level feelings vengeful 90
94 - South City Screen sensory level vengeful 90
95 - East City Screen level of feelings vengeful 90
96 - North City Screen sensory level vengeful 90
97 - Expeditionary camp level feelings vengeful 100
98 - Snowswept Village-level feelings vengeful 100
99 - Shattered ice level feelings vengeful 100
100 - Avalanche 100 senses vengeful

ADC invasion events
109 - Start final ADC invasion wave (When bosses kill his success onwars to wave 1, and if the owners were aggroed dont they disappear when the event is closed)
110 - ADC start of the invasion wave 1
111 - the invasion ADC Wave 2
112 - ADC start of the invasion wave 3
113 - beginning of the invasion wave ADC 4
114 - ADC invasion last boss outside the ADC North
117 - ADC invasion last boss outside the ADC North
118 - ADC invasion last boss outside the ADC West
119 - ADC invasion last boss outside the ADC South
120 - ADC invasion last boss outside the ADC South
121 - ADC invasion last Bosse leader north ADC
125 - NON-AGGRO Boss inside the walls of the north gate of ADC
126 - General and desperate line of guards for the ADC. Useful for ADC if the invasion

New Events
127 - New Year lanterns (lamps) in most buildings, and 20 lantern NPCs (New Year's Riddle lamps) in the center of ADC, there are no quests
128 - New Year Boss for ADC West, North and South, which drops fireworks, a mirage, Eng Bao (10-50 kb gives gold) and we congratulate the trait that gives the system the announcement "The player wants all players in a perfect world a happy and prosperous China New Year! "Besides, adds a" Christmas gift Peddlery "NPC which sells gift items (without the use / benefit of the unknown so far)

Other
134 - puts the fields around the teleporters in Ethersword, disappeared and feathers

Credits by Google. =)

[MentaL]

[evilgenx]

Very nice. Everything works fantastic!

+5.

[michae5k]

hmm when i press CTRL J no console comes up hmm...

[segredu]

hmm when i press CTRL J no console comes up hmm...

Press CTRL J for Debug....
But you Debug Mode is active in your Server ?

[neuzaty]

Press CTRL J for Debug....
But you Debug Mode is active in your Server ?

how to make debug mode aktiv ??

[hihihihuhuuu]

And how can I delete GM rights from account?

[Wizatek]

the key combination normally is : "shift + ~ "
But you need to start your client with instructions.

elementclient.exe game:cpw console:1

[Dragganta]

hmmm im bit sad so i wonder BATGM dit works once i try but i want renew server all .. and no

batgm - send it up to mysql right but my char looks like empty from cubi--

and same with command call usecash (32 , 1, 0, 1, 0, 1000000, 1, @error)
send again to mysql but fukn char empty..

so something wrong maybe with my client .. or wat im doing wrong

and
char need to login or logoff for it???

[Romulan]

Humm... I use BATGM.. never had problems

1. I open BATGM and add cubi-gold to my account.
2. I'm waiting about 10minutes.
3. I relog my account and cubi-gold appears in my Item Mall...

I don't know why do you have some problems with BATGM...

ps: i can directly add cubi-gold after the first transaction... i don't must wait 24hours or something like this before add cubi-gold again. ^^

[stoni]

so...lets say i want to automate an event. What would be the call on the server to do that. Is it "Activate monster creater ID" where ID is the number of the event? I want to be able to make the call on the server so that a GM doesnt have to be logged in. That way events can still happen without a GM being on. Thanks for help in advance

[Allvis]

add GM and Cubi-Coin in MySQL database

1- Open your browser with http:// server IP /phpmyadmin/
2- Select privilegious tab and add :
user = "your server name"
server = localhost
pass = "your pass"
3- Select you dbo database and select SQL tab
4- Digit this code (change 32 for your Char ID) and click Execute

ADD GM

call addGM (32 , 1)

ADD 10.000 CUBI-COIN

call usecash (32 , 1, 0, 1, 0, 1000000, 1, @error)

Good Luck

Console commands Press: CTRL J for Debug, CTRL G for GM

Debug console commands:
d_cameramode
d_boundbox
d_rtdebug
d_npcid
d_runspeed
d_goto
d_fly
d_c2scmd
d_viewradius
d_relogin
d_skill
d_render_water
d_render_grass
d_render_forest
d_render_shadow
d_render_outline
d_turnaround
d_testdist
d_gfx
d_showpos
d_trnlayer
d_a3dstat
d_gamestat
d_treelod
d_fps
d_playerradius
d_showid
d_skipframe
d_modelupdate
d_minidump
d_settimeofday
d_getservertime
d_task
d_mipmapbias
d_trncull
d_gscmd
d_delcmd

GM console commands:
gm_kickout_role
gm_kickout_user
gm_list_user
gm_online_num
gm_restart_sev
gm_shutup_role
gm_shutup_user
gm_moveto_player
gm_callin_player
gm_broadcast
gm_showid
gm_forbid_role
gm_trigger_chat
gm_generate

Event command GM

To use, GM says the console Activate monster creater ID
Where ID is the number eventa (to choose from the list below) ID - Events

Christmas Events
2 - Christmas Meeting (in Snowmans ADC dropping celestial stones, etc.)
3 - Santa Claus NPC close to the city Ethersword Elder
4 - Santa's NPC close to the city of feathers Elder
5 - Santa Claus NPC disappeared near the town of Big
6 - Santa Claus NPC close to the Rose and Eunice in the ancient town of Dragon
8 - activate boxes in the arena (the GM should be within the start)

Horse racing
9 - Activate monthly / annually in Horserace feathers (the GM should be in place)
10 - the same as 9
11 - the same as 9

Communication event
12 - mailboxes (by default set to remeove them using Close monster creater)
13 - Messenger Angel Chiling (NPC all mailboxes for sale World Pipes, and postal service), also adds a replacement for the Perfect Present NPCs Ambassadors
14 - Perfect Present Ambassador (defauld installed to remove them using Close monster creater)

Event feelings vengeful
66 - Invisible Town Hero feelings vengeful 20
67 - Cambridge Village feelings vengeful 20
68 - Bamboo Village feelings vengeful 20
69 - Walled Fortress feelings vengeful 20
70 - Ancient Entreance feelings vengeful 20
71 - South Fortress feelings vengeful psychological level of 20
72 - Ground Logging feelings vengeful 20
73 - around the city feeling vengeful 20
74 - Barbarian Village feelings vengeful 20
75 - Mirror Lake feelings vengeful 40
76 - orchis Sereene level of feelings vengeful 40
77 - Allied army camp level feelings vengeful 40
78 - Fishing village level feelings vengeful 40
79 - clan haste level feelings vengeful 50
80 - Town Forward wind feelings vengeful 50
81 - Camp Sumor level of feelings vengeful 50
82 - Sundown Town level feelings vengeful 50
83 - City-level feelings come vengeful 50
84 - Arrow Manor level will intensify feelings vengeful 70
85 - City-level feelings of unhappiness vengeful 70
86 - Fangs Town level feelings vengeful 70
87 - Dreaming Cloud Village level feelings vengeful 70
88 - Whetstone Stronghold level feelings vengeful 70
89 - Village of Lost feelings vengeful level 90 flying
90 - Sanctuary of the city of senses vengeful of 90 flying
91 - Nottingham Village vengeful feelings of 90 flying
92 - despite the beauty village level feelings vengeful 90
93 - Fire Bathing Village level feelings vengeful 90
94 - South City Screen sensory level vengeful 90
95 - East City Screen level of feelings vengeful 90
96 - North City Screen sensory level vengeful 90
97 - Expeditionary camp level feelings vengeful 100
98 - Snowswept Village-level feelings vengeful 100
99 - Shattered ice level feelings vengeful 100
100 - Avalanche 100 senses vengeful

ADC invasion events
109 - Start final ADC invasion wave (When bosses kill his success onwars to wave 1, and if the owners were aggroed dont they disappear when the event is closed)
110 - ADC start of the invasion wave 1
111 - the invasion ADC Wave 2
112 - ADC start of the invasion wave 3
113 - beginning of the invasion wave ADC 4
114 - ADC invasion last boss outside the ADC North
117 - ADC invasion last boss outside the ADC North
118 - ADC invasion last boss outside the ADC West
119 - ADC invasion last boss outside the ADC South
120 - ADC invasion last boss outside the ADC South
121 - ADC invasion last Bosse leader north ADC
125 - NON-AGGRO Boss inside the walls of the north gate of ADC
126 - General and desperate line of guards for the ADC. Useful for ADC if the invasion

New Events
127 - New Year lanterns (lamps) in most buildings, and 20 lantern NPCs (New Year's Riddle lamps) in the center of ADC, there are no quests
128 - New Year Boss for ADC West, North and South, which drops fireworks, a mirage, Eng Bao (10-50 kb gives gold) and we congratulate the trait that gives the system the announcement "The player wants all players in a perfect world a happy and prosperous China New Year! "Besides, adds a" Christmas gift Peddlery "NPC which sells gift items (without the use / benefit of the unknown so far)

Other
134 - puts the fields around the teleporters in Ethersword, disappeared and feathers

Credits by Google. =)

Good topic but what's the use the Ctrl J? nothing appears when I use this command

[stoni]

ok...hmmmmm. Im not sure if that quite answers what i was asking. What im trying to do is figure out the server calls....the GM console requires a client to be active. I am trying to run events automaticly WITHOUT the GM console. I would like to do this from the server NOT a client computer. Any help is greatly appreciated, but all of that except adding a GM or cubi is on that guide. The rest is GM or DEBUG console commands, which are client side not server side. Thank you in advance.

[Kripter]

welll u can have it set as a quest that starts it every so often. but only a gm can get to the quest so u can have it set for certain times of the day. btw great guide and commands. its helped me a ton with placeing looking and just about any thing i needed as gm and or not gm on my server.

[rbb138]

thread necro'd

theres a way u can make a jsp page to activate it i think, then run this in cron using lynx.

[Teemo Cell]

hmmm...i cant open the debug console with CTRL-J why?My version is 1.4.5.

[shard1976]

how do i reset an accounts cubi total usages, purchases etc as i seem to have maxed mine in a few accounts on my server and am unable to assign any more cubi/gold to those accounts.

[343]

how do i reset an accounts cubi total usages, purchases etc as i seem to have maxed mine in a few accounts on my server and am unable to assign any more cubi/gold to those accounts.

As far as I know, this is stored in the gameDB and not MySQL (so, since we cannot edit the gameDB directly at this time, it cannot be done)... ... ...

[[D@nte]]

Arithmetics isn't that hard...

For wipeing it to 0:
call usecash (userid1, zoneid1, sn1, aid1, point1, (PurchasedGold - UsedGold) * -1, status1 , @error)

For lowering it:
call usecash (userid1, zoneid1, sn1, aid1, point1, AmountToRemove * -1, status1 , @error)