Auto Reset Using Sql

[3yeka]

PLS Give me this scripts!!!

Auto Reset script :
-500 points for reset
-PK Reset
-Inventory and magic's save!!!!, not NULL
Money script :
-Valut money fix to 2 000 000
-Inventory fix to 1 000 000

[3yeka]

Auto Reset script :
-500 points for reset
-PK Reset
-Inventory and magic's save!!!!, not NULL
Money script :
-Valut money fix to 2 000 000
-Inventory fix to 1 000 000

[3yeka]

I need help !!!
My Script is :
UPDATE Character
SET clevel=('50'),Experience=('0'),Strength=('500'),Dexterity=('500'),Vitality=('500'),Energy=('500'),MapNumber=('0'),MapPosX=('125'),MapPosY=('125'),PkLevel=( '3'),Resets=Resets+('1'),LevelUpPoint=('500')*resets
WHERE clevel>('349')

But script is not reseting:(

[HELLOall]

wow i dident know it possible

[phongli]

Er Hi, sorry if this were mention somehwere before, i barly enter ragezone ( this isnot my acc too)

How to do a Script that reset the Character, ( which also remove what so ever left in the Character / stat ) , But it not auto , or to not auto host on site or something? . ty

[MaSch]

GM-AutoReset

UPDATE Character
SET cLevel=('340') experience= ('0')
WHERE cLevel>349 and CtlCode=8

Maybe anyone need it!

greetz

MaSch

[phongli]

How to set it as Un Auto?

[muleiki]

guys if i want put the reset in lvl 1000 and gain 1000 points per reset what should i do?

[muleiki]

guys what should i do if i want put lvl reset 1000 and gain 1000 points per reset?

[inquisitor]

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('500')+('500')*Character.resets ,
Character.Strength= ('18') , Character.Dexterity= ('18') , Character.Vitality= ('15') ,
Character.Energy= ('30') , Character.Inventory=null , Character.MagicList=null ,
Money=Money-300000000-100000000*Character.resets , MapNumber=('0') , MapPosX=('125') ,
MapPosY=('125') , PkLevel=('3') , Character.resets=Character.resets+1
WHERE Character.clevel>('349') and Character.Class=1
and Money>=300000000*(Character.resets+1)

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('500')+('500')*Character.resets ,
Character.Strength= ('22') , Character.Dexterity= ('25') , Character.Vitality= ('20') ,
Character.Energy= ('15') , Character.Inventory=null , Character.MagicList=null ,
Money=Money-300000000-100000000*Character.resets , MapNumber=('3') , MapPosX=('176') ,
MapPosY=('116') , PkLevel=('3') , Character.resets=Character.resets+1
WHERE Character.clevel>('349') and Character.Class=33
and Money>=300000000*(Character.resets+1)

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('700')+('700')*Character.resets ,
Character.Strength= ('26') , Character.Dexterity= ('26') , Character.Vitality= ('26') ,
Character.Energy= ('26') , Character.Inventory=null , Character.MagicList=null ,
Money=Money-300000000-100000000*Character.resets , MapNumber=('2') , MapPosX=('215') ,
MapPosY=('41') , PkLevel=('3') , Character.resets=Character.resets+1
WHERE Character.clevel>('349') and Character.Class=48
and Money>=300000000*(Character.resets+1)

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('500')+('500')*Character.resets ,
Character.Strength= ('28') , Character.Dexterity= ('20') , Character.Vitality= ('25') ,
Character.Energy= ('10') , Character.Inventory=null , Character.MagicList=null ,
Money=Money-300000000-100000000*Character.resets , MapNumber=('3') , MapPosX=('176') ,
MapPosY=('116') , PkLevel=('3') , Character.resets=Character.resets+1
WHERE Character.clevel>('349') and Character.Class=17
and Money>=300000000*(Character.resets+1)

100% working (my formula)

[phongli]

Halo, anyone here have 1 totally work Script for, all Equipement in item = dead after reset,
lvl 350 reset, max reset = 15, and Stat all return back.
or anything similar, that i would be able to change^^ ty

[phongli]

Hi, i still keep geting error, i just wondering anyone can post me a auto reset script that they have and it work , and i change some ( as in the number only ), if can ty^^

[phongli]

Update Character
Set clevel=('1'), Character.Experience=0, LevelUpPoint= ('300')+('300') , Strength= ('18') , Dexterity= ('18') , Vitality= ('15') , Energy= ('30') , Inventory=null, MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>349


Hi, that my Script, What do i need to do with it, to make when i reset, i get 300stat then 600 * on second. cause for now i did those script and end up having 300k * see through mu editor*

[KillerHT]

Im added row "resets" to "character" table on "MuOnline" database.
column name "resets", data type "int" allow nulls "on" default value "0" ("1" too most)

And add sctipt to SQL Agent Jobs:

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= 100+100*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>349 and Character.Class=1 and Character.LevelUpPoint=0 and Character.PkCount=0 AND Memb_Stat.ConnectStat = 0

It's work ^^

1 reset 400 points
2 reset 500 points
3 reset 600 points

BUT, It is necessary that it multiplied 100 on reset and then already added 100.

[KillerHT]

[QUOTE=thedark123]...QUOTE]

Im added row "resets" to "character" table on "MuOnline" database.
column name "resets", data type "int" allow nulls "on" default value "0" ("1" too most)

And add sctipt to SQL Agent Jobs:

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= 100+100*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>349 and Character.Class=1 and Character.LevelUpPoint=0 and Character.PkCount=0 AND Memb_Stat.ConnectStat = 0

It's work ^^

1 reset 400 points
2 reset 500 points
3 reset 600 points

BUT, It is necessary that it multiplied 100 on reset and then already added 100.