From e1a3908c858f49d05f24c438a5a899e32e115eb9 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Mon, 7 Jul 2014 16:52:44 +0200 Subject: SQL: rename now correct ... --- ...14_07_07_02_world_spell_game_event_creature.sql | 34 ++++++++++++++++++++++ ...14_07_07_02_world_spell_game_event_creature.sql | 34 ---------------------- 2 files changed, 34 insertions(+), 34 deletions(-) create mode 100644 sql/updates/world/2014_07_07_02_world_spell_game_event_creature.sql delete mode 100644 sql/updates/world/world_2014_07_07_02_world_spell_game_event_creature.sql (limited to 'sql') diff --git a/sql/updates/world/2014_07_07_02_world_spell_game_event_creature.sql b/sql/updates/world/2014_07_07_02_world_spell_game_event_creature.sql new file mode 100644 index 00000000000..c512521337d --- /dev/null +++ b/sql/updates/world/2014_07_07_02_world_spell_game_event_creature.sql @@ -0,0 +1,34 @@ +-- +SET @CGUID := 127340; +DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUID+00 AND @CGUID+29; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(1, @CGUID+00), +(1, @CGUID+01), +(1, @CGUID+02), +(1, @CGUID+03), +(1, @CGUID+04), +(1, @CGUID+05), +(1, @CGUID+06), +(1, @CGUID+07), +(1, @CGUID+08), +(1, @CGUID+09), +(1, @CGUID+10), +(1, @CGUID+11), +(1, @CGUID+12), +(1, @CGUID+13), +(1, @CGUID+14), +(1, @CGUID+15), +(1, @CGUID+16), +(1, @CGUID+17), +(1, @CGUID+18), +(1, @CGUID+19), +(1, @CGUID+20), +(1, @CGUID+21), +(1, @CGUID+22), +(1, @CGUID+23), +(1, @CGUID+24), +(1, @CGUID+25), +(1, @CGUID+26), +(1, @CGUID+27), +(1, @CGUID+28), +(1, @CGUID+29); diff --git a/sql/updates/world/world_2014_07_07_02_world_spell_game_event_creature.sql b/sql/updates/world/world_2014_07_07_02_world_spell_game_event_creature.sql deleted file mode 100644 index c512521337d..00000000000 --- a/sql/updates/world/world_2014_07_07_02_world_spell_game_event_creature.sql +++ /dev/null @@ -1,34 +0,0 @@ --- -SET @CGUID := 127340; -DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUID+00 AND @CGUID+29; -INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES -(1, @CGUID+00), -(1, @CGUID+01), -(1, @CGUID+02), -(1, @CGUID+03), -(1, @CGUID+04), -(1, @CGUID+05), -(1, @CGUID+06), -(1, @CGUID+07), -(1, @CGUID+08), -(1, @CGUID+09), -(1, @CGUID+10), -(1, @CGUID+11), -(1, @CGUID+12), -(1, @CGUID+13), -(1, @CGUID+14), -(1, @CGUID+15), -(1, @CGUID+16), -(1, @CGUID+17), -(1, @CGUID+18), -(1, @CGUID+19), -(1, @CGUID+20), -(1, @CGUID+21), -(1, @CGUID+22), -(1, @CGUID+23), -(1, @CGUID+24), -(1, @CGUID+25), -(1, @CGUID+26), -(1, @CGUID+27), -(1, @CGUID+28), -(1, @CGUID+29); -- cgit v1.2.3