njn dela to skripty sql, tak sem mel za ze sem, inak neviem aka kompatibilita, bud overuj autora alebo testni, tak ci onak je to bomba, luxus, klikas a otvara to samo stranky alkazam totbot ...
ja som skusil teraz zo vcerajsou mangos zmenou quest_template, (mazali sa 2 polia a pribudol 1 `SuggestedPlayers`) a div sa svete program isiel a vygenerovany skript obsahoval nove pole, hoci verzia je stara as 14 dni, tj. univerzalne to bude asi daku dobu pokial sa nezmeni cosi radikalne
a takto to zhruba generuje:
DELETE FROM `creature_questrelation` WHERE (`quest`=55);
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (311, 55);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE (`entry`=311);
DELETE FROM `creature_involvedrelation` WHERE (`quest`=55);
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (311, 55);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE (`entry`=311);
DELETE FROM `quest_template` WHERE (`entry`=55);
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredRepFaction`, `RequiredRepValue`, `SuggestedPlayers`, `LimitTime`, `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`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `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`, `RewXP`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `CompleteScript`, `Repeatable`) VALUES (55, 24, 32, 0, 0, 1, 0, 0, 0, 9, 325, 0, 0, 0, 7297, 1, 0, 'Morbent Fel', 'Morbent Fel hides in his lair. the house perched atop the hill to the east overlooking the Raven Hill cemetery. His time in this land is drawing to an end...$B$BUse Morbent\'s Bane against him. It will render his protective magics powerless.$B$BSlay him. Slay him. and save us from his wickedness. Be the instrument of my revenge, and a hero of Duskwood!', 'Use Morbent\'s Bane on Morbent Fel. kill Morbent Fel. then return Morbent\'s Bane to Sven at his camp.', 'Morbent Fel has been defeated. The dark riders are still at large. but a small piece of that which I had hoped beyond hope has come to pass.$b$bYou have done the impossible. and your deeds will forever live in the legends of Duskwood.$b$bGo, $N. And perhaps, one day, fate may bring you back to me...', 'Is Morbent Fel defeated?!', '', '', '', '', '', 7297, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1200, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 2954, 2953, 1282, 0, 0, 0, 1, 1, 1, 0, 0, 0, 7344, 0, 0, 0, 1, 0, 0, 0, 54, 72, 0, 0, 0, 125, 500, 0, 0, 0, 0, 3850, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);