VSRO Query TopS4a



๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ๐Ÿ”ฅ




>>> ุฃูƒุจุฑ ู…ูƒุชุจุฉ SQL- Query <<<


Search About item on char

ูƒูˆุฏ:
Use SRO_VT_SHARD
GO

-----------------------------------

Select IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF
Right Join _Items As IT On IT.RefItemID = REF.ID
Right Join _Inventory As INV On INV.ItemID = IT.ID64
Right Join _Char as CH On CH.CharID = INV.CharID
-------------------------------------

Where CodeName128 like 'TSWORD_12_C_RARE'
Teleport All Players to Char name

ูƒูˆุฏ:
USE SRO_VT_SHARD  
GO
----------------------------------------------------------------------
    DECLARE @CHARNAME Varchar (18) 
-----------------------------------------------------------------------
    SET @CHARNAME = 'Player' -- Type Charname Here
-----------------------------------------------------------------------
    DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME)  
    DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)  
    DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)  
    DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)  
    DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)  
------------------------------------------------------------------------
UPDATE [dbo].[_Char] SET 
PosX = @POSX2, 
PosY = @POSY2, 
PosZ = @POSZ2, 
LatestRegion = @REGION2, 
WorldID = @WORLDID
Delete item from all players

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
-------------------------------

Exec [Dbo].[_SEEK_N_DESTROY_ITEM]  ['ITEM Code Name' ]  --Type Here Code Name
Add Silk to all players

ูƒูˆุฏ:
USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK 
(JID,
silk_own,
silk_gift,
silk_point) 
SELECT JID,
'0',
'0',
'0'
FROM TB_User 
WHERE not exists (select * from SK_Silk 
WHERE SK_SILK.JID = TB_User.JID);
--------------------------------------------------------
UPDATE SK_Silk SET silk_own=silk_own+10  --Change +10 To Amount You Want
Ban Player
ูƒูˆุฏ:
USE [SRO_VT_SHARD]           
GO
--------------------------------                           
DECLARE @ChrID INT;            
DECLARE @CharName VARCHAR(64); 
DECLARE @AccJID INT;           
---------------------------------
SET @CharName =    'CharNameHere' ---type Charname
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
-----------------------------------------------------------------
USE SRO_VT_ACCOUNT
DECLARE @ID VARCHAR (64)
DECLARE @Reason VARCHAR(128)
DECLARE @Begin DATETIME
DECLARE @End DATETIME
SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID)

---------------------------------
SET @Reason    =    'Ban Reason Here'
SET @Begin    =    '2012-05-01 00:00:00.000' --    Time Begin    --
SET @End    =    '2040-01-01 00:00:00.000' --    Time End    --
---------------------------------
---------------------------

INSERT [dbo].[_Punishment]
(
[UserJID],
[Type],
[Executor],
[Shard],
[CharName],
[CharInfo],
[PosInfo] ,
[Guide],
[Description],
[RaiseTime],
[BlockStartTime],
[BlockEndTime],
[PunishTime],
[Status]
)
VALUES 
(
@AccJID,
1,
1,
0,
@CharName,
1,
1,
@Reason,
@Reason,
@Begin,
@Begin,
@End,
@End,
0);
----------------------------------------------------------
DECLARE @ReasonID INT
SET @ReasonID =
(Select SerialNo FROM _Punishment Where UserJID = @AccJID)
----------------------------------------------------------
INSERT [dbo].[_BlockedUser]
(
[UserJID],
[UserID],
[Type],
[SerialNo],
[TimeBegin],
[TimeEnd])
VALUES
(
@AccJID,
@ID,
1,
@ReasonID,
@Begin,
@End);

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------
Remove PK By Char Name

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
------------------------------
DECLARE @CharName Varchar(max)
------------------------------
SET  @CharName = 'Player' --Type Player Name Here
------------------------------
UPDATE _Char SET
RemainHwanCount = 5,
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
WHERE CharName16 = @CharName
Give 120 Mastery Scroll

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
Declare @CharName Varchar (64)
-------------------------------------------------
Set @CharName    =    'Player' -- Type Player Name Here
-------------------------------------------------
UPDATE    [dbo].[_CharSkillMastery]
SET Level= '120' - Change If You Want
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Move All players to jangan
ูƒูˆุฏ:
USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
Give Buff Academy

ูƒูˆุฏ:
USE [SRO_VT_SHARD]  
DECLARE @CharName Varchar (MAX)  
DECLARE @Graduates INT  
DECLARE @HonorPoints INT  
DECLARE @CharID INT  
DECLARE @CampID INT  
----------------------------------------------------------------------------------------------------
SET        @CharName = 'Player' --Player Name Here
----------------------------------------------------------------------------------------------------
SET        @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)  
SET        @CampID    = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)  
SET        @Graduates    =    '1234[Number Of Graduates] '  
SET        @HonorPoints=    @Graduates * 39  

--------------------  

UPDATE [Dbo].[_TrainingCamp]  
SET GraduateCount = @Graduates  
WHERE [Dbo].[_TrainingCamp].[ID] = @CampID  
UPDATE [dbo].[_TrainingCampMember]  
SET HonorPoint = @HonorPoints  
WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID
Give Title Name

ูƒูˆุฏ:
USE SRO_VT_SHARD
GO
-------------------------
Update  _Char SET HWANLevel = '0' Where Charname16 Like 'Player' --Change Hwan Code And Player Name
Give Inventory Size

ูƒูˆุฏ:
USE SRO_VT_SHARD
GO
-----------------------------------------------------------------
Declare @CharName Varchar (64) 
Set @CharName    =    'Player' --Player Name
-----------------------------------------------------------------
Update(dbo._Char) 
InventorySize = 109 /* Number Of Slot Max 109 */ 
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Open All Skills GM (CH) Only
ูƒูˆุฏ:
USE [SRO_VT_SHARD]    
DECLARE @CharName varchar(255)    
DECLARE @CharID INT    
----------------------------------------------------------
SET @CharName='Player' --CharName    
----------------------------------------------------------
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName    
------------------------------------------------------------------
UPDATE _CharSkillMastery SET Level = '120' --Mastry
------------------------------------------------------------------
 WHERE CharID=@CharID    
INSERT INTO _CharSkill VALUES (@CharID,1,1)    
INSERT INTO _CharSkill VALUES (@CharID,2,1)    
INSERT INTO _CharSkill VALUES (@CharID,40,1)    
INSERT INTO _CharSkill VALUES (@CharID,70,1)    
INSERT INTO _CharSkill VALUES (@CharID,298,1)    
INSERT INTO _CharSkill VALUES (@CharID,306,1)    
INSERT INTO _CharSkill VALUES (@CharID,314,1)    
INSERT INTO _CharSkill VALUES (@CharID,322,1)    
INSERT INTO _CharSkill VALUES (@CharID,346,1)    
INSERT INTO _CharSkill VALUES (@CharID,378,1)    
INSERT INTO _CharSkill VALUES (@CharID,418,1)    
INSERT INTO _CharSkill VALUES (@CharID,463,1)    
INSERT INTO _CharSkill VALUES (@CharID,558,1)    
INSERT INTO _CharSkill VALUES (@CharID,569,1)    
INSERT INTO _CharSkill VALUES (@CharID,580,1)    
INSERT INTO _CharSkill VALUES (@CharID,588,1)    
INSERT INTO _CharSkill VALUES (@CharID,596,1)    
INSERT INTO _CharSkill VALUES (@CharID,604,1)    
INSERT INTO _CharSkill VALUES (@CharID,647,1)    
INSERT INTO _CharSkill VALUES (@CharID,655,1)    
INSERT INTO _CharSkill VALUES (@CharID,672,1)    
INSERT INTO _CharSkill VALUES (@CharID,689,1)    
INSERT INTO _CharSkill VALUES (@CharID,699,1)    
INSERT INTO _CharSkill VALUES (@CharID,708,1)    
INSERT INTO _CharSkill VALUES (@CharID,716,1)    
INSERT INTO _CharSkill VALUES (@CharID,724,1)    
INSERT INTO _CharSkill VALUES (@CharID,735,1)    
INSERT INTO _CharSkill VALUES (@CharID,746,1)    
INSERT INTO _CharSkill VALUES (@CharID,757,1)    
INSERT INTO _CharSkill VALUES (@CharID,765,1)    
INSERT INTO _CharSkill VALUES (@CharID,773,1)    
INSERT INTO _CharSkill VALUES (@CharID,781,1)    
INSERT INTO _CharSkill VALUES (@CharID,789,1)    
INSERT INTO _CharSkill VALUES (@CharID,797,1)    
INSERT INTO _CharSkill VALUES (@CharID,805,1)    
INSERT INTO _CharSkill VALUES (@CharID,813,1)    
INSERT INTO _CharSkill VALUES (@CharID,821,1)    
INSERT INTO _CharSkill VALUES (@CharID,829,1)    
INSERT INTO _CharSkill VALUES (@CharID,853,1)    
INSERT INTO _CharSkill VALUES (@CharID,885,1)    
INSERT INTO _CharSkill VALUES (@CharID,925,1)    
INSERT INTO _CharSkill VALUES (@CharID,933,1)    
INSERT INTO _CharSkill VALUES (@CharID,943,1)    
INSERT INTO _CharSkill VALUES (@CharID,952,1)    
INSERT INTO _CharSkill VALUES (@CharID,960,1)    
INSERT INTO _CharSkill VALUES (@CharID,968,1)    
INSERT INTO _CharSkill VALUES (@CharID,976,1)    
INSERT INTO _CharSkill VALUES (@CharID,984,1)    
INSERT INTO _CharSkill VALUES (@CharID,992,1)    
INSERT INTO _CharSkill VALUES (@CharID,1003,1)    
INSERT INTO _CharSkill VALUES (@CharID,1014,1)    
INSERT INTO _CharSkill VALUES (@CharID,1025,1)    
INSERT INTO _CharSkill VALUES (@CharID,1033,1)    
INSERT INTO _CharSkill VALUES (@CharID,1041,1)    
INSERT INTO _CharSkill VALUES (@CharID,1049,1)    
INSERT INTO _CharSkill VALUES (@CharID,1053,1)    
INSERT INTO _CharSkill VALUES (@CharID,1057,1)    
INSERT INTO _CharSkill VALUES (@CharID,1065,1)    
INSERT INTO _CharSkill VALUES (@CharID,1073,1)    
INSERT INTO _CharSkill VALUES (@CharID,1081,1)    
INSERT INTO _CharSkill VALUES (@CharID,1089,1)    
INSERT INTO _CharSkill VALUES (@CharID,1099,1)    
INSERT INTO _CharSkill VALUES (@CharID,1108,1)    
INSERT INTO _CharSkill VALUES (@CharID,1116,1)    
INSERT INTO _CharSkill VALUES (@CharID,1124,1)    
INSERT INTO _CharSkill VALUES (@CharID,1132,1)    
INSERT INTO _CharSkill VALUES (@CharID,1140,1)    
INSERT INTO _CharSkill VALUES (@CharID,1148,1)    
INSERT INTO _CharSkill VALUES (@CharID,1153,1)    
INSERT INTO _CharSkill VALUES (@CharID,1158,1)    
INSERT INTO _CharSkill VALUES (@CharID,1163,1)    
INSERT INTO _CharSkill VALUES (@CharID,1168,1)    
INSERT INTO _CharSkill VALUES (@CharID,1173,1)    
INSERT INTO _CharSkill VALUES (@CharID,1178,1)    
INSERT INTO _CharSkill VALUES (@CharID,1189,1)    
INSERT INTO _CharSkill VALUES (@CharID,1200,1)    
INSERT INTO _CharSkill VALUES (@CharID,1217,1)    
INSERT INTO _CharSkill VALUES (@CharID,1234,1)    
INSERT INTO _CharSkill VALUES (@CharID,1244,1)    
INSERT INTO _CharSkill VALUES (@CharID,1253,1)    
INSERT INTO _CharSkill VALUES (@CharID,1261,1)    
INSERT INTO _CharSkill VALUES (@CharID,1269,1)    
INSERT INTO _CharSkill VALUES (@CharID,1271,1)    
INSERT INTO _CharSkill VALUES (@CharID,1273,1)    
INSERT INTO _CharSkill VALUES (@CharID,1275,1)    
INSERT INTO _CharSkill VALUES (@CharID,1286,1)    
INSERT INTO _CharSkill VALUES (@CharID,1297,1)    
INSERT INTO _CharSkill VALUES (@CharID,1308,1)    
INSERT INTO _CharSkill VALUES (@CharID,1316,1)    
INSERT INTO _CharSkill VALUES (@CharID,1324,1)    
INSERT INTO _CharSkill VALUES (@CharID,1332,1)    
INSERT INTO _CharSkill VALUES (@CharID,1337,1)    
INSERT INTO _CharSkill VALUES (@CharID,1342,1)    
INSERT INTO _CharSkill VALUES (@CharID,1350,1)    
INSERT INTO _CharSkill VALUES (@CharID,1358,1)    
INSERT INTO _CharSkill VALUES (@CharID,1368,1)    
INSERT INTO _CharSkill VALUES (@CharID,1377,1)    
INSERT INTO _CharSkill VALUES (@CharID,1385,1)    
INSERT INTO _CharSkill VALUES (@CharID,1393,1)    
INSERT INTO _CharSkill VALUES (@CharID,1398,1)    
INSERT INTO _CharSkill VALUES (@CharID,1403,1)    
INSERT INTO _CharSkill VALUES (@CharID,1408,1)    
INSERT INTO _CharSkill VALUES (@CharID,1410,1)    
INSERT INTO _CharSkill VALUES (@CharID,1412,1)    
INSERT INTO _CharSkill VALUES (@CharID,1414,1)    
INSERT INTO _CharSkill VALUES (@CharID,1422,1)    
INSERT INTO _CharSkill VALUES (@CharID,1430,1)    
INSERT INTO _CharSkill VALUES (@CharID,1438,1)    
INSERT INTO _CharSkill VALUES (@CharID,1443,1)    
INSERT INTO _CharSkill VALUES (@CharID,1448,1)    
INSERT INTO _CharSkill VALUES (@CharID,1465,1)    
INSERT INTO _CharSkill VALUES (@CharID,1482,1)    
INSERT INTO _CharSkill VALUES (@CharID,1499,1)    
INSERT INTO _CharSkill VALUES (@CharID,1509,1)    
INSERT INTO _CharSkill VALUES (@CharID,1518,1)    
INSERT INTO _CharSkill VALUES (@CharID,1526,1)    
INSERT INTO _CharSkill VALUES (@CharID,1534,1)    
INSERT INTO _CharSkill VALUES (@CharID,1539,1)    
INSERT INTO _CharSkill VALUES (@CharID,1544,1)    
INSERT INTO _CharSkill VALUES (@CharID,1549,1)    
INSERT INTO _CharSkill VALUES (@CharID,1557,1)    
INSERT INTO _CharSkill VALUES (@CharID,1565,1)    
INSERT INTO _CharSkill VALUES (@CharID,1573,1)    
INSERT INTO _CharSkill VALUES (@CharID,1578,1)    
INSERT INTO _CharSkill VALUES (@CharID,1583,1)    
INSERT INTO _CharSkill VALUES (@CharID,1588,1)    
INSERT INTO _CharSkill VALUES (@CharID,1593,1)    
INSERT INTO _CharSkill VALUES (@CharID,1598,1)    
INSERT INTO _CharSkill VALUES (@CharID,1609,1)    
INSERT INTO _CharSkill VALUES (@CharID,1617,1)    
INSERT INTO _CharSkill VALUES (@CharID,1628,1)    
INSERT INTO _CharSkill VALUES (@CharID,3149,1)    
INSERT INTO _CharSkill VALUES (@CharID,3167,1)    
INSERT INTO _CharSkill VALUES (@CharID,3176,1)    
INSERT INTO _CharSkill VALUES (@CharID,3224,1)    
INSERT INTO _CharSkill VALUES (@CharID,3340,1)    
INSERT INTO _CharSkill VALUES (@CharID,3349,1)    
INSERT INTO _CharSkill VALUES (@CharID,3364,1)    
INSERT INTO _CharSkill VALUES (@CharID,3379,1)    
INSERT INTO _CharSkill VALUES (@CharID,3391,1)    
INSERT INTO _CharSkill VALUES (@CharID,3406,1)    
INSERT INTO _CharSkill VALUES (@CharID,3409,1)    
INSERT INTO _CharSkill VALUES (@CharID,3415,1)    
INSERT INTO _CharSkill VALUES (@CharID,3430,1)    
INSERT INTO _CharSkill VALUES (@CharID,3431,1)    
INSERT INTO _CharSkill VALUES (@CharID,3446,1)    
INSERT INTO _CharSkill VALUES (@CharID,3461,1)    
INSERT INTO _CharSkill VALUES (@CharID,3467,1)    
INSERT INTO _CharSkill VALUES (@CharID,3473,1)    
INSERT INTO _CharSkill VALUES (@CharID,7139,1)    
INSERT INTO _CharSkill VALUES (@CharID,7159,1)    
INSERT INTO _CharSkill VALUES (@CharID,7203,1)    
INSERT INTO _CharSkill VALUES (@CharID,7322,1)    
INSERT INTO _CharSkill VALUES (@CharID,7385,1)    
INSERT INTO _CharSkill VALUES (@CharID,7390,1)    
INSERT INTO _CharSkill VALUES (@CharID,7392,1)    
INSERT INTO _CharSkill VALUES (@CharID,7404,1)    
INSERT INTO _CharSkill VALUES (@CharID,7418,1)    
INSERT INTO _CharSkill VALUES (@CharID,7474,1)    
INSERT INTO _CharSkill VALUES (@CharID,7484,1)    
INSERT INTO _CharSkill VALUES (@CharID,7513,1)    
INSERT INTO _CharSkill VALUES (@CharID,7520,1)    
INSERT INTO _CharSkill VALUES (@CharID,7536,1)    
INSERT INTO _CharSkill VALUES (@CharID,7554,1)    
INSERT INTO _CharSkill VALUES (@CharID,7577,1)    
INSERT INTO _CharSkill VALUES (@CharID,7582,1)    
INSERT INTO _CharSkill VALUES (@CharID,7584,1)    
INSERT INTO _CharSkill VALUES (@CharID,7596,1)    
INSERT INTO _CharSkill VALUES (@CharID,7612,1)    
INSERT INTO _CharSkill VALUES (@CharID,7637,1)    
INSERT INTO _CharSkill VALUES (@CharID,7651,1)    
INSERT INTO _CharSkill VALUES (@CharID,7672,1)    
INSERT INTO _CharSkill VALUES (@CharID,7675,1)    
INSERT INTO _CharSkill VALUES (@CharID,7688,1)    
INSERT INTO _CharSkill VALUES (@CharID,7798,1)    
INSERT INTO _CharSkill VALUES (@CharID,7805,1)    
INSERT INTO _CharSkill VALUES (@CharID,7829,1)    
INSERT INTO _CharSkill VALUES (@CharID,7838,1)    
INSERT INTO _CharSkill VALUES (@CharID,7839,1)    
INSERT INTO _CharSkill VALUES (@CharID,7853,1)    
INSERT INTO _CharSkill VALUES (@CharID,7862,1)    
INSERT INTO _CharSkill VALUES (@CharID,7877,1)    
INSERT INTO _CharSkill VALUES (@CharID,7881,1)    
INSERT INTO _CharSkill VALUES (@CharID,7894,1)    
INSERT INTO _CharSkill VALUES (@CharID,7899,1)    
INSERT INTO _CharSkill VALUES (@CharID,7907,1)    
INSERT INTO _CharSkill VALUES (@CharID,7919,1)    
INSERT INTO _CharSkill VALUES (@CharID,7931,1)    
INSERT INTO _CharSkill VALUES (@CharID,7938,1)    
INSERT INTO _CharSkill VALUES (@CharID,7947,1)    
INSERT INTO _CharSkill VALUES (@CharID,7953,1)    
INSERT INTO _CharSkill VALUES (@CharID,7959,1)    
INSERT INTO _CharSkill VALUES (@CharID,7962,1)    
INSERT INTO _CharSkill VALUES (@CharID,7972,1)    
INSERT INTO _CharSkill VALUES (@CharID,7980,1)    
INSERT INTO _CharSkill VALUES (@CharID,7995,1)    
INSERT INTO _CharSkill VALUES (@CharID,7997,1)    
INSERT INTO _CharSkill VALUES (@CharID,8010,1)    
INSERT INTO _CharSkill VALUES (@CharID,8024,1)    
INSERT INTO _CharSkill VALUES (@CharID,8050,1)    
INSERT INTO _CharSkill VALUES (@CharID,8084,1)    
INSERT INTO _CharSkill VALUES (@CharID,8097,1)    
INSERT INTO _CharSkill VALUES (@CharID,8103,1)    
INSERT INTO _CharSkill VALUES (@CharID,8109,1)    
INSERT INTO _CharSkill VALUES (@CharID,8115,1)    
INSERT INTO _CharSkill VALUES (@CharID,8119,1)    
INSERT INTO _CharSkill VALUES (@CharID,8129,1)    
INSERT INTO _CharSkill VALUES (@CharID,8133,1)    
INSERT INTO _CharSkill VALUES (@CharID,8142,1)    
INSERT INTO _CharSkill VALUES (@CharID,8150,1)    
INSERT INTO _CharSkill VALUES (@CharID,8164,1)    
INSERT INTO _CharSkill VALUES (@CharID,8171,1)    
INSERT INTO _CharSkill VALUES (@CharID,8183,1)    
INSERT INTO _CharSkill VALUES (@CharID,8195,1)    
INSERT INTO _CharSkill VALUES (@CharID,8204,1)    
INSERT INTO _CharSkill VALUES (@CharID,8214,1)    
INSERT INTO _CharSkill VALUES (@CharID,8220,1)    
INSERT INTO _CharSkill VALUES (@CharID,8221,1)    
INSERT INTO _CharSkill VALUES (@CharID,8238,1)    
INSERT INTO _CharSkill VALUES (@CharID,8239,1)    
INSERT INTO _CharSkill VALUES (@CharID,8250,1)    
INSERT INTO _CharSkill VALUES (@CharID,8253,1)    
INSERT INTO _CharSkill VALUES (@CharID,8276,1)    
INSERT INTO _CharSkill VALUES (@CharID,8291,1)    
INSERT INTO _CharSkill VALUES (@CharID,8304,1)    
INSERT INTO _CharSkill VALUES (@CharID,8316,1)    
INSERT INTO _CharSkill VALUES (@CharID,8320,1)    
INSERT INTO _CharSkill VALUES (@CharID,8338,1)    
INSERT INTO _CharSkill VALUES (@CharID,8347,1)    
INSERT INTO _CharSkill VALUES (@CharID,8348,1)    
INSERT INTO _CharSkill VALUES (@CharID,8361,1)    
INSERT INTO _CharSkill VALUES (@CharID,8370,1)    
INSERT INTO _CharSkill VALUES (@CharID,8379,1)    
INSERT INTO _CharSkill VALUES (@CharID,8383,1)    
INSERT INTO _CharSkill VALUES (@CharID,8390,1)    
INSERT INTO _CharSkill VALUES (@CharID,8399,1)    
INSERT INTO _CharSkill VALUES (@CharID,8405,1)    
INSERT INTO _CharSkill VALUES (@CharID,8410,1)    
INSERT INTO _CharSkill VALUES (@CharID,8414,1)    
INSERT INTO _CharSkill VALUES (@CharID,8416,1)    
INSERT INTO _CharSkill VALUES (@CharID,20494,1)    
INSERT INTO _CharSkill VALUES (@CharID,20497,1)    
INSERT INTO _CharSkill VALUES (@CharID,20500,1)    
INSERT INTO _CharSkill VALUES (@CharID,21215,1)    
INSERT INTO _CharSkill VALUES (@CharID,21217,1)    
INSERT INTO _CharSkill VALUES (@CharID,30578,1)    
INSERT INTO _CharSkill VALUES (@CharID,30584,1)    
INSERT INTO _CharSkill VALUES (@CharID,30590,1)    
INSERT INTO _CharSkill VALUES (@CharID,30596,1)    
INSERT INTO _CharSkill VALUES (@CharID,30600,1)
Give Avatar GM

ูƒูˆุฏ:
USE SRO_VT_SHARD  

--Usage: 
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl 
declare @CharName varchar(64)  
  
set @CharName = 'Gamer' 
  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_AVATAR_M_GM_UNIFORM',1,250  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_AVATAR_W_GM_UNIFORM',1,250
Clean Database ACCOUNT

ูƒูˆุฏ:
USE [SRO_VT_ACCOUNT] 
GO 
TRUNCATE TABLE [dbo].[TB_User] 
TRUNCATE TABLE [dbo].[TB_User_Bak] 
TRUNCATE TABLE [dbo].[SK_CharRenameLog] 
TRUNCATE TABLE [dbo].[_Punishment] 
TRUNCATE TABLE [dbo].[_ServiceManagerLog] 
TRUNCATE TABLE [dbo].[Test_HN] 
TRUNCATE TABLE [dbo].[_BlockedUser] 
TRUNCATE TABLE [dbo].[_CasGMChatLog] 
TRUNCATE TABLE [dbo].[_Notice] 
TRUNCATE TABLE [dbo].[_SMCLog] 
TRUNCATE TABLE [dbo].[QuaySoEpoint] 
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_SilkGoods] 
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_paygate_trans]
Clean Database SHARD

ูƒูˆุฏ:
USE [SRO_VT_SHARD] 
GO 
truncate table _OpenMarket 
print 'Cleaned _OpenMarket' 
truncate table _CharSkill 
print 'Cleaned _CharSkill' 
truncate table _CharSkillMastery 
print 'Cleaned _CharSkillMastery' 
truncate table _GuildMember 
print 'Cleaned _GuildMember' 
truncate table _BlockedWhisperers 
print 'Cleaned _BlockedWhisperers' 
truncate table _Inventory 
print 'Cleaned _Inventory' 
truncate table _InventoryForAvatar 
print 'Cleaned _InventoryForAvatar' 
truncate table _InventoryForLinkedStorage 
print 'Cleaned _InventoryForLinkedStorage' 
truncate table _TrainingCampMember 
print 'Cleaned _TrainingCampMember' 
truncate table _TrainingCampSubMentorHonorPoint 
print 'Cleaned _TrainingCampSubMentorHonorPoint' 
update _TrainingCampHonorRank set CampID = NULL, Rank = NULL 
print 'Cleaned _TrainingCampHonorRank' 
truncate table _TrainingCampBuffStatus 
print 'Cleaned _TrainingCampBuffStatus' 
delete from _TrainingCamp 
print 'Cleaned _TrainingCamp' 
truncate table _StaticAvatar 
print 'Cleaned _StaticAvatar' 
truncate table _User 
print 'Cleaned _User' 
truncate table _Friend 
print 'Cleaned _Friend' 
truncate table _Memo 
print 'Cleaned _Memo' 
truncate table _TimedJob 
print 'Cleaned _TimedJob' 
truncate table _CharTrijobSafeTrade 
print 'Cleaned _CharTrijobSafeTrade' 
delete from _CharTrijob 
print 'Cleaned _CharTrijob' 
truncate table _InvCOS 
print 'Cleaned _InvCOS' 
delete from _CharCOS where ID > 0 
print 'Cleaned _CharCOS' 
delete from _Char where charid > 0 
print 'Cleaned _Char' 
truncate table _Chest 
print 'Cleaned _Chest' 
truncate table _ChestInfo 
print 'Cleaned _ChestInfo' 
truncate table _ItemPool 
print 'Cleaned _ItemPool' 
delete from _Items where ID64 > 0 
print 'Cleaned _Items' 
delete from _AccountJID 
print 'Cleaned _AccountJID' 
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 
print 'Cleaned _AlliedClans' 
truncate table _GuildWar 
print 'Cleaned _GuildWar' 
truncate table _CharNameList 
print 'Cleaned _CharNameList' 
truncate table _CharQuest 
print 'Cleaned _CharQuest' 
truncate table _ClientConfig 
print 'Cleaned _ClientConfig' 
truncate table _DeletedChar 
print 'Cleaned _DeletedChar' 
truncate table _SiegeFortressStoneState 
print 'Cleaned _SiegeFortressStoneState' 
truncate table _SiegeFortressRequest 
print 'Cleaned _SiegeFortressRequest' 
truncate table _SiegeFortressObject 
print 'Cleaned _SiegeFortressObject' 
truncate table _SiegeFortressItemForge 
print 'Cleaned _SiegeFortressItemForge' 
truncate table _SiegeFortressBattleRecord 
print 'Cleaned _SiegeFortressBattleRecord' 
update _SiegeFortressStruct SET OwnerGuildID = '0' 
print 'Cleaned _SiegeFortressStruct' 
UPDATE  _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL 
print 'Cleaned _SiegeFortress' 
truncate table _CharNickNameList 
print 'Cleaned _CharNickNameList' 
truncate table _GPHistory 
print 'Cleaned _GPHistory' 
truncate table _GuildChest 
print 'Cleaned _GuildChest' 
delete from _Guild where ID > 0 
print 'Cleaned _Guild' 
delete from _AlliedClans where ID > 0 
print 'Cleaned _AlliedClans'
Clean Database SHARDLOG

ูƒูˆุฏ:
USE [SRO_VT_SHARDLOG] 
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]
Guild/Job (0) Penalty Time

ูƒูˆุฏ:
USE [SRO_VT_SHARD] 
GO 
/******By Jangan ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 

ALTER   procedure [dbo].[_AddTimedJob] 
@CharID            int, 
@Category        tinyint, 
@JobID            int, 
@TimeToKeep    int, 
@Data1            int, 
@Data2            int, 
--##begin due to develop composite item 
@Data3            int, 
@Data4            int, 
@Data5            int, 
@Data6            int, 
@Data7            int, 
@Data8            int, 
@Serial64        bigint, 
@JID            int 
--##end due to develop composite item 
as 
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) 
                return -1 
            if (@TimeToKeep <= 0) 
                return -2 
            declare @NewJobID int 
            set @NewJobID = 0 

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader 
            --##If you want to only have one not both, then just modify the line below! 
            if (@JobID = 1 or @JobID = 2) 
            BEGIN 
                return -1 
            END 
            ELSE 
            BEGIN 
            --##begin due to develop composite item 
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID) 
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) 
            END 
            --##end due to develop composite item 
            set @NewJobID = @@identity 
            if (@@error <> 0 or @@rowcount = 0) 
                 
                return -3 
     return @NewJobID
Create Guild Lv 5

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Guild_Create] Script Date: 08/16/2012 23:40:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--
ALTER PROCEDURE [dbo].[_Guild_Create]
@GuildName varchar(64),
@CreaterID int
as
if (exists (select id from _Guild where Name = @GuildName))
begin
         return -1000
end
if (exists (select CharID from _GuildMember where CharID = @CreaterID))
begin
         return -1001
end
begin transaction

declare @GuildID int
declare @FoundationDate smalldatetime

set @FoundationDate = GetDate()
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values(@GuildName, 5, 123456, @FoundationDate,0,0)
set @GuildID = @@identity

if (@@error <> 0 or @@rowcount = 0 or @GuildID = 0)
begin
         rollback transaction
         return -5
end


--???? ???? 0xffffffff !!
declare @rvalue int
exec @rvalue = _Guild_FnAddMember @GuildID, @CreaterID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
         rollback transaction
         return @rvalue
end

-- ?? ??? ????
exec @rvalue = _Guild_CreateChest_NoTX @GuildID
if (@@error <> 0 or @rvalue <= 0)
begin
         rollback transaction
         return @rvalue
end


commit transaction
return @GuildID
Guild Limit

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_Guild_FnAddMember]    Script Date: 15.06.2014 11:08:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO




ALTER PROCEDURE [dbo].[_Guild_FnAddMember]
 @guildID        int,
 @MemberID     int,
 @MemberClass    tinyint,
 @joinDate     smalldatetime,
 @permission     int    
    
as
Declare @LiMiT int = '24' -- << Userr Limit Credits by $Apollo
    if (exists (select CharID from _GuildMember where CharID = @MemberID))
    begin
        return -1001
    end


    declare @MemberName    varchar(64)
    declare @curLevel    tinyint
    select @MemberName = CharName16, @curLevel = CurLevel from _Char with (nolock) where CharID = @MemberID
    if (@@error <> 0 or @@rowcount = 0)
    begin
        return -1
    end
    if (exists (select CharID from _GuildMember with (nolock) where GuildID = @guildID and CharID = @MemberID))
    begin 
        return -2
    end
    
        declare @ReFObjID int
    select @ReFObjID = RefObjID from _Char with (nolock) where CharID = @MemberID
    
    if (@@error <> 0 or @@rowcount = 0)
    begin
        return -5
    end






    declare @siegeAuthority tinyint
    set @siegeAuthority = 0


    if @MemberClass = 0  -- ±&#230;¸¶&#192;&#204;¸รฉ °&#248;¼&#186;±&#199;&#199;&#209;&#192;» commander·&#206; ¼¼&#198;&#195;! ±× &#191;&#220;´&#194; &#192;&#207;¹&#221; member·&#206; ¼¼&#198;&#195;&#199;&#209;´&#217;.
    begin
        set @siegeAuthority = 1
    end
    Declare @GC int = (Select COUNT(*) from _GuildMember where GuildID = @guildID )
   if @GC  <= @LiMiT begin 
    insert _GuildMember values @guildID, @MemberID, @MemberName, @MemberClass, @curLevel, 0, @joinDate @permission, 0, 0, 0, null, @ReFObjID, @siegeAuthority)
    end
    if (@@error <> 0 or @@rowcount = 0)
    begin
        return -3
    end
    
       if @GC  <= @LiMiT begin  
    update _Char Set GuildID = @guildID where CharID = @MemberID
    end
    if (@@error <> 0 or @@rowcount = 0)
    begin
        return -4
    end
    return 1
Union Limit

ูƒูˆุฏ:
USE [SRO_VT_SHARD]

GO
/****** Object:  StoredProcedure [dbo].[_Guild_Create]    Script Date: 14.06.2014 16:53:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




--
ALTER PROCEDURE [dbo].[_Guild_Create]
    @guildName    varchar(64),
    @CreaterID    int
as
    if (exists (select id from _Guild where Name = @guildName))
    begin
        return -1000
    end
    if (exists (select CharID from _GuildMember where CharID = @CreaterID))
    begin
        return -1001
    end
begin transaction
    
    declare @guildID    int
    declare @FoundationDate  smalldatetime
    
    set @FoundationDate = GetDate()
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_1', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_2', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_3', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_4', 1, 0, @FoundationDate,0,0)
    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName+'_ULimit_5', 1, 0, @FoundationDate,0,0)


    insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName, 5, 0, @FoundationDate,0,0)
    set @guildID = @@identity
    
    if (@@error <> 0 or @@rowcount = 0 or @guildID = 0)
    begin
        rollback transaction
        return -5
    end


    --๊ธธ๋“œ์žฅ์€ ํผ๋ฏธ์…˜์ด 0xffffffff !!
    declare @rvalue int
    exec @rvalue = _Guild_FnAddMember @guildID, @CreaterID, 0, @FoundationDate,0xffffffff
    if (@@error <> 0 or @rvalue <= 0)
    begin
        rollback transaction
        return @rvalue
    end
    
    -- ๊ธธ๋“œ ์ฐฝ๊ณ ๋ฅผ ์ƒ์„ฑํ•˜์ž
    exec @rvalue = _Guild_CreateChest_NoTX @guildID
    if (@@error <> 0 or @rvalue <= 0)
    begin
        rollback transaction
        return @rvalue
    end


commit transaction
    return @guildID
Remove Fortress From All Guilds

ูƒูˆุฏ:
USE SRO_VT_SHARD 
UPDATE _SiegeFortress SET GuildID = 0
Add Drop To Unique Or Mobs

ูƒูˆุฏ:
 USE SRO_VT_SHARD 
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 3810 -------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 -------- Item drop rate 1=100% , 0.3 = 30% 
SET @ItemID = 24165 -------- ITEM ID You want Add in Drops


INSERT _RefMonster_AssignedItemDrop 
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
) 
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
Delete Alchemy Material Drop

ูƒูˆุฏ:
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
Change Spot Unique

[QUOTE]USE [SRO_VT_SHARD]

ูƒูˆุฏ:
USE [SRO_VT_SHARD] 

DECLARE @OldMOB varchar(128),@NewMOB varchar(128),@OldMOBID varchar(128),@NewMOBID varchar(128) 
SET /**/@OldMOB/**/        =    'MOB_CH_MANGNYANG' 
SET /**/@NewMOB/**/    =    'MOB_RM_ROC' 
SET @OldMOBID    =    (SELECT [ID] FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @OldMOB) 
SET @NewMOBID    =    (SELECT [ID] FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @NewMOB) 
UPDATE [dbo].[Tab_RefTactics] 
SET [dwObjID]    =    @NewMOBID 
WHERE [dwObjID]    =    @OldMOBID
Add Spot Unique

ูƒูˆุฏ:
USE SRO_VT_SHARD

DECLARE @UNIQUE VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1

/* put your settings here */
SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60  -- Minimum time before appears in seconds
SET @maxdelay = 120  -- Maximum time before appears in seconds
SET @INITRADIUS = 100  -- Radius around spot unique can generated at
SET @RADIUS = 500  -- Radius around spot Unique can move in
/* end of settings area */

/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)

SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF

SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)

SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!' 
/**Because query will not work as it with BR files due to the difference between tables so:
Delete Drop

ูƒูˆุฏ:
USE SRO_VT_SHARD
GO
DELETE _RefDropItemAssign
FROM _RefDropItemAssign Drops
LEFT JOIN _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like 'ITEMCODENAMEHERE'
Change Delay unique Time

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1 where dwdelaytimemax = '21600' ;
Change Mob Or Unique Lvl

ูƒูˆุฏ:
USE SRO_VT_SHARD 

Declare @link int, @codename varchar(max), @level int, @newlevel int; 

set @codename = 'SN_MOB_SD_HIKE' /* <- from textdata_object.txt */ 



set @link = (SELECT Link FROM _RefObJCommon WHERE NameStrID128 = @codename) 
set @newlevel = ( 
    case 
    when (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10 <= 120 THEN (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10 
    ELSE 120 
    end); 

UPDATE _RefObjChar SET Lvl = @newlevel WHERE ID = @link 
UPDATE _RefObjChar SET ExpToGive = cast(ExpToGive*1.1 as bigint) WHERE ID = @link 
UPDATE _RefObjChar SET MaxHP = cast(MaxHP*1.1 as bigint) WHERE ID = @link
Change Mob To Unique

ูƒูˆุฏ:
USE SRO_VT_SHARD 
GO 

update _RefObjCommon set Rarity = 3 where CodeName128 = 'Code el mob hna' 

Print 'Mob has been changed to unique'
Sox Drop Rate

ูƒูˆุฏ:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
Alchemy Rate 1.5x

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2044'
Lucky Powder Rate

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
DECLARE @RATE INT
SET @RATE=1
UPDATE dbo._RefObjItem SET Param2=(Param2*@RATE) WHERE ID BETWEEN '2033' AND '2054'
UPDATE dbo._RefObjItem SET Param3=(Param3*@RATE) WHERE ID BETWEEN '2033' AND '2054'
UPDATE dbo._RefObjItem SET Param4=(Param4*@RATE) WHERE ID BETWEEN '2033' AND '2054'
Job Exp Rate

ูƒูˆุฏ:
USE [SRO_VT_SHARD] 
DECLARE @Rate INT 
SET @Rate = '100' -- Rate here 
UPDATE [dbo].[_RefLevel] 
SET 

[JobExp_Trader] = [JobExp_Trader]/@Rate 
, 
[JobExp_Robber] = [JobExp_Robber]/@Rate 
, 
[JobExp_Hunter] = [JobExp_Hunter]/@Rate 
WHERE [Lvl] BETWEEN 1 and 7 


SELECT  
* 
FROM _RefLevel 
WHERE Lvl BETWEEN 1 AND 140;
Job Gold Rate

ูƒูˆุฏ:
USE [SRO_VT_SHARD] 
DECLARE @NewQuot FLOAT   
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9            -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999            -- Goods Price @ the Shop
SET @NewStack = 9999            -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999        -- Goods Price if you sell them directly again - without trading.

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

-- Price / SellPrice

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672

  -- MaxStack
  
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160

-- Price

UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCodeName like '%ITEM_ETC_TRADE%'
Magic Pop Rate

ูƒูˆุฏ:
USE [SRO_VT_SHARD] 
GO 
DECLARE @Rate int 
SET @Rate = 10 
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
Stones Rate

ูƒูˆุฏ:
USE SRO_VT_SHARD 
GO 
UPDATE _RefObjItem 
SET Param4 = Here Put The Rate You Want % 
WHERE ID BETWEEN 4630 AND 5013
Fix F1 Problem

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO

DELETE FROM _CharQuest WHERE QuestID = 1

INSERT INTO _CharQuest
SELECT CharID, QuestID = 1, [Status] = 1,AchievementCount = 0, StartTime = GETDATE()-4460, EndTime = GETDATE()-4460, QuestData1 = 0, QuestData2 = 0
FROM _Char
WHERE not exists (SELECT CharID, QuestID FROM _CharQuest WHERE QuestID = 1)

--if problem is still found open _RefCharDefault_Quest Table.
--look at this line : 0    15    3    QEVENT_GUIDE    1
--you need to enable this quest like this : 1    15    3    QEVENT_GUIDE    1
Fix 5 Page Pet Inventory
ูƒูˆุฏ:
USE [SRO_VT_SHARD]  
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 (&Atilde;&Ouml;¼±&Egrave;£)          
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  

    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 (&Atilde;&Ouml;¼±&Egrave;£)          
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
    if (@MaxInventorySize > 0)  
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
    begin  
        declare @Slot  int  
        set @Slot = 0  
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
--        pet_skill_item (&Atilde;&Ouml;¼±&Egrave;£)          
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
        while (@Slot < @MaxInventorySize)  
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@  
        begin  
            insert into _InvCOS values(@COS_ID, @Slot, 0)  
            if (@@error <> 0)  
            begin  
                -- &Agrave;&Icirc;&ordm;¥&Aring;&auml;¸® »&yacute;¼&ordm; ½&Ccedil;&AElig;&ETH;!  
                rollback tran  
                return -2  
            end      
          
            set @Slot = @Slot + 1  
        end  
    end  
      
/*    --´&otilde; &Agrave;&Igrave;»&oacute; &Agrave;&Igrave; &Auml;&Atilde;·³&iquest;&iexcl;´&Acirc; ยต¥&Agrave;&Igrave;&Aring;&Iacute;¸¦ ³&Ouml;&Aacute;&ouml; ¾&Ecirc;´&Acirc;´&Ugrave;!  
    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 7 Page Pet Inventory

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddNewCOS]    Script Date: 08/22/2013 19:40:43 ******/
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 (&#195;&#214;¼±&#200;£)        
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

    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 (&#195;&#214;¼±&#200;£)        
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
    begin
        declare @Slot  int
        set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        pet_skill_item (&#195;&#214;¼±&#200;£)        
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        begin
            insert into _InvCOS values(@COS_ID, @Slot, 0)
            if (@@error <> 0)
            begin
                -- &#192;&#206;&#186;¥&#197;&#228;¸® »&#253;¼&#186; ½&#199;&#198;&#208;!
                rollback tran
                return -2
            end    
        
            set @Slot = @Slot + 1
        end
    end
    
/*    --´&#245; &#192;&#204;»&#243; &#192;&#204; &#196;&#195;·³&#191;&#161;´&#194; ยต¥&#192;&#204;&#197;&#205;¸¦ ³&#214;&#193;&#246; ¾&#202;´&#194;´&#217;!
    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
        
         declare @Serial64 bigint
        select @Serial64 = Serial64 from _Items where Data = @COS_ID
        exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,196,0,0,0,0,0,@Serial64
        
    end

    commit tran

return @COS_ID
Honor Rank

ูƒูˆุฏ:
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
Bug Pills

ูƒูˆุฏ:
USE [SRO_VT_SHARD] --By Swagger1337
GO

UPDATE _RefObjItem SET Param4='20000', Desc4_128='COOLTIME:0x000000C8'
WHERE ID BETWEEN 5861 and 5864
Fortress War Fixes Lines

ูƒูˆุฏ:
Go To

SQL >> SRO_VT_SHARD >> TABLES >> _SiegeFortress

Delete all then add this

------------------------------------------------------------------------------------
1 0 0 0 0 0 NULL NULL 0 1  
3 0 0 0 0 0 NULL NULL 0 1  
6 0 0 0 0 0 NULL NULL 0 1 
------------------------------------------------------------------------------------

Then go to 

SQL >> SRO_VT_SHARD >> TABLES >> _SiegeFortressStruct

Delete all then add this

------------------------------------------------------------------------------------

1 0 84 19538 936000 2011.10.20. 15:06:00 0 
1 0 85 19521 464000 2011.10.20. 15:06:00 0 
1 0 86 19521 464000 2011.10.20. 15:06:00 0 
1 0 87 19521 464000 2011.10.20. 15:06:00 0 
1 0 88 19504 936000 2011.10.20. 15:06:00 0 
1 0 89 19504 936000 2011.10.20. 15:06:00 0 
1 0 90 19504 936000 2011.10.20. 15:06:00 0 
1 0 91 19509 0 2011.10.20. 15:06:00 0 
1 0 92 19509 0 2011.10.20. 15:06:00 0 
1 0 93 19509 0 2011.10.20. 15:06:00 0 
1 0 94 19509 0 2011.10.20. 15:06:00 0 
1 0 95 19509 0 2011.10.20. 15:06:00 0 
1 0 96 19509 0 2011.10.20. 15:06:00 0 
1 0 97 19515 0 2011.10.20. 15:06:00 0 
1 0 98 19515 0 2011.10.20. 15:06:00 0 
1 0 99 19515 0 2011.10.20. 15:06:00 0 
1 0 100 19515 0 2011.10.20. 15:06:00 0 
1 0 101 19515 0 2011.10.20. 15:06:00 0 
1 0 102 19515 0 2011.10.20. 15:06:00 0 
1 0 103 19515 0 2011.10.20. 15:06:00 0 
1 0 104 19515 0 2011.10.20. 15:06:00 0 
1 0 105 19515 0 2011.10.20. 15:06:00 0 
1 0 106 19515 0 2011.10.20. 15:06:00 0 
1 0 107 19515 0 2011.10.20. 15:06:00 0 
1 0 108 19515 0 2011.10.20. 15:06:00 0 
1 0 127 19543 0 2011.10.20. 16:25:00 0 
1 0 128 19543 0 2011.10.20. 16:25:00 0 
1 0 129 19543 0 2011.10.20. 16:25:00 0 
1 0 130 19543 0 2011.10.20. 16:25:00 0 
1 0 131 19543 0 2011.10.20. 16:25:00 0 
1 0 132 19543 0 2011.10.20. 16:25:00 0 
1 0 133 19543 0 2011.10.20. 16:25:00 0 
1 0 134 19543 0 2011.10.20. 16:25:00 0 
1 0 135 19543 0 2011.10.20. 16:25:00 0 
1 0 136 19543 0 2011.10.20. 16:25:00 0 
3 0 180 19610 936000 2011.10.19. 22:00:00 0 
3 0 181 19521 464000 2011.10.19. 22:00:00 0 
3 0 182 19521 464000 2011.10.19. 22:00:00 0 
3 0 183 19521 464000 2011.10.19. 22:00:00 0 
3 0 184 19575 936000 2011.10.19. 22:00:00 0 
3 0 185 19575 936000 2011.10.19. 22:00:00 0 
3 0 186 19575 936000 2011.10.19. 22:00:00 0 
3 0 187 19509 0 2011.10.19. 22:00:00 0 
3 0 188 19509 0 2011.10.19. 22:00:00 0 
3 0 189 19509 0 2011.10.19. 22:00:00 0 
3 0 190 19509 0 2011.10.19. 22:00:00 0 
3 0 191 19509 0 2011.10.19. 22:00:00 0 
3 0 192 19509 0 2011.10.19. 22:00:00 0 
3 0 193 19515 0 2011.10.19. 22:00:00 0 
3 0 194 19515 0 2011.10.19. 22:00:00 0 
3 0 195 19515 0 2011.10.19. 22:00:00 0 
3 0 196 19515 0 2011.10.19. 22:00:00 0 
3 0 197 19515 0 2011.10.19. 22:00:00 0 
3 0 198 19515 0 2011.10.19. 22:00:00 0 
3 0 199 19515 0 2011.10.19. 22:00:00 0 
3 0 200 19515 0 2011.10.19. 22:00:00 0 
3 0 201 19515 0 2011.10.19. 22:00:00 0 
3 0 202 19515 0 2011.10.19. 22:00:00 0 
3 0 224 19543 0 2011.10.19. 22:00:00 0 
3 0 225 19543 0 2011.10.19. 22:00:00 0 
3 0 226 19543 0 2011.10.19. 22:00:00 0 
3 0 227 19543 0 2011.10.19. 22:00:00 0 
3 0 228 19543 0 2011.10.19. 22:00:00 0 
3 0 229 19543 0 2011.10.19. 22:00:00 0 
3 0 230 19543 0 2011.10.19. 22:00:00 0 
3 0 231 19543 0 2011.10.19. 22:00:00 0 
6 0 137 19625 464000 2011.10.19. 15:10:00 0 
6 0 138 19521 464000 2011.10.19. 15:10:00 0 
6 0 139 19521 464000 2011.10.19. 15:10:00 0 
6 0 140 19590 464000 2011.10.19. 15:10:00 0 
6 0 141 19590 464000 2011.10.19. 15:10:00 0 
6 0 142 19509 0 2011.10.19. 15:10:00 0 
6 0 143 19509 0 2011.10.19. 15:10:00 0 
6 0 144 19509 0 2011.10.19. 15:10:00 0 
6 0 145 19509 0 2011.10.19. 15:10:00 0 
6 0 146 19515 0 2011.10.19. 15:10:00 0 
6 0 147 19515 0 2011.10.19. 15:10:00 0 
6 0 148 19515 0 2011.10.19. 15:10:00 0 
6 0 149 19515 0 2011.10.19. 15:10:00 0 
6 0 150 19515 0 2011.10.19. 15:10:00 0 
6 0 151 19515 0 2011.10.19. 15:10:00 0 
6 0 152 19515 0 2011.10.19. 15:10:00 0 
6 0 153 19515 0 2011.10.19. 15:10:00 0 
6 0 154 19515 0 2011.10.19. 15:10:00 0 
6 0 155 19515 0 2011.10.19. 15:10:00 0 
6 0 172 19543 0 2011.10.19. 15:10:00 0 
6 0 173 19543 0 2011.10.19. 15:10:00 0 
6 0 174 19543 0 2011.10.19. 15:10:00 0 
6 0 175 19543 0 2011.10.19. 15:10:00 0 
6 0 176 19543 0 2011.10.19. 15:10:00 0 
6 0 177 19543 0 2011.10.19. 15:10:00 0 
6 0 178 19543 0 2011.10.19. 15:10:00 0 
6 0 179 19543 0 2011.10.19. 15:10:00 0 
1 0 118 19641 80000 2011.10.20. 17:42:59 0 
3 0 221 23934 80000 2011.10.20. 17:43:26 0 
1 0 117 19641 80000 2011.10.20. 17:43:37 0 
1 0 116 19642 80000 2011.10.20. 17:44:14 0 
1 0 124 19642 80000 2011.10.20. 17:44:50 0 
1 0 126 19550 80000 2011.10.20. 17:45:29 0 
1 0 114 19641 80000 2011.10.20. 17:46:09 0 
1 0 113 19641 80000 2011.10.20. 17:46:46 0 
3 0 222 23934 80000 2011.10.20. 17:47:11 0 
1 0 122 19643 80000 2011.10.20. 17:47:22 0 
3 0 220 19640 80000 2011.10.20. 17:47:53 0 
1 0 121 19643 80000 2011.10.20. 17:48:07 0 
3 0 215 19640 80000 2011.10.20. 17:48:54 0 
1 0 120 19643 80000 2011.10.20. 17:49:10 0 
3 0 213 19640 80000 2011.10.20. 17:49:48 0 
1 0 119 19643 80000 2011.10.20. 17:49:54 0 
1 0 112 19641 80000 2011.10.20. 17:50:44 0 
3 0 211 19640 80000 2011.10.20. 17:50:59 0 
1 0 111 19641 80000 2011.10.20. 17:51:23 0 
3 0 210 19640 80000 2011.10.20. 17:51:48 0 
1 0 115 19642 80000 2011.10.20. 17:52:27 0 
1 0 123 19642 80000 2011.10.20. 17:53:17 0 
3 0 219 19640 80000 2011.10.20. 17:53:27 0 
3 0 217 19640 80000 2011.10.20. 17:55:13 0 
1 0 110 19643 80000 2011.10.20. 17:56:16 0 
3 0 218 19640 80000 2011.10.20. 17:56:34 0 
3 0 216 19640 80000 2011.10.20. 17:57:10 0 
1 0 109 19643 80000 2011.10.20. 17:57:54 0 
3 0 214 19640 80000 2011.10.20. 17:58:15 0 
3 0 212 19640 80000 2011.10.20. 17:59:14 0 
3 0 223 19640 80000 2011.10.20. 17:59:51 0 
3 0 209 19640 80000 2011.10.20. 18:00:30 0 
3 0 208 19640 80000 2011.10.20. 18:01:29 0 
3 0 207 19640 80000 2011.10.20. 18:02:15 0 
6 0 167 19640 80000 2011.10.20. 18:02:20 0 
3 0 206 23933 80000 2011.10.20. 18:02:56 0 
6 0 171 19640 80000 2011.10.20. 18:03:36 0 
3 0 205 23933 80000 2011.10.20. 18:03:45 0 
3 0 204 23933 80000 2011.10.20. 18:04:25 0 
3 0 203 23933 80000 2011.10.20. 18:05:10 0 
6 0 169 23932 80000 2011.10.20. 18:05:16 0 
6 0 168 23932 80000 2011.10.20. 18:05:55 0 
6 0 166 19640 80000 2011.10.20. 18:06:32 0 
6 0 156 19640 80000 2011.10.20. 18:07:08 0 
6 0 162 23932 80000 2011.10.20. 18:07:49 0 
6 0 163 23932 80000 2011.10.20. 18:08:27 0 
6 0 164 23932 80000 2011.10.20. 18:09:04 0 
6 0 165 23932 80000 2011.10.20. 18:09:47 0 
6 0 170 19640 80000 2011.10.20. 18:10:29 0 
6 0 161 19640 80000 2011.10.20. 18:11:13 0 
6 0 157 19640 80000 2011.10.20. 18:11:59 0 
6 0 160 19640 80000 2011.10.20. 18:12:36 0 
6 0 158 23932 80000 2011.10.20. 18:13:14 0 
6 0 159 23932 80000 2011.10.20. 18:13:59 0
Add New Custom Teleport

ูƒูˆุฏ:
USE SRO_VT_SHARD 


DECLARE @Teleport VARCHAR (64) 
DECLARE @CHARNAME1 VARCHAR (30) 
DECLARE @CHARNAME2 VARCHAR (30) 
DECLARE @OwnTeleport INT 
DECLARE @Fee INT 
DECLARE @RequiredLVL INT 

/* Put your settings here */ 
SET @Teleport = 'swagger_area1' -- any name you want ex: PK_ZONE or PVP_ZONE 
SET @CHARNAME1 = '[GM]Swagger1337' -- Teleport position 
SET @CHARNAME2 = 'Swagger2' -- Spawn position after teleport 
SET @OwnTeleport = 1  -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople 
SET @Fee = 50000  -- Gold amount to Pass the teleport 
SET @RequiredLVL = 0  -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport 
/* settings area end here */ 

IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport) 
 BEGIN 
  raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport); 
  RETURN; 
 END 
     
    DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1 
    DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1) 
    DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1) 
    DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1) 
    DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1) 
    DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1 
      
    SET IDENTITY_INSERT _RefObjCommon ON 
    INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES 
    (1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\ins_quest_teleport.bsr','xxx','xxx','xxx','xxx',@link) 
    SET IDENTITY_INSERT _RefObjCommon OFF 
     
    print '' 
    print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder' 
    print '1    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'STORE_'+@Teleport+'    '+@Teleport+'    xxx    '+'SN_STORE_'+@Teleport+'    xxx    0    0    4    1    1    0    0    3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    '+CONVERT(varchar(max),@REGION1)+'    0    '+CONVERT(varchar(max),@POSX1)+'    '+CONVERT(varchar(max),@POSY1)+'    '+CONVERT(varchar(max),@POSZ1)+'    0    0    50    50    30    0    quest\teleport01.bsr    xxx    xxx    xxx    xxx    '+CONVERT(varchar(max),@link) 
    print '' 
    print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder' 
    print '' 
    print '1    '+'SN_STORE_'+@Teleport+'                                '+@Teleport 
    print '' 
      print '' 

  SET IDENTITY_INSERT _RefObjStruct ON 
  INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES 
  (@LINK,0) 
  SET IDENTITY_INSERT _RefObjStruct OFF 
   
  DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1 
  DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2) 
  DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2) 
  DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2) 
  DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2) 
  DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2) 

  INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES 
  (1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0) 
   
  print '' 
  print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder' 
  print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+'GATE_'+@Teleport+'    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'SN_STORE_'+@Teleport+'    '+CONVERT(varchar(max),@REGION2)+'    '+CONVERT(varchar(max),@POSX2)+'    '+CONVERT(varchar(max),@POSY2)+'    '+CONVERT(varchar(max),@POSZ2)+'    30    0    0    '+CONVERT(varchar(max),@WORLDID)+'    1    0' 
  print '' 
  print '' 

  IF @RequiredLVL = 0 
  BEGIN 
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES 
    (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) 
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES 
    (1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) 
     
print '' 
    print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder' 
    print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0' 
    print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0' 
    print '' 
  END 
  ELSE BEGIN 
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES 
    (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0) 
     
    print '' 
    print '' 
    print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder' 
    print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    1    '+CONVERT(varchar(max),@RequiredLVL)+'    999    0    0    0    0    0    0    0    0    0    0    0    0' 
    print '' 

  END 

print '' 
print 'Done!e'
Add Dg12 / Dg13 Items

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO

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
Addd 120 Skills

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO

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
Move Table From Database To Other Database

ูƒูˆุฏ:
USE SRO_VT_SHARD 
GO   
TRUNCATE TABLE [dbo].[_RefObjItem]   
GO   
insert into SRO_VT_SHARD.dbo._RefObjItem select * from SRO_VT_SHARD1.dbo._RefObjItem
Change Max Stack.

ูƒูˆุฏ:
USE [SRO_VT_SHARD]7
GO

UPDATE dbo._RefObjItem
SET MaxStack = 50 --Change 50 to your stack need
WHERE ID BETWEEN 3679 AND 3682

--warning! you need to change it in media.pk2

SQL Script For Media.pk2

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_GetMediaLines]    Script Date: 02/05/2012 12:42:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE  procedure  [dbo].[_GetMediaLines]

@Type SMALLINT,
@CodeName VARCHAR(30)

AS

IF(@Type=1)
BEGIN
    SELECT 
    _RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,
    _RefObjItem.MaxStack,_RefObjItem.ReqGender,_RefObjItem.ReqStr,_RefObjItem.ReqInt,_RefObjItem.ItemClass,_RefObjItem.SetID,_RefObjItem.Dur_L,_RefObjItem.Dur_U,_RefObjItem.PD_L,_RefObjItem.PD_U,_RefObjItem.PDInc,_RefObjItem.ER_L,_RefObjItem.ER_U,_RefObjItem.ERInc,_RefObjItem.PAR_L,_RefObjItem.PAR_U,_RefObjItem.PARInc,_RefObjItem.BR_L,_RefObjItem.BR_U,_RefObjItem.MD_L,_RefObjItem.MD_U,_RefObjItem.MDInc,_RefObjItem.MAR_L,_RefObjItem.MAR_U,_RefObjItem.MARInc,_RefObjItem.PDStr_L,_RefObjItem.PDStr_U,_RefObjItem.MDInt_L,_RefObjItem.MDInt_U,_RefObjItem.Quivered,_RefObjItem.Ammo1_TID4,_RefObjItem.Ammo2_TID4,_RefObjItem.Ammo3_TID4,_RefObjItem.Ammo4_TID4,_RefObjItem.Ammo5_TID4,_RefObjItem.SpeedClass,_RefObjItem.TwoHanded,_RefObjItem.Range,_RefObjItem.PAttackMin_L,_RefObjItem.PAttackMin_U,_RefObjItem.PAttackMax_L,_RefObjItem.PAttackMax_U,_RefObjItem.PAttackInc,_RefObjItem.MAttackMin_L,_RefObjItem.MAttackMin_U,_RefObjItem.MAttackMax_L,_RefObjItem.MAttackMax_U,_RefObjItem.MAttackInc,_RefObjItem.PAStrMin_L,_RefObjItem.PAStrMin_U,_RefObjItem.PAStrMax_L,_RefObjItem.PAStrMax_U,_RefObjItem.MAInt_Min_L,_RefObjItem.MAInt_Min_U,_RefObjItem.MAInt_Max_L,_RefObjItem.MAInt_Max_U,_RefObjItem.HR_L,_RefObjItem.HR_U,_RefObjItem.HRInc,_RefObjItem.CHR_L,_RefObjItem.CHR_U,_RefObjItem.Param1,_RefObjItem.Desc1_128,_RefObjItem.Param2,_RefObjItem.Desc2_128,_RefObjItem.Param3,_RefObjItem.Desc3_128,_RefObjItem.Param4,_RefObjItem.Desc4_128,_RefObjItem.Param5,_RefObjItem.Desc5_128,_RefObjItem.Param6,_RefObjItem.Desc6_128,_RefObjItem.Param7,_RefObjItem.Desc7_128,_RefObjItem.Param8,_RefObjItem.Desc8_128,_RefObjItem.Param9,_RefObjItem.Desc9_128,_RefObjItem.Param10,_RefObjItem.Desc10_128,_RefObjItem.Param11,_RefObjItem.Desc11_128,_RefObjItem.Param12,_RefObjItem.Desc12_128,_RefObjItem.Param13,_RefObjItem.Desc13_128,_RefObjItem.Param14,_RefObjItem.Desc14_128,_RefObjItem.Param15,_RefObjItem.Desc15_128,_RefObjItem.Param16,_RefObjItem.Desc16_128,_RefObjItem.Param17,_RefObjItem.Desc17_128,_RefObjItem.Param18,_RefObjItem.Desc18_128,_RefObjItem.Param19,_RefObjItem.Desc19_128,_RefObjItem.Param20,_RefObjItem.Desc20_128,_RefObjItem.MaxMagicOptCount,_RefObjItem.ChildItemCount
    FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link=_RefObjItem.ID
    WHERE _RefObjCommon.CodeName128 LIKE @CodeName AND _RefObjCommon.Service=1 ORDER BY _RefObjCommon.ID ASC
END
IF(@Type=2)
    BEGIN
    SELECT 
    _RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,
    _RefObjChar.Lvl,_RefObjChar.CharGender,_RefObjChar.MaxHP,_RefObjChar.MaxMP,_RefObjChar.InventorySize,_RefObjChar.CanStore_TID1,_RefObjChar.CanStore_TID2,_RefObjChar.CanStore_TID3,_RefObjChar.CanStore_TID4,_RefObjChar.CanBeVehicle,_RefObjChar.CanControl,_RefObjChar.DamagePortion,_RefObjChar.MaxPassenger,_RefObjChar.AssocTactics,_RefObjChar.PD,_RefObjChar.MD,_RefObjChar.PAR,_RefObjChar.MAR,_RefObjChar.ER,_RefObjChar.BR,_RefObjChar.HR,_RefObjChar.CHR,_RefObjChar.ExpToGive,_RefObjChar.CreepType,_RefObjChar.Knockdown,_RefObjChar.KO_RecoverTime,_RefObjChar.DefaultSkill_1,_RefObjChar.DefaultSkill_2,_RefObjChar.DefaultSkill_3,_RefObjChar.DefaultSkill_4,_RefObjChar.DefaultSkill_5,_RefObjChar.DefaultSkill_6,_RefObjChar.DefaultSkill_7,_RefObjChar.DefaultSkill_8,_RefObjChar.DefaultSkill_9,_RefObjChar.DefaultSkill_10,_RefObjChar.TextureType,_RefObjChar.Except_1,_RefObjChar.Except_2,_RefObjChar.Except_3,_RefObjChar.Except_4,_RefObjChar.Except_5,_RefObjChar.Except_6,_RefObjChar.Except_7,_RefObjChar.Except_8,_RefObjChar.Except_9,_RefObjChar.Except_10
    FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link=_RefObjChar.ID WHERE CodeName128 LIKE @CodeName AND _RefObjCommon.Service=1 ORDER BY _RefObjCommon.ID ASC
END

IF(@Type!=1 OR @Type!=2)
BEGIN
    PRINT 'The Type must be 1 OR 2!'
    PRINT 'Use @Type=1 for Items'
    PRINT 'Use @Type=2 for Characters'
END
Get Media.pk2 / itemdata_xxxx.txt

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
exec _GetMediaLines
@Type=1,
@CodeName='ITEM_CH_SWORD_01%'
/* or ITEM_CH_SWORD_01_A << For 1 Item WithOut %*/
Get Media.pk2 / Characterdata_xxxx.txt

ูƒูˆุฏ:
USE [SRO_VT_SHARD]

exec _GetMediaLines
@Type=2,
@CodeName='MOB_FW_WHITETIGER_%'
/* or MOB_FW_WHITETIGER_001 << For 1 Item WithOut %*/
Remove EU Drop

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO  

UPDATE dbo._RefDropItemAssign  
SET DropCount = 0  
WHERE RefItemID BETWEEN 14181 AND 14869  

UPDATE dbo._RefDropItemAssign  
SET DropCount = 0  
WHERE RefItemID BETWEEN 12844 AND 14180  

UPDATE dbo._RefDropItemAssign  
SET DropCount = 0  
WHERE RefItemID BETWEEN 11417 AND 12843  

UPDATE dbo._RefDropItemAssign  
SET DropCount = 0  
WHERE RefItemID BETWEEN 10897 AND 11416  


UPDATE dbo._RefDropItemAssign  
SET Prob_Absolute = 0  
WHERE RefItemID BETWEEN 14181 AND 14869  

UPDATE dbo._RefDropItemAssign  
SET Prob_Absolute = 0  
WHERE RefItemID BETWEEN 12844 AND 14180  

UPDATE dbo._RefDropItemAssign  
SET Prob_Absolute = 0  
WHERE RefItemID BETWEEN 11417 AND 12843  

UPDATE dbo._RefDropItemAssign  
SET Prob_Absolute = 0  
WHERE RefItemID BETWEEN 10897 AND 11416  



UPDATE dbo._RefDropItemAssign  
SET Prob_Relative = 0  
WHERE RefItemID BETWEEN 14181 AND 14869  

UPDATE dbo._RefDropItemAssign  
SET Prob_Relative = 0  
WHERE RefItemID BETWEEN 12844 AND 14180  

UPDATE dbo._RefDropItemAssign  
SET Prob_Relative = 0  
WHERE RefItemID BETWEEN 11417 AND 12843  

UPDATE dbo._RefDropItemAssign  
SET Prob_Relative = 0  
WHERE RefItemID BETWEEN 10897 AND 11416

Disable EU

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO

UPDATE _RefObjCommon SET Service = '0' WHERE ID >= 14875 and ID <= 14900
UPDATE _RefCharGen SET Service = '0' WHERE RefObjID >= 14875 and RefObjID <= 14900

--you must download this file and import to your data.pk2. to delete EU.bsr skin from creater characters.

-- link : https://mega.nz/#!KFwQVbCD!Af9gIcxPc-4YoFKq0DCF9QoclCigxlaTv7UNARt334I
How To Add New NPC

[COLOR="Red"][SIZE="4"]First thing ...
make this steeps

ูƒูˆุฏ:
How to use this queries ?

SQL ==> Tools ==> Options ==> Designers ==> Perevnt Saving Changes the require table re-creation (Remove Mark)

SQL ==> SRO_VT_SHARD ==> Tables 
RefPackageItem
Design ==> right click ID Column Set a primary key ==> Column Properties ==> Indetity Spercification ==> Set it Off


SQL ==> SRO_VT_SHARD ==> Tables 
RefScrapOfPackageItem
Design ==> right click ID Column Set a primary key ==> Column Properties ==> Indetity Spercification ==> [ Index ] ==> Set it Off


RefObjCommon > Design > right click ID Column Set a primary key > Column Properties > Indetity Spercification > (Is Indetity) set "Yes" same with the others. 

Then

Tab_RefHive and Tab_RefNest BUT SET INDENTITY OFF
Add New NPC

ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO

DECLARE @CHARNAME VARCHAR (30) 
DECLARE @NPCNAME VARCHAR (30) 
DECLARE @ADDNEW VARCHAR (30) 
DECLARE @GAMEWORDID INT 
SET @CHARNAME = 'Swagger1337' --Your Charname to set npc location 
SET @NPCNAME = 'SwaggerNPC' --Your New Npc Name
SET @GAMEWORDID = 1 --Leave it 1 if you dont know what you make! 
SET @ADDNEW = 'NPC' 
-- 
IF @ADDNEW = 'NPC' BEGIN 
DECLARE @MAXLINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1 
DECLARE @MAXCOMMONID VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjCommon)+1 
SET IDENTITY_INSERT _RefObjCommon ON 
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country 
,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius 
,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES 
(1,@MAXCOMMONID,'NPC_'+@NPCNAME,'xxx','xxx','SN_NPC_'+@NPCNAME,'xxx',0,1,1,2,2,0,5000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'npc\npc\chinawoman_Noblegirl_event.bsr','xxx','xxx','xxx','xxx',@MAXLINK) 
SET IDENTITY_INSERT _RefObjCommon OFF 
SET IDENTITY_INSERT _RefObjChar ON 
INSERT INTO _RefObjChar (ID,Lvl,CharGender,MaxHP,MaxMP,ResistFrozen,ResistFrostbite,ResistBurn,ResistEShock,ResistPoison,ResistZombie,ResistSleep,ResistRoot,ResistSlow,ResistFear 
,ResistMyopia,ResistBlood,ResistStone,ResistDark,ResistStun,ResistDisea,ResistChaos,ResistCsePD,ResistCseMD,ResistCseSTR,ResistCseINT,ResistCseHP,ResistCseMP,Resist24,ResistBomb,Resist26 
,Resist27,Resist28,Resist29,Resist30,Resist31,Resist32,InventorySize,CanStore_TID1,CanStore_TID2,CanStore_TID3,CanStore_TID4,CanBeVehicle,CanControl,DamagePortion,MaxPassenger,AssocTactics,PD,MD,PAR,MAR,ER,BR,HR,CHR 
,ExpToGive,CreepType,Knockdown,KO_RecoverTime,DefaultSkill_1,DefaultSkill_2,DefaultSkill_3,DefaultSkill_4,DefaultSkill_5,DefaultSkill_6,DefaultSkill_7,DefaultSkill_8,DefaultSkill_9,DefaultSkill_10,TextureType,Except_1 
,Except_2,Except_3,Except_4,Except_5,Except_6,Except_7,Except_8,Except_9,Except_10,Link) VALUES 
(@MAXLINK,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,336860180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) 
SET IDENTITY_INSERT _RefObjChar OFF 
SET IDENTITY_INSERT _RefShop ON 
DECLARE @ShopID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShop)+1 
INSERT INTO _RefShop (Service,Country,ID,CodeName128,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 
VALUES (1,15,@ShopID,'STORE_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') 
SET IDENTITY_INSERT _RefShop OFF 
SET IDENTITY_INSERT _RefShopGroup ON 
DECLARE @ShopGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopGroup)+1 
INSERT INTO _RefShopGroup (Service,Country,ID,CodeName128,RefNPCCodeName,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 
VALUES (1,15,@ShopGroupID,'GROUP_STORE_'+@NPCNAME,'NPC_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') 
SET IDENTITY_INSERT _RefShopGroup OFF 
SET IDENTITY_INSERT _RefShopItemGroup ON 
DECLARE @ShopItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1 
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group) 
VALUES (1,@ShopItemID,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1') 
SET IDENTITY_INSERT _RefShopItemGroup OFF 
SET IDENTITY_INSERT _RefShopTab ON 
DECLARE @ShopTabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1 
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) 
VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_Stones') 
SET IDENTITY_INSERT _RefShopTab OFF 
SET IDENTITY_INSERT _RefShopTabGroup ON 
DECLARE @ShopTabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) 
VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1') 
SET IDENTITY_INSERT _RefShopTabGroup OFF 
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_'+@NPCNAME,'STORE_'+@NPCNAME) 
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+'_GROUP1') 
DECLARE @TACTICSID INT SET @TACTICSID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10 
INSERT INTO Tab_RefTactics VALUES 
(@TACTICSID,@MAXCOMMONID,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'NPC_'+@NPCNAME) 
BEGIN
DECLARE @HIVEID INT  SET @HIVEID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 
INSERT INTO Tab_RefHive VALUES 
(@HIVEID,0,0,0,0,0,0,@GAMEWORDID,2,'NPC_'+@NPCNAME) 
END
BEGIN
DECLARE @REGION VARCHAR (30) SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @NESTID INT SET @NESTID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 
INSERT INTO Tab_RefNest VALUES 
(@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0) 
END
PRINT 'add this line to characterdata_45000 @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    '+@MAXCOMMONID+'    '+@NPCNAME+'    xxx    xxx    '+'SN_NPC_'+@NPCNAME+'    xxx    0    1    1    2    2    0    5000    3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    npc\npc\chinawoman_Noblegirl_event.bsr    xxx    xxx    xxx    xxx    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    336860180    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0' 
PRINT '' 
PRINT 'Add this line to refshop.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    15    '+@SHOPID+'    '+'STORE_'+@NPCNAME+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx' 
PRINT '' 
PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    15    '+@SHOPGROUPID+'    '+'GROUP_STORE_'+@NPCNAME+'    '+'NPC_'+@NPCNAME+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx' 
PRINT '' 
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    '+@SHOPITEMID+'    '+'STORE_'+@NPCNAME+'_GROUP1    '+'SN_STORE_'+@NPCNAME+'_GROUP1' 
PRINT '' 
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    15    '+@SHOPTABID+'    '+'STORE_'+@NPCNAME+'_TAB1    '+'STORE_'+@NPCNAME+'_GROUP1     SN_TAB_Stones' 
PRINT '' 
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    15    '+@SHOPTABGROUPID+'    '+'STORE_'+@NPCNAME+'_GROUP1    '+'SN_STORE_'+@NPCNAME+'_GROUP1' 
PRINT '' 
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    15    '+'GROUP_STORE_'+@NPCNAME+'    '+'STORE_'+@NPCNAME 
PRINT '' 
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata' 
PRINT '' 
PRINT '1    15    '+'STORE_'+@NPCNAME+'    '+'STORE_'+@NPCNAME+'_GROUP1'
Add New Group

ูƒูˆุฏ:
USE SRO_VT_SHARD
GO

DECLARE @NPCNAME VARCHAR (30)
DECLARE @ADDNEW VARCHAR (30)
DECLARE @GROUPNUMBER VARCHAR (30) 
DECLARE @GROUPNEW VARCHAR (30)
SET @NPCNAME = 'STATIC' --U NPC NAME
SET @GROUPNUMBER  = 2
SET @ADDNEW = 'GROUP'
--
IF @GROUPNUMBER  = 2 SET @GROUPNEW = '_GROUP2'
IF @GROUPNUMBER  = 3 SET @GROUPNEW = '_GROUP3'
IF @GROUPNUMBER  = 4 SET @GROUPNEW = '_GROUP4'
IF @GROUPNUMBER  = 5 SET @GROUPNEW = '_GROUP5'
IF @GROUPNUMBER  = 6 SET @GROUPNEW = '_GROUP6'
IF @ADDNEW = 'GROUP' BEGIN 
SET IDENTITY_INSERT _RefShopTabGroup ON
DECLARE @ShopTabGroupID VARCHAR (30) SET @ShopTabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+@GROUPNEW,'SN_STORE_'+@NPCNAME+@GROUPNEW)
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+@GROUPNEW)
PRINT ''
PRINT 'New Group Added Succesfully '
PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT '1    15    '+@SHOPTABGROUPID+'    STORE_'+@NPCNAME+@GROUPNEW+'    SN_STORE_'+@NPCNAME+@GROUPNEW
PRINT ''
PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT '1    15    STORE_'+@NPCNAME+'    STORE_'+@NPCNAME+@GROUPNEW
END
Add New TAB


ูƒูˆุฏ:
USE [SRO_VT_SHARD]
GO

DECLARE @NPCNAME VARCHAR (30)
DECLARE @ADDNEW VARCHAR (30)
DECLARE @TABNAME VARCHAR (30)
DECLARE @TABNUMBER VARCHAR (30) 
DECLARE @TABNEW VARCHAR (30)
DECLARE @GROUPNUMBER VARCHAR (30) 
DECLARE @GROUPNEW VARCHAR (30)
--
SET @ADDNEW = 'TAB' --Do Not Change Please!
SET @NPCNAME = 'Avatars Mall' --Your NPC name who you need to make tab for it
SET @GROUPNUMBER  = 1 --Leave it please!
SET @TABNUMBER = 2 --which tab ? if it 1 type 1 if it 2 type 2 max 4 tabs.
SET @TABNAME = 'Euro' --the new tab name ?
--
IF @TABNUMBER = 2 SET @TABNEW = '_TAB2'
IF @TABNUMBER = 3 SET @TABNEW = '_TAB3'
IF @TABNUMBER = 4 SET @TABNEW = '_TAB4'
IF @GROUPNUMBER = 1 SET @GROUPNEW = '_GROUP1'
IF @GROUPNUMBER  = 2 SET @GROUPNEW = '_GROUP2'
IF @GROUPNUMBER  = 3 SET @GROUPNEW = '_GROUP3'
IF @GROUPNUMBER  = 4 SET @GROUPNEW = '_GROUP4'
IF @GROUPNUMBER  = 5 SET @GROUPNEW = '_GROUP5'
IF @GROUPNUMBER  = 6 SET @GROUPNEW = '_GROUP6'
IF @ADDNEW = 'TAB' BEGIN
SET IDENTITY_INSERT _RefShopTab ON
DECLARE @ShopTabID VARCHAR (30) SET @ShopTabID = (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+@TABNEW,'STORE_'+@NPCNAME+@GROUPNEW,'SN_'+@TABNAME)
SET IDENTITY_INSERT _RefShopTab OFF
PRINT ''
PRINT 'New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata' 
PRINT '1    15    '+@SHOPTABID+'    STORE_'+@NPCNAME+@TABNEW+'    STORE_'+@NPCNAME+@GROUPNEW+'     SN_TAB_'+@TABNAME
END

. 1- If you want to remove the premium from one you have on the server

USE SRO_VT_SHARD
GO
DECLARE @CharName Varchar (MAX)
DECLARE @
CharID INT
SET        
@CharName 'Char Name'
SET        @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
DELETE FROM _TimedJob WHERE CharID = @CharID 
2-If you want to remove the PK from someone
USE [SRO_VT_SHARD]
DECLARE @
CharName Varchar(max)
SET @CharName 'Char Name'

UPDATE _Char SET
RemainHwanCount 
5,
DailyPK0,
TotalPK0,
PKPenaltyPoint0
WHERE CharName16 
= @CharName 
3-If you want to give one title name

USE SRO_VT_SHARD

Declare @CharNick varchar(64)
Declare @
Hwanlvl tinyint

SET 
@CharNick 'Char Name'    --Your Ingame Nick
SET 
@Hwanlvl 'Rkm al Title'    --Your desired Hwan Title e.g

/* Hwan Title Explanation:
CH '1'    Captain
CH '2'    General
CH '3'    Senior General
CH '4'    Chief General
CH '5'    Vice General Lord
CH '6'    General Lord
EU '1'    Knight
EU '2'    Baronet
EU '3'    Baron
EU '4'    Count
EU '5'    Marquis
EU '6'    Duke    */

UPDATE dbo._Char
SET HwanLevel 
= @Hwanlvl
WHERE CharName16 like 
@CharNick 
4- If you have a title name, for example, and you want to know who has this title on the server


Use SRO_VT_SHARD Select CharName16 From dbo._Char Where HwanLevel Like 'Rkm al Title' 
5-If you want to remove an item from all people

PHP code:
USE [SRO_VT_SHARD]

Exec [dbo].[_SEEK_N_DESTROY_ITEM]  ['item code' 
6-If you want to make all people jangan


USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion25000posX982 posY= -0.421872 ,posZ140 ,AppointedTeleport=27754,TelRegion0TelPosX0TelPosY0TelPosZ0
DiedRegion,DiedPosX,DiedPosY0DiedPosZ0WorldID1 WHERE CharID>= 
7-If you want to add an item to your char

PHP code:
USE SRO_VT_SHARD
--Usage:
--
exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64

set @CharName 'Char Name'

exec _ADD_ITEM_EXTERN @CharName,'code item',100,
8-If you want to erase your fortress

PHP code:
USE SRO_VT_SHARD 
UPDATE _SiegeFortress SET GuildID 

9-If you want to convert moob to unique


USE SRO_VT_SHARD 
GO 

update _RefObjCommon set Rarity 
3 where CodeName128 'Code Moob' 

Print 'Mob has been changed to unique' 
10-If you want to get the ID of something you have
PHP code:
Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'Code Here' 
11- If you want people with you after you leave the guild, you can teleport and go to the guild again


USE [SRO_VT_SHARD
GO 
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 06/14/2014 19:29:37 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 

ALTER   procedure 
[dbo].[_AddTimedJob
@
CharID            int
@
Category        tinyint
@
JobID            int
@
TimeToKeep    int
@
Data1            int
@
Data2            int
--
##begin due to develop composite item 
@Data3            int
@
Data4            int
@
Data5            int
@
Data6            int
@
Data7            int
@
Data8            int
@
Serial64        bigint
@
JID            int 
--##end due to develop composite item 
as 
    if (
not exists (select CharID from _Char with (nolockwhere CharID = @CharID)) 
                return -

            
if (@TimeToKeep <= 0
                return -

            
declare @NewJobID int 
            set 
@NewJobID 

            
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader 
            
--##If you want to only have one not both, then just modify the line below! 
            
if (@JobID or @JobID 2
            
BEGIN 
                
return -
            END 
            
ELSE 
            
BEGIN 
            
--##begin due to develop composite item 
            
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID
            
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID
            
END 
            
--##end due to develop composite item 
            
set @NewJobID = @@identity 
            
if (@@error <> or @@rowcount 0
                 
                return -

     
return @NewJobID 
12-If you want to unlock all the skills, be an account


USE SRO_VT_SHARD
DECLARE @CharName varchar(255)
DECLARE @
CharID INT

SET 
@CharName='char name'

SELECT @CharID CharID FROM _Char WHERE CharName16=@CharName

UPDATE _CharSkillMastery SET Level 
'120' WHERE CharID=@CharID

INSERT INTO _CharSkill VALUES 
(@CharID,1,1)
INSERT INTO _CharSkill VALUES (@CharID,2,1)
INSERT INTO _CharSkill VALUES (@CharID,40,1)
INSERT INTO _CharSkill VALUES (@CharID,70,1)
INSERT INTO _CharSkill VALUES (@CharID,298,1)
INSERT INTO _CharSkill VALUES (@CharID,306,1)
INSERT INTO _CharSkill VALUES (@CharID,314,1)
INSERT INTO _CharSkill VALUES (@CharID,322,1)
INSERT INTO _CharSkill VALUES (@CharID,346,1)
INSERT INTO _CharSkill VALUES (@CharID,378,1)
INSERT INTO _CharSkill VALUES (@CharID,418,1)
INSERT INTO _CharSkill VALUES (@CharID,463,1)
INSERT INTO _CharSkill VALUES (@CharID,558,1)
INSERT INTO _CharSkill VALUES (@CharID,569,1)
INSERT INTO _CharSkill VALUES (@CharID,580,1)
INSERT INTO _CharSkill VALUES (@CharID,588,1)
INSERT INTO _CharSkill VALUES (@CharID,596,1)
INSERT INTO _CharSkill VALUES (@CharID,604,1)
INSERT INTO _CharSkill VALUES (@CharID,647,1)
INSERT INTO _CharSkill VALUES (@CharID,655,1)
INSERT INTO _CharSkill VALUES (@CharID,672,1)
INSERT INTO _CharSkill VALUES (@CharID,689,1)
INSERT INTO _CharSkill VALUES (@CharID,699,1)
INSERT INTO _CharSkill VALUES (@CharID,708,1)
INSERT INTO _CharSkill VALUES (@CharID,716,1)
INSERT INTO _CharSkill VALUES (@CharID,724,1)
INSERT INTO _CharSkill VALUES (@CharID,735,1)
INSERT INTO _CharSkill VALUES (@CharID,746,1)
INSERT INTO _CharSkill VALUES (@CharID,757,1)
INSERT INTO _CharSkill VALUES (@CharID,765,1)
INSERT INTO _CharSkill VALUES (@CharID,773,1)
INSERT INTO _CharSkill VALUES (@CharID,781,1)
INSERT INTO _CharSkill VALUES (@CharID,789,1)
INSERT INTO _CharSkill VALUES (@CharID,797,1)
INSERT INTO _CharSkill VALUES (@CharID,805,1)
INSERT INTO _CharSkill VALUES (@CharID,813,1)
INSERT INTO _CharSkill VALUES (@CharID,821,1)
INSERT INTO _CharSkill VALUES (@CharID,829,1)
INSERT INTO _CharSkill VALUES (@CharID,853,1)
INSERT INTO _CharSkill VALUES (@CharID,885,1)
INSERT INTO _CharSkill VALUES (@CharID,925,1)
INSERT INTO _CharSkill VALUES (@CharID,933,1)
INSERT INTO _CharSkill VALUES (@CharID,943,1)
INSERT INTO _CharSkill VALUES (@CharID,952,1)
INSERT INTO _CharSkill VALUES (@CharID,960,1)
INSERT INTO _CharSkill VALUES (@CharID,968,1)
INSERT INTO _CharSkill VALUES (@CharID,976,1)
INSERT INTO _CharSkill VALUES (@CharID,984,1)
INSERT INTO _CharSkill VALUES (@CharID,992,1)
INSERT INTO _CharSkill VALUES (@CharID,1003,1)
INSERT INTO _CharSkill VALUES (@CharID,1014,1)
INSERT INTO _CharSkill VALUES (@CharID,1025,1)
INSERT INTO _CharSkill VALUES (@CharID,1033,1)
INSERT INTO _CharSkill VALUES (@CharID,1041,1)
INSERT INTO _CharSkill VALUES (@CharID,1049,1)
INSERT INTO _CharSkill VALUES (@CharID,1053,1)
INSERT INTO _CharSkill VALUES (@CharID,1057,1)
INSERT INTO _CharSkill VALUES (@CharID,1065,1)
INSERT INTO _CharSkill VALUES (@CharID,1073,1)
INSERT INTO _CharSkill VALUES (@CharID,1081,1)
INSERT INTO _CharSkill VALUES (@CharID,1089,1)
INSERT INTO _CharSkill VALUES (@CharID,1099,1)
INSERT INTO _CharSkill VALUES (@CharID,1108,1)
INSERT INTO _CharSkill VALUES (@CharID,1116,1)
INSERT INTO _CharSkill VALUES (@CharID,1124,1)
INSERT INTO _CharSkill VALUES (@CharID,1132,1)
INSERT INTO _CharSkill VALUES (@CharID,1140,1)
INSERT INTO _CharSkill VALUES (@CharID,1148,1)
INSERT INTO _CharSkill VALUES (@CharID,1153,1)
INSERT INTO _CharSkill VALUES (@CharID,1158,1)
INSERT INTO _CharSkill VALUES (@CharID,1163,1)
INSERT INTO _CharSkill VALUES (@CharID,1168,1)
INSERT INTO _CharSkill VALUES (@CharID,1173,1)
INSERT INTO _CharSkill VALUES (@CharID,1178,1)
INSERT INTO _CharSkill VALUES (@CharID,1189,1)
INSERT INTO _CharSkill VALUES (@CharID,1200,1)
INSERT INTO _CharSkill VALUES (@CharID,1217,1)
INSERT INTO _CharSkill VALUES (@CharID,1234,1)
INSERT INTO _CharSkill VALUES (@CharID,1244,1)
INSERT INTO _CharSkill VALUES (@CharID,1253,1)
INSERT INTO _CharSkill VALUES (@CharID,1261,1)
INSERT INTO _CharSkill VALUES (@CharID,1269,1)
INSERT INTO _CharSkill VALUES (@CharID,1271,1)
INSERT INTO _CharSkill VALUES (@CharID,1273,1)
INSERT INTO _CharSkill VALUES (@CharID,1275,1)
INSERT INTO _CharSkill VALUES (@CharID,1286,1)
INSERT INTO _CharSkill VALUES (@CharID,1297,1)
INSERT INTO _CharSkill VALUES (@CharID,1308,1)
INSERT INTO _CharSkill VALUES (@CharID,1316,1)
INSERT INTO _CharSkill VALUES (@CharID,1324,1)
INSERT INTO _CharSkill VALUES (@CharID,1332,1)
INSERT INTO _CharSkill VALUES (@CharID,1337,1)
INSERT INTO _CharSkill VALUES (@CharID,1342,1)
INSERT INTO _CharSkill VALUES (@CharID,1350,1)
INSERT INTO _CharSkill VALUES (@CharID,1358,1)
INSERT INTO _CharSkill VALUES (@CharID,1368,1)
INSERT INTO _CharSkill VALUES (@CharID,1377,1)
INSERT INTO _CharSkill VALUES (@CharID,1385,1)
INSERT INTO _CharSkill VALUES (@CharID,1393,1)
INSERT INTO _CharSkill VALUES (@CharID,1398,1)
INSERT INTO _CharSkill VALUES (@CharID,1403,1)
INSERT INTO _CharSkill VALUES (@CharID,1408,1)
INSERT INTO _CharSkill VALUES (@CharID,1410,1)
INSERT INTO _CharSkill VALUES (@CharID,1412,1)
INSERT INTO _CharSkill VALUES (@CharID,1414,1)
INSERT INTO _CharSkill VALUES (@CharID,1422,1)
INSERT INTO _CharSkill VALUES (@CharID,1430,1)
INSERT INTO _CharSkill VALUES (@CharID,1438,1)
INSERT INTO _CharSkill VALUES (@CharID,1443,1)
INSERT INTO _CharSkill VALUES (@CharID,1448,1)
INSERT INTO _CharSkill VALUES (@CharID,1465,1)
INSERT INTO _CharSkill VALUES (@CharID,1482,1)
INSERT INTO _CharSkill VALUES (@CharID,1499,1)
INSERT INTO _CharSkill VALUES (@CharID,1509,1)
INSERT INTO _CharSkill VALUES (@CharID,1518,1)
INSERT INTO _CharSkill VALUES (@CharID,1526,1)
INSERT INTO _CharSkill VALUES (@CharID,1534,1)
INSERT INTO _CharSkill VALUES (@CharID,1539,1)
INSERT INTO _CharSkill VALUES (@CharID,1544,1)
INSERT INTO _CharSkill VALUES (@CharID,1549,1)
INSERT INTO _CharSkill VALUES (@CharID,1557,1)
INSERT INTO _CharSkill VALUES (@CharID,1565,1)
INSERT INTO _CharSkill VALUES (@CharID,1573,1)
INSERT INTO _CharSkill VALUES (@CharID,1578,1)
INSERT INTO _CharSkill VALUES (@CharID,1583,1)
INSERT INTO _CharSkill VALUES (@CharID,1588,1)
INSERT INTO _CharSkill VALUES (@CharID,1593,1)
INSERT INTO _CharSkill VALUES (@CharID,1598,1)
INSERT INTO _CharSkill VALUES (@CharID,1609,1)
INSERT INTO _CharSkill VALUES (@CharID,1617,1)
INSERT INTO _CharSkill VALUES (@CharID,1628,1)
INSERT INTO _CharSkill VALUES (@CharID,3149,1)
INSERT INTO _CharSkill VALUES (@CharID,3167,1)
INSERT INTO _CharSkill VALUES (@CharID,3176,1)
INSERT INTO _CharSkill VALUES (@CharID,3224,1)
INSERT INTO _CharSkill VALUES (@CharID,3340,1)
INSERT INTO _CharSkill VALUES (@CharID,3349,1)
INSERT INTO _CharSkill VALUES (@CharID,3364,1)
INSERT INTO _CharSkill VALUES (@CharID,3379,1)
INSERT INTO _CharSkill VALUES (@CharID,3391,1)
INSERT INTO _CharSkill VALUES (@CharID,3406,1)
INSERT INTO _CharSkill VALUES (@CharID,3409,1)
INSERT INTO _CharSkill VALUES (@CharID,3415,1)
INSERT INTO _CharSkill VALUES (@CharID,3430,1)
INSERT INTO _CharSkill VALUES (@CharID,3431,1)
INSERT INTO _CharSkill VALUES (@CharID,3446,1)
INSERT INTO _CharSkill VALUES (@CharID,3461,1)
INSERT INTO _CharSkill VALUES (@CharID,3467,1)
INSERT INTO _CharSkill VALUES (@CharID,3473,1)
INSERT INTO _CharSkill VALUES (@CharID,7139,1)
INSERT INTO _CharSkill VALUES (@CharID,7159,1)
INSERT INTO _CharSkill VALUES (@CharID,7203,1)
INSERT INTO _CharSkill VALUES (@CharID,7322,1)
INSERT INTO _CharSkill VALUES (@CharID,7385,1)
INSERT INTO _CharSkill VALUES (@CharID,7390,1)
INSERT INTO _CharSkill VALUES (@CharID,7392,1)
INSERT INTO _CharSkill VALUES (@CharID,7404,1)
INSERT INTO _CharSkill VALUES (@CharID,7418,1)
INSERT INTO _CharSkill VALUES (@CharID,7474,1)
INSERT INTO _CharSkill VALUES (@CharID,7484,1)
INSERT INTO _CharSkill VALUES (@CharID,7513,1)
INSERT INTO _CharSkill VALUES (@CharID,7520,1)
INSERT INTO _CharSkill VALUES (@CharID,7536,1)
INSERT INTO _CharSkill VALUES (@CharID,7554,1)
INSERT INTO _CharSkill VALUES (@CharID,7577,1)
INSERT INTO _CharSkill VALUES (@CharID,7582,1)
INSERT INTO _CharSkill VALUES (@CharID,7584,1)
INSERT INTO _CharSkill VALUES (@CharID,7596,1)
INSERT INTO _CharSkill VALUES (@CharID,7612,1)
INSERT INTO _CharSkill VALUES (@CharID,7637,1)
INSERT INTO _CharSkill VALUES (@CharID,7651,1)
INSERT INTO _CharSkill VALUES (@CharID,7672,1)
INSERT INTO _CharSkill VALUES (@CharID,7675,1)
INSERT INTO _CharSkill VALUES (@CharID,7688,1)
INSERT INTO _CharSkill VALUES (@CharID,7798,1)
INSERT INTO _CharSkill VALUES (@CharID,7805,1)
INSERT INTO _CharSkill VALUES (@CharID,7829,1)
INSERT INTO _CharSkill VALUES (@CharID,7838,1)
INSERT INTO _CharSkill VALUES (@CharID,7839,1)
INSERT INTO _CharSkill VALUES (@CharID,7853,1)
INSERT INTO _CharSkill VALUES (@CharID,7862,1)
INSERT INTO _CharSkill VALUES (@CharID,7877,1)
INSERT INTO _CharSkill VALUES (@CharID,7881,1)
INSERT INTO _CharSkill VALUES (@CharID,7894,1)
INSERT INTO _CharSkill VALUES (@CharID,7899,1)
INSERT INTO _CharSkill VALUES (@CharID,7907,1)
INSERT INTO _CharSkill VALUES (@CharID,7919,1)
INSERT INTO _CharSkill VALUES (@CharID,7931,1)
INSERT INTO _CharSkill VALUES (@CharID,7938,1)
INSERT INTO _CharSkill VALUES (@CharID,7947,1)
INSERT INTO _CharSkill VALUES (@CharID,7953,1)
INSERT INTO _CharSkill VALUES (@CharID,7959,1)
INSERT INTO _CharSkill VALUES (@CharID,7962,1)
INSERT INTO _CharSkill VALUES (@CharID,7972,1)
INSERT INTO _CharSkill VALUES (@CharID,7980,1)
INSERT INTO _CharSkill VALUES (@CharID,7995,1)
INSERT INTO _CharSkill VALUES (@CharID,7997,1)
INSERT INTO _CharSkill VALUES (@CharID,8010,1)
INSERT INTO _CharSkill VALUES (@CharID,8024,1)
INSERT INTO _CharSkill VALUES (@CharID,8050,1)
INSERT INTO _CharSkill VALUES (@CharID,8084,1)
INSERT INTO _CharSkill VALUES (@CharID,8097,1)
INSERT INTO _CharSkill VALUES (@CharID,8103,1)
INSERT INTO _CharSkill VALUES (@CharID,8109,1)
INSERT INTO _CharSkill VALUES (@CharID,8115,1)
INSERT INTO _CharSkill VALUES (@CharID,8119,1)
INSERT INTO _CharSkill VALUES (@CharID,8129,1)
INSERT INTO _CharSkill VALUES (@CharID,8133,1)
INSERT INTO _CharSkill VALUES (@CharID,8142,1)
INSERT INTO _CharSkill VALUES (@CharID,8150,1)
INSERT INTO _CharSkill VALUES (@CharID,8164,1)
INSERT INTO _CharSkill VALUES (@CharID,8171,1)
INSERT INTO _CharSkill VALUES (@CharID,8183,1)
INSERT INTO _CharSkill VALUES (@CharID,8195,1)
INSERT INTO _CharSkill VALUES (@CharID,8204,1)
INSERT INTO _CharSkill VALUES (@CharID,8214,1)
INSERT INTO _CharSkill VALUES (@CharID,8220,1)
INSERT INTO _CharSkill VALUES (@CharID,8221,1)
INSERT INTO _CharSkill VALUES (@CharID,8238,1)
INSERT INTO _CharSkill VALUES (@CharID,8239,1)
INSERT INTO _CharSkill VALUES (@CharID,8250,1)
INSERT INTO _CharSkill VALUES (@CharID,8253,1)
INSERT INTO _CharSkill VALUES (@CharID,8276,1)
INSERT INTO _CharSkill VALUES (@CharID,8291,1)
INSERT INTO _CharSkill VALUES (@CharID,8304,1)
INSERT INTO _CharSkill VALUES (@CharID,8316,1)
INSERT INTO _CharSkill VALUES (@CharID,8320,1)
INSERT INTO _CharSkill VALUES (@CharID,8338,1)
INSERT INTO _CharSkill VALUES (@CharID,8347,1)
INSERT INTO _CharSkill VALUES (@CharID,8348,1)
INSERT INTO _CharSkill VALUES (@CharID,8361,1)
INSERT INTO _CharSkill VALUES (@CharID,8370,1)
INSERT INTO _CharSkill VALUES (@CharID,8379,1)
INSERT INTO _CharSkill VALUES (@CharID,8383,1)
INSERT INTO _CharSkill VALUES (@CharID,8390,1)
INSERT INTO _CharSkill VALUES (@CharID,8399,1)
INSERT INTO _CharSkill VALUES (@CharID,8405,1)
INSERT INTO _CharSkill VALUES (@CharID,8410,1)
INSERT INTO _CharSkill VALUES (@CharID,8414,1)
INSERT INTO _CharSkill VALUES (@CharID,8416,1)
INSERT INTO _CharSkill VALUES (@CharID,20494,1)
INSERT INTO _CharSkill VALUES (@CharID,20497,1)
INSERT INTO _CharSkill VALUES (@CharID,20500,1)
INSERT INTO _CharSkill VALUES (@CharID,21215,1)
INSERT INTO _CharSkill VALUES (@CharID,21217,1)
INSERT INTO _CharSkill VALUES (@CharID,30578,1)
INSERT INTO _CharSkill VALUES (@CharID,30584,1)
INSERT INTO _CharSkill VALUES (@CharID,30590,1)
INSERT INTO _CharSkill VALUES (@CharID,30596,1)
INSERT INTO _CharSkill VALUES (@CharID,30600,1
13-If you want to follow paths, do not specify

:
delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like 'item code'
and


USE SRO_VT_SHARD
DELETE _RefDropItemAssign
FROM _RefDropItemAssign Drops
LEFT join _RefObjCommon Objects
ON 
(Drops.RefItemID Objects.ID
WHERE CodeName128 like 'item code' 
14-If you want to remove the skill you have on the server, you will get its code from _RefSkill and run this query


use SRO_VT_SHARD 
update _RefSkill 
set Service 
'0' 
where Basic_Code 'Skill Code' 
15-If you want to clean SRO_VT_ACCOUNT


USE [SRO_VT_ACCOUNT
GO 
TRUNCATE TABLE 
[dbo].[TB_User
TRUNCATE TABLE [dbo].[TB_User_Bak
TRUNCATE TABLE [dbo].[SK_CharRenameLog
TRUNCATE TABLE [dbo].[_Punishment
TRUNCATE TABLE [dbo].[_ServiceManagerLog
TRUNCATE TABLE [dbo].[Test_HN
TRUNCATE TABLE [dbo].[_BlockedUser
TRUNCATE TABLE [dbo].[_CasGMChatLog
TRUNCATE TABLE [dbo].[_Notice
TRUNCATE TABLE [dbo].[_SMCLog
TRUNCATE TABLE [dbo].[QuaySoEpoint
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_SilkGoods
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_paygate_trans
16-If you want to clean SRO_VT_SHARD


USE [SRO_VT_SHARD
GO 
truncate table _OpenMarket 
print 'Cleaned _OpenMarket' 
truncate table _CharSkill 
print 'Cleaned _CharSkill' 
truncate table _CharSkillMastery 
print 'Cleaned _CharSkillMastery' 
truncate table _GuildMember 
print 'Cleaned _GuildMember' 
truncate table _BlockedWhisperers 
print 'Cleaned _BlockedWhisperers' 
truncate table _Inventory 
print 'Cleaned _Inventory' 
truncate table _InventoryForAvatar 
print 'Cleaned _InventoryForAvatar' 
truncate table _InventoryForLinkedStorage 
print 'Cleaned _InventoryForLinkedStorage' 
truncate table _TrainingCampMember 
print 'Cleaned _TrainingCampMember' 
truncate table _TrainingCampSubMentorHonorPoint 
print 'Cleaned _TrainingCampSubMentorHonorPoint' 
update _TrainingCampHonorRank set CampID NULLRank NULL 
print 'Cleaned _TrainingCampHonorRank' 
truncate table _TrainingCampBuffStatus 
print 'Cleaned _TrainingCampBuffStatus' 
delete from _TrainingCamp 
print 'Cleaned _TrainingCamp' 
truncate table _StaticAvatar 
print 'Cleaned _StaticAvatar' 
truncate table _User 
print 'Cleaned _User' 
truncate table _Friend 
print 'Cleaned _Friend' 
truncate table _Memo 
print 'Cleaned _Memo' 
truncate table _TimedJob 
print 'Cleaned _TimedJob' 
truncate table _CharTrijobSafeTrade 
print 'Cleaned _CharTrijobSafeTrade' 
delete from _CharTrijob 
print 'Cleaned _CharTrijob' 
truncate table _InvCOS 
print 'Cleaned _InvCOS' 
delete from _CharCOS where ID 
print 'Cleaned _CharCOS' 
delete from _Char where charid 
print 'Cleaned _Char' 
truncate table _Chest 
print 'Cleaned _Chest' 
truncate table _ChestInfo 
print 'Cleaned _ChestInfo' 
truncate table _ItemPool 
print 'Cleaned _ItemPool' 
delete from _Items where ID64 
print 'Cleaned _Items' 
delete from _AccountJID 
print 'Cleaned _AccountJID' 
update _AlliedClans set Ally1 0Ally2 0Ally3 0Ally4 0Ally5 0Ally6 0Ally7 0Ally8 
print 'Cleaned _AlliedClans' 
truncate table _GuildWar 
print 'Cleaned _GuildWar' 
truncate table _CharNameList 
print 'Cleaned _CharNameList' 
truncate table _CharQuest 
print 'Cleaned _CharQuest' 
truncate table _ClientConfig 
print 'Cleaned _ClientConfig' 
truncate table _DeletedChar 
print 'Cleaned _DeletedChar' 
truncate table _SiegeFortressStoneState 
print 'Cleaned _SiegeFortressStoneState' 
truncate table _SiegeFortressRequest 
print 'Cleaned _SiegeFortressRequest' 
truncate table _SiegeFortressObject 
print 'Cleaned _SiegeFortressObject' 
truncate table _SiegeFortressItemForge 
print 'Cleaned _SiegeFortressItemForge' 
truncate table _SiegeFortressBattleRecord 
print 'Cleaned _SiegeFortressBattleRecord' 
update _SiegeFortressStruct SET OwnerGuildID '0' 
print 'Cleaned _SiegeFortressStruct' 
UPDATE  _SiegeFortress SET GuildID '0'TaxRatio '0'Tax '0'NPCHired '0'Introduction NULLCreatedDungeonTime NULLCreatedDungeonCount NULL 
print 'Cleaned _SiegeFortress' 
truncate table _CharNickNameList 
print 'Cleaned _CharNickNameList' 
truncate table _GPHistory 
print 'Cleaned _GPHistory' 
truncate table _GuildChest 
print 'Cleaned _GuildChest' 
delete from _Guild where ID 
print 'Cleaned _Guild' 
delete from _AlliedClans where ID 
print 'Cleaned _AlliedClans' 
17-If you want to clean SRO_VT_SHARDLOG

PHP code:
USE [SRO_VT_SHARDLOG
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
18-If you want to let Unique stay somewhere


USE SRO_VT_SHARD

DECLARE @UNIQUE VARCHAR (129)
DECLARE @
CHARNAME VARCHAR (64)
DECLARE @
mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestIDFROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveIDFROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsIDFROM Tab_RefTactics)+1

/* put your settings here */
SET @UNIQUE 'Code Unique' -- Unique code name from _RefobjCommon table
SET 
@CHARNAME 'Char Name' -- Character name from _Char table to get mob position X Y Z
SET 
@mindealy 5400 -- Minimum time before appears in seconds
SET 
@maxdelay 7200 -- Maximum time before appears in seconds
SET 
@INITRADIUS 60 -- Radius around spot unique can generated at
SET 
@RADIUS 120 -- Radius around spot Unique can move in
/* end of settings area */

/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)

SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics 
(dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressDatabtChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceDatabtTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,02,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF

SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive 
(dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,szDescString128VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegionFROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @
POSX INT SET @POSX = (SELECT (POSXFROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @
POSY INT SET @POSY = (SELECT (POSYFROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @
POSZ INT SET @POSZ = (SELECT (POSZFROM _Char WHERE CharName16 = @CHARNAME)

SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest 
(dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMindwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt TypeVALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY ,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay ,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!' 
In place of Char Name, you will write the name of the account you are parked under Unique.

19- If you want to let Unique or Moob sign item, you specify it.


USE SRO_VT_SHARD
GO 

DECLARE @MonsterID int 
DECLARE @ItemID int 
DECLARE @DropRatio real
DECLARE @DropAmountMin int 
DECLARE @DropAmountMax int


SET 
@MonsterID 24062    -------- Mob,Unique ID you want Add Drop in 
SET 
@DropRatio 1        -------- Item drop rate 1=100% , 0.3 30%  
SET @ItemID 24670        -------- ITEM ID You want Add in Drops 
SET 
@DropAmountMin 5    -------- Amount of this item to Drop min
SET 
@DropAmountMax 8    -------- Amount of this item to Drop max



INSERT _RefMonster_AssignedItemDrop  

RefMonsterID
RefItemID
DropGroupType
OptLevel
DropAmountMin
DropAmountMax
DropRatio
RefMagicOptionID1
CustomValue1
RefMagicOptionID2
CustomValue2
RefMagicOptionID3
CustomValue3
RefMagicOptionID4
CustomValue4
RefMagicOptionID5
CustomValue5
RefMagicOptionID6
CustomValue6
RefMagicOptionID7
CustomValue7
RefMagicOptionID8
CustomValue8
RefMagicOptionID9
CustomValue9
RentCodeName 
)  
VALUES(@MonsterID , @ItemID00, @DropAmountMin, @DropAmountMax, @DropRatio00000000
00000000'xxx'
20-If you want to add a new Teleport


USE SRO_VT_SHARD 


DECLARE @Teleport VARCHAR (64)
DECLARE @
CHARNAME1 VARCHAR (30)
DECLARE @
CHARNAME2 VARCHAR (30)
DECLARE @
OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT

/* Put your settings here */
SET @Teleport 'PVP_ZONE' -- any name you want exPK_ZONE or PVP_ZONE
SET 
@CHARNAME1 'Char Name1' -- Teleport position
SET 
@CHARNAME2 'Char Name2' -- Spawn position after teleport
SET 
@OwnTeleport 1  -- Target teleport ID exfor Jangan for Hotan 20 for Constantinople
SET 
@Fee 50000  -- Gold amount to Pass the teleport
SET 
@RequiredLVL 0  -- minimum level required to teleport 0 for no restriction ex:90 lvl 90 and higher can teleport
/* settings area end here */

IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 'STORE_'+@Teleport)
 
BEGIN
  raiserror
('The stated teleportname of %s is already exist!',11,1,@Teleport);
  RETURN;
 
END
    
    
DECLARE @MAXOBJ INT = (SELECT MAX (IDFROM _RefObjCommon)+1
    
DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegionFROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @
POSX1 INT SET @POSX1 = (SELECT (POSXFROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @
POSY1 INT SET @POSY1 = (SELECT (POSYFROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @
POSZ1 INT SET @POSZ1 = (SELECT (POSZFROM _Char WHERE CharName16 = @CHARNAME1)
    DECLARE @
LINK INT = (SELECT MAX (IDFROM _RefObjStruct)+1
     
    SET IDENTITY_INSERT _RefObjCommon ON
    INSERT INTO _RefObjCommon 
(Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,LinkVALUES
    
(1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link)
    
SET IDENTITY_INSERT _RefObjCommon OFF
    
    
print ''
    
print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'
    
print '1    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'STORE_'+@Teleport+'    '+@Teleport+'    xxx    '+'SN_STORE_'+@Teleport+'    xxx    0    0    4    1    1    0    0    3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    '+CONVERT(varchar(max),@REGION1)+'    0    '+CONVERT(varchar(max),@POSX1)+'    '+CONVERT(varchar(max),@POSY1)+'    '+CONVERT(varchar(max),@POSZ1)+'    0    0    50    50    30    0    quest\teleport01.bsr    xxx    xxx    xxx    xxx    '+CONVERT(varchar(max),@link)
    print 
''
    
print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder'
    
print ''
    
print '1    '+'SN_STORE_'+@Teleport+'                                '+@Teleport
    
print ''
      
print ''

  
SET IDENTITY_INSERT _RefObjStruct ON
  INSERT INTO _RefObjStruct 
(ID,Dummy_DataVALUES
  
(@LINK,0)
  
SET IDENTITY_INSERT _RefObjStruct OFF
  
  
DECLARE @MAXTELID INT = (SELECT MAX (IDFROM _RefTeleport)+1
  
DECLARE @WORLDID INT = (SELECT (WorldIDFROM _Char where CharName16 = @CHARNAME2)
  DECLARE @
REGION2 INT SET @REGION2 = (SELECT (LatestRegionFROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE @
POSX2 INT SET @POSX2 = (SELECT (POSXFROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE @
POSY2 INT SET @POSY2 = (SELECT (POSYFROM _Char WHERE CharName16 = @CHARNAME2)
  DECLARE @
POSZ2 INT SET @POSZ2 = (SELECT (POSZFROM _Char WHERE CharName16 = @CHARNAME2)

  
INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedServiceVALUES
  
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0)
  
  print 
''
  
print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
  
print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+'GATE_'+@Teleport+'    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'SN_STORE_'+@Teleport+'    '+CONVERT(varchar(max),@REGION2)+'    '+CONVERT(varchar(max),@POSX2)+'    '+CONVERT(varchar(max),@POSY2)+'    '+CONVERT(varchar(max),@POSZ2)+'    30    0    0    '+CONVERT(varchar(max),@WORLDID)+'    1    0'
  
print ''
  
print ''

  
IF @RequiredLVL 0
  BEGIN
    INSERT INTO _RefTeleLink 
(Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2VALUES
    
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2VALUES
    
(1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    
print 
''
    
print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder'
    
print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'
    
print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'
    
print ''
  
END
  
ELSE BEGIN
    INSERT INTO _RefTeleLink 
(Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2VALUES
    
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0)
    
    print 
''
    
print ''
    
print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder'
    
print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    1    '+CONVERT(varchar(max),@RequiredLVL)+'    999    0    0    0    0    0    0    0    0    0    0    0    0'
    
print ''

  
END

print ''
print 'Done!' 
21-If you want to add silk to the people you have on the server

PHP code:
USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK 
(JID,
silk_own,
silk_gift,
silk_point
SELECT JID,
'0',
'0',
'0'
FROM TB_User 
WHERE not exists 
(select from SK_Silk 
WHERE SK_SILK
.JID TB_User.JID);
UPDATE SK_Silk SET silk_own=silk_own+1000 
1000 is the number of wires that will be sent to people.

22- If you want to change the rate of Magic PoP


USE [SRO_VT_SHARD]
GO
DECLARE @Rate int
SET 
@Rate 10
UPDATE dbo
._RefGachaItemSet SET Ratio Ratio*@Rate WHERE Ratio*@Rate 32768 -- 32767 max value for smallint 
23-If you want to have your Bug Pills fixed


USE [SRO_VT_SHARD]
UPDATE _RefObjItem SET Param4='20000'Desc4_128='COOLTIME:0x000000C8'
WHERE ID BETWEEN 5861 and 5864 
24-If you want to give the ban to someone you have


USE [SRO_VT_SHARD
GO
-------------------------------- 
DECLARE @
ChrID INT
DECLARE @
CharName VARCHAR(64); 
DECLARE @
AccJID INT
---------------------------------
SET @CharName 'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
-----------------------------------------------------------------
USE 
SRO_VT_ACCOUNT
DECLARE @ID VARCHAR (64)
DECLARE @
Reason VARCHAR(128)
DECLARE @
Begin DATETIME
DECLARE @End DATETIME
SET 
@ID = (Select STRuserID FROM TB_User Where JID = @AccJID)

---------------------------------
SET @Reason 'Ban Reason Here'
SET @Begin '2012-05-01 00:00:00.000' -- Time Begin --
SET @End '2040-01-01 00:00:00.000' -- Time End --
---------------------------------
---------------------------

INSERT [dbo].[_Punishment]
(
[
UserJID],
[
Type],
[
Executor],
[
Shard],
[
CharName],
[
CharInfo],
[
PosInfo] ,
[
Guide],
[
Description],
[
RaiseTime],
[
BlockStartTime],
[
BlockEndTime],
[
PunishTime],
[
Status]
)
VALUES 
(
@
AccJID,
1,
1,
0,
@
CharName,
1,
1,
@
Reason,
@
Reason,
@
Begin,
@
Begin,
@
End,
@
End,
0);
----------------------------------------------------------
DECLARE @
ReasonID INT
SET 
@ReasonID =
(
Select SerialNo FROM _Punishment Where UserJID = @AccJID)
----------------------------------------------------------
INSERT [dbo].[_BlockedUser]
(
[
UserJID],
[
UserID],
[
Type],
[
SerialNo],
[
TimeBegin],
[
TimeEnd])
VALUES
(
@
AccJID,
@
ID,
1,
@
ReasonID,
@
Begin,
@
End);

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID 
25-If you want to remove the ban

USE [SRO_VT_SHARD
GO
-------------------------------- 
DECLARE @
ChrID INT
DECLARE @
CharName VARCHAR(64); 
DECLARE @
AccJID INT
---------------------------------
SET @CharName 'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
--------------------------------
USE [
SRO_VT_ACCOUNT]
--------------------------------
DELETE FROM [dbo].[_BlockedUser]
WHERE UserJID = @AccJID
DELETE FROM 
[dbo].[_Punishment]
WHERE UserJID = @AccJID

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
----------------------------------------------------------------- 
26- People say that the problem of lag then I think this will alleviate it to some extent.
Remove Tablet and Material


USE([SRO_VT_SHARD])GO()Update(dbo._RefDropItemAssign)Service 0WHERE RefItemID BETWEEN 6679 AND 5414
Update
(dbo._RefDropItemAssign)Service 0WHERE RefItemID BETWEEN 6082 AND 6371
Update
(dbo._RefDropItemAssign)Service 0WHERE RefItemID BETWEEN 10501 AND 10527
Update
(dbo._RefDropItemAssign)Service 0WHERE RefItemID BETWEEN 11499 AND 11668
Update
(dbo._RefDropItemAssign)Service 0WHERE RefItemID BETWEEN 12554 AND 12569 
27- If you want to remove skills, go to the account


USE [SRO_VT_SHARD]
GO . Declare @CharName Varchar (64)Set @CharName    =    'Char Name'
UPDATE    [dbo].[_CharSkill]SET CharID0WHERE CharID = (SELECT CharID FROM [dbo].[_CharWHERE CharName16 = @CharName
28- If you want to remove an NPC

PHP code:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'NPC Name' 
29-If you want to download a moob

PHP code:
Update Tab_RefNest Set fLocalPosX=NULL fLocalPosY=NULL fLocalPosZ=NULL WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'Moob Code' 
30-If you want to reset skills, go to the account


USE SRO_VT_SHARD
DECLARE @CharName varchar (64)
DECLARE  @
CharID int
DECLARE @GiveSP int
SET 
@CharName 'Char Name'--Your Char Name
SET 
@GiveSP   '10000000' --Write the amount of Skill Point
SET 
@CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName) --Do not change

-- edit by InPanic Kev --
update _ClientConfig
set Data 
'0'
where CharID = @CharID
-- edit by InPanic Kev --

--- Do 
Not Change Here ---
--- 
made by ModGift for RZ  ---
DELETE [dbo].[_CharSkill]
   
WHERE [CharID] = @CharID and [SkillID] > '2'

INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID
           
,'8421'
           
,'1')
INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID
           
,'8419'
           
,'1')

INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'8420'
           
,'1')

INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'9354'
           
,'1')

INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'9355'
           
,'1')

INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'9944'
           
,'1')
INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'10625'
           
,'1')
INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'11162'
           
,'1')
INSERT INTO [dbo].[_CharSkill]
           ([
CharID]
           ,[
SkillID]
           ,[
Enable])
     
VALUES
           
(@CharID,
           
'11526'
           
,'1')
UPDATE [dbo].[_CharSkillMastery]
   
SET 
      
[Level] = '0'
 
WHERE CharID= @CharID
UPDATE 
[dbo].[_Char]
  
SET RemainSkillPoint= @GiveSP
  WHERE CharName16 
= @CharName
GO 
31- If you want to make your place safe zone or not safe zone


Update _RefRegionSet IsBattleField 1Where ContinentName CHINA
Update _RefRegionSet IsBattleField 
0Where ContinentName CHINA 
32- If you want to change your name, count

PHP code:
USE SRO_VT_SHARD
 GO
Update _Char set CharName16 
'New Name' where CharName16 'Old Name' 
33-If you want to know all the Uniques you have

PHP code:
Use [SRO_VT_SHARD]Select CodeName128 From _RefObjCommon Where Rarity and CodeName128 Like '%MOB%' 
34- If you have a problem with fortress uniques


use SRO_VT_SHARD UPDATE _RefObjCommon SET TypeID3=1TypeID4=1Rarity=
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%'
35-If we want to provide the exp for a specific Unique or Moob


USE SRO_VT_SHARD 
DECLARE @MobCodeName VARCHAR(30); 
DECLARE @
Rate INT
DECLARE @
Link INT
/* Set mob CodeName, and rate here */ 
SET @Rate=
SET 
@MobCodeName='Code' 

SET @Link=(SELECT Link FROM _RefObjCommon WHERE CodeName128=@MobCodeName
UPDATE _RefObjChar SET ExpToGive=ExpToGive*@Rate WHERE ID=@Link 
36- If you want to change your account ID


USE [SRO_VT_ACCOUNT
declare @
AtualID varchar (30
declare @
NewID varchar (30
set @AtualID 'Your ID' 
set @NewID 'New ID' 
update tb_user set struserid = @NewID 
where struserid 
= @ActualID 
37-After you add the title in the media, do this Query


USE SRO_VT_SHARD 
Declare @newHWANlevel varchar(64
Declare @
blueORred int 
Declare @ZerkDMG tinyint 
Declare @CHwriting1 varchar(74
Declare @
EUwriting1 varchar(74
Declare @
newCHtitle varchar(74
Declare @
newEUtitle varchar(74



SET @blueORred 1145127506 /* 1145127506 for blue, 0 for red Zerk*/ 
SET @ZerkDMG 50 /*e.g. for 50% more DMG; MAX = 255% change tinyint to int if you want more*/ 
SET @newCHtitle 'Title Name'    /*new Chinese Title*/ 
SET @newEUtitle 'Title Name'    /*new European Title*/ 

--############################################ END 
--############################################ 


SET @newHWANlevel = (SELECT MAX(HwanLevelFROM _RefHWANLevel)+
SET 
@CHwriting1 'UIO_SECOND_HWAN_CH_NAME_LEVEL_' 
SET @EUwriting1 'UIO_SECOND_HWAN_EU_NAME_LEVEL_' 
INSERT INTO _RefHWANLevel (HwanLevel,ParamFourcc1,ParamValue1,ParamFourcc2,ParamValue2,ParamFourcc3,ParamValue3,ParamFourcc4,ParamValue4,ParamFourcc5,ParamValue5,AssocFileObj128,Title_CH70,Title_EU70VALUES (@newHWANlevel,1397769301,200,@blueORred,@ZerkDMG,0,0,0,0,0,0,'xxx',@CHwriting1+@newHWANlevel,@EUwriting1+@newHWANlevel); 
print 
'' 
print 'Media/server_dep/silkroad/textdata/textuisystem.txt' 
print '1    '+@CHwriting1+@newHWANlevel+'                            '+@newCHtitle 
print '1    '+@EUwriting1+@newHWANlevel+'                            '+@newEUtitle 
print '' 
print 'Media/server_dep/silkroad/textdata/hwanleveldata.txt' 
print @newHWANlevel+'    UIO_SECOND_HWAN_CH_NAME_LEVEL_'+@newHWANlevel+'    UIO_SECOND_HWAN_EU_NAME_LEVEL_'+@newHWANlevel 
38-If you only have a Chinese server and want to remove euro items


USE [SRO_VT_SHARD
GO 
UPDATE dbo
._RefDropItemAssign 
SET DropCount 

WHERE RefItemID BETWEEN 14181 
AND 14869 

UPDATE dbo
._RefDropItemAssign 
SET DropCount 

WHERE RefItemID BETWEEN 12844 
AND 14180 

UPDATE dbo
._RefDropItemAssign 
SET DropCount 

WHERE RefItemID BETWEEN 11417 
AND 12843 

UPDATE dbo
._RefDropItemAssign 
SET DropCount 

WHERE RefItemID BETWEEN 10897 
AND 11416 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Absolute 

WHERE RefItemID BETWEEN 14181 
AND 14869 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Absolute 

WHERE RefItemID BETWEEN 12844 
AND 14180 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Absolute 

WHERE RefItemID BETWEEN 11417 
AND 12843 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Absolute 

WHERE RefItemID BETWEEN 10897 
AND 11416 


UPDATE dbo
._RefDropItemAssign 
SET Prob_Relative 

WHERE RefItemID BETWEEN 14181 
AND 14869 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Relative 

WHERE RefItemID BETWEEN 12844 
AND 14180 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Relative 

WHERE RefItemID BETWEEN 11417 
AND 12843 

UPDATE dbo
._RefDropItemAssign 
SET Prob_Relative 

WHERE RefItemID BETWEEN 10897 
AND 11416 
39- If you have a problem in FGW with uniques or envy


USE [SRO_VT_SHARD
GO --/*Fix Envy*/ 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41540' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41550' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41560' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41570' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41580' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41590' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42460' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42470' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42480' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42490' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42500' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42510' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42520' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42530' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43420' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43430' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43440' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43450' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43460' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43470' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43480' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43490'  
------------------------------------------------------------------------- 
USE [
SRO_VT_SHARD
GO --/*Fix Boss Uniques*/ 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43580' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43590' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43600' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43610' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43620' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43630' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43640' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43650' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43660' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43670' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43680' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43690' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43700' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43710' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43720' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43730' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43740' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43750' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43760' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43770' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43780' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43790'  
------------------------------------------------------------------------- 
USE [
SRO_VT_SHARD
GO --/*For Treasure Box*/ 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41600' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41610' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41620' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41630' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41640' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '41650' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42540' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42550' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42560' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42570' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42580' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42590' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42600' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '42610' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43500' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43510' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43520' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43530' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43540' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43550' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43560' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '43570' 
40- If you want to change the number of people in the guild


USE [SRO_VT_SHARD
GO 
/****** Object:  StoredProcedure [dbo].[_Guild_FnAddMember]    Script Date: 15.06.2014 11:08:20 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER OFF 
GO 




ALTER PROCEDURE 
[dbo].[_Guild_FnAddMember
 @
guildID        int
 @
MemberID     int
 @
MemberClass    tinyint
 @
joinDate     smalldatetime
 @
permission     int     
     
as 
Declare @
LiMiT int '24' -- << Userr Limit Credits by $Apollo 
    
if (exists (select CharID from _GuildMember where CharID = @MemberID)) 
    
begin 
        
return -1001 
    end 


    
declare @MemberName    varchar(64
    declare @
curLevel    tinyint 
    select 
@MemberName CharName16, @curLevel CurLevel from _Char with (nolockwhere CharID = @MemberID 
    
if (@@error <> or @@rowcount 0
    
begin 
        
return -
    end 
    
if (exists (select CharID from _GuildMember with (nolockwhere GuildID = @guildID and CharID = @MemberID)) 
    
begin  
        
return -
    end 
     
        
declare @ReFObjID int 
    select 
@ReFObjID RefObjID from _Char with (nolockwhere CharID = @MemberID 
     
    
if (@@error <> or @@rowcount 0
    
begin 
        
return -
    end 






    
declare @siegeAuthority tinyint 
    set 
@siegeAuthority 


    
if @MemberClass 0  -- ±&#230;¸¶ร€รŒ¸รฉ °รธ¼ยบ±ร‡ร‡ร‘ร€» commander·รŽ ¼¼ร†รƒ! ±× ¿รœ´ร‚ ร€ร¹ร member·รŽ ¼¼ร†รƒร‡ร‘´ร™. 
    
begin 
        set 
@siegeAuthority 
    end 
    
Declare @GC int = (Select COUNT(*) from _GuildMember where GuildID = @guildID 
   if @
GC  <= @LiMiT begin  
    insert _GuildMember values 
@guildID, @MemberID, @MemberName, @MemberClass, @curLevel0, @joinDate @permission000null, @ReFObjID, @siegeAuthority
    
end 
    
if (@@error <> or @@rowcount 0
    
begin 
        
return -
    end 
     
       
if @GC  <= @LiMiT begin   
    update _Char Set GuildID 
= @guildID where CharID = @MemberID 
    end 
    
if (@@error <> or @@rowcount 0
    
begin 
        
return -
    end 
    
return 
24 is the number because you want to change it


Declare @LiMiT int '24' 
41-If you have a problem with the holy water temple uniques


USE [SRO_VT_SHARD
GO 
UPDATE Tab_RefNest SET dwMaxTotalCount 
1 WHERE dwTacticsID LIKE '38480' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38490' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38500' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38540' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38550' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38560' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38510' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38520' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38530' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38570' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38580' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38590' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38600' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38610' 
UPDATE Tab_RefNest SET dwMaxTotalCount 1 WHERE dwTacticsID LIKE '38620' 
I hope I have benefited people :)
Regards 

2 Comments

Previous Post Next Post

Contact Form