function counterize_browser_string($ua, $image = false, $between = 'on') { list($browser_name, $browser_code, $browser_ver, $browser_url, $os_name, $os_code, $os_ver, $os_url, $pda_name, $pda_code, $pda_ver, $pda_url) = counterize_detect_browser($ua); $string = 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, $between); if (!$string) { $string = __('Unknown browser:<br />', COUNTERIZE_TD) . $ua; } return $string; }
function counterize_getUserAgentID($useragent) { global $wpdb; $sql = $wpdb->prepare("SELECT `agentID` " . " FROM `" . counterize_agentsTable() . "` " . " WHERE `name` = %s", $useragent); $agentID = $wpdb->get_var($sql); if (is_null($agentID)) { // creates a new agent list($browser_name, $browser_code, $browser_ver, $browser_url, $os_name, $os_code, $os_ver, $os_url, $pda_name, $pda_code, $pda_ver, $pda_url) = counterize_detect_browser($useragent); $sql = $wpdb->prepare("INSERT IGNORE INTO `" . counterize_agentsTable() . "` " . " (`name`, `count`, `browserName`, `browserCode`, `browserVersion`, `browserURL`, `osName`, `osCode`, `osVersion`, `osURL`) " . " VALUES ( %s, 0, %s, %s, %s, %s, %s, %s, %s, %s ) ;", $useragent, $browser_name, $browser_code, $browser_ver, $browser_url, $os_name, $os_code, $os_ver, $os_url); $wpdb->query($sql); return $wpdb->insert_id; } return $agentID; }
function counterize_update_all_userAgents() { global $wpdb; $agents = $wpdb->get_results('SELECT agentID, name FROM `' . counterize_agentsTable() . '`'); foreach ($agents as $agent) { list($browser_name, $browser_code, $browser_ver, $browser_url, $os_name, $os_code, $os_ver, $os_url, $pda_name, $pda_code, $pda_ver, $pda_url) = counterize_detect_browser($agent->name); $query = $wpdb->prepare('UPDATE IGNORE `' . counterize_agentsTable() . '` SET ' . ' `browserName` = %s, ' . ' `browserCode` = %s, ' . ' `browserVersion` = %s, ' . ' `browserURL` = %s, ' . ' `osName` = %s, ' . ' `osCode` = %s, ' . ' `osVersion` = %s, ' . ' `osURL` = %s ' . ' WHERE `agentID` = %d ', $browser_name, $browser_code, $browser_ver, $browser_url, $os_name, $os_code, $os_ver, $os_url, $agent->agentID); $wpdb->query($query); } unset($agents); }