[ Release ] New Sql DB quires Collection .

[Neko*]

I Would like to release my collection
This is Some MSSQL V-sro quires i collected it in 1 thread ...
maybe it will help someone



It is not all mine , there is some i made myself , and there is others i collected from alot of threads .



-Cleaning The Databases .

 Spoiler

I. TABLE SQL

SRO_VT_ACCOUNT

CODE:

USE [SRO_VT_ACCOUNT]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SK_gamebang_ip](
    [nID] [smallint] NOT NULL,
    [ip] [int] NOT NULL,
    [capacity] [smallint] NOT NULL
) ON [PRIMARY]

GO

SRO_VT_ACCOUNT

CODE:

USE [SRO_VT_ACCOUNT]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

DROP TABLE [dbo].[_PrivilegedIP]
GO

CREATE TABLE [dbo].[_PrivilegedIP](
    [IP1] [tinyint] NOT NULL,
    [IP2] [tinyint] NOT NULL,
    [IP3] [tinyint] NOT NULL,
    [IP4] [tinyint] NOT NULL,
    [IP5] [tinyint] NOT NULL,
    [IP6] [tinyint] NOT NULL,
    [IP7] [tinyint] NOT NULL,
    [IP8] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SRO_VT_SHARD

CODE:

USE [SRO_VT_SHARD]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end

GO

II. CLEAN SQL

SRO_VT_ACCOUNT

CODE:

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[__SiegeFortressStatus__]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[SK_DownLevelLog]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_partnerInfo]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[Test_HN]
UPDATE [dbo].[_ShardService] SET ShardID = '64'

SRO_VT_LOG

CODE:

USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

SRO_VT_SHARD

CODE:

USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE [dbo].[_Chest]
TRUNCATE TABLE [dbo].[_ChestInfo]
TRUNCATE TABLE [dbo].[_User]
TRUNCATE TABLE [dbo].[_OpenMarket]
DELETE FROM [dbo].[_AccountJID] 
TRUNCATE TABLE [dbo].[_GuildWar]
TRUNCATE TABLE [dbo].[_GuildMember]
TRUNCATE TABLE [dbo].[_GuildChest]
TRUNCATE TABLE [dbo].[_SiegeFortressStruct]
TRUNCATE TABLE [dbo].[_SiegeFortressObject]
TRUNCATE TABLE [dbo].[_SiegeFortressItemForge]
DELETE FROM [dbo].[_SiegeFortress]
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3)
INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6)
UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0'
DELETE FROM [dbo].[_Guild] WHERE ID > 0
DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0
TRUNCATE TABLE [dbo].[_InventoryForAvatar]
TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint]
TRUNCATE TABLE [dbo].[_BlockedWhisperers]
TRUNCATE TABLE [dbo].[_TrainingCampMember]
TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade]
DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_TimedJob]
TRUNCATE TABLE [dbo].[_StaticAvatar]
TRUNCATE TABLE [dbo].[_Inventory]
TRUNCATE TABLE [dbo].[_Memo]
TRUNCATE TABLE [dbo].[_FleaMarketNetwork]
TRUNCATE TABLE [dbo].[_Friend]
TRUNCATE TABLE [dbo].[_CharSkillMastery]
TRUNCATE TABLE [dbo].[_CharSkill]
TRUNCATE TABLE [dbo].[_InvCOS]
DELETE FROM [dbo].[_CharCOS] WHERE ID > 0
DELETE FROM [dbo].[_Char] WHERE CharID > 0
TRUNCATE TABLE [dbo].[_CharCollectionBook]
TRUNCATE TABLE [dbo].[_CharInstanceWorldData]
TRUNCATE TABLE [dbo].[_CharNameList]
TRUNCATE TABLE [dbo].[_CharNickNameList]
TRUNCATE TABLE [dbo].[_CharQuest]
TRUNCATE TABLE [dbo].[_ClientConfig]
TRUNCATE TABLE [dbo].[_DeletedChar]
TRUNCATE TABLE [dbo].[_GPHistory]
TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage]
TRUNCATE TABLE [dbo].[_ItemPool]
DELETE FROM [dbo].[_Items] WHERE ID64 > 0
TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET]
TRUNCATE TABLE [dbo].[_TimedJobForPet]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp]
TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution]
TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution]

- Edit MaxStack for all items of stack = 50.

 Spoiler

PHP Code:

USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjItem
SET MaxStack = 10000
WHERE MaxStack = 50 


- Change it clientSide in each Itemsdata "5,000~45,000k" , try use CTRL + H to make it fast ^^

-Change Pets Page number to 5.

 Spoiler

PHP Code:

USE [SRO_VT_SHARD_INIT]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewCOS]    Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_AddNewCOS]
    @OwnerCharID    int,
    @RefObjID    int,
    @Level        int,
    @HP        int,
    @MP        int,
    @HGP        int,
    @KeeperNPC    int,
    @State        int,
    @InventorySize  int,
    @itemID        int,
    @PickItemConfig tinyint,
    @RentEndTime     smalldatetime
as

begin tran

    declare @COS_ID    int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (ÃÖ¼±È£)        
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

    declare @MaxInventorySize tinyint
    select @MaxInventorySize = InventorySize
    from _RefObjCommon, _RefObjChar
    where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
    
    if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
    begin
        rollback tran
        return -5
    end

    insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    set @COS_ID = @@identity
    if (@COS_ID = 0 OR @@error <> 0)
    begin
        rollback tran
        return -1
    end

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (ÃÖ¼±È£)        
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    begin
        declare @Slot  int
        set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (ÃÖ¼±È£)        
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        begin
            insert into _InvCOS values(@COS_ID, @Slot, 0)
            if (@@error <> 0)
            begin
                -- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
                rollback tran
                return -2
            end    
        
            set @Slot = @Slot + 1
        end
    end
    
/*    --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
    UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
    IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN -3
    END
*/
    if( @itemID <> 0 )
    begin
        update _Items set Data = @COS_ID where ID64 = @itemID
        if( @@error <> 0 or @@rowcount = 0 )
        begin
            rollback transaction
            return -4
        end
        
        --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
        declare @Serial64 bigint
        select @Serial64 = Serial64 from _Items where Data = @COS_ID
        exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0,0,0,@Serial64
        --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
        
    end

    commit tran

return @COS_ID 


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

 Spoiler

PHP Code:

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


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

 Spoiler

PHP Code:

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


-Change selling price for [Trader sell price without trading , Thief Sell price , and Trader Npc items buy Price ].

 Spoiler

PHP Code:

USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjCommon
SET Price = 3830
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 1910
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 114900
WHERE Cost = 16024 


-Change Job Profit.

 Spoiler

PHP Code:

DECLARE @NewQuot FLOAT                    -- @ SRO_VT_SHARD 
SET @NewQuot = 3            is also possible)

-- Profit %

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672 


- Finds Username, id, charname.

 Spoiler

PHP Code:

Select SRO_VT_SHARD_INIT.dbo._Char.CharName16 As CharName, U.StrUserID As UserName, UserJID As JID From SRO_VT_SHARD_INIT.dbo._User 
Right Join SRO_VT_SHARD_INIT.dbo._Char
On SRO_VT_SHARD_INIT.dbo._User.CharID = SRO_VT_SHARD_INIT.dbo._Char.CharID
Right Join SRO_VT_ACCOUNT.dbo.TB_User As U
On U.JID = SRO_VT_SHARD_INIT.dbo._User.UserJID
Where _Char.CharName16 = 'CharNameHere' 


- Resets Guild penalty when leaving.

 Spoiler

PHP Code:

Delete From _TimedJob Where ChardID = 'CharID' and JobID = '1' 


- Finds registered guilds for fw, leader, fw name, etc.

 Spoiler

PHP Code:

Use SRO_VT_SHARD_INIT
Select Distinct SG.GuildID, GM.CharName as GuildMaster, G.Name as GuildName, SG.FortressID, REFSG.CodeName128 As FortressName From _SiegeFortressRequest as SG
Right Join _RefSiegeFortress As REFSG On SG.FortressID = REFSG.FortressID
Right Join _Guild as G On G.ID = SG.GuildID
Right Join _RefSiegeFortress on REFSG.FortressID = SG.FortressID
Right Join _GuildMember as GM On GM.GuildID = SG.GuildID 
Where GM.MemberClass = 0 and SG.RequestType = 0
Order By REFSG.CodeName128 Asc 


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

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]
GO

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

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

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

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

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


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

 Spoiler

PHP 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%') 


With this Query you have to change all the FW uniques rows in Client side , you can download the fixed characterdata from here ..


if you edited your own , just copy the lines of all the FW uniques , 120 for each unqiue

- Added 120 Skills. [ This Query will Set service "1" for every Character skill exist in the DB ]

 Spoiler

PHP Code:

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409 


Activating the 12th degree on DB.

 Spoiler

PHP Code:

USE [SRO_VT_SHARD_INIT]

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'

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

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

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

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

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

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

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

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

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

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


-Fix Qin-Shin Tomb uniques timing .

 Spoiler

PHP Code:

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


-change character's mastery's at a certain level..
Credits ; nukertube , By ღ ∂ropp

 Spoiler

PHP 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'

UPDATE    [dbo].[_CharSkillMastery]
SET Level= 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName) 


Change Character User Name , A.K.A. ID.
Credits ; nukertube , By ღ ∂ropp

 Spoiler

PHP Code:

USE [SRO_VT_ACCOUNT]
declare @AtualID varchar (30)
declare @NewID varchar (30)
set @AtualID = 'youridhere'
set @NewID = 'newidhere'
update tb_user set struserid = @NewID
where struserid = @ActualID 


-Moving Uniques from its spawns (E.G : DemonShitan )
Credits : nukertube , By ღ ∂ropp

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]

Update Tab_RefNest Set 
dwDelayTimeMin=600 , 
dwDelayTimeMax=1601 ,
--Posição--
nRegionDBID=26737 ,
fLocalPosX=705 ,
fLocalPosY=272.922821 ,
fLocalPosZ=1466


 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET')) 


-ADD a GM account ( ip & [GM stats] & Some Gold )
by : Ahmed4ever2u

 Spoiler

PHP Code:

use SRO_VT_ACCOUT
Go
INSERT INTO _PrivilegedIP (IP1, IP2, IP3, IP4, IP5, IP6 ,IP7 ,IP8)      
    VALUES (41, 232, 175, 220, 41, 232, 175, 240)
GO
update TB_User set GMrank = 1
where StrUserID = heroine
GO
update TB_User set sec_primary = 1
where StrUserID = heroine
Go
update TB_User set sec_content = 1
where StrUserID = heroine
Go
USE SRO_VT_SHARD 
GO
update _Char set CharName16 = [GM] UnderGround 
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999 
where CharName16 like '%[GM] UnderGround%'; 


-Honor ranks Fix.
by : Ahmed4ever2u

 Spoiler

PHP Code:

USE SRO_VT_SHARD 
TRUNCATE TABLE _TrainingCampHonorRank 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK 


-Teleport All users to Jangan.
by : ahmed4ever2u

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 1073 , posY= 5 ,posZ= 1068 ,AppointedTeleport=19554,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0 


-Clean grap pets inventory .
By : Ahmed4ever2u

 Spoiler

PHP Code:

use SHARD_1
exec _ClearInvalidCOS 


-cleaning db from trashes & invalid data.
by : ahmed4ever2u

 Spoiler

PHP Code:

use SHARD_1
exec _RemoveAllInvalidData 


I Hope This Collections Helps.... and..


Regards.

[FoxRayz]

#Requesting this thread to be stickied

[ღ ∂ Ropp]

It's fairly useful...
If everyone wants to be lazy..
Anyways, good post.
+1

[Disco Teka]

Please link the threads here from where you've taken the information !
Inform me when it is done.

[Devsome]

Should he ?
When he tryed on his own and success ... maybe or maybe not.
Who knows :P

Otherwise, good 1+

[Wayne3]

Originally Posted by Neko*

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

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]
GO

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

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

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

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

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


Didnt worked for me. I set the droprate of the materials = 0:

USE [SRO_VT_SHARD]

GO

UPDATE dbo._RefMonster_AssignedItemDrop
SET DropRatio = 0
WHERE RefItemID BETWEEN 7101 AND 7464

UPDATE dbo._RefMonster_AssignedItemDrop
SET DropRatio = 0
WHERE RefItemID BETWEEN 10595 AND 10884

UPDATE dbo._RefMonster_AssignedItemDrop
SET DropRatio = 0
WHERE RefItemID BETWEEN 23279 AND 23305

UPDATE dbo._RefMonster_AssignedItemDrop
SET DropRatio = 0
WHERE RefItemID BETWEEN 25011 AND 25180

UPDATE dbo._RefMonster_AssignedItemDrop
SET DropRatio = 0
WHERE RefItemID BETWEEN 26066 AND 26081

[PortalDark]

i like to add this kind of stuff to my pastebin(ill find another way easier to arrange stuff later)

that one is for this thread



this is my complete stuff
i got some handy stuff that could help

[ÑõÑ_Ŝŧóp]

so you request this to be sticked?
srsly there are many other threads which are more useful than this and its not sticked,even the release thread of serverfiles isn't sticked...
otherwise,good job

[Disco Teka]

A collection of all silkroad server development tools which were released here would be definitly worth to get pinned.
But i imagine this like this:

Useful queries:
Title
Threadlink
etc.

Managing server:
Title
Threadlink

Other:
Title
Threadlink

Because otherwise people would flame about the credits.

[FoxRayz]

Originally Posted by ÑõÑ_Ŝŧóp

so you request this to be sticked?
srsly there are many other threads which are more useful than this and its not sticked,even the release thread of serverfiles isn't sticked...
otherwise,good job

I don't see why the serverfiles thread should get stickied? A simple search on Google and you got them right infront of you. I'm also curious who should've sticked it? Since we only got 1 moderator around here (Disco_Teka).


The reason why i want this thread to get stickied is because it would prevent a lot of spam in the this section and the "Ask the expert" section.

The necessary help could be found in this thread if it's just a simple SQL query.

[LastThief*]

Originally Posted by FoxRayz

I don't see why the serverfiles thread should get stickied? A simple search on Google and you got them right infront of you. I'm also curious who should've sticked it? Since we only got 1 moderator around here (Disco_Teka).


The reason why i want this thread to get stickied is because it would prevent a lot of spam in the this section and the "Ask the expert" section.

The necessary help could be found in this thread if it's just a simple SQL query.

still it aint that important to be stickied lol

[Neko*]

Added new 4 very important queries :


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

 Spoiler

PHP 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. [ This Query will Set service "1" for every Character skill exist in the DB ]

 Spoiler

PHP Code:

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409 


Activating the 12th degree on DB.

 Spoiler

PHP Code:

USE [SRO_VT_SHARD_INIT]

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'

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

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

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

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

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

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

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

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

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

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


-Fix Qin-Shin Tomb uniques timing .

 Spoiler

PHP Code:

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


I will ad others soon..

, and for what Disco Teka asked for , well it is my own library , and i didn't saved the main writer of the query i copied in here , i will try find them again on the internet , and write it on each query .

Regards

[tamer15]

well , thank you

but i would ask blackrogue got skilldatax.enc ?

[Melantz]

can you share query to add jupiter mob on vsro ?

[ahmed4ever2u]

here you are another good one
GM account ( ip & [GM stats] & Some Gold ) [Main]

 Spoiler

PHP Code:

use SRO_VT_ACCOUT
Go
INSERT INTO _PrivilegedIP (IP1, IP2, IP3, IP4, IP5, IP6 ,IP7 ,IP8)      
    VALUES (41, 232, 175, 220, 41, 232, 175, 240)
GO
update TB_User set GMrank = 1
where StrUserID = heroine
GO
update TB_User set sec_primary = 1
where StrUserID = heroine
Go
update TB_User set sec_content = 1
where StrUserID = heroine
Go
USE SRO_VT_SHARD 
GO
update _Char set CharName16 = [GM] UnderGround 
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999 
where CharName16 like '%[GM] UnderGround%'; 


1st Edit [main]
Honor Fix

 Spoiler

PHP Code:

USE SRO_VT_SHARD 
TRUNCATE TABLE _TrainingCampHonorRank 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK 


2nd Edit [not main] :
all users to jangan

 Spoiler

PHP Code:

USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 1073 , posY= 5 ,posZ= 1068 ,AppointedTeleport=19554,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0 


edit 3 : ( main )
Clean grap pets inventory ( kral for hackers )

 Spoiler

PHP Code:

use SHARD_1
exec _ClearInvalidCOS 


Edit 4 : ( main )
cleaning db from trashes & invalid data

 Spoiler

PHP Code:

use SHARD_1
exec _RemoveAllInvalidData