Error: Logging database table does not exist! Try clicking "Create log DB"
';
exit();
}
$table_width_html = "";
adlog_results_table();
function adlog_results_table(){
global $wpdb;
$adlog_table = adlog_table_name();
$count = $wpdb->get_var("SELECT COUNT(*) FROM $adlog_table");
$offset = adlog_get_param('o', 6);
$query = adlog_get_param('q', 50);
$ops = adlog_options();
$rows_per_page = $ops['ui_num_rows_per_page'];
if ($count > 1){
$num_pages = ceil($count / $rows_per_page);
} else {
$num_pages = 1;
}
$page = 0;
if (isset($_GET['o'])){
$page = $_GET['o'];
if ($page < 0) $page = 0;
if ($page >= $num_pages) $page = $num_pages-1;
}
$offset = $rows_per_page * $page;
if (adlog_ticked('debug_mode')) $debugquery = ", Debug";
if (adlog_ticked('ui_show_size')) $sizequery = ", Size";
if (adlog_ticked('ui_show_unit')) $unitquery = ", Unit";
if (adlog_ticked('ui_show_referrer')) $referrerquery = ", Referrer";
if (adlog_ticked('ui_show_ip')) $ipquery = ", IP";
if (adlog_ticked('ui_show_browser')) $browserquery = ", Browser";
if (adlog_ticked('ui_show_src')) $sourcequery = ", Src";
global $table_width_html;
$table_width_html = "";
$sql = "";
if ($query == 'IPCount'){
$sql = "SELECT COUNT(*) AS Clicks, IP FROM " . $adlog_table . " GROUP BY IP ORDER BY Clicks DESC LIMIT $rows_per_page OFFSET $offset";
} else if ($query == 'PageCount'){
$sql = "SELECT COUNT(*) AS Clicks, Page FROM " . $adlog_table . " GROUP BY Page ORDER BY Clicks DESC LIMIT $rows_per_page OFFSET $offset";
} else if ($query == 'ReferrerCount'){
$sql = "SELECT COUNT(*) AS Clicks, Referrer FROM " . $adlog_table . " GROUP BY Referrer ORDER BY Clicks DESC LIMIT $rows_per_page OFFSET $offset";
} else if ($query == 'BrowserCount'){
$sql = "SELECT COUNT(*) AS Clicks, Browser FROM " . $adlog_table . " GROUP BY Browser ORDER BY Clicks DESC LIMIT $rows_per_page OFFSET $offset";
} else if ($query == 'TypeCount'){
$sql = "SELECT COUNT(*) AS Clicks, Type FROM " . $adlog_table . " GROUP BY Type ORDER BY Clicks DESC LIMIT $rows_per_page OFFSET $offset";
} else {
$table_width_html = " width='100%'";
$sql = "SELECT ID, Type, Date $sizequery $unitquery, Page $referrerquery $ipquery $browserquery $sourcequery $debugquery FROM " . $adlog_table . " ORDER BY ID DESC LIMIT $rows_per_page OFFSET $offset";
}
?>
";
}
function adlog_print_table($query) {
$ops = adlog_options();
if (adlog_ticked('debug_mode')) echo "DebugMode: Query: $query
";
global $wpdb;
$results = $wpdb->get_results($query);
if ($results === false) die("Error with: $query
Msg: ".$wpdb->last_error);
echo '
';
global $table_width_html;
echo "";
echo '';
$column_names = array();
// Output headers
$columns = $wpdb->get_col_info('name');
foreach($columns as $column){
echo "| $column | ";
$column_names[] = $column;
}
echo '
';
if (count($results)== 0) die("
The logging table is currently empty.
If you have just installed the plugin and want to try it with some example data you can add some test data from the 'Testing the plugin' section below. Then click the 'Refresh' link above the table to see the new data.
");
// Output data
$count = 1;
foreach ($results as $row) {
if ($count % 2 == 0){
echo '';
} else {
echo "
";
}
$col_num = 0;
foreach ($row as $column) {
if ($column_names[$col_num] == 'ID'){
echo "| $column | ";
} else if ($column_names[$col_num] == 'Type'){
echo "![](".plugins_url()."/ad-logger/images/";
switch ($column){
case 1:
echo ) | ";
} else if ($column_names[$col_num] == 'IP'){
$column = long2ip($column);
if ($column == "0.0.0.0"){
echo "$column (could not retrieve IP) | ";
} else {
echo "$column | ";
}
} else if ($column_names[$col_num] == 'Page' || $column_names[$col_num] == 'Referrer'){
echo "$column | ";
} else if ($column_names[$col_num] == 'Browser') {
echo "$column | ";
} else if ($column_names[$col_num] == 'Debug'){
echo "$column | ";
} else {
echo "$column | ";
}
++$col_num;
}
echo "
\n";
++$count;
}
echo "\n";
}
function adlog_get_param($param, $max_length=128) {
if(isset($_GET[$param])) {
return mysql_real_escape_string(substr($_GET[$param],0,$max_length));
}
return "";
}
?>