# Neltharakus Geschichte -> by DarkMan# New Quest Script + Changes on Quest# Updating object from table 'quest_template'# ID: 10814#UPDATE quest_template SET RequiredRaces = '1791' WHERE entry = '10814';DELETE FROM gameobject_questrelation WHERE gameobject_questrelation.quest LIKE '10814' ;DELETE FROM gameobject_involvedrelation WHERE gameobject_involvedrelation.quest LIKE '10814' ;DELETE FROM creature_questrelation WHERE creature_questrelation.quest LIKE '10814' ;INSERT INTO creature_questrelation ( creature_questrelation.quest, creature_questrelation.id ) VALUES ( '10814', '21657' );DELETE FROM creature_involvedrelation WHERE creature_involvedrelation.quest LIKE '10814' ;INSERT INTO creature_involvedrelation ( creature_involvedrelation.quest, creature_involvedrelation.id ) VALUES ( '10814', '21657' );UPDATE quest_template SET SpecialFlags = '6' WHERE entry = '10814';UPDATE `creature_template` SET `ScriptName`='neltharaku' WHERE (`entry`='21657');DELETE FROM areatrigger_involvedrelation WHERE areatrigger_involvedrelation.quest LIKE '10814' ;# Gameobject Dung -> by DarkMan# Changed Flag, so its lootable# Updating object from table 'gameobject_template'# ID: 182128#UPDATE gameobject_template SET flags = '0' WHERE entry = '182128';# Item Bummbombe -> by DarkMan# Set to 0 because its needed to complete the quest! 10 charges wasnt right!# Updating object from table 'gameobject_template'# ID: 29429#UPDATE `item_template` SET `spellcharges_1`='0' WHERE (`entry`='29429');# Die Kunst des Rüstungsschmieds -> by DarkMan# Falscher Spell @ Waffenschmied statt Rüstungsschmied -> kill flag removed# Updating object from table 'quest_template'# ID: 5283#UPDATE quest_template SET SpecialFlags = '1', ReqSpellCast1 = '0' WHERE entry = '5283';DELETE FROM gameobject_questrelation WHERE gameobject_questrelation.quest LIKE '5283' ;DELETE FROM gameobject_involvedrelation WHERE gameobject_involvedrelation.quest LIKE '5283' ;DELETE FROM creature_questrelation WHERE creature_questrelation.quest LIKE '5283' ;INSERT INTO creature_questrelation ( creature_questrelation.quest, creature_questrelation.id ) VALUES ( '5283', '5164' );DELETE FROM creature_involvedrelation WHERE creature_involvedrelation.quest LIKE '5283' ;INSERT INTO creature_involvedrelation ( creature_involvedrelation.quest, creature_involvedrelation.id ) VALUES ( '5283', '5164' );DELETE FROM areatrigger_involvedrelation WHERE areatrigger_involvedrelation.quest LIKE '5283' ;# Die Kunst des Rüstungsschmieds -> by DarkMan# Falscher Spell @ Waffenschmied statt Rüstungsschmied -> kill flag removed# Updating object from table 'quest_template'# ID: 5301#UPDATE quest_template SET SpecialFlags = '1', ReqSpellCast1 = '0', RewSpell = '9790' WHERE entry = '5301';DELETE FROM gameobject_questrelation WHERE gameobject_questrelation.quest LIKE '5301' ;DELETE FROM gameobject_involvedrelation WHERE gameobject_involvedrelation.quest LIKE '5301' ;DELETE FROM creature_questrelation WHERE creature_questrelation.quest LIKE '5301' ;INSERT INTO creature_questrelation ( creature_questrelation.quest, creature_questrelation.id ) VALUES ( '5301', '11177' );DELETE FROM creature_involvedrelation WHERE creature_involvedrelation.quest LIKE '5301' ;INSERT INTO creature_involvedrelation ( creature_involvedrelation.quest, creature_involvedrelation.id ) VALUES ( '5301', '11177' );DELETE FROM areatrigger_involvedrelation WHERE areatrigger_involvedrelation.quest LIKE '5301' ;# Der Weg des Waffenschmieds -> By DarkMan# Kill flag removed# Updating object from table 'quest_template'# ID: 5284#UPDATE quest_template SET SpecialFlags = '1' WHERE entry = '5284';DELETE FROM gameobject_questrelation WHERE gameobject_questrelation.quest LIKE '5284' ;DELETE FROM gameobject_involvedrelation WHERE gameobject_involvedrelation.quest LIKE '5284' ;DELETE FROM creature_questrelation WHERE creature_questrelation.quest LIKE '5284' ;INSERT INTO creature_questrelation ( creature_questrelation.quest, creature_questrelation.id ) VALUES ( '5284', '11146' );DELETE FROM creature_involvedrelation WHERE creature_involvedrelation.quest LIKE '5284' ;INSERT INTO creature_involvedrelation ( creature_involvedrelation.quest, creature_involvedrelation.id ) VALUES ( '5284', '11146' );DELETE FROM areatrigger_involvedrelation WHERE areatrigger_involvedrelation.quest LIKE '5284' ;# Der Weg des Waffenschmieds -> By DarkMan# Kill flag + Spell casting requirement removed!# Updating object from table 'quest_template'# ID: 5302#UPDATE quest_template SET SpecialFlags = '1', ReqSpellCast1 = '0' WHERE entry = '5302';DELETE FROM gameobject_questrelation WHERE gameobject_questrelation.quest LIKE '5302' ;DELETE FROM gameobject_involvedrelation WHERE gameobject_involvedrelation.quest LIKE '5302' ;DELETE FROM creature_questrelation WHERE creature_questrelation.quest LIKE '5302' ;INSERT INTO creature_questrelation ( creature_questrelation.quest, creature_questrelation.id ) VALUES ( '5302', '11178' );DELETE FROM creature_involvedrelation WHERE creature_involvedrelation.quest LIKE '5302' ;INSERT INTO creature_involvedrelation ( creature_involvedrelation.quest, creature_involvedrelation.id ) VALUES ( '5302', '11178' );DELETE FROM areatrigger_involvedrelation WHERE areatrigger_involvedrelation.quest LIKE '5302' ;# New Quest Script Changes...UPDATE creature_template SET ScriptName = 'dashel_stonefist' WHERE entry = '4961';UPDATE creature_template SET ScriptName = 'blood_knight_stillblade' WHERE entry = '17768';UPDATE creature_template SET ScriptName = 'shattered_rumbler' WHERE entry = '17157';# by DarkMan## Updating object from table 'quest_template'# ID: 9784#UPDATE quest_template SET RequiredMaxRepValue = '9000' WHERE entry = '9784';DELETE FROM gameobject_questrelation WHERE gameobject_questrelation.quest LIKE '9784' ;DELETE FROM gameobject_involvedrelation WHERE gameobject_involvedrelation.quest LIKE '9784' ;DELETE FROM creature_questrelation WHERE creature_questrelation.quest LIKE '9784' ;INSERT INTO creature_questrelation ( creature_questrelation.quest, creature_questrelation.id ) VALUES ( '9784', '17909' );DELETE FROM creature_involvedrelation WHERE creature_involvedrelation.quest LIKE '9784' ;INSERT INTO creature_involvedrelation ( creature_involvedrelation.quest, creature_involvedrelation.id ) VALUES ( '9784', '17909' );DELETE FROM areatrigger_involvedrelation WHERE areatrigger_involvedrelation.quest LIKE '9784' ;