Como definir o lvl e pts do reset

[---6_ta_loko---]

[glow=red,2,300]Olá gente blz?

Hoje to aqui para sabe se tem alguem ai que saiba como que em meu servidor posso definil o lvl e pontos de reset Free, reset vip e reset vip gold por exemplo.

ja vi geitos de colocar o free e o vip mais queria aprender a colocar os 3 free, vip e vip gold. quem puder ajudar ganha meu obrigado.

Vlw[/glow]

 

[BobSponja]

Acho q e isso que voce quer amigo.

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')

350+350 = Pontos no caso 350 pontos por reset.

349= Level PS: Sempre Deixa 1 a menos por Exemplo Resete e leve 300 voce deixa 299 no caso 349 reset = 350 Nao sei pq isso.. mais e assim kk

se nao for assim, poste a sua Job ae vlws!

 

[RenatoMN]

Free:

Citar

    -- JOB ACUMULATIVA FREE By ShamaN

    UPDATE Character

    SET cLevel  = 1,

    Experience  = 0,

    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 > 399

    AND Money > 50000000

    AND MEMB_STAT.ConnectStat = 0

    AND MEMB_INFO.vip = 0

    AND Resets <= 5000

Vip:

Citar

    -- JOB ACUMULATIVA VIP By ShamaN

    UPDATE Character

    SET cLevel  = 1,

    Experience  = 0,

    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 > 350

    AND Money > 10000000

    AND MEMB_STAT.ConnectStat = 0

    AND MEMB_INFO.vip = 1

    AND Resets <= 5000

Super Vip:

Citar

    -- JOB ACUMULATIVA SUPER VIP By ShamaN

    UPDATE Character

    SET cLevel  = 1,

    Experience  = 0,

    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 > 330

    AND Money > 10000000

    AND MEMB_STAT.ConnectStat = 0

    AND MEMB_INFO.vip = 2

    AND Resets <= 5000

Creditos:ShamaN

Post original Kaiba newbee:http://www.xpzone.net/%28mu-admin%29-tutoriais/%28tutorial%29reset-acumulativo-free-vip-e-supervip/