From e90e6085dfd35ee101e43b0fa0f84a71a19f7208 Mon Sep 17 00:00:00 2001 From: Jan-Philipp Litza Date: Tue, 27 Dec 2011 13:22:43 +0100 Subject: fixed various bug in DB update scripts --- db/update.d/01_faq.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'db/update.d/01_faq.php') 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('
', $row['Frage'], 2); $answer = explode('
', $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']); } -- cgit v1.2.3-70-g09d2