مشاهدة النسخة كاملة : مساعده بالمواضيع دول
MasterioPayBack
15-02-2017, 04:56 PM
السلام عليكم
انا عايز مساعده بالنسبه للمواضيع دي
اولا عايز اعرف اغير الريوارد بتاع كاردز ال FGW من Egy Weapons ل D10 Sun Weapons ?
عايز اعرف ازاي اشيل D11 من الماجيك بوب ؟
وشكرا
:huh::huh::artist1:
Dev.Klito
15-02-2017, 05:36 PM
ارجو اختيار اسم واضح للموضوع و يتعلق بالموضوع ... ياريت تشوف القوانين كويس
بخصوص الــ FGW
اعمل دى
USE SRO_VT_SHARD
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_10_C_RARE' -- New Items
SET @NewItem2='ITEM_CH_BLADE_10_C_RARE' -- New Items
SET @NewItem3='ITEM_CH_SPEAR_10_C_RARE' -- New Items
SET @NewItem4='ITEM_CH_TBLADE_10_C_RARE' -- New Items
SET @NewItem5='ITEM_CH_BOW_10_C_RARE' -- New Items
SET @NewItem6='ITEM_EU_SWORD_10_C_RARE' -- New Items
SET @NewItem7='ITEM_EU_TSWORD_10_C_RARE' -- New Items
SET @NewItem8='ITEM_EU_AXE_10_C_RARE' -- New Items
SET @NewItem9='ITEM_EU_DAGGER_10_C_RARE' -- New Items
SET @NewItem10='ITEM_EU_CROSSBOW_10_C_RARE' -- New Items
SET @NewItem11='ITEM_EU_TSTAFF_10_C_RARE' -- New Items
SET @NewItem12='ITEM_EU_DARKSTAFF_10_C_RARE' -- New Items
SET @NewItem13='ITEM_EU_STAFF_10_C_RARE' -- New Items
SET @NewItem14='ITEM_EU_HARP_10_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_10_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_10_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
/* End insert Shield Degree13 Europe and Chinese in quest Forgotten */
عشان الــ Magic Pop اعمل دى
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%'
واضح انك بتعمل داتا D10 عشان تشيل Drop ال D11 كلو اعمل دى
update _RefDropItemAssign
SET Service = 0
from _RefDropItemAssign p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '%_11_%' and p.Service = 1
Dev.Klito
15-02-2017, 05:36 PM
ارجو اختيار اسم واضح للموضوع و يتعلق بالموضوع ... ياريت تشوف القوانين كويس
بخصوص الــ FGW
اعمل دى
USE SRO_VT_SHARD
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_10_C_RARE' -- New Items
SET @NewItem2='ITEM_CH_BLADE_10_C_RARE' -- New Items
SET @NewItem3='ITEM_CH_SPEAR_10_C_RARE' -- New Items
SET @NewItem4='ITEM_CH_TBLADE_10_C_RARE' -- New Items
SET @NewItem5='ITEM_CH_BOW_10_C_RARE' -- New Items
SET @NewItem6='ITEM_EU_SWORD_10_C_RARE' -- New Items
SET @NewItem7='ITEM_EU_TSWORD_10_C_RARE' -- New Items
SET @NewItem8='ITEM_EU_AXE_10_C_RARE' -- New Items
SET @NewItem9='ITEM_EU_DAGGER_10_C_RARE' -- New Items
SET @NewItem10='ITEM_EU_CROSSBOW_10_C_RARE' -- New Items
SET @NewItem11='ITEM_EU_TSTAFF_10_C_RARE' -- New Items
SET @NewItem12='ITEM_EU_DARKSTAFF_10_C_RARE' -- New Items
SET @NewItem13='ITEM_EU_STAFF_10_C_RARE' -- New Items
SET @NewItem14='ITEM_EU_HARP_10_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_10_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_10_C_RARE', 'xxx', 0, 1, 'xxx', 0, 'xxx', 0, 'xxx')
/* End insert Shield Degree13 Europe and Chinese in quest Forgotten */
عشان الــ Magic Pop اعمل دى
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%'
واضح انك بتعمل داتا D10 عشان تشيل Drop ال D11 كلو اعمل دى
update _RefDropItemAssign
SET Service = 0
from _RefDropItemAssign p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '%_11_%' and p.Service = 1
MasterioPayBack
15-02-2017, 06:04 PM
يااااه تسلم يا معلم
و اسف عشان عنوان الموضوع معرفتش اكتب ايه :)
شكرا :mf_lustslow::mf_lustslow:
Dev.Klito
16-02-2017, 02:02 PM
##
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc