Help with Remove Adv & Durability Scrolls please!!

i just need this two scrolls
1. Remove Adv Scroll "13 Slot"
2. Remove Duraibility State Scroll "13 Slot"

i want em throw AddLogItem please


thanks in advance

ADV:
just write the procedure yourself, can use the _addlogitem. isn't that hard.

get the charid, then search for the ID64 and then join the _bindingoptionwithitem, search for the nitemdbid (ID64) and delete the row with bopttype = 2 (2 should be adv)

Quote:

Originally Posted by infinityProject ADV: just write the procedure yourself, can use the _addlogitem. isn't that hard. get the charid, then search for the ID64 and then join the _bindingoptionwithitem, search for the nitemdbid (ID64) and delete the row with bopttype = 2 (2 should be adv)

should be like that ?

if(@ItemRefID= '99999999' and @[Only registered and activated users can see links. Click Here To Register...] = '41')
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 = 4
END

Quote:

Originally Posted by alydandy should be like that ? if(@ItemRefID= '99999999' and @[Only registered and activated users can see links. Click Here To Register...] = '41') 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 = 4 END

could work, just test it :) to be sure, make a db backup before executing :)

EDIT: ...where nItemDBID IN (SELECT ItemID ... replace "in" by "=" . for adv theres no in required, since you'll have max 1 entry for that

Quote:

Originally Posted by infinityProject could work, just test it :) to be sure, make a db backup before executing :)

going to test it now, and i will write back the results...

Quote:

Originally Posted by infinityProject could work, just test it :) to be sure, make a db backup before executing :) EDIT: ...where nItemDBID IN (SELECT ItemID ... replace "in" by "=" . for adv theres no in required, since you'll have max 1 entry for that

that was my first producer ever and it worked lol...seems like someone leveling up :)

thanks bro for leting me try this, i really appreciate it <3

what about the Duraibility one ?

i need the durability reset scroll now please!! if anyone got it... i need it for AddLogItem if possible