elbattawy1st
24-02-2016, 07:28 AM
الموضوع دا كان معمول قبل كده بس كان بيشيل كل الايتم الا فيها adv معاك حتى الا انت لابسها اما الاسكروله دى محدده لايتم واحد بس
علشان الاسكرول تشتغل لازم تحط الايتم فى اول خانة من inventory
نخش فى الموضوع على طول
DataBase Side :
RefObjCommon
1 61508 ITEM_MALL_ADV_REMOVE ???? ???? ??? (???) xxx SN_ITEM_MALL_ADV_REMOVE SN_ITEM_MALL_ADV_REMOVE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 2239122
RefObjItem
2239122 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -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
ِAdd To _AddLogItem
IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID = 61508) -- Adv removal
BEGIN
DELETE FROM [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] where nItemDBID IN (SELECT ItemID FROM [SRO_VT_SHARD].[dbo].[_Inventory] WHERE Slot= 13 AND CharID = @CharID) and bOptType = 2
END
END
-----------------------------------------------------------------
Media Side :
itemdata_45000
1 61508 ITEM_MALL_ADV_REMOVE ???? ???? ??? (???) xxx SN_ITEM_MALL_ADV_REMOVE SN_ITEM_MALL_ADV_REMOVE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -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
textdata_object
1 SN_ITEM_MALL_ADV_REMOVE Adv Remover Scroll
1 SN_ITEM_MALL_ADV_REMOVE_TT_DESC <sml2>After using this you should teleport AutoMatice and it will Remove adv from ur item<br><br><font color="255,255,255,0">How to use:</font><br>- Put Item which want to remove adv from it into slot 1 in ur inventory <br>- Have Fun!</sml2>
علشان الاسكرول تشتغل لازم تحط الايتم فى اول خانة من inventory
نخش فى الموضوع على طول
DataBase Side :
RefObjCommon
1 61508 ITEM_MALL_ADV_REMOVE ???? ???? ??? (???) xxx SN_ITEM_MALL_ADV_REMOVE SN_ITEM_MALL_ADV_REMOVE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 2239122
RefObjItem
2239122 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -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
ِAdd To _AddLogItem
IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID = 61508) -- Adv removal
BEGIN
DELETE FROM [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] where nItemDBID IN (SELECT ItemID FROM [SRO_VT_SHARD].[dbo].[_Inventory] WHERE Slot= 13 AND CharID = @CharID) and bOptType = 2
END
END
-----------------------------------------------------------------
Media Side :
itemdata_45000
1 61508 ITEM_MALL_ADV_REMOVE ???? ???? ??? (???) xxx SN_ITEM_MALL_ADV_REMOVE SN_ITEM_MALL_ADV_REMOVE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -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
textdata_object
1 SN_ITEM_MALL_ADV_REMOVE Adv Remover Scroll
1 SN_ITEM_MALL_ADV_REMOVE_TT_DESC <sml2>After using this you should teleport AutoMatice and it will Remove adv from ur item<br><br><font color="255,255,255,0">How to use:</font><br>- Put Item which want to remove adv from it into slot 1 in ur inventory <br>- Have Fun!</sml2>