* Trinity sql coding style

* Added 1703_world.sql
* Small fixies in other files

--HG--
branch : trunk

5 files changed, 25 insertions, 3 deletions

diff --git a/sql/updates/2.4.3_updates/1138_world.sql b/sql/updates/2.4.3_updates/1138_world.sql
new file mode 100644
index 00000000000..610f97139a5
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1138_world.sql
@@ -0,0 +1 @@
+INSERT INTO `spell_proc_event` VALUES (17619, 0x00, 13, 0x0000000000000000, 0x00008000, 0x00000000, 0.000000, 0.000000, 0);
diff --git a/sql/updates/2.4.3_updates/1142_world.sql b/sql/updates/2.4.3_updates/1142_world.sql
new file mode 100644
index 00000000000..2109d0f8ab7
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1142_world.sql
@@ -0,0 +1,8 @@
+DELETE from `spell_affect` where entry=16999 and effectId=0;
+DELETE from `spell_affect` where entry=16999 and effectId=2;
+INSERT INTO `spell_affect` VALUES (16999, 0, 0x1000001000);
+INSERT INTO `spell_affect` VALUES (16999, 2, 0x1000001000);
+DELETE from `spell_affect` where entry=16998 and effectId=0;
+DELETE from `spell_affect` where entry=16998 and effectId=2;
+INSERT INTO `spell_affect` VALUES (16998, 0, 0x1000001000);
+INSERT INTO `spell_affect` VALUES (16998, 2, 0x1000001000);
diff --git a/sql/updates/2.4.3_updates/1159_world.sql b/sql/updates/2.4.3_updates/1159_world.sql
new file mode 100644
index 00000000000..b237e0422c4
--- /dev/null
+++ b/sql/updates/2.4.3_updates/1159_world.sql
@@ -0,0 +1,10 @@
+DELETE from `spell_affect` where entry=16999;
+DELETE from `spell_affect` where entry=16998;
+INSERT INTO `spell_affect` VALUES (16998, 0, 0x40000001000);
+INSERT INTO `spell_affect` VALUES (16998, 1, 0x40000001000);
+INSERT INTO `spell_affect` VALUES (16998, 2, 0x40000001000);
+INSERT INTO `spell_affect` VALUES (16999, 0, 0x40000001000);
+INSERT INTO `spell_affect` VALUES (16999, 1, 0x40000001000);
+INSERT INTO `spell_affect` VALUES (16999, 2, 0x40000001000);
+
+
diff --git a/sql/updates/2.4.3_updates/1160_world.sql b/sql/updates/2.4.3_updates/1160_world.sql
index bf959443065..f25085cf05c 100644
--- a/sql/updates/2.4.3_updates/1160_world.sql
+++ b/sql/updates/2.4.3_updates/1160_world.sql
@@ -15,7 +15,6 @@ CREATE TABLE `access_requirement` (
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements';
 
-
 ALTER TABLE `instance_template`
  DROP COLUMN `levelMin`,
  DROP COLUMN `levelMax`,
@@ -138,4 +137,4 @@ UPDATE `instance_template` SET `access_id` = '48' WHERE `map` = '565';
 UPDATE `instance_template` SET `access_id` = '49' WHERE `map` = '568';
 UPDATE `instance_template` SET `access_id` = '50' WHERE `map` = '580';
 UPDATE `instance_template` SET `access_id` = '51' WHERE `map` = '585';
-UPDATE `areatrigger_teleport` SET `access_id` = '52' WHERE `id` IN ('4352','4354');
+UPDATE `areatrigger_teleport` SET `access_id` = '52' WHERE `id` IN ('4352','4354');
\ No newline at end of file
diff --git a/sql/updates/2.4.3_updates/CMakeLists.txt b/sql/updates/2.4.3_updates/CMakeLists.txt
index 85f240ead8c..6d9b6a025cc 100644
--- a/sql/updates/2.4.3_updates/CMakeLists.txt
+++ b/sql/updates/2.4.3_updates/CMakeLists.txt
@@ -168,4 +168,8 @@ INSTALL(FILES
 1069_world_scripts.sql
 1073_world_scripts.sql
 1074_world_scripts.sql
-DESTINATION share/trinity/sql/updates/2.4.3_updates)
+1138_world.sql
+1142_world.sql
+1159_world.sql
+1160_world.sql
+DESTINATION share/trinity/sql/updates/2.4.3_updates)
\ No newline at end of file