From 05e7a155a5ec2381ce5878eab39ca1969f4d80bb Mon Sep 17 00:00:00 2001 From: teacher Date: Tue, 23 Mar 2010 02:13:38 +0100 Subject: Fixed long forgotten gamebuild default value (thx Aokromes). Also fixed typo in script full file (thx ogeraisi). --HG-- branch : trunk --- sql/FULL/world_scripts_full.sql | 2 +- sql/realmd.sql | 2 +- sql/updates/7677_realmd_realmlist.sql | 1 + 3 files changed, 3 insertions(+), 2 deletions(-) create mode 100644 sql/updates/7677_realmd_realmlist.sql (limited to 'sql') diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 315505a6a33..38d34d06f57 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -913,7 +913,7 @@ UPDATE `gameobject_template` SET `ScriptName`='containment_sphere' WHERE `entry` UPDATE `instance_template` SET `script`='instance_oculus' WHERE `map`=578; UPDATE `creature_template` SET `ScriptName`='boss_drakos' WHERE `entry`=27654; UPDATE `creature_template` SET `ScriptName`='npc_unstable_sphere' WHERE `entry`=28166; -UPDATE `creature_template` SET `ScriptName`='npc_oculus_drakes' WHERE `entry` IN (27657,27658,27659); +UPDATE `creature_template` SET `ScriptName`='npc_oculus_drake' WHERE `entry` IN (27657,27658,27659); /* OBSIDIAN SANCTUM */ UPDATE `instance_template` SET `script`='instance_obsidian_sanctum' WHERE `map`=615; diff --git a/sql/realmd.sql b/sql/realmd.sql index 7334139d660..5c27c704347 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -196,7 +196,7 @@ CREATE TABLE `realmlist` ( `timezone` tinyint(3) unsigned NOT NULL default '0', `allowedSecurityLevel` tinyint(3) unsigned NOT NULL default '0', `population` float unsigned NOT NULL default '0', - `gamebuild` int(11) unsigned NOT NULL default '10505', + `gamebuild` int(11) unsigned NOT NULL default '11403', PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System'; diff --git a/sql/updates/7677_realmd_realmlist.sql b/sql/updates/7677_realmd_realmlist.sql new file mode 100644 index 00000000000..cddab25c060 --- /dev/null +++ b/sql/updates/7677_realmd_realmlist.sql @@ -0,0 +1 @@ +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '11403'; -- cgit v1.2.3