| ●♥ Marwan1337 ♥● |
18-10-2012 04:55 PM |
كـــل الــQuery اللــى تحتاجهــــا هنـــــا
http://www4.0zz0.com/2012/10/18/13/418212205.png
بســــم الله الرحــمن الرحــيم
http://www4.0zz0.com/2012/10/18/13/497599141.gif
موضوعنا أنهاردة هيكون شامل كل ال Querys ان شاء الله وأحاول أجمع أكتر عدد من ال Query ..
نبدأ على بركة الله :)
http://www4.0zz0.com/2012/10/18/13/497599141.gif
اول حاجه حتقولي انا نفسي احط الدجري 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 مش حتأثر ع السيرفر
نرجع لموضوعنا
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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]
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
http://www4.0zz0.com/2012/10/18/13/497599141.gif
مسح الأكونتات من الداتا بيس ...
كود:
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]
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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 */
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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 */
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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:
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
http://www4.0zz0.com/2012/10/18/13/497599141.gif
Remove Pk All Players ..
كود:
USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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)
http://www4.0zz0.com/2012/10/18/13/497599141.gif
Change MaxStack
كود:
EXEC _ChangeMaxStack
@ITEMNAME = '%ITEM_ETC_ARCHEMY_MAGICSTONE%', /* ITEM TO CHANGE */
@MAXSTACK = 100 /* NEW MAXSTACK */
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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')
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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)
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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'
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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!'
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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'
http://www4.0zz0.com/2012/10/18/13/497599141.gif
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
(المشاركة 4475113)
دي شوية كويري بتفتح 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
(المشاركة 4474074)
عايز كل اللى فى الجيم يروحو جنجان
كود بلغة 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 (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0,0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
end
commit tran
return @COS_ID
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;
|
حمـــدلله تــــم بحمـــــد الله ... !!
أن شــاء الله الموضــوع متجــدد بكــل جــديد ... !! ツ تحيــــــــــــــــــــــــــــاتى
|
