Maximum Durability Scroll Remover

03/17/2020 05:17 loader8#1

Hi guys who can help me changing this Produce to remove only the Maximum durability % reduce , be cause right now clean me all the blue in the item

Code:

IF(@JobID= '33859') 
		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 = [MENTION=395373]Chari[/MENTION]D and Slot =13 and ItemID Between 1 AND 999999999)
	END

03/19/2020 18:12 JohnDornel^#2

Well in short, create an item and put red stats through SMC. Each item, different stat (all possibilities). Once you are done, record all the MagParams and in your code you just have to check MagParam1-9 for all those params you recorded earlier if they exists, if they do remove them and set MagParamNum - 1, mind you you have to keep the order of blues or it might bug out.

03/25/2020 06:14 loader8#3

Quote:

Originally Posted by JohnDornel^

Well in short, create an item and put red stats through SMC. Each item, different stat (all possibilities). Once you are done, record all the MagParams and in your code you just have to check MagParam1-9 for all those params you recorded earlier if they exists, if they do remove them and set MagParamNum - 1, mind you you have to keep the order of blues or it might bug out.

i think i will make a produc then i will call it when use the scroll

03/26/2020 21:33 ibraimzakaria#4

well

03/27/2020 09:13 White Ros3#5

you can get the required params from SMC by setting maximum durability from SMC then extract the param from _items table but the main problem here is you can only get specific params for maximum durability from 5 to 55 not all so you will face problems with 90%+ maximum durability you have to open alchemy bot and get the rest params of 90%+ maximum durability yourself if you want the scroll to remove only the maximum durabilit not all blues

04/02/2020 04:10 loader8#6

Quote:

Originally Posted by White Ros3

you can get the required params from SMC by setting maximum durability from SMC then extract the param from _items table but the main problem here is you can only get specific params for maximum durability from 5 to 55 not all so you will face problems with 90%+ maximum durability you have to open alchemy bot and get the rest params of 90%+ maximum durability yourself if you want the scroll to remove only the maximum durabilit not all blues

oh nice, i was taking the params from Alchemy XD i will get the lowers % in SMC thx for the information,

04/02/2020 11:06 White Ros3#7

Quote:

Originally Posted by loader8

oh nice, i was taking the params from Alchemy XD i will get the lowers % in SMC thx for the information,

you are welcome