📄 admin.php
字号:
<?
/*******************************************
* Sphider Version 1.2
* This program is licensed under the GNU GPL.
* By Ando Saabas ando(a t)cs.ioc.ee
********************************************/
error_reporting (E_ALL ^ E_NOTICE);
$include_dir = "../include";
include "auth.php";
include "$include_dir/commonfuncs.php";
set_time_limit (0);
extract (getHttpVars());
?>
<html>
<head>
<title>
控制面板
</title>
<LINK REL=STYLESHEET HREF="admin.css" TYPE="text/css">
</head>
<body>
<center><p>
<a href="admin.php?f=2" class="main">站点列表</a> |
<a href="admin.php?f=13" class="main">添加</a> |
<a href="admin.php?f=8" class="main">类别列表</a> |
<a href="admin.php?f=6" class="main">添加类别</a> |
<a href="admin.php?f=12" class="main">索引</a> |
<a href="admin.php?f=14" class="main">清除</a> |
<a href="admin.php?f=18" class="main">统计</a> |
<a href="admin.php?f=24" class="main">退出</a>
</p>
</center>
<?
function list_cats($parent, $lev, $color) {
global $mysql_table_prefix;
if ($lev == 0)
print "<br><div align=\"center\"><center><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\" width =\"600\"><tr><td><table table cellpadding=\"3\" cellspacing=\"1\" width=\"100%\">\n";
$space = "";
for ($x = 0; $x < $lev; $x++)
$space .= " ";
$query = "SELECT * FROM ".$mysql_table_prefix."categories WHERE parent_num=$parent ORDER BY category";
$result = mysql_query($query);
echo mysql_error();
if (mysql_num_rows($result) <> '')
while ($row = mysql_fetch_array($result)) {
if ($color =="white")
$color = "grey";
else
$color = "white";
$id = $row['category_id'];
$cat = $row['category'];
print "<tr class=\"$color\"><td width=90%>$space<a href=\"admin.php?f=9&cat_id=$id\">".$cat. "</a></td><td><a href=\"admin.php?f=9&cat_id=$id\">Edit</a></td><td> <a href=\"admin.php?f=11&cat_id=$id\" onclick=\"return confirm('Are you sure you want to delete? Subcategories will be lost.')\">Delete</a></td></tr>\n";
$color = list_cats($id, $lev + 1, $color);
}
if ($lev == 0)
print "</table></td></tr></table></center></div>\n";
return $color;
}
function walk_through_cats($parent, $lev, $site_id) {
global $mysql_table_prefix;
$space = "";
for ($x = 0; $x < $lev; $x++)
$space .= " ";
$query = "SELECT * FROM ".$mysql_table_prefix."categories WHERE parent_num=$parent ORDER BY category";
$result = mysql_query($query);
echo mysql_error();
if (mysql_num_rows($result) <> '')
while ($row = mysql_fetch_array($result)) {
$id = $row['category_id'];
$cat = $row['category'];
$state = '';
if ($site_id <> '') {
$result2 = mysql_query("select * from ".$mysql_table_prefix."site_category where site_id=$site_id and category_id=$id");
echo mysql_error();
$rows = mysql_num_rows($result2);
if ($rows > 0)
$state = "checked";
}
print $space . "<input type=checkbox name=cat[$id] $state>" . $cat . "<br>\n";
;
walk_through_cats($id, $lev + 1, $site_id);
}
}
function addcatform($parent) {
global $mysql_table_prefix;
$par2 = "";
$par2num = "";
if ($parent=='')
$par='(Top level)';
else {
$query = "SELECT category, parent_num FROM ".$mysql_table_prefix."categories WHERE category_id='$parent'";
$result = mysql_query($query);
if (!mysql_error()) {
if ($row = mysql_fetch_row($result)) {
$par=$row[0];
$query = "SELECT Category_ID, Category FROM ".$mysql_table_prefix."categories WHERE Category_ID='$row[1]'";
$result = mysql_query($query);
echo mysql_error();
if (mysql_num_rows($result)<>'') {
$row = mysql_fetch_row($result);
$par2num = $row[0];
$par2 = $row[1];
}
else
$par2 = "Top level";
}
}
else
echo mysql_error();
print "</td></tr></table>";
}
?>
<br><center><table><tr><td valign=top align=center colspan=2><b>上一级: <?print "<a href=admin.php?f=6&parent=$par2num>$par2</a> > $par"?></b></td></tr>
<form action=admin.php method=post>
<input type=hidden name=f value=7>
<input type=hidden name=parent value=<?print $parent?>
<tr><td><b>类别:</b></td><td> <input type=text name=category size=40></td></tr>
<tr><td></td><td><input type=submit value=Add></td></tr></form>
<?
print "<tr><td colspan=2>";
$query = "SELECT category_ID, Category FROM ".$mysql_table_prefix."categories WHERE parent_num='$parent'";
$result = mysql_query($query);
echo mysql_error();
if (mysql_num_rows($result)>0) {
print "<br><b>Create subcategory under</b><br><br>";
}
while ($row = mysql_fetch_row($result)) {
print "<a href=\"admin.php?f=6&parent=$row[0]\">$row[1]</a><br>";
}
print "</td></tr></table></center>";
}
function addcat ($category, $parent) {
global $mysql_table_prefix;
if ($category=="") return;
$category = addslashes($category);
mysql_query("INSERT INTO ".$mysql_table_prefix."categories (category, parent_num)
VALUES ('$category', '$parent')");
If (!mysql_error()) {
print "<center><b>Category $category addded.</b></center>" ;
} else {
echo mysql_error();
}
}
function addsiteform() {
?>
<br><div align=center><center><table>
<form action=admin.php method=post>
<input type=hidden name=f value=1>
<input type=hidden name=af value=2>
<tr><td><b>URL:</b></td><td align ="right"></td><td><input type=text name=url size=60 value ="http://"></td></tr>
<tr><td><b>标题:</b></td><td></td><td> <input type=text name=title size=60></td></tr>
<tr><td><b>简短描述:</b></td><td></td><td><textarea name=short_desc cols=45 rows=3 wrap="virtual"></textarea></td></tr>
<tr><td>类别:</td><td></td><td>
<? walk_through_cats(0, 0, '');?></td></tr>
<tr><td></td><td></td><td><input type=submit value=Add></td></tr></form></table></center></div>
<?
}
function editsiteform($site_id) {
global $mysql_table_prefix;
$result = mysql_query("SELECT site_id, url, title, short_desc, spider_depth, required, disallowed, can_leave_domain from ".$mysql_table_prefix."sites where site_id=$site_id");
echo mysql_error();
$row = mysql_fetch_array($result);
$depth = $row['spider_depth'];
$fullchecked = "";
$depthchecked = "";
if ($depth == -1 ) {
$fullchecked = "checked";
$depth ="";
} else {
$depthchecked = "checked";
}
$leave_domain = $row['can_leave_domain'];
if ($leave_domain == 1 ) {
$domainchecked = "checked";
} else {
$domainchecked = "";
}
?>
<br><div align=center><center><table>
<form action=admin.php method=post>
<input type=hidden name=f value=4>
<input type=hidden name=site_id value=<?print $site_id;?>>
<tr><td><b>URL:</b></td><td align ="right"></td><td><input type=text name=url value=<?print "\"".$row['url']."\""?> size=60></td></tr>
<tr><td><b>标题:</b></td><td></td><td> <input type=text name=title value=<?print "\"".$row['title']."\""?> size=60></td></tr>
<tr><td><b>简短描述:</b></td><td></td><td><textarea name=short_desc cols=45 rows=3 wrap><?print $row['short_desc']?></textarea></td></tr>
<tr><td><b>蜘蛛选项:</b></td><td></td><td><input type="radio" name="soption" value="full" <?print $fullchecked;?>> 全部<br>
<input type="radio" name="soption" value="level" <?print $depthchecked;?>>深度: <input type="text" name="depth" size="2" value="<?print $depth;?>"><br>
<input type="checkbox" name="domaincb" value="1" <?print $domainchecked;?>> 蜘蛛能离开域名
</td></tr>
<tr><td><b>URL 必须包括:</b></td><td></td><td><textarea name=in cols=45 rows=2 wrap="virtual"><?print $row['required'];?></textarea></td></tr>
<tr><td><b>URL 必须排除:</b></td><td></td><td><textarea name=out cols=45 rows=2 wrap="virtual"><?print $row['disallowed'];?></textarea></td></tr>
<tr><td>类别:</td><td></td><td>
<? walk_through_cats(0, 0, $site_id);?></td></tr>
<tr><td></td><td></td><td><input type="submit" value="Update"></td></tr></form></table></center></div>
<?
}
function editsite ($site_id, $url, $title, $short_desc, $depth, $required, $disallowed, $cat) {
global $mysql_table_prefix;
$short_desc = addslashes($short_desc);
$title = addslashes($title);
mysql_query("delete from ".$mysql_table_prefix."site_category where site_id=$site_id");
echo mysql_error();
$compurl=parse_url($url);
if ($compurl['path']=='')
$url=$url."/";
mysql_query("UPDATE ".$mysql_table_prefix."sites SET url='$url', title='$title', short_desc='$short_desc', spider_depth =$depth, required='$required', disallowed='$disallowed' WHERE site_id=$site_id");
echo mysql_error();
$result=mysql_query("select category_id from ".$mysql_table_prefix."categories");
echo mysql_error();
print mysql_error();
while ($row=mysql_fetch_row($result)) {
$cat_id=$row[0];
if ($cat[$cat_id]=='on') {
mysql_query("INSERT INTO ".$mysql_table_prefix."site_category (site_id, category_id) values ('$site_id', '$cat_id')");
echo mysql_error();
}
}
print mysql_error();
If (!mysql_error()) {
print "<br><center><b>Site updated.</b></center>" ;
} else {
echo mysql_error();
}
}
function editcatform($cat_id) {
global $mysql_table_prefix;
$result = mysql_query("SELECT category FROM ".$mysql_table_prefix."categories where category_id='$cat_id'");
echo mysql_error();
$row=mysql_fetch_array($result);
$category=$row[0];
?>
<div align="center"><center><table><tr><td valign="top" align="center" colspan="2"><b>编辑类别</td></tr>
<form action="admin.php" method="post">
<input type="hidden" name="f" value="10">
<input type="hidden" name="cat_id" value="<? print $cat_id;?>"
<tr><td><b>类别:</b></td><td> <input type="text" name="category" value="<?print $category?>"size=40></td></tr>
<tr><td></td><td><input type="submit" value="Update"></td></tr></form></table></center></div>
<?
}
function editcat ($cat_id, $category) {
global $mysql_table_prefix;
mysql_query("UPDATE ".$mysql_table_prefix."categories SET category='$category' WHERE category_id='$cat_id'");
if (!mysql_error()) {
print "<br><center><b>Category updated</b></center>";
} else {
echo mysql_error();
}
}
function showsites() {
global $mysql_table_prefix;
$result = mysql_query("SELECT site_id, url, title, indexdate from ".$mysql_table_prefix."sites ORDER By indexdate, title");
echo mysql_error();
print "<br><div align=\"center\"><center><table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing=\"1\">
<tr class=\"grey\"><td align=\"center\"><b>Site name</b></td><td align=\"center\"><b>Site url</b></td><td align=\"center\"><b>Last indexed</b></td><td colspan=4></td></tr>\n";
$class = "grey";
while ($row=mysql_fetch_array($result)) {
if ($row['indexdate']=='') {
$indexstatus="<font color=\"red\">Not indexed</font>";
$indexoption="<a href=\"admin.php?f=12&url=$row[url]\">Index</a>";
} else {
$site_id = $row['site_id'];
$result2 = mysql_query("SELECT site_id from ".$mysql_table_prefix."pending where site_id =$site_id");
echo mysql_error();
$row2=mysql_fetch_array($result2);
if ($row2['site_id'] == $row['site_id']) {
$indexstatus = "Unfinished";
$indexoption="<a href=\"admin.php?f=12&url=$row[url]\">Continue</a>";
} else {
$indexstatus = $row['indexdate'];
$indexoption="<a href=\"admin.php?f=12&url=$row[url]&reindex=1\">Re-index</a>";
}
}
if ($class =="white")
$class = "grey";
else
$class = "white";
print "<tr class=\"$class\"><td>$row[title]</td><td><a href=\"$row[url]\">$row[url]</a></td><td>$indexstatus</td>";
print "<td><a href=admin.php?f=20&site_id=$row[site_id]>Options</td></tr>\n";
}
print "<tr class='white'><td colspan='4' align='center'>" .
"<form action='spider.php' method='post'>" .
"<input type='hidden' name='all' value='1'>" .
"<input type='submit' value='Reindex all'><form></td></tr>";
print "</table></td></tr></table></center></div>";
}
function deletecat($cat_id) {
global $mysql_table_prefix;
$list = implode(",", get_cats($cat_id));
mysql_query("delete from ".$mysql_table_prefix."categories where category_id in ($list)");
echo mysql_error();
mysql_query("delete from ".$mysql_table_prefix."site_category where category_id=$cat_id");
echo mysql_error();
print "<center><b>Category deleted.</b></center>";
}
function deletesite($site_id) {
global $mysql_table_prefix;
mysql_query("delete from ".$mysql_table_prefix."sites where site_id=$site_id");
echo mysql_error();
mysql_query("delete from ".$mysql_table_prefix."site_category where site_id=$site_id");
echo mysql_error();
$query = "select link_id from ".$mysql_table_prefix."links where site_id=$site_id";
$result = mysql_query($query);
echo mysql_error();
$todelete = array();
while ($row=mysql_fetch_array($result)) {
$todelete[]=$row['link_id'];
}
if (count($todelete)>0) {
$todelete = implode(",", $todelete);
$query = "delete from ".$mysql_table_prefix."link_keyword where link_id in($todelete)";
mysql_query($query);
echo mysql_error();
}
mysql_query("delete from ".$mysql_table_prefix."links where site_id=$site_id");
echo mysql_error();
mysql_query("delete from ".$mysql_table_prefix."pending where site_id=$site_id");
echo mysql_error();
print "<br><center><b>Site deleted</b></center>";
}
function deletePage($link_id) {
global $mysql_table_prefix;
mysql_query("delete from ".$mysql_table_prefix."links where link_id=$link_id");
echo mysql_error();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -