Code:
************************************************************************ *********************** Server Side Setup *********************** ************************************************************************ 1) Open/start: "Query Analyzer" 2) Login with your Login Name and password 3) Copy and paste the following line: Code: USE [character]; GO ALTER TABLE [user_character] ADD [Reborn] [smallint] DEFAULT(0) NOT NULL; 4) Press "Parse Query (ctrl + F5) and press Execute Query (F5) 5) Copy and past the following lines: Code: USE [character]; GO 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); 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 = 1) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50); 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 = 2) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50); 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 = 3) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50); 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 = 4) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50); 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 = 5) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50); 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 = 6) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50); 6) Press "Parse Query (ctrl + F5) and press Execute Query (F5) This will make all lvl 170 players reborn NOTE: Gm's with lvl 200+ will also be reborn! Note: That "WHERE (byPCClass = 6)" is the class, so 1 line for every class 7) Close: "Query Analyzer" 8) Start: "SQL Server Agent" (can be found in the taskbar or start menu) 9) Open/start: "Enterprise Manager" 10) Go to: Console Root/Microsoft SQL Servers/SQL Server Group/(local) (Windows NT)/Managemnt/SQL Server Agent/Jobs 11) Right click in the right windows "New Job" 12) In tab "General" look for "Name:" enter "reborn" of what ever you like In tab "Steps" click "new" "Step name:" enter "Class0" "Type:" select: "Transact-SQL Script (TSQL)" "Database:" select: "character" "Command:" Enter the following line: Code: 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); Press "Apply" then "ok" Repeat step: 12 WARNING: DONT FORGET TO CHANGE "WHERE (byPCClass = 0)" FOR EACH CLASS!!! You should have 1 step for every class, if you dont it ok 13) In tab "Schedules" click "New Schedule" 14) "name:" enter "run" of what ever you want "Schedule Type" select "Recurring" Click "Change" and enter the following: Occurs: Daily Daily: Every 1 Day(s) Daily Frequency: Occurs Every: 1 Minute(s) Starting at: 0:00:00 Ending at: 23:59:59 Durdation: (today's date) No end Date 15) Press "Ok" and "Apply" when asked" This will make all classes reborn every 1 Minute(s) IF! Lvl 170+ IF! 50.000.000 Dill IF! Reborns less then 50 times 16) Open/start: "Query Analyzer" 17) Copy and past the following line: Code: USE [account]; GO UPDATE dbo.user_profile SET login_flag = 0, WHERE (login_flag0 = 1100); 18) Make a job for this also (see step 12) 19) Start All Jobs
but after the 2nd reborn rebon + 4 = 5 = 1250 reborn poitn
pls tell me why?