first u should add a new reborn column in user_character in query analyzer
USE [character];
GO
ALTER TABLE [user_character] ADD [Reborn] [smallint] DEFAULT(0) NOT NULL;
then
add job example for AK (its not full
)
UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 0) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);
its like 50 max reborns on lvl 170 which cost 50kk and add reborn*250stat points, you should add if login_flag = 0 and do something with skills;]