prefix.ADS_PAGEFILE;
$general = adswsc_GetOptions( ADS_OPTIONS_GENERAL );
if (isset($_POST['rows']))
$pageRows = (absint($_POST['rows']));
if (isset($_POST['period']))
$period = (absint($_POST['period']));
switch ($period) {
case "1": $searchDate = " and time >= ".(current_time('timestamp') - (60*60*24)); break;
case "2": $searchDate = " and time >= ".(current_time('timestamp') - (60*60*24*7)); break;
case "3": $searchDate = " and time >= ".(current_time('timestamp') - (60*60*24*7*31)); break;
default: $searchDate = ""; break;
}
if (isset($_POST['button_clean'])) {
$results = $wpdb->get_results("SELECT PageID FROM $table_name WHERE IP != '0' and PageID != 0 GROUP BY PageID");
foreach($results as $result) {
$link = get_permalink( $result->PageID, false );
$title = get_the_title( $result->PageID );
if ((empty($link) && empty($title)))
$wpdb->query("DELETE FROM $table_name WHERE IP != '0' and PageID=$result->PageID");
}
if (isset($_POST['clean_yes']) == true)
$wpdb->query("DELETE FROM $table_name WHERE IP != '0' and PageID != 0");
}
$x = $wpdb->get_results( "SELECT PageID FROM $table_name ".
" WHERE IP !='0' and PageID != 0 ".$searchDate.
" GROUP BY PageID");
$pageMaxx = sizeof($x);
$pageMax = absint($pageMaxx / $pageRows) + ( ($pageMaxx % $pageRows) > 0 ? 1 : 0);
$pageStart = 0;
if (isset($_POST['page']))
$pageStart = (absint($_POST['page'])-1);
if (isset($_POST['button_next']))
$pageStart += $pageStart < ($pageMax-1) ? 1 : 0;
if (isset($_POST['button_prev']))
$pageStart -= $pageStart > 0 ? 1 : 0;
if (isset($_POST['button_top']))
$pageStart = 0;
if (isset($_POST['button_last']))
$pageStart = $pageMax-1;
echo "".__('The table shows the number of calls for each page.', ADS_TEXT_DOMAIN).' ';
echo __('Not referring page addresses will not be displayed.' , ADS_TEXT_DOMAIN)."
";
$results = $wpdb->get_results("SELECT PageID,IP,Time,sum(Count) as Total FROM $table_name".
" WHERE PageID > 0 ".$searchDate.
" GROUP BY PageID ORDER BY Total Desc, Time Asc".
" LIMIT ".($pageStart * $pageRows).", ".$pageRows);
echo '';
echo '';
echo '| '.__('Count', ADS_TEXT_DOMAIN).' | ';
echo ''.__('page', ADS_TEXT_DOMAIN).' | ';
echo '
';
if ($results) {
$i=0;
foreach($results as $result) {
$i++;
if (($i % 2) == 1)
echo '';
else
echo '
';
echo '| '.$result->Total.' | ';
$link = get_permalink( $result->PageID, false );
$title = get_the_title($result->PageID);
if (empty($title) || empty($link) )
echo "-deleted- id:$result->PageID. | ";
else
echo "$title | ";
echo '
';
}
} else
echo '| - | '.__('no data found', ADS_TEXT_DOMAIN).' |
';
echo '
';
if ( $pageRows > 10 ) {
echo '';
}
echo '';
}
}
$adswsc_DashboardWidget = new adswsc_clsDashboardWidgets();
?>