" . $GLOBALS['sitename'] . " " . _FAQ2 . "

" . "
" . _CATEGORY . ": " . _MAIN . " -> " . ($categories) . "

"; echo "" . "
" . _QUESTION . "
"; while (list($id, $question, $answer) = sql_fetch_row($result)) { echo"·  $question
"; } echo "
" . _INFO1 . " " . _INFO2 . " " . _INFO3 . ""; echo "

"; } // ########################################################### function ShowFaqAll($id_cat) { global $bgcolor2, $bgcolor3, $prefix; echo "" . ""; $result = sql_query("select id, id_cat, question, answer from ${prefix}_faqanswer where id_cat='" . intval($id_cat) . "' order by id DESC"); while (list($id, $id_cat, $question, $answer) = sql_fetch_row($result)) { echo""; } echo "
" . _ANSWER . "
" . "
·  $question" . "
" . mxNL2BR($answer) . "
" . "
[ " . _BACKTOTOP . " ]

" . "


" . "
[ " . _BACKTOFAQINDEX . " ]
"; } // ########################################################### function ShowFaqNew() { global $prefix; $faqaddsave = (empty($_REQUEST['faqaddsave'])) ? "" : $_REQUEST['faqaddsave']; $faqemail = (empty($_REQUEST['faqemail'])) ? "" : mxStripSlashes($_REQUEST['faqemail']); $faqquestion = (empty($_REQUEST['faqquestion'])) ? "" : mxStripSlashes($_REQUEST['faqquestion']); $faqaddcat = (empty($_REQUEST['faqaddcat'])) ? 0 : $_REQUEST['faqaddcat']; $error = (empty($error)) ? "" : $error; if (MX_IS_USER) { $cookie = mxGetUserSession(); $faqname = $cookie[1]; } else { $faqname = $GLOBALS['anonymous']; } if ($faqaddsave == 'y') { $faqname = str_replace('"', "'", $faqname); $faqemail = str_replace('"', "'", $faqemail); $faqquestion = str_replace('"', "'", $faqquestion); $faqip = MX_REMOTE_ADDR; $faqaddsave = ''; $error = "" . _FERROR . ": "; if (empty($faqname)) { $error .= _ENTERNAME . "

\n"; } else if ($faqemail != '' and (!strchr($faqemail, '@') or !strchr($faqemail, '.'))) { $error .= "'$faqemail' " . _WRONGMAIL . "

\n"; $faqemail = ''; } else if ($faqquestion == '') { $error .= _QUESTION . "

\n"; } else { $faqaddsave = 'y'; $error = ''; $query = "INSERT INTO ${prefix}_faqnew (name,email,question,date,id_cat,ip) VALUES ( '" . mxAddSlashesForSQL(strip_tags($faqname)) . "', '" . mxAddSlashesForSQL(strip_tags($faqemail)) . "', '" . mxAddSlashesForSQL(strip_tags($faqquestion)) . "', '" . date("%Y-%m-%d %H:%i:%s") . "', '" . $faqaddcat . "', '" . $faqip . "')"; // print $query; $result1 = sql_query($query); if (!$result1) mxErrorScreen("Database-Error"); if (!empty($faqemail) && $result1) { $message = _DEAR . " " . $faqname . "\n\n" . _USEMAIL1 . " $faqip " . _USEMAIL2 . "\n" . _USEMAIL3 . "\n" . $GLOBALS['sitename'] . " (" . MX_HOME_URL . ")\n\n" . _QUEST1 . "\n" . "\t$faqquestion\n\n" . _NOMESS . "\n\n" . _SEE1 . " " . $GLOBALS['sitename'] . " " . _WEBSITE . "\n\n" . _GREETS . "\n" . $GLOBALS['sitename'] . " " . _TEAM; $subject = _THANKS1 . " " . $GLOBALS['sitename']; $sender = $faqemail; // mxDebugFuncVars($message); mxMail($faqemail, $subject, $message, $sender, "text", "", "" . $GLOBALS['sitename'] . " " . _VISITOR . ""); } if (!empty($GLOBALS['adminmail']) && $result1) { $message = _HI . " " . $GLOBALS['sitename'] . " " . _ADMIN . ",\n\n" . _USER1 . " '" . $faqname . "' ($faqemail) [$faqip] " . _QUESTION3 . "\n\n" . "\t$faqquestion\n\n" . _DIRECT . " " . MX_HOME_URL . "/admin.php?op=FaqAnswerNew " . _ANSWER . "\n\n" . _GREETS . "\n" . _TEAM; $subject = _QUESTION2 . " '" . $GLOBALS['sitename'] . "'"; $sender = $faqemail; // mxDebugFuncVars($sender, $subject); @mxMail($GLOBALS['adminmail'], $subject, $message, $sender, "text", "", "" . $GLOBALS['sitename'] . " " . _VISITOR . ""); } // die("Subject:".$subject.", Message:".$message." Senderemail:".$sender." include("header.php"); OpenTable(); echo "
" . _THANKS1 . "

\n" // .""._THANKS2."
" . _THANKS3 . "

\n" . "
" . _FINISH . "
\n"; CloseTable(); include("footer.php"); } } if ($faqaddsave != 'y') { $categories = (empty($_REQUEST['categories'])) ? "" : $_REQUEST['categories']; $id_cat = (empty($_REQUEST['id_cat'])) ? "" : $_REQUEST['id_cat']; if ($GLOBALS["multilingual"] == 1) { if (ereg("german", $GLOBALS["currentlang"])) $thislang = "german"; else $thislang = $GLOBALS["currentlang"]; $querylang = "WHERE (flanguage LIKE '" . $thislang . "%' OR flanguage='')"; } else { $querylang = ""; } $result = sql_query("select id_cat, categories from ${prefix}_faqcategories $querylang ORDER BY categories DESC"); while (list($idcat, $categorie) = sql_fetch_row($result)) { $sel = ($id_cat == $idcat) ? " selected" : ""; $options[] = ""; } include("header.php"); OpenTable(); echo "
" . _ADDFAQ . "


\n"; echo "" . _NEWQUEST . ":\n"; echo "


" . $error . "
"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if (isset($options)) echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
" . _YNAME . "
" . _YMAIL . "" . _YMAILINFO . "
" . _YQUEST . "" . _MAXCHAR . "
" . _CATEGORY . "
\n"; echo "
\n"; CloseTable(); include("footer.php"); } } // ########################################################### $myfaq = (empty($_REQUEST['myfaq'])) ? "" : $_REQUEST['myfaq']; $faqaddnew = (empty($_REQUEST['faqaddnew'])) ? "" : $_REQUEST['faqaddnew']; if ($faqaddnew == 'y') { ShowFaqNew(); } else if (empty($myfaq)) { if ($GLOBALS["multilingual"] == 1) { if (ereg("german", $GLOBALS["currentlang"])) $thislang = "german"; else $thislang = $GLOBALS["currentlang"]; $querylang = "WHERE (flanguage LIKE '" . $thislang . "%' OR flanguage='')"; } else { $querylang = ""; } include("header.php"); OpenTable(); echo "
" . _FAQ2 . "


" . "" . "
" . _CATEGORIES . "
"; $result = sql_query("select id_cat, categories from ${prefix}_faqcategories $querylang"); while (list($id_cat, $categories) = sql_fetch_row($result)) { echo"· $categories
"; } echo "
"; CloseTable(); include("footer.php"); } else { $result = sql_query("select categories from ${prefix}_faqcategories where id_cat=" . intval($id_cat)); list($categories) = sql_fetch_row($result); $pagetitle = _FAQ . ': ' . $categories; include("header.php"); OpenTable(); ShowFaq($id_cat, $categories); ShowFaqAll($id_cat); CloseTable(); include("footer.php"); }