From 7154097581f231753005aaabdc12d00173b7ce27 Mon Sep 17 00:00:00 2001
From: Jan-Philipp Litza <jplitza@sylar.(none)>
Date: Mon, 26 Dec 2011 16:04:54 +0100
Subject: database update script

---
 db/update.d/01_faq.php | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 db/update.d/01_faq.php

(limited to 'db/update.d/01_faq.php')

diff --git a/db/update.d/01_faq.php b/db/update.d/01_faq.php
new file mode 100644
index 00000000..92a7376d
--- /dev/null
+++ b/db/update.d/01_faq.php
@@ -0,0 +1,16 @@
+<?php
+if(sql_num_query("DESCRIBE `FAQ` `Sprache`") === 0) {
+    sql_query("ALTER TABLE `FAQ`
+        ADD `Sprache` SET('de', 'en') NOT NULL,
+        ADD INDEX(`Sprache`)");
+    $res = sql_query("SELECT * FROM `FAQ` WHERE `Sprache` = ''");
+    while($row = mysql_fetch_assoc($res)) {
+        $question = explode('<br>', $row['Frage'], 2);
+        $answer = explode('<br>', $row['Antwort'], 2);
+        sql_query("INSERT INTO `FAQ` (`Frage`, `Antwort`, `Sprache`) VALUES ('" . sql_escape(trim($question[1])) . "', '" . sql_escape(trim($answer[1])) . "', 'en')");
+        sql_query("UPDATE `FAQ` SET `Frage` = '" . sql_escape(trim($question[0])) . "', `Antwort` = '" . sql_escape(trim($answer[0])) . "', `Sprache` = 'de' WHERE `FID` = " . $row['FID']);
+    }
+
+    $applied = true;
+}
+?>
-- 
cgit v1.2.3-54-g00ecf