Register for your free account! | Forgot your password?

You last visited: Today at 08:41

  • Please register to post and access all features, it's quick, easy and FREE!

 

RB system

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2009
Posts: 193
Received Thanks: 222
RB system

Hi.
Can any one tell me how I can get a rb script.
I want it to do like so :
When you rb, you keep your statt.
And max rb is 7?



lagoni is offline  
Old   #2
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,851
Received Thanks: 1,866
huh ?
wut ?
i cant understand a word you are saying


janvier123 is offline  
Old   #3
 
elite*gold: 0
Join Date: Nov 2010
Posts: 141
Received Thanks: 23
I think he just need's a Reborn system with 7 Reborns and when they reborn they dont lose any stat points. LOL IDFK!
Delerium is offline  
Old   #4
 
elite*gold: 0
Join Date: Oct 2009
Posts: 193
Received Thanks: 222
Edit, sorry for the bad english, yes you are right Delerium.


lagoni is offline  
Old   #5
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,851
Received Thanks: 1,866
************************************************** **********************
*********************** 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

Dont we just love the search function ?
janvier123 is offline  
Old   #6
 
elite*gold: 0
Join Date: Oct 2009
Posts: 193
Received Thanks: 222
I already found that one, but as i can se, then you dont keep your statt like when you rb?
lagoni is offline  
Old   #7
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,851
Received Thanks: 1,866
why you wanna do that ?
their is a limit on what you can use for stat points


janvier123 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Pc-System [Help]
Meine Eltern wollen mir ein pc kaufen :D Aber brache eure hilfe Welches pc gut ist.. Ich habe diesen gefunden. kann man mit desien system...
20 Replies - Technical Support
Pk System
Hmm.. idk why this happening to me... Why the PK isnt like real co ,PK SYSTEM SUCKS! if want to hit some1 with FB/SS i need to click like 3 on his...
0 Replies - CO2 PServer - Discussions / Questions
How to get System.mrs Like how u want?
Could anyone help me i wanna build my own hack just for myself alone and i dont know how to get God Mode or prems so could anyone help me???? I do...
0 Replies - GunZ
system c6
HAve any one a System folder from c6 ( offi) I destroy my lol.. please link
3 Replies - Lineage 2



All times are GMT +1. The time now is 08:41.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.