About Sql

[Limestone]

how can i do, if i change my server's max stats from 300 all stats to 1 all stats. then adding exact stat points for 255 max stats.

another 1 is checking if the character is reached lvl 255, then it will reset the stats. but if the level not reached level 255, it will not reset the stats. thank you

bump?

[Limestone]

how to make all of the players level 1 and reseting their stats to 0? thank you! Level only no Job Level

[Sryx]

UPDATE `char` set base_level = 1, str = 1, agi = 1, vit = 1, dex = 1, luk = 1, `int` = 1, status_point = 0;

[Limestone]

this will update all of the characters level and stats? :3

[Sryx]

Yup.

Base Level = 1
Str = 1
Agi = 1
Vit = 1
Int = 1
Dex = 1
Luk = 1
Status Points = 0

[Neo-Mind]

make sure you do the change while the server is not running

Edited December 27, 2012 by mindstream