diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2012_08_12_03_world_misc_434.sql (renamed from sql/updates/world/2012_08_17_00_world_misc_434.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2012_08_14_00_reputation_spillover_template.sql | 12 |
2 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2012_08_17_00_world_misc_434.sql b/sql/updates/world/2012_08_12_03_world_misc_434.sql index aa6c11ee1f8..aa6c11ee1f8 100644 --- a/sql/updates/world/2012_08_17_00_world_misc_434.sql +++ b/sql/updates/world/2012_08_12_03_world_misc_434.sql diff --git a/sql/updates/world/2012_08_14_00_reputation_spillover_template.sql b/sql/updates/world/2012_08_14_00_reputation_spillover_template.sql new file mode 100644 index 00000000000..cc7e011ca43 --- /dev/null +++ b/sql/updates/world/2012_08_14_00_reputation_spillover_template.sql @@ -0,0 +1,12 @@ +ALTER TABLE `reputation_spillover_template` +ADD COLUMN `faction5` SMALLINT(6) UNSIGNED DEFAULT '0' NOT NULL AFTER `rank_4`, +ADD COLUMN `rate_5` FLOAT DEFAULT '0' NOT NULL AFTER `faction5`, +ADD COLUMN `rank_5` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL AFTER `rate_5`; + +UPDATE `reputation_spillover_template` SET `faction5`=1134,`rate_5`=0.25,`rank_5`=7 WHERE `faction` IN (72,47,54,930,69); +UPDATE `reputation_spillover_template` SET `faction5`=1133,`rate_5`=0.25,`rank_5`=7 WHERE `faction` IN (76,530,911,81,68); + +DELETE FROM `reputation_spillover_template` WHERE `faction` IN (1134,1133); +INSERT INTO `reputation_spillover_template`(`faction`,`faction1`,`rate_1`,`rank_1`,`faction2`,`rate_2`,`rank_2`,`faction3`,`rate_3`,`rank_3`,`faction4`,`rate_4`,`rank_4`,`faction5`,`rate_5`,`rank_5`) VALUES +(1134,72,0.25,7,47,0.27,7,54,0.25,7,930,0.25,7,69,0.25,7), +(1133,76,0.25,7,530,0.27,7,911,0.25,7,81,0.25,7,68,0.25,7),
\ No newline at end of file |