From 0c38d04691ac19ce3fdcf2c0515c34c9def91d71 Mon Sep 17 00:00:00 2001 From: Alyen Date: Wed, 27 May 2009 18:53:31 +0200 Subject: *Some changes in Nexus-Prince Shaffar's script. --HG-- branch : trunk --- sql/updates/TC1_1534_world.sql | 3 +++ sql/world_scripts_full.sql | 1 + 2 files changed, 4 insertions(+) create mode 100644 sql/updates/TC1_1534_world.sql (limited to 'sql') diff --git a/sql/updates/TC1_1534_world.sql b/sql/updates/TC1_1534_world.sql new file mode 100644 index 00000000000..593069435fd --- /dev/null +++ b/sql/updates/TC1_1534_world.sql @@ -0,0 +1,3 @@ +UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18431; + +DELETE FROM `creature` WHERE `id` = 18431; diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index d074a524da4..3832574dc34 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -130,6 +130,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry` = UPDATE `creature_template` SET `ScriptName`='boss_pandemonius' WHERE `entry`=18341; UPDATE `creature_template` SET `ScriptName`='boss_nexusprince_shaffar' WHERE `entry`=18344; UPDATE `creature_template` SET `ScriptName`='mob_ethereal_beacon' WHERE `entry`=18431; +UPDATE `creature_template` SET `ScriptName`='mob_ethereal_apprentice' WHERE `entry`=18431; /* AUCHENAI CRYPTS */ UPDATE `creature_template` SET `ScriptName`='boss_exarch_maladaar' WHERE `entry`=18373; -- cgit v1.2.3 From f61911b5f5028b9fec35c8645a8495b484ae4e34 Mon Sep 17 00:00:00 2001 From: freeganja Date: Thu, 28 May 2009 13:16:17 +0200 Subject: *Fix a typo in scriptname. --HG-- branch : trunk --- sql/updates/TC1_1534_world.sql | 2 +- sql/world_scripts_full.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/updates/TC1_1534_world.sql b/sql/updates/TC1_1534_world.sql index 593069435fd..cd80a785278 100644 --- a/sql/updates/TC1_1534_world.sql +++ b/sql/updates/TC1_1534_world.sql @@ -1,3 +1,3 @@ -UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18431; +UPDATE `creature_template` SET `ScriptName` = 'mob_ethereal_apprentice' WHERE `entry` = 18430; DELETE FROM `creature` WHERE `id` = 18431; diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql index 3832574dc34..e00872ce13e 100644 --- a/sql/world_scripts_full.sql +++ b/sql/world_scripts_full.sql @@ -130,7 +130,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_ruul_snowhoof' WHERE `entry` = UPDATE `creature_template` SET `ScriptName`='boss_pandemonius' WHERE `entry`=18341; UPDATE `creature_template` SET `ScriptName`='boss_nexusprince_shaffar' WHERE `entry`=18344; UPDATE `creature_template` SET `ScriptName`='mob_ethereal_beacon' WHERE `entry`=18431; -UPDATE `creature_template` SET `ScriptName`='mob_ethereal_apprentice' WHERE `entry`=18431; +UPDATE `creature_template` SET `ScriptName`='mob_ethereal_apprentice' WHERE `entry`=18430; /* AUCHENAI CRYPTS */ UPDATE `creature_template` SET `ScriptName`='boss_exarch_maladaar' WHERE `entry`=18373; -- cgit v1.2.3 From 56a005703be0342e9b8233a14d2b618b55164467 Mon Sep 17 00:00:00 2001 From: Paradox Date: Thu, 28 May 2009 10:14:46 -0400 Subject: Fix wrong data type for core_revision in DB, again --HG-- branch : trunk --- sql/updates/919_world.sql | 2 +- sql/world.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/updates/919_world.sql b/sql/updates/919_world.sql index 5febe1ebdfc..7aa9fa363e6 100644 --- a/sql/updates/919_world.sql +++ b/sql/updates/919_world.sql @@ -1,3 +1,3 @@ ALTER TABLE version - ADD `core_revision` BIGINT UNSIGNED AFTER `core_version`; + ADD `core_revision` varchar(120) AFTER `core_version`; diff --git a/sql/world.sql b/sql/world.sql index 36328704193..9589907df1a 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -3291,7 +3291,7 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `version`; CREATE TABLE `version` ( `core_version` varchar(120) default NULL COMMENT 'Core revision dumped at startup.', - `core_revision` BIGINT UNSIGNED default '0', + `core_revision` varchar(120) default '0', `db_version` varchar(120) default NULL COMMENT 'Version of world DB.', `script_version` varchar(120) default NULL COMMENT 'Version of scripts DB.' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; -- cgit v1.2.3