So nachdem ich mich dumm und dämmlich ärgerte wegen der Nachwirkung habe ich nach LANGEM testen eine Lösung gefunden wie man sie per Quest enfernen kann !!


Jede Quest hat ein Complete und ein Start Script.

-Complete oder END Script ist das was geschiet wenn man die Quest beendet(abgibt)

-Start Script ist das was passiert wenn man annimmt.


BEISPIEL aus Trinity,Ribon und Mangos:


DELETE FROM `quest_start_scripts` WHERE `id`=87015;
INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(87015, 1, 14, 15007, 0, '0', 0, 0, 0, 0);



rot= ID des Script's

grün= Command das passiert wenn quest angenommen oder abgegeben wird.

blau=Spell der entfernt wird (nicht verlernt) mit dem command 14


So nun haben wir es eigtl schon nun müsst ihr noch wenn ihr zb. Quice benutzt, bei Quest Part 2--->
Ganz unten Start und Complete Script euere ID des Script's eingeben.



Hier noch ein vollständiger Quest für MANGOS,trinity und Ribon:

ACHTUNG ihr müsst noch den NPC der diese Quest vergibt ausbessern!!!(blau makiert) 990001 steht für den NPC.



DELETE FROM `creature_questrelation` WHERE `quest` = 87015;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 87015;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 87015;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (990001, 87015);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 990001;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 87015;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 87015;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (990001, 87015);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=990001;
DELETE FROM `quest_start_scripts` WHERE `id`=87015;
INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(87015, 1, 14, 15007, 0, '0', 0, 0, 0, 0);
DELETE FROM `quest_end_scripts` WHERE `id`=87015;
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES
(87015, 0, 14, 15007, 0, '0', 0, 0, 0, 0);
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `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`, `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`, `RewHonorableKills`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (87015, 2, 0, 0, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Wiederbelebungsnachwirkung Entfernen.', 'Wiederbelebungsnachwirkung Entfernen.', 'Wiederbelebungsnachwirkung Entfernen.', 'Wiederbelebungsnachwirkung Entfernen.', '', '', '', '', '', '', 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, 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, 87015, 87015);




ICH hoffe der Beitrag hilft euch






Hier für Trinity/Ribon sogar noch der NPC:


REPLACE INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (990001, 0, 0, 17045, 0, 17045, 0, 'Chacki Jan', 'Teleporter(Weltenbummler)', '', 59, 61, 6700, 24000, 5598, 5875, 3263, 35, 35, 3, 1.48, 0, 0, 353, 407, 0, 115, 1, 1400, 1900, 8, 0, 0, 0, 0, 0, 0, 0, 111, 164, 25, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 208, 0, 0, 'telefratz');