COLLECTION BOOK RESET SCROLL?

12/29/2019 06:47 ThievesUTD#1

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

SRO_VT_SHARDLOG ADDLOGITEM:

SRO_VT_SHARD StoredProcedure [dbo].[_ForgottenWorldReset]

RefObjCommon:

Code:

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:

Code:

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:

Code:

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

12/29/2019 08:00 Mr.Awesome1337#2

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.

12/29/2019 10:17 ThievesUTD#3

Quote:

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 ( @[Only registered and activated users can see links. Click Here To Register...] = 41 ) AND (@ItemRefID = 51118))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @[Only registered and activated users can see links. Click Here To Register...]D
END"

and put yours? or just below. What is " @[Only registered and activated users can see links. Click Here To Register...]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:

Code:

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 :(

12/29/2019 11:49 NorseGodTyr#4

Quote:
Originally Posted by ThievesUTD
So i have to delete this "IF ( @[Only registered and activated users can see links. Click Here To Register...] = 41 ) AND @[Only registered and activated users can see links. Click Here To Register...]RefID = 51118))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @[Only registered and activated users can see links. Click Here To Register...]D
END"

and put yours? or just below. What is " @[Only registered and activated users can see links. Click Here To Register...]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:
Code:
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

Code:

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

12/29/2019 17:32 Mr.Awesome1337#5

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

12/29/2019 17:40 ThievesUTD#6

Quote:

Originally Posted by NorseGodTyr

use this

Code:

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:

Code:

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

Anyway ty for ur answers guys.