leway, you created a table with name Reset, but you dont need that, you need create a column in Character table.
Printable View
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)
(... 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...)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
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?