مجموعة كبيره من ال Queries

[Muuhammed Rifaii]

انا حاولت اجمع اكبر كم ممكن من ال Queries في موضوع واحد
الغرض من الموضوع الي عايز يدور علي Query ميدورش في مليون مكان


1- لو عايز تشيل premium من واحد عندك في السيرفير​

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-لو عايز تشيل PK من علي واحد
​

USE [SRO_VT_SHARD] 
DECLARE @CharName Varchar(max) 
SET @CharName = 'Char Name' 

UPDATE _Char SET 
RemainHwanCount = 5, 
DailyPK= 0, 
TotalPK= 0, 
PKPenaltyPoint= 0 
WHERE CharName16 = @CharName

3-لو عايز تدي واحد title name​

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-لو عندك title name مثلا عايز تعرف مين الي معاه في السيرفير عندك ال title name ده​

Use SRO_VT_SHARD Select CharName16 From dbo._Char Where HwanLevel Like 'Rkm al Title'

5-لو عايز تشيل item من الناس كلها
​

USE [SRO_VT_SHARD] 

Exec [dbo].[_SEEK_N_DESTROY_ITEM]  ['item code' ]

6-لو عايز ترجع الناس كلها 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

7-لو عايز تدي item ل char عندك​

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

8-لو عايز تمسح الواخد fortress عندك​

USE SRO_VT_SHARD  
UPDATE _SiegeFortress SET GuildID = 0

9-لو عايز تحول moob الي unique​

USE SRO_VT_SHARD  
GO  

update _RefObjCommon set Rarity = 3 where CodeName128 = 'Code Moob'  

Print 'Mob has been changed to unique'

10-لو عايز تجيب id بتاع حاجه عندك​

Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'Code Here'

11- لو عايز الناس عندك بعد ما تخرج من guild تعمل teleport تخوش guild ثاني
​

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

12-لو عايز تفتح كل skills لاكونت​

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-لو عايز تشيل دروب لايتم معين​

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

او
​

USE SRO_VT_SHARD 
DELETE _RefDropItemAssign 
FROM _RefDropItemAssign Drops 
LEFT join _RefObjCommon Objects 
ON (Drops.RefItemID = Objects.ID)  
WHERE CodeName128 like 'item code'

14-لو عايز تشيل skill عندك في السيرفر هتجيب ال code بتاعه من _RefSkill وتعمل ال query ده​

use SRO_VT_SHARD  
update _RefSkill  
set Service = '0'  
where Basic_Code = 'Skill Code'

15-لو عايز تعمل 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-لو عايز تعمل 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 = 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'

17-لو عايز تعمل clean ل SRO_VT_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]

18-لو عايز تخلي 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 = '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,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,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,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,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,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) 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!'

مكان ال Char Name هتكتب اسم الاكونت الي انت موقفوا عند ال Unique


19-لو عايز تخلي Unique او Moob يوقع item انت بتحددها
​

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 , @ItemID, 0, 0, @DropAmountMin, @DropAmountMax, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,  
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')

20-لو عايز تضيف 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 ex: PK_ZONE or PVP_ZONE 
SET @CHARNAME1 = 'Char Name1' -- Teleport position 
SET @CHARNAME2 = 'Char Name2' -- 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\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_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!'

21-لو عايز تضيف silk للناس الي عندك في السيرفير​

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 ده عدد السيلك الي هيتبعت للناس

22- لو عايز تغير rate بتاع ال 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-لو عايز تصلح Bug Pills عندك​

USE [SRO_VT_SHARD] 
UPDATE _RefObjItem SET Param4='20000', Desc4_128='COOLTIME:0x000000C8' 
WHERE ID BETWEEN 5861 and 5864

24-لو عايز تدي 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 
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-لو عايز تشيل ال 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- ناس بتقايل مشكلة ال lag عندها اعتقد ده هيخففه الي حدا ما
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- لو عايز تشيل skills لاكونت​

USE [SRO_VT_SHARD] 
GO . Declare @CharName Varchar (64)Set @CharName    =    'Char Name' 
UPDATE    [dbo].[_CharSkill]SET CharID= 0WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)

28- لو عايز تشيل NPC​

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'NPC Name'

29-لو عايز تشيل moob
​

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-لو عايز reset skills لاكونت
​

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- لو عايز تخلي مكان عندك Safe Zone او مش Safe Zone
​

Update _RefRegionSet IsBattleField = 1Where ContinentName = CHINA 
Update _RefRegionSet IsBattleField = 0Where ContinentName = CHINA

32- لو عايز تغير اسم لاكونت​

USE SRO_VT_SHARD 
 GO 
Update _Char set CharName16 = 'New Name' where CharName16 = 'Old Name'

33-لو عايز تعرف كل ال Uniques الي عندك
​

Use [SRO_VT_SHARD]Select CodeName128 From _RefObjCommon Where Rarity = 3 and CodeName128 Like '%MOB%'

34- لو عندك مشكلة في ال fortress uniques
​

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

35-لو عايز نزود ال exp ل Unique او Moob معين​

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

SET @Link=(SELECT Link FROM _RefObjCommon WHERE CodeName128=@MobCodeName)  
UPDATE _RefObjChar SET ExpToGive=ExpToGive*@Rate WHERE ID=@Link

36- لو عايز تغير 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-بعد ما تضيف ال title في الميديا اعمل ال 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(HwanLevel) FROM _RefHWANLevel)+1  
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_EU70) VALUES (@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-لو سيرفر chinese بس وعايز تشيل euro items​

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

39- لو عندك مشكلة في FGW مع ال uniques او 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- لو عايز تغير عدد الناس في ال 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 (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  -- ±æ¸¶ÀÌ¸é °ø¼º±ÇÇÑÀ» commander·Î ¼¼ÆÃ! ±× ¿Ü´Â ÀÏ¹Ý member·Î ¼¼ÆÃÇÑ´Ù.  
    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

24 ده العدد عشان او عايز تغيره​

Declare @LiMiT int = '24'

41 -لو عندك مشكله في ال 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'

 

[Gamer]

رد: مجموعة كبيره من ال Queries

مكرر..
بس الله ينور عاش

 

[Muuhammed Rifaii]

رد: مجموعة كبيره من ال Queries

مكرر..
بس الله ينور عاش

انا عارف انها مكرره بس في حاجات انا ملقيتهاش في الموضوع التاني و حبيت اساعد بس ​

 

[blalelsayed]

رد: مجموعة كبيره من ال Queries

عاش والله , استمر

 

[Muuhammed Rifaii]

رد: مجموعة كبيره من ال Queries

عاش والله , استمر

حبيبي يا بلال

 

[DraCula]

رد: مجموعة كبيره من ال Queries

عااااااااااااااااش استمر

 

[Muuhammed Rifaii]

رد: مجموعة كبيره من ال Queries

عااااااااااااااااش استمر

حبيبي يا عبدو في تقدم ان شاء الله :emoji37:

 

[Dev.HamB0Za]

رد: مجموعة كبيره من ال Queries

عااااااااااااااااش استمر

 

[Dev.HamB0Za]

رد: مجموعة كبيره من ال Queries

عااااااااااااااااش استمر