From f4075f0f945c842fe2b1a08ea4a7fa253e8e2e53 Mon Sep 17 00:00:00 2001 From: Subv2112 Date: Sat, 14 Jan 2012 17:37:28 +0100 Subject: Core/LFG: Fix priority of the player when its added to the lfg group Better implementation of the Dungeon Deserter debuff Rewrite the NeedBeforeGreed loot Fixed players being shown as Unknown Entity when entering the lfg group Some incremental optimizations after original patch Thanks to Retriman and Paecman for base implementation Signed-off-by: Machiavelli --- sql/updates/characters/2012_01_14_00_characters_lfg_data.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/characters/2012_01_14_00_characters_lfg_data.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2012_01_14_00_characters_lfg_data.sql b/sql/updates/characters/2012_01_14_00_characters_lfg_data.sql new file mode 100644 index 00000000000..3c6671a3914 --- /dev/null +++ b/sql/updates/characters/2012_01_14_00_characters_lfg_data.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `lfg_data`; + +CREATE TABLE `lfg_data` ( + `guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `dungeon` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `state` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='LFG Data'; -- cgit v1.2.3