как создать в базе в таблице Character поле Reset ??
и как изменить конфиг чтобы MG DL давали больше статов чем остальным?????
Вот я так понимаю сдесь конфиги для DW, DK, MG, ELF!!!
А какой из них для MG? И где взять для DL??
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)), Money = Money - (50000000 * (Reset + 1)), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, 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 * (Reset + 1))) AND (ConnectStat = 0);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)), Money = Money - (50000000 * (Reset + 1)), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, 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 * (Reset + 1))) AND (ConnectStat = 0);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)), Money = Money - (50000000 * (Reset + 1)), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, 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 * (Reset + 1))) AND (ConnectStat = 0);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)), Money = Money - (50000000 * (Reset + 1)), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, 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 >= 400) AND (Money >= (50000000 * (Reset + 1))) AND (ConnectStat = 0);
WHERE ((class = .. ) OR (class=.. )) => это что?? так как я понимаю это показывает класс персонажа, объясните мне пожалуста для кого какие цыфры?? и как сделать конфиг на DL ? :o