الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**●♥ Marwan1337 ♥●** · 18-10-2012, 04:55 PM

بســــم الله الرحــمن الرحــيم

موضوعنا أنهاردة هيكون شامل كل ال Querys ان شاء الله وأحاول أجمع أكتر عدد من ال Query ..
نبدأ على بركة الله :)

اول حاجه حتقولي انا نفسي احط الدجري 12 و دجري 13
اقولك ماشي مفيش غير انك تفتح ال New Query Windows
وتحط فيها الكود ده

كود:

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

وتغير اسم الداتا لو الداتا بتاعتك غير SRO_VT_SHARD
حتلاقي الداتا فيها دجري 12 و 13
وطبعا الكلينت انتا حتتسرف فيه
ملحوظه : الداتا سؤاء دجري 11 او 12 او 13 او 20 مش حتأثر ع السيرفر

نرجع لموضوعنا

Clean Log [ ال SHARDLOG]

كود:

USE [LOG_DB]
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]

Clean Shard [ ال SHARD ]

كود:

USE SRO_VT_SHARD
GO
truncate table _CharSkill
truncate table _CharSkillMastery
truncate table _GuildMember
truncate table _BlockedWhisperers
truncate table _Inventory
truncate table _InventoryForAvatar
truncate table _InventoryForLinkedStorage
truncate table _TrainingCampMember
truncate table _TrainingCampSubMentorHonorPoint
truncate table _TrainingCampHonorRank
truncate table _TrainingCampBuffStatus
delete from _TrainingCamp
truncate table _StaticAvatar
truncate table _User
truncate table _Friend
truncate table _Memo
truncate table _TimedJob
truncate table _CharTrijobSafeTrade
delete from _CharTrijob
truncate table _InvCOS
delete from _CharCOS where ID > 0
delete from _Char where charid > 0
truncate table _Chest
truncate table _ChestInfo
truncate table _ItemPool
delete from _Items where ID64 > 0
delete from _AccountJID
truncate table _GuildChest
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
truncate table _GuildWar
delete from _Guild where ID > 0
delete from _AlliedClans where ID > 0
truncate table _CharNameList
truncate table _CharQuest
truncate table _ClientConfig
truncate table _DeletedChar
truncate table _SiegeFortressStruct
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress
truncate table _OpenMarket

مسح الأكونتات من الداتا بيس ...

كود:

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]

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

/* Stored Procedure by sladlejrhfpq */

Get Media Code

كود:

For Get Code Meida Itemdataxxx.txt
------------
USE [SRO_VT_SHARD]
exec _GetMediaLines
@Type=1,
@CodeName='ITEM_CH_SWORD_01%'
/* or ITEM_CH_SWORD_01_A << For 1 Item WithOut %*/


For Get Code Meida characterdataxxx.txt
------------
USE [SRO_VT_SHARD]
exec _GetMediaLines
@Type=2,
@CodeName='MOB_FW_WHITETIGER_%'
/* or MOB_FW_WHITETIGER_001 << For 1 Item WithOut %*/

/* Stored Procedure by sladlejrhfpq */

Yellow Title

كود:

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)


--############################################ by Marwan Abbas
--############################################ Parameter which you can change!

SET @blueORred = 1145127506 /* 1145127506 for blue, 0 for red Zerk*/
SET @ZerkDMG = 95 /*e.g. for 50% more DMG; MAX = 255% change tinyint to int if you want more*/
SET @newCHtitle = 'Queen'    /*new Chinese Title*/
SET @newEUtitle = 'Queen'    /*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

Add Spot Uniques

كود:

USE SRO_VT_SHARD /* Add Unique Spot By Marwan Abbas */

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:

For Privileged IP

كود:

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Table [dbo].[_PrivilegedIP]    Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
DROP TABLE _PrivilegedIP
GO
CREATE TABLE [dbo].[_PrivilegedIP](
    [IP1] [tinyint] NOT NULL,
    [IP2] [tinyint] NOT NULL,
    [IP3] [tinyint] NOT NULL,
    [IP4] [tinyint] NOT NULL,
    [IP5] [tinyint] NOT NULL,
    [IP6] [tinyint] NOT NULL,
    [IP7] [tinyint] NOT NULL,
    [IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

Plvl Char :)

كود:

USE [SRO_VT_SHARD]
Declare @CharName VarChar(max)
Declare @Level BigInt
SET @CharName=        '’Marwan Abbas'  --CharName
SET @Level = '120' --Level
UPDATE [Dbo].[_Char]
SET InventorySize = '109', --Iventory Size Min 45 max 109
RemainGold = RemainGold + '1', --GOLD to give
HwanLevel = '0', --Zerk Level ( 0 to none )
RemainSkillPoint = RemainSkillPoint + '101000', --SkillPoint to give
CurLevel = @Level,
MaxLevel = @Level,
Strength = @Level+19,
Intellect = @Level+19,
RemainStatPoint = @Level * 3 -3,
RemainHwanCount = 5,  --RemainHwanCount
ExpOffset = 1-- Exp
WHERE CharName16 = @CharName

Remove Pk All Players ..

كود:

USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0

Remove Pk By Char Name ..

كود:

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

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

Give Items to Char

كود:

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

set @CharName = 'Marwan Abbas'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MOVE_SPEED_UP_100',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_AA_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_SA_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_FA_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_HA_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_LA_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_BA_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,12

Give 120 Mastry to Char

كود:

USE [SRO_VT_SHARD]
GO
--by Marwan Abbas
Declare @CharName Varchar (64)
Set @CharName    =    'Marwan Abbas'

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

Change MaxStack

كود:

EXEC _ChangeMaxStack
@ITEMNAME = '%ITEM_ETC_ARCHEMY_MAGICSTONE%', /* ITEM TO CHANGE */
@MAXSTACK = 100 /* NEW MAXSTACK */

Add New Drop Item In Unique Or Mob

كود:

USE SRO_VT_SHARD_INIT
GO

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



SET @MonsterID = 24160 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 35773 -- You can find Item ID's at RefObjCommon


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

Remove All Skill By Char

كود:

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

UPDATE    [dbo].[_CharSkill]
SET CharID= 0
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)

Search About Item In Char

كود:

Use SRO_VT_SHARD_INIT
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'

Add New Qustom Teleport

كود:

USE SRO_VT_SHARD /* Add new Teleport By Marwan Abbas */


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 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- 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+'
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!'

Change Alchemy Rate 1.5x

كود:

USE [SRO_VT_SHARD_INIT]
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 1

كود:

USE [SRO_VT_SHARD_INIT]
/*SQL Query made by Marwan Abbas*/
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'

اقتباس:

المشاركة الأصلية كتبت بواسطة $Waxy عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

دي شوية كويري بتفتح d14 set and weopens and accsory
و كل ال ديجري تاريبن انا العملها كولها

كود PHP:


			
UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_SWORD_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SWORD_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_TSWORD_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_BLADE_12%'

UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_HARP_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_TBLADE_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_CROSSBOW_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_BOW_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_DAGGER_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SPEAR_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_SHIELD_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SHIELD_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_SWORD_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SWORD_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_TSWORD_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_BLADE_14%'

UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_HARP_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_TBLADE_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_CROSSBOW_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_BOW_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_DAGGER_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SPEAR_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_SHIELD_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SHIELD_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_STAFF_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_TSTAFF_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_AXE_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_SWORD_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SWORD_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_TSWORD_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_BLADE_13%'

UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_HARP_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_TBLADE_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_CROSSBOW_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_BOW_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_DAGGER_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SPEAR_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_SHIELD_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_SHIELD_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_STAFF_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_TSTAFF_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_AXE_13%'

/*Credit To : Waxy$ Not Other >> Dont Re Release Under Your Name*/

كود PHP:


			
UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_HEAVY_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_HEAVY_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_HEAVY_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_HEAVY_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_LIGHT_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_LIGHT_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_LIGHT_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_LIGHT_14%'

UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_14%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_HEAVY_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_HEAVY_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_HEAVY_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_HEAVY_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_LIGHT_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_LIGHT_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_LIGHT_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_CLOTHES_13%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_HEAVY_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_HEAVY_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_HEAVY_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_HEAVY_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_LIGHT_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_LIGHT_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_LIGHT_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_LIGHT_12%

'

UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_12%'



UPDATE [dbo].[_RefObjCommon]

set service = 1

WHERE CodeName128 like '%ITEM_CH_W_CLOTHES_12%'

/*Credit To : Waxy$ Not Other Dont Re Release Under Your Name*/

كود PHP:


			
UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_RING_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_RING_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_EARRING_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_EARRING_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_NECKLACE_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_NECKLACE_14%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_RING_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_RING_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_EARRING_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_EARRING_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_NECKLACE_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_NECKLACE_13%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_RING_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_RING_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_EARRING_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_EARRING_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_EU_NECKLACE_12%'



UPDATE [dbo].[_RefObjCommon]

SET Service = 1

WHERE CodeName128 like '%ITEM_CH_NECKLACE_12%'

/*Credit To : Waxy$ Not Other >> Dont Re Release Under Your Name*/

كود PHP:


			
Stone query

UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_STR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_INT_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_DUR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_BLOCK_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_CRITICAL_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HP_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_MP_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_FROSTBITE_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ESHOCK_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_BURN_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_POISON_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ZOMBIE_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ATHANASIA_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_SOLID_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ASTRAL_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PA_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PASTR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MA_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAINT_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_CRITICAL_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_HR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PD_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PDSTR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MD_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MDINT_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_ER_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_BR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PAR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_STR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_INT_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_DUR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_BLOCK_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_CRITICAL_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ER_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HP_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_MP_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_FROSTBITE_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ESHOCK_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_BURN_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_POISON_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ZOMBIE_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PA_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MA_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_13%'

UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_HR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PD_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MD_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_ER_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_BR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_13%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_STR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_INT_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_DUR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_BLOCK_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_CRITICAL_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HP_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_MP_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_FROSTBITE_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ESHOCK_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_BURN_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_POISON_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ZOMBIE_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ATHANASIA_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_SOLID_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ASTRAL_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PA_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PASTR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MA_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAINT_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_CRITICAL_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_HR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PD_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PDSTR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MD_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MDINT_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_ER_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_BR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PAR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_STR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_INT_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_DUR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_BLOCK_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_CRITICAL_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ER_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HP_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_MP_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_FROSTBITE_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ESHOCK_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_BURN_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_POISON_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ZOMBIE_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PA_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MA_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_HR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PD_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MD_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_ER_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_BR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_12%'



UPDATE [dbo].[_RefObjCommon]

Set Service = 1

Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_12%'

/*Credit To : Waxy$ Not Other >> Dont Re Release Under Your Name*/

اقتباس:

المشاركة الأصلية كتبت بواسطة omarahmed500 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

عايز كل اللى فى الجيم يروحو جنجان

كود بلغة HTML:

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

عايز تشيل الاسلحة السوس و الرسايل 150% الكويست من عند البوشن _RefCharDefault_Quest
Make 1->0

كود بلغة HTML:

1	1	3	QEV_ALL_BASIC_1		5
1	2	3	QEV_ALL_BASIC_2		8
1	3	3	QEV_ALL_BASIC_3		10
1	4	3	QEV_ALL_BASIC_4		16
1	5	3	QEV_ALL_BASIC_5		20
1	6	3	QEV_ALL_BASIC_6		24
1	7	3	QEV_ALL_BASIC_7		30
1	8	3	QEV_ALL_BASIC_8		32
1	9	3	QEV_ALL_BASIC_9		40
1	10	3	QEV_ALL_BASIC_10	42
1	11	3	QEV_ALL_BASIC_11	50
1	12	3	QEV_ALL_BASIC_12	60
1	13	3	QEV_ALL_BASIC_0		1

Reset Chines Skill

كود بلغة HTML:

SET @CharName = 'CharName' --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 omarahmed500 --
update _ClientConfig
set Data = '0'
where CharID = @CharID
-- edit by omarahmed500 --

--- Do Not Change Here ---
--- made by omarahmed500 for S4a ---
DELETE [dbo].[_CharSkill]
   WHERE [CharID] = @CharID and [SkillID] > '2' and SkillID<'40' 

DELETE [dbo].[_CharSkill]
   WHERE [CharID] = @CharID and [SkillID] > '40' and SkillID<'70' 

DELETE [dbo].[_CharSkill]
   WHERE [CharID] = @CharID and [SkillID] > '70' 

UPDATE [dbo].[_CharSkillMastery]
   SET 
      [Level] = '0'
 WHERE CharID= @CharID

UPDATE [dbo].[_Char]
  SET RemainSkillPoint= @GiveSP
  WHERE CharName16 = @CharName
GO

Reset EU skill

كود بلغة HTML:

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

--- Do Not Change Here ---
--- made by omarahmed500 for S4a  ---
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

for all char

كود بلغة HTML:

USE [SRO_VT_SHARD]
GO
--Made by omarahmed500 for silkroad4arab 

-- edit by omarahmed500 --
update _ClientConfig
set Data = '0'
-- edit by omarahmed500 --

DELETE FROM [dbo].[_CharSkill]
      WHERE  SKillID NOT LIKE '1' and  SKillID NOT LIKE '2' and  SKillID NOT LIKE '40'
	  and  SKillID NOT LIKE '70' and  SKillID NOT LIKE '8421' and  SKillID NOT LIKE '8419'
	  and  SKillID NOT LIKE '8420' and  SKillID NOT LIKE '9354' and  SKillID NOT LIKE '9355'
	  and  SKillID NOT LIKE '9944' and  SKillID NOT LIKE '10625' and  SKillID NOT LIKE '11162'
	  and  SKillID NOT LIKE '11526'
GO 

UPDATE [dbo].[_CharSkillMastery]
   SET 
      [Level] = '0'

For delete Mobs

كود PHP:


			
JUPITER - Jupiter

SD - DESERT OF ALEX

DELTA - Alexandria

Eu - Constantinople

Ca - Central Asia (Samarkand)

Pharaoh - HOLY TEMPLE

KingsValley - ALEX DOWN

TEMPLE - JOB CAVE ALEXANDRIA

كود بلغة HTML:

USE [SRO_VT_SHARD]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
    [ID] [nchar](10) NULL
) ON [PRIMARY]

GO
INSERT INTO Region (ID)
select 
_RefRegion.wRegionID
from 
_RefRegion 
where 
/* Set JUPITER name here like 'JUPITER'*/
_RefRegion.ContinentName like 'JUPITER'
GO
delete FROM Tab_RefNest 
WHERE EXISTS (SELECT ID FROM Region WHERE ID = nRegionDBID)
USE [SRO_VT_SHARD]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO

Fix PET2 Skill In DataBase(new Pets)

كود بلغة HTML:

Update _RefSkill
Set Service = 1
Where Basic_Code like ('%%P2SKIL%%')
/*   */

كود بلغة HTML:

Update _RefSkill
Set Param16 = 0, Param17 = 0, Param18 = 0, Param19 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */

كود بلغة HTML:

Update _RefSkill
Set Param11 = 0, Param12 = 0, Param13 = 0, Param15 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */

كود بلغة HTML:

Update _RefSkill
Set Param14 = 0, Param15 = 0, Param16 = 0, Param17 = 0
Where Basic_Code like ('%%P2SKIL%%')
/*  */

كود بلغة HTML:

Update _RefSkill
Set Service = 0
Where ID BETWEEN 33726 And 33739
/* */

كود بلغة HTML:

Update _RefSkill
Set Service = 0
Where ID BETWEEN 33581 And 33586
/* */

Query Delete Select Item From All Game

كود بلغة HTML:

USE [SRO_VT_SHARD]

Exec [Dbo].[_SEEK_N_DESTROY_ITEM]  ['ITEM_COS_P_RABBIT_SCROLL' ]

5Page Inventory (Work 100%) Without Bug

كود PHP:


			
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

Jop Exp

كود PHP:


			
USE [SRO_VT_SHARD] --By Evo--

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;

حمـــدلله تــــم بحمـــــد الله ... !!
أن شــاء الله الموضــوع متجــدد بكــل جــديد ... !! ツ تحيــــــــــــــــــــــــــــاتى

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟

شـريـط الاهـداءات