PROBLEM WITH CUSTOM SCROLLS

[ThievesUTD]

I have added new Remover blues scrolls, one for equipment, and one for avatars, i dont mention redstat remover scroll bc i know its hard and it requires hard querys. Anyway here my lines:

EQUIPMENT BLUES REMOVER:

When i put the item in the 1st slot inventory (13 in db) and activate scroll, it works but the item keep with blues...

 Spoiler

RefObjcommon:

1	51119	ITEM_BLUES_REMOVER	??	???	SN_ITEM_BLUES_REMOVER_FGW	SN_ITEM_BLUES_REMOVER_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_ch_eventbox.bsr	item\etc\mall_skill_point_recall_b.ddj	xxx	xxx	26824	No Name

RefObjItem:

26824	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	500	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

SHARDLOG --AddLogItem:

IF (@Operation = 41) and (@ItemRefID = 51119) 
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 = ChariD and Slot = '13' and ItemID > 0)  
End

ITEMDATA_45000:

1	51119	ITEM_BLUES_REMOVER	??	???	SN_ITEM_BLUES_REMOVER_FGW	SN_ITEM_BLUES_REMOVER_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_ch_eventbox.bsr	item\etc\mall_skill_point_recall_b.ddj	xxx	xxx	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	500	????	1	??????                                                                                                                           	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

AVATAR BLUES REMOVER:

When i press the scroll it appears like a buff above and it ends fast, then i teleport manually but avatar keeps with blues... (This scroll should work while the user is wearing any avatar, dress, hat or attach...)

 Spoiler

RefObjCommon:

1	51120	ITEM_MALL_REMOV_BLUE_AV	???(???)	???	SN_ITEM_MALL_REMOV_BLUE_AV	SN_ITEM_MALL_REMOV_BLUE_AV_TT_DESC	1	0	3	3	13	1	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	Premium\etc\changename.ddj	xxx	xxx	26825	No Name

RefObjItem:

26825	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	SKILL_MALL_REMOVEBLAV	-1	xxx                                                                                                                              	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

Refskill:

1	34092	1231	SKILL_MALL_REMOVEBLAV	???? ????	SKILL_MALL_REMOVEBLAV	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_MALL_REMOVEBLAV	xxx	SN_SKILL_MALL_REMOVEBLAV_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

Refskillgroup:

1231	SKILL_MALL_REMOVEBLAV

SHARD--AddTimedJob:

 IF(@JobID= '34092') 
		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 _Inventoryforavatar where CharID =  @ CharID and Slot between 0 and 2 and ItemID>0)
			return -3 
		end

ITEMDATA_45000:

1	51120	ITEM_MALL_REMOV_BLUE_AV	???(???)	???	SN_ITEM_MALL_REMOV_BLUE_AV	SN_ITEM_MALL_REMOV_BLUE_AV_TT_DESC	1	0	3	3	13	1	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	Premium\etc\changename.ddj	xxx	xxx	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	SKILL_MALL_REMOVEBLAV	-1	xxx                                                                                                                              	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

SKILLDATA_35000enc:

1	34092	1231	SKILL_MALL_REMOVEBLAV	???? ????	SKILL_MALL_REMOVEBLAV	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_MALL_REMOVEBLAV	xxx	SN_SKILL_MALL_REMOVEBLAV_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

PD: I tried restarting shardmanager too...

[C 9]

this function action doesn't work correctly like you're updating (unknown results) that's mean you didn't mention slot 13 into your procedure, so the scroll will not take any effects. Also your procedure is weak going to smash your logs if you got more than 100++ players. i hope that i helped you!

[ThievesUTD]

Originally Posted by C 9

this function action doesn't work correctly like you're updating (unknown results) that's mean you didn't mention slot 13 into your procedure, so the scroll will not take any effects. Also your procedure is weak going to smash your logs if you got more than 100++ players. i hope that i helped you!

Ok i think its good idea to delete it for while until i get the correct way, have to delete in addtimedjob too?

[C 9]

Originally Posted by ThievesUTD

Ok i think its good idea to delete it for while until i get the correct way, have to delete in addtimedjob too?

timed job isn't a part from the scroll logs or orders you need addlog item + scroll to make it works, i can code it for you if you want.

[ThievesUTD]

Originally Posted by C 9

timed job isn't a part from the scroll logs or orders you need addlog item + scroll to make it works, i can code it for you if you want.

Well if u can i will apreciate it, happy new year