From 697b756c4ea5925ebb23e31b08ff851d024ae26d Mon Sep 17 00:00:00 2001
From: Jan-Philipp Litza <janphilipp@litza.de>
Date: Wed, 12 Dec 2012 00:58:44 +0100
Subject: more translations and fixes

---
 db/update.d/18_translations.php | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 db/update.d/18_translations.php

(limited to 'db')

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;
-- 
cgit v1.2.3-54-g00ecf