function iriValueTable($fld, $fldtitle, $limit = 0, $param = "", $queryfld = "", $exclude = "")
{
/* Maddler 04112007: param addedd */
global $wpdb;
$table_name = $wpdb->prefix . "statpress";
if ($queryfld == '') {
$queryfld = $fld;
}
print "<div class='wrap'><h2>{$fldtitle}</h2><table style='width:100%;padding:0px;margin:0px;' cellpadding=0 cellspacing=0><thead><tr><th style='width:400px;background-color:white;'></th><th style='width:150px;background-color:white;'><u>" . __('Visits', 'statpress') . "</u></th><th style='background-color:white;'></th></tr></thead>";
print "<tbody id='the-list'>";
$rks = $wpdb->get_var("SELECT count({$param} {$queryfld}) as rks FROM {$table_name} WHERE 1=1 {$exclude};");
if ($rks > 0) {
$sql = "SELECT count({$param} {$queryfld}) as pageview, {$fld} FROM {$table_name} WHERE 1=1 {$exclude} GROUP BY {$fld} ORDER BY pageview DESC";
if ($limit > 0) {
$sql = $sql . " LIMIT {$limit}";
}
$qry = $wpdb->get_results($sql);
$tdwidth = 450;
$red = 131;
$green = 180;
$blue = 216;
$deltacolor = round(250 / count($qry), 0);
// $chl="";
// $chd="t:";
foreach ($qry as $rk) {
$pc = round($rk->pageview * 100 / $rks, 1);
if ($fld == 'date') {
$rk->{$fld} = irihdate($rk->{$fld});
}
if ($fld == 'urlrequested') {
$rk->{$fld} = iri_StatPress_Decode($rk->{$fld});
}
// $chl.=urlencode(my_substr($rk->$fld,0,50))."|";
// $chd.=($tdwidth*$pc/100)."|";
print "<tr><td style='width:400px;overflow: hidden; white-space: nowrap; text-overflow: ellipsis;'>" . my_substr($rk->{$fld}, 0, 50);
if (strlen("{$rk->fld}") >= 50) {
print "...";
}
// <td style='text-align:right'>$pc%</td>";
print "</td><td style='text-align:center;'>" . $rk->pageview . "</td>";
print "<td><div style='text-align:right;padding:2px;font-family:helvetica;font-size:7pt;font-weight:bold;height:16px;width:" . number_format($tdwidth * $pc / 100, 1, '.', '') . "px;background:" . irirgbhex($red, $green, $blue) . ";border-top:1px solid " . irirgbhex($red + 20, $green + 20, $blue) . ";border-right:1px solid " . irirgbhex($red + 30, $green + 30, $blue) . ";border-bottom:1px solid " . irirgbhex($red - 20, $green - 20, $blue) . ";'>{$pc}%</div>";
print "</td></tr>\n";
$red = $red + $deltacolor;
$blue = $blue - $deltacolor / 2;
}
}
print "</table>\n";
// $chl=my_substr($chl,0,strlen($chl)-1);
// $chd=my_substr($chd,0,strlen($chd)-1);
// print "<img src=http://chart.apis.google.com/chart?cht=p3&chd=".($chd)."&chs=400x200&chl=".($chl)."&chco=1B75DF,92BF23>\n";
print "</div>\n";
}
function iriValueTable($fld, $fldtitle, $limit = 0, $param = "", $queryfld = "", $exclude = "")
{
/* Maddler 04112007: 添加了参数 */
global $wpdb;
$table_name = $wpdb->prefix . "statpress";
$to_time = current_time('timestamp');
if (strlen(get_option("statpress_details_period")) > 0) {
$period = get_option("statpress_details_period");
} else {
$period = "1 month";
update_option("statpress_details_period", $period);
}
$from_time = strtotime('-' . $period, $to_time);
$exclude .= " and (statuscode != '404' or statuscode is null)";
#$fc_statpress = $wpdb->query("select * from $table_name where feed!='' and timestamp between $from_time and $to_time;");
//$qry = $wpdb->get_results("select count(DISTINCT(IP)) as feedcounts from $table_name where feed!='' and timestamp between $from_time and $to_time;");
if ($queryfld == '') {
$queryfld = $fld;
}
print "<div class='wrap'><table align=center><tr><td align=center>";
print "<h3>{$fldtitle}</h3>(" . __("recently", "statpresscn") . " " . $period . ")<table style='width:100%;padding:0px;margin:0px;' cellpadding=0 cellspacing=0><thead><tr><th style='width:220px;background-color:white;'></th><th style='width:60px;background-color:white;'><u>" . __('Visits', 'statpresscn') . "</u></th><th style='background-color:white;'></th></tr></thead>";
print "<tbody id='the-list'>";
$rks = $wpdb->get_var("SELECT count({$param} {$queryfld}) as rks FROM {$table_name} where timestamp between {$from_time} and {$to_time} {$exclude};");
if ($rks > 0) {
$sql = "SELECT count({$param} {$queryfld}) as pageview, {$fld} FROM {$table_name} where timestamp between {$from_time} and {$to_time} {$exclude} GROUP BY {$fld} ORDER BY pageview DESC";
if ($limit > 0) {
$sql = $sql . " LIMIT {$limit}";
}
$qry = $wpdb->get_results($sql);
$tdwidth = 250;
$red = 131;
$green = 180;
$blue = 216;
$deltacolor = round(250 / count($qry), 0);
// $chl="";
// $chd="t:";
foreach ($qry as $rk) {
$pc = round($rk->pageview * 100 / $rks, 1);
if ($fld == 'date') {
$rk->{$fld} = irihdate($rk->{$fld});
}
if ($fld == 'urlrequested') {
$rk->{$fld} = iri_StatPress_Decode($rk->{$fld});
}
// $chl.=urlencode(substr($rk->$fld,0,50))."|";
// $chd.=($tdwidth*$pc/100)."|";
print "<tr><td style='width:250px;overflow: hidden; white-space: nowrap; text-overflow: ellipsis;'>";
if ($fld == "referrer") {
echo "<a href='" . $rk->{$fld} . "' target='_heart5'>";
}
echo iri_StatPress_Abbrevia(urldecode($rk->{$fld}), 26);
if ($fld == "referrer") {
echo "</a>";
}
print "</td><td style='text-align:center;'>" . $rk->pageview . "</td>";
// <td style='text-align:right'>$pc%</td>";
print "<td><div style='text-align:right;padding:2px;font-family:helvetica;font-size:7pt;font-weight:bold;height:16px;width:" . $tdwidth * $pc / 100 . "px;background:" . irirgbhex($red, $green, $blue) . ";border-top:1px solid " . irirgbhex($red + 20, $green + 20, $blue) . ";border-right:1px solid " . irirgbhex($red + 30, $green + 30, $blue) . ";border-bottom:1px solid " . irirgbhex($red - 20, $green - 20, $blue) . ";'>{$pc}%</div>";
print "</td></tr>\n";
$red = $red + $deltacolor;
$blue = $blue - $deltacolor / 2;
}
}
print "</table>\n</td><td bgcolor=gray><font color=white>*vs*</font></td>";
print "<td align=center><h3>{$fldtitle}</h3>(" . __("all stats days", "statpresscn") . ")<table style='width:100%;padding:0px;margin:0px;' cellpadding=0 cellspacing=0><thead><tr><th style='width:220px;background-color:white;'></th><th style='width:60px;background-color:white;'><u>" . __('Visits', 'statpresscn') . "</u></th><th style='background-color:white;'></th></tr></thead>";
print "<tbody id='the-list'>";
$rks = $wpdb->get_var("SELECT count({$param} {$queryfld}) as rks FROM {$table_name} WHERE 1=1 {$exclude};");
if ($rks > 0) {
$sql = "SELECT count({$param} {$queryfld}) as pageview, {$fld} FROM {$table_name} WHERE 1=1 {$exclude} GROUP BY {$fld} ORDER BY pageview DESC";
if ($limit > 0) {
$sql = $sql . " LIMIT {$limit}";
}
$qry = $wpdb->get_results($sql);
$tdwidth = 250;
$red = 131;
$green = 180;
$blue = 216;
$deltacolor = round(250 / count($qry), 0);
// $chl="";
// $chd="t:";
foreach ($qry as $rk) {
$pc = round($rk->pageview * 100 / $rks, 1);
if ($fld == 'date') {
$rk->{$fld} = irihdate($rk->{$fld});
}
if ($fld == 'urlrequested') {
$rk->{$fld} = iri_StatPress_Decode($rk->{$fld});
}
print "<tr><td style='width:250px;overflow: hidden; white-space: nowrap; text-overflow: ellipsis;'>";
if ($fld == "referrer") {
echo "<a href='" . $rk->{$fld} . "' target='_heart5'>";
}
echo iri_StatPress_Abbrevia(urldecode($rk->{$fld}), 26);
if ($fld == "referrer") {
echo "</a>";
}
print "</td><td style='text-align:center;'>" . $rk->pageview . "</td>";
// <td style='text-align:right'>$pc%</td>";
print "<td><div style='text-align:right;padding:2px;font-family:helvetica;font-size:7pt;font-weight:bold;height:16px;width:" . $tdwidth * $pc / 100 . "px;background:" . irirgbhex($red, $green, $blue) . ";border-top:1px solid " . irirgbhex($red + 20, $green + 20, $blue) . ";border-right:1px solid " . irirgbhex($red + 30, $green + 30, $blue) . ";border-bottom:1px solid " . irirgbhex($red - 20, $green - 20, $blue) . ";'>{$pc}%</div>";
print "</td></tr>\n";
$red = $red + $deltacolor;
$blue = $blue - $deltacolor / 2;
}
}
print "</table>\n";
print "</td></table>";
// print "<img src=http://chart.apis.google.com/chart?cht=p3&chd=".($chd)."&chs=400x200&chl=".($chl)."&chco=1B75DF,92BF23>\n";
print "</div>\n";
}
