Nyc Mu Auto scripts + Guide on how to use them.

[xphire]

Okay, i thought that i should make a guide on how to get a fast auto reset,auto pk reset, and auto stat fix and a few other things. This script is perfect for high rate servers. This script has Auto reset at 400,Auto pk reset,Auto stat fix, Auto money fix, and you get 1billion zen if you have less then 1bill zen. These scripts get executed right away after u go to the switch character menu. No waiting 1minite like sql jobs :)
Tutorial:
1)Go to start -> All programs -> Microsoft SQL Server -> Query Analyzer
Screenshot
2)When you click it, in the little box, for server type "(Local)" And tick windows authentication
Screenshot
3)Copy and paste this script into the text field

--Auto Reset
CREATE TRIGGER Auto_Reset
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [cLevel]=1, [Resets]=[Resets]+1,[Reset]=[Reset]+1,[Experience]=0
WHERE [cLevel]=400
Go

--Auto Pk Reset
CREATE TRIGGER Auto_Pk_Reset
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [PkLevel] = 2
WHERE [PkLevel] > 2
Go

--Auto Money Fix
CREATE TRIGGER Auto_Money_Fix
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [Money] = 1000000000
WHERE [Money]>2000000000
Go

--Auto free 1bill
CREATE TRIGGER Auto_Give_1bill
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [Money] = 1000000000
WHERE [Money]<1000000000
Go

--Auto str stat fix
CREATE TRIGGER Auto_Str_Fix
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [strength] = 32767
WHERE [strength]>32767
Go

--Auto agi stat fix
CREATE TRIGGER Auto_Agi_Fix
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET Dexterity = 32767
WHERE Dexterity>32767

--Auto vit stat fix
CREATE TRIGGER Auto_Vit_Fix
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET vitality = 32767
WHERE vitality>32767

--Auto ene stat fix
CREATE TRIGGER Auto_Ene_Fix
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET energy = 32767
WHERE energy>32767

Screenshot

4)Click on the little drop down tab and select the MuOnline database.
Screenshot

5)Press the little green play button and you are done :)
Screenshot

Now you can exit SQL Query Analyzer, and when you get the popup do you wnat to save changes, press no :)

If you want to delete these scripts from your database, just run this in query analyzer:

Use MuOnline
drop trigger Auto_Reset
drop trigger Auto_Pk_Reset
drop trigger Auto_Money_Fx
drop trigger Auto_Give_1bill
drop trigger Auto_str_fix
drop trigger Auto_agi_fix
drop trigger Auto_vit_Fix
drop trigger Auto_ene_fix
GO

Enjoy.

[MentaL]

[themad]

CREATE TRIGGER Auto_Reset
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [cLevel]=1, [Resets]=[Resets]+1,[Reset]=[Reset]+1
WHERE [cLevel]=400


err....I suggest you don't use this .. The dataservers update the character level when its still online (real time), however if you update the character level through the database it will not be updated in the gameserver, therefor it will continue adding resets. Even if the max level is 400 and the character can no longer receive experience the gameserver updates his data on periods, so he'll gain resets staying afk....same goes for all ur scripts ..

[xphire]

its not working :S..

Forgot to add a part to the tutorial, fixed :)

[o0nvt0o]

great release xphire!

[Disconnect1]

CREATE TRIGGER Auto_Reset
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [cLevel]=1, [Resets]=[Resets]+1,[Reset]=[Reset]+1,[Experience]=0
WHERE [cLevel]=400
Go

CREATE TRIGGER Auto_Reset
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [cLevel]=1, [Resets]=[Resets]+1,[Reset]=[Reset]+1
WHERE [cLevel]=400

Wichy one is the best ?

[xphire]

Wichy one is the best ?

Mine is actually. What he copyed and pasted was just the first time i posted my scripts where i forgot to add experience = 0 -_-

[Disconnect1]

Ok, thx...

[DestructiO]

some of the scripts are helpful good work 7/10

[=Ady=]

and how can i disable this scripts?

[themad]

Wichy one is the best ?

Neither ... as i already said the database update does not effect online characters, they will eventually overwrite that data w/o overwriting the resets... it was just a quote..

[=Ady=]

works on 99.88T with no bugs?

[GhostOne]

7/10

[=Ady=]

damn this scripts fk the database...
how can i disable them now ???

[esperanza]

damn this scripts fk the database...
how can i disable them now ???

re make your server xD

[Hummel]

very good man!