diff options
| -rw-r--r-- | sql/FULL/world_script_texts.sql | 2 | ||||
| -rw-r--r-- | sql/FULL/world_script_waypoints.sql | 20 |
2 files changed, 21 insertions, 1 deletions
diff --git a/sql/FULL/world_script_texts.sql b/sql/FULL/world_script_texts.sql index a20e9635d68..36efbf647d6 100644 --- a/sql/FULL/world_script_texts.sql +++ b/sql/FULL/world_script_texts.sql @@ -30,7 +30,7 @@ CREATE TABLE `script_texts` ( -- -- -1 000 000 First 100 entries are reserved for special use, do not add regular text here. -- -DELETE FROM `script_texts` WHERE entry between -1999925 and -1000000; +DELETE FROM `script_texts` WHERE entry BETWEEN -1999925 AND -1000000; INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES (0,-1000000,'<TrinityScript Text Entry Missing!>',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'DEFAULT_TEXT'), (0,-1000001,'%s goes into a killing frenzy!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_GENERIC_FRENZY_KILL'), diff --git a/sql/FULL/world_script_waypoints.sql b/sql/FULL/world_script_waypoints.sql index 68e150f271b..2bab528edab 100644 --- a/sql/FULL/world_script_waypoints.sql +++ b/sql/FULL/world_script_waypoints.sql @@ -15,6 +15,12 @@ CREATE TABLE `script_waypoint` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; */ +-- +-- Not sure why we don't just run +-- DELETE FROM `script_waypoint`; +-- I mean seriously, who has custom waypoint creatures? +-- + DELETE FROM `script_waypoint` WHERE `entry`=24156; INSERT INTO `script_waypoint` VALUES (24156,1,1859.74, -6178.15, 24.3033, 0, ''), @@ -1670,3 +1676,17 @@ INSERT INTO `script_waypoint` VALUES (23784, 22, 1619.15, -6167.6, 9.39125, 5, 'Apothecary Hanes'), (23784, 23, 1634.05, -6153.81, 8.08527, 5, 'Apothecary Hanes'); +-- New waypoint format as of 5696: +ALTER IGNORE TABLE `creature_addon` + ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `guid`; +ALTER IGNORE TABLE `creature_template_addon` + ADD `path_id` int(11) unsigned NOT NULL default '0' AFTER `entry`; + +ALTER TABLE `waypoint_data` ADD COLUMN `id_old` int(10) unsigned NOT NULL default '0' COMMENT 'Creature GUID' AFTER `wpguid`; +UPDATE `waypoint_data` SET `id_old`=`id`*0.1; + +REPLACE INTO `creature_addon` ( `guid` ) SELECT `id_old` FROM `waypoint_data`; + +UPDATE `creature_addon`,`waypoint_data` SET `creature_addon`.`path_id` = `waypoint_data`.`id` WHERE `creature_addon`.`guid`=`waypoint_data`.`id_old`; + +ALTER TABLE `waypoint_data` DROP COLUMN `id_old`; |