Avto Reset

[DarkLord]

Всё доброе время суток сори что не там пишу ну всё равно может кто знает
и так:
При создания сервера MuOnline как на сервере сделать авторесет я знаю можно через jobs в sql но что то у меня не получается может кто то поможет.. буду очень благодарен зарания спасибо

[This Is My World]

UPDATE Character SET clevel= 1, Experience= 0, Money= Money-100000000, Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX=125, MapPosY= 123, PkLevel= 3, Resets = Resets+1, LevelUpPoint = (300 * (Resets + 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>399) and (Money > (100000001)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1,Experience= 0, Money=Money-100000000, Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX= 125, MapPosY= 123, PkLevel= 3, Resets = Resets+1, LevelUpPoint = (300 * (Resets + 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>399) and (Money > (100000001)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1, Experience= 0, Money=Money-100000000, Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX= 125, MapPosY= 123, PkLevel= 3, Resets=Resets+1, LevelUpPoint = (300 * (Resets + 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>399) and (Money > (100000001)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1, Experience= 0, Money=Money-100000000, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber=0, MagicList = NULL, INVENTORY=Null, MapPosX= 125, MapPosY= 123, PkLevel= 3, LevelUpPoint= (300 * (Resets + 1))
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (class = 48 ) and (clevel>399) and (Money > (100000001)) AND (pklevel < 4) and (ConnectStat = 0)

UPDATE Character SET clevel= 1, Experience= 0, Money= Money-100000000, Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MagicList = NULL, INVENTORY=Null, MapNumber= 0, MapPosX= 125, MapPosY= 123, PkLevel= 3, Resets = Resets+1, LevelUpPoint = (300 * (Resets + 1))
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (class = 64) and (clevel>399) and (Money > (100000001)) AND (pklevel < 4) and (ConnectStat = 0)

[Alex_132]

sam pisal??

[This Is My World]

лол, а что тут писать работа по 2 таблицам. Как и что можно поменять думаю понятно...

[DarkLord]

лол, а что тут писать работа по 2 таблицам. Как и что можно поменять думаю понятно... [/b]

Cкрипт у меня есть! мне надо саму настройку jobs'a