prefix."adrotate` WHERE `id` = '".$id."' LIMIT 1"; if($banner = $wpdb->get_row($SQL)) { $ip = $wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."adrotate_tracker` WHERE `ipaddress` = '$buffer[0]' AND `timer` < '$tomorrow' AND `bannerid` = '$id' LIMIT 1"); if($ip < 1) { $wpdb->query("UPDATE `".$wpdb->prefix."adrotate` SET `clicks` = `clicks` + 1 WHERE `id` = '$id'"); $wpdb->query("INSERT INTO `".$wpdb->prefix."adrotate_tracker` (`ipaddress`, `timer`, `bannerid`) VALUES ('$buffer[0]', '$now', '$id')"); } wp_redirect(htmlspecialchars_decode($banner->link)); } else { echo 'There was an error retrieving the banner! Contact an administrator!'; } ?>