Query To Fix PET2 Skill In DataBase

Results 1 to 15 of 15
  1. #1
    Banned NoMore is offline
    BannedRank
    Oct 2011 Join Date
    Alexandria, EgyLocation
    268Posts

    thumbs up Query To Fix PET2 Skill In DataBase

    /* Welcome Every One To My Thread ^^ */

    Today I Will Going To Release Some Query To Active And Fix PET2 Skills In DataBase
    Credit : To Me Not Others > King$ <

    Lets Start ..

    1. Query To Active The Skills
    Code:
    Update _RefSkill
    Set Service = 1
    Where Basic_Code like ('%%P2SKIL%%')
    /* By King$ Dont Re Release Under Your Name */
    2. Query To Fix The Lines
    Code:
    Update _RefSkill
    Set Param16 = 0, Param17 = 0, Param18 = 0, Param19 = 0
    Where Basic_Code like ('%%P2SKIL%%')
    /* By King$ Dont Re Release Under Your Name */
    3. Query To Fix The Lines
    Code:
    Update _RefSkill
    Set Param11 = 0, Param12 = 0, Param13 = 0, Param15 = 0
    Where Basic_Code like ('%%P2SKIL%%')
    /* By King$ Dont Re Release Under Your Name */
    4. Query To Fix The Lines
    Code:
    Update _RefSkill
    Set Param14 = 0, Param15 = 0, Param16 = 0, Param17 = 0
    Where Basic_Code like ('%%P2SKIL%%')
    /* By King$ Dont Re Release Under Your Name */
    5. Query To Fix The Lines
    Code:
    Update _RefSkill
    Set Service = 0
    Where ID BETWEEN 33726 And 33739
    /* By King$ Dont Re Release Under Your Name */
    6. Query To Fix The Lines
    Code:
    Update _RefSkill
    Set Service = 0
    Where ID BETWEEN 33581 And 33586
    /* By King$ Dont Re Release Under Your Name */
    Done

    If My Querys Helping You Press Like ^^

    /* Have Fun */


    << Regards King$ >>


  2. #2
    (⌐■_■) NourAyman is offline
    MemberRank
    Feb 2012 Join Date
    Behind you :PLocation
    683Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    thank you , but where is the skilleffect lines ?

  3. #3
    Banned NoMore is offline
    BannedRank
    Oct 2011 Join Date
    Alexandria, EgyLocation
    268Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by NourAyman View Post
    thank you , but where is the skilleffect lines ?
    take it from isro :D

  4. #4
    (⌐■_■) NourAyman is offline
    MemberRank
    Feb 2012 Join Date
    Behind you :PLocation
    683Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    dude , just complete ur thread and post them

  5. #5
    In the Emperor name Caosfox is offline
    MemberRank
    Jun 2011 Join Date
    Balcora GateLocation
    1,608Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    lol, lazy people...
    btw, can i ask what thing is fixed?

  6. #6
    Proficient Member Tazdingo is offline
    MemberRank
    Nov 2010 Join Date
    153Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by Caosfox View Post
    lol, lazy people...
    btw, can i ask what thing is fixed?
    Nothing he only disable the params that the gameserver cannot read.

  7. #7
    In the Emperor name Caosfox is offline
    MemberRank
    Jun 2011 Join Date
    Balcora GateLocation
    1,608Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    good ^^

  8. #8
    Proficient Member Tazdingo is offline
    MemberRank
    Nov 2010 Join Date
    153Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by nemo07 View Post
    why you are too jealous He tried to help anyway.
    He is not jealous, i think that he only said that this is a "stupid" release because the attacks will not work with the correct stats, etc.

    InTopic:
    Why you repeat the same query in 2,3,4 points ?
    You can use this instead of divide it in 3 different querys.

    Update _RefSkill
    Set Param11 = 0, Param12 = 0, Param13 = 0, Param14 = 0, Param15=0, Param16=0, Param17=0, Param18=0,Param19=0
    Where Basic_Code like ('%%P2SKIL%%')

  9. #9
    Banned nemo07 is offline
    BannedRank
    Sep 2011 Join Date
    HomeLocation
    284Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by InsaneDev View Post
    you are not even close to decency
    okey it's not a discussion Thread BTW not you that U tell me that, YOU know u are still kid and I hope u wont write any shit from your shits :)

    Quote Originally Posted by Tazdingo View Post
    He is not jealous, i think that he only said that this is a "stupid" release because the attacks will not work with the correct stats, etc.

    InTopic:
    Why you repeat the same query in 2,3,4 points ?
    You can use this instead of divide it in 3 different querys.

    Update _RefSkill
    Set Param11 = 0, Param12 = 0, Param13 = 0, Param14 = 0, Param15=0, Param16=0, Param17=0, Param18=0,Param19=0
    Where Basic_Code like ('%%P2SKIL%%')

    I said bro in the comment too that He tried To help ..

  10. #10
    Banned nemo07 is offline
    BannedRank
    Sep 2011 Join Date
    HomeLocation
    284Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by nemo07 View Post
    okey it's not a discussion Thread BTW not you that U tell me that, YOU know u are still kid and I hope u wont write any shit from your shits :)




    I said bro in the comment too that He tried To help ..


    I hated the SRO community (o_o)

  11. #11
    I'm Archimedes InsaneDev is offline
    MemberRank
    Jun 2012 Join Date
    EgyptLocation
    454Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by nemo07 View Post
    I hated the SRO community (o_o)
    sro community hatrd you even before you say that

    and one other thing
    you say i am a kid
    at least people respect this kid for who he is not for what he do in the Private server shit

  12. #12
    Banned nemo07 is offline
    BannedRank
    Sep 2011 Join Date
    HomeLocation
    284Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by InsaneDev View Post
    sro community hatrd you even before you say that

    and one other thing
    you say i am a kid
    at least people respect this kid for who he is not for what he do in the Private server shit
    Some PPL know me well and how I was helpfull to them BTW InsaneDev forget everything and It's not a weakness from me but I wanna be in peace :)

  13. #13
    Member 3oOomar is offline
    MemberRank
    Sep 2012 Join Date
    EgyptLocation
    96Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Thank's

  14. #14
    I'm Archimedes InsaneDev is offline
    MemberRank
    Jun 2012 Join Date
    EgyptLocation
    454Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    Quote Originally Posted by nemo07 View Post
    Some PPL know me well and how I was helpfull to them BTW InsaneDev forget everything and It's not a weakness from me but I wanna be in peace :)
    prove it

  15. #15
    Account Upgraded | Title Enabled! SL1MSH4DY is offline
    MemberRank
    Dec 2011 Join Date
    USALocation
    418Posts

    Re: [Release] Query To Fix PET2 Skill In DataBase

    I thought this topic was going to be a way to make pet skills work at vSRO :( lol



Advertisement