SQL help

[mofo]

I'd like to ask our resident sql experts for a query/code to alter the table for characters level 151-160. I want to change them back to 150. And if possible include the syntax to change all stats and skills to 0. Please help, thanks in advance Hercules.

 

[jimboy09232]

go to db pre/re exp.txt change 

//================================
// Renewal content (required for some core features)
//================================
 
//Base - 3rd Jobs, Baby 3rds, Expanded Super Novice, and Kagerou/Oboro
//Note: (First 98 values [Level 1 - 98] are dummy values (used Adv Jobs values), because 3rd classes start at level 99.)
99,4054:4055:4056:4057:4058:4059:4060:4061:4062:4063:4064:4065:4066:4067:4068:4069:4070:4071:4072:4073:4074:4075:4076:4077:4078:4079:4080:4081:4082:4083:4084:4085:4
lvl, jobs:jobs:jobs:jobs:jobs:jobs:jobs:jobs and so on after that exp
example change to:
 
150,99,4054:4055:4056:4057:4058:4059:4060:4061:4062:4063:4064:4065:4066:4067:4068:4069:4070:4071:4072:4073:4074:4075:4076:4077:4078:4079:4080:4081:4082:4083:4084:4085:4
 
this is just an example so don't copy the txt ....
if u don't need this just ignore it.. just want to help you.. 

 

[Patskie]

I'd like to ask our resident sql experts for a query/code to alter the table for characters level 151-160. I want to change them back to 150. And if possible include the syntax to change all stats and skills to 0. Please help, thanks in advance Hercules.

To make it more simple, why not use a script to check? instead of doing query commands you can do something like this :

if (BaseLevel >= 151 || BaseLevel <= 160) {	BaseLevel = 150;	resetstatus;	resetskill;}