A question about Shipewreck quest ! (Egy weapon)

[Hamza FiGo]

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 ?

[Crue*]

you can edit it from quest script

[Aurora Online]

add this to AddLogItem at sro_vt_shardlog

 Spoiler

IF (@Operation = 41)
begin
IF (@ItemRefID =SCROLL ID from refobjcommon)
BEGIN
DELETE FROM SRO_VT_SHARD.DBO._CharQuest where CharID = @CharID and QuestID = 799
delete from SRO_VT_SHARD.dbo._CharCollectionBook where CharID = @CharID
END
END

press thanks if i helped

[Hamza FiGo]

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 ?

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

[Crue*]

server files

 Spoiler

Script\VIETNAM

but you've to decompile it

[WickedNite.]

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 ?

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

[Aurora Online]

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

 Spoiler

Declare @CharID1 = (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

press thanks if i helped

[Hamza FiGo]

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.

 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

[WickedNite.]

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.

[Hamza FiGo]

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