Problem with Rmove Blue Scroll

03/17/2019 18:21 devdash#1

PHP Code:


			
IF (@Operation = 41) and (@ItemRefID = XXXXXXXXX) 

Begin  

Update SRO_VT_SHARD.dbo._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 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID =  [MENTION=395373]Chari[/MENTION]D and Slot = '13' and ItemID > 0)  

End

this is my Remove Blue Scroll Producer

it works perfectly, but it will remove the redstats aswell, i dont want that

i want it to remove only the blues( STR/INT/HP/MP/etc.. ) except Maximum Durability thing...

please edit the producer for me, or share with me if u have a better one

thanks in advance, appreciate all the answers..

03/17/2019 22:07 NagySandor96#2

Check that which param(s) belong(s) to the red stats, then simply not to update them via your procedure. Don't be lazy...

03/17/2019 22:44 devdash#3

Quote:

Originally Posted by NagySandor96

Check that which param(s) belong(s) to the red stats, then simply not to update them via your procedure. Don't be lazy...

thanks for your answer,
there's no spcific param for red stats as i knew O_o
and trust me iam not lazy at all..

03/22/2019 23:03 devdash#4

topic close please.