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; }