Auto reset with points

C

chey42

Initiate Mage
Joined
May 20, 2004
Messages
2
Reaction score
0
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
 
chey42 said:
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 ....
Click to expand...

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
 
maniac1 said:
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
Click to expand...
I don't understand you man...
Auto reset = logoff, he reset you don't losing itens ! what you need ?
 
koaru* said:
possible to delete all the agil and strength....just delete it...so it just resets with same stats?

thx...pls reply
Click to expand...
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.
 
Last edited:
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 ??
 
help :)

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

To view the content, you need to sign in or register

To view the content, you need to sign in or register
 
ok i got it :) this reset works fine 4 me :)
i explain:
1. create a new column in ur tables
2. Name it Reset >
To view the content, you need to sign in or register

3. Change the type of the column to masllint
4. default value 1

then make new job
name it Reset >
To view the content, you need to sign in or register

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 :)
 
Last edited:
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?
 
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)

ok i got it this reset works fine 4 me
i explain:
1. create a new column in ur tables
2. Name it Reset >
To view the content, you need to sign in or register

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
Click to expand...

(... 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 -
To view the content, you need to sign in or register
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
2,359
Guests online
7,635
Total visitors
9,994
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back