quote:

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