|
You last visited: Today at 04:57
Advertisement
Reborns on A3 client/server.
Discussion on Reborns on A3 client/server. within the Dekaron Private Server forum part of the Dekaron category.
02/17/2017, 11:06
|
#1
|
elite*gold: 0
Join Date: Sep 2009
Posts: 99
Received Thanks: 11
|
Reborns on A3 client/server.
Is there any chance someone knows how was the automatic reborn (like fussion was) works like? I would be gratefull if you share some knowledge
|
|
|
02/17/2017, 15:43
|
#2
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
use search. i see on forum some topic how to make this.
Quote:
************************************************** **********************
*********************** 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 !
|
|
|
|
02/17/2017, 17:26
|
#3
|
elite*gold: 0
Join Date: Sep 2009
Posts: 99
Received Thanks: 11
|
Thanks mate Im trying to build an a3 client from scraps i find around the internet...i have an old pc that i dont use and it might be enough so me and some friends can enjoy the oldschool brawl
edit: which value should i edit, so after every reborn the characters keep their stats, and only lvl is rerolled.
|
|
|
|
Similar Threads
|
what i cant see the reborns?
09/01/2011 - CO2 Private Server - 7 Replies
hi everyone i have a problem whit reborns 5517+ source look this i have 2 reborns but i cant see it in my character and i cant reborn anymore look this pic
|
B > Reborns !!!
02/25/2010 - Conquer Online 2 Trading - 1 Replies
Buying 3 RBs,
Water - > Warrior
Water - > Archer
Water - > Trojan
Preferred on servers liberty / prosperity
but has to be on ONE server
(not 1 rb on liberty and 2 on prosperity or anything like that)
|
Need Help with pkt/pet reborns....
02/02/2009 - EO PServer Hosting - 0 Replies
1. My Pkt dont let you claim prize at the end. and it says Change Map is Over
2. My Pets says they can be composed 9999 times and it says 2700 in cq_grade so i thought it was in the client some were but i couldent find it so i hope somebody knows.
My Email: [email protected]
Ty to all that do help
|
Selling Reborns On Lightning Server
05/15/2008 - Conquer Online 2 Trading - 3 Replies
c
|
Reborns.
11/18/2005 - Conquer Online 2 - 13 Replies
Firstly, i would like to question this weird idea i had. When i reborn right, there would be a message asking me for what super gems i want. Is it possible to "reverse" that process and that keep getting super gems @.@ Perhaps getting the super gem packet from CO and keep resending them lol..Or the packet you send when you made which super gem you want
|
All times are GMT +2. The time now is 04:57.
|
|