diff options
Diffstat (limited to 'db/update.d/01_faq.php')
| -rw-r--r-- | db/update.d/01_faq.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/db/update.d/01_faq.php b/db/update.d/01_faq.php index 92a7376d..1e32f1ad 100644 --- a/db/update.d/01_faq.php +++ b/db/update.d/01_faq.php @@ -7,7 +7,8 @@ if(sql_num_query("DESCRIBE `FAQ` `Sprache`") === 0) { 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')"); + if(count($question) == 2 && count($answer) == 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']); } |