Best Auto Reset for Your server.

[IAmMe]

it's fast easy and best way to do autoreset at ur server :).
Let's Start,
go to Start->Programs->Microsoft SQL Server->Query Analyzer->press "oK"
Change At the Top "master" to "MuOnline"
Here's a Picture::
After that write that:
Picture:

CREATE TRIGGER trigger_name_350_1
ON [MuOnline].[dbo].[Character]
FOR UPDATE AS
UPDATE [MuOnline].[dbo].[Character]
SET [cLevel]=1
WHERE [cLevel]=350
GO

picture:
and press on the top on "Green play button" or "f5"
Thats all :), now close ur query,it will ask youif you wanttosave changes or not, select "NO!"
dun save anychanged if u press f5 it saves auto and u have the auto reset, dun need to save then ur quiting the program(query) :).
Sry for my bad english.

[MentaL]

[quzopl]

this autoreset is too simple , its only reseting to lvl 1 no stats reset no cost reset but good idea to make a reset as trigger not job

[IAmMe]

it's how i was always making it at my server, also u can do select server and log after 10 seconds and the reset is ready :).

[pezaobr]

trigger? no memberstats cheking? its not a good script.

use sql agent.

[Josh]

Not the best, lol. It just makes it lvl 1, thats all :P.

[AsterisKSM]

This is Very Old Thing...

[Troubleextreme]

It comes out whit this error when i try too Parse my text.

and here is what i try too add.
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 48) OR (class = 64)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
PLZ any help will be welcome.

[Troubleextreme]

thx for no help at all.:eh:

[-=LaMeR=-]

How To Stop This Shit ?
I Start It But Now All Chars Is ! Lvl And I Cant Do Anything !

[themad]

How To Stop This Shit ?
I Start It But Now All Chars Is ! Lvl And I Cant Do Anything !

DROP TRIGGER trigger_name_350_1;

[SHANG]

I can say, this is not good auto reset, this is simple auto reset.
I tested that script, but ppls know bugs to make alot of resets.
use Auto reset Generator to create script :)

[blow^^]

It comes out whit this error when i try too Parse my text.

and here is what i try too add.
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 16) OR (class = 17)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 32) OR (class = 33)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (10000000 * (Reset + 1)), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 48) OR (class = 64)) AND (clevel >= 350) AND (Money >= (10000000 * (Reset + 1))) AND (ConnectStat = 0) AND (ctlcode < 8);
PLZ any help will be welcome.

Omg! It is obviously your ''Script'' can`t find Column name ''Reset'' in your db.

[ggameboss]

Tnx man.

[FT1FT1]

Listen People
The main problem on doing autoreset using a trigger is this: Gameserver doesn't read stats from database during gameplay, it only read data once at character login, after that it only write to DB and it consider his own version of the data the most secure and uptodate so, if you character reach level 350 the trigger will move him to level one, but, after any stat or inventory change, DB data will be overwrite by gameserver with online version so your trigger will only change 3rd party character who was at level 350 and loged off.

I will give you my way to doit:
1.- Create a stored procedure with your autoreset code, full of detail, zen priced, stat and inventory moded and add all your flavors of pain and gain to it. Stored procedure template is:

CREATE PROCEDURE dbo.RESET
@char varchar(10)
as
begin

end
go

2.- Add a call to that procedure on WZ_DISCONNECT_MEMB like this:

EXECUTE dbo.RESET @uid

This will make accounts auto-reset on disconnect, so, character with correct experience, level, zen or what ever you want for reset price will reset with no user, website or GM furter actions needed.

This is for skilled people who need a short push, I'll no write full procedure here since every one have a different criteria on reset.

Enjoy

[superman007]

Nice
but how can i get 400 points per each reset

[eladlevy5]

No!
Dont Do That Script!
Its Make Problems In Db!
Its Not A Good Script!
Warrning!!!!