Problem with Reset PK/ADV/Durability Scrolls

01/05/2019 17:47 devdash#1

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

ADV & Durability 13 slot recommended please

thanks in advance..

01/06/2019 14:35 Leodoom#2

Spoiler

01/06/2019 17:15 devdash#3

Quote:

Originally Posted by Leodoom

Spoiler

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

01/06/2019 23:44 Leodoom#4

01/07/2019 00:03 devdash#5

Quote:

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

01/07/2019 00:05 Leodoom#6

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

01/07/2019 09:29 cristianxi#7

Quote:

Originally Posted by Leodoom

Spoiler

if(@Operation = 41 and @[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]D and Slot between 0 and 12 and ItemID Between 1 AND 999999999)

end

This will remove Dur and all blues xD

01/07/2019 12:16 devdash#8

Quote:

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

Quote:

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