From edbd44a67530f2938864fd054182553b3d5ab1ac Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 4 May 2015 12:39:36 +0200 Subject: Core/Creatures: Extended npcflags to uint64 --- sql/base/characters_database.sql | 2 +- sql/updates/world/2015_05_04_00_world.sql | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 sql/updates/world/2015_05_04_00_world.sql (limited to 'sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index bcca640a7d9..5c864dc8cf7 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2670,7 +2670,7 @@ CREATE TABLE `mail_items` ( PRIMARY KEY (`item_guid`), KEY `idx_receiver` (`receiver`), KEY `idx_mail_id` (`mail_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- diff --git a/sql/updates/world/2015_05_04_00_world.sql b/sql/updates/world/2015_05_04_00_world.sql new file mode 100644 index 00000000000..276464917a1 --- /dev/null +++ b/sql/updates/world/2015_05_04_00_world.sql @@ -0,0 +1,8 @@ +ALTER TABLE `creature` CHANGE `npcflag` `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `creature_template` CHANGE `npcflag` `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `game_event_npcflag` CHANGE `npcflag` `npcflag` bigint(20) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `gossip_menu_option` CHANGE `npc_option_npcflag` `npc_option_npcflag` bigint(20) unsigned NOT NULL DEFAULT '0'; + +UPDATE `trinity_string` SET `content_default`='Player selected NPC\nDB GUID: %u, current %s.\nFaction: %u.\nnpcFlags: 0x%llX.\nEntry: %u.\nDisplayID: %u (Native: %u).' WHERE entry=539; +UPDATE `trinity_string` SET `content_default`='%s, faction is %u, flags is 0x%X, npcflag is 0x%llX, dynflag is 0x%X.' WHERE entry=128; +UPDATE `trinity_string` SET `content_default`='You changed %s Faction to %u, flags to 0x%X, npcflag to 0x%llX, dyflag to 0x%X.' WHERE entry=130; -- cgit v1.2.3