UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('35'), Dexterity=('35'), Vitality=('35'),Energy=('35')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>399 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 0 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=500+500*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('50'), Dexterity=('50'), Vitality=('50'),Energy=('50')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')
