ruxana
22-05-2016, 12:59 PM
انا Procedure بتاع الاسكرول
Reset FGW Quest/Remove Book
Job Penalty Remover Thief/Hunter/Trader
مش شغالين يا ريت حد يبعتلي البرسودر الصح
IF @Operation = 41 and (@ItemRefID = 41891)
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2' AND Category=2 AND CharID = @CharID
END
IF @Operation = 16 and (@ItemRefID = 41890)
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
Reset FGW Quest/Remove Book
Job Penalty Remover Thief/Hunter/Trader
مش شغالين يا ريت حد يبعتلي البرسودر الصح
IF @Operation = 41 and (@ItemRefID = 41891)
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2' AND Category=2 AND CharID = @CharID
END
IF @Operation = 16 and (@ItemRefID = 41890)
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