x-MU.net форум

1. Всем персонажам ( В моем случае : DK/SM/MG/DL ) требуется 400лвл. Эльфу требуется 395 лвл .

2. За каждый ресет взымается 10кк зен ( Кол-во ресетов*10кк )

3.После 40-ого ресета за ресет взымается "Remedy Of Love" ( 40-1ROL ; 41-2ROL ....... 50- 10 ROL ; 51-10 ROL ; 52 - 10 ROL и т.д. вплоть до 65 ресета) После 65 ресета ГР ( ресеты сгорают ; ГР будет отдельно )

4. Персонаж должен находиться на карте "Lorencia" ( Впрочем это не так важно но если так возможно будет замечательно )

5. Я думаю промежутки ресета можно не указывать т.к. это можно настроить в джобах но на всякий случай ( Каждые 60 минут : 00-00 ; 01-00 ; 02-00 ........ )

6. Поинты при ресете не горят!

7. Статы после ресета: Str:25 ; Agi:25 ; Vit:25 ; Ene:25 ; Cmd:40 ( Каждый ресет сюда начисляется по 30 поинтов (10-ый ресет: Cmd:340 ; 20-ый ресет: Cmd:640 и т.д. )

8. Класс персонажа при ресете не сгорает.

9. Все изученные магии сгорают каждые 20 ресетов ( Если это возможно то будет замечательно )

10. Персонаж должен быть раздет .

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 500 * (Resets + 1), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Money = Money - (15000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS WHERE ((class = 0) OR (class = 1) OR (class = 2)) AND (clevel >= 400) AND (Money >= (15000000)) AND (ConnectStat = 0) AND (Resets < 999);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 500 * (Resets + 1), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Money = Money - (15000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS WHERE ((class = 16) OR (class = 17) OR (class = 18)) AND (clevel >= 400) AND (Money >= (15000000)) AND (ConnectStat = 0) AND (Resets < 999);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 600 * (Resets + 1), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Money = Money - (15000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS WHERE ((class = 32) OR (class = 33) OR (class = 34)) AND (clevel >= 400) AND (Money >= (15000000)) AND (ConnectStat = 0) AND (Resets < 999);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 650 * (Resets + 1), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Money = Money - (15000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS WHERE ((class = 48) OR (class = 50)) AND (clevel >= 400) AND (Money >= (15000000)) AND (ConnectStat = 0) AND (Resets < 999);

UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = 650 * (Resets + 1), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Leadership = 26, Money = Money - (15000000), MapNumber = 0, MapPosX = 130, MapPosY = 130, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Chinese_PRC_CI_AS WHERE ((class = 64) OR (class = 66)) AND (clevel >= 400) AND (Money >= (15000000)) AND (ConnectStat = 0) AND (Resets < 999);