Quote:
UPDATE CharacterSET clevel = 1, Experience = 0, LevelUpPoint = 400 * (ResetCount + 1), Money = Money - (50000000), Strength = 26, Dexterity = 26, Vitality = 26, Energy = 26, Leadership = 26, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkCount = 0, PkLevel = 0, ResetCount = ResetCount + 1FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___idCOLLATE Latin1_general_CS_AIWHERE (class = 64) AND (clevel >= 400) AND (Money >= (50000000)) AND (ConnectStat = 0) AND (MapNumber = 0) AND (ResetCount < 1000) ;