aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorBrian <runningnak3d@gmail.com>2009-12-20 16:51:41 -0700
committerBrian <runningnak3d@gmail.com>2009-12-20 16:51:41 -0700
commitc4ac6323b0bb4eb9f4f1729ce2a63ab1a8ebd523 (patch)
treedcd9ed61403d11cad7482aac0220b15587411e23 /sql
parent8a5df265c2d3e9e47464f172dd3d79efba748686 (diff)
* Added support for RepObjectiveFaction2 / RepObjectiveValue2 (opposite
* faction) IE: need to LOSE reputation with that faction. * Original patch by Brian / Ported to latest rev. by Kudlaty -- THANKS! --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/6664_world_quest_template.sql3
-rw-r--r--sql/world.sql2
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/6664_world_quest_template.sql b/sql/updates/6664_world_quest_template.sql
new file mode 100644
index 00000000000..c0f6b5fe4f7
--- /dev/null
+++ b/sql/updates/6664_world_quest_template.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `quest_template` ADD `RepObjectiveFaction2` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `RepObjectiveValue`;
+ALTER TABLE `quest_template` ADD `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT 0 AFTER `RepObjectiveFaction2`;
+
diff --git a/sql/world.sql b/sql/world.sql
index 69504248ea6..a589d7bdb38 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -3828,6 +3828,8 @@ CREATE TABLE `quest_template` (
`RequiredSkillValue` smallint(5) unsigned NOT NULL DEFAULT '0',
`RepObjectiveFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
`RepObjectiveValue` mediumint(9) NOT NULL DEFAULT '0',
+ `RepObjectiveFaction2` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT '0',
`RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
`RequiredMinRepValue` mediumint(9) NOT NULL DEFAULT '0',
`RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',