[HELP]where i should UP VIP lvl in navicat?

[GosZ]

i want up my VIP lvl in my server..where i should setting?

[Eurion]

Its in your account table, look for either VIP or Vip. Typical levels would be 1-7

[GosZ]

Tq Eurion..

[GosZ]

i want to take VIP lvl 7 and take effect to my body..

[CyberServer]

what your means effect on your body lol vip lev 7 just vip lev7 i dont know if have some effect

[GosZ]

my friends server..he is GM..GM only VIP lvl 7..but his body has take effect..pink bubble..

[disasterzoner]

Originally Posted by GosZ

my friends server..he is GM..GM only VIP lvl 7..but his body has take effect..pink bubble..

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

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:
open Navicat -> my -> Queries -> new table -> than paste the code below...make sure put your ID from cq_User and the effect you want in your charracter... then click run

Code:
INSERT INTO `cq_special_status` (`user_id`, `status_id`, `power`, `finish_time`) VALUES ('id-from-cq_user', 'statusid(exm.156)', '0', '900000')