⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 admin_faq.php

📁 BLOG HOSTER---PHP & MYSQL Create Blogs in seconds Installation of your BlogHoster system is easy.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?
$page = "admin_faq.php";
include "admin_header.php";
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }



if($task == "add_cat") {
if(isset($_POST['o_post'])) { $o_url = $_POST['o_post']; } else { $o_url = ""; }
echo $head;
echo "
<h2>$admin_faq1</h2>
$admin_faq2<br><br>
<table cellspacing='0' cellpadding='1'>
<tr>
<form action='admin_faq.php' method='POST'>
<td valign='bottom'>
<b>$admin_faq3</b><br>
<input type='text' class='text' name='new_category' maxlength='30' size='30'>
<input type='submit' class='button' value='$admin_faq4' style='margin-bottom: 2px;'>
<input type='hidden' name='task' value='add_cat_do'>
<input type='hidden' name='o_post' value='$o_url'>
</td>
</form>
<form action='admin_faq.php' method='POST'>
<td valign='bottom'>
<input type='submit' class='button' value='$admin_faq5' style='margin-bottom: 3px;'>
<input type='hidden' name='task' value='cancel'>
<input type='hidden' name='o_post' value='$o_url'>
</td>
</form>
</tr>
</table>
";
echo $foot;
exit;
}


if($task == "add_cat_do") {
if(isset($_POST['o_post'])) { $o_url = $_POST['o_post']; } else { $o_url = ""; }
$new_category = str_replace("'", "&#39;", $_POST['new_category']);
  if(str_replace(" ", "", $new_category) == "") {
  echo $head;
  echo "<b>$admin_faq6</b><br>$admin_faq7";
  echo $foot;
  exit;
  }
  if(mysql_num_rows(mysql_query("SELECT * FROM bhost_faqcat WHERE category='$new_category'")) != 0) {
  echo $head;
  echo "<b>$admin_faq6</b><br>$admin_faq8";
  echo $foot;
  exit;
  }
$max = mysql_fetch_assoc(mysql_query("SELECT max(c_order) as c_order FROM bhost_faqcat"));
$max = 1 + $max[c_order];
mysql_query("INSERT INTO bhost_faqcat (category, c_order) VALUES ('$new_category', '$max')");
header("Location: admin_faq.php?o=$o_url");
exit;
}


if($task == "mod_cat") {
if(isset($_GET['o'])) { $o_url = $_GET['o']; } else { $o_url = ""; }
if(!isset($_GET['c_id'])) { exit; }
if(mysql_num_rows(mysql_query("SELECT * FROM bhost_faqcat WHERE c_id='$_GET[c_id]'")) != 1) { exit; }
$faqcat_info = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_faqcat WHERE c_id='$_GET[c_id]'"));
echo $head;
echo "
<h2>$admin_faq9</h2>
$admin_faq10<br><br>
<table cellspacing='0' cellpadding='1'>
<tr>
<form action='admin_faq.php' method='POST'>
<td>
<input type='hidden' name='task' value='mod_cat_do'>
<input type='hidden' name='c_id' value='$faqcat_info[c_id]'>
<input type='hidden' name='o_post' value='$o_url'>
<input type='text' name='mod_category' value='$faqcat_info[category]' maxlength='30' size='30'>
<input type='submit' class='button' value='$admin_faq11' style='margin-bottom: 2px;'>
</td>
</form>
<form action='admin_faq.php' method='POST'>
<td>
<input type='hidden' name='task' value='del_cat'>
<input type='hidden' name='c_id' value='$faqcat_info[c_id]'>
<input type='hidden' name='o_post' value='$o_url'>
<input type='submit' class='button' value='$admin_faq12' style='margin-bottom: 3px;'>
</td>
</form>
<form action='admin_faq.php' method='POST'>
<td>
<input type='hidden' name='task' value='cancel'>
<input type='hidden' name='o_post' value='$o_url'>
<input type='submit' class='button' value='$admin_faq5' style='margin-bottom: 3px;'>
</td>
</form>
</tr>
</table>
";

$faq = mysql_query("SELECT * FROM bhost_faq WHERE c_id='$faqcat_info[c_id]' ORDER BY q_order");
$questions = mysql_num_rows($faq);

if($questions > 0) {
echo "
<br>

<table cellspacing='0' cellpadding='1'>
<tr>
<form action='admin_faq.php?o=$o_url' method='POST'>
<td>

<table cellpadding='3' cellspacing='0'>
";
$max = mysql_fetch_assoc(mysql_query("SELECT max(q_order) as q_order FROM bhost_faq WHERE c_id='$faqcat_info[c_id]'"));
$old_faq_q_id = 0;

while($faq_info = mysql_fetch_assoc($faq)) {
echo "
<tr>";



// ECHO ARROW COLUMN
if($old_faq_q_id == 0 OR $faq_info[q_order] == $max[q_order]) { 
echo "<td colspan='2'"; 
 if($old_faq_q_id == 0) {
 echo " align='right'";
 }
echo ">"; 
} else { 
echo "<td>"; 
} 

if($old_faq_q_id != 0) { echo "<a href='admin_faq.php?task=quest_order_do&c_id=$faqcat_info[c_id]&q_id=$old_faq_q_id&o=$o_url'><img src='../images/faq_up.gif' border='0'></a></td>"; }

if($old_faq_q_id != 0) { 
 if($faq_info[q_order] != $max[q_order]) { echo "<td>"; } 
}

if($faq_info[q_order] != $max[q_order]) { echo "<a href='admin_faq.php?task=quest_order_do&c_id=$faqcat_info[c_id]&q_id=$faq_info[q_id]&o=$o_url'><img src='../images/faq_down.gif' border='0'></a></td>"; }

echo "<td>&nbsp;&nbsp;$faq_info[question]</td>";
echo "</tr>
";
$old_faq_q_id = $faq_info[q_id];
}


echo "
</table>
<br>

<input type='hidden' name='task' value='main'>
<input type='submit' class='button' value='$admin_faq13'>
</td>
</form>
</tr>
</table>
";
}

echo $foot;
exit;
}


if($task == "mod_cat_do") {
if(isset($_POST['o_post'])) { $o_url = $_POST['o_post']; } else { $o_url = ""; }
$c_id = $_POST['c_id'];
$mod_category = str_replace("'", "&#39;", $_POST['mod_category']);
  if(str_replace(" ", "", $mod_category) == "") {
  echo $head;
  echo "<b>$admin_faq6</b><br>$admin_faq7";
  echo $foot;
  exit;
  }
  if(mysql_num_rows(mysql_query("SELECT * FROM bhost_faqcat WHERE category='$mod_category' AND c_id <> '$c_id'")) != 0) {
  echo $head;
  echo "<b>$admin_faq6</b><br>$admin_faq8";
  echo $foot;
  exit;
  }
mysql_query("UPDATE bhost_faqcat SET category='$mod_category' WHERE c_id='$c_id'");
header("Location: admin_faq.php?o=$o_url");
exit;
}


if($task == "del_cat") {
if(isset($_POST['o_post'])) { $o_url = $_POST['o_post']; } else { $o_url = ""; }
$faqcat_info = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_faqcat WHERE c_id='$_POST[c_id]'"));
echo $head;
echo "
<h2>$admin_faq14</h2>
$admin_faq15 \"<b>$faqcat_info[category]</b>\"?<br>
<b>$admin_faq16</b><br><br>
<table cellspacing='0' cellpadding='1'>
<tr>
<form action='admin_faq.php' method='POST'>
<td>
<input type='hidden' name='task' value='del_cat_do'>
<input type='hidden' name='o_post' value='$o_url'>
<input type='hidden' name='c_id' value='$faqcat_info[c_id]'>
<input type='submit' class='button' value='$admin_faq12'>
</td>
</form>
<form action='admin_faq.php' method='POST'>
<td>
<input type='hidden' name='task' value='cancel'>
<input type='hidden' name='o_post' value='$o_url'>
<input type='submit' class='button' value='$admin_faq5'>
</td>
</form>
</tr>
</table>
";
echo $foot;
exit;

}


if($task == "del_cat_do") {
if(isset($_POST['o_post'])) { $o_url = $_POST['o_post']; } else { $o_url = ""; }
$c_id = $_POST['c_id'];
mysql_query("DELETE FROM bhost_faqcat WHERE c_id='$c_id'");
mysql_query("DELETE FROM bhost_faq WHERE c_id='$c_id'");
header("Location: admin_faq.php?o=$o_url");
exit;
}









if($task == "cat_order") {
if(isset($_GET['o'])) { $o_url = $_GET['o']; } else { $o_url = ""; }
echo $head;
echo "
<h2>$admin_faq17</h2>
$admin_faq18<br><br>
<table cellspacing='0' cellpadding='1'>
<tr>
<form action='admin_faq.php?o=$o_url' method='POST'>
<td>
";

$faqcat = mysql_query("SELECT * FROM bhost_faqcat ORDER BY c_order");
$number_of_kittens = mysql_num_rows($faqcat);

if($number_of_kittens > 0) {

echo "<table cellpadding='3' cellspacing='0'>";
$max = mysql_fetch_assoc(mysql_query("SELECT max(c_order) as c_order FROM bhost_faqcat"));
$old_faqcat_c_id = 0;

while($faqcat_info = mysql_fetch_assoc($faqcat)) {
echo "
<tr>";

// ECHO ARROW COLUMN
if($old_faqcat_c_id == 0 OR $faqcat_info[c_order] == $max[c_order]) { 
echo "<td colspan='2'"; 
 if($old_faqcat_c_id == 0) {
 echo " align='right'";
 }
echo ">"; 
} else { 
echo "<td>"; 
} 

if($old_faqcat_c_id != 0) { echo "<a href='admin_faq.php?task=cat_order_do&c_id=$old_faqcat_c_id&o=$o_url'><img src='../images/faq_up.gif' border='0'></a></td>"; }

if($old_faqcat_c_id != 0) { 
 if($faqcat_info[c_order] != $max[c_order]) { echo "<td>"; } 
}

if($faqcat_info[c_order] != $max[c_order]) { echo "<a href='admin_faq.php?task=cat_order_do&c_id=$faqcat_info[c_id]&o=$o_url'><img src='../images/faq_down.gif' border='0'></a></td>"; }

echo "<td>&nbsp;&nbsp;<b>$faqcat_info[category]</b></td>";
echo "</tr>
";

$old_faqcat_c_id = $faqcat_info[c_id];
}
echo "
</table>

<br>
<input type='hidden' name='task' value='main'>
<input type='submit' class='button' value='$admin_faq13'>
</td>
</form>
</tr>
</table>
";
} else {
echo "
$admin_faq19
</td></tr></table>
";
}
echo $foot;
exit();
}







if($task == "cat_order_do") {
$c_id = $_GET['c_id'];
if(isset($_GET['o'])) { $o_url = $_GET['o']; } else { $o_url = ""; }
$old_faqcat_info = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_faqcat WHERE c_id='$c_id'"));

$max = mysql_fetch_assoc(mysql_query("SELECT max(c_order) as c_order FROM bhost_faqcat"));
if($old_faqcat_info[c_order] == $max[c_order]) { exit(); }

$new = mysql_fetch_assoc(mysql_query("SELECT c_order FROM bhost_faqcat WHERE c_order > '$old_faqcat_info[c_order]' ORDER BY c_order LIMIT 1"));
$new_faqcat_info = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_faqcat WHERE c_order='$new[c_order]'"));

mysql_query("UPDATE bhost_faqcat SET c_order='$old_faqcat_info[c_order]' WHERE c_id='$new_faqcat_info[c_id]'");
mysql_query("UPDATE bhost_faqcat SET c_order='$new_faqcat_info[c_order]' WHERE c_id='$c_id'");
header("Location: admin_faq.php?task=cat_order&o=$o_url");
exit();
}


if($task == "quest_order_do") {
$c_id = $_GET['c_id'];
$q_id = $_GET['q_id'];
if(isset($_GET['o'])) { $o_url = $_GET['o']; } else { $o_url = ""; }

$old_faq_info = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_faq WHERE q_id='$q_id' AND c_id='$c_id'"));
$max = mysql_fetch_assoc(mysql_query("SELECT max(q_order) as q_order FROM bhost_faq WHERE c_id='$c_id'"));
if($old_faq_info[q_order] == $max[q_order]) { exit(); }

$new = mysql_fetch_assoc(mysql_query("SELECT q_order FROM bhost_faq WHERE q_order > '$old_faq_info[q_order]' AND c_id='$c_id' ORDER BY q_order LIMIT 1"));
$new_faq_info = mysql_fetch_assoc(mysql_query("SELECT * FROM bhost_faq WHERE q_order='$new[q_order]' AND c_id='$c_id'"));

mysql_query("UPDATE bhost_faq SET q_order='$old_faq_info[q_order]' WHERE q_id='$new_faq_info[q_id]'");
mysql_query("UPDATE bhost_faq SET q_order='$new_faq_info[q_order]' WHERE q_id='$q_id'");

header("Location: admin_faq.php?task=mod_cat&c_id=$c_id&o=$o_url");
exit();
}





if($task == "add_quest") {
if(isset($_POST['o_post'])) { $o_url = $_POST['o_post']; } else { $o_url = ""; }
echo $head;
echo "
<h2>$admin_faq20</h2>
$admin_faq21<br><br>
<form action='admin_faq.php' method='POST'>
$admin_faq22<br>
<select name='new_category'>
<option></option>";
$faqcat = mysql_query("SELECT * FROM bhost_faqcat ORDER BY c_order");
while($faqcat_info = mysql_fetch_assoc($faqcat)) {
echo "<option value='$faqcat_info[c_id]'>$faqcat_info[category]</option>";
}
echo "
</select><br><br>
$admin_faq23<br>
<input type='text' name='new_question' maxlength='100' size='60'><br><br>
$admin_faq24<br>
<textarea name='new_answer' rows='15' cols='60'></textarea><br>
<table cellspacing='0' cellpadding='1'>
<tr>
<td>
<input type='hidden' name='task' value='add_quest_do'>
<input type='hidden' name='o_post' value='$o_url'>
<input type='submit' class='button' value='$admin_faq25'>
</td>
</form>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -