Public feed #891714

Untitled

public text v1 · immutable
Raw Edit
·published 2008-02-04 21:20 UTC
rendered paste body
UPDATE `quests` SET `RequiredQuest1`='0' WHERE (`entry`='7645');  

INSERT INTO `creature_spawns` 

(`id`,`entry`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`displayid`,`faction`,`flags`) VALUES 

(NULL,'14566','429','62','476','-23.293','3.21','14585','1080','2');

INSERT INTO `creatureloot` (`entryid`,`itemid`,`percentchance`,`heroicpercentchance`,`mincount`,`maxcount`) VALUES 

('14516','18799','101','0','1','1');

INSERT INTO `creature_quest_starter` (`id`,`quest`) VALUES ('17717','9721');

UPDATE `quests` SET 

`entry`='9721',`ZoneId`='0',`sort`='0',`flags`='136',`MinLevel`='0',`questlevel`='0',`Type`='0',`RequiredRaces`='512

',`RequiredClass`='0',`RequiredTradeskill`='0',`RequiredRepFaction`='0',`RequiredRepValue`='0',`LimitTime`='0',`Spec

ialFlags`='0',`PrevQuestId`='0',`NextQuestId`='9722',`srcItem`='0',`SrcItemCount`='0',`Title`='A Summons from Lady 

Liadrin',`Details`='Your dedication to our order and advancement through the ranks has not gone unnoticed. In fact, 

Lady Liadrin, leader of the Blood Knights, has asked to speak with you.$B$BThis is a rare honor, $N. Normally, Lady 

Liadrin leaves the management of the order\'s rank-and-file to me, but she has taken a personal interest in you. Do 

not tarry, $N.',`Objectives`='Speak with Lady Liadrin in Silvermoon 

City.',`ReqItemId1`='0',`ReqItemId2`='0',`ReqItemId3`='0',`ReqItemId4`='0',`ReqItemCount2`='0',`ReqItemCount3`='0',`

ReqItemCount4`='0',`ReqKillMobOrGOId1`='0',`ReqKillMobOrGOId2`='0',`ReqKillMobOrGOId3`='0',`ReqKillMobOrGOId4`='0',`

ReqKillMobOrGOCount1`='0',`ReqKillMobOrGOCount2`='0',`ReqKillMobOrGOCount3`='0',`ReqKillMobOrGOCount4`='0',`ReqCastS

pellId1`='0',`ReqCastSpellId2`='0',`ReqCastSpellId3`='0',`ReqCastSpellId4`='0',`RewChoiceItemId1`='0',`RewChoiceItem

Id2`='0',`RewChoiceItemId3`='0',`RewChoiceItemId4`='0',`RewChoiceItemId5`='0',`RewChoiceItemId6`='0',`RewChoiceItemC

ount1`='0',`RewChoiceItemCount2`='0',`RewChoiceItemCount3`='0',`RewChoiceItemCount4`='0',`RewChoiceItemCount5`='0',`

RewChoiceItemCount6`='0',`RewItemId1`='0',`RewItemId2`='0',`RewItemId3`='0',`RewItemId4`='0',`RewItemCount1`='0',`Re

wItemCount2`='0',`RewItemCount3`='0',`RewItemCount4`='0',`RewRepFaction1`='0',`RewRepFaction2`='0',`RewRepValue1`='0

',`RewRepValue2`='0',`RewRepLimit`='0',`RewMoney`='0',`RewXP`='0',`RewSpell`='0',`CastSpell`='0',`PointMapId`='0',`P

ointX`='0',`PointY`='0',`PointOpt`='0',`RequiredMoney`='0',`ExploreTrigger1`='0',`ExploreTrigger2`='0',`ExploreTrigg

er3`='0',`ExploreTrigger4`='0',`RequiredQuest1`='0',`RequiredQuest2`='0',`RequiredQuest3`='0',`RequiredQuest4`='0',`

ReceiveItemId1`='0',`ReceiveItemId2`='0',`ReceiveItemId3`='0',`ReceiveItemId4`='0',`ReceiveItemCount1`='0',`ReceiveI

temCount2`='0',`ReceiveItemCount3`='0',`ReceiveItemCount4`='0',`IsRepeatable`='0' WHERE (`entry`='9721'); 

INSERT INTO `creature_quest_finisher` (`id`,`quest`) VALUES ('17076','9721');

INSERT INTO `creature_quest_finisher` (`id`,`quest`) VALUES ('17076','9722');

INSERT INTO `creature_quest_starter` (`id`,`quest`) VALUES ('17076','9722');

UPDATE `quests` SET 

`entry`='9722',`ZoneId`='0',`sort`='0',`flags`='136',`MinLevel`='0',`questlevel`='0',`Type`='0',`RequiredRaces`='512

',`RequiredClass`='0',`RequiredTradeskill`='0',`RequiredRepFaction`='0',`RequiredRepValue`='0',`LimitTime`='0',`Spec

ialFlags`='0',`PrevQuestId`='0',`NextQuestId`='9723',`srcItem`='0',`SrcItemCount`='0',`Title`='The Master\'s 

Path',`Details`='Within the ranks of my order, there exists an inner circle of elite knights. Members of the circle 

represent the most dedicated, skilled, and trustworthy of all Blood Knights and are handpicked by the leadership. 

Most simply know the masters by their thalassian charger mounts.$B$BEach candidate for membership must have a 

sponsor within the circle and must demonstrate their dedication to the order\'s central tenets.$B$BI have chosen to 

sponsor you for standing as a Blood Knight master, if this is your wish.',`Objectives`='Speak with Lady Liadrin 

again to accept her offer of 

sponsorship.',`ReqItemId1`='0',`ReqItemId2`='0',`ReqItemId3`='0',`ReqItemId4`='0',`ReqItemCount1`='0',`ReqItemCount2

`='0',`ReqItemCount3`='0',`ReqItemCount4`='0',`ReqKillMobOrGOId1`='0',`ReqKillMobOrGOId2`='0',`ReqKillMobOrGOId3`='0

',`ReqKillMobOrGOId4`='0',`ReqKillMobOrGOCount1`='0',`ReqKillMobOrGOCount2`='0',`ReqKillMobOrGOCount3`='0',`ReqKillM

obOrGOCount4`='0',`ReqCastSpellId1`='0',`ReqCastSpellId2`='0',`ReqCastSpellId3`='0',`ReqCastSpellId4`='0',`RewChoice

ItemId1`='0',`RewChoiceItemId2`='0',`RewChoiceItemId3`='0',`RewChoiceItemId4`='0',`RewChoiceItemId5`='0',`RewChoiceI

temId6`='0',`RewChoiceItemCount1`='0',`RewChoiceItemCount2`='0',`RewChoiceItemCount3`='0',`RewChoiceItemCount4`='0',

`RewChoiceItemCount5`='0',`RewChoiceItemCount6`='0',`RewItemId1`='0',`RewItemId2`='0',`RewItemId3`='0',`RewItemId4`=

'0',`RewItemCount1`='0',`RewItemCount2`='0',`RewItemCount3`='0',`RewItemCount4`='0',`RewRepFaction1`='10',`RewRepFac

tion2`='0',`RewRepValue1`='10',`RewRepValue2`='0',`RewRepLimit`='0',`RewMoney`='0',`RewXP`='0',`RewSpell`='0',`CastS

pell`='0',`PointMapId`='0',`PointX`='0',`PointY`='0',`PointOpt`='0',`RequiredMoney`='0',`ExploreTrigger1`='0',`Explo

reTrigger2`='0',`ExploreTrigger3`='0',`ExploreTrigger4`='0',`RequiredQuest1`='0',`RequiredQuest2`='0',`RequiredQuest

3`='0',`RequiredQuest4`='0',`ReceiveItemId1`='0',`ReceiveItemId2`='0',`ReceiveItemId3`='0',`ReceiveItemId4`='0',`Rec

eiveItemCount1`='0',`ReceiveItemCount2`='0',`ReceiveItemCount3`='0',`ReceiveItemCount4`='0',`IsRepeatable`='0' WHERE 

(`entry`='9722');  


UPDATE `creature_quest_finisher` SET `id`='14347',`quest`='7786' WHERE (`id`='14347') AND (`quest`='7785');

UPDATE `quests` SET `flags`='0',`Type`='0',`SpecialFlags`='0' WHERE (`entry`='7786');  

INSERT INTO `gameobject_quest_starter` (`id`,`quest`) VALUES ('19018','7787');

UPDATE `quests` SET `srcItem`='0' WHERE (`entry`='7604');  

INSERT INTO `gameobject_quest_starter` (`id`,`quest`) VALUES ('18628','7604');


UPDATE `quests` SET 

`entry`='9723',`ZoneId`='0',`sort`='0',`flags`='128',`MinLevel`='0',`questlevel`='0',`Type`='81',`RequiredRaces`='51

2',`RequiredClass`='0',`RequiredTradeskill`='0',`RequiredRepFaction`='0',`RequiredRepValue`='0',`LimitTime`='0',`Spe

cialFlags`='0',`PrevQuestId`='0',`NextQuestId`='9725',`srcItem`='0',`SrcItemCount`='0',`Title`='A Gesture of 

Commitment',`Details`='A Blood Knight\'s loyalty does not stop at the end of $g his:her; blade, $N. The order asks 

more of its members than mere drilling and combat. A true knight contributes to all of the order\'s activities, even 

the ones that may not seem glorious on the surface.$B$BThis first task is neither combat intensive, nor glorious, 

but without such contributions, the order would fall apart. I will give you a list of items Magister Astalor 

Bloodsworn\'s men require to keep us supplied with Light energy for our magics.',`Objectives`='Bring 40 Runecloth, 6 

Arcanite Bars, 10 Sungrass, 5 Dark Runes, and 150 Gold to Lady Liadrin in Silvermoon 

City.',`ReqItemId1`='14047',`ReqItemId2`='12360',`ReqItemId3`='8838',`ReqItemId4`='20520',`ReqItemCount1`='40',`ReqI

temCount2`='6',`ReqItemCount3`='10',`ReqItemCount4`='5',`ReqKillMobOrGOId1`='0',`ReqKillMobOrGOId2`='0',`ReqKillMobO

rGOId3`='0',`ReqKillMobOrGOId4`='0',`ReqKillMobOrGOCount1`='9',`ReqKillMobOrGOCount2`='0',`ReqKillMobOrGOCount3`='0'

,`ReqKillMobOrGOCount4`='0',`ReqCastSpellId1`='0',`ReqCastSpellId2`='0',`ReqCastSpellId3`='0',`ReqCastSpellId4`='0',

`RewChoiceItemId1`='0',`RewChoiceItemId2`='0',`RewChoiceItemId3`='0',`RewChoiceItemId4`='0',`RewChoiceItemId5`='0',`

RewChoiceItemId6`='0',`RewChoiceItemCount1`='0',`RewChoiceItemCount2`='0',`RewChoiceItemCount3`='0',`RewChoiceItemCo

unt4`='0',`RewChoiceItemCount5`='0',`RewChoiceItemCount6`='0',`RewItemId1`='0',`RewItemId2`='0',`RewItemId3`='0',`Re

wItemId4`='0',`RewItemCount1`='0',`RewItemCount2`='0',`RewItemCount3`='0',`RewItemCount4`='0',`RewRepFaction1`='0',`

RewRepFaction2`='0',`RewRepValue1`='0',`RewRepValue2`='0',`RewRepLimit`='0',`RewMoney`='0',`RewXP`='4750',`RewSpell`

='0',`CastSpell`='0',`PointMapId`='0',`PointX`='0',`PointY`='0',`PointOpt`='0',`RequiredMoney`='150',`ExploreTrigger

1`='0',`ExploreTrigger2`='0',`ExploreTrigger3`='0',`ExploreTrigger4`='0',`RequiredQuest1`='0',`RequiredQuest2`='0',`

RequiredQuest3`='0',`RequiredQuest4`='0',`ReceiveItemId1`='0',`ReceiveItemId2`='0',`ReceiveItemId3`='0',`ReceiveItem

Id4`='0',`ReceiveItemCount1`='0',`ReceiveItemCount2`='0',`ReceiveItemCount3`='0',`ReceiveItemCount4`='0',`IsRepeatab

le`='0' WHERE (`entry`='9723');  

UPDATE `quests` SET 

`entry`='9725',`ZoneId`='0',`sort`='0',`flags`='136',`MinLevel`='0',`questlevel`='0',`Type`='0',`RequiredRaces`='0',

`RequiredClass`='0',`RequiredTradeskill`='0',`RequiredRepFaction`='0',`RequiredRepValue`='0',`LimitTime`='0',`Specia

lFlags`='0',`PrevQuestId`='0',`NextQuestId`='9735',`srcItem`='0',`SrcItemCount`='0',`Title`='A Demonstration of 

Loyalty',`Details`='We Blood Knights are bound to defend Quel\'Thalas, $N. This is a central part of your training. 

Our enemies are fierce and unrelenting. Silvermoon and its people remain free by our efforts and the support of our 

allies.$B$BI have received some disturbing reports of a renewed Scourge presence to the southeast of our border with 

the Eastern Plaguelands. A company of Scourge siege engineers and their equipment appear to be staging for an attack 

on the Ghostlands. They must not be permitted to succeed.',`Objectives`='Lady Liadrin in Silvermoon City wants you 

to destroy 3 Scourge Meat Wagons and kill 15 Scourge Siege Engineers.',`ObjectiveText2`='Destroy Scourge Meat 

Wagons',`ReqItemId1`='0',`ReqItemId2`='0',`ReqItemId3`='0',`ReqItemId4`='0',`ReqItemCount1`='0',`ReqItemCount2`='0',

`ReqItemCount3`='0',`ReqItemCount4`='0',`ReqKillMobOrGOId1`='17878',`ReqKillMobOrGOId2`='0',`ReqKillMobOrGOId3`='0',

`ReqKillMobOrGOId4`='0',`ReqKillMobOrGOCount1`='15',`ReqKillMobOrGOCount2`='3',`ReqKillMobOrGOCount3`='0',`ReqKillMo

bOrGOCount4`='0',`ReqCastSpellId1`='0',`ReqCastSpellId2`='0',`ReqCastSpellId3`='0',`ReqCastSpellId4`='0',`RewChoiceI

temId1`='0',`RewChoiceItemId2`='0',`RewChoiceItemId3`='0',`RewChoiceItemId4`='0',`RewChoiceItemId5`='0',`RewChoiceIt

emId6`='0',`RewChoiceItemCount1`='0',`RewChoiceItemCount2`='0',`RewChoiceItemCount3`='0',`RewChoiceItemCount4`='0',`

RewChoiceItemCount5`='0',`RewChoiceItemCount6`='0',`RewItemId1`='0',`RewItemId2`='0',`RewItemId3`='0',`RewItemId4`='

0',`RewItemCount1`='0',`RewItemCount2`='0',`RewItemCount3`='0',`RewItemCount4`='0',`RewRepFaction1`='911',`RewRepFac

tion2`='0',`RewRepValue1`='250',`RewRepValue2`='0',`RewRepLimit`='0',`RewMoney`='0',`RewXP`='11900',`RewSpell`='0',`

CastSpell`='0',`PointMapId`='0',`PointX`='0',`PointY`='0',`PointOpt`='0',`RequiredMoney`='0',`ExploreTrigger1`='0',`

ExploreTrigger2`='0',`ExploreTrigger3`='0',`ExploreTrigger4`='0',`RequiredQuest1`='0',`RequiredQuest2`='0',`Required

Quest3`='0',`RequiredQuest4`='0',`ReceiveItemId1`='0',`ReceiveItemId2`='0',`ReceiveItemId3`='0',`ReceiveItemId4`='0'

,`ReceiveItemCount1`='0',`ReceiveItemCount2`='0',`ReceiveItemCount3`='0',`ReceiveItemCount4`='0',`IsRepeatable`='0' 

WHERE (`entry`='9725');  

UPDATE `quests` SET 

`entry`='9736',`ZoneId`='0',`sort`='0',`flags`='136',`MinLevel`='0',`questlevel`='0',`Type`='0',`RequiredRaces`='512

',`RequiredClass`='0',`RequiredTradeskill`='0',`RequiredRepFaction`='0',`RequiredRepValue`='0',`LimitTime`='0',`Spec

ialFlags`='0',`PrevQuestId`='0',`NextQuestId`='9737',`srcItem`='0',`SrcItemCount`='0',`Title`='True Masters of the 

Light',`Details`='Now that we have the water, we\'re going to need a number of reagents in precise quantities. Some 

of these substances are rare and expensive, $N, but I have located sources for two.$B$BYou should be able to 

purchase some arcane catalyst from Zalle, the reagent vendor in one of the shops on the plaza near the Dead Scar. 

Darlia, the poison merchant near the rogue trainers on Murder Row, stocks crepuscular powder.$B$BTo complete my 

mixture, I\'ll also need an azerothian diamond and a pristine black diamond.',`Objectives`='Lady Liadrin in 

Silvermoon City wants you to bring her 1 Arcane Catalyst, 1 Crepuscular Powder, 1 Azerothian Diamond, and 1 Pristine 

Black 

Diamond.',`ReqItemId1`='24286',`ReqItemId2`='24285',`ReqItemId3`='12800',`ReqItemId4`='18335',`ReqItemCount1`='1',`R

eqItemCount2`='1',`ReqItemCount3`='1',`ReqItemCount4`='1',`ReqKillMobOrGOId1`='0',`ReqKillMobOrGOId2`='0',`ReqKillMo

bOrGOId3`='0',`ReqKillMobOrGOId4`='0',`ReqKillMobOrGOCount1`='0',`ReqKillMobOrGOCount2`='0',`ReqKillMobOrGOCount3`='

0',`ReqKillMobOrGOCount4`='0',`ReqCastSpellId1`='0',`ReqCastSpellId2`='0',`ReqCastSpellId3`='0',`ReqCastSpellId4`='0

',`RewChoiceItemId1`='0',`RewChoiceItemId2`='0',`RewChoiceItemId3`='0',`RewChoiceItemId4`='0',`RewChoiceItemId5`='0'

,`RewChoiceItemId6`='0',`RewChoiceItemCount1`='0',`RewChoiceItemCount2`='0',`RewChoiceItemCount3`='0',`RewChoiceItem

Count4`='0',`RewChoiceItemCount5`='0',`RewChoiceItemCount6`='0',`RewItemId1`='0',`RewItemId2`='0',`RewItemId3`='0',`

RewItemId4`='0',`RewItemCount1`='0',`RewItemCount2`='0',`RewItemCount3`='0',`RewItemCount4`='0',`RewRepFaction1`='11

',`RewRepFaction2`='0',`RewRepValue1`='150',`RewRepValue2`='0',`RewRepLimit`='0',`RewMoney`='0',`RewXP`='4950',`RewS

pell`='0',`CastSpell`='0',`PointMapId`='0',`PointX`='0',`PointY`='0',`PointOpt`='0',`RequiredMoney`='0',`ExploreTrig

ger1`='0',`ExploreTrigger2`='0',`ExploreTrigger3`='0',`ExploreTrigger4`='0',`RequiredQuest1`='0',`RequiredQuest2`='0

',`RequiredQuest3`='0',`RequiredQuest4`='0',`ReceiveItemId1`='0',`ReceiveItemId2`='0',`ReceiveItemId3`='0',`ReceiveI

temId4`='0',`ReceiveItemCount1`='0',`ReceiveItemCount2`='0',`ReceiveItemCount3`='0',`ReceiveItemCount4`='0',`IsRepea

table`='0' WHERE (`entry`='9736');

UPDATE `quests` SET 

`entry`='9737',`ZoneId`='0',`sort`='0',`flags`='128',`MinLevel`='0',`questlevel`='0',`Type`='81',`RequiredRaces`='51

2',`RequiredClass`='2',`RequiredTradeskill`='0',`RequiredRepFaction`='0',`RequiredRepValue`='0',`LimitTime`='0',`Spe

cialFlags`='0',`PrevQuestId`='9736',`NextQuestId`='0',`srcItem`='0',`SrcItemCount`='0',`Title`='True Masters of the 

Light',`Details`='Ours is the true way of utilizing the Light, $N. To show others that would call themselves 

\'paladins\' the folly of their ways, I intend to send an unmistakable message.$B$BThe Alonsus Chapel, where the 

Order of the Silver Hand was founded, seems immune to the destruction of Stratholme. The chapel\'s eternal flame 

affords it the Light\'s protection, but when you use this mixture to extinguish the flame, that protection will be 

no more. It will burn, and our dominion over the Light will be proven to the world.',`Objectives`='Use the 

Extinguishing Mixture near the eternal flame in the Alonsus Chapel to remove the Light\'s protection. Be prepared to 

fight anyone who may attempt to defend the chapel.',`ObjectiveText1`='Remove Alonsus Chapel 

Protection',`ReqItemId1`='0',`ReqItemId2`='24287',`ReqItemId3`='0',`ReqItemId4`='0',`ReqItemCount1`='0',`ReqItemCoun

t2`='1',`ReqItemCount3`='0',`ReqItemCount4`='0',`ReqKillMobOrGOId1`='0',`ReqKillMobOrGOId2`='0',`ReqKillMobOrGOId3`=

'0',`ReqKillMobOrGOId4`='0',`ReqKillMobOrGOCount1`='0',`ReqKillMobOrGOCount2`='0',`ReqKillMobOrGOCount3`='0',`ReqKil

lMobOrGOCount4`='0',`ReqCastSpellId1`='0',`ReqCastSpellId2`='0',`ReqCastSpellId3`='0',`ReqCastSpellId4`='0',`RewChoi

ceItemId1`='0',`RewChoiceItemId2`='0',`RewChoiceItemId3`='0',`RewChoiceItemId4`='0',`RewChoiceItemId5`='0',`RewChoic

eItemId6`='0',`RewChoiceItemCount1`='0',`RewChoiceItemCount2`='0',`RewChoiceItemCount3`='0',`RewChoiceItemCount4`='0

',`RewChoiceItemCount5`='0',`RewChoiceItemCount6`='0',`RewItemId1`='25549',`RewItemId2`='0',`RewItemId3`='0',`RewIte

mId4`='0',`RewItemCount1`='1',`RewItemCount2`='0',`RewItemCount3`='0',`RewItemCount4`='0',`RewRepFaction1`='911',`Re

wRepFaction2`='0',`RewRepValue1`='250',`RewRepValue2`='0',`RewRepLimit`='0',`RewMoney`='0',`RewXP`='8300',`RewSpell`

='34767',`CastSpell`='34766',`PointMapId`='0',`PointX`='0',`PointY`='0',`PointOpt`='0',`RequiredMoney`='0',`ExploreT

rigger1`='0',`ExploreTrigger2`='0',`ExploreTrigger3`='0',`ExploreTrigger4`='0',`RequiredQuest1`='0',`RequiredQuest2`

='0',`RequiredQuest3`='0',`RequiredQuest4`='0',`ReceiveItemId1`='0',`ReceiveItemId2`='0',`ReceiveItemId3`='0',`Recei

veItemId4`='0',`ReceiveItemCount1`='0',`ReceiveItemCount2`='0',`ReceiveItemCount3`='0',`ReceiveItemCount4`='0',`IsRe

peatable`='0' WHERE (`entry`='9737')