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