Mini quest by Clant

[Clant 1]

Jmeno questu: Zabijte Generala Marcuse Jonathana

Zadava: Overlord Runthak

Odmena: 10 Badge of Justice a 50 goldu.

 

 

Naberete quest.

 

Zabijete generala Marcuse Jonathana.

 

Lootnete quest item.

 

A supem pro odmenu.

 

 

 

soubor, ktery nahrajete do mangos databaze

 

Chvalu, kritiku, rady cokoliv beru

[axxxa 78]

Chtělo by to ještě alianční verzi

[Clant 1]

Ano, Alianční verzy udelam az si rano, teda dopoledne....jinak na to take myslim

 

Takovy mini for fun questik

[Zachy 11]

Hehe, zajímavý quest.

btw, buď to neumím číst nebo tam máš chybu v textu - ,,Zabijte prosim Vas genrala ...'' Místo GENERALA tam máš GENRALA .

[Clant 1]

ano moje chyby, opravim to

[Radek402 1]

Ano, ta alianci verze by se hodila, ale ta hordacka stoji zato. Jeste pockam na tu alickou a hodim to tam.

[Pra3toron 0]

Krasny q clant. GW

[Clant 1]

menší úprava.

UPDATE quest_template SET RewItemCount1='2' WHERE entry='20000';

Místo 10 Badge of Jusitce, 2 stačí, 10 jich dám až budu mít kompletní sérii nějakou...

[.eLhomer0. 12]

Hezky, ale na poprvi mě Q item nepadl

[Radek402 1]

Hezky, ale na poprvi mě Q item nepadl

 

zvys si drop item, padne ti pak toho vic

[Clant 1]

Hezky, ale na poprvi mě Q item nepadl

to je divny, je to quest item, a myslim ze by mel mit velkou sanci....nevim, mozna se pletu

[Radek402 1]

to je divny, je to quest item, a myslim ze by mel mit velkou sanci....nevim, mozna se pletu

 

No mně se zobrazil pokaždé. Byl jsem tam asi 3x.

[Sareth 0]

Posílám alianční verzi na Quest:

 

Jmeno questu: Smrt Overlorda Runthaka!

Zadava: General Marcus Jonathan

Odmena: 10 Badge of Justice a 50 goldu.

 

UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 20001;

INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (466, 20001);

UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 466;

INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (466, 20001);

UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=466;

REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `ClassOrSkill`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (20001, 12, 0, 65, 65, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 2, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Smrt Overlorda Runthaka!', 'Zabijte Overlorda Runthaka, odmena je zajistena pro Vas az ukol splnite.$B$BNa dukaz jeho smrti mi prineste jeho shoulders', 'Prineste mi shoulders Overlorda Runthaka', 'Oh, skvele, dobra prace obcane. Jsou to vzacne shoulders$b$bTady to mas!', 'Porad dnem i noci na to cekam, $N. Mas uz konecne ty jeho shoulders?', '', '', '', '', '', 50002, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29434, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);

 

btw Netestoval jsem to, takže jestli jsou nějaké chyby tak pište.

[bobby 24]

Posílám alianční verzi na Quest:

 

Jmeno questu: Smrt Overlorda Runthaka!

Zadava: General Marcus Jonathan

Odmena: 10 Badge of Justice a 50 goldu.

btw Netestoval jsem to, takže jestli jsou nějaké chyby tak pište.

Hehe, mám taky něco takovýho akorát helmu z ruthaka

[Method-man 1]

ty clante, je to zajimavy napad ... ale 10 badge je prilis moc... zvlaste kdyz je to pro 70ky a ve SW jsou 60ky

 

co takhle dat za to tak 1-2 badge ...

 

u nas na serveru existuej podobny Q, oboufrakcni ... mate zabit 65 guardu, vzit jejich hlavy a jako odmena je tam honor (+700) a moznost vyberu 10 pointu - WSG, AV, AB, EOS ... ovsem v nasem pripade je to daleko tezsi a pointy maji nizsi cenu

[bLuma 225]

ty clante, je to zajimavy napad ... ale 10 badge je prilis moc... zvlaste kdyz je to pro 70ky a ve SW jsou 60ky

 

umíš číst ?

menší úprava.

KÓD

UPDATE quest_template SET RewItemCount1='2' WHERE entry='20000';

 

Místo 10 Badge of Jusitce, 2 stačí, 10 jich dám až budu mít kompletní sérii nějakou...

[van 1]

no nvm nejak mi to hadze eror ked to davam do databaty

[Snake Plisken 2]

Clante musím tě jen pochválit. Asi si najdu čas a konečně si prostuduju tu DB a naučám se taky dělat Questy

Edited June 22, 2008 by Snake Plisken

[XtremeR 1]

S Quicem sem udělal Q na 1. pokus. Je to vážně lehký.

[Meelkor 0]

U toho aliancskeho q mi to pri davani do DB napise (viz. priloha)

A u hordskeho kdyz ho zabiju a vemu ten Qitem tak ho v inv vidim jako otaznik...

Nevis co s tim? diky

[sabath 110]

DELETE FROM `creature_questrelation` WHERE `quest` = 20004;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 20004;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 20004;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (24882, 20004);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 24882;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 20004;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 20004;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (24882, 20004);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=24882;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (20004, 400, 68, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5799, 1, 0, 'Kill the Kelthuzad ', 'Cafik...$BHele Kelthuzad mi neco vzal ale jáho nedám je slinější prosím tě můžeš mi to donést?$BDones mi z něj jeden Quest Item padne ti možna...$BITEM JE ', 'Zabij Kelthuzada vem item a pojď zpět', 'Ano.Výborně...Kelthuzad už mi to brát nebude$BVyber si odměnu...', 'OMG Pohni sebou di ho zabit dpc', '', '', '', '', '', 22733, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 34362, 34166, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);
DELETE FROM `areatrigger_involvedrelation` WHERE `quest` = 20004;
INSERT INTO `areatrigger_involvedrelation` (`id`, `quest`) VALUES (0, 20004);

Cuzz hele udělal jsem Quest mohl by mi někdo upravit ten sql kod aby mi to slo do db??

Edited September 9, 2008 by sabath

[van 1]

no hordácky Q mi ide ale ten co má davat marcus jonathan ten nejak nechce ísť

[Falcon 0]

Pls nejde mi nahrat ani ten hordackej ani ten alickej u kazdyho mi hodi Sqllog error pls poradte nikdo co stim ten q sem mi zrovna docela libi :(:(:(:(

[STONERSVK 899]

Pls nejde mi nahrat ani ten hordackej ani ten alickej u kazdyho mi hodi Sqllog error pls poradte nikdo co stim ten q sem mi zrovna docela libi :(:(:(:(

 

a aky error ti to hadze? takto to moze byt hoci co

[Sareth 0]

Tady posílám už updatnutý na nejnovější revizi.

 

Hordacka verze:

UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 20000;

INSERT INTO `creature_questrelation` VALUES (14392, 20000);

UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 14392;

INSERT INTO `creature_involvedrelation` VALUES (14392, 20000);

UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=14392;

INSERT INTO `quest_template` VALUES (20000, 0, 0, 70, 70, 0, 690, 0, '0', '0', 0, 0, 0, 0, 2, 0, 8, 0, '0', 0, 0, 0, 0, 0, 0, 0, 'Kill general Marcus Jonathan!', ' For horde! Kill General Jonathan Marcus. Remuneration will be responsible Your offence.', 'On the evidence of his death prines me his helmet.', 'Bring me a helmet generala Marcuse Jonathan', 'No finally.', 'Here it yet.', 'Still on you wait ...', 'Do you there helmet?!', '', '', '', '', '', 50000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '29434', '0', '0', '0', '10', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '0', '500000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0');

INSERT INTO `creature_loot_template` VALUES (466, 50000, -66, 0, 1, 1, 0, 0, 0);

INSERT INTO `item_template` VALUES (50000, 12, 0, 0, 'Helma Marcuse Jonathana', 48057, 6, 0, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 4, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0);

 

Alicka verze:

UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 20001;

INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (466, 20001);

UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 466;

INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (466, 20001);

UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=466;

INSERT INTO `quest_template` VALUES (20001, 0, 0, 70, 70, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 2, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Kill Overlord Runthak!!!', 'Honour and glory of the Alliance! Kill Overlord Runthak. I have the impression that against me something stamped.', 'On the evidence of his death bring me his gloves.', 'Bring me gloves Overlord Runthak.', 'Finally ...', 'Here to you.', 'Still wait to you...', 'You are no longer those gloves?', '', '', 0, 0, 0, 50001, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29434, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500001, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES (14392, 50001, -66, 0, 1, 1, 0, 0, 0);

INSERT INTO `item_template` VALUES (50001, 12, 0, 0, 'Hands of Overlord Runthak', 48032, 6, 0, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, -1, 4, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0);