Writing

Comments

platforms
"; // Get information about platforms $windows = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Windows%'"); $linux = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Linux%'"); $macos = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%MAC OS X%'"); $wp = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%WordPress%'"); $sun = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%SunOS%'"); $platform = array("windows" => $windows, "linux" => $linux, "macos" => $macos, "wp" => $wp, "sun" => $sun); arsort($platform); foreach($platform as $key => $val){ echo " "; echo $val."
"; } // Get information about browsers echo "
browsers
"; $firefox = $wpdb->get_var("SELECT COUNT( comment_agent ) FROM $wpdb->comments WHERE comment_agent LIKE '%Mozilla/5.0 (Windows%' OR comment_agent LIKE '%Mozilla/5.0 (Macintosh%' OR comment_agent LIKE '%Mozilla/5.0 (X11%'"); $ie = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%MSIE%'"); $safari = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Safari%'"); $opera = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Opera%'"); $iceweasel = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%IceWeasel%'"); $konqueror = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Mozilla/5.0 (compatible; Konqueror%'"); $lynx = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%ELinks%'"); $netnewswire = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Netnews%'"); $epiphany = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Epiphany%'"); $bonecho = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%BonEcho%'"); $flock = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Flock%'"); $chrome = $wpdb->get_var("SELECT COUNT(comment_agent) from $wpdb->comments WHERE comment_agent LIKE '%Chrome%'"); $browser = array("firefox" => $firefox, "ie" => $ie, "safari" => $safari, "opera" => $opera, "iceweasel" => $iceweasel, "konqueror" => $konqueror, "lynx" => $lynx, "netnewswire" => $netnewswire, "epiphany" => $epiphany, "bonecho" => $bonecho, "chrome" => $chrome, "flock" => $flock); arsort($browser); foreach($browser as $key => $val) { echo " ".$val." 
"; } echo"