# 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' ;