Хотел бы спросить: можно зделать так чтоб МГ(шнику) после ресов ему давали не 500 стотов а например 700 на 200 больше а??
Скрипт
Сообщений 1 страница 7 из 7
Поделиться22007-04-27 05:25:15
а скрипт можна дать ??
Поделиться32007-04-27 17:06:47
(затупил)
Вот ваш скрипт!!! B)
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
Поделиться42007-04-27 19:12:59
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 28, Dexterity = 20, Vitality = 25, Energy = 10, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (500 * (Reset + 1)), Money = Money - (100000001), Strength = 22, Dexterity = 25, Vitality = 20, Energy = 15, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + ([span style='color:red']500 * (Reset + 1)), Money = Money - (100000001), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Inventory = 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 >= 350) AND (Money >= (100000001)) AND (ConnectStat = 0) AND (ctlcode < 8);[/span]
Поделиться52007-04-27 22:10:43
Спасибо....
Поделиться62007-04-28 08:58:59
инет упал забыл написать что меняется не только для МГ но и для ДЛ
и менять нада как можна понять значение 500 выделиное красным
Поделиться72007-04-28 13:07:28
Я понял все по красоте написано....(и причом все работает как по скрипту B) ))