|
You last visited: Today at 21:56
Advertisement
[HELP]Auto Reborn System
Discussion on [HELP]Auto Reborn System within the Dekaron Private Server forum part of the Dekaron category.
05/24/2009, 07:51
|
#1
|
elite*gold: 0 
Join Date: May 2008
Posts: 238
Received Thanks: 8
|
[HELP]Auto Reborn System
Hello All ..
Can Some One Tell Me And Teach Me
How To Create An Auto Reborn System ???
Thank You
|
|
|
|
05/24/2009, 08:39
|
#2
|
elite*gold: 0
Join Date: Dec 2008
Posts: 436
Received Thanks: 54
|
no1 want help for u
|
|
|
|
|
05/24/2009, 08:57
|
#3
|
elite*gold: 0
Join Date: Mar 2008
Posts: 138
Received Thanks: 26
|
put some gasoline and use zippo 7520 to burn it up.
|
|
|
|
|
05/24/2009, 12:11
|
#4
|
elite*gold: 0
Join Date: May 2008
Posts: 238
Received Thanks: 8
|
some one help ???
plz
|
|
|
|
|
05/24/2009, 18:02
|
#5
|
elite*gold: 0
Join Date: Dec 2008
Posts: 928
Received Thanks: 132
|
heres the second thread
|
|
|
|
|
05/24/2009, 19:07
|
#6
|
elite*gold: 0
Join Date: Mar 2008
Posts: 94
Received Thanks: 11
|
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;] |
|
|
|
|
|
05/24/2009, 23:55
|
#7
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,854
Received Thanks: 1,891
|
Reset Loginflag
Code:
UPDATE dbo.user_profile
SET login_flag = 0,
WHERE (login_flag0 = 1100);
|
|
|
|
|
05/25/2009, 03:43
|
#8
|
elite*gold: 0
Join Date: Mar 2008
Posts: 94
Received Thanks: 11
|
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?
|
|
|
|
|
05/25/2009, 10:23
|
#9
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,854
Received Thanks: 1,891
|
************************************************** **********************
*********************** 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 !
|
|
|
|
|
05/25/2009, 19:31
|
#10
|
elite*gold: 0
Join Date: Aug 2008
Posts: 223
Received Thanks: 39
|
ty janvier 
|
|
|
|
|
05/26/2009, 11:43
|
#11
|
elite*gold: 0
Join Date: May 2008
Posts: 238
Received Thanks: 8
|
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 ?
|
|
|
|
|
06/27/2009, 13:57
|
#12
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,854
Received Thanks: 1,891
|
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)
|
|
|
|
|
06/27/2009, 23:43
|
#13
|
elite*gold: 0
Join Date: Jan 2009
Posts: 106
Received Thanks: 10
|
I have customised FsG's reborns so many times over. It's not too hard. And you should check the stickies before posting.
|
|
|
|
|
06/28/2009, 01:33
|
#14
|
elite*gold: 0
Join Date: Nov 2008
Posts: 784
Received Thanks: 339
|
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 
|
|
|
|
|
06/28/2009, 01:59
|
#15
|
elite*gold: 0
Join Date: Jan 2009
Posts: 106
Received Thanks: 10
|
Whats the login flag for? I made my version of the query and didnt need it what so ever.
|
|
|
|
 |
|
Similar Threads
|
reborn system for dekaron
03/18/2025 - Dekaron Private Server - 5 Replies
hi pls help me with reborn system for dekaron...
i wanna make a pserv (don't worry i wanna play only me and some friends from schools).who have this system pls add my id: [email protected].
:handsdown::handsdown:pls help me:handsdown::handsdown:
THANK YOU VERY MUCH!:)
|
which reborn system is better?
12/07/2012 - Dekaron Private Server - 18 Replies
1. resets lvl to 1, resets stats,skills to original, and add +250 stats multiplied by reborn no.
2. resets lvl to 1, resets skills to original and REMAIN stats.
which one people prefer and why?
|
[Help]Reborn system
12/20/2009 - Dekaron Private Server - 8 Replies
Trane Please delete my topic.
reason users do not have the right to post it because it is a funny and say that and double post.
|
[Help]Reborn System
08/05/2009 - Dekaron Private Server - 1 Replies
http://img35.imageshack.us/img35/281/semttulogos.j pg
Hi all im having this error and my characters not reborning(lv205 reborn)
please a sollution xD
|
[New]Reborn System
08/31/2008 - EO PServer Hosting - 1 Replies
Hey ALL e*pvp Members im working on a new Reborn System and it will be kinda Hard because it will be a Great Quest beside its my first Custom Quest :D I will be letting pics here etc and will either Realse it if i got some thanks or only keep it for me and the people who will help me with :P I Promise nothing
|
All times are GMT +1. The time now is 21:59.
|
|
![[HELP]Auto Reborn System](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/help-auto-reborn-system_ltr.gif){kind=small}
