Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
You last visited: Today at 23:08

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] Query To Fix PET2 Skill In DataBase

Discussion on [Release] Query To Fix PET2 Skill In DataBase within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
elite*gold: 460
Join Date: Jul 2012
Posts: 394
Received Thanks: 272
Cool [Release] 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$ >>
Alexiuns is offline  
Thanks
1 User
Old 07/21/2015, 15:03   #2
 
elite*gold: 0
Join Date: Jan 2015
Posts: 2
Received Thanks: 0
Thanks
precord is offline  
Reply


Similar Threads Similar Threads
[Release] Query To Add Skill 120 in Data Base ^^
07/14/2014 - SRO Private Server - 19 Replies
Query To Add Skill 120 in Data Base D11 ^^ ############################################Query By:King$########################################## ################# UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 1 AND 273 UPDATE dbo._RefSkill SET Service = 1 WHERE ID BETWEEN 276 AND 3481
[Release] Query To Un-ban Account [Database]
08/04/2012 - SRO PServer Guides & Releases - 6 Replies
--By Leandro ( nukertube ) -- USE GO -------------------------------- DECLARE @ChrID INT; DECLARE @CharName VARCHAR(64); DECLARE @AccJID INT; --------------------------------- SET @CharName = 'CharNameHere'--- ---------------------------------



All times are GMT +1. The time now is 23:09.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.