| قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
18-10-2012, 04:55 PM
|
#1 | ||||||||||||
  
|
 بســــم الله الرحــمن الرحــيم  موضوعنا أنهاردة هيكون شامل كل ال Querys ان شاء الله وأحاول أجمع أكتر عدد من ال Query .. نبدأ على بركة الله :) اول حاجه حتقولي انا نفسي احط الدجري 12 و دجري 13 اقولك ماشي مفيش غير انك تفتح ال New Query Windows وتحط فيها الكود ده كود:
UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_EU%' UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_CH%' UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 8994 AND 9005 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9008 AND 9025 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9028 AND 9045 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9048 AND 9065 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9068 AND 9085 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9088 AND 9105 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9114 AND 9125 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9134 AND 9145 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID BETWEEN 9154 AND 9225 UPDATE dbo._RefObjCommon SET Service = 0 WHERE ID = 38620 حتلاقي الداتا فيها دجري 12 و 13 وطبعا الكلينت انتا حتتسرف فيه ملحوظه : الداتا سؤاء دجري 11 او 12 او 13 او 20 مش حتأثر ع السيرفر نرجع لموضوعنا Clean Log [ ال SHARDLOG] كود:
USE [LOG_DB] GO TRUNCATE TABLE [dbo].[_LogCashItem] TRUNCATE TABLE [dbo].[_LogEventChar] TRUNCATE TABLE [dbo].[_LogEventItem] TRUNCATE TABLE [dbo].[_LogEventSiegeFortress] TRUNCATE TABLE [dbo].[_LogSchedule] TRUNCATE TABLE [dbo].[_LogServerEvent] Clean Shard [ ال SHARD ] كود:
USE SRO_VT_SHARD GO truncate table _CharSkill truncate table _CharSkillMastery truncate table _GuildMember truncate table _BlockedWhisperers truncate table _Inventory truncate table _InventoryForAvatar truncate table _InventoryForLinkedStorage truncate table _TrainingCampMember truncate table _TrainingCampSubMentorHonorPoint truncate table _TrainingCampHonorRank truncate table _TrainingCampBuffStatus delete from _TrainingCamp truncate table _StaticAvatar truncate table _User truncate table _Friend truncate table _Memo truncate table _TimedJob truncate table _CharTrijobSafeTrade delete from _CharTrijob truncate table _InvCOS delete from _CharCOS where ID > 0 delete from _Char where charid > 0 truncate table _Chest truncate table _ChestInfo truncate table _ItemPool delete from _Items where ID64 > 0 delete from _AccountJID truncate table _GuildChest update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 truncate table _GuildWar delete from _Guild where ID > 0 delete from _AlliedClans where ID > 0 truncate table _CharNameList truncate table _CharQuest truncate table _ClientConfig truncate table _DeletedChar truncate table _SiegeFortressStruct truncate table _SiegeFortressStoneState truncate table _SiegeFortressRequest truncate table _SiegeFortressObject truncate table _SiegeFortressItemForge truncate table _SiegeFortressBattleRecord delete from _SiegeFortress truncate table _OpenMarket مسح الأكونتات من الداتا بيس ... كود:
USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[Test_HN] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog] TRUNCATE TABLE [dbo].[SK_ItemSaleLog] TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog] TRUNCATE TABLE [dbo].[SK_PK_UpdateLog] TRUNCATE TABLE [dbo].[SK_ResetSkillLog] TRUNCATE TABLE [dbo].[SK_Silk] TRUNCATE TABLE [dbo].[SK_SilkBuyList] TRUNCATE TABLE [dbo].[SK_SilkGoods] TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_paygate_trans] SQL Script for Media.pk2 كود:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_GetMediaLines] Script Date: 02/05/2012 12:42:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_GetMediaLines]
@Type SMALLINT,
@CodeName VARCHAR(30)
AS
IF(@Type=1)
BEGIN
SELECT
_RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,
_RefObjItem.MaxStack,_RefObjItem.ReqGender,_RefObjItem.ReqStr,_RefObjItem.ReqInt,_RefObjItem.ItemClass,_RefObjItem.SetID,_RefObjItem.Dur_L,_RefObjItem.Dur_U,_RefObjItem.PD_L,_RefObjItem.PD_U,_RefObjItem.PDInc,_RefObjItem.ER_L,_RefObjItem.ER_U,_RefObjItem.ERInc,_RefObjItem.PAR_L,_RefObjItem.PAR_U,_RefObjItem.PARInc,_RefObjItem.BR_L,_RefObjItem.BR_U,_RefObjItem.MD_L,_RefObjItem.MD_U,_RefObjItem.MDInc,_RefObjItem.MAR_L,_RefObjItem.MAR_U,_RefObjItem.MARInc,_RefObjItem.PDStr_L,_RefObjItem.PDStr_U,_RefObjItem.MDInt_L,_RefObjItem.MDInt_U,_RefObjItem.Quivered,_RefObjItem.Ammo1_TID4,_RefObjItem.Ammo2_TID4,_RefObjItem.Ammo3_TID4,_RefObjItem.Ammo4_TID4,_RefObjItem.Ammo5_TID4,_RefObjItem.SpeedClass,_RefObjItem.TwoHanded,_RefObjItem.Range,_RefObjItem.PAttackMin_L,_RefObjItem.PAttackMin_U,_RefObjItem.PAttackMax_L,_RefObjItem.PAttackMax_U,_RefObjItem.PAttackInc,_RefObjItem.MAttackMin_L,_RefObjItem.MAttackMin_U,_RefObjItem.MAttackMax_L,_RefObjItem.MAttackMax_U,_RefObjItem.MAttackInc,_RefObjItem.PAStrMin_L,_RefObjItem.PAStrMin_U,_RefObjItem.PAStrMax_L,_RefObjItem.PAStrMax_U,_RefObjItem.MAInt_Min_L,_RefObjItem.MAInt_Min_U,_RefObjItem.MAInt_Max_L,_RefObjItem.MAInt_Max_U,_RefObjItem.HR_L,_RefObjItem.HR_U,_RefObjItem.HRInc,_RefObjItem.CHR_L,_RefObjItem.CHR_U,_RefObjItem.Param1,_RefObjItem.Desc1_128,_RefObjItem.Param2,_RefObjItem.Desc2_128,_RefObjItem.Param3,_RefObjItem.Desc3_128,_RefObjItem.Param4,_RefObjItem.Desc4_128,_RefObjItem.Param5,_RefObjItem.Desc5_128,_RefObjItem.Param6,_RefObjItem.Desc6_128,_RefObjItem.Param7,_RefObjItem.Desc7_128,_RefObjItem.Param8,_RefObjItem.Desc8_128,_RefObjItem.Param9,_RefObjItem.Desc9_128,_RefObjItem.Param10,_RefObjItem.Desc10_128,_RefObjItem.Param11,_RefObjItem.Desc11_128,_RefObjItem.Param12,_RefObjItem.Desc12_128,_RefObjItem.Param13,_RefObjItem.Desc13_128,_RefObjItem.Param14,_RefObjItem.Desc14_128,_RefObjItem.Param15,_RefObjItem.Desc15_128,_RefObjItem.Param16,_RefObjItem.Desc16_128,_RefObjItem.Param17,_RefObjItem.Desc17_128,_RefObjItem.Param18,_RefObjItem.Desc18_128,_RefObjItem.Param19,_RefObjItem.Desc19_128,_RefObjItem.Param20,_RefObjItem.Desc20_128,_RefObjItem.MaxMagicOptCount,_RefObjItem.ChildItemCount
FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link=_RefObjItem.ID
WHERE _RefObjCommon.CodeName128 LIKE @CodeName AND _RefObjCommon.Service=1 ORDER BY _RefObjCommon.ID ASC
END
IF(@Type=2)
BEGIN
SELECT
_RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,
_RefObjChar.Lvl,_RefObjChar.CharGender,_RefObjChar.MaxHP,_RefObjChar.MaxMP,_RefObjChar.InventorySize,_RefObjChar.CanStore_TID1,_RefObjChar.CanStore_TID2,_RefObjChar.CanStore_TID3,_RefObjChar.CanStore_TID4,_RefObjChar.CanBeVehicle,_RefObjChar.CanControl,_RefObjChar.DamagePortion,_RefObjChar.MaxPassenger,_RefObjChar.AssocTactics,_RefObjChar.PD,_RefObjChar.MD,_RefObjChar.PAR,_RefObjChar.MAR,_RefObjChar.ER,_RefObjChar.BR,_RefObjChar.HR,_RefObjChar.CHR,_RefObjChar.ExpToGive,_RefObjChar.CreepType,_RefObjChar.Knockdown,_RefObjChar.KO_RecoverTime,_RefObjChar.DefaultSkill_1,_RefObjChar.DefaultSkill_2,_RefObjChar.DefaultSkill_3,_RefObjChar.DefaultSkill_4,_RefObjChar.DefaultSkill_5,_RefObjChar.DefaultSkill_6,_RefObjChar.DefaultSkill_7,_RefObjChar.DefaultSkill_8,_RefObjChar.DefaultSkill_9,_RefObjChar.DefaultSkill_10,_RefObjChar.TextureType,_RefObjChar.Except_1,_RefObjChar.Except_2,_RefObjChar.Except_3,_RefObjChar.Except_4,_RefObjChar.Except_5,_RefObjChar.Except_6,_RefObjChar.Except_7,_RefObjChar.Except_8,_RefObjChar.Except_9,_RefObjChar.Except_10
FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link=_RefObjChar.ID WHERE CodeName128 LIKE @CodeName AND _RefObjCommon.Service=1 ORDER BY _RefObjCommon.ID ASC
END
IF(@Type!=1 OR @Type!=2)
BEGIN
PRINT 'The Type must be 1 OR 2!'
PRINT 'Use @Type=1 for Items'
PRINT 'Use @Type=2 for Characters'
END
/* Stored Procedure by sladlejrhfpq */
Get Media Code كود:
For Get Code Meida Itemdataxxx.txt ------------ USE [SRO_VT_SHARD] exec _GetMediaLines @Type=1, @CodeName='ITEM_CH_SWORD_01%' /* or ITEM_CH_SWORD_01_A << For 1 Item WithOut %*/ For Get Code Meida characterdataxxx.txt ------------ USE [SRO_VT_SHARD] exec _GetMediaLines @Type=2, @CodeName='MOB_FW_WHITETIGER_%' /* or MOB_FW_WHITETIGER_001 << For 1 Item WithOut %*/ /* Stored Procedure by sladlejrhfpq */ Yellow Title كود:
USE SRO_VT_SHARD Declare @newHWANlevel varchar(64) Declare @blueORred int Declare @ZerkDMG tinyint Declare @CHwriting1 varchar(74) Declare @EUwriting1 varchar(74) Declare @newCHtitle varchar(74) Declare @newEUtitle varchar(74) --############################################ by Marwan Abbas --############################################ Parameter which you can change! SET @blueORred = 1145127506 /* 1145127506 for blue, 0 for red Zerk*/ SET @ZerkDMG = 95 /*e.g. for 50% more DMG; MAX = 255% change tinyint to int if you want more*/ SET @newCHtitle = 'Queen' /*new Chinese Title*/ SET @newEUtitle = 'Queen' /*new European Title*/ --############################################ END --############################################ SET @newHWANlevel = (SELECT MAX(HwanLevel) FROM _RefHWANLevel)+1 SET @CHwriting1 = 'UIO_SECOND_HWAN_CH_NAME_LEVEL_' SET @EUwriting1 = 'UIO_SECOND_HWAN_EU_NAME_LEVEL_' INSERT INTO _RefHWANLevel (HwanLevel,ParamFourcc1,ParamValue1,ParamFourcc2,ParamValue2,ParamFourcc3,ParamValue3,ParamFourcc4,ParamValue4,ParamFourcc5,ParamValue5,AssocFileObj128,Title_CH70,Title_EU70) VALUES (@newHWANlevel,1397769301,200,@blueORred,@ZerkDMG,0,0,0,0,0,0,'xxx',@CHwriting1+@newHWANlevel,@EUwriting1+@newHWANlevel); print '' print 'Media/server_dep/silkroad/textdata/textuisystem.txt' print '1 '+@CHwriting1+@newHWANlevel+' '+@newCHtitle print '1 '+@EUwriting1+@newHWANlevel+' '+@newEUtitle print '' print 'Media/server_dep/silkroad/textdata/hwanleveldata.txt' print @newHWANlevel+' UIO_SECOND_HWAN_CH_NAME_LEVEL_'+@newHWANlevel+' UIO_SECOND_HWAN_EU_NAME_LEVEL_'+@newHWANlevel Add Spot Uniques كود:
USE SRO_VT_SHARD /* Add Unique Spot By Marwan Abbas */ DECLARE @UNIQUE VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) DECLARE @mindealy INT DECLARE @maxdelay int DECLARE @INITRADIUS INT DECLARE @RADIUS int DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1 /* put your settings here */ SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z SET @mindealy = 60 -- Minimum time before appears in seconds SET @maxdelay = 120 -- Maximum time before appears in seconds SET @INITRADIUS = 100 -- Radius around spot unique can generated at SET @RADIUS = 500 -- Radius around spot Unique can move in /* end of settings area */ /* get ID of mob by code name */ Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE) SET IDENTITY_INSERT Tab_RefTactics ON INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES (@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE) SET IDENTITY_INSERT Tab_RefTactics OFF SET IDENTITY_INSERT Tab_RefHive ON INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES (@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE) SET IDENTITY_INSERT Tab_RefHive OFF /* get position coordinates of your character */ DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) SET IDENTITY_INSERT Tab_RefNest ON INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES (@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0) SET IDENTITY_INSERT Tab_RefNest OFF print '' print '' print 'Done!' /**Because query will not work as it with BR files due to the difference between tables so: For Privileged IP كود:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
DROP TABLE _PrivilegedIP
GO
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO
Plvl Char :) كود:
USE [SRO_VT_SHARD] Declare @CharName VarChar(max) Declare @Level BigInt SET @CharName= '’Marwan Abbas' --CharName SET @Level = '120' --Level UPDATE [Dbo].[_Char] SET InventorySize = '109', --Iventory Size Min 45 max 109 RemainGold = RemainGold + '1', --GOLD to give HwanLevel = '0', --Zerk Level ( 0 to none ) RemainSkillPoint = RemainSkillPoint + '101000', --SkillPoint to give CurLevel = @Level, MaxLevel = @Level, Strength = @Level+19, Intellect = @Level+19, RemainStatPoint = @Level * 3 -3, RemainHwanCount = 5, --RemainHwanCount ExpOffset = 1-- Exp WHERE CharName16 = @CharName Remove Pk All Players .. كود:
USE [SRO_VT_SHARD] UPDATE _Char SET DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 Remove Pk By Char Name .. كود:
USE [SRO_VT_SHARD] DECLARE @CharName Varchar(max) SET @CharName = 'Kira' UPDATE _Char SET RemainHwanCount = 5, DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 WHERE CharName16 = @CharName Give Items to Char كود:
USE SRO_VT_SHARD --Usage: --exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl declare @CharName varchar(64) set @CharName = 'Marwan Abbas' exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MOVE_SPEED_UP_100',1000,1 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_AA_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_SA_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_FA_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_HA_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_LA_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_M_LIGHT_13_BA_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_RING_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_EARRING_13_C_RARE',1,12 exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_NECKLACE_13_C_RARE',1,12 Give 120 Mastry to Char كود:
USE [SRO_VT_SHARD] GO --by Marwan Abbas Declare @CharName Varchar (64) Set @CharName = 'Marwan Abbas' UPDATE [dbo].[_CharSkillMastery] SET Level= 120 WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName) Change MaxStack كود:
EXEC _ChangeMaxStack @ITEMNAME = '%ITEM_ETC_ARCHEMY_MAGICSTONE%', /* ITEM TO CHANGE */ @MAXSTACK = 100 /* NEW MAXSTACK */ Add New Drop Item In Unique Or Mob كود:
USE SRO_VT_SHARD_INIT GO DECLARE @MonsterID int DECLARE @ItemID int DECLARE @DropRatio real SET @MonsterID = 24160 -- You can find Monster ID's at RefObjCommon SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course SET @ItemID = 35773 -- You can find Item ID's at RefObjCommon INSERT _RefMonster_AssignedItemDrop ( RefMonsterID, RefItemID, DropGroupType, OptLevel, DropAmountMin, DropAmountMax, DropRatio, RefMagicOptionID1, CustomValue1, RefMagicOptionID2, CustomValue2, RefMagicOptionID3, CustomValue3, RefMagicOptionID4, CustomValue4, RefMagicOptionID5, CustomValue5, RefMagicOptionID6, CustomValue6, RefMagicOptionID7, CustomValue7, RefMagicOptionID8, CustomValue8, RefMagicOptionID9, CustomValue9, RentCodeName ) VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx') Remove All Skill By Char كود:
USE [SRO_VT_SHARD_INIT] GO --by Marwan Abbas , Input their name here, and set their skill level you desire. Declare @CharName Varchar (64) Set @CharName = 'Marwan Abbas' UPDATE [dbo].[_CharSkill] SET CharID= 0 WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName) Search About Item In Char كود:
Use SRO_VT_SHARD_INIT Select IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF Right Join _Items As IT On IT.RefItemID = REF.ID Right Join _Inventory As INV On INV.ItemID = IT.ID64 Right Join _Char as CH On CH.CharID = INV.CharID Where CodeName128 like 'TSWORD_12_C_RARE' Add New Qustom Teleport كود:
USE SRO_VT_SHARD /* Add new Teleport By Marwan Abbas */
DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT
/* Put your settings here */
SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000 -- Gold amount to Pass the teleport
SET @RequiredLVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport
/* settings area end here */
IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport)
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);
RETURN;
END
DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link)
SET IDENTITY_INSERT _RefObjCommon OFF
print ''
print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_'+@Teleport+' '+@Teleport+' xxx '+'SN_STORE_'+@Teleport+' xxx 0 0 4 1 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 '+CONVERT(varchar(max),@REGION1)+' 0 '+CONVERT(varchar(max),@POSX1)+' '+CONVERT(varchar(max),@POSY1)+' '+CONVERT(varchar(max),@POSZ1)+' 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx '+CONVERT(varchar(max),@link)
print ''
print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_'+@Teleport+'
print ''
print ''
SET IDENTITY_INSERT _RefObjStruct ON
INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
(@LINK,0)
SET IDENTITY_INSERT _RefObjStruct OFF
DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)
INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0)
print ''
print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0'
print ''
print ''
IF @RequiredLVL = 0
BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
print ''
print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
ELSE BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0)
print ''
print ''
print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max),@RequiredLVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
print ''
print 'Done!'
Change Alchemy Rate 1.5x كود:
USE [SRO_VT_SHARD_INIT] UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2033' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2034' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2035' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2036' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2037' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2038' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2039' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2040' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2041' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2042' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2043' UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='336202250' where ID='2044' Lucky Powder Rate 1 كود:
USE [SRO_VT_SHARD_INIT] /*SQL Query made by Marwan Abbas*/ DECLARE @RATE INT SET @RATE=1 UPDATE dbo._RefObjItem SET Param2=(Param2*@RATE) WHERE ID BETWEEN '2033' AND '2054' UPDATE dbo._RefObjItem SET Param3=(Param3*@RATE) WHERE ID BETWEEN '2033' AND '2054' UPDATE dbo._RefObjItem SET Param4=(Param4*@RATE) WHERE ID BETWEEN '2033' AND '2054' اقتباس:
اقتباس:
حمـــدلله تــــم بحمـــــد الله ... !! أن شــاء الله الموضــوع متجــدد بكــل جــديد ... !! ツ تحيــــــــــــــــــــــــــــاتى |
||||||||||||
|
التعديل الأخير تم بواسطة ●♥ Marwan1337 ♥● ; 17-12-2012 الساعة 12:33 PM
|
| إعلانات google |
|
|
|
18-10-2012, 05:05 PM
|
#2 | ||||||||||
  
|
الله ينور يا ريس ولى شرف اول رد على الموضوع |
||||||||||
|
|
|
18-10-2012, 05:09 PM
|
#3 | |||||||||||
|
اقتباس:
|
|||||||||||
|
|
|
18-10-2012, 05:11 PM
|
#4 | ||||||||||
 
|
أه بقا يا مارو رجعنا شغل زمان بسم الله ما شاء الله عليك الله ينور والله |
||||||||||
|
التعديل الأخير تم بواسطة ™Anas™ ; 18-10-2012 الساعة 05:13 PM
|
|
18-10-2012, 05:15 PM
|
#5 | |||||||||||
|
اقتباس:
شكرا يا معلم على مرورك :) أنا قولت نريح الأعضاء شوية ^^ |
|||||||||||
|
|
|
18-10-2012, 05:24 PM
|
#6 | ||||||||||
  
|
الله ينور ياااض .gif "111 (5)") |
||||||||||
|
|
|
18-10-2012, 05:48 PM
|
#7 | ||||||||||
  ![الصورة الرمزية [Dev] Arshivel](image.php?s=fbafe9dcffe39a0e8495724f5d61282b&u=99172&dateline=1351541786)
|
الله يتور استمر يا مروان يا رهوان  |
||||||||||
|
|
|
18-10-2012, 05:52 PM
|
#8 | ||||||||||||
|
اقتباس:
اقتباس:
|
||||||||||||
|
التعديل الأخير تم بواسطة ●♥ Marwan1337 ♥● ; 18-10-2012 الساعة 05:56 PM
|
|
18-10-2012, 05:55 PM
|
#9 | ||||||||||
 
|
اىوة باءا هو دة الشغل تسلم يا مروان |
||||||||||
|
|
|
18-10-2012, 05:58 PM
|
#10 | |||||||||||
|
اقتباس:
|
|||||||||||
|
|
|
18-10-2012, 09:43 PM
|
#11 | ||||||||||
 
|
نـــجم مـــن يومك حبيبي ::) |
||||||||||
|
|
|
19-10-2012, 01:00 AM
|
#12 | ||||||||||
  
|
استاذ يا ابنى من يومك  |
||||||||||
|
|
|
19-10-2012, 02:42 AM
|
#13 | ||||||||||
|
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 انا مش فاهم دا بيعمل اة  |
||||||||||
|
|
|
19-10-2012, 02:46 AM
|
#14 | ||||||||||
 
|
الله عليك حبيب قلبى مروان وتسلم ايدك |
||||||||||
|
|
|
19-10-2012, 10:06 AM
|
#15 | ||||||||||||
|
اقتباس:
اقتباس:
شــكرا يـا أحمـــد ... :) |
||||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه
|
||||
| الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
| حصريـــا أضخم مكتبة الــQuery اللــى تحتاجهــــا هنـــــا | Mahmoud Rashwan | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 23 | 14-05-2014 01:46 AM |
| ظــاهرة المــد الأحمــر !! | CHI-VA | بـعـيـدآ عـن سـيـلـك رود | 10 | 22-09-2013 02:18 PM |
| إلى كـــل حزيــــــــــــن وإلى كـــل مهمـــــــــــومـ .... ماذا قال الله لكــــمـ.. | ☜ ĂиTaKą ☞ | القـسـم الإسـلامـى الـعـام | 8 | 23-05-2013 07:25 AM |
| ***: █ ₪ حصريـــا أضخم مكتبة الــQuery اللــى تحتاجهــــا هنـــــا ₪ █*** | Mahmoud Rashwan | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 15 | 29-03-2013 03:12 AM |
.gif){kind=icon}
العرض العادي
