aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-02-21 17:02:56 -0600
committermegamage <none@none>2009-02-21 17:02:56 -0600
commit3fb55c922f7b36d0746894702ada17203603fafb (patch)
tree9579916466c66d824355922385b2246fa5d30def /sql
parent30413b6d1ac059c71be426d318ed7c7c336a422d (diff)
[7312] Use localized DB-based achievement message instead hardcoded string. Author: VladimirMangos
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/mangos.sql3
-rw-r--r--sql/updates/7312_01_mangos_mangos_string.sql5
2 files changed, 7 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql
index a7e555be112..75b4fce25e6 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -22,7 +22,7 @@
DROP TABLE IF EXISTS `db_version`;
CREATE TABLE `db_version` (
`version` varchar(120) default NULL,
- `required_7303_01_mangos_pools` bit(1) default NULL
+ `required_7312_01_mangos_mangos_string` bit(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
--
@@ -2870,6 +2870,7 @@ INSERT INTO `mangos_string` VALUES
(807,'Please provide character name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(808,'Player %s not found or offline',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(809,'Account for character %s not found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(810,'|Hplayer:$N|h[$N]|h has earned the achievement $a!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1000,'Exiting daemon...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1001,'Account deleted: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(1002,'Account %s NOT deleted (probably sql file format was updated)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
diff --git a/sql/updates/7312_01_mangos_mangos_string.sql b/sql/updates/7312_01_mangos_mangos_string.sql
new file mode 100644
index 00000000000..8a5f848d438
--- /dev/null
+++ b/sql/updates/7312_01_mangos_mangos_string.sql
@@ -0,0 +1,5 @@
+ALTER TABLE db_version CHANGE COLUMN required_7303_01_mangos_pools required_7312_01_mangos_mangos_string bit;
+
+DELETE FROM `mangos_string` WHERE entry = 810;
+INSERT INTO `mangos_string` VALUES
+(810,'|Hplayer:$N|h[$N]|h has earned the achievement $a!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);