معلش على التأخير انا مكنتش بعض على الجهاز
Cast Away مفيهاش ADV اكتر من D12
انا جيبلك ال ADV D13 & D14
RefObjCommon
1 45004 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_ 14 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 45000
1 45005 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_SH_RARE_B_ 14 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_SH_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_shield2.ddj xxx xxx 45001
1 45006 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AR_RARE_B_ 14 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AR_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_armor2.ddj xxx xxx 45002
1 45007 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AC_RARE_B_ 14 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AC_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_accessary2.ddj xxx xxx 45003
1 45004 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_ 13 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 45004
1 45005 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_SH_RARE_B_ 13 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_SH_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_shield2.ddj xxx xxx 45005
1 45006 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AR_RARE_B_ 13 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AR_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_armor2.ddj xxx xxx 45006
1 45007 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AC_RARE_B_ 13 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AC_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_accessary2.ddj xxx xxx 45007
RefObjItem
45000 1 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45001 1 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45002 1 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45003 1 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45004 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45005 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45006 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
45007 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
itemdata_45000
1 45000 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_ 14 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 1 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45001 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_SH_RARE_B_ 14 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_SH_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_shield2.ddj xxx xxx 1 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67108864 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45002 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AR_RARE_B_ 14 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AR_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_armor2.ddj xxx xxx 6 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16909056 ?????? -1 xxx -1 xxx -1 xxx 151653120 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45003 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AC_RARE_B_ 14 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_14 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AC_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_accessary2.ddj xxx xxx 4 2 0 0 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45004 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_B_ 13 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_WE_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_weapon2.ddj xxx xxx 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100663296 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45005 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_SH_RARE_B_ 13 ?? ????(??) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_SH_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_shield2.ddj xxx xxx 1 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67108864 ?????? -1 xxx -1 xxx -1 xxx 0 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45006 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AR_RARE_B_ 13 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AR_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_armor2.ddj xxx xxx 6 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16909056 ?????? -1 xxx -1 xxx -1 xxx 151653120 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
1 45007 ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_AC_RARE_B_ 13 ?? ????(???) xxx SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_13 SN_ITEM_ETC_ARCHEMY_UPPER_REINFORCE_AC_B_RARE_TT_D ESC 0 0 3 3 10 4 180000 3 2 1 1 1 255 3 1 0 0 0 0 200000 0 0 0 2000 100 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_reinforce_recipe.bsr item\etc\archemy_upper_reinforce_accessary2.ddj xxx xxx 4 2 0 0 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 83886080 ?????? -1 xxx -1 xxx -1 xxx 201326592 ?????? 0 ?????? 2 ?????? 2 ???? +2 -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
علشان بقى تزبت ال + كام دور على
2 ???? +2
فى RefObjItem و itemdata_45000
وغير ركم 2 الاولانى ل + قلى انتا عوزو
و بالنسبة لل Drop بتاع ال Free Silk
دة لازم تزبتو ب Query بس حتعملو Mob Mob
يعنى تحت ل كل Mob ال Free Silk ب ال Query دة
لو فى اى حاجة كلمنى على
[email protected]
USE SRO_VT_SHARD
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 24160
SET @DropRatio = 0.01
SET @ItemID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = 'ITEM_EU_TSTAFF_13_C_RARE')
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')