-Fix Dare Devil Skill [ Not fully Working in some Databases].*Using it even there is no problems , will no affect your DB

Code:

UPDATE _RefSkill SET Basic_ChainCode=9046 WHERE ID=9035UPDATE _RefSkill SET Basic_ChainCode=9047 WHERE ID=9036UPDATE _RefSkill SET Basic_ChainCode=9048 WHERE ID=9037UPDATE _RefSkill SET Basic_ChainCode=9049 WHERE ID=9038UPDATE _RefSkill SET Basic_ChainCode=9050 WHERE ID=9039UPDATE _RefSkill SET Basic_ChainCode=9051 WHERE ID=9040UPDATE _RefSkill SET Basic_ChainCode=9052 WHERE ID=9041UPDATE _RefSkill SET Basic_ChainCode=9053 WHERE ID=9042

-Fix Dare Blade Soul Skill [ Not fully Working in some Databases].

Code:

USE SRO_VT_SHARD_INITupdate _RefSkill Set Basic_ChainCode = 0 WHERE ID between 7433 and 7434

- Disable alchemy materials from dropping. (all that garbage that is no longer needed).

Code:

USE [SRO_VT_SHARD]GO

UPDATE dbo._RefDropItemAssignSET Service = 0WHERE RefItemID BETWEEN 6679 AND 5414

UPDATE dbo._RefDropItemAssignSET Service = 0WHERE RefItemID BETWEEN 6082 AND 6371

UPDATE dbo._RefDropItemAssignSET Service = 0WHERE RefItemID BETWEEN 10501 AND 10527

UPDATE dbo._RefDropItemAssignSET Service = 0WHERE RefItemID BETWEEN 11499 AND 11668

UPDATE dbo._RefDropItemAssignSET Service = 0WHERE RefItemID BETWEEN 12554 AND 12569

- Fix The Fortress War Uniques. [ Some of them was not working ].

Code:

use SRO_VT_SHARD_INIT UPDATE _RefObjCommon SET TypeID3=1, TypeID4=1, Rarity=3 WHERE (CodeName128 LIKE 'MOB_FW_KYKLOPES_%') OR (CodeName128 LIKE 'MOB_FW_WHITETIGER_%') OR (CodeName128 LIKE 'MOB_FW_DARKEAGLE%') OR (CodeName128 LIKE 'MOB_FW_HAGIAZO%') OR (CodeName128 LIKE 'MOB_FW_BIGSPIDER_%') OR (CodeName128 LIKE 'MOB_FW_HANGA%')

- Added 120 Skills. [size=13][size=10][ This Query will Set service "1" for every Character skill exist in the DB ] [/size]UPDATE dbo._RefSkill[/size]

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 8994 AND 9005

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9008 AND 9025

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9028 AND 9045

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9048 AND 9065

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9068 AND 9085

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9088 AND 9105

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9114 AND 9125

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9134 AND 9145

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID BETWEEN 9154 AND 9225

UPDATE dbo._RefObjCommon SET Service = 0WHERE ID = 38620

-Fix Qin-Shin Tomb uniques timing .

Code:

USE SRO_VT_SHARD_INIT--B1UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique--B2UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 UniqueUPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 UniqueUPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique--B3UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800

-change character's mastery's at a certain level..

Code:

USE [SRO_VT_SHARD]GO--by Evo , Input their name here, and set their skill level you desire.Declare @CharName Varchar (64)Set @CharName = '[GM]BlackBerry'