Help with Remove Adv & Durability Scrolls please!!

[devdash]

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

[MrCatGardens]

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)

[devdash]

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 @ = '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

[MrCatGardens]

Originally Posted by alydandy

should be like that ?

if(@ItemRefID= '99999999' and @ = '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

[devdash]

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...

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