From 05e03e7634d257820d49e3d93aed4da374eee869 Mon Sep 17 00:00:00 2001
From: Vincent_Michael <Vincent_Michael@gmx.de>
Date: Mon, 7 Jan 2013 23:09:34 +0100
Subject: SQL: Rename SQL merged in PR

---
 sql/updates/world/2012_12_20_00_world_skeram.sql |  5 -----
 sql/updates/world/2012_12_23_02_world_buru.sql   | 23 -----------------------
 sql/updates/world/2013_01_07_09_world_buru.sql   | 23 +++++++++++++++++++++++
 sql/updates/world/2013_01_07_10_world_skeram.sql |  5 +++++
 4 files changed, 28 insertions(+), 28 deletions(-)
 delete mode 100644 sql/updates/world/2012_12_20_00_world_skeram.sql
 delete mode 100644 sql/updates/world/2012_12_23_02_world_buru.sql
 create mode 100644 sql/updates/world/2013_01_07_09_world_buru.sql
 create mode 100644 sql/updates/world/2013_01_07_10_world_skeram.sql

diff --git a/sql/updates/world/2012_12_20_00_world_skeram.sql b/sql/updates/world/2012_12_20_00_world_skeram.sql
deleted file mode 100644
index fb62da5e994..00000000000
--- a/sql/updates/world/2012_12_20_00_world_skeram.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-DELETE FROM `spell_target_position` WHERE id IN (4801,8195,20449);
-INSERT INTO `spell_target_position` VALUES
-(4801,531,-8306.68,2060.84,133.062,0),
-(8195,531,-8344.97,2081.36,125.649,0),
-(20449,531,-8330.63,2123.14,133.062,0);
diff --git a/sql/updates/world/2012_12_23_02_world_buru.sql b/sql/updates/world/2012_12_23_02_world_buru.sql
deleted file mode 100644
index daab88f6cea..00000000000
--- a/sql/updates/world/2012_12_23_02_world_buru.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-UPDATE `creature_template` SET ScriptName='npc_buru_egg' WHERE entry=15514;
-UPDATE `creature_template` SET `faction_A`=16,`faction_H`=16 WHERE `entry` IN (15514,15370);
-DELETE FROM `creature` WHERE `id`=15521; -- because **** you, thats why
-SET @GUID :=xxx; -- Change me plz
-DELETE FROM `creature` WHERE `id`=15514;
-INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
-(@GUID, 15514, 509, 1, 1, -9270.393, 1243.896, -63.76731, 2.722714, 7200, 0, 0),
-(@GUID+1, 15514, 509, 1, 1, -9300.067, 1305.085, -63.69709, 4.18879, 7200, 0, 0),
-(@GUID+2, 15514, 509, 1, 1, -9263.014, 1295.236, -63.80813, 1.797689, 7200, 0, 0),
-(@GUID+3, 15514, 509, 1, 1, -9243.427, 1280.498, -63.59377, 3.822271, 7200, 0, 0),
-(@GUID+4, 15514, 509, 1, 1, -9234.326, 1243.826, -63.52806, 3.490659, 7200, 0, 0),
-(@GUID+5, 15514, 509, 1, 1, -9300.189, 1266.665, -63.74272, 0.2617994, 7200, 0, 0);
-DELETE FROM `linked_respawn` WHERE `linkedGuid`=90873;
-INSERT INTO `linked_respawn` (`guid`, `linkedGuid`, `linkType`) VALUES
-(@GUID, 90873, 0),
-(@GUID+1, 90873, 0),
-(@GUID+2, 90873, 0),
-(@GUID+3, 90873, 0),
-(@GUID+4, 90873, 0),
-(@GUID+5, 90873, 0);
-DELETE FROM `spell_script_names` WHERE `spell_id`=19593;
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
-(19593, 'spell_egg_explosion');
diff --git a/sql/updates/world/2013_01_07_09_world_buru.sql b/sql/updates/world/2013_01_07_09_world_buru.sql
new file mode 100644
index 00000000000..a7e1d5a0ef1
--- /dev/null
+++ b/sql/updates/world/2013_01_07_09_world_buru.sql
@@ -0,0 +1,23 @@
+UPDATE `creature_template` SET ScriptName='npc_buru_egg' WHERE entry=15514;
+UPDATE `creature_template` SET `faction_A`=16,`faction_H`=16 WHERE `entry` IN (15514,15370);
+DELETE FROM `creature` WHERE `id`=15521; -- because **** you, thats why
+SET @GUID :=61988;
+DELETE FROM `creature` WHERE `id`=15514;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@GUID, 15514, 509, 1, 1, -9270.393, 1243.896, -63.76731, 2.722714, 7200, 0, 0),
+(@GUID+1, 15514, 509, 1, 1, -9300.067, 1305.085, -63.69709, 4.18879, 7200, 0, 0),
+(@GUID+2, 15514, 509, 1, 1, -9263.014, 1295.236, -63.80813, 1.797689, 7200, 0, 0),
+(@GUID+3, 15514, 509, 1, 1, -9243.427, 1280.498, -63.59377, 3.822271, 7200, 0, 0),
+(@GUID+4, 15514, 509, 1, 1, -9234.326, 1243.826, -63.52806, 3.490659, 7200, 0, 0),
+(@GUID+5, 15514, 509, 1, 1, -9300.189, 1266.665, -63.74272, 0.2617994, 7200, 0, 0);
+DELETE FROM `linked_respawn` WHERE `linkedGuid`=90873;
+INSERT INTO `linked_respawn` (`guid`, `linkedGuid`, `linkType`) VALUES
+(@GUID, 90873, 0),
+(@GUID+1, 90873, 0),
+(@GUID+2, 90873, 0),
+(@GUID+3, 90873, 0),
+(@GUID+4, 90873, 0),
+(@GUID+5, 90873, 0);
+DELETE FROM `spell_script_names` WHERE `spell_id`=19593;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(19593, 'spell_egg_explosion');
diff --git a/sql/updates/world/2013_01_07_10_world_skeram.sql b/sql/updates/world/2013_01_07_10_world_skeram.sql
new file mode 100644
index 00000000000..fb62da5e994
--- /dev/null
+++ b/sql/updates/world/2013_01_07_10_world_skeram.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_target_position` WHERE id IN (4801,8195,20449);
+INSERT INTO `spell_target_position` VALUES
+(4801,531,-8306.68,2060.84,133.062,0),
+(8195,531,-8344.97,2081.36,125.649,0),
+(20449,531,-8330.63,2123.14,133.062,0);
-- 
cgit v1.2.3