Gerai, stai jums kodas ir pamoka kaip pasidaryti auto reseta per sql.
Sutaiso max status ir nureseta. Tai pat nuresetina ir PK statusa iejus ir isejus i acc po 1 min. Skriptas skirtas noobiskiems servas t.y. su daug exp.
1. Einam All programs -> Microsoft SQL Server -> Query Analyzer
2. Atsiradus nedideliai lenteliai, skiltyje "SQL Server" pasirinkite "Local" ir spauskit OK
3. Atsidarusiame lange pamatysite balta lapa ir ten nukopijuokite sita koda:
--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
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
Atrodys taip:
4. Virsuj tarp ikoneliu bus zalia knopke su play zenkliuku:
Spaudziam ja ir iseinam is sql analyzer'io.
Jusu paklaus "do you wnat to save changes?" spaudzima "no" ir viskas.
P.S. sql koda galite pasiredaguoti palei save t.y. max lvl kiek reseto kaina ir t.t. tik nepersistenkite! ;)
