function update_all_links()
{
global $db;
$day = intval($_GET["day"]);
if (!empty($day)) {
$sql = "select * from ve123_links where updatetime<='" . (time() - 86400 * $day) . "'";
} else {
$sql = "select * from ve123_links";
}
//echo $sql;echo date("Y-m-d H:i:s",(time()-(86400*$day)));die();
$result = $db->query($sql);
$total = $db->num_rows($result);
//记录总数i
if ($total <= 0) {
header("location:links.php");
exit;
}
$pagesize = 5;
//每页显示数
$totalpage = ceil($total / $pagesize);
$page = intval($_GET["page"]);
if ($page <= 0) {
$page = 1;
}
$offset = ($page - 1) * $pagesize;
$query = $db->query($sql . " limit {$offset},{$pagesize}");
$str = "<html><head><title></title><link rel=\"stylesheet\" href=\"images/maincss.css\">";
$str .= "<meta http-equiv='Content-Type' content='text/html; charset=gb2312'></head><body >";
$str .= "<b>网站正在更新中……请稍候！<font color='red'>在此过程中请勿刷新此页面！！！</font></b><br>总共需要更新 <font color='red'><b>{$total}</b></font> 个网站，每页更新 <font color='red'><b>{$pagesize}</b></font> 个网站，共需要分 <font color='red'><b>{$totalpage}</b></font> 页更新，当前正在更新 <font color='red'><b>{$page}</b></font> 页<br>";
while ($row = $db->fetch_array($query)) {
add_update_link($row["url"], "", "", "update");
$str .= $row["url"] . "<br>";
}
if ($page <= $totalpage) {
$str .= "<meta http-equiv=\"refresh\" content=3;url='?action=update_all_links&day=" . $day . "&page=" . ($page + 1) . "'>";
$str .= "</body></html>";
} else {
$str .= "更新完毕<br>";
$str .= "<a href=\"links.php\">返回上一页</a>";
$str .= "</body></html>";
}
echo $str;
exit;
}
function add_new_page_step_2($site_id, $level)
{
global $db;
$sql = "select * from ve123_links_temp where site_id='" . $site_id . "' and updatetime='" . $level . "'";
$query = $db->query($sql);
$total = $db->num_rows($query);
//记录总数
$pagesize = 10;
//每页显示数
$totalpage = ceil($total / $pagesize);
$page = intval($_GET["page"]);
if ($page <= 0) {
$page = 1;
}
$offset = ($page - 1) * $pagesize;
$sql = $sql . " limit {$offset},{$pagesize}";
echo $sql;
//die();
$query = $db->query($sql);
// $str="<html><head><title></title><link rel=\"stylesheet\" href=\"images/maincss.css\">";
// $str.="<meta http-equiv='Content-Type' content='text/html; charset=gb2312'></head><body >";
$str .= "<b>网站正在收录中……请稍候!<br>总共需要收录 <font color='red'><b>{$total}</b></font> 个网页，每页收录 <font color='red'><b>{$pagesize}</b></font> 个网站，共需要分 <font color='red'><b>{$totalpage}</b></font> 页，当前正在收录 <font color='red'><b>{$page}</b></font> 页<br>";
// flush();
while ($row = $db->fetch_array($query)) {
$query_links = $db->query("select * from ve123_links where url='" . $row["url"] . "'");
$num = $db->num_rows($query_links);
if ($num == 0) {
add_update_link($row["url"], $site_id, $level, "add");
}
$str = $str . $row["url"] . "<br>";
}
if ($page <= $totalpage) {
$str .= "<a href=\"sites.php?action=options&site_id=" . $site_id . "\">点此停止收录</a>";
$str .= "<meta http-equiv=\"refresh\" content=3;url='?action=add_new_page_step_2&site_id=" . $site_id . "&updatetime=" . $level . "&page=" . ($page + 1) . "'>";
} else {
$str .= "收录完毕<br>";
$str .= "<a href=\"sites.php?action=options&site_id=" . $site_id . "\">返回上一页</a>";
}
$str .= "</body></html>";
echo $str;
die;
}
