diff options
| author | Xanadu <none@none> | 2010-03-23 16:10:18 +0100 |
|---|---|---|
| committer | Xanadu <none@none> | 2010-03-23 16:10:18 +0100 |
| commit | cfc094040f7ce3924fd024c93c82eaf0b0498c8d (patch) | |
| tree | 1d9a66e4c18ee8c8f9f0eec8b2842301c743dfba /sql | |
| parent | a348b591a70b2d9f5acc890ec6f21649fddc93e1 (diff) | |
Added support for maximum allowed player level for quests. By Gyullo.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7680_world_quest_template.sql | 1 | ||||
| -rw-r--r-- | sql/world.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/7680_world_quest_template.sql b/sql/updates/7680_world_quest_template.sql new file mode 100644 index 00000000000..296f2d5cdba --- /dev/null +++ b/sql/updates/7680_world_quest_template.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` ADD COLUMN `MaxLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `MinLevel`; diff --git a/sql/world.sql b/sql/world.sql index 1ac1ee4e7e9..9db5ff08fb4 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -4369,6 +4369,7 @@ CREATE TABLE `quest_template` ( `ZoneOrSort` smallint(6) NOT NULL DEFAULT '0', `SkillOrClass` smallint(6) NOT NULL DEFAULT '0', `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `QuestLevel` smallint(3) NOT NULL DEFAULT '1', `Type` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredRaces` smallint(5) unsigned NOT NULL DEFAULT '0', |