DB/GOs: Correct some templates and add a missing one (WDB)

DB/Auth: Add missed change to auth_base.sql
Also fix file endings in some of hte sqls

5 files changed, 34 insertions, 4 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 1075644db3d..14aaa4658e9 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -191,7 +191,7 @@ DROP TABLE IF EXISTS `realmlist`;
 CREATE TABLE `realmlist` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `name` varchar(32) NOT NULL DEFAULT '',
-  `address` varchar(64) NOT NULL DEFAULT '127.0.0.1',
+  `address` varchar(255) NOT NULL DEFAULT '127.0.0.1',
   `port` smallint(5) unsigned NOT NULL DEFAULT '8085',
   `icon` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `flag` tinyint(3) unsigned NOT NULL DEFAULT '2',
diff --git a/sql/updates/world/2012_03_30_00_world_smart_scripts.sql b/sql/updates/world/2012_03_30_00_world_smart_scripts.sql
index 08d4ee90168..3ec709d76c1 100644
--- a/sql/updates/world/2012_03_30_00_world_smart_scripts.sql
+++ b/sql/updates/world/2012_03_30_00_world_smart_scripts.sql
@@ -92,4 +92,3 @@ INSERT INTO `quest_start_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`
 (@COOP,38,10,@ENTRY,@LIFE,0, 5227.28,4407.01,-95.3888,4.29414),
 (@COOP,39,10,@ENTRY,@LIFE,0, 5251.09,4413.76,-96.086,3.90536),
 (@COOP,40,10,@ENTRY,@LIFE,0, 5251.09,4413.76,-96.086,4.36089);
-
diff --git a/sql/updates/world/2012_04_04_00_world_conditions.sql b/sql/updates/world/2012_04_04_00_world_conditions.sql
index f4d0a6c41b4..55cab4ca730 100644
--- a/sql/updates/world/2012_04_04_00_world_conditions.sql
+++ b/sql/updates/world/2012_04_04_00_world_conditions.sql
@@ -4,4 +4,4 @@ INSERT INTO `conditions`(`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`
 (13, 1, 61254, 0, 0, 31, 0, 3, 30449, 0, 0, 0, '', 'Will of Sartharion'),
 (13, 1, 61254, 0, 1, 31, 0, 3, 30451, 0, 0, 0, '', 'Will of Sartharion'),
 (13, 1, 61254, 0, 2, 31, 0, 3, 30452, 0, 0, 0, '', 'Will of Sartharion'),
-(13, 1, 61254, 0, 3, 31, 0, 3, 28860, 0, 0, 0, '', 'Will of Sartharion');
\ No newline at end of file
+(13, 1, 61254, 0, 3, 31, 0, 3, 28860, 0, 0, 0, '', 'Will of Sartharion');
diff --git a/sql/updates/world/2012_04_04_01_world_spell_dbc.sql b/sql/updates/world/2012_04_04_01_world_spell_dbc.sql
index 1b8b0868648..7eccdf811e4 100644
--- a/sql/updates/world/2012_04_04_01_world_spell_dbc.sql
+++ b/sql/updates/world/2012_04_04_01_world_spell_dbc.sql
@@ -1,2 +1 @@
 UPDATE `spell_dbc` SET `EffectApplyAuraName1`=4 WHERE `Id`=56817;
-
diff --git a/sql/updates/world/2012_04_05_00_world_gameobject_template.sql b/sql/updates/world/2012_04_05_00_world_gameobject_template.sql
new file mode 100644
index 00000000000..ab05bf43b86
--- /dev/null
+++ b/sql/updates/world/2012_04_05_00_world_gameobject_template.sql
@@ -0,0 +1,32 @@
+DELETE FROM `gameobject_template` WHERE `entry`=202931;
+INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `WDBVerified`) VALUES
+(202931, 5, 9463, 'Serpent Offering', '', '', '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.17, 0, 0, 0, 0, 0, 0, 12340); -- -Unknown-
+
+UPDATE `gameobject_template` SET `questItem1`=30527, `questItem2`=30524, `questItem3`=30525, `questItem4`=30526 WHERE `entry`=184815; -- Sealed Coffin
+-- UPDATE `gameobject_template` SET `data0`=2061, `WDBVerified`=12340 WHERE `entry`=151951; -- Idol Oven Fire
+-- UPDATE `gameobject_template` SET `type`=5, `data3`=0, `data5`=0 WHERE `entry`=188187; -- Snow Pile
+UPDATE `gameobject_template` SET `size`=0.45 WHERE `entry`=190169; -- Tiger Lily
+UPDATE `gameobject_template` SET `unk1`='' WHERE `entry`=190549; -- The Zephyr
+UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=191300; -- Fire
+UPDATE `gameobject_template` SET `displayId`=7836 WHERE `entry`=196485; -- Saronite Rock
+--  UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=126337; -- 126337
+--  UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=126338; -- 126338
+--  UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=126339; -- 126339
+--  UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=126340; -- 126340
+--  UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=126341; -- 126341
+--  UPDATE `gameobject_template` SET `data0`=2061 WHERE `entry`=126345; -- 126345
+UPDATE `gameobject_template` SET `data2`=23787, `data7`=3605, `data19`=0 WHERE `entry`=202443; -- Dedication of Honor
+UPDATE `gameobject_template` SET `type`=10 WHERE `entry`=166872; -- Supply Crate
+UPDATE `gameobject_template` SET `data6`=-1000 WHERE `entry`=178559; -- Larva Spewer
+
+/*
+GameObject (Entry: 126337 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 126338 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 126339 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 126340 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 126341 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 126345 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 151951 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+GameObject (Entry: 191300 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist.
+Gameobject (Entry: 188192 GoType: 3) have data7=188187 but GO (Entry 188187) have not GAMEOBJECT_TYPE_TRAP (6) type.
+*/