قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
USE SRO_VT_SHARDLOG /* By ™BaZzZoKa™ */
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
bann player with cher name
كود PHP:
USE SRO_VT_SHARDLOG /* By ™BaZzZoKa™ */
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @CharName VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @CharName = 'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
-----------------------------------------------------------------
USE SRO_VT_ACCOUNT
DECLARE @ID VARCHAR (64)
DECLARE @Reason VARCHAR(128)
DECLARE @Begin DATETIME
DECLARE @End DATETIME
SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID)
---------------------------------
SET @Reason = 'Ban Reason Here'
SET @Begin = '2012-05-01 00:00:00.000' -- Time Begin --
SET @End = '2040-01-01 00:00:00.000' -- Time End --
---------------------------------
---------------------------
-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------
--By Leandro (™BaZzZoKa™ ) --
Unbann player by cher name
كود PHP:
USE SRO_VT_SHARDLOG /* By ™BaZzZoKa™ */
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @CharName VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @CharName = 'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
--------------------------------
USE [SRO_VT_ACCOUNT]
--------------------------------
DELETE FROM [dbo].[_BlockedUser]
WHERE UserJID = @AccJID
DELETE FROM [dbo].[_Punishment]
WHERE UserJID = @AccJID
--By Leandro ( nukertube ) --
-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------
عايز تظبط مواعيد اليونيك عندك ف الداتا
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1 where dwdelaytimemax = '21600' ;
21600 دة الوقت با السنية
لو الجهاز عاندك رامات 2
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/3
لو جهازك 4 GB Memeroy Ram
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2
لو عايز تمسح اكونت و متستناش 7 ايامـ
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
DELETE FROM _InventoryForAvatar WHERE charid = '13055'
DELETE FROM _Inventory WHERE charid = '13055'
DELETE FROM _CharSkillMastery WHERE charid = '13055'
DELETE FROM _CharSkill WHERE charid = '13055'
DELETE FROM _CharTrijob WHERE charid = '13055'
DELETE FROM _User WHERE charid = '13055'
DELETE FROM _StaticAvatar WHERE charid = '13055'
DELETE FROM _TimedJob WHERE charid = '13055'
DELETE FROM _char WHERE charid = '13055'
DELETE FROM _Friend WHERE charid = '13055'
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
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,Data2,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,Data2,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
نفسك اي حد يسجل عندك ينزل ب معاه سيلك اوتوماتيك ومن غير مواقع ولا اي حاجه
كود PHP:
USE SRO_VT_ACCOUNT /* By ™BaZzZoKa™ */
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
كمية السيلك مكان +10 حوط الكمية الانتا عايزة
لو بف الا كاديمى عاندك مش شغال استخدمـ دة
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
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
عايز تتحكم ف ال Sox Drop Rate
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
مكان ركمـ 10 النسبة الانتا عايزة
العدد المسموح للاليكسر فوق بعضها ضعيف عندك
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
UPDATE dbo._RefObjItem
SET MaxStack = 50
WHERE ID BETWEEN 3679 AND 3682
Remove Pk All Players
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint = 0
Remeove Item From All Player
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM_COS_P_RABBIT_SCROLL' ]
Query To Drop D13
كود PHP:
USE SRO_VT_SHARD /* Query To Drop D13 By ™BaZzZoKa™ */
GO
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='130'
Query 2
كود PHP:
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='130'
Query change quest FGW for Degree13
كود PHP:
USE SRO_VT_SHARD /* Query change quest FGW for Degree13 By ™BaZzZoKa™ */
GO
DECLARE @NewItem1 varchar(128)
DECLARE @NewItem2 varchar(128)
DECLARE @NewItem3 varchar(128)
DECLARE @NewItem4 varchar(128)
DECLARE @NewItem5 varchar(128)
DECLARE @NewItem6 varchar(128)
DECLARE @NewItem7 varchar(128)
DECLARE @NewItem8 varchar(128)
DECLARE @NewItem9 varchar(128)
DECLARE @NewItem10 varchar(128)
DECLARE @NewItem11 varchar(128)
DECLARE @NewItem12 varchar(128)
DECLARE @NewItem13 varchar(128)
DECLARE @NewItem14 varchar(128)
/* Script New Itens */
SET @NewItem1='ITEM_CH_SWORD_13_C_RARE' -- New Items
SET @NewItem2='ITEM_CH_BLADE_13_C_RARE' -- New Items
SET @NewItem3='ITEM_CH_SPEAR_13_C_RARE' -- New Items
SET @NewItem4='ITEM_CH_TBLADE_13_C_RARE' -- New Items
SET @NewItem5='ITEM_CH_BOW_13_C_RARE' -- New Items
SET @NewItem6='ITEM_EU_SWORD_13_C_RARE' -- New Items
SET @NewItem7='ITEM_EU_TSWORD_13_C_RARE' -- New Items
SET @NewItem8='ITEM_EU_AXE_13_C_RARE' -- New Items
SET @NewItem9='ITEM_EU_DAGGER_13_C_RARE' -- New Items
SET @NewItem10='ITEM_EU_CROSSBOW_13_C_RARE' -- New Items
SET @NewItem11='ITEM_EU_TSTAFF_13_C_RARE' -- New Items
SET @NewItem12='ITEM_EU_DARKSTAFF_13_C_RARE' -- New Items
SET @NewItem13='ITEM_EU_STAFF_13_C_RARE' -- New Items
SET @NewItem14='ITEM_EU_HARP_13_C_RARE' -- New Items
/* End Script New Itens */
/* Script Update New Itens */
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem1
WHERE ItemCodeName='ITEM_CH_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem2
WHERE ItemCodeName='ITEM_CH_BLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem3
WHERE ItemCodeName='ITEM_CH_SPEAR_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem4
WHERE ItemCodeName='ITEM_CH_TBLADE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem5
WHERE ItemCodeName='ITEM_CH_BOW_11_SET_A_RARE'
/*HeroSilkroad Revolution*/
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem6
WHERE ItemCodeName='ITEM_EU_SWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem7
WHERE ItemCodeName='ITEM_EU_TSWORD_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem8
WHERE ItemCodeName='ITEM_EU_AXE_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem9
WHERE ItemCodeName='ITEM_EU_DAGGER_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem10
WHERE ItemCodeName='ITEM_EU_CROSSBOW_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem11
WHERE ItemCodeName='ITEM_EU_TSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem12
WHERE ItemCodeName='ITEM_EU_DARKSTAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem13
WHERE ItemCodeName='ITEM_EU_STAFF_11_SET_A_RARE'
UPDATE _RefQuestRewardItems
SET ItemCodeName=@Newitem14
WHERE ItemCodeName='ITEM_EU_HARP_11_SET_A_RARE'
/* End Script Update New Itens */
/* Insert Shield Degree13 Europe and Chinese in quest Forgotten */
INSERT INTO _RefQuestRewardItems ([Service], QuestID, QUestCodeName, RewardType, ItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, RentItemCodeName, Param1, Param1_Desc, Param2, Param2_Desc) VALUES (1, 799, 'QNO_FW_RS1_001', 0, 'ITEM_CH_SHIELD_13_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
INSERT INTO _RefQuestRewardItems ([Service], QuestID, QUestCodeName, RewardType, ItemCodeName, OptionalItemCode, OptionalItemCnt, AchieveQuantity, RentItemCodeName, Param1, Param1_Desc, Param2, Param2_Desc) VALUES (1, 799, 'QNO_FW_RS1_001', 0, 'ITEM_EU_SHIELD_13_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
/* End insert Shield Degree13 Europe and Chinese in quest Forgotten */
Find Mob Code
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
select ID from _RefObjCommon where CodeName128 like 'MOB_CH_TIGERWOMAN'
Change title by Cher name
كود PHP:
USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
Update _Char
set HwanLevel = 'Title Num'
where CharName16 = 'Cher Name'
Change Time oF FGW
كود PHP:
USE SRO_VT_SHARD /* change time of FGW By ™BaZzZoKa™ */
GO
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2'
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2'
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_3'
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35901'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35902'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35903'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35904'
10800 دة الوقت بالسنية
Change inventorysize by Cher Name
كود PHP:
USE SRO_VT_SHARD /* change inventorysize by Cher name By ™BaZzZoKa™ */
GO
--by Atossuper
Declare @CharName Varchar (64)
Set @CharName = 'Put Chr name here'
UPDATE dbo._Char
--change 77 to any number you want for make 3 inv put number 109
SET InventorySize= 77
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Add Unique Spot
كود PHP:
USE SRO_VT_SHARD /* Add Unique Spot By ™BaZzZoKa™ */
Go
DECLARE @UNIQUE VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1
/* put your settings here */
SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 60 -- Minimum time before appears in seconds
SET @maxdelay = 120 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @RADIUS = 500 -- Radius around spot Unique can move in
/* end of settings area */
/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF
SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
SET IDENTITY_INSERT Tab_RefHive OFF
/* get position coordinates of your character */
DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)
SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF
print ''
print ''
print 'Done!'
Add new Teleport
كود PHP:
USE SRO_VT_SHARD /* Add new Teleport By ™BaZzZoKa™ */
Go
DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT
/* Put your settings here */
SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000 -- Gold amount to Pass the teleport
SET @RequiredLVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport
/* settings area end here */
IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport)
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);
RETURN;
END
DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\teleport01.bsr','xxx','xxx','xxx','xxx',@link)
SET IDENTITY_INSERT _RefObjCommon OFF
SET IDENTITY_INSERT _RefObjStruct ON
INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
(@LINK,0)
SET IDENTITY_INSERT _RefObjStruct OFF
DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)
INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0)
print ''
print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0'
print ''
print ''
IF @RequiredLVL = 0
BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES
(1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
هوا ف جديد و فى قديم فعلشان محدش يدخل و يقول كلمتين ملهومش لازمه ادخل على موضوع
Make Your DataBase With Your Self
و شوف اللى موجود منو ف موضوعك و امسحوا
تقبل مرورى
المشاركة الأصلية كتبت بواسطة developer
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
هوا ف جديد و فى قديم فعلشان محدش يدخل و يقول كلمتين ملهومش لازمه ادخل على موضوع
make your database with your self
و شوف اللى موجود منو ف موضوعك و امسحوا
تقبل مرورى
انا قولت اعمل الموضوع دة عشان يكون شامل جميع القورى و انشاء الله اى حاجة جديدة هضفها هنا
بسم الله الرحمن الرحيم والصلاة والسلام على اشرف المرسلين
اللهم أنت ربي لا إله الا أنت، خلقتني وأنا عبدك وأنا على عهدك ووعدك ما استطعت، أعوذ بك من شر ما صنعت، أبوء لك بنعمتك عليّ وأبوء بذنبي، فاغفر لي، فإنه لا يغفر الذنوب إلا أنت
السلام عليكم ورحمه الله وبركاته
شكراً على هذا المجهود الضخم والى الافضل دائماً ان شاء الله
المشاركة الأصلية كتبت بواسطة {viper}
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
شكراا ياريس
اقتباس:
المشاركة الأصلية كتبت بواسطة ™ MyReturn ™
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ThX
اقتباس:
المشاركة الأصلية كتبت بواسطة mimomaro
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
فاجلر اوى
اقتباس:
المشاركة الأصلية كتبت بواسطة sherifalbasha
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بسم الله الرحمن الرحيم والصلاة والسلام على اشرف المرسلين
اللهم أنت ربي لا إله الا أنت، خلقتني وأنا عبدك وأنا على عهدك ووعدك ما استطعت، أعوذ بك من شر ما صنعت، أبوء لك بنعمتك عليّ وأبوء بذنبي، فاغفر لي، فإنه لا يغفر الذنوب إلا أنت
السلام عليكم ورحمه الله وبركاته
شكراً على هذا المجهود الضخم والى الافضل دائماً ان شاء الله
28-03-2013, 07:21 PM
.png "(118)")
المواضيع المتشابهه
.gif){kind=icon}
.gif){kind=icon}
العرض العادي
