diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/characters/2011_09_28_00_characters_characters.sql | 9 | ||||
| -rw-r--r-- | sql/updates/world/2011_09_28_00_world_achievement_reward.sql | 2 |
2 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/characters/2011_09_28_00_characters_characters.sql b/sql/updates/characters/2011_09_28_00_characters_characters.sql new file mode 100644 index 00000000000..800afc60622 --- /dev/null +++ b/sql/updates/characters/2011_09_28_00_characters_characters.sql @@ -0,0 +1,9 @@ +-- Replaces MATRON with PATRON title on MALE char. +UPDATE characters SET knownTitles = CONCAT( +SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 1), ' ', -1), ' ', +SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 2), ' ', -1), ' ', +SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 3), ' ', -1), ' ', +(SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 4), ' ', -1) | 512) &~256, ' ', +SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 5), ' ', -1), ' ', +SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 6), ' ', -1)) +WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(knownTitles, ' ', 4), ' ', -1) & 256 AND gender = 0; diff --git a/sql/updates/world/2011_09_28_00_world_achievement_reward.sql b/sql/updates/world/2011_09_28_00_world_achievement_reward.sql new file mode 100644 index 00000000000..da170d86672 --- /dev/null +++ b/sql/updates/world/2011_09_28_00_world_achievement_reward.sql @@ -0,0 +1,2 @@ +-- Set `title_A` to male variant (Patron) +UPDATE `achievement_reward` SET `title_A`=138 WHERE `entry`=1793; |