COLLECTION BOOK RESET SCROLL?

[ThievesUTD]

When i press the scroll nothing happens, here my lines, thanks in advanced.

SRO_VT_SHARDLOG ADDLOGITEM:

 Spoiler

--FGW REMOVER SCROLL--

IF ((@Operation = 41 ) AND (@ItemRefID = 51118))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset [MENTION=395373]Chari[/MENTION]D
END

SRO_VT_SHARD StoredProcedure [dbo].[_ForgottenWorldReset]

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_ForgottenWorldReset]    Script Date: 29/12/2019 12:34:55 a.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_ForgottenWorldReset]
 [MENTION=395373]Chari[/MENTION]D INT
AS

BEGIN

DELETE FROM _CharQuest WHERE QuestID = 799 AND CharID = [MENTION=395373]Chari[/MENTION]D
DELETE FROM _CharCollectionBook WHERE ThemeID = 4 AND CharID = [MENTION=395373]Chari[/MENTION]D

END

RefObjCommon:

1	51118	ITEM_RESET_FGW	??	???	xxx SN_ITEM_RESET_FGW	SN_ITEM_RESET_FGW_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_server_change_scroll.ddj	xxx	xxx	26823	No Name

RefObjItem:

26823	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	0	0	-1	5000                                                                                                                             	-1	1	-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

ITEMDATA:

1	51118	ITEM_RESET_FGW	??	???	xxx SN_ITEM_RESET_FGW	SN_ITEM_RESET_FGW_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_server_change_scroll.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	0	0	-1	5000                                                                                                                             	-1	1	-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

[Mr.Awesome1337]

Put that in _AddLogItem

PHP Code:

if(@Operation = 16 and  [MENTION=1134588]item[/MENTION]RefID = 51118) -- Fgw Reset
begin
Delete from SRO_VT_SHARD.._CharQuest where QuestID = 799 and CharID =  [MENTION=395373]Chari[/MENTION]D
Delete from SRO_VT_SHARD.._CharCollectionBook where ThemeID = 4 and CharID =  [MENTION=395373]Chari[/MENTION]D
end 


Change Those [MENTIONS] to @ CharID and @ ItemRefID, it won't allow me to disable mentioning.

[ThievesUTD]

Originally Posted by Mr.Awesome1337

Put that in _AddLogItem

PHP Code:

if  [MENTION=1059401]operation[/MENTION] = 16 and  [MENTION=1134588]item[/MENTION]RefID = 51118) -- Fgw Reset
begin
Delete from SRO_VT_SHARD.._CharQuest where QuestID = 799 and CharID =      [MENTION=395373]Chari[/MENTION]D
Delete from SRO_VT_SHARD.._CharCollectionBook where ThemeID = 4 and CharID =      [MENTION=395373]Chari[/MENTION]D
end 


Change Those [MENTIONS] to @ CharID and @ ItemRefID, it won't allow me to disable mentioning.

So i have to delete this "IF ( @ = 41 ) AND (@ItemRefID = 51118))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @D
END"

and put yours? or just below. What is " @D 1134588"? i dont want to make it for one character, i wanna make it for all people just for buying scroll and activate it...

Update...

I have put this:

IF @ Operation = '16'
BEGIN
IF (@ ItemRefID = 51118)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._CharQuest WHERE QuestID = 799 AND CharID = @ CharID
DELETE FROM SRO_VT_SHARD.dbo._CharCollectionBook WHERE ThemeID = 4 AND CharID = @ CharID
End
End

But still not working

[NorseGodTyr]

Originally Posted by ThievesUTD

So i have to delete this "IF ( @ = 41 ) AND @RefID = 51118))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @D
END"

and put yours? or just below. What is " @D 1134588"? i dont want to make it for one character, i wanna make it for all people just for buying scroll and activate it...

Update...

I have put this:

IF @ Operation = '16'
BEGIN
IF (@ ItemRefID = 51118)
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._CharQuest WHERE QuestID = 799 AND CharID = @ CharID
DELETE FROM SRO_VT_SHARD.dbo._CharCollectionBook WHERE ThemeID = 4 AND CharID = @ CharID
End
End

But still not working

use this

IF @ Operation = '41' and @ ItemRefID = 51118
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._CharQuest WHERE QuestID = 799 AND CharID = @ CharID
DELETE FROM SRO_VT_SHARD.dbo._CharCollectionBook WHERE ThemeID = 4 AND CharID = @ CharID
End

[Mr.Awesome1337]

Elitepvpers system consider @ CharID as a mention to some user called CharID so its changing CharID to the ID of this user, use this and just delete the after every "@" symbol

if(@ Operation = 41 and @ ItemRefID = 51118) -- Fgw Reset
begin
Delete from SRO_VT_SHARD.._CharQuest where QuestID = 799 and CharID = @ CharID
Delete from SRO_VT_SHARD.._CharCollectionBook where ThemeID = 4 and CharID = @ CharID
end

Note: Operation = 41 is for return scroll type

[ThievesUTD]

Originally Posted by NorseGodTyr

use this

IF @ Operation = '41' and @ ItemRefID = 51118
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._CharQuest WHERE QuestID = 799 AND CharID = @ CharID
DELETE FROM SRO_VT_SHARD.dbo._CharCollectionBook WHERE ThemeID = 4 AND CharID = @ CharID
End

Does not work, i think the problem is in refobjchar, can u see char and itemdata lines and tell me if it is correct?, i think there must be a "RESURRECT" or "SKILL_MALL_....." or something like that?

FIXED:

PROBLEM WAS IN REFOBJITEM LINE, THIS IS THE CORRECT:

26823	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	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	-1	***	0	0	0

Anyway ty for ur answers guys.