diff options
| author | Shauren <none@none> | 2010-09-03 20:11:14 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-09-03 20:11:14 +0200 |
| commit | d5115ca68729782679a1e185ca79402092991dc8 (patch) | |
| tree | 1b16ba735b64738d6739f81a3d989ab56cbdcaa6 /sql/updates | |
| parent | d7f9cea3055b3eb297ddb1ac15a92631074ac784 (diff) | |
Core/Dungeon Finder: Added support for rewards for random dungeons
Core/Quests: Simplified rewarding money from quests, now ModifyMoney and UpdateAchievementCriteria are called only once per quest
Core/Achievements: Implemented ACHIEVEMENT_CRITERIA_TYPE_USE_LFD_TO_GROUP_WITH_PLAYERS
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9743_world_command.sql | 4 | ||||
| -rw-r--r-- | sql/updates/9743_world_lfg_dungeon_encounters.sql | 6 | ||||
| -rw-r--r-- | sql/updates/9743_world_lfg_dungeon_rewards.sql | 12 |
3 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/9743_world_command.sql b/sql/updates/9743_world_command.sql new file mode 100644 index 00000000000..4309c51db98 --- /dev/null +++ b/sql/updates/9743_world_command.sql @@ -0,0 +1,4 @@ +DELETE FROM `command` WHERE `name` IN ('reload lfg_dungeon_encounters','reload lfg_dungeon_rewards'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('reload lfg_dungeon_encounters',3,'Syntax: .reload lfg_dungeon_encounters\nReload lfg_dungeon_encounters table.'), +('reload lfg_dungeon_rewards',3,'Syntax: .reload lfg_dungeon_rewards\nReload lfg_dungeon_rewards table.'); diff --git a/sql/updates/9743_world_lfg_dungeon_encounters.sql b/sql/updates/9743_world_lfg_dungeon_encounters.sql new file mode 100644 index 00000000000..2e436b0edb2 --- /dev/null +++ b/sql/updates/9743_world_lfg_dungeon_encounters.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `lfg_dungeon_encounters`; +CREATE TABLE `lfg_dungeon_encounters` ( + `achievementId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Achievement marking final boss completion', + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc', + PRIMARY KEY (`achievementId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/9743_world_lfg_dungeon_rewards.sql b/sql/updates/9743_world_lfg_dungeon_rewards.sql new file mode 100644 index 00000000000..0b762b59aca --- /dev/null +++ b/sql/updates/9743_world_lfg_dungeon_rewards.sql @@ -0,0 +1,12 @@ +DROP TABLE IF EXISTS `lfg_dungeon_rewards`; +CREATE TABLE `lfg_dungeon_rewards` ( + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc', + `maxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Max level at which this reward is rewarded', + `firstQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for first dungeon this day', + `firstMoneyVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Money multiplier for completing the dungeon first time in a day with less players than max', + `firstXPVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Experience multiplier for completing the dungeon first time in a day with less players than max', + `otherQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for Nth dungeon this day', + `otherMoneyVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Money multiplier for completing the dungeon Nth time in a day with less players than max', + `otherXPVar` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Experience multiplier for completing the dungeon Nth time in a day with less players than max', + PRIMARY KEY (`dungeonId`,`maxLevel`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; |