function luc_Row($count, $feed, $spider, $agent, $color, $text, $total)
{
$visitors_color = "#114477";
$rss_visitors_color = "#FFF168";
$pageviews_color = "#3377B6";
$rss_pageviews_color = "#f38f36";
$spider_color = "#83b4d8";
$lastmonth = luc_StatPress_lastmonth();
$thismonth = gmdate('Ym', current_time('timestamp'));
$yesterday = gmdate('Ymd', current_time('timestamp') - 86400);
$today = gmdate('Ymd', current_time('timestamp'));
//TOTAL
$qry_total = requete_main($count, $feed, $spider, $agent, "1 = 1");
//LAST MONTH
$qry_lmonth = requete_main($count, $feed, $spider, $agent, "date LIKE '" . $lastmonth . "%'");
//THIS MONTH
$qry_tmonth = requete_main($count, $feed, $spider, $agent, "date LIKE '" . $thismonth . "%'");
$qry_tmonth_change = pourcent_change($qry_tmonth, $qry_lmonth);
//TARGET
$tmonthtarget = round($qry_tmonth / (time() - mktime(0, 0, 0, date('m'), date('1'), date('Y'))) * (86400 * date('t')));
$tmonthadded = pourcent_change($tmonthtarget, $qry_lmonth);
//YESTERDAY
$qry_y = $total[$yesterday];
//TODAY
$qry_t = $total[$today];
echo "<tr><td><div style='background:{$color};width:10px;height:10px;float:left;margin-top:4px;margin-right:5px;'></div>{$text}</td>\r\n\t\t<td>" . number_format_i18n($qry_total) . "</td>\n\r\n\t\t<td>" . number_format_i18n($qry_lmonth) . "</td>\n\r\n\t\t<td>" . number_format_i18n($qry_tmonth) . $qry_tmonth_change . "</td>\n\r\n\t\t<td>" . number_format_i18n($tmonthtarget) . $tmonthadded . "</td>\n\r\n\t\t<td>" . number_format_i18n($qry_y) . "</td>\n\r\n\t\t<td>" . number_format_i18n($qry_t) . "</td>\n</tr>";
}
/**
* Dashboard widget
*/
function luc_StatPresV_Dashboard_Widget()
{
global $wpdb;
$table_name = STATPRESS_V_TABLE_NAME;
if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) {
die('StatPress is not installed');
}
# Table properties
$unique_color = "#114477";
$web_color = "#3377B6";
$rss_color = "#f38f36";
$spider_color = "#83b4d8";
$lastmonth = luc_StatPress_lastmonth();
$thismonth = gmdate('Ym', current_time('timestamp'));
$yesterday = gmdate('Ymd', current_time('timestamp') - 86400);
$today = gmdate('Ymd', current_time('timestamp'));
$tlm[0] = substr($lastmonth, 0, 4);
$tlm[1] = substr($lastmonth, 4, 2);
print "<table class='widefat'><thead><tr>\n\t\t\t<th scope='col'></th>\n\t\t\t<th scope='col'>" . __('Total', 'statpress') . "</th>\n\t\t\t<th scope='col'>" . __('Yesterday', 'statpress') . "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp') - 86400) . "</font></th>\n\t\t\t<th scope='col'>" . __('Today', 'statpress') . "<br /><font size=1>" . gmdate('d M, Y', current_time('timestamp')) . "</font></th>\n\t\t\t</tr></thead>\n\t\t\t<tbody id='the-list'>";
################################################################################################
# VISITORS ROW
print "<tr><td>" . __('Visitors', 'statpress') . "</td>";
#TOTAL
$qry_total = $wpdb->get_var("\n\t\t\t\t\tSELECT count(DISTINCT ip)\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed = ''\n\t\t\t\t\t\tAND spider = ''\n\t\t\t\t\t");
echo "<td>" . $qry_total . "</td>\n";
$qry = $wpdb->get_results("\n\t\t\t\t\tSELECT date, COUNT(DISTINCT ip) as total\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed = ''\n\t\t\t\t\t\tAND spider = ''\n\t\t\t\t\t\tAND date BETWEEN {$yesterday} AND {$today}\n\t\t\t\t\tGROUP BY date");
echo luc_print_dashstats($yesterday, $today, $qry);
echo "</tr>";
################################################################################################
# PAGE VIEWS ROW
print "<tr><td>" . __('Page Views', 'statpress') . "</td>";
#TOTAL
$qry_total = $wpdb->get_var("\n\t\t\t\t\tSELECT COUNT(date)\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed = ''\n\t\t\t\t\t\tAND spider = ''\n\t\t\t\t\t");
echo "<td>" . $qry_total . "</td>\n";
$qry = $wpdb->get_results("\n\t\t\t\t\tSELECT date, COUNT(date) as total\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed = ''\n\t\t\t\t\t\tAND spider = ''\n\t\t\t\t\t\tAND date BETWEEN {$yesterday} AND {$today}\n\t\t\t\t\tGROUP BY date");
echo luc_print_dashstats($yesterday, $today, $qry);
echo "</tr>";
################################################################################################
# SPIDERS ROW
print "<tr><td>Spiders</td>";
#TOTAL
$qry_total = $wpdb->get_var("\n\t\t\t\t\tSELECT COUNT(date)\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed = ''\n\t\t\t\t\t\tAND spider <> ''\n\t\t\t\t\t");
print "<td>" . $qry_total . "</td>\n";
$qry = $wpdb->get_results("\n\t\t\t\t\tSELECT date, COUNT(date) as total\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed = ''\n\t\t\t\t\t\tAND spider <> ''\n\t\t\t\t\t\tAND date BETWEEN {$yesterday} AND {$today}\n\t\t\t\t\tGROUP BY date");
echo luc_print_dashstats($yesterday, $today, $qry);
echo "</tr>";
################################################################################################
# FEEDS ROW
print "<tr><td>Feeds</td>";
#TOTAL
$qry_total = $wpdb->get_var("\n\t\t\t\t\tSELECT count(date)\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed <> ''\n\t\t\t\t\t\tAND spider = ''\n\t\t\t\t\t");
print "<td>" . $qry_total . "</td>\n";
$qry = $wpdb->get_results("\n\t\t\t\t\tSELECT date, COUNT(date) as total\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tWHERE feed <> ''\n\t\t\t\t\t\tAND spider = ''\n\t\t\t\t\t\tAND date BETWEEN {$yesterday} AND {$today}\n\t\t\t\t\tGROUP BY date");
echo luc_print_dashstats($yesterday, $today, $qry);
echo "</tr>";
##################################################################################################
$qry_s = $wpdb->get_var("\n\t\t\t\t\tSELECT date\n\t\t\t\t\tFROM {$table_name}\n\t\t\t\t\tLIMIT 1;\n\t\t\t\t\t");
$cstart = strtotime($qry_s);
$cstart = date("d.m.Y", $cstart);
print "<tr><td><i>Counter Start</i></td>";
print "<td colspan='3'><i>{$cstart}</i></td>\n";
print "</table><br />\n\n";
// More Details link
print "<div class='wrap'><a href='admin.php?page=statpress-visitors/admin/luc_admin.php'>" . __('More details', 'statpress') . " »</a></div>";
luc_StatPressV_load_time();
}
