summaryrefslogtreecommitdiff
path: root/db/update.d/18_translations.php
diff options
context:
space:
mode:
authorJan-Philipp Litza <janphilipp@litza.de>2012-12-12 00:58:44 +0100
committerJan-Philipp Litza <janphilipp@litza.de>2012-12-12 01:02:55 +0100
commit697b756c4ea5925ebb23e31b08ff851d024ae26d (patch)
treed1368317b2627f8d829a3c019e73345538b1e2ec /db/update.d/18_translations.php
parent910af3eaf725845f19c134805433533220113ae4 (diff)
more translations and fixes
Diffstat (limited to 'db/update.d/18_translations.php')
-rw-r--r--db/update.d/18_translations.php17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/update.d/18_translations.php b/db/update.d/18_translations.php
new file mode 100644
index 00000000..995a2450
--- /dev/null
+++ b/db/update.d/18_translations.php
@@ -0,0 +1,17 @@
+<?php
+// one translation pair added last commit was faulty (contained a closing :
+// even though it should have been a .), we fix it now
+mysql_query("UPDATE `Sprache`
+SET `Text` = CONCAT(SUBSTR(`Text`, 1, CHAR_LENGTH(`Text`)-1), '.')
+WHERE `TextID` = 'inc_schicht_ical_text' AND `Text` LIKE '%:';");
+
+$applied = mysql_affected_rows() > 0;
+
+// more translations
+$res = mysql_query("INSERT IGNORE INTO `Sprache` (`TextID`, `Sprache`, `Text`) VALUES
+('occupied', 'DE', 'belegt'),
+('occupied', 'EN', 'occupied'),
+('free', 'DE', 'frei'),
+('free', 'EN', 'free');");
+
+$applied |= mysql_affected_rows() > 0;