المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : كـــل الــQuery اللــى تحتاجهــــا هنـــــا

●♥ Marwan1337 ♥●
18-10-2012, 04:55 PM
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.pk2USE [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,_RefObjComm on.CodeName128,_RefObjCommon.ObjName128,_RefObjCom mon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_ RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_ RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjC ommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon. TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Coun try,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_R efObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCo mmon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon .CanPick,_RefObjCommon.CanRepair,_RefObjCommon.Can Revive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow ,_RefObjCommon.Price,_RefObjCommon.CostRepair,_Ref ObjCommon.CostRevive,_RefObjCommon.CostBorrow,_Ref ObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefO bjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_Re fObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_ RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3 ,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLeve l4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID ,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCo mmon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.S peed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_Re fObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObj Common.EventID,_RefObjCommon.AssocFileObj128,_RefO bjCommon.AssocFileDrop128,_RefObjCommon.AssocFileI con128,_RefObjCommon.AssocFile1_128,_RefObjCommon. AssocFile2_128,
_RefObjItem.MaxStack,_RefObjItem.ReqGender,_RefObj Item.ReqStr,_RefObjItem.ReqInt,_RefObjItem.ItemCla ss,_RefObjItem.SetID,_RefObjItem.Dur_L,_RefObjItem .Dur_U,_RefObjItem.PD_L,_RefObjItem.PD_U,_RefObjIt em.PDInc,_RefObjItem.ER_L,_RefObjItem.ER_U,_RefObj Item.ERInc,_RefObjItem.PAR_L,_RefObjItem.PAR_U,_Re fObjItem.PARInc,_RefObjItem.BR_L,_RefObjItem.BR_U, _RefObjItem.MD_L,_RefObjItem.MD_U,_RefObjItem.MDIn c,_RefObjItem.MAR_L,_RefObjItem.MAR_U,_RefObjItem. MARInc,_RefObjItem.PDStr_L,_RefObjItem.PDStr_U,_Re fObjItem.MDInt_L,_RefObjItem.MDInt_U,_RefObjItem.Q uivered,_RefObjItem.Ammo1_TID4,_RefObjItem.Ammo2_T ID4,_RefObjItem.Ammo3_TID4,_RefObjItem.Ammo4_TID4, _RefObjItem.Ammo5_TID4,_RefObjItem.SpeedClass,_Ref ObjItem.TwoHanded,_RefObjItem.Range,_RefObjItem.PA ttackMin_L,_RefObjItem.PAttackMin_U,_RefObjItem.PA ttackMax_L,_RefObjItem.PAttackMax_U,_RefObjItem.PA ttackInc,_RefObjItem.MAttackMin_L,_RefObjItem.MAtt ackMin_U,_RefObjItem.MAttackMax_L,_RefObjItem.MAtt ackMax_U,_RefObjItem.MAttackInc,_RefObjItem.PAStrM in_L,_RefObjItem.PAStrMin_U,_RefObjItem.PAStrMax_L ,_RefObjItem.PAStrMax_U,_RefObjItem.MAInt_Min_L,_R efObjItem.MAInt_Min_U,_RefObjItem.MAInt_Max_L,_Ref ObjItem.MAInt_Max_U,_RefObjItem.HR_L,_RefObjItem.H R_U,_RefObjItem.HRInc,_RefObjItem.CHR_L,_RefObjIte m.CHR_U,_RefObjItem.Param1,_RefObjItem.Desc1_128,_ RefObjItem.Param2,_RefObjItem.Desc2_128,_RefObjIte m.Param3,_RefObjItem.Desc3_128,_RefObjItem.Param4, _RefObjItem.Desc4_128,_RefObjItem.Param5,_RefObjIt em.Desc5_128,_RefObjItem.Param6,_RefObjItem.Desc6_ 128,_RefObjItem.Param7,_RefObjItem.Desc7_128,_RefO bjItem.Param8,_RefObjItem.Desc8_128,_RefObjItem.Pa ram9,_RefObjItem.Desc9_128,_RefObjItem.Param10,_Re fObjItem.Desc10_128,_RefObjItem.Param11,_RefObjIte m.Desc11_128,_RefObjItem.Param12,_RefObjItem.Desc1 2_128,_RefObjItem.Param13,_RefObjItem.Desc13_128,_ RefObjItem.Param14,_RefObjItem.Desc14_128,_RefObjI tem.Param15,_RefObjItem.Desc15_128,_RefObjItem.Par am16,_RefObjItem.Desc16_128,_RefObjItem.Param17,_R efObjItem.Desc17_128,_RefObjItem.Param18,_RefObjIt em.Desc18_128,_RefObjItem.Param19,_RefObjItem.Desc 19_128,_RefObjItem.Param20,_RefObjItem.Desc20_128, _RefObjItem.MaxMagicOptCount,_RefObjItem.ChildItem Count
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,_RefObjComm on.CodeName128,_RefObjCommon.ObjName128,_RefObjCom mon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_ RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_ RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjC ommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon. TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Coun try,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_R efObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCo mmon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon .CanPick,_RefObjCommon.CanRepair,_RefObjCommon.Can Revive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow ,_RefObjCommon.Price,_RefObjCommon.CostRepair,_Ref ObjCommon.CostRevive,_RefObjCommon.CostBorrow,_Ref ObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefO bjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_Re fObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_ RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3 ,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLeve l4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID ,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCo mmon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.S peed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_Re fObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObj Common.EventID,_RefObjCommon.AssocFileObj128,_RefO bjCommon.AssocFileDrop128,_RefObjCommon.AssocFileI con128,_RefObjCommon.AssocFile1_128,_RefObjCommon. AssocFile2_128,
_RefObjChar.Lvl,_RefObjChar.CharGender,_RefObjChar .MaxHP,_RefObjChar.MaxMP,_RefObjChar.InventorySize ,_RefObjChar.CanStore_TID1,_RefObjChar.CanStore_TI D2,_RefObjChar.CanStore_TID3,_RefObjChar.CanStore_ TID4,_RefObjChar.CanBeVehicle,_RefObjChar.CanContr ol,_RefObjChar.DamagePortion,_RefObjChar.MaxPassen ger,_RefObjChar.AssocTactics,_RefObjChar.PD,_RefOb jChar.MD,_RefObjChar.PAR,_RefObjChar.MAR,_RefObjCh ar.ER,_RefObjChar.BR,_RefObjChar.HR,_RefObjChar.CH R,_RefObjChar.ExpToGive,_RefObjChar.CreepType,_Ref ObjChar.Knockdown,_RefObjChar.KO_RecoverTime,_RefO bjChar.DefaultSkill_1,_RefObjChar.DefaultSkill_2,_ RefObjChar.DefaultSkill_3,_RefObjChar.DefaultSkill _4,_RefObjChar.DefaultSkill_5,_RefObjChar.DefaultS kill_6,_RefObjChar.DefaultSkill_7,_RefObjChar.Defa ultSkill_8,_RefObjChar.DefaultSkill_9,_RefObjChar. DefaultSkill_10,_RefObjChar.TextureType,_RefObjCha r.Except_1,_RefObjChar.Except_2,_RefObjChar.Except _3,_RefObjChar.Except_4,_RefObjChar.Except_5,_RefO bjChar.Except_6,_RefObjChar.Except_7,_RefObjChar.E xcept_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,P aramValue2,ParamFourcc3,ParamValue3,ParamFourcc4,P aramValue4,ParamFourcc5,ParamValue5,AssocFileObj12 8,Title_CH70,Title_EU70) VALUES (@newHWANlevel,1397769301,200,@blueORred,@ZerkDMG, 0,0,0,0,0,0,'xxx',@CHwriting1+@newHWANlevel,@EUwri ting1+@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,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0 ,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0, 2,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF

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

/* get position coordinates of your character */

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

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


print ''
print ''
print 'Done!'
/**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 IPUSE [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 CharUSE [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 MaxStackEXEC _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 MobUSE 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 CharUse 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 TeleportUSE 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,OrgObjCodeName1 28,NameStrID128,DescStrID128,CashItem,Bionic,TypeI D1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarit y,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPic k,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRe pair,CostRevive,CostBorrow,KeepingFee,SellPrice,Re qLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqL evelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCon tain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,S peed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj 128,AssocFileDrop128,AssocFileIcon128,AssocFile1_1 28,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',@lin k)
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,Ass ocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos _Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGot oResurrectPos,GenWorldID,BindInteractionMask,Fixed Service) VALUES
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport, @MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POS Y2,@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,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,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,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,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,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLV L,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.5xUSE [SRO_VT_SHARD_INIT]
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2044'
http://www4.0zz0.com/2012/10/18/13/497599141.gif
Lucky Powder Rate 1USE [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'


دي شوية كويري بتفتح d14 set and weopens and accsory
و كل ال ديجري تاريبن انا العملها كولها
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*/


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


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

عايز كل اللى فى الجيم يروحو جنجان
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
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
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
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
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
JUPITER - Jupiter
SD - DESERT OF ALEX
DELTA - Alexandria
Eu - Constantinople
Ca - Central Asia (Samarkand)
Pharaoh - HOLY TEMPLE
KingsValley - ALEX DOWN
TEMPLE - JOB CAVE ALEXANDRIA
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)
Update _RefSkill
Set Service = 1
Where Basic_Code like ('%%P2SKIL%%')
/* */
Update _RefSkill
Set Param16 = 0, Param17 = 0, Param18 = 0, Param19 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */
Update _RefSkill
Set Param11 = 0, Param12 = 0, Param13 = 0, Param15 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */
Update _RefSkill
Set Param14 = 0, Param15 = 0, Param16 = 0, Param17 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */
Update _RefSkill
Set Service = 0
Where ID BETWEEN 33726 And 33739
/* */
Update _RefSkill
Set Service = 0
Where ID BETWEEN 33581 And 33586
/* */

Query Delete Select Item From All Game
USE [SRO_VT_SHARD]

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

5Page Inventory (Work 100%) Without Bug
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
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;



حمـــدلله تــــم بحمـــــد الله ... !!
أن شــاء الله الموضــوع متجــدد بكــل جــديد ... !! ツ تحيــــــــــــــــــــــــــــاتى
ღ♥_iMoRy_♥ღ
18-10-2012, 05:05 PM
الله ينور يا ريس ولى شرف اول رد على الموضوع
●♥ Marwan1337 ♥●
18-10-2012, 05:09 PM
الله ينور يا ريس ولى شرف اول رد على الموضوع

شكــرا والله أنـا بحضـروا بقالـى يومـان .. عشـان نريـح الأعضــاء شويـة ^^
™Anas™
18-10-2012, 05:11 PM
أه بقا يا مارو رجعنا شغل زمان بسم الله ما شاء الله عليك
الله ينور والله
●♥ Marwan1337 ♥●
18-10-2012, 05:15 PM
أه بقا يا مارو رجعنا شغل زمان بسم الله ما شاء الله علي
الله ينور والله

والله أنت حبيبى يا أنس :)
شكرا يا معلم على مرورك :)
أنا قولت نريح الأعضاء شوية ^^
ღ♥Franky♥ღ
18-10-2012, 05:24 PM
الله ينور ياااض
:111 (5):
[Dev] Arshivel
18-10-2012, 05:48 PM
الله يتور استمر يا مروان يا رهوان :director:
●♥ Marwan1337 ♥●
18-10-2012, 05:52 PM
الله ينور ياااض
:111 (5):

شكـــــرا يـا تيــــت ... :))
الله يتور استمر يا مروان يا رهوان :director:
شكـــرا أ صاحبــى .. :)
omarradi1997
18-10-2012, 05:55 PM
اىوة باءا هو دة الشغل تسلم يا مروان
●♥ Marwan1337 ♥●
18-10-2012, 05:58 PM
اىوة باءا هو دة الشغل تسلم يا مروان

شـــكرا يـا مـــعلم .. :)
ღ♥CarLeTo♥ღ
18-10-2012, 09:43 PM
نـــجم مـــن يومك حبيبي ::)
kakan
19-10-2012, 01:00 AM
استاذ يا ابنى من يومك
:clapping:
ღ♥Alexandria♥ღ
19-10-2012, 02:42 AM
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


انا مش فاهم دا بيعمل اة


:lmfao::lmfao::lmfao::lmfao::lmfao::lmfao:
Last_Fiddler
19-10-2012, 02:46 AM
الله عليك حبيب قلبى مروان وتسلم ايدك
●♥ Marwan1337 ♥●
19-10-2012, 10:06 AM
نـــجم مـــن يومك حبيبي ::)

ألـــف شــــكر يــا حبــى :)

استاذ يا ابنى من يومك
:clapping:

شــكرا يـا أحمـــد ... :)
●♥ Marwan1337 ♥●
19-10-2012, 10:12 AM
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



انا مش فاهم دا بيعمل اة


:lmfao::lmfao::lmfao::lmfao::lmfao::lmfao:

حضــرتك كـل Query مكتــوب بيعمــل ايــه ...
والــ Query ده بيعمــل "Search About Item In Char"
يعنــى بيعمــل بحـث عـن Item :)
●♥ Marwan1337 ♥●
19-10-2012, 10:16 AM
الله عليك حبيب قلبى مروان وتسلم ايدك

شكـــرا أ صاحبـــى ... :)
matraxs2
19-10-2012, 02:18 PM
تسلم
F18
19-10-2012, 02:41 PM
يومين ايه حضرتك انت وخد كوبى باست من ال gm helper
بس تمام
●♥ Marwan1337 ♥●
19-10-2012, 03:24 PM
يومين ايه حضرتك انت وخد كوبى باست من ال gm helper
بس تمام

1- شكـــرا لمــروركـ ...
2- لمــا الموضـوع سهــل أوى كــده أنــو يتعمــل طــب معملتهــوش حضــرتكـ ليــه ?!
3- و الكويــرى مــش كلهــم مـن Gm Helper أنـا جايــب مــن أكتــر مـن حتــة ...
4 - و يا عــم أقســم بـالله انـا منســق الموضـوع ده وبعملــوا بقــالى أكتــر مـن يومـان بـس والله هـى غلطتــى أنـا أنـى عملتــوا ...

شكرا ... !
●♥ Marwan1337 ♥●
19-10-2012, 03:25 PM
تسلم

Thanks :)
افندينا ™Hamboka™
19-10-2012, 06:02 PM
لا بجد الله ينور يا مروان
hosam1eg
19-10-2012, 09:38 PM
Change MaxStack
كود:
EXEC _ChangeMaxStack
@ITEMNAME = '%ITEM_ETC_ARCHEMY_MAGICSTONE%', /* ITEM TO CHANGE */
@MAXSTACK = 100 /* NEW MAXSTACK


لو سمحت طرسقة استخدام الكويرى ده
●♥ Marwan1337 ♥●
19-10-2012, 09:42 PM
لا بجد الله ينور يا مروان

شكـــــ يا معلم ــــــرا .... :)
™Anas™
19-10-2012, 09:45 PM
يومين ايه حضرتك انت وخد كوبى باست من ال gm helper
بس تمام

كنت تعمله إنتا
لو هتخش على موضوع تقول شكرا ماشي غير كده متعلقش على شغل حد
المشرفين هما إللي يعلقو حضرتك عليك تخش تقول شكرا أو إيه إللي بايظ فيه
شكرا
●♥ Marwan1337 ♥●
19-10-2012, 09:50 PM
Change MaxStack
كود:
EXEC _ChangeMaxStack
@ITEMNAME = '%ITEM_ETC_ARCHEMY_MAGICSTONE%', /* ITEM TO CHANGE */
@MAXSTACK = 100 /* NEW MAXSTACK


لو سمحت طرسقة استخدام الكويرى ده

"Open " New Query وبعــدين أكتـــب الكويــرى وغيــر الــ "NEW MAXSTACK" لــ الــرقم اللــى أنــت عايـــزوا .. :)
hosam1eg
19-10-2012, 10:17 PM
"open " new query وبعــدين أكتـــب الكويــرى وغيــر الــ "new maxstack" لــ الــرقم اللــى أنــت عايـــزوا .. :)

تمام لكن

1- ده لكل الايتم اللى فى اللعبة

2- لو انا عايز اعمل ماكس استيتس لابتم معبن اعمل ايه؟؟؟
™Anas™
19-10-2012, 10:22 PM
تمام لكن

1- ده لكل الايتم اللى فى اللعبة

2- لو انا عايز اعمل ماكس استيتس لابتم معبن اعمل ايه؟؟؟

يا باشا لأ ده مش ماكس ستاتس ده بيخلي الحاجات تتحط على بعضها يعني ^^
بمعني إنك تحط كام Potion على بعض أو كام إليكسر وكده
hosam1eg
19-10-2012, 11:00 PM
يا باشا لأ ده مش ماكس ستاتس ده بيخلي الحاجات تتحط على بعضها يعني ^^
بمعني إنك تحط كام Potion على بعض أو كام إليكسر وكده

اسف فهمتها غلط

:boxed2::boxed2:

فى كويرى يعمل ماكس بلو

او طريقة عمل ماكس بلو
●♥ Marwan1337 ♥●
20-10-2012, 12:54 AM
اسف فهمتها غلط

:boxed2::boxed2:

فى كويرى يعمل ماكس بلو

او طريقة عمل ماكس بلو

لأ عــادى ولا يهمـــكـ

أظـــن أن مفيــش كويــرى عشــان الماكــس بلــو ..
Mahmoud Rashwan
20-10-2012, 01:16 AM
الله ينور بجد استمر
●♥ Marwan1337 ♥●
20-10-2012, 02:00 AM
الله ينور بجد استمر

شكـــــ يـا معلـم ــــــرا ... :)
hosam1eg
20-10-2012, 01:35 PM
لأ عــادى ولا يهمـــكـ

أظـــن أن مفيــش كويــرى عشــان الماكــس بلــو ..

مفيش اى طريقة لعمل ماكس للايتم
™Anas™
20-10-2012, 01:46 PM
مفيش اى طريقة لعمل ماكس للايتم

من smc
hosam1eg
20-10-2012, 04:40 PM
من smc



ازاى لو سمحت؟
AhmedElomda
22-10-2012, 01:42 AM
السـلامـ عليكمـ ورحمه الله وبركاته

لو سمحت عايز أعرف أزاي أضيف ،، الـ New pet's اللي بيتركب فـ الـ NPC

وأزاي أضيف Item D14 فـ الـ NPC زي ما أحب (Rare-Sun-Nova) على حسب ما أختار يعني

ولكمـ جزيل الشكر
FlameRoadOnline
22-10-2012, 01:30 PM
يا جماعه عايز احط d14 ايتمز عند ال npc

يا ريت حد يساعدي

و شكرا
ღ♥ Destination ♥ღ
01-11-2012, 12:41 AM
Thanks Alot Marwan :)
●♥ Marwan1337 ♥●
01-11-2012, 05:59 PM
Thanks Alot Marwan :)

شكـــرا لمــروركـ
●♥ Marwan1337 ♥●
03-11-2012, 01:03 AM
Closed
#

لعــدمـ الحـاجــه إلــى الــردود .

ويـا ريــتـ أى حــد عنــدوا مشكلــة مـنـ كويــرى أو أى مشكلة تانيــة يعمــلـ مـوضــوعـ جـديــد ..