Dynamic Reset System

Results 1 to 10 of 10
  1. #1
    Account Inactive Sylv3R69 is offline
    InactiveRank
    Aug 2007 Join Date
    BudapestLocation
    69Posts

    idea Dynamic Reset System

    I created 1 reset system, work and i think very good...

    Normal Reset System:

    first part reset:
    If you under 50 reset

    350lvl = 320 stat
    351lvl = 322 stat, 2 stay stat bonus
    352lvl = 324 stat, 4 stay stat bonus
    400lvl = 420stat, 100 stay stat bonus

    second part reset:
    If you after 50 reset

    380lvl = 320 stat
    381lvl = 322 stat, 2 stay stat bonus
    382lvl = 324 stat, 4 stay stat bonus
    400lvl = 420 stat, 100 stay stat bonus

    If you have 1reset in 400 lvl, you give:
    320 stat + 100 stay stat, so you give 420 stat

    If you have 5 reset in 350, 350, 350, 351, 400, you give:
    320+320+320+(320+2)+(320+100) = 1702 stat

    ----------------------------------------------------------------

    VIP system:

    first part reset:
    If you under 50 reset

    350lvl = 330 stat
    351lvl = 333 stat, 3 stay stat bonus
    352lvl = 336 stat, 6 stay stat bonus
    400lvl = 480stat, 150 stay stat bonus

    second part reset:
    If you after 50 reset

    380lvl = 330 stat
    381lvl = 333 stat, 3 stay stat bonus
    382lvl = 336 stat, 6 stay stat bonus
    400lvl = 480 stat, 150 stay stat bonus

    If you have 1reset in 400 lvl, you give:
    330 stat + 150 stay stat, so you give 480 stat

    If you have 5 reset in 350, 350, 350, 351, 400, you give:
    330+330+330+(330+3)+(330+150) = 1803 stat

    Now SQL side:

    You need under 50rr: 50 millio zen, lorencia, 350lvl
    You need after 50rr: 50 millio zen, lorencia, 380lvl

    Create in character table:
    resetlvl / int / 4 / allow null <- no
    resetvip / int / 4 / allow null <- no

    Here the first part code:

    Code:
    Use MuOnline;
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, 
    PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip 
    = 0) and (Resets < 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, 
    PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) 
    and (resetvip = 0) and (Resets < 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, 
    PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip 
    = 1) and (Resets < 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, 
    PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) 
    and (resetvip = 1) and (Resets < 50);
    second part:

    Code:
    Use MuOnline;
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 0) and (Resets 
    >= 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, 
    Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip = 
    0) and (Resets >= 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 1) and (Resets 
    >= 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, 
    Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip = 
    1) and (Resets >= 50);
    By Sylv3R


  2. #2
    Legend MuIsBest is offline
    LegendRank
    Dec 2006 Join Date
    NorwayLocation
    2,144Posts

    Re: Dynamic Reset System

    Approved
    Akaruz
    -never forgotten, my friend.

    | RaGEZONE Forum Rules - Account Support |
    MuUsedToBeTheBest RIP


  3. #3
    High'nLows 19871986 is offline
    True MemberRank
    Sep 2010 Join Date
    istanbulLocation
    802Posts

    Re: Dynamic Reset System

    How this work ?

  4. #4
    Account Inactive Atomixx is offline
    InactiveRank
    Feb 2011 Join Date
    4Posts

    Re: Dynamic Reset System

    jajaja i am trolololo

  5. #5
    Account Inactive Evil_spirit is offline
    InactiveRank
    Jun 2008 Join Date
    Bangkok, ThailaLocation
    88Posts

    Re: Dynamic Reset System

    anyone can understand about this thread? and what season to use it for?

  6. #6
    VIP enabled khuongck is offline
    True MemberRank
    Nov 2007 Join Date
    VietnamLocation
    263Posts

    Re: Dynamic Reset System

    Sorry pros,I'm noob ;) plz explain how to use it

  7. #7
    Registered naguelsito is offline
    MemberRank
    Oct 2010 Join Date
    19Posts

    Re: Dynamic Reset System

    you need put the download LOL!!!

    haha! :D

    sorry for my bad english im argentinian ^^!

  8. #8
    Account Inactive foxfirediego is offline
    InactiveRank
    Jun 2005 Join Date
    my room?Location
    246Posts

    Re: Dynamic Reset System

    Quote Originally Posted by Evil_spirit View Post
    anyone can understand about this thread? and what season to use it for?
    Quote Originally Posted by khuongck View Post
    Sorry pros,I'm noob ;) plz explain how to use it
    Quote Originally Posted by naguelsito View Post
    you need put the download LOL!!!

    haha! :D

    sorry for my bad english im argentinian ^^!
    You need to create a stored procedure on SQL Server
    Last edited by foxfirediego; 25-02-11 at 01:50 PM.

  9. #9
    The Observer! Saige is offline
    True MemberRank
    Oct 2010 Join Date
    PilipinasLocation
    618Posts

    Re: Dynamic Reset System

    Quote Originally Posted by Sylv3R69 View Post
    I created 1 reset system, work and i think very good...

    Normal Reset System:

    first part reset:
    If you under 50 reset

    350lvl = 320 stat
    351lvl = 322 stat, 2 stay stat bonus
    352lvl = 324 stat, 4 stay stat bonus
    400lvl = 420stat, 100 stay stat bonus

    second part reset:
    If you after 50 reset

    380lvl = 320 stat
    381lvl = 322 stat, 2 stay stat bonus
    382lvl = 324 stat, 4 stay stat bonus
    400lvl = 420 stat, 100 stay stat bonus

    If you have 1reset in 400 lvl, you give:
    320 stat + 100 stay stat, so you give 420 stat

    If you have 5 reset in 350, 350, 350, 351, 400, you give:
    320+320+320+(320+2)+(320+100) = 1702 stat

    ----------------------------------------------------------------

    VIP system:

    first part reset:
    If you under 50 reset

    350lvl = 330 stat
    351lvl = 333 stat, 3 stay stat bonus
    352lvl = 336 stat, 6 stay stat bonus
    400lvl = 480stat, 150 stay stat bonus

    second part reset:
    If you after 50 reset

    380lvl = 330 stat
    381lvl = 333 stat, 3 stay stat bonus
    382lvl = 336 stat, 6 stay stat bonus
    400lvl = 480 stat, 150 stay stat bonus

    If you have 1reset in 400 lvl, you give:
    330 stat + 150 stay stat, so you give 480 stat

    If you have 5 reset in 350, 350, 350, 351, 400, you give:
    330+330+330+(330+3)+(330+150) = 1803 stat

    Now SQL side:

    You need under 50rr: 50 millio zen, lorencia, 350lvl
    You need after 50rr: 50 millio zen, lorencia, 380lvl

    Create in character table:
    resetlvl / int / 4 / allow null <- no
    resetvip / int / 4 / allow null <- no

    Here the first part code:

    Code:
    Use MuOnline;
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, 
    PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip 
    = 0) and (Resets < 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, 
    PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) 
    and (resetvip = 0) and (Resets < 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, 
    PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip 
    = 1) and (Resets < 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = 
    Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, 
    PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) 
    and (resetvip = 1) and (Resets < 50);
    second part:

    Code:
    Use MuOnline;
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 0) and (Resets 
    >= 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, 
    Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip = 
    0) and (Resets >= 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 1) and (Resets 
    >= 50);
    UPDATE Character
    SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000), 
    Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, 
    Resets = Resets + 1
    FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
    COLLATE Latin1_general_CI_AI
    WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip = 
    1) and (Resets >= 50);
    By Sylv3R
    nice code this help a lot thanks for sharing... and btw to the people who dont know how it works? will just run this query to your db. :)

  10. #10
    Account Inactive tutero69 is offline
    InactiveRank
    Jun 2010 Join Date
    1,028Posts

    Re: Dynamic Reset System

    Quote Originally Posted by naguelsito View Post
    you need put the download LOL!!!

    haha! :D

    sorry for my bad english im argentinian ^^!

    you need to READ MORE LOL !!!

    to know how this thing work ,,

    @ AUTHOR

    NICE RELEASE very helpfull !!!



Advertisement