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