Reset Stat Point

Results 1 to 11 of 11
  1. #1
    Member Ocid Borlan is offline
    MemberRank
    Feb 2014 Join Date
    56Posts

    Reset Stat Point

    how to reset all character only STR, DEX, INT, PNT


  2. #2
    Member vodikatm is online now
    MemberRank
    Mar 2013 Join Date
    75Posts

    Re: Reset Stat Point

    use [Server01]


    update cabal_character_table set STR = 0, DEX = 0, INT = 0, PNT = 5

  3. #3
    Member Ocid Borlan is offline
    MemberRank
    Feb 2014 Join Date
    56Posts

    Re: Reset Stat Point

    Quote Originally Posted by vodikatm View Post
    use [Server01]


    update cabal_character_table set STR = 0, DEX = 0, INT = 0, PNT = 5
    how about a level that has been reached 160, 170, 180 ,190 ??
    str,dex,int 0 ? it will not balance.

  4. #4
    Account Upgraded | Title Enabled! luis R is offline
    MemberRank
    Nov 2015 Join Date
    467Posts

    Re: Reset Stat Point

    Quote Originally Posted by Ocid Borlan View Post
    how about a level that has been reached 160, 170, 180 ,190 ??
    str,dex,int 0 ? it will not balance.

    use [Server01]


    update cabal_character_table set LEV = 1

    and

    use [Server01]


    update cabal_character_table set STR = 0, DEX = 0, INT = 0, PNT = 5

  5. #5
    Trying to be developer ^^ Dens666 is offline
    MemberRank
    Jul 2010 Join Date
    PolandLocation
    1,080Posts

    Re: Reset Stat Point

    Quote Originally Posted by luis R View Post
    use [Server01]


    update cabal_character_table set LEV = 1

    and

    use [Server01]


    update cabal_character_table set STR = 0, DEX = 0, INT = 0, PNT = 5
    Do not use this query Ocid if you don't want fck up your server ;)
    Explain exactly what you expect and i'll prepare for you query.

    It's like when someone reach 160 lvl then reset lvl to 1 and set str dex int to 0?

  6. #6
    Account Upgraded | Title Enabled! luis R is offline
    MemberRank
    Nov 2015 Join Date
    467Posts

    Re: Reset Stat Point

    ohh sorry I didn't get what he mean, I think he want reset system

  7. #7
    Trying to be developer ^^ Dens666 is offline
    MemberRank
    Jul 2010 Join Date
    PolandLocation
    1,080Posts

    Re: Reset Stat Point

    Quote Originally Posted by luis R View Post
    ohh sorry I didn't get what he mean, I think he want reset system
    I think he want reset system, but your query is useless and just gonna mess his db.
    This query need if's.

  8. #8
    Member Ocid Borlan is offline
    MemberRank
    Feb 2014 Join Date
    56Posts

    Re: Reset Stat Point

    Thank Dens666 for reminding.
    I need to reset the system to all the characters. I've searched the forum, but there is only reset the system one by one. no to all the characters.

    Sorry, my English is bad.

  9. #9
    Account Upgraded | Title Enabled! golddragooon is offline
    MemberRank
    Feb 2013 Join Date
    Far Far AwayLocation
    350Posts

    Re: Reset Stat Point

    update cabal_character_table set STR = 0

    update cabal_character_table set INT = 0

    update cabal_character_table set DEX = 0

    update cabal_character_table set PTN = 0


    "Run this one by one in Server01 query" This will reset all char stats to 0

  10. #10
    Trying to be developer ^^ Dens666 is offline
    MemberRank
    Jul 2010 Join Date
    PolandLocation
    1,080Posts

    Re: Reset Stat Point

    Quote Originally Posted by golddragooon View Post
    update cabal_character_table set STR = 0

    update cabal_character_table set INT = 0

    update cabal_character_table set DEX = 0

    update cabal_character_table set PTN = 0


    "Run this one by one in Server01 query" This will reset all char stats to 0
    Best condition query Europe XD
    Btw. If you don't see vodika already post the same query as you.

    Update server01.dbo.cabal_character_table set lvl=1
    To reset all level, I do not recommend to do that.

  11. #11
    Account Upgraded | Title Enabled! golddragooon is offline
    MemberRank
    Feb 2013 Join Date
    Far Far AwayLocation
    350Posts

    Re: Reset Stat Point

    I just posted it again since he for sure didnt understand it so he did ask again same question



Advertisement