- Joined
- Apr 13, 2008
- Messages
- 1,244
- Reaction score
- 656
Hmm, here's what i've figured out, the old scripts, which i post here for AutoReset, had that problem: If the character gets the lvl for the reset, and the character is still online, every minute he gets +1 Resets ^^... Well, that is a little stupid 
Here is the better AutoReset Script (for the SQL Server Agent):
In RED are the things u CAN change
More Information:
cLevel -> The Character Level
LevelUpPoint -> Those are the points, which the player can add on the character as Strength, Agility, Vitality, Energy or Command
Money -> That's the amount of zen, and in red i have taged the amount of zen, that u pay for the Reset
MapNumber -> That's the map, in which u spawn, when u reset (when u log in the game again), the numbers are the same, as those, u use for "/gmove", for example i gave "0" = "Lorencia"
MapPosX & MapPosY -> Those are the coordinates in tha map, in which u spawn after the reset, for example i gave "130 122"
The last cLevel -> There, the ">399" means, that u must be over 399 level to reset, so if u change it to 349 for example, u can make the reset from 350 to 400 level (when the players ones to reset)
Don't touch "ConnectStat = 0" , it's from MEMB_STAT table in MuOnline DB, which means, that u have to be offline to make the reset! But sometimes the value stays "1", even if the player is offline! Then:
Delete MEMB_STAT table from MuOnline DB and execute this query in SQL Query Analizer:
Copy-Paste the query in the field and press F5 to execute!
NOTE, THAT THE CODES ARE 100% CORRECT!!! I, ReaL, AM USING THEM!
Credits:
-me ^^ , [DarksTeam]ReaL
Here is the better AutoReset Script (for the SQL Server Agent):
Code:
UPDATE Character
SET cLevel= [COLOR="Red"]1[/COLOR] , Experience = 0 , LevelUpPoint = (LevelUpPoint + [COLOR="Red"][COLOR="Red"]300[/COLOR][/COLOR]) , Resets = (Resets + 1), Money = (Money - [COLOR="Red"]50000000[/COLOR]) , MapNumber = [COLOR="Red"]0[/COLOR] , MapPosX = [COLOR="Red"]130[/COLOR] , MapPosY = [COLOR="Red"]122[/COLOR]
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE cLevel>[COLOR="Red"]399[/COLOR] AND ConnectStat = 0In RED are the things u CAN change
More Information:
cLevel -> The Character Level
LevelUpPoint -> Those are the points, which the player can add on the character as Strength, Agility, Vitality, Energy or Command
Money -> That's the amount of zen, and in red i have taged the amount of zen, that u pay for the Reset
MapNumber -> That's the map, in which u spawn, when u reset (when u log in the game again), the numbers are the same, as those, u use for "/gmove", for example i gave "0" = "Lorencia"
MapPosX & MapPosY -> Those are the coordinates in tha map, in which u spawn after the reset, for example i gave "130 122"
The last cLevel -> There, the ">399" means, that u must be over 399 level to reset, so if u change it to 349 for example, u can make the reset from 350 to 400 level (when the players ones to reset)
Don't touch "ConnectStat = 0" , it's from MEMB_STAT table in MuOnline DB, which means, that u have to be offline to make the reset! But sometimes the value stays "1", even if the player is offline! Then:
Delete MEMB_STAT table from MuOnline DB and execute this query in SQL Query Analizer:
Code:
CREATE TABLE [dbo].[MEMB_STAT] (
[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ConnectStat] [tinyint] NULL ,
[ServerName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[IP] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[ConnectTM] [smalldatetime] NULL ,
[DisConnectTM] [smalldatetime] NULL
) ON [PRIMARY]
GOCopy-Paste the query in the field and press F5 to execute!
NOTE, THAT THE CODES ARE 100% CORRECT!!! I, ReaL, AM USING THEM!
Credits:
-me ^^ , [DarksTeam]ReaL
-
