[HELP]Auto Reborn System

~~lelothebest~~ · 05/24/2009, 07:51

Hello All ..
Can Some One Tell Me And Teach Me
How To Create An Auto Reborn System ???

Thank You

DawnofwaR · 05/24/2009, 08:39

no1 want help for u

bellydaniel · 05/24/2009, 08:57

put some gasoline and use zippo 7520 to burn it up.

~~lelothebest~~ · 05/24/2009, 12:11

some one help ???
plz

~~ex6tenCe~~ · 05/24/2009, 18:02

heres the second thread

kenshin-x · 05/24/2009, 19:07

Diatas cupu, rights?

Quote:

Originally Posted by lolpol

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;]

janvier123 · 05/24/2009, 23:55

Reset Loginflag

Code:

UPDATE dbo.user_profile
SET login_flag = 0, 
WHERE (login_flag0 = 1100);

kenshin-x · 05/25/2009, 03:43

Quote:
Originally Posted by janvier123
Reset Loginflag
Code:
UPDATE dbo.user_profile
SET login_flag = 0, 
WHERE (login_flag0 = 1100);

Sorry what action that code?

janvier123 · 05/25/2009, 10:23

************************************************** **********************
*********************** DK Reborn System ***********************
************************************************** **********************

@ Written by: lolpol
@ Modifyd by: Janvier123

************************************************** **********************
*********************** 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

Have fun !

skulkerman32 · 05/25/2009, 19:31

ty janvier

~~lelothebest~~ · 05/26/2009, 11:43

hey dude .. i tried this way and i got GMS reborn when they get 200+
but now i have character create error . 600,400
*only when i choose loa castle .
*braiken castle working good .
any help plz ?

janvier123 · 06/27/2009, 13:57

i got somehow a auto reborn system
i dont have a php script but players have to reset all there skills themself
this script does more then just standard reborn
if someone has a php script, can you share it plz ?
thx

The basic Idea:

Once you lvl 170 go to the Skill master
Take off all your armor, pots, weapons, ...etc
Ask for the skillmaster for a SKILL RESET
this will wipe are your skills
Logg out and wait 120sec (2min)
When you log back in all your skills are gone and you can do this over and over again

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 = + 5, bySkillClearCount = 0, byStatClearCount = 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 = + 5, bySkillClearCount = 0, byStatClearCount = 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 = + 5, bySkillClearCount = 0, byStatClearCount = 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 = + 5, bySkillClearCount = 0, byStatClearCount = 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 = + 5, bySkillClearCount = 0, byStatClearCount = 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 = + 5, bySkillClearCount = 0, byStatClearCount = 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 = + 5, bySkillClearCount = 0, byStatClearCount = 0
WHERE (byPCClass = 6) AND (wlevel = 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

It gives you +5 skillpoints
Wont make GM's over lvl 170 reborn (but players with lvl 171 wont be reborn
Resets the skillmasters 1 time skillreset
Resets the statmaster 1 time statsreset (Kata in parca)

!Haroon! · 06/27/2009, 23:43

I have customised FsG's reborns so many times over. It's not too hard. And you should check the stickies before posting.

ItsNobody · 06/28/2009, 01:33

Quote:
Originally Posted by janvier123
************************************************** **********************
*********************** DK Reborn System ***********************
************************************************** **********************

@ Written by: lolpol
@ Modifyd by: Janvier123

************************************************** **********************
*********************** 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

Have fun !

Funny thing is..that script is so long..you have to do jobs etc etc...i wrote one that just ties into it and reborns on relog

!Haroon! · 06/28/2009, 01:59

Whats the login flag for? I made my version of the query and didnt need it what so ever.