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

Printable View

17-05-09
segredu

2 Attachment(s)

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

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

Code:

call addGM (32 , 1)

ADD 10.000 CUBI-COIN

Code:

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

Good Luck :thumbup:

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. =)
18-05-09
evilgenx

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

Very nice. Everything works fantastic!

+5.
19-05-09
michae5k

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

hmm when i press CTRL J no console comes up hmm...
19-05-09
segredu

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

Quote:

Originally Posted by michae5k

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 ?
:?:
16-07-09
neuzaty

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

Quote:

Originally Posted by segredu

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

how to make debug mode aktiv ??
29-07-09
hihihihuhuuu

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

And how can I delete GM rights from account?
29-07-09
Wizatek

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

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

elementclient.exe game:cpw console:1
01-08-09
Dragganta

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

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???
01-08-09
Romulan

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

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. ^^
28-09-09
stoni

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

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
30-09-09
Allvis

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

Quote:

Originally Posted by 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

Code:

call addGM (32 , 1)

ADD 10.000 CUBI-COIN

Code:

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

Good Luck :thumbup:

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 :grr::grr:
05-10-09
stoni

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

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.
13-08-10
Kripter

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

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. :thumbup:
13-08-10
rbb138

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

thread necro'd

theres a way u can make a jsp page to activate it i think, then run this in cron using lynx.
16-11-12
Teemo Cell

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

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

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

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.
17-02-13
343

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

Quote:

Originally Posted by 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.

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)... ... ...
19-02-13
[D@nte]

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

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)