شـريـط الاهـداءات |
|
| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
24-02-2013, 12:39 AM
|
#1 | ||||||||||
  
|
عايز اشيل حاجه من magicpop
|
||||||||||
|
| إعلانات google |
|
|
|
24-02-2013, 04:07 AM
|
#2 | ||||||||||||
  
|
من ال db فى _RefGachaItemSet فى الميديا من gachaitemset.txt |
||||||||||||
|
|
|
24-02-2013, 02:13 PM
|
#3 | ||||||||||||
  
|
وكمان تشوف اسم الحاجة الي عاوز تشيلها وتشيله
|
||||||||||||
|
|
|
24-02-2013, 06:20 PM
|
#4 | ||||||||||||
  
|
♥♥Some helpful queries from my old host♥ ♥
اولا نبتدي بالخفيف ------------------------------------------------------------------------------------------------------------------ لو عندك ايتم في بج في الجيم و عايز تمسحه من عند الناس هتعمل الكويري دي كود PHP: USE [SRO_VT_SHARD] exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING' طبعا هتغير كود الجلوبال بالكود اللي انت عايزه ------------------------------------------------------------------------------------- ضريت بريميم غلط و عايز تشيله هتعمل الكويري دي كود PHP: DELETE FROM [SRO_VT_SHARD].[dbo].[_TimedJob] WHERE CharID = 'CHAR ID' هنغير ال CHAR ID بال ID بتاع الاكونت من SRO_VT_SHARD > Char ------------------------------------------------------------------------------------- بوظط حاجه في الجيم و العيال مطلعه عينك و عايز تحطلهم سيلك عشان يتخرصوا :D الكويري ده هيحطلك سيلك للناس كلها اللي في الجيم كود PHP: /***********Wrote by Mrs_Mero***********/ USE SRO_VT_ACCOUNT; GO INSERT INTO SK_SILK (JID, silk_own, silk_gift, silk_point) SELECT JID, '0', '0', '0' FROM TB_User WHERE not exists (select * from SK_Silk WHERE SK_SILK.JID = TB_User.JID); UPDATE SK_Silk SET silk_own=silk_own+10 /***********Wrote by Mrs_Mero***********/ الاصفار اللي فوق دي اللي هي Silk , Silk point , Silk gift حط اللي انت عايزه ------------------------------------------------------------------------------------- عايز تعمل Max Account for every IP هتحط ده في ال Server.cfg كود PHP: GlobalManager { Certification "Your IP!", 32000 LoginFailureTolerance 3 IBUVFailureTolerance 3 LoginFailureBlockTimeMin 10 IBUVFailureBlockTimeMin 10 AutomatedPunisher "AutomatedPunisher" LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times" LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times" IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times" IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times" NetCafeIPRefreshTime 2 MaxUserForNonePCBangIP 2 Change The NetCafeIPRefreshTime & MaxUserForNonePCBangIP "2" To IP Per Player! Tested on vSRO working 100% مجربه علي vSRO ------------------------------------------------------------------------------------- SRO_VT_SHARD استخدمها على الشارد يااحمد عايز تفتح كل السيكلات في اكونت الجي ام من غير ما تبوظ الماوس بتاعك كود PHP: DECLARE @CharName varchar(255) DECLARE @CharID INT SET @CharName='Mrs_Mero' SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID INSERT INTO _CharSkill VALUES (@CharID,1,1) INSERT INTO _CharSkill VALUES (@CharID,2,1) INSERT INTO _CharSkill VALUES (@CharID,40,1) INSERT INTO _CharSkill VALUES (@CharID,70,1) INSERT INTO _CharSkill VALUES (@CharID,298,1) INSERT INTO _CharSkill VALUES (@CharID,306,1) INSERT INTO _CharSkill VALUES (@CharID,314,1) INSERT INTO _CharSkill VALUES (@CharID,322,1) INSERT INTO _CharSkill VALUES (@CharID,346,1) INSERT INTO _CharSkill VALUES (@CharID,378,1) INSERT INTO _CharSkill VALUES (@CharID,418,1) INSERT INTO _CharSkill VALUES (@CharID,463,1) INSERT INTO _CharSkill VALUES (@CharID,558,1) INSERT INTO _CharSkill VALUES (@CharID,569,1) INSERT INTO _CharSkill VALUES (@CharID,580,1) INSERT INTO _CharSkill VALUES (@CharID,588,1) INSERT INTO _CharSkill VALUES (@CharID,596,1) INSERT INTO _CharSkill VALUES (@CharID,604,1) INSERT INTO _CharSkill VALUES (@CharID,647,1) INSERT INTO _CharSkill VALUES (@CharID,655,1) INSERT INTO _CharSkill VALUES (@CharID,672,1) INSERT INTO _CharSkill VALUES (@CharID,689,1) INSERT INTO _CharSkill VALUES (@CharID,699,1) INSERT INTO _CharSkill VALUES (@CharID,708,1) INSERT INTO _CharSkill VALUES (@CharID,716,1) INSERT INTO _CharSkill VALUES (@CharID,724,1) INSERT INTO _CharSkill VALUES (@CharID,735,1) INSERT INTO _CharSkill VALUES (@CharID,746,1) INSERT INTO _CharSkill VALUES (@CharID,757,1) INSERT INTO _CharSkill VALUES (@CharID,765,1) INSERT INTO _CharSkill VALUES (@CharID,773,1) INSERT INTO _CharSkill VALUES (@CharID,781,1) INSERT INTO _CharSkill VALUES (@CharID,789,1) INSERT INTO _CharSkill VALUES (@CharID,797,1) INSERT INTO _CharSkill VALUES (@CharID,805,1) INSERT INTO _CharSkill VALUES (@CharID,813,1) INSERT INTO _CharSkill VALUES (@CharID,821,1) INSERT INTO _CharSkill VALUES (@CharID,829,1) INSERT INTO _CharSkill VALUES (@CharID,853,1) INSERT INTO _CharSkill VALUES (@CharID,885,1) INSERT INTO _CharSkill VALUES (@CharID,925,1) INSERT INTO _CharSkill VALUES (@CharID,933,1) INSERT INTO _CharSkill VALUES (@CharID,943,1) INSERT INTO _CharSkill VALUES (@CharID,952,1) INSERT INTO _CharSkill VALUES (@CharID,960,1) INSERT INTO _CharSkill VALUES (@CharID,968,1) INSERT INTO _CharSkill VALUES (@CharID,976,1) INSERT INTO _CharSkill VALUES (@CharID,984,1) INSERT INTO _CharSkill VALUES (@CharID,992,1) INSERT INTO _CharSkill VALUES (@CharID,1003,1) INSERT INTO _CharSkill VALUES (@CharID,1014,1) INSERT INTO _CharSkill VALUES (@CharID,1025,1) INSERT INTO _CharSkill VALUES (@CharID,1033,1) INSERT INTO _CharSkill VALUES (@CharID,1041,1) INSERT INTO _CharSkill VALUES (@CharID,1049,1) INSERT INTO _CharSkill VALUES (@CharID,1053,1) INSERT INTO _CharSkill VALUES (@CharID,1057,1) INSERT INTO _CharSkill VALUES (@CharID,1065,1) INSERT INTO _CharSkill VALUES (@CharID,1073,1) INSERT INTO _CharSkill VALUES (@CharID,1081,1) INSERT INTO _CharSkill VALUES (@CharID,1089,1) INSERT INTO _CharSkill VALUES (@CharID,1099,1) INSERT INTO _CharSkill VALUES (@CharID,1108,1) INSERT INTO _CharSkill VALUES (@CharID,1116,1) INSERT INTO _CharSkill VALUES (@CharID,1124,1) INSERT INTO _CharSkill VALUES (@CharID,1132,1) INSERT INTO _CharSkill VALUES (@CharID,1140,1) INSERT INTO _CharSkill VALUES (@CharID,1148,1) INSERT INTO _CharSkill VALUES (@CharID,1153,1) INSERT INTO _CharSkill VALUES (@CharID,1158,1) INSERT INTO _CharSkill VALUES (@CharID,1163,1) INSERT INTO _CharSkill VALUES (@CharID,1168,1) INSERT INTO _CharSkill VALUES (@CharID,1173,1) INSERT INTO _CharSkill VALUES (@CharID,1178,1) INSERT INTO _CharSkill VALUES (@CharID,1189,1) INSERT INTO _CharSkill VALUES (@CharID,1200,1) INSERT INTO _CharSkill VALUES (@CharID,1217,1) INSERT INTO _CharSkill VALUES (@CharID,1234,1) INSERT INTO _CharSkill VALUES (@CharID,1244,1) INSERT INTO _CharSkill VALUES (@CharID,1253,1) INSERT INTO _CharSkill VALUES (@CharID,1261,1) INSERT INTO _CharSkill VALUES (@CharID,1269,1) INSERT INTO _CharSkill VALUES (@CharID,1271,1) INSERT INTO _CharSkill VALUES (@CharID,1273,1) INSERT INTO _CharSkill VALUES (@CharID,1275,1) INSERT INTO _CharSkill VALUES (@CharID,1286,1) INSERT INTO _CharSkill VALUES (@CharID,1297,1) INSERT INTO _CharSkill VALUES (@CharID,1308,1) INSERT INTO _CharSkill VALUES (@CharID,1316,1) INSERT INTO _CharSkill VALUES (@CharID,1324,1) INSERT INTO _CharSkill VALUES (@CharID,1332,1) INSERT INTO _CharSkill VALUES (@CharID,1337,1) INSERT INTO _CharSkill VALUES (@CharID,1342,1) INSERT INTO _CharSkill VALUES (@CharID,1350,1) INSERT INTO _CharSkill VALUES (@CharID,1358,1) INSERT INTO _CharSkill VALUES (@CharID,1368,1) INSERT INTO _CharSkill VALUES (@CharID,1377,1) INSERT INTO _CharSkill VALUES (@CharID,1385,1) INSERT INTO _CharSkill VALUES (@CharID,1393,1) INSERT INTO _CharSkill VALUES (@CharID,1398,1) INSERT INTO _CharSkill VALUES (@CharID,1403,1) INSERT INTO _CharSkill VALUES (@CharID,1408,1) INSERT INTO _CharSkill VALUES (@CharID,1410,1) INSERT INTO _CharSkill VALUES (@CharID,1412,1) INSERT INTO _CharSkill VALUES (@CharID,1414,1) INSERT INTO _CharSkill VALUES (@CharID,1422,1) INSERT INTO _CharSkill VALUES (@CharID,1430,1) INSERT INTO _CharSkill VALUES (@CharID,1438,1) INSERT INTO _CharSkill VALUES (@CharID,1443,1) INSERT INTO _CharSkill VALUES (@CharID,1448,1) INSERT INTO _CharSkill VALUES (@CharID,1465,1) INSERT INTO _CharSkill VALUES (@CharID,1482,1) INSERT INTO _CharSkill VALUES (@CharID,1499,1) INSERT INTO _CharSkill VALUES (@CharID,1509,1) INSERT INTO _CharSkill VALUES (@CharID,1518,1) INSERT INTO _CharSkill VALUES (@CharID,1526,1) INSERT INTO _CharSkill VALUES (@CharID,1534,1) INSERT INTO _CharSkill VALUES (@CharID,1539,1) INSERT INTO _CharSkill VALUES (@CharID,1544,1) INSERT INTO _CharSkill VALUES (@CharID,1549,1) INSERT INTO _CharSkill VALUES (@CharID,1557,1) INSERT INTO _CharSkill VALUES (@CharID,1565,1) INSERT INTO _CharSkill VALUES (@CharID,1573,1) INSERT INTO _CharSkill VALUES (@CharID,1578,1) INSERT INTO _CharSkill VALUES (@CharID,1583,1) INSERT INTO _CharSkill VALUES (@CharID,1588,1) INSERT INTO _CharSkill VALUES (@CharID,1593,1) INSERT INTO _CharSkill VALUES (@CharID,1598,1) INSERT INTO _CharSkill VALUES (@CharID,1609,1) INSERT INTO _CharSkill VALUES (@CharID,1617,1) INSERT INTO _CharSkill VALUES (@CharID,1628,1) INSERT INTO _CharSkill VALUES (@CharID,3149,1) INSERT INTO _CharSkill VALUES (@CharID,3167,1) INSERT INTO _CharSkill VALUES (@CharID,3176,1) INSERT INTO _CharSkill VALUES (@CharID,3224,1) INSERT INTO _CharSkill VALUES (@CharID,3340,1) INSERT INTO _CharSkill VALUES (@CharID,3349,1) INSERT INTO _CharSkill VALUES (@CharID,3364,1) INSERT INTO _CharSkill VALUES (@CharID,3379,1) INSERT INTO _CharSkill VALUES (@CharID,3391,1) INSERT INTO _CharSkill VALUES (@CharID,3406,1) INSERT INTO _CharSkill VALUES (@CharID,3409,1) INSERT INTO _CharSkill VALUES (@CharID,3415,1) INSERT INTO _CharSkill VALUES (@CharID,3430,1) INSERT INTO _CharSkill VALUES (@CharID,3431,1) INSERT INTO _CharSkill VALUES (@CharID,3446,1) INSERT INTO _CharSkill VALUES (@CharID,3461,1) INSERT INTO _CharSkill VALUES (@CharID,3467,1) INSERT INTO _CharSkill VALUES (@CharID,3473,1) INSERT INTO _CharSkill VALUES (@CharID,7139,1) INSERT INTO _CharSkill VALUES (@CharID,7159,1) INSERT INTO _CharSkill VALUES (@CharID,7203,1) INSERT INTO _CharSkill VALUES (@CharID,7322,1) INSERT INTO _CharSkill VALUES (@CharID,7385,1) INSERT INTO _CharSkill VALUES (@CharID,7390,1) INSERT INTO _CharSkill VALUES (@CharID,7392,1) INSERT INTO _CharSkill VALUES (@CharID,7404,1) INSERT INTO _CharSkill VALUES (@CharID,7418,1) INSERT INTO _CharSkill VALUES (@CharID,7474,1) INSERT INTO _CharSkill VALUES (@CharID,7484,1) INSERT INTO _CharSkill VALUES (@CharID,7513,1) INSERT INTO _CharSkill VALUES (@CharID,7520,1) INSERT INTO _CharSkill VALUES (@CharID,7536,1) INSERT INTO _CharSkill VALUES (@CharID,7554,1) INSERT INTO _CharSkill VALUES (@CharID,7577,1) INSERT INTO _CharSkill VALUES (@CharID,7582,1) INSERT INTO _CharSkill VALUES (@CharID,7584,1) INSERT INTO _CharSkill VALUES (@CharID,7596,1) INSERT INTO _CharSkill VALUES (@CharID,7612,1) INSERT INTO _CharSkill VALUES (@CharID,7637,1) INSERT INTO _CharSkill VALUES (@CharID,7651,1) INSERT INTO _CharSkill VALUES (@CharID,7672,1) INSERT INTO _CharSkill VALUES (@CharID,7675,1) INSERT INTO _CharSkill VALUES (@CharID,7688,1) INSERT INTO _CharSkill VALUES (@CharID,7798,1) INSERT INTO _CharSkill VALUES (@CharID,7805,1) INSERT INTO _CharSkill VALUES (@CharID,7829,1) INSERT INTO _CharSkill VALUES (@CharID,7838,1) INSERT INTO _CharSkill VALUES (@CharID,7839,1) INSERT INTO _CharSkill VALUES (@CharID,7853,1) INSERT INTO _CharSkill VALUES (@CharID,7862,1) INSERT INTO _CharSkill VALUES (@CharID,7877,1) INSERT INTO _CharSkill VALUES (@CharID,7881,1) INSERT INTO _CharSkill VALUES (@CharID,7894,1) INSERT INTO _CharSkill VALUES (@CharID,7899,1) INSERT INTO _CharSkill VALUES (@CharID,7907,1) INSERT INTO _CharSkill VALUES (@CharID,7919,1) INSERT INTO _CharSkill VALUES (@CharID,7931,1) INSERT INTO _CharSkill VALUES (@CharID,7938,1) INSERT INTO _CharSkill VALUES (@CharID,7947,1) INSERT INTO _CharSkill VALUES (@CharID,7953,1) INSERT INTO _CharSkill VALUES (@CharID,7959,1) INSERT INTO _CharSkill VALUES (@CharID,7962,1) INSERT INTO _CharSkill VALUES (@CharID,7972,1) INSERT INTO _CharSkill VALUES (@CharID,7980,1) INSERT INTO _CharSkill VALUES (@CharID,7995,1) INSERT INTO _CharSkill VALUES (@CharID,7997,1) INSERT INTO _CharSkill VALUES (@CharID,8010,1) INSERT INTO _CharSkill VALUES (@CharID,8024,1) INSERT INTO _CharSkill VALUES (@CharID,8050,1) INSERT INTO _CharSkill VALUES (@CharID,8084,1) INSERT INTO _CharSkill VALUES (@CharID,8097,1) INSERT INTO _CharSkill VALUES (@CharID,8103,1) INSERT INTO _CharSkill VALUES (@CharID,8109,1) INSERT INTO _CharSkill VALUES (@CharID,8115,1) INSERT INTO _CharSkill VALUES (@CharID,8119,1) INSERT INTO _CharSkill VALUES (@CharID,8129,1) INSERT INTO _CharSkill VALUES (@CharID,8133,1) INSERT INTO _CharSkill VALUES (@CharID,8142,1) INSERT INTO _CharSkill VALUES (@CharID,8150,1) INSERT INTO _CharSkill VALUES (@CharID,8164,1) INSERT INTO _CharSkill VALUES (@CharID,8171,1) INSERT INTO _CharSkill VALUES (@CharID,8183,1) INSERT INTO _CharSkill VALUES (@CharID,8195,1) INSERT INTO _CharSkill VALUES (@CharID,8204,1) INSERT INTO _CharSkill VALUES (@CharID,8214,1) INSERT INTO _CharSkill VALUES (@CharID,8220,1) INSERT INTO _CharSkill VALUES (@CharID,8221,1) INSERT INTO _CharSkill VALUES (@CharID,8238,1) INSERT INTO _CharSkill VALUES (@CharID,8239,1) INSERT INTO _CharSkill VALUES (@CharID,8250,1) INSERT INTO _CharSkill VALUES (@CharID,8253,1) INSERT INTO _CharSkill VALUES (@CharID,8276,1) INSERT INTO _CharSkill VALUES (@CharID,8291,1) INSERT INTO _CharSkill VALUES (@CharID,8304,1) INSERT INTO _CharSkill VALUES (@CharID,8316,1) INSERT INTO _CharSkill VALUES (@CharID,8320,1) INSERT INTO _CharSkill VALUES (@CharID,8338,1) INSERT INTO _CharSkill VALUES (@CharID,8347,1) INSERT INTO _CharSkill VALUES (@CharID,8348,1) INSERT INTO _CharSkill VALUES (@CharID,8361,1) INSERT INTO _CharSkill VALUES (@CharID,8370,1) INSERT INTO _CharSkill VALUES (@CharID,8379,1) INSERT INTO _CharSkill VALUES (@CharID,8383,1) INSERT INTO _CharSkill VALUES (@CharID,8390,1) INSERT INTO _CharSkill VALUES (@CharID,8399,1) INSERT INTO _CharSkill VALUES (@CharID,8405,1) INSERT INTO _CharSkill VALUES (@CharID,8410,1) INSERT INTO _CharSkill VALUES (@CharID,8414,1) INSERT INTO _CharSkill VALUES (@CharID,8416,1) INSERT INTO _CharSkill VALUES (@CharID,20494,1) INSERT INTO _CharSkill VALUES (@CharID,20497,1) INSERT INTO _CharSkill VALUES (@CharID,20500,1) INSERT INTO _CharSkill VALUES (@CharID,21215,1) INSERT INTO _CharSkill VALUES (@CharID,21217,1) INSERT INTO _CharSkill VALUES (@CharID,30578,1) INSERT INTO _CharSkill VALUES (@CharID,30584,1) INSERT INTO _CharSkill VALUES (@CharID,30590,1) INSERT INTO _CharSkill VALUES (@CharID,30596,1) INSERT INTO _CharSkill VALUES (@CharID,30600,1) هتغير اسم Mrs_Mero باسم الاكونت بتاع الجي ام طبعا ----------------------------------------------------------------------------------------- الـ Uniques عندك مواعيدها مش متظبطه و مخنوق مش عارف تظبطها - تعالا لحمو يا حبيبي انا مظبطهم ينزله كل نص ساعه بعد ما يموتوا .. هتاخد الكويري دي و تحطها في VT_SHARD كود PHP: Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN')) Uruchi Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_OA_URUCHI')) Isyutaru Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_KK_ISYUTARU')) Lord Yarkan: Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TK_BONELORD')) Demon Shaitan Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET')) ------------------------------------------------------------------------------------------------------- عندك حته في الماب بتطلع DC و Crach كل شويه و الاكونتات بايظه مش عارف تعمل ايه !! تاخد الكويري ده هيغير مكان الناس كلها و يخليهم عند ال Cerberus في حته امان كود PHP: UPDATE _Char SET LatestRegion = '25416', PosX = '779.661', PosY = '3.081456', PosZ = '1575.07068', AppointedTeleport = '27754', WorldID = '1' ------------------------------------------------------------------------------------------------------- شيل وقت الجيلد للناس اللي عندك اللي واكلين دماغك >الناس اللي طلعت من جيلد و عايزه تخش واحد تاني < كود PHP: USE [SRO_VT_SHARD] GO /******Mrs_Mero ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[_AddTimedJob] @CharID int, @Category tinyint, @JobID int, @TimeToKeep int, @Data1 int, @Data2 int, --##begin due to develop composite item @Data3 int, @Data4 int, @Data5 int, @Data6 int, @Data7 int, @Data8 int, @Serial64 bigint, @JID int --##end due to develop composite item as if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) return -1 if (@TimeToKeep <= 0) return -2 declare @NewJobID int set @NewJobID = 0 --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader --##If you want to only have one not both, then just modify the line below! if (@JobID = 1 or @JobID = 2) BEGIN insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID) values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) END ELSE BEGIN --##begin due to develop composite item insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID) values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) END --##end due to develop composite item set @NewJobID = @@identity if (@@error <> 0 or @@rowcount = 0) return -3 return @NewJobID ------------------------------------------------------------------------------------------------------ عايز تعمل الــ Grap pet 5 صفح سهله برضه كود PHP: USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[_AddNewCOS] @OwnerCharID int, @RefObjID int, @Level int, @HP int, @MP int, @HGP int, @KeeperNPC int, @State int, @InventorySize int, @itemID int, @PickItemConfig tinyint, @RentEndTime smalldatetime as begin tran declare @COS_ID int --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- pet_skill_item (أض¼±ب£) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ declare @MaxInventorySize tinyint select @MaxInventorySize = InventorySize from _RefObjCommon, _RefObjChar where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID if( @@rowcount = 0 or @MaxInventorySize < @InventorySize ) begin rollback tran return -5 end insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ set @COS_ID = @@identity if (@COS_ID = 0 OR @@error <> 0) begin rollback tran return -1 end --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- pet_skill_item (أض¼±ب£) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ if (@MaxInventorySize > 0) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ begin declare @Slot int set @Slot = 0 --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- pet_skill_item (أض¼±ب£) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ while (@Slot < @MaxInventorySize) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ begin insert into _InvCOS values(@COS_ID, @Slot, 0) if (@@error <> 0) begin -- ہخ؛¥إن¸® »¼؛ ½ائذ! rollback tran return -2 end set @Slot = @Slot + 1 end end /* --´ُ ہج»َ ہج ؤأ·³؟،´آ µ¥ہجإح¸¦ ³ضءِ ¾ت´آ´ظ! UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID IF (@@ERROR <> 0 OR @@ROWCOUNT = 0) BEGIN ROLLBACK TRANSACTION RETURN -3 END */ if( @itemID <> 0 ) begin update _Items set Data = @COS_ID where ID64 = @itemID if( @@error <> 0 or @@rowcount = 0 ) begin rollback transaction return -4 end --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH declare @Serial64 bigint select @Serial64 = Serial64 from _Items where Data = @COS_ID exec _AddTimedJobForPet @COS_ID,5,22926,1331260204,1111708465,1,112,0,0,0, 0,0,@Serial64 --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH end commit tran return @COS_ID ------------------------------------------------------------------------------------------------------- عايز تحط مكان لـ Unique في المكان اللي انت عايزه او حطيط Unique جديد و عايز تحطه في المكان اللي انت عايزه --- كود PHP: USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */ 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!' بص يا برنس هتروح باي اكونت في المكان اللي عايز تحط في الـ Unique و تظبط الكويري و تدوس Excute ----------------------------------------------------------------------------------------------- الــ Honor Ranking مش شغال ؟؟ حماده كود PHP: USE SRO_VT_SHARD TRUNCATE TABLE _TrainingCampHonorRank INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50) exec _TRAINING_CAMP_UPDATEHONORRANK --------------------------------------------------------------------------------------------------- عايز تعمل New custom teleport ؟؟ كود PHP: USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */ 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+' '+@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!' محدش يقولي شرح في دي هعمله انا بس مش دلوقتي .. رخامه بقه --------------------------------------------------------------------------------------------------- عايز تحط Drop جديد في Unique مثلا يعني تخلي ال Medusa توقع Global Chat كده مثلا .. الكويري دي كود PHP: USE SRO_VT_SHARD GO DECLARE @MonsterID int DECLARE @ItemID int DECLARE @DropRatio real SET @MonsterID = 24082 // Enter here monster id in RefObjCommon table SET @DropRatio = 0.00004 // Drop rate (%100 = 1 , %50 = 0.5 , %0 =0) SET @ItemID = 3851 // Enter here item id in RefObjCommon table 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') ------------------------------------------------------------------------------------------------------ عايز تشيل الــ Alchemy materials اللي ملهاش لزمه دي كود PHP: USE [SRO_VT_SHARD] GO UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 6679 AND 5414 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 6082 AND 6371 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 10501 AND 10527 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 11499 AND 11668 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 12554 AND 12569 ----------------------------------------------------------------------------------------------------- عايز تلقل اكونت بسرعه بدل ما تفتح ال SMC و كده . معايا برضه كود PHP: USE [SRO_VT_SHARD] Declare @CharName VarChar(max) Declare @Level BigInt SET @CharName= '_2ReaiS_' --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 ----------------------------------------------------------------------------------------------------- عايز تشيل ال PK من علي اكونت واحد كود PHP: USE [SRO_VT_SHARD] DECLARE @CharName Varchar(max) SET @CharName = '_2ReaiS_' UPDATE _Char SET RemainHwanCount = 5, DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 WHERE CharName16 = @CharName --------------------------------------------------------------------------------------------- تشيل ال PK من علي الناس كلها !! كود PHP: USE [SRO_VT_SHARD] UPDATE _Char SET DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 ----------------------------------------------------------------------------------------------------- Clean SRO_VT_ACCOUNT كود PHP: USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[__SiegeFortressStatus__] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[_ShardCurrentUser] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[SK_DownLevelLog] 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_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_partnerInfo] TRUNCATE TABLE [dbo].[tb_paygate_trans] TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[Test_HN] UPDATE [dbo].[_ShardService] SET ShardID = '64' ------------------------------------------------------------------------------------------------------ Clean SRO_VT_SHARD كود PHP: USE [SRO_VT_SHARD] GO TRUNCATE TABLE [dbo].[_Chest] TRUNCATE TABLE [dbo].[_ChestInfo] TRUNCATE TABLE [dbo].[_User] TRUNCATE TABLE [dbo].[_OpenMarket] DELETE FROM [dbo].[_AccountJID] TRUNCATE TABLE [dbo].[_GuildWar] TRUNCATE TABLE [dbo].[_GuildMember] TRUNCATE TABLE [dbo].[_GuildChest] TRUNCATE TABLE [dbo].[_SiegeFortressStruct] TRUNCATE TABLE [dbo].[_SiegeFortressObject] TRUNCATE TABLE [dbo].[_SiegeFortressItemForge] DELETE FROM [dbo].[_SiegeFortress] INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6) UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0' DELETE FROM [dbo].[_Guild] WHERE ID > 0 DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0 TRUNCATE TABLE [dbo].[_InventoryForAvatar] TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint] TRUNCATE TABLE [dbo].[_BlockedWhisperers] TRUNCATE TABLE [dbo].[_TrainingCampMember] TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade] DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_TimedJob] TRUNCATE TABLE [dbo].[_StaticAvatar] TRUNCATE TABLE [dbo].[_Inventory] TRUNCATE TABLE [dbo].[_Memo] TRUNCATE TABLE [dbo].[_FleaMarketNetwork] TRUNCATE TABLE [dbo].[_Friend] TRUNCATE TABLE [dbo].[_CharSkillMastery] TRUNCATE TABLE [dbo].[_CharSkill] TRUNCATE TABLE [dbo].[_InvCOS] DELETE FROM [dbo].[_CharCOS] WHERE ID > 0 DELETE FROM [dbo].[_Char] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_CharCollectionBook] TRUNCATE TABLE [dbo].[_CharInstanceWorldData] TRUNCATE TABLE [dbo].[_CharNameList] TRUNCATE TABLE [dbo].[_CharNickNameList] TRUNCATE TABLE [dbo].[_CharQuest] TRUNCATE TABLE [dbo].[_ClientConfig] TRUNCATE TABLE [dbo].[_DeletedChar] TRUNCATE TABLE [dbo].[_GPHistory] TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage] TRUNCATE TABLE [dbo].[_ItemPool] DELETE FROM [dbo].[_Items] WHERE ID64 > 0 TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET] TRUNCATE TABLE [dbo].[_TimedJobForPet] TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus] TRUNCATE TABLE [dbo].[_TrainingCampHonorRank] INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50) EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK] DELETE FROM [dbo].[_TrainingCamp] TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution] -------------------------------------------------------------------------------------------------------- Clean SRO_VT_SHARDLOG كود PHP: USE [SRO_VT_LOG] 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] -------------------------------------------------------------------------------------------------------- كويرى لفتح السيف زون كلمه Regon يعنى المنطقه اللى عايز تقفلها جانجان ولا هوتان ولا اى بتنجان ^^ Update _RefRegion Set IsBattleField = 0 Where ContinentName = Ur Region Name /* By King$ */ -------------------------------------------------- كويرى لقفل السيف زون كلمه Regon يعنى المنطقه اللى عايز تقفلها جانجان ولا هوتان ولا اى بتنجان ^^ Update _RefRegion Set IsBattleField = 1 Where ContinentName = Ur Region Name /* By King$ */ ------------------------------------------------------------------------------------------------------ كويرى خذف اى ايتم فى اللعبه USE [SRO_VT_SHARD] Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM_COS_P_RABBIT_SCROLL' ] ---------------------------------------------------------------------------------------------------------- To get mob ID us this Query : Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC' Change MOB_RM_ROC With your Monster or Unique Code ------------------------------------------------------------------ To get ITEM ID us this Query : Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE' Change ITEM_CH_TBLADE_11_SET_A_RARE to Any item you want ------------------------------------------------------------------------------- Fast Query to Add Drops in Mob , Unique bla bla bla ^^ USE SRO_VT_SHARD -----> ( MaDenGo ) <----- GO DECLARE @MonsterID int DECLARE @ItemID int DECLARE @DropRatio real SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50% SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop 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') .gif "111 (3)") |
||||||||||||
|
|
|
24-02-2013, 06:21 PM
|
#5 | ||||||||||||
|
♥♥Some helpful queries from my old host♥ ♥
اولا نبتدي بالخفيف ------------------------------------------------------------------------------------------------------------------ لو عندك ايتم في بج في الجيم و عايز تمسحه من عند الناس هتعمل الكويري دي كود PHP: USE [SRO_VT_SHARD] exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING' طبعا هتغير كود الجلوبال بالكود اللي انت عايزه ------------------------------------------------------------------------------------- ضريت بريميم غلط و عايز تشيله هتعمل الكويري دي كود PHP: DELETE FROM [SRO_VT_SHARD].[dbo].[_TimedJob] WHERE CharID = 'CHAR ID' هنغير ال CHAR ID بال ID بتاع الاكونت من SRO_VT_SHARD > Char ------------------------------------------------------------------------------------- بوظط حاجه في الجيم و العيال مطلعه عينك و عايز تحطلهم سيلك عشان يتخرصوا :D الكويري ده هيحطلك سيلك للناس كلها اللي في الجيم كود PHP: /***********Wrote by Mrs_Mero***********/ USE SRO_VT_ACCOUNT; GO INSERT INTO SK_SILK (JID, silk_own, silk_gift, silk_point) SELECT JID, '0', '0', '0' FROM TB_User WHERE not exists (select * from SK_Silk WHERE SK_SILK.JID = TB_User.JID); UPDATE SK_Silk SET silk_own=silk_own+10 /***********Wrote by Mrs_Mero***********/ الاصفار اللي فوق دي اللي هي Silk , Silk point , Silk gift حط اللي انت عايزه ------------------------------------------------------------------------------------- عايز تعمل Max Account for every IP هتحط ده في ال Server.cfg كود PHP: GlobalManager { Certification "Your IP!", 32000 LoginFailureTolerance 3 IBUVFailureTolerance 3 LoginFailureBlockTimeMin 10 IBUVFailureBlockTimeMin 10 AutomatedPunisher "AutomatedPunisher" LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times" LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times" IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times" IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times" NetCafeIPRefreshTime 2 MaxUserForNonePCBangIP 2 Change The NetCafeIPRefreshTime & MaxUserForNonePCBangIP "2" To IP Per Player! Tested on vSRO working 100% مجربه علي vSRO ------------------------------------------------------------------------------------- SRO_VT_SHARD استخدمها على الشارد يااحمد عايز تفتح كل السيكلات في اكونت الجي ام من غير ما تبوظ الماوس بتاعك كود PHP: DECLARE @CharName varchar(255) DECLARE @CharID INT SET @CharName='Mrs_Mero' SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID INSERT INTO _CharSkill VALUES (@CharID,1,1) INSERT INTO _CharSkill VALUES (@CharID,2,1) INSERT INTO _CharSkill VALUES (@CharID,40,1) INSERT INTO _CharSkill VALUES (@CharID,70,1) INSERT INTO _CharSkill VALUES (@CharID,298,1) INSERT INTO _CharSkill VALUES (@CharID,306,1) INSERT INTO _CharSkill VALUES (@CharID,314,1) INSERT INTO _CharSkill VALUES (@CharID,322,1) INSERT INTO _CharSkill VALUES (@CharID,346,1) INSERT INTO _CharSkill VALUES (@CharID,378,1) INSERT INTO _CharSkill VALUES (@CharID,418,1) INSERT INTO _CharSkill VALUES (@CharID,463,1) INSERT INTO _CharSkill VALUES (@CharID,558,1) INSERT INTO _CharSkill VALUES (@CharID,569,1) INSERT INTO _CharSkill VALUES (@CharID,580,1) INSERT INTO _CharSkill VALUES (@CharID,588,1) INSERT INTO _CharSkill VALUES (@CharID,596,1) INSERT INTO _CharSkill VALUES (@CharID,604,1) INSERT INTO _CharSkill VALUES (@CharID,647,1) INSERT INTO _CharSkill VALUES (@CharID,655,1) INSERT INTO _CharSkill VALUES (@CharID,672,1) INSERT INTO _CharSkill VALUES (@CharID,689,1) INSERT INTO _CharSkill VALUES (@CharID,699,1) INSERT INTO _CharSkill VALUES (@CharID,708,1) INSERT INTO _CharSkill VALUES (@CharID,716,1) INSERT INTO _CharSkill VALUES (@CharID,724,1) INSERT INTO _CharSkill VALUES (@CharID,735,1) INSERT INTO _CharSkill VALUES (@CharID,746,1) INSERT INTO _CharSkill VALUES (@CharID,757,1) INSERT INTO _CharSkill VALUES (@CharID,765,1) INSERT INTO _CharSkill VALUES (@CharID,773,1) INSERT INTO _CharSkill VALUES (@CharID,781,1) INSERT INTO _CharSkill VALUES (@CharID,789,1) INSERT INTO _CharSkill VALUES (@CharID,797,1) INSERT INTO _CharSkill VALUES (@CharID,805,1) INSERT INTO _CharSkill VALUES (@CharID,813,1) INSERT INTO _CharSkill VALUES (@CharID,821,1) INSERT INTO _CharSkill VALUES (@CharID,829,1) INSERT INTO _CharSkill VALUES (@CharID,853,1) INSERT INTO _CharSkill VALUES (@CharID,885,1) INSERT INTO _CharSkill VALUES (@CharID,925,1) INSERT INTO _CharSkill VALUES (@CharID,933,1) INSERT INTO _CharSkill VALUES (@CharID,943,1) INSERT INTO _CharSkill VALUES (@CharID,952,1) INSERT INTO _CharSkill VALUES (@CharID,960,1) INSERT INTO _CharSkill VALUES (@CharID,968,1) INSERT INTO _CharSkill VALUES (@CharID,976,1) INSERT INTO _CharSkill VALUES (@CharID,984,1) INSERT INTO _CharSkill VALUES (@CharID,992,1) INSERT INTO _CharSkill VALUES (@CharID,1003,1) INSERT INTO _CharSkill VALUES (@CharID,1014,1) INSERT INTO _CharSkill VALUES (@CharID,1025,1) INSERT INTO _CharSkill VALUES (@CharID,1033,1) INSERT INTO _CharSkill VALUES (@CharID,1041,1) INSERT INTO _CharSkill VALUES (@CharID,1049,1) INSERT INTO _CharSkill VALUES (@CharID,1053,1) INSERT INTO _CharSkill VALUES (@CharID,1057,1) INSERT INTO _CharSkill VALUES (@CharID,1065,1) INSERT INTO _CharSkill VALUES (@CharID,1073,1) INSERT INTO _CharSkill VALUES (@CharID,1081,1) INSERT INTO _CharSkill VALUES (@CharID,1089,1) INSERT INTO _CharSkill VALUES (@CharID,1099,1) INSERT INTO _CharSkill VALUES (@CharID,1108,1) INSERT INTO _CharSkill VALUES (@CharID,1116,1) INSERT INTO _CharSkill VALUES (@CharID,1124,1) INSERT INTO _CharSkill VALUES (@CharID,1132,1) INSERT INTO _CharSkill VALUES (@CharID,1140,1) INSERT INTO _CharSkill VALUES (@CharID,1148,1) INSERT INTO _CharSkill VALUES (@CharID,1153,1) INSERT INTO _CharSkill VALUES (@CharID,1158,1) INSERT INTO _CharSkill VALUES (@CharID,1163,1) INSERT INTO _CharSkill VALUES (@CharID,1168,1) INSERT INTO _CharSkill VALUES (@CharID,1173,1) INSERT INTO _CharSkill VALUES (@CharID,1178,1) INSERT INTO _CharSkill VALUES (@CharID,1189,1) INSERT INTO _CharSkill VALUES (@CharID,1200,1) INSERT INTO _CharSkill VALUES (@CharID,1217,1) INSERT INTO _CharSkill VALUES (@CharID,1234,1) INSERT INTO _CharSkill VALUES (@CharID,1244,1) INSERT INTO _CharSkill VALUES (@CharID,1253,1) INSERT INTO _CharSkill VALUES (@CharID,1261,1) INSERT INTO _CharSkill VALUES (@CharID,1269,1) INSERT INTO _CharSkill VALUES (@CharID,1271,1) INSERT INTO _CharSkill VALUES (@CharID,1273,1) INSERT INTO _CharSkill VALUES (@CharID,1275,1) INSERT INTO _CharSkill VALUES (@CharID,1286,1) INSERT INTO _CharSkill VALUES (@CharID,1297,1) INSERT INTO _CharSkill VALUES (@CharID,1308,1) INSERT INTO _CharSkill VALUES (@CharID,1316,1) INSERT INTO _CharSkill VALUES (@CharID,1324,1) INSERT INTO _CharSkill VALUES (@CharID,1332,1) INSERT INTO _CharSkill VALUES (@CharID,1337,1) INSERT INTO _CharSkill VALUES (@CharID,1342,1) INSERT INTO _CharSkill VALUES (@CharID,1350,1) INSERT INTO _CharSkill VALUES (@CharID,1358,1) INSERT INTO _CharSkill VALUES (@CharID,1368,1) INSERT INTO _CharSkill VALUES (@CharID,1377,1) INSERT INTO _CharSkill VALUES (@CharID,1385,1) INSERT INTO _CharSkill VALUES (@CharID,1393,1) INSERT INTO _CharSkill VALUES (@CharID,1398,1) INSERT INTO _CharSkill VALUES (@CharID,1403,1) INSERT INTO _CharSkill VALUES (@CharID,1408,1) INSERT INTO _CharSkill VALUES (@CharID,1410,1) INSERT INTO _CharSkill VALUES (@CharID,1412,1) INSERT INTO _CharSkill VALUES (@CharID,1414,1) INSERT INTO _CharSkill VALUES (@CharID,1422,1) INSERT INTO _CharSkill VALUES (@CharID,1430,1) INSERT INTO _CharSkill VALUES (@CharID,1438,1) INSERT INTO _CharSkill VALUES (@CharID,1443,1) INSERT INTO _CharSkill VALUES (@CharID,1448,1) INSERT INTO _CharSkill VALUES (@CharID,1465,1) INSERT INTO _CharSkill VALUES (@CharID,1482,1) INSERT INTO _CharSkill VALUES (@CharID,1499,1) INSERT INTO _CharSkill VALUES (@CharID,1509,1) INSERT INTO _CharSkill VALUES (@CharID,1518,1) INSERT INTO _CharSkill VALUES (@CharID,1526,1) INSERT INTO _CharSkill VALUES (@CharID,1534,1) INSERT INTO _CharSkill VALUES (@CharID,1539,1) INSERT INTO _CharSkill VALUES (@CharID,1544,1) INSERT INTO _CharSkill VALUES (@CharID,1549,1) INSERT INTO _CharSkill VALUES (@CharID,1557,1) INSERT INTO _CharSkill VALUES (@CharID,1565,1) INSERT INTO _CharSkill VALUES (@CharID,1573,1) INSERT INTO _CharSkill VALUES (@CharID,1578,1) INSERT INTO _CharSkill VALUES (@CharID,1583,1) INSERT INTO _CharSkill VALUES (@CharID,1588,1) INSERT INTO _CharSkill VALUES (@CharID,1593,1) INSERT INTO _CharSkill VALUES (@CharID,1598,1) INSERT INTO _CharSkill VALUES (@CharID,1609,1) INSERT INTO _CharSkill VALUES (@CharID,1617,1) INSERT INTO _CharSkill VALUES (@CharID,1628,1) INSERT INTO _CharSkill VALUES (@CharID,3149,1) INSERT INTO _CharSkill VALUES (@CharID,3167,1) INSERT INTO _CharSkill VALUES (@CharID,3176,1) INSERT INTO _CharSkill VALUES (@CharID,3224,1) INSERT INTO _CharSkill VALUES (@CharID,3340,1) INSERT INTO _CharSkill VALUES (@CharID,3349,1) INSERT INTO _CharSkill VALUES (@CharID,3364,1) INSERT INTO _CharSkill VALUES (@CharID,3379,1) INSERT INTO _CharSkill VALUES (@CharID,3391,1) INSERT INTO _CharSkill VALUES (@CharID,3406,1) INSERT INTO _CharSkill VALUES (@CharID,3409,1) INSERT INTO _CharSkill VALUES (@CharID,3415,1) INSERT INTO _CharSkill VALUES (@CharID,3430,1) INSERT INTO _CharSkill VALUES (@CharID,3431,1) INSERT INTO _CharSkill VALUES (@CharID,3446,1) INSERT INTO _CharSkill VALUES (@CharID,3461,1) INSERT INTO _CharSkill VALUES (@CharID,3467,1) INSERT INTO _CharSkill VALUES (@CharID,3473,1) INSERT INTO _CharSkill VALUES (@CharID,7139,1) INSERT INTO _CharSkill VALUES (@CharID,7159,1) INSERT INTO _CharSkill VALUES (@CharID,7203,1) INSERT INTO _CharSkill VALUES (@CharID,7322,1) INSERT INTO _CharSkill VALUES (@CharID,7385,1) INSERT INTO _CharSkill VALUES (@CharID,7390,1) INSERT INTO _CharSkill VALUES (@CharID,7392,1) INSERT INTO _CharSkill VALUES (@CharID,7404,1) INSERT INTO _CharSkill VALUES (@CharID,7418,1) INSERT INTO _CharSkill VALUES (@CharID,7474,1) INSERT INTO _CharSkill VALUES (@CharID,7484,1) INSERT INTO _CharSkill VALUES (@CharID,7513,1) INSERT INTO _CharSkill VALUES (@CharID,7520,1) INSERT INTO _CharSkill VALUES (@CharID,7536,1) INSERT INTO _CharSkill VALUES (@CharID,7554,1) INSERT INTO _CharSkill VALUES (@CharID,7577,1) INSERT INTO _CharSkill VALUES (@CharID,7582,1) INSERT INTO _CharSkill VALUES (@CharID,7584,1) INSERT INTO _CharSkill VALUES (@CharID,7596,1) INSERT INTO _CharSkill VALUES (@CharID,7612,1) INSERT INTO _CharSkill VALUES (@CharID,7637,1) INSERT INTO _CharSkill VALUES (@CharID,7651,1) INSERT INTO _CharSkill VALUES (@CharID,7672,1) INSERT INTO _CharSkill VALUES (@CharID,7675,1) INSERT INTO _CharSkill VALUES (@CharID,7688,1) INSERT INTO _CharSkill VALUES (@CharID,7798,1) INSERT INTO _CharSkill VALUES (@CharID,7805,1) INSERT INTO _CharSkill VALUES (@CharID,7829,1) INSERT INTO _CharSkill VALUES (@CharID,7838,1) INSERT INTO _CharSkill VALUES (@CharID,7839,1) INSERT INTO _CharSkill VALUES (@CharID,7853,1) INSERT INTO _CharSkill VALUES (@CharID,7862,1) INSERT INTO _CharSkill VALUES (@CharID,7877,1) INSERT INTO _CharSkill VALUES (@CharID,7881,1) INSERT INTO _CharSkill VALUES (@CharID,7894,1) INSERT INTO _CharSkill VALUES (@CharID,7899,1) INSERT INTO _CharSkill VALUES (@CharID,7907,1) INSERT INTO _CharSkill VALUES (@CharID,7919,1) INSERT INTO _CharSkill VALUES (@CharID,7931,1) INSERT INTO _CharSkill VALUES (@CharID,7938,1) INSERT INTO _CharSkill VALUES (@CharID,7947,1) INSERT INTO _CharSkill VALUES (@CharID,7953,1) INSERT INTO _CharSkill VALUES (@CharID,7959,1) INSERT INTO _CharSkill VALUES (@CharID,7962,1) INSERT INTO _CharSkill VALUES (@CharID,7972,1) INSERT INTO _CharSkill VALUES (@CharID,7980,1) INSERT INTO _CharSkill VALUES (@CharID,7995,1) INSERT INTO _CharSkill VALUES (@CharID,7997,1) INSERT INTO _CharSkill VALUES (@CharID,8010,1) INSERT INTO _CharSkill VALUES (@CharID,8024,1) INSERT INTO _CharSkill VALUES (@CharID,8050,1) INSERT INTO _CharSkill VALUES (@CharID,8084,1) INSERT INTO _CharSkill VALUES (@CharID,8097,1) INSERT INTO _CharSkill VALUES (@CharID,8103,1) INSERT INTO _CharSkill VALUES (@CharID,8109,1) INSERT INTO _CharSkill VALUES (@CharID,8115,1) INSERT INTO _CharSkill VALUES (@CharID,8119,1) INSERT INTO _CharSkill VALUES (@CharID,8129,1) INSERT INTO _CharSkill VALUES (@CharID,8133,1) INSERT INTO _CharSkill VALUES (@CharID,8142,1) INSERT INTO _CharSkill VALUES (@CharID,8150,1) INSERT INTO _CharSkill VALUES (@CharID,8164,1) INSERT INTO _CharSkill VALUES (@CharID,8171,1) INSERT INTO _CharSkill VALUES (@CharID,8183,1) INSERT INTO _CharSkill VALUES (@CharID,8195,1) INSERT INTO _CharSkill VALUES (@CharID,8204,1) INSERT INTO _CharSkill VALUES (@CharID,8214,1) INSERT INTO _CharSkill VALUES (@CharID,8220,1) INSERT INTO _CharSkill VALUES (@CharID,8221,1) INSERT INTO _CharSkill VALUES (@CharID,8238,1) INSERT INTO _CharSkill VALUES (@CharID,8239,1) INSERT INTO _CharSkill VALUES (@CharID,8250,1) INSERT INTO _CharSkill VALUES (@CharID,8253,1) INSERT INTO _CharSkill VALUES (@CharID,8276,1) INSERT INTO _CharSkill VALUES (@CharID,8291,1) INSERT INTO _CharSkill VALUES (@CharID,8304,1) INSERT INTO _CharSkill VALUES (@CharID,8316,1) INSERT INTO _CharSkill VALUES (@CharID,8320,1) INSERT INTO _CharSkill VALUES (@CharID,8338,1) INSERT INTO _CharSkill VALUES (@CharID,8347,1) INSERT INTO _CharSkill VALUES (@CharID,8348,1) INSERT INTO _CharSkill VALUES (@CharID,8361,1) INSERT INTO _CharSkill VALUES (@CharID,8370,1) INSERT INTO _CharSkill VALUES (@CharID,8379,1) INSERT INTO _CharSkill VALUES (@CharID,8383,1) INSERT INTO _CharSkill VALUES (@CharID,8390,1) INSERT INTO _CharSkill VALUES (@CharID,8399,1) INSERT INTO _CharSkill VALUES (@CharID,8405,1) INSERT INTO _CharSkill VALUES (@CharID,8410,1) INSERT INTO _CharSkill VALUES (@CharID,8414,1) INSERT INTO _CharSkill VALUES (@CharID,8416,1) INSERT INTO _CharSkill VALUES (@CharID,20494,1) INSERT INTO _CharSkill VALUES (@CharID,20497,1) INSERT INTO _CharSkill VALUES (@CharID,20500,1) INSERT INTO _CharSkill VALUES (@CharID,21215,1) INSERT INTO _CharSkill VALUES (@CharID,21217,1) INSERT INTO _CharSkill VALUES (@CharID,30578,1) INSERT INTO _CharSkill VALUES (@CharID,30584,1) INSERT INTO _CharSkill VALUES (@CharID,30590,1) INSERT INTO _CharSkill VALUES (@CharID,30596,1) INSERT INTO _CharSkill VALUES (@CharID,30600,1) هتغير اسم Mrs_Mero باسم الاكونت بتاع الجي ام طبعا ----------------------------------------------------------------------------------------- الـ Uniques عندك مواعيدها مش متظبطه و مخنوق مش عارف تظبطها - تعالا لحمو يا حبيبي انا مظبطهم ينزله كل نص ساعه بعد ما يموتوا .. هتاخد الكويري دي و تحطها في VT_SHARD كود PHP: Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN')) Uruchi Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_OA_URUCHI')) Isyutaru Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_KK_ISYUTARU')) Lord Yarkan: Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TK_BONELORD')) Demon Shaitan Update Tab_RefNest Set dwDelayTimeMin=7000 , dwDelayTimeMax=7000 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET')) ------------------------------------------------------------------------------------------------------- عندك حته في الماب بتطلع DC و Crach كل شويه و الاكونتات بايظه مش عارف تعمل ايه !! تاخد الكويري ده هيغير مكان الناس كلها و يخليهم عند ال Cerberus في حته امان كود PHP: UPDATE _Char SET LatestRegion = '25416', PosX = '779.661', PosY = '3.081456', PosZ = '1575.07068', AppointedTeleport = '27754', WorldID = '1' ------------------------------------------------------------------------------------------------------- شيل وقت الجيلد للناس اللي عندك اللي واكلين دماغك >الناس اللي طلعت من جيلد و عايزه تخش واحد تاني < كود PHP: USE [SRO_VT_SHARD] GO /******Mrs_Mero ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[_AddTimedJob] @CharID int, @Category tinyint, @JobID int, @TimeToKeep int, @Data1 int, @Data2 int, --##begin due to develop composite item @Data3 int, @Data4 int, @Data5 int, @Data6 int, @Data7 int, @Data8 int, @Serial64 bigint, @JID int --##end due to develop composite item as if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) return -1 if (@TimeToKeep <= 0) return -2 declare @NewJobID int set @NewJobID = 0 --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader --##If you want to only have one not both, then just modify the line below! if (@JobID = 1 or @JobID = 2) BEGIN insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID) values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) END ELSE BEGIN --##begin due to develop composite item insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID) values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) END --##end due to develop composite item set @NewJobID = @@identity if (@@error <> 0 or @@rowcount = 0) return -3 return @NewJobID ------------------------------------------------------------------------------------------------------ عايز تعمل الــ Grap pet 5 صفح سهله برضه كود PHP: USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[_AddNewCOS] @OwnerCharID int, @RefObjID int, @Level int, @HP int, @MP int, @HGP int, @KeeperNPC int, @State int, @InventorySize int, @itemID int, @PickItemConfig tinyint, @RentEndTime smalldatetime as begin tran declare @COS_ID int --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- pet_skill_item (ÃÖ¼±È£) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ declare @MaxInventorySize tinyint select @MaxInventorySize = InventorySize from _RefObjCommon, _RefObjChar where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID if( @@rowcount = 0 or @MaxInventorySize < @InventorySize ) begin rollback tran return -5 end insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ set @COS_ID = @@identity if (@COS_ID = 0 OR @@error <> 0) begin rollback tran return -1 end --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- pet_skill_item (ÃÖ¼±È£) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ if (@MaxInventorySize > 0) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ begin declare @Slot int set @Slot = 0 --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- pet_skill_item (ÃÖ¼±È£) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ while (@Slot < @MaxInventorySize) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ begin insert into _InvCOS values(@COS_ID, @Slot, 0) if (@@error <> 0) begin -- Àκ¥Å丮 »ý¼º ½ÇÆÐ! rollback tran return -2 end set @Slot = @Slot + 1 end end /* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù! UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID IF (@@ERROR <> 0 OR @@ROWCOUNT = 0) BEGIN ROLLBACK TRANSACTION RETURN -3 END */ if( @itemID <> 0 ) begin update _Items set Data = @COS_ID where ID64 = @itemID if( @@error <> 0 or @@rowcount = 0 ) begin rollback transaction return -4 end --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH declare @Serial64 bigint select @Serial64 = Serial64 from _Items where Data = @COS_ID exec _AddTimedJobForPet @COS_ID,5,22926,1331260204,1111708465,1,112,0,0,0, 0,0,@Serial64 --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 1 MONTH end commit tran return @COS_ID ------------------------------------------------------------------------------------------------------- عايز تحط مكان لـ Unique في المكان اللي انت عايزه او حطيط Unique جديد و عايز تحطه في المكان اللي انت عايزه --- كود PHP: USE SRO_VT_SHARD /* Add Unique Spot By Arabianfox */ 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!' بص يا برنس هتروح باي اكونت في المكان اللي عايز تحط في الـ Unique و تظبط الكويري و تدوس Excute ----------------------------------------------------------------------------------------------- الــ Honor Ranking مش شغال ؟؟ حماده كود PHP: USE SRO_VT_SHARD TRUNCATE TABLE _TrainingCampHonorRank INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49) INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50) exec _TRAINING_CAMP_UPDATEHONORRANK --------------------------------------------------------------------------------------------------- عايز تعمل New custom teleport ؟؟ كود PHP: USE SRO_VT_SHARD /* Add new Teleport By Arabianfox */ 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+' '+@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!' محدش يقولي شرح في دي هعمله انا بس مش دلوقتي .. رخامه بقه --------------------------------------------------------------------------------------------------- عايز تحط Drop جديد في Unique مثلا يعني تخلي ال Medusa توقع Global Chat كده مثلا .. الكويري دي كود PHP: USE SRO_VT_SHARD GO DECLARE @MonsterID int DECLARE @ItemID int DECLARE @DropRatio real SET @MonsterID = 24082 // Enter here monster id in RefObjCommon table SET @DropRatio = 0.00004 // Drop rate (%100 = 1 , %50 = 0.5 , %0 =0) SET @ItemID = 3851 // Enter here item id in RefObjCommon table 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') ------------------------------------------------------------------------------------------------------ عايز تشيل الــ Alchemy materials اللي ملهاش لزمه دي كود PHP: USE [SRO_VT_SHARD] GO UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 6679 AND 5414 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 6082 AND 6371 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 10501 AND 10527 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 11499 AND 11668 UPDATE dbo._RefDropItemAssign SET Service = 0 WHERE RefItemID BETWEEN 12554 AND 12569 ----------------------------------------------------------------------------------------------------- عايز تلقل اكونت بسرعه بدل ما تفتح ال SMC و كده . معايا برضه كود PHP: USE [SRO_VT_SHARD] Declare @CharName VarChar(max) Declare @Level BigInt SET @CharName= '_2ReaiS_' --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 ----------------------------------------------------------------------------------------------------- عايز تشيل ال PK من علي اكونت واحد كود PHP: USE [SRO_VT_SHARD] DECLARE @CharName Varchar(max) SET @CharName = '_2ReaiS_' UPDATE _Char SET RemainHwanCount = 5, DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 WHERE CharName16 = @CharName --------------------------------------------------------------------------------------------- تشيل ال PK من علي الناس كلها !! كود PHP: USE [SRO_VT_SHARD] UPDATE _Char SET DailyPK= 0, TotalPK= 0, PKPenaltyPoint= 0 ----------------------------------------------------------------------------------------------------- Clean SRO_VT_ACCOUNT كود PHP: USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[__SiegeFortressStatus__] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[_ShardCurrentUser] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[SK_DownLevelLog] 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_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_partnerInfo] TRUNCATE TABLE [dbo].[tb_paygate_trans] TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[Test_HN] UPDATE [dbo].[_ShardService] SET ShardID = '64' ------------------------------------------------------------------------------------------------------ Clean SRO_VT_SHARD كود PHP: USE [SRO_VT_SHARD] GO TRUNCATE TABLE [dbo].[_Chest] TRUNCATE TABLE [dbo].[_ChestInfo] TRUNCATE TABLE [dbo].[_User] TRUNCATE TABLE [dbo].[_OpenMarket] DELETE FROM [dbo].[_AccountJID] TRUNCATE TABLE [dbo].[_GuildWar] TRUNCATE TABLE [dbo].[_GuildMember] TRUNCATE TABLE [dbo].[_GuildChest] TRUNCATE TABLE [dbo].[_SiegeFortressStruct] TRUNCATE TABLE [dbo].[_SiegeFortressObject] TRUNCATE TABLE [dbo].[_SiegeFortressItemForge] DELETE FROM [dbo].[_SiegeFortress] INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6) UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0' DELETE FROM [dbo].[_Guild] WHERE ID > 0 DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0 TRUNCATE TABLE [dbo].[_InventoryForAvatar] TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint] TRUNCATE TABLE [dbo].[_BlockedWhisperers] TRUNCATE TABLE [dbo].[_TrainingCampMember] TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade] DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_TimedJob] TRUNCATE TABLE [dbo].[_StaticAvatar] TRUNCATE TABLE [dbo].[_Inventory] TRUNCATE TABLE [dbo].[_Memo] TRUNCATE TABLE [dbo].[_FleaMarketNetwork] TRUNCATE TABLE [dbo].[_Friend] TRUNCATE TABLE [dbo].[_CharSkillMastery] TRUNCATE TABLE [dbo].[_CharSkill] TRUNCATE TABLE [dbo].[_InvCOS] DELETE FROM [dbo].[_CharCOS] WHERE ID > 0 DELETE FROM [dbo].[_Char] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_CharCollectionBook] TRUNCATE TABLE [dbo].[_CharInstanceWorldData] TRUNCATE TABLE [dbo].[_CharNameList] TRUNCATE TABLE [dbo].[_CharNickNameList] TRUNCATE TABLE [dbo].[_CharQuest] TRUNCATE TABLE [dbo].[_ClientConfig] TRUNCATE TABLE [dbo].[_DeletedChar] TRUNCATE TABLE [dbo].[_GPHistory] TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage] TRUNCATE TABLE [dbo].[_ItemPool] DELETE FROM [dbo].[_Items] WHERE ID64 > 0 TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET] TRUNCATE TABLE [dbo].[_TimedJobForPet] TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus] TRUNCATE TABLE [dbo].[_TrainingCampHonorRank] INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50) EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK] DELETE FROM [dbo].[_TrainingCamp] TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution] -------------------------------------------------------------------------------------------------------- Clean SRO_VT_SHARDLOG كود PHP: USE [SRO_VT_LOG] 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] -------------------------------------------------------------------------------------------------------- كويرى لفتح السيف زون كلمه Regon يعنى المنطقه اللى عايز تقفلها جانجان ولا هوتان ولا اى بتنجان ^^ Update _RefRegion Set IsBattleField = 0 Where ContinentName = Ur Region Name /* By King$ */ -------------------------------------------------- كويرى لقفل السيف زون كلمه Regon يعنى المنطقه اللى عايز تقفلها جانجان ولا هوتان ولا اى بتنجان ^^ Update _RefRegion Set IsBattleField = 1 Where ContinentName = Ur Region Name /* By King$ */ ------------------------------------------------------------------------------------------------------ كويرى خذف اى ايتم فى اللعبه USE [SRO_VT_SHARD] Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM_COS_P_RABBIT_SCROLL' ] ---------------------------------------------------------------------------------------------------------- To get mob ID us this Query : Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC' Change MOB_RM_ROC With your Monster or Unique Code ------------------------------------------------------------------ To get ITEM ID us this Query : Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE' Change ITEM_CH_TBLADE_11_SET_A_RARE to Any item you want ------------------------------------------------------------------------------- Fast Query to Add Drops in Mob , Unique bla bla bla ^^ USE SRO_VT_SHARD -----> ( MaDenGo ) <----- GO DECLARE @MonsterID int DECLARE @ItemID int DECLARE @DropRatio real SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50% SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop 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') |
||||||||||||
|
|
|
24-02-2013, 06:30 PM
|
#6 | ||||||||||||
|
بص بقى ده كويرى تافه علشان الماجيك بوب لو عايز تقفل ديجرى محدد يعنى 11 او 12 او 13 او اى بتنجان ^^ ما عليك غير انك تاخد الكويرى ده وتعمله كوبى وباست فى SRO_VT_SHARD وبعدين كليك يمين NEW-QUEry
update _RefGachaItemSet SET Service = 0 from _RefGachaItemSet p inner join _RefObjCommon a on a.ID = p.RefItemID where a.CodeName128 like '%_11_%' and p.Service = 1 and a.CodeName128 not like '%etc%' شايف كلمه SET Service = 0 لو عايز ترجع تشغل الديجرى ده تانى خليه بدل 0 خليه 1 وعندك _11_ ده انا قافل الديجرى 11 عندى انت لو عايز تقفل الديجرى 12 او 13 ما عليك غير انك تغير الرقم ده لاى ديجرى انت عايزه يلا بقى طير انت ^^ |
||||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
.gif){kind=icon}
العرض العادي
