downgrade character

[tjungz212]

Hi all Help Me plss

How to update sql for all player

Update reset status

Update reset skill

Update downgrade level & job level

An d gift status point & skill point

My server lv 255/120

Downgrade to Lv 150/70 & gift status point & skill point & allstats 1

I can change all for my user

Help me plss

[Emistry]

you can try refer this site..

http://www.w3schools.com/sql/sql_update.asp

write your sql command that edit the data in char table....and run it in your sql machines.

[tjungz212]

Example :

UPDATE char

SET base_level='150', job_level='70', str='1', agi='1', vit='1', int='1', dex='1', luk='1', status_point='1', skill_point='1'

Please check whether the update in sql this is true or false, plss Help Me sir emistry

Edited November 11, 2012 by tjungz212

[GmOcean]

You know, you don't need other people to test it for you... just try running it in your sql, and if its correct, it'll run and finish, if it's not, it will show you an error, and nothing will change.