- Joined
- Aug 1, 2006
- Messages
- 357
- Reaction score
- 68
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
2)When you click it, in the little box, for server type "(Local)" And tick windows authentication
3)Copy and paste this script into the text field
4)Click on the little drop down tab and select the MuOnline database.
5)Press the little green play button and you are done
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:
Enjoy.
Tutorial:
1)Go to start -> All programs -> Microsoft SQL Server -> Query Analyzer
2)When you click it, in the little box, for server type "(Local)" And tick windows authentication
3)Copy and paste this script into the text field
Code:
--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
4)Click on the little drop down tab and select the MuOnline database.
5)Press the little green play button and you are done
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:
Code:
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.
Last edited: