set @Energia = 30 -- Ponto padrao de energia que ira retornar apos resetar-- Contas VIP set @MaxLevelVIP = 299 -- Level ao qual podera resetar set @PontosResetVIP = 400 -- Pontos que ganhara por reset (Pontos vezes Resets) set @ZenReqVIP = 20000000 -- Zen requerido para resetar set @ForcaVIP = 100 -- Ponto padrao de forca que ira retornar apos resetar set @AgilidadeVIP = 100 -- Ponto padrao de agilidade que ira retornar apos resetar set @VitalidadeVIP = 100 -- Ponto padrao de vitalidade que ira retornar apos resetar set @EnergiaVIP = 100 -- Ponto padrao de energia que ira retornar apos resetar-- Execucao do comando SQL (Nao mexer) -- -- Contas nao VIP UPDATE CharacterSET cLevel = 1, Experience = 0, LevelUpPoint = @PontosReset * (Resets + 1), Strength = @Forca, Dexterity = @Agilidade, Vitality = @Vitalidade, Energy = @Energia, Money = Money - @ZenReq, Resets = Resets + 1FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_ASWHERE cLevel > (@MaxLevel - 1) AND Money > (@ZenReq - 1) AND MEMB_STAT.ConnectStat = 0 AND MEMB_INFO.vip = 0 AND Resets <= 150-- Contas VIP UPDATE CharacterSET cLevel = 1, Experience = 0, LevelUpPoint = @PontosResetVIP * (Resets + 1), Strength = @ForcaVIP, Dexterity = @AgilidadeVIP, Vitality = @VitalidadeVIP, Energy = @EnergiaVIP, Money = Money - @ZenReqVIP, Resets = Resets + 1FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_ASWHERE cLevel > (@MaxLevelVIP - 1) AND Money > (@ZenReqVIP - 1) AND MEMB_STAT.ConnectStat = 0 AND MEMB_INFO.vip = 1 AND Resets <= 1000 ------------------------------------------------------------------------------------------------------------- [ Auto Reset Para Vip na table Character ] Auto Reset para GM's UPDATE Character SET clevel=('50'), Experience=('0'),Money=Money-('0'), Reset=Reset+1, Strength=('32500'), Dexterity=('26000'), Vitality=('32500'), Energy=('32500') FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id collate Latin1_general_CI_AS WHERE clevel>349 AND Vip = 8 AND Memb_Stat.ConnectStat = 0 Auto Reset para Usuarios Normais ( and Vip = 0 ) :Ganhando 350 pontos, Resetando lvl 350 UPDATE Character SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Reset, Reset=Reset+1,Strength=('30'), Dexterity=('30'), Vitality=('30'),Energy=('30') FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id collate Latin1_general_CI_AS WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Vip = 0 and Money>('0') Auto Reset para Users Normais ( and Vip = 0 ) :Ganhando 350 pontos, Resetando lvl 350, Resetando Itens UPDATE Character SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Reset, Reset=Reset+1, Strength=('30'), Dexterity=('30'), Vitality=('30'),Energy=('30'), Inventory=null, MagicList=null FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id collate Latin1_general_CI_AS WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Vip = 0 and Money>('0') Auto Reset para Usuarios Vips ( and Vip = 1 ) : Ganhando 400 pontos, Resetando lvl 350 UPDATE Character SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint = 400+400*Reset, Reset=Reset+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 WHERE clevel>349 AND Vip = 1 AND Memb_Stat.ConnectStat = 0 Auto Reset para Qualquer Usuario Acumulativo : Resetando lvl 350 Acumulativo UPDATE Character SET clevel= ('1') , experience= ('0') WHERE clevel>349 ------------------------------------------------------------------------------------------------------------- Mudando o Codigo: LevelUpPoint = 300*Reset Significa que os pontos por reset vao ser definidos assim: 300 multiplicado pelo numero de resets atuais. Strength= ('20') , Dexterity= ('20') , Vitality= ('20') , Energy= ('20') Isso sao os atributos que o char recomeca,