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