help here please

Results 1 to 13 of 13
  1. #1
    Proficient Member vienchin is offline
    MemberRank
    Apr 2014 Join Date
    160Posts

    information help here please

    How to fix this?
    when the character is reset stats , the PK win and lose are also reset
    example : PK win = 10 / Pk lose=5 then i reset stats and it become to 0/0 PK win/lose


  2. #2
    TsunaKun blackcatyb is offline
    MemberRank
    Jan 2010 Join Date
    Việt NamLocation
    935Posts

    Re: help here please

    Use querry reset it

  3. #3
    Proficient Member vienchin is offline
    MemberRank
    Apr 2014 Join Date
    160Posts

    Re: help here please

    Quote Originally Posted by blackcatyb View Post
    Use querry reset it
    i tried to reset all PK win PK lose many times .. but same thing happen.. if the character reset stats, the PK win / lose will Reset too.. how can i fix this problem?

  4. #4
    TsunaKun blackcatyb is offline
    MemberRank
    Jan 2010 Join Date
    Việt NamLocation
    935Posts

    Re: help here please

    USE RanGame1
    UPDATE ChaInfo
    SET pkwin=0,pklose=0 WHERE ChaNum=123

    See again name pk win lose in db because i onl mobile should i dont remember name the exact name it

  5. #5
    Proficient Member vienchin is offline
    MemberRank
    Apr 2014 Join Date
    160Posts

    Re: help here please

    - - - Updated - - -

    Quote Originally Posted by blackcatyb View Post
    USE RanGame1
    UPDATE ChaInfo
    SET pkwin=0,pklose=0 WHERE ChaNum=123

    See again name pk win lose in db because i onl mobile should i dont remember name the exact name it
    i already Reset all character's PK win/lose many times but still nothing happen..
    My problem sir is when character is reset stats, the PK win/lose will reset too.
    and i think the problem also is when character log out the pk win/lose will not save.


  6. #6
    Kayo na! ANg galing nyo e chumleader is offline
    MemberRank
    May 2014 Join Date
    wwwLocation
    353Posts

    Re: help here please

    where did it occur?
    on the SQL Trigger or on your Website?

  7. #7
    Proficient Member vienchin is offline
    MemberRank
    Apr 2014 Join Date
    160Posts

    Re: help here please

    Quote Originally Posted by chumleader View Post
    where did it occur?
    on the SQL Trigger or on your Website?
    sir pK win and lose on ranking sir .. everytime they logout or disconnect pk win and lose back to 0

  8. #8
    Kayo na! ANg galing nyo e chumleader is offline
    MemberRank
    May 2014 Join Date
    wwwLocation
    353Posts

    Re: help here please

    Check your SQL Trigger maybe there are codes that resets their PK info's

  9. #9
    Proficient Member vienchin is offline
    MemberRank
    Apr 2014 Join Date
    160Posts

    Re: help here please

    Quote Originally Posted by chumleader View Post
    Check your SQL Trigger maybe there are codes that resets their PK info's
    on what part of database?

  10. #10
    Kayo na! ANg galing nyo e chumleader is offline
    MemberRank
    May 2014 Join Date
    wwwLocation
    353Posts

    Re: help here please

    RanGame1.dbo.ChaInfo
    Click on Triggers
    then check the Trigger you have there

  11. #11
    Proficient Member vienchin is offline
    MemberRank
    Apr 2014 Join Date
    160Posts

    Re: help here please

    Quote Originally Posted by chumleader View Post
    RanGame1.dbo.ChaInfo
    Click on Triggers
    then check the Trigger you have there
    NONE.. i have no triggers on ChaInfo..

  12. #12
    Kayo na! ANg galing nyo e chumleader is offline
    MemberRank
    May 2014 Join Date
    wwwLocation
    353Posts

    Re: help here please

    maybe there are running query on your website
    as you said from your past comments the pk kill and pk death were resetting when the user reset their stats

    - - - Updated - - -

    maybe i'll check your Facebook account to be able to help further

  13. #13
    Account Bä́̽̔̌̈́̈̄̕̕nned HolyShift is offline
    MemberRank
    Sep 2014 Join Date
    Davao City, PhiLocation
    251Posts

    Re: help here please

    source related :)



Advertisement