A question about Shipewreck quest ! (Egy weapon)

Sry for many asking. How can i make this quest repeatable.

Its allowed once / char. It can be repeatable 1-2-3..etc times per char ?
[Only registered and activated users can see links. Click Here To Register...]

you can edit it from quest script

add this to AddLogItem at sro_vt_shardlog

press thanks if i helped

Quote:

Originally Posted by Aurora Online add this to AddLogItem at sro_vt_shardlog press thanks if i helped

Did u got what i mean? i mean i can make the quest over and over again at 1 char.

In ur query, (SCROLL ID from refobjcommon) which scroll ?

Quote:

Originally Posted by Crue* you can edit it from quest script

sry, quest script in the media+DB or at server files. and where is it in server files ? Ty

server files
but you've to decompile it

Quote:

Originally Posted by hamzafigo Sry for many asking. How can i make this quest repeatable. Its allowed once / char. It can be repeatable 1-2-3..etc times per char ? [Only registered and activated users can see links. Click Here To Register...]

You can't make it repeatable from the quest script, only by creating a scroll which resets your collection book and deletes the quest from _CharQuest

Quote:

Originally Posted by hamzafigo Did u got what i mean? i mean i can make the quest over and over again at 1 char. In ur query, (SCROLL ID from refobjcommon) which scroll ? sry, quest script in the media+DB or at server files. and where is it in server files ? Ty

I thought you want it by a scroll.

you can make it w/o scroll too.
addthis @ _AddLOGChar at log DB


press thanks if i helped

Quote:

Originally Posted by Aurora Online I thought you want it by a scroll. you can make it w/o scroll too. addthis @ _AddLOGChar at log DB press thanks if i helped

What does this do? I mean, now i make the quest and got the weapon, what now ? just teleport and the book will be clean or what ?

Ty for helping guys

Edit: Tested and didn`t work. With a new char, i finished the quest once then teleported. and tried to get it again. nothing happened. And the books still at collection book.

Quote:

Originally Posted by hamzafigo What does this do? I mean, now i make the quest and got the weapon, what now ? just teleport and the book will be clean or what ? Ty for helping guys Edit: Tested and didn`t work. With a new char, i finished the quest once then teleported. and tried to get it again. nothing happened. And the books still at collection book.  Spoiler DECLARE @CharID1 Varchar (MAX) SELECT CharID from SRO_VT_SHARD.._CharQuest where QuestID = 799 IF @EventID between 9 and 11 --- teleport begin DELETE FROM SRO_VT_SHARD.DBO._CharQuest where CharID = @CharID1 and QuestID = 799 delete from SRO_VT_SHARD.dbo._CharCollectionBook where CharID = @CharID1 end

I don't remember what's the questID for d11, probably this one.

Shard procedure:
CREATE PROCEDURE [dbo].[_ForgottenWorldReset]
@CharID INT
AS

BEGIN

DELETE FROM _CharQuest WHERE QuestID = 799 AND CharID = @CharID
DELETE FROM _CharCollectionBook WHERE ThemeID = 4 AND CharID = @CharID

END

AddLogItem:
IF ((@Operation = 41 ) AND (@ItemRefID = 42174))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID
END

Also I assume you know to create a scroll.

Quote:

Originally Posted by TheWickedNite I don't remember what's the questID for d11, probably this one. Shard procedure: CREATE PROCEDURE [dbo].[_ForgottenWorldReset] @CharID INT AS BEGIN DELETE FROM _CharQuest WHERE QuestID = 799 AND CharID = @CharID DELETE FROM _CharCollectionBook WHERE ThemeID = 4 AND CharID = @CharID END AddLogItem: IF ((@Operation = 41 ) AND (@ItemRefID = 42174)) BEGIN exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID END Also I assume you know to create a scroll.

Thanks for trying to help. i gonna try this scroll. Ty again

Edit: Worked perfectly. Thanks [Only registered and activated users can see links. Click Here To Register...]