Anyone can help me?

[yepee22]

I need some help in making Reborn system level 250

and Vote fo coins.

i need some video tutorial.

any can make?

because i already follow the tut of javier123 but i got fail i got error's.

BIG THANKS!

[Ultimo ☼]

Originally Posted by yepee22

I need some help in making Reborn system

Dude... Use the search button next time.

************************************************************************
***********************     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_flag = 1100);
18)    Make a job for this also (see step 12)
19)    Start All Jobs

Edit it, to be just as you want it.

Credits to Janvier.

[janvier123]

Credits to me, cuz i wrote it
you even copied my mistakes ....

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

should be

UPDATE dbo.user_profile
SET login_flag = 0, 
WHERE (login_flag = 1100);
18)    Make a job for this also (see step 12)
19)    Start All Jobs

[zombikk]

can somebody make a video tut

[Ultimo ☼]

Originally Posted by janvier123

Credits to me, cuz i wrote it
you even copied my mistakes ....

Ah sorry janvier, i just copied it from trane's thread.

I've edited my first reply to correct that mistake and i've also changed credits.

[yepee22]

If they reborn, its unlimited reborn?

i want 3 reborn only.

how i can change it.?

[janvier123]

Originally Posted by Ultimo ☼

Ah sorry janvier, i just copied it from trane's thread.

I've edited my first reply to correct that mistake and i've also changed credits.

np

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 < 3);