Auto reset with points

1. create a new column in ur tables
2. Name it reset
3. Change the type of the column to navchar
4. Change the default to 1
5. Save it

Then at ur SQL server agent
1. Create a new job
2. Add this commands to it

UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=0
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=1
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=16
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=33
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('26') , Dexterity= ('26') , Vitality= ('26') , Energy= ('26')
WHERE clevel>349 and Class=48
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=17
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=32

This will reset all class to their default value and give 500 pts per reset .... Jus change the 500 to watever nos u like .... Hope this helps ....

does not working for me .. or I`m too n00b ;/

well ... my server is using this ... so its fine with me ...

possible to delete all the agil and strength....just delete it...so it just resets with same stats?

thx...pls reply

Quote:

---

Originally Posted by chey42

1. create a new column in ur tables
2. Name it reset
3. Change the type of the column to navchar
4. Change the default to 1
5. Save it

Then at ur SQL server agent
1. Create a new job
2. Add this commands to it

UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=0
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=1
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=16
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=33
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('26') , Dexterity= ('26') , Vitality= ('26') , Energy= ('26')
WHERE clevel>349 and Class=48
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=17
UPDATE Character
SET clevel= ('1') , experience= ('0') , LevelUpPoint= 500*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=32

This will reset all class to their default value and give 500 pts per reset .... Jus change the 500 to watever nos u like .... Hope this helps ....

---

Look this man ! and cry ^^

Try this job...

Code:

---

UPDATE Character
SET Reset = Reset+1 WHERE cLevel=1000
UPDATE Character
SET cLevel= ('1') , Experience= ('0') , LevelUpPoint= 500*Reset , Strength= ('5') , Dexterity= ('5') , Vitality= ('5') , Energy= ('5')
WHERE cLevel=1000

---

He, take the resets (default = o ok ?)
Add more one... later he take the value again... (1) and 500*1 = 500 pounts = 1 reset ^^ it's good for ranking
Is a correction for you script ^^ ok ?
Good Luck

Using such resets,
my DB screwed very often, and ppl are back with
their lvls and staff.
(Dunno where's the problem exactly in such way of reset) :(

~Maniac

Quote:

---

Originally Posted by maniac1

Using such resets,
my DB screwed very often, and ppl are back with
their lvls and staff.
(Dunno where's the problem exactly in such way of reset) :(

~Maniac

---

I don't understand you man...
Auto reset = logoff, he reset you don't losing itens ! what you need ?

Quote:

---

Originally Posted by koaru*

possible to delete all the agil and strength....just delete it...so it just resets with same stats?

thx...pls reply

---

Sure, just use this:

Code:

---

UPDATE Character
SET clevel= ('1') , experience= ('0') , Reset = Reset+1
WHERE clevel>349

---

Its in fact a hellofalot shorter then his code :icon6:

But I advice not using automatic reset. 1th reason is that users can't maintain a level 350 character (wich is always cool to see on the stats page) and 2nd reason is that it uses quite an amount of CPU time, especially with that terribly long script posted here.

As a matter of coincidence, I just posted a webreset + reset reward script here :)

For the people who can't get there autoreset to work: make sure your SQL agent is running and that you've enabled the job to run every 1 minute from 00:00h till 23:59h without enddate.

NEED HELP !!!

http://forum.ragezone.com/showthrea...ight=Auto+Reset

And How to only reset, with the same stats?

como v6

What is SQL server agent

btw. how can i make such reset like:
1lvl char with 1 lvl char stats + extra points to add and before reset u have to put on all items to vault?? can somone write that kind of reset ??

i did everything you said but look at the errors that i get

http://img47.exs.cx/img47/4018/16sl.jpg
http://img47.exs.cx/img47/4104/22pw.jpg

ok i got it :) this reset works fine 4 me :)
i explain:
1. create a new column in ur tables
2. Name it Reset > http://dami.pl/~download/mu/sql.GIF
3. Change the type of the column to masllint
4. default value 1

then make new job
name it Reset > http://dami.pl/~download/mu/jobs.GIF
then in steps type:
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=0 and Money>50000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30')
WHERE clevel>349 and Class=1 and Money>50000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=16 and Money>50000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=33 and Money>500000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('26') , Dexterity= ('26') , Vitality= ('26') , Energy= ('26')
WHERE clevel>349 and Class=48 and Money>50000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10')
WHERE clevel>349 and Class=17 and Money>50000000
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1 , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15')
WHERE clevel>349 and Class=32 and Money>50000000


u can change extra points and money :)
everything works fine 4 me :)

leway, you created a table with name Reset, but you dont need that, you need create a column in Character table.

OK when I add the job, the job isn't running. Even when i try to start it, it still doesn't run. Anybody know why?

I make all allright but when rr don look what happend :( plz Help...

riuger

If you do not want to stats become 'zero' again simply edit the sql job like this,

mati_jg i'm using your script in here hope you don't mind with it... (...i made some changes)

Quote:

---

ok i got it this reset works fine 4 me
i explain:
1. create a new column in ur tables
2. Name it Reset > http://dami.pl/~download/mu/sql.GIF
3. Change the type of the column to masllint
4. default value 1

then make new job
UPDATE Character
SET clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 300*Reset , Reset = Reset+1
WHERE clevel>349 and Money>50000000

---

(... no need to add the class option on sql statemente because like this it will reset all class accounts you have, and reduces resources need to check...)

Hope i helped you and all other that may need.

---------------------------------
LegenD MU Server Portugal -http://www.legendmuserver.pt.vu/

I tryyed all manuals . But it same... Very much points and any way i cant rise it. Plz help.

lol same here the leveluppoint not working :P

i m using a similar script for auto reset, but ppl can keep the lvl 350... i just set the money for=50000000 ... so ppl only ll reset if they are lvl 350 with the right gold number :)
i got a question is bugging me:
what we can do to make ppl take out the itens to reset?? other way they can use wings/armors... without the req... just becouse they was wearing it before reset... tyvm

there is my script to auto reset:
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 35*VIP*Reset , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30') , Life= ('60') , MaxLife= ('60') , Mana= ('60') , MaxMana= ('60') , MapNumber= ('0') , MapPosX= ('125') , MapPosY= ('125')
WHERE clevel>349 and Class=0 and Money=50000000
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 35*VIP*Reset , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30') , Life= ('60') , MaxLife= ('60') , Mana= ('60') , MaxMana= ('60') , MapNumber= ('0') , MapPosX= ('125') , MapPosY= ('125')
WHERE clevel>349 and Class=1 and Money=50000000
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 35*VIP*Reset , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10') , Life= ('110') , MaxLife= ('110') , Mana= ('20') , MaxMana= ('20') , MapNumber= ('0') , MapPosX= ('125') , MapPosY= ('125')
WHERE clevel>349 and Class=16 and Money=50000000
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint=35*VIP*Reset , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15') , Life= ('80') , MaxLife= ('80') , Mana= ('30') , MaxMana= ('30') , MapNumber= ('3') , MapPosX= ('175') , MapPosY= ('110')
WHERE clevel>349 and Class=33 and Money=50000000
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 36*VIP*Reset , Strength= ('26') , Dexterity= ('26') , Vitality= ('26') , Energy= ('26') , Life= ('110') , MaxLife= ('110') , Mana= ('100') , MaxMana= ('100') , MapNumber= ('0') , MapPosX= ('125') , MapPosY= ('125')
WHERE clevel>349 and Class=48 and Money=50000000
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 35*VIP*Reset , Strength= ('28') , Dexterity= ('20') , Vitality= ('25') , Energy= ('10') , Life= ('110') , MaxLife= ('110') , Mana= ('20') , MaxMana= ('20') , MapNumber= ('0') , MapPosX= ('125') , MapPosY= ('125')
WHERE clevel>349 and Class=17 and Money=50000000
UPDATE Character
SET Reset = Reset+1, clevel= ('1') , experience= ('0') , Money=Money-50000000 , LevelUpPoint= 35*VIP*Reset , Strength= ('22') , Dexterity= ('25') , Vitality= ('20') , Energy= ('15') , Life= ('80') , MaxLife= ('80') , Mana= ('30') , MaxMana= ('30') , MapNumber= ('3') , MapPosX= ('175') , MapPosY= ('110')
WHERE clevel>349 and Class=32 and Money=50000000

and to add points:
UPDATE Character
SET LevelUpPoint=LevelUpPoint-300, Money=Money-2000000, Strength=Strength+300
WHERE clevel=1 and LevelUpPoint>299 and Money=2000301
UPDATE Character
SET LevelUpPoint=LevelUpPoint-300, Money=Money-2000000, Dexterity=Dexterity+300
WHERE clevel=1 and LevelUpPoint>299 and Money=2000302
UPDATE Character
SET LevelUpPoint=LevelUpPoint-300, Money=Money-2000000,Vitality=Vitality+300
WHERE clevel=1 and LevelUpPoint>299 and Money=2000303
UPDATE Character
SET LevelUpPoint=LevelUpPoint-300, Money=Money-2000000, Energy=Energy+300
WHERE clevel=1 and LevelUpPoint>299 and Money=2000304
UPDATE Character
SET LevelUpPoint=LevelUpPoint-1000, Money=Money-5000000, Strength=Strength+1000
WHERE clevel=1 and LevelUpPoint>999 and Money=5000301
UPDATE Character
SET LevelUpPoint=LevelUpPoint-1000, Money=Money-5000000, Dexterity=Dexterity+1000
WHERE clevel=1 and LevelUpPoint>999 and Money=5000302
UPDATE Character
SET LevelUpPoint=LevelUpPoint-1000, Money=Money-5000000,Vitality=Vitality+1000
WHERE clevel=1 and LevelUpPoint>999 and Money=5000303
UPDATE Character
SET LevelUpPoint=LevelUpPoint-1000, Money=Money-5000000, Energy=Energy+1000
WHERE clevel=1 and LevelUpPoint>999 and Money=5000304

any1 know how to erase all the itens the player is using?? it ll make ppl take off all items to reset... i already tryed search it like 1k times and looking in the php script ppl have post on the forum, but dont got where is this script... if any1 can help i would be very gratefull :)

I Need a Simple Reset Script...No add Str or other stats...no money need..
LvL need = 350
Plz Help

no1 know how to make the items the player is using during the reset go away... that ll make ppl put all items they have in vault to reset... no1 yet??

how do u make it so the charter must take of his/her items before they reset or they will loose it so the reset is like (bitz and bytez) server

Set up table?where to set it up?it is possible to put some screen shots for us?

it has bug. what if character is online during reset job works? you don't know what will happen? so let me underline, reset field will be increased but character will not be reseted and it will increase reset count with the period you set as long as character is online. cha cha cha

Please one script that it functions these has errors.... the chars bug points 6546664 pontos reset?

i have this bug too .. very many points!

I used a lot of codes .. but this problem persist!

Anywhere know the solution?

it is working for me..i manage to get it..however...the level did change to lvl 1...but no extra points..I copy all the command.Can i know where i go wrong?

Anywhere post one link to download one database for reset funtcionaly? Please ...

I knowledge the resolution for my problem!

ODBC!! my odbc not 100% functionaly .. im download new ODBC and this problem go away ...

well here is mine resets to defualt stats to each char class

for lvl 1k servers with maginc list deleted as a should be making them relearning skills plus inv clear it wont delete mony left on char tho also not u will need to edit PkLevel=2 to 1 cause my server has auto hero system :P anyways here my code

Code:

---

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('18') , Character.Dexterity= ('18') , Character.Vitality= ('15') , Character.Energy= ('30') , Character.Inventory=null , Character.MagicList=null

FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=1 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('22') , Character.Dexterity= ('25') , Character.Vitality= ('20') , Character.Energy= ('15') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=33 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('26') , Character.Dexterity= ('26') , Character.Vitality= ('26') , Character.Energy= ('26') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=48 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('28') , Character.Dexterity= ('20') , Character.Vitality= ('25') , Character.Energy= ('10') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=17 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10

---

Quote:

---

Originally Posted by Brianbio

well here is mine resets to defualt stats to each char class

for lvl 1k servers with maginc list deleted as a should be making them relearning skills plus inv clear it wont delete mony left on char tho also not u will need to edit PkLevel=2 to 1 cause my server has auto hero system :P anyways here my code

Code:

---

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('18') , Character.Dexterity= ('18') , Character.Vitality= ('15') , Character.Energy= ('30') , Character.Inventory=null , Character.MagicList=null

FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=1 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('22') , Character.Dexterity= ('25') , Character.Vitality= ('20') , Character.Energy= ('15') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=33 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('26') , Character.Dexterity= ('26') , Character.Vitality= ('26') , Character.Energy= ('26') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=48 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('28') , Character.Dexterity= ('20') , Character.Vitality= ('25') , Character.Energy= ('10') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=17 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10

---

---

better remove the invenotry clear.cuz imagine user gets connection problems and is for reset and blam..all items gone ^^

yep your right

Good idea.

[N]asser` ~ Out

XiaoXin faster on the server.........