motminhtao
01-05-15, 10:05 AM
Các bác giúp e coi dùm cái querry này còn dùng được ko và nó áp dụng được vào những loại server nào ? E chạy mà ko thấy có tác dụng.
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, 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 >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);
Nếu đc bác nào có thể share cho e 1 server RS bằng lệnh lun nhé. tks nhiều ạ.
UPDATE Character
SET clevel = 1, Experience = 0, LevelUpPoint = LevelUpPoint + (350 * (Reset + 1)), Money = Money - (50000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, Inventory = NULL, MagicList = NULL, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, 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 >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset <50>= 350) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (Reset < 50);
Nếu đc bác nào có thể share cho e 1 server RS bằng lệnh lun nhé. tks nhiều ạ.