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

---
 includes/pages/guest_faq.php | 25 +++++++++++--------------
 1 file changed, 11 insertions(+), 14 deletions(-)

(limited to 'includes')

diff --git a/includes/pages/guest_faq.php b/includes/pages/guest_faq.php
index e639731b..9d65bb36 100644
--- a/includes/pages/guest_faq.php
+++ b/includes/pages/guest_faq.php
@@ -1,22 +1,19 @@
 <?php
 function guest_faq() {
 	$html = "";
-	$faqs = sql_select("SELECT * FROM `FAQ`");
+	if ($_SESSION['Sprache'] == "DE") {
+		$faqs = sql_select("SELECT * FROM `FAQ` WHERE `Sprache` = 'de'");
+	} else {
+		$faqs = sql_select("SELECT * FROM `FAQ` WHERE `Sprache` = 'en'");
+	}
+
 	foreach ($faqs as $faq) {
 		$html .= "<dl>";
-		if ($_SESSION['Sprache'] == "DE") {
-			$html .= sprintf(
-				'<dt>%s</dt> <dd>%s</dd>',
-				$faq['Frage_de'],
-				$faq['Antwort_de']
-			);
-		} else {
-			$html .= sprintf(
-				'<dt>%s</dt> <dd>%s</dd>',
-				$faq['Frage_en'],
-				$faq['Antwort_en']
-			);
-		}
+		$html .= sprintf(
+			'<dt>%s</dt> <dd>%s</dd>',
+			$faq['Frage'],
+			$faq['Antwort']
+		);
 		$html .= "</dl>";
 	}
 	return $html;
-- 
cgit v1.2.3-54-g00ecf