Jobs de reset !

[somule]

galera alguem pode me passa job aew de gan 256 pontos por reset nao acumulativo !

free e vip ?      e tbm alguem pode me passa como coloca maximo de resete no serve quero colocar no maximo 500 !

 

[mzpvz]

JOB RESET AUTOMATICO NAO ACUMULATIVO

UPDATE Character

SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=130+130*Character.Resets, Character.Resets=Character.Resets+1,Strength=('25'), Dexterity=('25'), Vitality=('25'),Energy=('25')

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=180+180*Character.Resets, Character.Resets=Character.Resets+1,Strength=('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>389 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')

UPDATE Character

SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=230+230*Character.Resets, Character.Resets=Character.Resets+1,Strength=('70'), Dexterity=('70'), Vitality=('70'),Energy=('70')

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>379 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 2 and Money>('0')

AGRADEÇA SE AJUDEI..