Topic already exists";
}
}
// Edit topic
if(!isset($ADD_error)){
DATABASE_query("UPDATE ".$DB_prefix."topics SET name='$TOPIC_name' WHERE id='$TOPIC_id'");
echo("Topic edited
");
}else{
echo($ADD_error);
}
}elseif($_POST["x"] == "f"){
if (get_magic_quotes_gpc() == 0) {
$FAQ_id = addslashes(rawurlencode($_POST["id"]));
$FAQ_subject = addslashes(rawurlencode($_POST["subject"]));
$FAQ_message = addslashes(rawurlencode($_POST["message"]));
$FAQ_topicid = addslashes(rawurlencode($_POST["topic"]));
} else {
$FAQ_id = rawurlencode($_POST["id"]);
$FAQ_subject = rawurlencode($_POST["subject"]);
$FAQ_message = rawurlencode($_POST["message"]);
$FAQ_topicid = rawurlencode($_POST["topic"]);
}
if($FAQ_subject == ""){
$SEARCH_error = "Please enter a subject
";
}
if($FAQ_message == ""){
$SEARCH_error = "Please enter a message
";
}
if($FAQ_topicid == ""){
$SEARCH_error = "FAQs must be assigned to a topic
";
}
// Check to see if faq exists
$result_search = DATABASE_query("SELECT * FROM ".$DB_prefix."faqs");
while($search = DATABASE_fetch($result_search)){
$SEARCH_subject = $search["subject"];
$SEARCH_id = $search["id"];
if($SEARCH_subject == $FAQ_subject && $SEARCH_id !== $FAQ_id){
$SEARCH_error = "FAQ already exists
";
}
}
// Edit FAQ if it does not exist
if(!isset($SEARCH_error)){
DATABASE_query("UPDATE ".$DB_prefix."faqs SET topicid='$FAQ_topicid', subject='$FAQ_subject', message='$FAQ_message' WHERE id='$FAQ_id'");
echo("FAQ edited
");
}else{
echo($SEARCH_error);
}
}elseif($_POST["x"] == "s"){
$result_topics = DATABASE_query("SELECT * FROM ".$DB_prefix."topics");
while($find = DATABASE_fetch($result_topics)){
$TOPIC_id = $find["id"];
$TOPIC_sort = $_POST[$TOPIC_id];
DATABASE_query("UPDATE ".$DB_prefix."topics SET sort='$TOPIC_sort' WHERE id='$TOPIC_id'");
}
echo("Sorting edited
");
}else{
echo("Code Error - x not defined
");
}
}else{
if($_GET["x"] == "t"){
include_once("../../inc/header_faq.php");
$TOPIC_id = $_GET["id"];
$result_topic = DATABASE_query("SELECT * FROM ".$DB_prefix."topics WHERE id='$TOPIC_id'");
if($topic = DATABASE_fetch($result_topic)){
$TOPIC_name = rawurldecode($topic["name"]);
}else{
echo("Topic not found
");
}
?>
FAQ not found");
}
if(!isset($FAQ_notfound)){
?>