UPDATE  Character SET   
  cLevel=1, 
  LevelUpPoint=(case when Resets>=50 then (Gresets+1)*10000  else (Resets+1)*300 end), 
  Experience=0, 
  Strength=(case when CtlCode=8 THEN 32767 ELSE  25 end), 
  Dexterity=(case when CtlCode=8 THEN 32767 ELSE  25 end), 
  Vitality=(case when CtlCode=8 THEN 32767 ELSE  25 end), 
  Energy=(case when CtlCode=8 THEN 32767 ELSE  25 end),  
  Money=(case when Resets>=50 then Money-(Gresets+1)*250000000 else  Money-(Resets+1)*10000000 end), 
  MapNumber=0, 
  MapPosX=130, 
  MapPosY=130, 
  PkLevel=0, 
  Resets=(case when Resets>=50 then 1 else Resets+1 end), 
  Gresets=(case when Resets>=50 then Gresets+1 else Gresets end)  
  where exists( 
   select *from MEMB_STAT m where m.ConnectStat=0 AND m.memb___id=AccountID  
  ) 
  and cLevel=350 and acctype=1  
  and Money>=(case when Resets>=50 then (Gresets+1)*250000000 else (Resets+1)*10000000 end)  
  

 
  UPDATE Character  
  SET clevel = 1, Experience = 0, LevelUpPoint = 400 * (Resets + 1), Money = Money - (10000000), Strength = 18, Dexterity = 18, Vitality = 15, Energy = 30, 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 CtlCode <> ('8') AND (clevel >= 400) AND (Money >= (10000000)) AND (ConnectStat = 0) AND (Resets < 100);