Query to reset skill/stat points?

[johnbond]

May I request a sql query that would reset all skill points and status points of all Lord Knights (#4008) in the server but still giving them back what should be the set skills points and stat points.

 

Thank you guys!

[Chaos92]

up, i want to reset all players, if anyone can help ?

using sql is great !

*i want to reset all character to their original status point, not remove it

[johnbond]

Well I just used a NPC for this.

 

Thanks.

[Emistry]

TRUNCATE `skill`;

UPDATE `char` SET `str` = 5,`agi` = 5,`vit` = 5,`int` = 5,`dex` = 5,`luk` = 5,`status_point` = 0,`skill_point` = 0;

some basic way that you can try.

[Chaos92]

TRUNCATE `skill`;

UPDATE `char` SET `str` = 5,`agi` = 5,`vit` = 5,`int` = 5,`dex` = 5,`luk` = 5,`status_point` = 0,`skill_point` = 0;

some basic way that you can try.

 

i want to reset so they got status point which is 3330 for 3rd job if im not mistaken, that query seems reset to novice stats ? since status point is 0

[Capuche]

If you use prere load [paste=cks0m5eejyj] and execute

update `char` set status_point = ( ( select points from `status_points_prere` where `status_points_prere`.`base_level` = `char`.`base_level` )
+ IF( `class` < 4001 or `class` > 4029 and `class` < 4109 , 48, 100 ) ),
`str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 
where online = 0 and account_id not in ( select account_id from login where group_id >= 60 )

If you use renewal stat, load [paste=79h03exenzoq] and execute

EDIT : [paste=57mh2zxewaph]

update `char` set status_point = ( ( select points from `status_points_re` where `status_points_re`.`base_level` = `char`.`base_level` )
+ IF( `class` < 4001 or `class` > 4029 and `class` < 4109 , 48, 100 ) ),
`str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 
where online = 0 and account_id not in ( select account_id from login where group_id >= 60 )

[Chaos92]

 

If you use prere load [paste=cks0m5eejyj] and execute

update `char` set status_point = ( ( select points from `status_points_prere` where `status_points_prere`.`base_level` = `char`.`base_level` )
+ IF( `class` < 4001 or `class` > 4029 and `class` < 4109 , 48, 100 ) ),
`str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 
where online = 0 and account_id not in ( select account_id from login where group_id >= 60 )

If you use renewal stat, load [paste=79h03exenzoq] and execute

update `char` set status_point = ( ( select points from `status_points_re` where `status_points_re`.`base_level` = `char`.`base_level` )
+ IF( `class` < 4001 or `class` > 4029 and `class` < 4109 , 48, 100 ) ),
`str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 
where online = 0 and account_id not in ( select account_id from login where group_id >= 60 )

this gonna work for all character sir ?

btw, when i @reset , 3rd job status point will be 3330 for level 175.. and as i see at that paste u given for renewal, (175,3265); 

theres a bit different, why sir

Edited September 22, 2014 by Chaos92

[Capuche]

Yes this gonna work for all characters. I don't know why there is a decimal in db stat however char.status_point will convert the entrie to integrer.

 

EDIT I think it's because I used an old stat db

[Chaos92]

Yes this gonna work for all characters. I don't know why there is a decimal in db stat however char.status_point will convert the entrie to integrer.

 

EDIT I think it's because I used an old stat db

can i have the latest sir

[Capuche]

[paste=57mh2zxewaph]

[Chaos92]

[paste=57mh2zxewaph]

work like charm