[GUIDE] Setting Status Effects, exm. Pkmatch_champion

11/12/2009 07:34 cruey#1
You might be wondering how you set yourself to have the champion effect on yourself. This will explain how to do it:

1 ) Open Navicate and go into your 'my' database, then open your cq_user & cq_special_status tables.

2 ) The cq_special_status table is made up of 4 columns. user_id is for the connection to the id column under your cq_user table. status_id is for the connection to the effectID. Power i'm not sure about yet, but I assume it has something to do with traps. finish_time assumed, is the amount of time left (in seconds) with the effect.

Go into your cq_user table and find the character name you want the effect on. Then scroll across to the id column and copy the entry with 'ctrl+c'

3 ) Paste your entry into the user_id column of cq_special_staus table.

4 ) Set status_id to 156, keep power as 0 and finish time to any number higher than 0 (try like 500000).

5 ) Relogin into the game and you have your effect.

[Only registered and activated users can see links. Click Here To Register...]

Extra: I have changed the status_id to others to test them and found some other IDs, here is a list:
154 - Cursed effect
155 – Top Effect
156 – Champion Effect
174 – Polymorph
24 – Strange thing
17 – Sneak
14 – Invisible
15 –Trap Effect

You can also use the following query to do what you want with status effects:
Quote:
INSERT INTO `cq_special_status` (`user_id`, `status_id`, `power`, `finish_time`) VALUES ('id-from-cq_user', 'statusid(exm.156)', '0', '900000')
Have fun and remember to post your questions if you need answers.
Brought to you by Devils-Advocate Online!
[Only registered and activated users can see links. Click Here To Register...]
11/12/2009 07:46 ~Dark-Warrior~#2
aww thats REALLY Help !!
thnx
11/12/2009 19:09 magewarior2#3
good job, ceep that kind of releases
11/12/2009 23:26 cruey#4
It's a release? I thought it was a guide. O____O
11/13/2009 19:00 magewarior2#5
Quote:
Originally Posted by cruey View Post
It's a release? I thought it was a guide. O____O
guide are also released, so this is a release :bandit:
11/14/2009 00:41 cruey#6
Oh okay, well thanks i'll keep that in mind for next time.
11/17/2009 12:37 I Am Murtah#7
Nice one Crue, Coolies ^_^
05/21/2010 13:33 AziQ#8
Quote:
Originally Posted by cruey View Post
You might be wondering how you set yourself to have the champion effect on yourself. This will explain how to do it:

1 ) Open Navicate and go into your 'my' database, then open your cq_user & cq_special_status tables.

2 ) The cq_special_status table is made up of 4 columns. user_id is for the connection to the id column under your cq_user table. status_id is for the connection to the effectID. Power i'm not sure about yet, but I assume it has something to do with traps. finish_time assumed, is the amount of time left (in seconds) with the effect.

Go into your cq_user table and find the character name you want the effect on. Then scroll across to the id column and copy the entry with 'ctrl+c'

3 ) Paste your entry into the user_id column of cq_special_staus table.

4 ) Set status_id to 156, keep power as 0 and finish time to any number higher than 0 (try like 500000).

5 ) Relogin into the game and you have your effect.

[Only registered and activated users can see links. Click Here To Register...]

Extra: I have changed the status_id to others to test them and found some other IDs, here is a list:
154 - Cursed effect
155 – Top Effect
156 – Champion Effect
174 – Polymorph
24 – Strange thing
17 – Sneak
14 – Invisible
15 –Trap Effect

You can also use the following query to do what you want with status effects:


Have fun and remember to post your questions if you need answers.
Brought to you by Devils-Advocate Online!
[Only registered and activated users can see links. Click Here To Register...]
thx bro .how about springpowder id's .?u know that .?
06/22/2010 00:04 Elizier#9
Ok, I know its a somewhat old topic but it was just given to me and I tried it cause I like it...

and its not working... >.<

I tried the query and manual input...


'4000' '1******0' '156' '0' '4294967295'

Did I mis input something???
\/.\/
06/22/2010 16:58 PraDevil[ELITE]#10
whats about u check my signature..i think i was release effect seller there:)
06/23/2010 13:39 OwnerBI#11
Thx ^^
08/06/2011 06:23 iGoz#12
not working :(
09/10/2012 15:00 wumega#13
Quote:
Originally Posted by cruey View Post
You might be wondering how you set yourself to have the champion effect on yourself. This will explain how to do it:

1 ) Open Navicate and go into your 'my' database, then open your cq_user & cq_special_status tables.

2 ) The cq_special_status table is made up of 4 columns. user_id is for the connection to the id column under your cq_user table. status_id is for the connection to the effectID. Power i'm not sure about yet, but I assume it has something to do with traps. finish_time assumed, is the amount of time left (in seconds) with the effect.

Go into your cq_user table and find the character name you want the effect on. Then scroll across to the id column and copy the entry with 'ctrl+c'

3 ) Paste your entry into the user_id column of cq_special_staus table.

4 ) Set status_id to 156, keep power as 0 and finish time to any number higher than 0 (try like 500000).

5 ) Relogin into the game and you have your effect.

[Only registered and activated users can see links. Click Here To Register...]

Extra: I have changed the status_id to others to test them and found some other IDs, here is a list:
154 - Cursed effect
155 – Top Effect
156 – Champion Effect
174 – Polymorph
24 – Strange thing
17 – Sneak
14 – Invisible
15 –Trap Effect

You can also use the following query to do what you want with status effects:


Have fun and remember to post your questions if you need answers.
Brought to you by Devils-Advocate Online!
[Only registered and activated users can see links. Click Here To Register...]
154 - Cursed effect
155 – Top Effect
156 – Champion Effect
174 – Polymorph
24 – Strange thing
17 – Sneak
14 – Invisible
15 –Trap Effect

can i know whre to got number?
09/20/2014 06:30 Dragon(H)ell#14
How did you know that ids
154 - Cursed effect
155 – Top Effect
156 – Champion Effect
174 – Polymorph
24 – Strange thing
17 – Sneak
14 – Invisible
15 –Trap Effect
??
and how to add a new one ?