AuTo reset Scripts

[thendmu]

i have searched in a lot threads but i couldn't find anywhere. who will help thank him or her in advance.


i need auto reset script next:

reset costs 10kk dk gets 500 points, dw gets 600 points, dl and mg gets 700 points, and elf gets 800 points. max reset is 100 and reset lvl is 400.


thank you all in advance

[MentaL]

[thendmu]

no one have ?

[JaneX]

here:

//DW or SM
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 600, Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, 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 >= 400) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 100);

//DK or BK
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 500, Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, 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 >= 400) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 100);

//ELF or ME
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 800, Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, 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 >= 400) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 100);

//MG
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 700, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 48) AND (clevel >= 400) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 100);

//DL
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 700, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (class = 64) AND (clevel >= 400) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 100);

im not pretty sure if u want keep stats or not but this one is not :P

[thendmu]

can i change it, that till 100 reset they could get 500 point and after 100 reset they would get 250 points

[thendmu]

no one knows ?

[19871986]

Janex How we can use this ? and with this points removed ? and is it Automatic ?

[JaneX]

to make this automatic you must paste this on SQL JOB :) yes as you see strength agi.. etc.. are set to 20.

[19871986]

i paste and OK this to sql query but with a little error.not happens. :/