world-database.log errors

Fixes for the current errors in the world-database.log

Here I will build up a list of the required scripts for the errors currently appearing in the World-database.log

[COLOR="#0000FF"]UPDATE creature_template SET LootId = 0 WHERE Entry IN (68, 325, 466, 467, 468, 469, 487, 488, 489, 490, 494, 495, 499, 754, 826, 827, 828, 853, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 874, 876, 885, 886, 887, 932, 933, 934, 935, 936, 999, 1064, 1245, 1278, 1280, 1337, 1338, 1414, 1421, 1434, 1437, 1476, 1477, 1481, 1483, 1642, 1733, 1741, 1754, 1756, 1777, 1949, 1975, 2058, 2099, 2105, 2112, 2153, 2238, 2239, 2361, 2362, 2363, 2378, 2379, 2386, 2392, 2395, 2396, 2398, 2400, 2402, 2466, 2468, 2469, 2470, 2506, 2507, 2508, 2509, 2510, 2511, 2512, 2513, 2514, 2515, 2516, 2517, 2518, 2525, 2526, 2527, 2608, 2714, 2721, 2787, 3083, 3338, 3501, 3691, 3695, 3732, 3733, 3734, 3804, 3806, 3807, 3808, 3893, 4966, 4979, 4995, 5546, 7489, 7730, 7843, 7865, 7939, 7975, 7980, 8015, 8016, 8096, 8147, 8154, 8155, 8310, 9118, 9119, 9525, 10036, 10037, 10684, 10696, 11040, 11053, 11180, 11276, 11328, 11609, 11615, 11979, 11994, 12047, 12160, 12657, 12658, 12736, 12858, 12862, 12863, 12903, 13817, 14983, 15443, 17070, 17079, 17080);[/COLOR]


-- Reapply the entire Corrupted plant script
-- ==========================

-- Cleansed Windblossom

-- Delete Corrupted Windblossom entries
[COLOR="#0000FF"]DELETE FROM gameobject_loot_template where item = 11950;[/COLOR]

-- New gameobject_loot_template records for Cleansed Windblossom

-- Cleansed Windblossom (gameobject_template: 164884, 173326, 174616, 174617, 174618, 174619, 174620, 174621, 174710, 174711)
[COLOR="#0000FF"]INSERT INTO gameobject_loot_template (entry, item, ChanceOrQuestChance, groupid, mincountOrRef, maxcount, condition_id) VALUES (164884, 11950, 100, 0, 1, 3, 0);[/COLOR]

-- Replace Cleansed Windblossom gameobject_template records
-- the plants will now be lootable
[COLOR="#0000FF"]UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 164884, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 164884;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 173326, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 173326;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174616, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174616;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174617, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174617;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174618, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174618;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174619, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174619;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174620, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174620;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174621, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174621;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174710, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174710;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174711, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174711;[/COLOR]

-- Assign a script to each of the corrupted Windblossom gameobject_template records
[COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164887';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='173327';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174599';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174600';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174601';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174602';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174603';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174604';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174708';[/COLOR]

-- Delete all cleansed Windblossom gameobject records (not required because the script spawns them)
[COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164884, 173326, 174616, 174617, 174618, 174619, 174620, 174621, 174710, 174711);[/COLOR]

-- Delete all but one cleansed Windblossom record from gameobject_template (we only need one)
[COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (173326, 174616, 174617, 174618, 174619, 174620, 174621, 174710, 174711);[/COLOR]

-- Cleansed Night Dragon

-- Delete Corrupted Night Dragon entries
[COLOR="#0000FF"]DELETE FROM gameobject_loot_template where item = 11952;[/COLOR]

-- New gameobject_loot_template records for Cleansed Night Dragon

-- Cleansed Night Dragon (gameobject_template: 164881, 173325, 174609, 174685)
[COLOR="#0000FF"]INSERT INTO gameobject_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES ('164881', '11952', '100', '0', '1', '3', '0');[/COLOR]

-- Replace Cleansed Night Dragon gameobject_template records
-- the plants will now be lootable
[COLOR="#0000FF"]UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 164881, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 164881;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 173325, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 173325;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174609, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174609;
UPDATE gameobject_template SET type= 3, data0 = 43, data1 = 174685, data2 = 0, data3 = 1, data4 = 1, data5 = 1, data10 = 0 WHERE entry = 174685;[/COLOR]

-- Assign a script to each of the corrupted Night Dragon gameobject_template records
[COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164885';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='173324';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174608';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174684';[/COLOR]

-- Delete all cleansed Night Dragon gameobject records (not required because the script spawns them)
[COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164881, 173325, 174609, 174685);[/COLOR]

-- Delete all but one cleansed Night Dragon record from gameobject_template (we only need one)
[COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (173325, 174609, 174685);[/COLOR]


-- Cleansed Songflower

-- Assign a script to each of the corrupted songflower gameobject_template records
[COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164886';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='171939';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='171942';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174594';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174595';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174596';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174598';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174712';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174713';[/COLOR]

-- Delete the CompleteQuest script (set to 0) for the corrupted songflower quest (the above assigned script will now deal with this)
[COLOR="#0000FF"]UPDATE quest_template SET `CompleteScript`='0' WHERE `entry`='2523';[/COLOR]

-- Assign a script to the cleansed songflower gameobject_template record
[COLOR="#0000FF"]UPDATE gameobject_template SET `data2`='0', `data10`='0', `ScriptName`= 'go_cleansed_plant' WHERE `entry`='164882';[/COLOR]

-- Delete all cleansed songflower gameobject records (not required because the script spawns them)
[COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164882, 171940, 171943, 174610, 174612, 174613, 174614, 174615, 174714, 174715);[/COLOR]

-- Delete all but one cleansed songflower record from gameobject_template (we only need one)
[COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (171940, 171943, 174610, 174612, 174613, 174614, 174615, 174714, 174715);[/COLOR]


-- Cleansed Whipper Root

-- REMOVE UNWANTED CLEANSED WHIPPER ROOT RECORDS (there are 2 of each, but only one of each is needed/correct - see above table)
[COLOR="#0000FF"]DELETE FROM gameobject WHERE `guid`='17660';
DELETE FROM gameobject WHERE `guid`='17662';
DELETE FROM gameobject WHERE `guid`='17664';
DELETE FROM gameobject WHERE `guid`='18176';
DELETE FROM gameobject WHERE `guid`='18178';
DELETE FROM gameobject WHERE `guid`='18180';[/COLOR]

-- New gameobject_loot_template records for Cleansed Whipper Root

-- Cleansed Whipper Root (gameobject_template: 164883, 174622, 174623, 174624, 174625, 174687)
[COLOR="#0000FF"]DELETE FROM gameobject_loot_template WHERE item = 11951;
INSERT INTO gameobject_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES ('164883', '11951', '100', '0', '1', '3', '0');[/COLOR]

-- Replace Cleansed Whipper Root gameobject_template records
-- the plants will now be lootable
[COLOR="#0000FF"]DELETE FROM gameobject_template where name = "Cleansed Whipper Root";
INSERT INTO gameobject_template (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `mingold`, `maxgold`, `ScriptName`) VALUES ('164883', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '164883', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174622', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174622', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174623', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174623', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174624', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174624', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174625', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174625', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', ''),('174687', '3', '3255', 'Cleansed Whipper Root', '0', '0', '2', '43', '174687', '0', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');[/COLOR]

-- INCORRECT GUID USED FOR SPAWNING CLEANSED WHIPPER ROOT
[COLOR="#0000FF"]UPDATE dbscripts_on_quest_end SET datalong = 48882 WHERE id = 4443;[/COLOR]

-- Assign a script to each of the corrupted Whipper Root gameobject_template records
[COLOR="#0000FF"]UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='164888';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='173284';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174605';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174606';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174607';
UPDATE gameobject_template SET `ScriptName`= 'go_corrupted_plant' WHERE `entry`='174686';[/COLOR]

-- Delete all cleansed songflower gameobject records (not required because the script spawns them)
[COLOR="#0000FF"]DELETE FROM gameobject WHERE id IN (164883, 174622, 174623, 174624, 174625, 174687);[/COLOR]

-- Delete all but one cleansed songflower record from gameobject_template (we only need one)
[COLOR="#0000FF"]DELETE FROM gameobject_template WHERE entry IN (174622, 174623, 174624, 174625, 174687);[/COLOR]

-- remove scripts
[COLOR="#0000FF"]UPDATE quest_template SET CompleteScript = 0 WHERE entry IN (996, 998, 1514, 2523, 2878, 3363, 4113, 4114, 4115, 4116, 4117, 4118, 4119, 4221, 4222, 4343, 4401, 4403, 4443, 4444, 4445, 4446, 4447, 4448, 4461, 4462, 4464, 4465, 4466, 4467);[/COLOR]
-- These are handled by scripdev scripts, therefore can be deleted
[COLOR="#0000FF"]DELETE FROM dbscripts_on_quest_end WHERE id IN (996, 998, 1514, 2523, 2878, 3363, 4113, 4114, 4115, 4116, 4117, 4118, 4119, 4221, 4222, 4343, 4401, 4403, 4443, 4444, 4445, 4446, 4447, 4448, 4461, 4462, 4464, 4465, 4466, 4467);[/COLOR]