Все умельци делать ресет через http://mdxteam.com.ru/reset/index.php
Я себе сгенерировал. Ток проблема. Вроде бы это генератор преднозначен для версий до 1.01, (до тех где нету ДЛа)
Подскажите как сделать ресет с такими параметрами только с Дл.

-- Авторесет с уровня: 350 до уровня: 1
-- Статическое число дополнительных статов: 600
-- Статическая цена ресета: 100KK
--
-- Статы обнуляются до изначального значения
--
-- Ресет затронет только неподключенных пользователей
-- Все герои будут телепортированы в Lorencia после ресета
-- PK ресет
--
--
-- В базе авторесет будет фиксироваться в таблице: `Reset` в таблице `Character`
-- С изначальным значением: `0`
--
--

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (600), Money = Money - (100000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, 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 >= 350) AND (Money >= (100000000)) AND (ConnectStat = 0);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (600), Money = Money - (100000000), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, 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 >= 350) AND (Money >= (100000000)) AND (ConnectStat = 0);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (600), Money = Money - (100000000), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, 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 >= 350) AND (Money >= (100000000)) AND (ConnectStat = 0);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (600), Money = Money - (100000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 3, Reset = Reset + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 48) OR (class = 64)) AND (clevel >= 350) AND (Money >= (100000000)) AND (ConnectStat = 0);

Отредактировано n1ghtmare (2006-09-09 01:29:20)