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
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
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.
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
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
here is question about 1 weapon 02/05/2013 - Dekaron Private Server - 3 Replies i have 250 lvl segu weapon, and i try wear it but it doesn't work like: character doesn't walk and can't even use a skill
i try with lower lvl weapons on segu and it works fine , skills and walking normally what is problem on it?
Howling Fjord quest- Level up weapon skills 01/30/2009 - WoW Exploits, Hacks, Tools & Macros - 0 Replies Among your first set of quests will be one given by Pontius, near the cannons, and is named 'Let Them Eat Crow.' Let Them Eat Crow - Quest - World of Warcraft If you have already done this quest, you're out of luck.
http://img84.imageshack.us/img84/5373/69753109nx0. th.jpg
He will give you a cage that contains a hungry plaguehound and wants you to kill crows in Bleeding Vale, right outside the town. You can either do the quest and not turn it in or just get the quest and summon the...
i have a question to a lvl 130 weapon 11/16/2008 - Dekaron Private Server - 5 Replies i wanted to know what for a socket item i have to put in my lvl 130 weapen for summoner the weapon have 3 socketst are free
Boba's Clone Relic Weapon Quest Dupe 01/05/2006 - General Gaming Discussion - 6 Replies It is possible to get Boba Fett?s 3?d clone relic reward over and over again. I believe it?s a carbine.
In the quest Boba sends you to Endor to start your quest. Once you complete part 3. Start part 4 then just go back to the contact on endor from the third quest and do the quest over again.
A question about Shipewreck quest ! (Egy weapon)
