function counterize_most_used_os($number = 10, $width = 300) { global $wpdb; $number = $wpdb->prepare("%d", $number); $sql = "SELECT SUM( `count` ) AS amount, CONCAT( CONCAT( `osName`, ' ' ), `osVersion` ) AS label, CONCAT( CONCAT( `osName`, ' ' ), `osVersion` ) AS label2, `osCode`, `osURL` AS url " . " FROM `" . counterize_agentsTable() . "`" . " GROUP BY label " . " ORDER BY amount DESC " . " LIMIT {$number}"; $rows = $wpdb->get_results($sql); reset($rows); while (list($i, $r) = each($rows)) { $row =& $rows[$i]; if ($row->label == " " || $row->label == "") { $row->label = __('unknown', COUNTERIZE_TD); } else { $row->label = counterize_get_image_tag($row->osCode, $row->label, $row->url) . " " . $row->label; } } counterize_renderstats_vertical($rows, __('Operating systems', COUNTERIZE_TD), $width, true, "100%", false); }
function counterize_friendly_string($browser_name = '', $browser_code = '', $browser_ver = '', $browser_url = '', $os_name = '', $os_code = '', $os_ver = '', $os_url = '', $pda_name = '', $pda_code = '', $pda_ver = '', $pda_url = '', $image = false, $between = 'on') { $out = ''; $browser_name = htmlspecialchars($browser_name); $browser_code = htmlspecialchars($browser_code); $browser_ver = htmlspecialchars($browser_ver); $browser_url = htmlspecialchars($browser_url); $os_name = htmlspecialchars($os_name); $os_code = htmlspecialchars($os_code); $os_ver = htmlspecialchars($os_ver); $os_url = htmlspecialchars($os_url); $pda_name = htmlspecialchars($pda_name); $pda_code = htmlspecialchars($pda_code); $pda_ver = htmlspecialchars($pda_ver); $pda_url = htmlspecialchars($pda_url); $between = $between; if ($browser_name && $pda_name) { if ($image) { $out .= counterize_get_image_tag($browser_code, $browser_name, $browser_url); } $out .= $browser_name; if ($browser_ver) { $out .= " {$browser_ver}"; } $out .= " {$between} "; if ($image) { $out .= counterize_get_image_tag($pda_code, $pda_name, $pda_url); } $out .= " {$pda_name}"; if ($pda_ver) { $out .= " {$pda_ver}"; } } elseif ($browser_name && $os_name) { if ($image) { $out .= counterize_get_image_tag($browser_code, $browser_name, $browser_url); } $out .= $browser_name; if ($browser_ver) { $out .= " {$browser_ver}"; } $out .= " {$between} "; if ($image) { $out .= counterize_get_image_tag($os_code, $os_name, $os_url); } $out .= " {$os_name}"; if ($os_ver) { $out .= " {$os_ver}"; } } elseif ($browser_name) { if ($image) { $out .= counterize_get_image_tag($browser_code, $browser_name, $browser_url); } $out .= $browser_name; if ($browser_ver) { $out .= " {$browser_ver}"; } } elseif ($os_name) { if ($image) { $out .= counterize_get_image_tag($os_code, $os_name, $os_url); } $out .= $os_name; if ($os_ver) { $out .= " {$os_ver}"; } } elseif ($pda_name) { if ($image) { $out .= counterize_get_image_tag($pda_code, $pda_name, $pda_url); } $out .= $pda_name; if ($pda_ver) { $out .= " {$pda_ver}"; } } return $out; }