-- add lootid and quest item loot. Fixes issue 1778

UPDATE creature_template SET lootid = 30921 WHERE entry = 30921;
DELETE FROM creature_loot_template WHERE entry = 30921;
INSERT INTO creature_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2)
VALUES
(30921, 43291, -51, 1, 0, 1, 1, 0, 0, 0);


-- add new reference to Nefarian. Fixes issue 2336

REPLACE INTO creature_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2)
VALUES
(11583, 33999, 100, 1, 1, -33999, 1, 0, 0, 0);


-- Reference loot for Nefarian's drop of T2 heads

DELETE FROM reference_loot_template WHERE entry = 33999;
INSERT INTO reference_loot_template (entry, item, ChanceOrQuestChance, lootmode, groupid, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2)
VALUES
(33999, 16963, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16955, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16929, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16914, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16900, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16908, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16939, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16921, 0, 1, 1, 1, 1, 0, 0, 0),
(33999, 16947, 0, 1, 1, 1, 1, 0, 0, 0);


-- remove needless Reputation Rank

UPDATE item_template SET RequiredReputationRank = 0 WHERE entry IN (51888, 50718); -- Why this item needs Reptation Rank, if he drops from some Boss in ICC?


-- add quest choice items. Fixes issue 2344

UPDATE quest_template SET RewChoiceItemId1 = 31104, RewChoiceItemId2 = 31110, RewChoiceItemId3 = 31109, RewChoiceItemId4 = 31105, RewChoiceItemId5 = 31106, RewChoiceItemId6 = 31107 WHERE entry = 10639;


-- add query on pool_template, Vyragosa has entry for spawnpoints now

SET @POOL := (SELECT MAX(entry) FROM pool_template);
SET @NEXTPOOL := @POOL+1;
DELETE FROM pool_template WHERE description = "Vyragosa - spawn";
INSERT INTO pool_template (entry, max_limit, description) VALUES (@NEXTPOOL, 1, "Vyragosa - spawn");


-- add query in pool_creature, five spawnpoints of Vyragosa

DELETE FROM pool_creature WHERE pool_entry = 1750;
DELETE FROM creature WHERE id = 32630;

SET @MAXGUID := (SELECT MAX(guid) FROM creature);
SET @NPC :=  @MAXGUID+1;
INSERT INTO pool_creature (guid, pool_entry, chance, description) VALUES (@NPC, @NEXTPOOL, 0, "Vyragosa (32630) - Spawn Point 1");
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES (@NPC, 32630, 571, 1, 1, 0, 0, 7084.63, -669.311, 970.369, 3.40634, 300, 0, 0, 18900, 0, 0, 0);

SET @MAXGUID := (SELECT MAX(guid) FROM creature);
SET @NPC :=  @MAXGUID+1;
INSERT INTO pool_creature (guid, pool_entry, chance, description) VALUES (@NPC, @NEXTPOOL, 0, "Vyragosa (32630) - Spawn Point 2");
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES (@NPC, 32630, 571, 1, 1, 0, 0, 7791.49, -280.008, 979.094, 5.41547, 300, 0, 0, 18900, 0, 0, 0);

SET @MAXGUID := (SELECT MAX(guid) FROM creature);
SET @NPC :=  @MAXGUID+1;
INSERT INTO pool_creature (guid, pool_entry, chance, description) VALUES (@NPC, @NEXTPOOL, 0, "Vyragosa (32630) - Spawn Point 3");
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES (@NPC, 32630, 571, 1, 1, 0, 0, 6345.18, -733.521, 654.263, 2.3485, 300, 0, 0, 18900, 0, 0, 0);

SET @MAXGUID := (SELECT MAX(guid) FROM creature);
SET @NPC :=  @MAXGUID+1;
INSERT INTO pool_creature (guid, pool_entry, chance, description) VALUES (@NPC, @NEXTPOOL, 0, "Vyragosa (32630) - Spawn Point 4");
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES (@NPC, 32630, 571, 1, 1, 0, 0, 8690.92, -1236.7, 1093.86, 4.86177, 300, 0, 0, 18900, 0, 0, 0);

SET @MAXGUID := (SELECT MAX(guid) FROM creature);
SET @NPC :=  @MAXGUID+1;
INSERT INTO pool_creature (guid, pool_entry, chance, description) VALUES (@NPC, @NEXTPOOL, 0, "Vyragosa (32630) - Spawn Point 5");
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, DeathState, MovementType) VALUES (@NPC, 32630, 571, 1, 1, 0, 0, 7416.74, -1149.03, 1070.88, 2.78675, 300, 0, 0, 18900, 0, 0, 0);


-- add chance on spawn Proto Drake

DELETE FROM creature_ai_scripts WHERE creature_id = 32630;
INSERT INTO creature_ai_scripts (id, creature_id, event_type, event_inverse_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action1_type, action1_param1, action1_param2, action1_param3, action2_type, action2_param1, action2_param2, action2_param3, action3_type, action3_param1, action3_param2, action3_param3, comment)
VALUES
(3263001, 32630, 9, 0, 100, 1, 0, 35, 7000, 9000, 11, 47425, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Vyragosa - Cast Frost Breath"),
(3263002, 32630, 9, 0, 100, 1, 0, 5, 3000, 6000, 11, 51857, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, "Vyragosa - Cast Frost Cleave"),
(3263003, 32630, 0, 0, 7.5, 1, 0, 0, 0, 0, 12, 32491, 0, 259200000, 37, 0, 0, 0, 0, 0, 0, 0, "Vyragosa - 7.5% Chance on spawn Time Lost Proto-drake and kills itself");