diff options
| author | teacher <none@none> | 2010-03-23 02:13:38 +0100 |
|---|---|---|
| committer | teacher <none@none> | 2010-03-23 02:13:38 +0100 |
| commit | 05e7a155a5ec2381ce5878eab39ca1969f4d80bb (patch) | |
| tree | 4b2ddcb9d1254d7d6af3b70c8b495a63cb787baf | |
| parent | 2c2b75fb55ed128861d83bb30570ce56716e5a2a (diff) | |
Fixed long forgotten gamebuild default value (thx Aokromes).
Also fixed typo in script full file (thx ogeraisi).
--HG--
branch : trunk
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 2 | ||||
| -rw-r--r-- | sql/realmd.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7677_realmd_realmlist.sql | 1 |
3 files changed, 3 insertions, 2 deletions
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'; |