[Release] Query To Fix PET2 Skill In DataBase

~~Alexiuns~~ · 12/16/2012, 22:10

/* 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$ >>

precord · 07/21/2015, 15:03

Thanks