- 1)AND Money > (@ZenReq - 1)AND MEMB_STAT.ConnectStat = 0AND MEMB_INFO.vip = 0AND Resets <= 150 -- Contas VIP UPDATE Character SET cLevel = 1, Experience = 0, LevelUpPoint = @PontosResetVIP * (Resets + 1), Strength = @ForcaVIP, Dexterity = @AgilidadeVIP, Vitality = @VitalidadeVIP, Energy = @EnergiaVIP, Money = Money - @ZenReqVIP, Resets = Resets + 1 FROM 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_AS WHERE cLevel > (@MaxLevelVIP - 1)AND Money > (@ZenReqVIP - 1)AND MEMB_STAT.ConnectStat = 0AND MEMB_INFO.vip = 1AND Resets <= 1000 ------------------------------------------------------------------------------------------------------------- E aqui estao alguns comandos de QUERY: CODE -- Tornar uma conta VIP UPDATE MEMB_INFO SET vip=1 WHERE memb___id='nome_da_conta' -- Tornar uma conta Nao VIP UPDATE MEMB_INFO SET vip=0 WHERE memb___id='nome_da_conta' -- Listar todas a contas VIP SELECT memb___id FROM MEMB_INFO WHERE vip=1 -- Listar todas a contas Nao VIP SELECT memb___id FROM MEMB_INFO WHERE vip=0 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, ou seja, esse char recomecaria com 20 pontos em todos os atributos (skills). WHERE clevel>349Lvl de Reset ( deixe -1 do lvl desejado ), nesse ele resetaria no 350.-------------------------------------------------------------------------------------------------------------[[ [ Auto Reset Para Vip na table Character ]Auto Reset para GM'sUPDATE CharacterSET 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___idcollate Latin1_general_CI_ASWHERE clevel>349 AND Vip = 8 AND Memb_Stat.ConnectStat = 0Auto Reset para Usuarios Normais ( and Vip = 0 ) :Ganhando 350 pontos, Resetando lvl 350UPDATE CharacterSET 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___idcollate Latin1_general_CI_ASWHERE 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 ItensUPDATE CharacterSET 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=nullFROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___idcollate Latin1_general_CI_ASWHERE 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 350UPDATE CharacterSET 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___idcollate Latin1_general_CI_ASWHERE clevel>349 AND Vip = 1 AND Memb_Stat.ConnectStat = 0Auto Reset para Qualquer Usuario Acumulativo : Resetando lvl 350 AcumulativoUPDATE Character SET clevel= ('1') , experience= ('0') WHERE clevel>349 15o Depois clique em Parse e de OK. 16o Va para Schedules.17o Em New Sechedule coloque tambem la AutoReset.18o Depois clique em Change.19o Na primeira parte selecione Daily e deixe em Every 1 day(s).20o Depois selecione em baixo Occurs every e troque Hour(s) por Minute(s).21o Duration selecione a data atual do dia e de ok.22o Agora e so finalizar dando Aplicar e OK.23o Pronto esta feito AUTORESET.24o Sempre de Start no SQL Server Agent, e deixe como auto start para facilitar.