function luc_StatPressUpdate($action)
{
global $wpdb;
$table_name = $wpdb->prefix . "statpress";
print "<div class='wrap'><h2>" . __('Update', 'statpress') . "</h2>";
// THE GRAPHS
// last "N" days graph NEW
$graphdays = get_option('statpress_daysinoverviewgraph');
if ($graphdays == 0) {
$graphdays = 7;
}
if (isset($_GET['pp'])) {
// Get Current page from URL
$pagePeriode = $_GET['pp'];
if ($pagePeriode <= 0) {
// Page is less than 0 then set it to 1
$pagePeriode = 1;
}
} else {
// URL does not show the page set it to 1
$pagePeriode = 1;
}
$strqry = "SELECT date FROM {$table_name} WHERE (ip IS NOT NULL) ORDER BY date ASC LIMIT 1";
$query = $wpdb->get_row($strqry);
$old_date = $query->date;
$nbjours = round((current_time('timestamp') - strtotime($old_date)) / 86400 - 1);
$NumberOfPagesPeriode = $nbjours / $graphdays;
$LimitValue = $pagePeriode * $graphdays - $graphdays;
$limitdate = gmdate('Ymd', current_time('timestamp') - 86400 * $graphdays * $pagePeriode + 86400);
$currentdate = gmdate('Ymd', current_time('timestamp') - 86400 * $graphdays * ($pagePeriode - 1));
$start_of_week = get_option('start_of_week');
print "Period of days : ";
luc_printperiodelink($NumberOfPagesPeriode, $pagePeriode, $action);
print '<table width="100%" border="0"><tr>';
for ($i = 0; $i < $graphdays; $i++) {
print '<td width="' . $gd . '" valign="bottom"';
if ($start_of_week == gmdate('w', current_time('timestamp') - 86400 * ($graphdays * $pagePeriode - $i - 1))) {
// week-cut
print ' style="border-left:2px dotted gray;"';
}
print "><div style='float:left;height: 100%;width:100%;font-family:Helvetica;font-size:7pt;text-align:center;border-right:1px solid white;color:black;'>\n <div style='background:gray;width:100%;height:1px;'></div>\n <br />" . gmdate('d', current_time('timestamp') - 86400 * ($graphdays * $pagePeriode - $i - 1)) . ' ' . gmdate('M', current_time('timestamp') - 86400 * ($graphdays * $pagePeriode - $i - 1)) . "</div></td>\n";
}
print '</tr></table>';
print '</div>';
if ($action != 'upSE') {
$wpdb->show_errors();
// update table
print "" . __('Updating table struct', 'statpress') . " {$table_name}... ";
iri_StatPress_CreateTable();
print "" . __('done', 'statpress') . "<br>";
// Update Feed
print "" . __('Updating Feeds', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET feed='' WHERE date BETWEEN {$limitdate} AND {$currentdate}");
// standard blog info urls
$s = iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='COMMENT ATOM' WHERE INSTR(urlrequested,'{$s}')>0 AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='COMMENT RSS' WHERE INSTR(urlrequested,'{$s}')>0 AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('atom_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='ATOM' WHERE INSTR(urlrequested,'{$s}')>0 AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('rdf_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='RDF' WHERE INSTR(urlrequested,'{$s}')>0 AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('rss_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='RSS' WHERE INSTR(urlrequested,'{$s}')>0 AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('rss2_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE INSTR(urlrequested,'{$s}')>0 AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
}
// not standard
$wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE urlrequested LIKE '%/feed%' AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
$wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE urlrequested LIKE '%wp-feed.php%' AND date BETWEEN {$limitdate} AND {$currentdate} AND feed=''");
print "" . __('done', 'statpress') . "<br>";
// Update OS
print "" . __('Updating OS', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET os = '' WHERE date BETWEEN {$limitdate} AND {$currentdate}");
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/os.dat');
foreach ($lines as $line_num => $os) {
list($nome_os, $id_os) = explode("|", $os);
$qry = "UPDATE {$table_name} SET os = '{$nome_os}' WHERE date BETWEEN {$limitdate} AND {$currentdate} AND os='' AND replace(agent,' ','') LIKE '%" . $id_os . "%'";
$wpdb->query($qry);
}
print "" . __('done', 'statpress') . "<br>";
// Update Browser
print "" . __('Updating Browsers', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET browser = '' WHERE date BETWEEN {$limitdate} AND {$currentdate}");
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/browser.dat');
foreach ($lines as $line_num => $browser) {
list($nome, $id) = explode("|", $browser);
$qry = "UPDATE {$table_name} SET browser = '{$nome}' WHERE browser='' AND date BETWEEN {$limitdate} AND {$currentdate} \n\t\t\t AND replace(agent,' ','') LIKE '%" . $id . "%'";
$wpdb->query($qry);
}
print "" . __('done', 'statpress') . "<br>";
print "" . __('Updating Spiders', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET spider = '' WHERE date BETWEEN {$limitdate} AND {$currentdate}");
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/spider.dat');
if (file_exists(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/spider.dat')) {
$lines = array_merge($lines, file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '-custom/spider.dat'));
}
foreach ($lines as $line_num => $spider) {
list($nome, $id) = explode("|", $spider);
$qry = "UPDATE {$table_name} SET spider = '{$nome}',os='',browser='' WHERE spider='' AND date BETWEEN {$limitdate} AND {$currentdate} AND replace(agent,' ','') LIKE '%" . $id . "%'";
$wpdb->query($qry);
}
print "" . __('done', 'statpress') . "<br>";
} else {
// Update Search engine
print "" . __('Updating Search engines', 'statpress') . "... ";
print "<br>";
//$wpdb->query("UPDATE $table_name SET searchengine = '', search='';");
print "..." . __('null-ed', 'statpress') . "!<br>";
$qry = $wpdb->get_results("SELECT id, referrer FROM {$table_name} WHERE referrer <> '' AND date BETWEEN {$limitdate} AND {$currentdate} \n\t\t AND referrer NOT LIKE '%" . get_bloginfo('url') . "%'");
print "..." . __('select-ed', 'statpress') . "!<br>";
foreach ($qry as $rk) {
list($searchengine, $search_phrase) = explode("|", iriGetSE($rk->referrer));
if ($searchengine != '') {
$q = "UPDATE {$table_name} SET searchengine = '{$searchengine}', search='" . addslashes($search_phrase) . "' WHERE date BETWEEN {$limitdate} AND {$currentdate} AND id=" . $rk->id;
$wpdb->query($q);
}
}
print "" . __('done', 'statpress') . "<br>";
$wpdb->hide_errors();
}
print "<br> <h1>" . __('Updated', 'statpress') . "!</h1>";
print "</DIV>";
}
function iriStatPressUpdate()
{
global $wpdb;
$table_name = $wpdb->prefix . "statpress";
$wpdb->show_errors();
// update table
print "" . __('Updating table struct', 'statpress') . " {$table_name}... ";
iri_StatPress_CreateTable();
print "" . __('done', 'statpress') . "<br>";
// Update Feed
print "" . __('Updating Feeds', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET feed='';");
// standard blog info urls
$s = iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='COMMENT ATOM' WHERE INSTR(urlrequested,'{$s}')>0 AND feed='';");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='COMMENT RSS' WHERE INSTR(urlrequested,'{$s}')>0 AND feed='';");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('atom_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='ATOM' WHERE INSTR(urlrequested,'{$s}')>0 AND feed='';");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('rdf_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='RDF' WHERE INSTR(urlrequested,'{$s}')>0 AND feed='';");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('rss_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='RSS' WHERE INSTR(urlrequested,'{$s}')>0 AND feed='';");
}
$s = iri_StatPress_extractfeedreq(get_bloginfo('rss2_url'));
if ($s != '') {
$wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE INSTR(urlrequested,'{$s}')>0 AND feed='';");
}
// not standard
$wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE urlrequested LIKE '%/feed%' AND feed='';");
$wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE urlrequested LIKE '%wp-feed.php%' AND feed='';");
print "" . __('done', 'statpress') . "<br>";
// Update OS
print "" . __('Updating OS', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET os = '';");
$lines = file(dirname(plugin_basename(__FILE__)) . '/def/os.dat');
foreach ($lines as $line_num => $os) {
list($nome_os, $id_os) = explode("|", $os);
$qry = "UPDATE {$table_name} SET os = '{$nome_os}' WHERE os='' AND replace(agent,' ','') LIKE '%" . $id_os . "%';";
$wpdb->query($qry);
}
print "" . __('done', 'statpress') . "<br>";
// Update Browser
print "" . __('Updating Browsers', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET browser = '';");
$lines = file(dirname(plugin_basename(__FILE__)) . '/def/browser.dat');
foreach ($lines as $line_num => $browser) {
list($nome, $id) = explode("|", $browser);
$qry = "UPDATE {$table_name} SET browser = '{$nome}' WHERE browser='' AND replace(agent,' ','') LIKE '%" . $id . "%';";
$wpdb->query($qry);
}
print "" . __('done', 'statpress') . "<br>";
print "" . __('Updating Spiders', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET spider = '';");
$lines = file(dirname(plugin_basename(__FILE__)) . '/def/spider.dat');
if (file_exists(dirname(plugin_basename(__FILE__)) . '-custom/spider.dat')) {
$lines = array_merge($lines, file(dirname(plugin_basename(__FILE__)) . '-custom/spider.dat'));
}
foreach ($lines as $line_num => $spider) {
list($nome, $id) = explode("|", $spider);
$qry = "UPDATE {$table_name} SET spider = '{$nome}',os='',browser='' WHERE spider='' AND replace(agent,' ','') LIKE '%" . $id . "%';";
$wpdb->query($qry);
}
print "" . __('done', 'statpress') . "<br>";
// Update feed to ''
print "" . __('Updating Feeds', 'statpress') . "... ";
$wpdb->query("UPDATE {$table_name} SET feed = '' WHERE isnull(feed);");
print "" . __('done', 'statpress') . "<br>";
// Update Search engine
print "" . __('Updating Search engines', 'statpress') . "... ";
print "<br>";
$wpdb->query("UPDATE {$table_name} SET searchengine = '', search='';");
print "..." . __('null-ed', 'statpress') . "!<br>";
$qry = $wpdb->get_results("SELECT id, referrer FROM {$table_name} WHERE referrer !=''");
print "..." . __('select-ed', 'statpress') . "!<br>";
foreach ($qry as $rk) {
list($searchengine, $search_phrase) = explode("|", iriGetSE($rk->referrer));
if ($searchengine != '') {
$q = "UPDATE {$table_name} SET searchengine = '{$searchengine}', search='" . addslashes($search_phrase) . "' WHERE id=" . $rk->id;
$wpdb->query($q);
}
}
print "" . __('done', 'statpress') . "<br>";
$wpdb->hide_errors();
print "<br> <h1>" . __('Updated', 'statpress') . "!</h1>";
}
function iriStatPressUpdate()
{
if ($_POST['updateit'] == 'yes') {
//$_POST，HTTP POST变量
global $wpdb;
$table_name = $wpdb->prefix . "statpress";
$wpdb->show_errors();
print "<br /><div class='updated'>";
# update table
print __("Updating table's struct: ", "statpresscn") . $table_name . ". ";
iri_StatPress_CreateTable();
print __('done', 'statpresscn') . "<br>";
// Auto-delete visits if...
if ($_POST['statpress_updatesets_longth'] != '') {
iri_update_manuplate_sets_autodelete();
}
//manuplate the baned ip
if ($_POST['statpress_updatesets_banip'] != '') {
$results = 0;
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/banips.dat');
foreach ($lines as $line_num => $banip) {
if (preg_match("@^(\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.(?:\\d{1,3})?)(\\s+evil)?\$@i", trim($banip), $matches)) {
$iprule = $matches[1];
if (strlen(rtrim($iprule)) > 0) {
$results += $wpdb->query("DELETE FROM " . $table_name . " WHERE ip like '{$iprule}%'");
}
}
}
print $results . __("items have been deleted", "statpresscn") . ". " . __('done', 'statpresscn') . "<br>";
}
//upate urlrequested based post id or page id
if ($_POST['statpress_updatesets_url'] != '') {
iri_update_staturl_based_new_permalink_structure();
}
# Update Feed
if ($_POST['statpress_updatesets_feed'] != '') {
print "" . __("Updating Feeds", "statpresscn") . ": ";
# not standard
$setcount = $wpdb->query("UPDATE {$table_name} SET feed='RSS2' WHERE urlrequested REGEXP '(^(/tag){0}/feed/?\$|^(/tag){0}/rss2?|^/wp-feed\\.php)';");
print $setcount . " sets are set to RSS2, they are non-standard feeds like (^(/tag){0}/feed/?\$|^(/tag){0}/rss2?|^/wp-feed\\.php), as regexp; ";
# standard blog info urls
$setcount = 0;
$s = iri_StatPress_extractfeedreq(get_bloginfo('comments_atom_url'));
if ($s != '') {
$tmpcount = $wpdb->query("UPDATE {$table_name} SET feed='COMMENT ATOM' WHERE urlrequested REGEXP '{$s}';");
print $tmpcount . " sets like " . $s . " are updated, ";
}
$setcount += $tmpcount;
$s = iri_StatPress_extractfeedreq(get_bloginfo('comments_rss2_url'));
if ($s != '') {
$tmpcount = $wpdb->query("UPDATE {$table_name} SET feed='COMMENT RSS' WHERE urlrequested REGEXP '{$s}';");
print $tmpcount . " sets like " . $s . " are updated, ";
}
$setcount += $tmpcount;
$s = iri_StatPress_extractfeedreq(get_bloginfo('atom_url'));
//http://localhost/feed/atom
if ($s != '') {
$tmpcount = $wpdb->query("UPDATE {$table_name} SET feed='ATOM' WHERE urlrequested REGEXP '{$s}';");
print $tmpcount . " sets like " . $s . " are updated, ";
}
$setcount += $tmpcount;
$s = iri_StatPress_extractfeedreq(get_bloginfo('rdf_url'));
if ($s != '') {
$tmpcount = $wpdb->query("UPDATE {$table_name} SET feed='RDF' WHERE urlrequested REGEXP '{$s}';");
print $tmpcount . " sets like " . $s . " are updated, ";
}
$setcount += $tmpcount;
$s = iri_StatPress_extractfeedreq(get_bloginfo('rss_url'));
if ($s != '') {
$tmpcount = $wpdb->query("UPDATE {$table_name} SET feed='RSS' WHERE urlrequested REGEXP '{$s}';");
print $tmpcount . " sets like " . $s . " are updated, ";
}
$setcount += $tmpcount;
print "totally " . $setcount . " sets are updated, they are standard feed." . __('done', 'statpresscn') . "<br>";
}
# Update OS
if ($_POST['statpress_updatesets_os'] != '') {
print __("Updating OSes", "statpresscn") . ": ";
$setcount = $wpdb->query("UPDATE {$table_name} SET os = '';");
print $setcount . " sets are set to blank. ";
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/os.dat');
$setcount = 0;
foreach ($lines as $line_num => $os) {
list($nome_os, $id_os) = explode("|", $os);
$qry = "UPDATE {$table_name} SET os = '{$nome_os}' WHERE os='' and replace(agent,' ','') REGEXP '{$id_os}';";
$setcount += $wpdb->query($qry);
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
}
# Update Browser
if ($_POST['statpress_updatesets_browser'] != '') {
print __("Updating Browsers", "statpresscn") . ": ";
$setcount = $wpdb->query("UPDATE {$table_name} SET browser = '';");
print $setcount . " sets are set to blank. ";
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/browser.dat');
$setcount = 0;
foreach ($lines as $line_num => $browser) {
list($nome, $id) = explode("|", $browser);
$qry = "UPDATE {$table_name} SET browser = '{$nome}' WHERE browser='' AND replace(agent,' ','') REGEXP '{$id}';";
$setcount += $wpdb->query($qry);
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
}
# Update Spider
if ($_POST['statpress_updatesets_spider'] != '') {
print __("Updating Spiders", "statpresscn") . ": ";
$setcount = $wpdb->query("UPDATE {$table_name} SET spider = '';");
print $setcount . __(" sets is set to blank! ", "statpresscn");
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/spider.dat');
$setcount = 0;
foreach ($lines as $line_num => $spider) {
list($nome, $id) = explode("|", $spider);
$qry = "UPDATE {$table_name} SET spider = '{$nome}',os='',browser='' WHERE spider='' AND replace(agent,' ','') REGEXP '{$id}';";
$setcount += $wpdb->query($qry);
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
iri_update_manuplate_sets_with_spider();
}
# Update Search engine
if ($_POST['statpress_updatesets_searchengine'] != '') {
print __("Updating Search engines", "statpresscn") . ": ";
$setcount = $wpdb->query("UPDATE {$table_name} SET searchengine = '', search='';");
print $setcount . __(" sets is set to blank! ", "statpresscn");
$qry = $wpdb->get_results("SELECT id, referrer FROM {$table_name}");
print count($qry) . __(" are select-ed", "statpresscn") . ", ";
$setcount = 0;
foreach ($qry as $rk) {
list($searchengine, $search_phrase) = explode("|", iriGetSE($rk->referrer));
if ($searchengine != '') {
$q = "UPDATE {$table_name} SET searchengine = '{$searchengine}', search='" . addslashes($search_phrase) . "' WHERE id=" . $rk->id;
$setcount += $wpdb->query($q);
}
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
}
//Update ip info
if ($_POST['statpress_updatesets_domain'] != '') {
echo __("Updating sets for ip info : ", "statpresscn");
$qry = $wpdb->get_results("SELECT id, ip FROM {$table_name}");
print count($qry) . __(" are select-ed", "statpresscn") . ", ";
$setcount = 0;
foreach ($qry as $rk) {
$ipinfo = iriDomain($rk->ip);
if ($ipinfo != '') {
$q = "UPDATE {$table_name} SET nation = '{$ipinfo}' WHERE id=" . $rk->id;
$setcount += $wpdb->query($q);
}
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
}
//Update ip info(partly, which is null)142.68.234.144
if ($_POST['statpress_updatesets_domain_partly'] != '') {
echo __("Updating sets whose ip info is null: ", "statpresscn");
$qry = $wpdb->get_results("SELECT id, ip FROM {$table_name} where nation='' order by id desc limit 10");
print count($qry) . __(" are select-ed", "statpresscn") . ", ";
$setcount = 0;
foreach ($qry as $rk) {
$ipinfo = iriDomain($rk->ip);
if ($ipinfo != '') {
$q = "UPDATE {$table_name} SET nation = '{$ipinfo}' WHERE id=" . $rk->id;
$setcount += $wpdb->query($q);
}
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
}
//Update ip def
if ($_POST['statpress_updatesets_defip'] != '') {
echo __("Updating sets whose ip is named in defip.dat: ", "statpresscn");
$setcount = 0;
$lines = file(ABSPATH . 'wp-content/plugins/' . dirname(plugin_basename(__FILE__)) . '/def/defip.dat');
print "There are " . count($lines) . " ips being named.<br>";
foreach ($lines as $line_num => $ipentry) {
list($ip, $name) = explode("|", $ipentry);
if (strlen($ip) > 0 && strlen($name) > 0) {
$q = "UPDATE {$table_name} SET user = '******' WHERE ip='{$ip}' and (user='' or user is null)";
$setcount += $wpdb->query($q);
}
}
print $setcount . __(" are updated", "statpresscn") . "!<br>";
}
//Update ip info(partly, which is null)142.68.234.144
if ($_POST['statpress_updatesets_del404'] != '') {
echo __("Deleting sets whose statuscode is 404: ", "statpresscn");
$setcount = $wpdb->query("DELETE FROM " . $table_name . " WHERE statuscode = '404'");
print $setcount . __(" are deleted", "statpresscn") . "!<br>";
}
echo __("Cleaning spam commenters: ", "statpresscn");
$qry = $wpdb->get_results("SELECT comment_author_IP as ip FROM {$wpdb->comments} where comment_approved = 'spam'");
print count($qry) . __(" are select-ed", "statpresscn") . ", ";
$setcount = 0;
foreach ($qry as $rk) {
$q = "DELETE from {$table_name} where ip = '{$rk->ip}'";
$setcount += $wpdb->query($q);
}
print $setcount . __(" are deleted", "statpresscn") . "!<br>";
//删除对连接/wp-signup.php请求的访问记录
// $results = $wpdb->query( "DELETE FROM " . $table_name . " WHERE urlrequested like '/wp-signup.php'");
// print ($results>0?$results." sets have been deleted, which are like /wp-signup.php.<br>":"");
//删除对连接/2008 /page请求的访问记录
// $results = $wpdb->query( "DELETE FROM " . $table_name . " WHERE urlrequested = '/2008' or urlrequested = '/2008/' or urlrequested = '/page' or urlrequested = '/page/'");
// print ($results>0?$results." sets have been deleted, which are like /2008 or /page.<br>":"");
$wpdb->hide_errors();
print "<br> <h1>" . __('Updated', 'statpresscn') . "!</h1> Query count is :" . get_num_queries() . "</div>";
}
?>
<div class='wrap'>
<style type="text/css">
TABLE {
width: 100%;
border-collapse: separate;
border-spacing: 10pt;}
TD {
background: white;
border-bottom: ridge 1pt;}
TH { border: outset 2pt gray; }
</style>
<form method=post>
<table>
<COLGROUP><COL WIDTH=50% ALIGN=left ><COL ALIGN=left></COLGROUP>
<tr>
<td><input type=checkbox name='statpress_updatesets_spider' value='checked'> <?php
_e('Update all sets for spider', 'statpresscn');
?>
</td>
<td><input type=checkbox name='statpress_updatesets_longth' value='checked'> <?php
_e('Update all sets based longth you configure', 'statpresscn');
?>
</td>
</tr>
<tr>
<td><input type=checkbox name='statpress_updatesets_banip' value='checked'> <?php
_e('Update all sets for banip', 'statpresscn');
?>
</td>
<td><input type=checkbox name='statpress_updatesets_url' value='checked'> <?php
_e('Update all sets for urlrequested', 'statpresscn');
?>
</td>
</tr>
<tr>
<td><input type=checkbox name='statpress_updatesets_os' value='checked'> <?php
_e('Update all sets for O.S.', 'statpresscn');
?>
</td>
<td><input type=checkbox name='statpress_updatesets_browser' value='checked'> <?php
_e('Update all sets for browser', 'statpresscn');
?>
</td>
</tr>
<tr>
<td><input type=checkbox name='statpress_updatesets_searchengine' value='checked'> <?php
_e('Update all sets for search engine', 'statpresscn');
?>
</td>
<td><input type=checkbox name='statpress_updatesets_feed' value='checked'> <?php
_e('Update all sets for feed', 'statpresscn');
?>
</td>
</tr>
<tr>
<td><input type=checkbox name='statpress_updatesets_domain' value='checked'> <?php
_e('Update all sets for ip info', 'statpresscn');
?>
</td>
<td><input type=checkbox name='statpress_updatesets_domain_partly' value='checked'> <?php
_e('Update sets partly, whose ip info is null', 'statpresscn');
?>
</td>
</tr>
<tr>
<td><input type=checkbox name='statpress_updatesets_del404' value='checked'> <?php
_e('Delete all 404 visits', 'statpresscn');
?>
</td>
<td><input type=checkbox name='statpress_updatesets_defip' value='checked'> <?php
_e('Update sets partly, whose name is null', 'statpresscn');
?>
</td>
</tr>
<tr><td align=center colspan=2 style="border:dashed 1px blue;"><input type=submit value="<?php
_e('Update stat data', 'statpresscn');
?>
"></td>
</tr>
</table>
<input type=hidden name=updateit value=yes>
<input type=hidden name=page value=statpresscn><input type=hidden name=statpress_action value=update>
</form>
</div>
<?php
heart5_print_spc_footer();
}
