Problem with Reset PK/ADV/Durability Scrolls

[devdash]

i need these 3 scrolls with AddLogItem, that can be used with Return scrolls please

ADV & Durability 13 slot recommended please

thanks in advance..

[Leodoom]

 Spoiler

if(@Operation = 41 and @RefID = 92257) -- Maxmium Durbality Remover
begin
Update _Items
Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventory where CharID = @D and Slot between 0 and 12 and ItemID Between 1 AND 999999999)


end

[devdash]

Originally Posted by Leodoom

 Spoiler

if(@Operation = 41 and @RefID = 92257) -- Maxmium Durbality Remover
begin
Update _Items
Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventory where CharID = @D and Slot between 0 and 12 and ItemID Between 1 AND 999999999)


end

thanks for your post i will try it now and i will write back the result...

[Leodoom]

ok

[devdash]

Originally Posted by Leodoom

ok

i have puted the item on the "13 slot" didn't work
so i tried while it on my hand, didn't work either

is that working with you ? cuz its not working with me

[Leodoom]

Slot between 0 and 12 and ItemID Between 1 AND 999999999)
Slot 13 and ItemID Between 1 AND 999999999)

I did not try but to write on the fast and did not try

[cristianxi]

Originally Posted by Leodoom

 Spoiler

if(@Operation = 41 and @RefID = 92257) -- Maxmium Durbality Remover
begin
Update _Items
Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventory where CharID = @D and Slot between 0 and 12 and ItemID Between 1 AND 999999999)


end

This will remove Dur and all blues xD

[devdash]

Originally Posted by Leodoom

Slot between 0 and 12 and ItemID Between 1 AND 999999999)
Slot 13 and ItemID Between 1 AND 999999999)

I did not try but to write on the fast and did not try

it didn't work with return scroll lines, should i add skill line ?, and i really appreciate ur fast write..

Originally Posted by cristianxi

This will remove Dur and all blues xD

actually it didn't remove he dur or the blues, do u have the dur one please ?
and the blues one aswell cuz yeah i think it will be usefull for my players

thanks in advance