📄 admin.php
字号:
$query_add = "";
if ($filter != "") {
$query_add = "and url like '%$filter%'";
}
$linksQuery = "select count(*) from ".$mysql_table_prefix."links where site_id = $site_id $query_add";
$result = mysql_query($linksQuery);
echo mysql_error();
$row = mysql_fetch_row($result);
$numOfPages = $row[0];
$result = mysql_query($linksQuery);
echo mysql_error();
$from = ($start-1) * 10;
$to = min(($start)*10, $numOfPages);
$linksQuery = "select link_id, url from ".$mysql_table_prefix."links where site_id = $site_id and url like '%$filter%' order by url limit $from, $per_page";
$result = mysql_query($linksQuery);
echo mysql_error();
?>
<br>
<center>
<b>站点的页<a href="admin.php?f=20&site_id=<? print $site_id?>"><?print $url;?></a></b><br>
<p>
<form action="admin.php" method="post">
网页的 Url: <input type="text" name="per_page" size="3" value="<?print $per_page;?>">
Url 包含: <input type="text" name="filter" size="15" value="<?print $filter;?>">
<input type="submit" value="Filter">
<input type="hidden" name="start" value="1">
<input type="hidden" name="site_id" value="<?print $site_id?>">
<input type="hidden" name="f" value="21">
</form>
</p>
<table width="600"><tr><td>
<table cellspacing ="0" cellpadding="0" class="darkgrey" width ="100%"><tr><td>
<table cellpadding="3" cellspacing="1" width="100%">
<?
$class = "white";
while ($row = mysql_fetch_array($result)) {
if ($class =="white")
$class = "grey";
else
$class = "white";
print "<tr class=\"$class\"><td><a href=\"".$row['url']."\">".$row['url']."</a></td><td width=\"8%\"> <a href=\"admin.php?link_id=".$row['link_id']."&f=22&site_id=$site_id&start=1&filter=$filter&per_page=$per_page\">Delete</a></td></tr>";
}
print "</table></td></tr></table>";
$pages = ceil($numOfPages / $per_page);
$prev = $start - 1;
$next = $start + 1;
if ($pages > 0)
print "<center>Pages: ";
$links_to_next =10;
$firstpage = $start - $links_to_next;
if ($firstpage < 1) $firstpage = 1;
$lastpage = $start + $links_to_next;
if ($lastpage > $pages) $lastpage = $pages;
for ($x=$firstpage; $x<=$lastpage; $x++)
if ($x<>$start) {
print "<a href=admin.php?f=21&site_id=$site_id&start=$x&filter=$filter&per_page=$per_page>$x</a> ";
} else
print "<b>$x </b>";
print"</td></tr></table></center>";
}
function cleanForm () {
global $mysql_table_prefix;
$result = mysql_query("select count(*) from ".$mysql_table_prefix."query_log");
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$log=$row[0];
}
$result = mysql_query("select count(*) from ".$mysql_table_prefix."temp");
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$temp=$row[0];
}
?>
<br><div align="center">
<table cellspacing ="0" cellpadding="0" class="darkgrey"><tr><td><table cellpadding="3" cellspacing = "1" width="100%"><tr class="grey" ><td>
<a href="admin.php?f=15">清除关键词</a> </td><td> 删除没有任何链接的关键词。</td></tr>
<tr class="grey" ><td>
<a href="admin.php?f=16">清除链接</a></td><td>删除没有站点的链接。</td></tr>
<tr class="grey" ><td>
<a href="admin.php?f=17">清除临时表</a></td><td> <?print $temp;?>临时表中的项目</td></tr>
<tr class="grey" ><td>
<a href="admin.php?f=23">清理搜索日志 </a></td><td><?print $log;?>搜索日志项目
</td></tr></table> </td></tr></table></div>
<?
}
function statisticsForm ($type) {
global $mysql_table_prefix;
?>
<br><div align="center"><center><table cellpadding="3"><tr><td valign="top"><?
if ($type == "") {
$cachedSumQuery = "select sum(length(fulltxt)) from ".$mysql_table_prefix."links";
$result=mysql_query("select sum(length(fulltxt)) from ".$mysql_table_prefix."links");
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$cachedSumSize = $row[0];
}
$cachedSumSize = number_format($cachedSumSize / 1024, 2);
$sitesSizeQuery = "select sum(size) from ".$mysql_table_prefix."links";
$result=mysql_query("$sitesSizeQuery");
echo mysql_error();
if ($row=mysql_fetch_array($result)) {
$sitesSize = $row[0];
}
$sitesSize = number_format($sitesSize, 2);
$stats = getStatistics();
print "<table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr class=\"grey\"><td><b>Sites:</b></td><td align=\"center\">".$stats['sites']."</td></tr>";
print "<tr class=\"white\"><td><b>Links:</b></td><td align=\"center\"> ".$stats['links']."</td></tr>";
print "<tr class=\"grey\"><td><b>Categories:</b></td><td align=\"center\"> ".$stats['categories']."</td></tr>";
print "<tr class=\"white\"><td><b>Keywords:</b></td><td align=\"center\"> ".$stats['keywords']."</td></tr>";
print "<tr class=\"grey\"><td><b>Keyword-link realations:</b></td><td align=\"center\"> ".$stats['index']."</td></tr>";
print "<tr class=\"white\"><td><b>Cached texts total:</b></td><td align=\"center\"> $cachedSumSize kb</td></tr>";
print "<tr class=\"grey\"><td><b>Sites size total:</b></td><td align=\"center\"> $sitesSize kb</td></tr>";
print "</table></td></tr></table>";
}
if ($type=='keywords') {
$class = "grey";
print "<table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr class=\"grey\"><td><b>Keyword</b></td><td><b>Occurrences</b></td></tr>";
$result=mysql_query("select keyword, count(".$mysql_table_prefix."link_keyword.keyword_id) as x from ".$mysql_table_prefix."keywords, ".$mysql_table_prefix."link_keyword where ".$mysql_table_prefix."keywords.keyword_id = ".$mysql_table_prefix."link_keyword.keyword_id group by keyword order by x desc limit 30");
echo mysql_error();
while ($row=mysql_fetch_row($result)) {
if ($class =="white")
$class = "grey";
else
$class = "white";
$word = $row[0];
$weight = $row[1];
print "<tr class=\"$class\"><td>".$word."</td><td align=\"center\"> ".$weight."</td></tr>";
}
print "</table></td></tr></table>";
}
if ($type=='pages') {
$class = "grey";
print "<table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"2\" cellspacing = \"1\"><tr class=\"grey\"><td><b>Page</b></td><td><b>Distinct words</b></td></tr>";
$result=mysql_query("select ".$mysql_table_prefix."links.link_id, url, count(".$mysql_table_prefix."link_keyword.link_id) as x from ".$mysql_table_prefix."links, ".$mysql_table_prefix."link_keyword where ".$mysql_table_prefix."links.link_id = ".$mysql_table_prefix."link_keyword.link_id group by ".$mysql_table_prefix."links.link_id order by x desc limit 20");
echo mysql_error();
while ($row=mysql_fetch_row($result)) {
if ($class =="white")
$class = "grey";
else
$class = "white";
$url = $row[1];
$weight = $row[2];
print "<tr class=\"$class\"><td><a href=\"$url\">".$url."</td><td align= \"center\"> ".$weight."</td></tr>";
}
print "</table></td></tr></table>";
}
if ($type=='top_searches') {
$class = "grey";
print "<table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr class=\"grey\"><td><b>Query</b></td><td><b>Count</b></td><td><b> Average results</b></td><td><b>Last queried</b></td></tr>";
$result=mysql_query("select query, count(*) as c, date_format(max(time), '%Y-%m-%d %H:%i:%s'), avg(results) from ".$mysql_table_prefix."query_log group by query order by c desc");
echo mysql_error();
while ($row=mysql_fetch_row($result)) {
if ($class =="white")
$class = "grey";
else
$class = "white";
$word = $row[0];
$times = $row[1];
$date = $row[2];
$avg = number_format($row[3], 1);
print "<tr class=\"$class\"><td>".htmlentities($word)."</td><td align=\"center\"> ".$times."</td><td align=\"center\"> ".$avg."</td><td align=\"center\"> ".$date."</td></tr>";
}
print "</table></td></tr></table>";
}
if ($type=='log') {
$class = "grey";
print "<table cellspacing =\"0\" cellpadding=\"0\" class=\"darkgrey\"><tr><td><table cellpadding=\"3\" cellspacing = \"1\"><tr class=\"grey\"><td align=\"center\"><b>Query</b></td><td align=\"center\"><b>Results</b></td><td align=\"center\"><b>Queried at</b></td><td align=\"center\"><b>Time taken</b></td></tr>";
$result=mysql_query("select query, date_format(time, '%Y-%m-%d %H:%i:%s'), elapsed, results from ".$mysql_table_prefix."query_log order by time desc");
echo mysql_error();
while ($row=mysql_fetch_row($result)) {
if ($class =="white")
$class = "grey";
else
$class = "white";
$word = $row[0];
$time = $row[1];
$elapsed = $row[2];
$results = $row[3];
print "<tr class=\"$class\"><td>".htmlentities($word)."</td><td align=\"center\"> ".$results."</td><td align=\"center\"> ".$time."</td><td align=\"center\"> ".$elapsed."</td></tr>";
}
print "</table></td></tr></table>";
}
?>
</td>
<td valign="top">
<table cellspacing ="0" cellpadding="0" class="darkgrey"><tr><td>
<table cellpadding="2" cellspacing="1" width="100%">
<tr><td width="100%" class="grey">
<a href="admin.php?f=18&type=keywords">TOP 关键词</a></td></tr>
<tr><td width="100%" class="grey">
<a href="admin.php?f=18&type=pages">最热的页</a></td></tr>
<tr><td width="100%" class="grey">
<a href="admin.php?f=18&type=top_searches">最POP搜索</a></td></tr>
<tr><td width="100%" class="grey">
<a href="admin.php?f=18&type=log">搜索日志</a></td></tr>
</table>
</td></tr></table>
</td></tr></table></center></div>
<?
}
switch ($f) {
case 1:
addsite($url, $title, $short_desc, $cat);
$compurl=parse_url($url);
if ($compurl['path']=='')
$url=$url."/";
$result = mysql_query("select site_id from ".$mysql_table_prefix."sites where url='$url'");
echo mysql_error();
$row = mysql_fetch_row($result);
$site_id = $row[0];
if ($site_id != "")
siteScreen($site_id);
else
showsites();
break;
case 2:
showsites();
break;
case 3:
editsiteform($site_id);
break;
case 4:
if (!isset($cat))
$cat = "";
if ($soption =='full') {
$depth = -1;
}
editsite ($site_id, $url, $title, $short_desc, $depth, $in, $out, $cat);
showsites();
break;
case 5:
deletesite ($site_id);
showsites();
break;
case 6:
if (!isset($parent))
$parent = "";
addcatform ($parent);
break;
case 7:
addcat ($category, $parent);
list_cats (0, 0, "white");
break;
case 8:
list_cats (0, 0, "white");
break;
case 9;
editcatform($cat_id);
break;
case 10;
editcat ($cat_id, $category);
list_cats (0, 0, "white");
break;
case 11;
deletecat($cat_id);
list_cats (0, 0, "white");
break;
case 12;
if (!isset($url))
$url = "";
if (!isset($reindex))
$reindex = "";
if (isset($adv)) {
$_SESSION['index_advanced']=$adv;
}
indexscreen($url, $reindex);
break;
case 13;
addsiteform();
break;
case 14;
cleanForm();
break;
case 15;
cleanKeywords();
break;
case 16;
cleanLinks();
break;
case 17;
cleanTemp();
break;
case 18;
if (!isset($type))
$type = "";
statisticsForm($type);
break;
case 19;
siteStats($site_id);
break;
case 20;
siteScreen($site_id);
break;
case 21;
if (!isset($start))
$start = 1;
if (!isset($filter))
$filter = "";
if (!isset($per_page))
$per_page = 10;
browsePages($site_id, $start, $filter, $per_page);
break;
case 22;
deletePage($link_id);
if (!isset($start))
$start = 1;
if (!isset($filter))
$filter = "";
if (!isset($per_page))
$per_page = 10;
browsePages($site_id, $start, $filter, $per_page);
break;
case 23;
clearLog();
break;
case 24;
session_destroy();
header("Location: admin.php");
break;
case '':
showsites();
break;
}
$stats = getStatistics();
print "<p><br> <hr width=500 size=2><center>Currently in database: ".$stats['sites']." sites, ".$stats['links']." links, ".$stats['categories']." categories and ".$stats['keywords']." keywords.</p></center>\n";
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -