summaryrefslogtreecommitdiff
path: root/db/update.d/01_faq.php
diff options
context:
space:
mode:
authorPhilip Häusler <msquare@notrademark.de>2011-12-26 16:09:15 +0100
committerPhilip Häusler <msquare@notrademark.de>2011-12-26 16:09:15 +0100
commitd0bb9fbbebf2112b7330476a471c18e06222634b (patch)
treeabc17d687448e1844c0cff3ca953bbf54f17d7be /db/update.d/01_faq.php
parent1852a2a1ae190391d47d5ce15398bc0c02c7071b (diff)
parent7154097581f231753005aaabdc12d00173b7ce27 (diff)
Merge branch 'master' of https://vcs.wybt.net/engelsystem/git
Diffstat (limited to 'db/update.d/01_faq.php')
-rw-r--r--db/update.d/01_faq.php16
1 files changed, 16 insertions, 0 deletions
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;
+}
+?>