prefix."ad_buttons";
$structure = "CREATE TABLE $table (
id INT(9) NOT NULL AUTO_INCREMENT,
ad_picture VARCHAR(100) NOT NULL,
ad_link VARCHAR(80) NOT NULL,
ad_text VARCHAR(80) NOT NULL,
ad_views INT(9) DEFAULT 0,
ad_clicks INT(9) DEFAULT 0,
ad_active TINYINT(1) NOT NULL DEFAULT 0,
UNIQUE KEY id (id)
);";
$wpdb->query($structure);
$wpdb->query("INSERT INTO $table(id, ad_picture, ad_link, ad_text, ad_views, ad_clicks, ad_active)
VALUES(1, 'http://www.phpinclude.net/images/wordpress125.gif', 'http://wordpress.org/', 'Powered by WordPress', 1, 0, 1)");
}
add_action('activate_ad buttons/adbuttons.php', 'ad_buttons_install');
//check if user is a bot of some sort
function is_bot()
{
$bots = array('google','yahoo','msn','jeeves','lycos','ArchitectSpider','whatuseek','BSDSeek','BullsEye');
//takes the list above and returns (google)|(yahoo)|(msn)...
$regex = '('.implode($bots, ')|(').')';
//uses the generated regex above to see if those keywords are contained in the user agent variable
return eregi($regex, $_SERVER['HTTP_USER_AGENT']);
}
function ad_buttons()
{
global $wpdb;
$widget_adbuttons_cfg = array(
'ab_dspcnt' => ''
);
$widget_adbuttons_cfg = get_option('widget_adbuttons_cfg');
$wp_root = get_option('home');
$ab_count = 0;
$results = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."ad_buttons WHERE ad_active = 1 ORDER BY RAND()");
foreach($results as $result){
if ($ab_count < $widget_adbuttons_cfg['ab_dspcnt']) {
echo"id\" target=\"_blank\" title=\"$result->ad_text\">ad_picture\" alt=\"$result->ad_text\" vspace=\"1\" hspace=\"1\" border=\"0\">";
$ab_count = $ab_count + 1;
// update view counter on the ad button
if(!is_bot()) {
$wpdb->query("UPDATE ".$wpdb->prefix."ad_buttons
SET ad_views = ad_views + 1 WHERE id = ".$result->id);
}
}
}
}
// add rewrite rules to support click tracking
function ad_click_rewrite() {
global $wp_rewrite;
// add rewrite tokens
$recon = '%reconments%';
$wp_rewrite->add_rewrite_tag($recon, '([A-Za-z0-9_]*)', 'reconments=');
$keywords_structure = $wp_rewrite->root . "reconments/$recon/";
$keywords_rewrite = $wp_rewrite->generate_rewrite_rules($keywords_structure);
$wp_rewrite->rules = $keywords_rewrite + $wp_rewrite->rules;
return $wp_rewrite->rules;
}
add_action('generate_rewrite_rules', 'createRewriteRules');
function ad_buttons_menu()
{
global $wpdb;
include 'adbuttonsadmin.php';
}
function ad_buttons_admin_actions()
{
add_options_page("Ad Buttons", "Ad Buttons", 1, "ad-buttons", "ad_buttons_menu");
}
add_action('admin_menu', 'ad_buttons_admin_actions');
function ad_buttons_stats()
{
global $wpdb;
include 'adbuttonsstats.php';
}
function ad_buttons_top()
{
global $wpdb;
include 'adbuttonstop.php';
}
function ad_buttons_act()
{
global $wpdb;
include 'adbuttonsact.php';
}
function ad_buttons_stats_actions()
{
add_menu_page('Ad Buttons', 'Ad Buttons', 9, __FILE__, 'ad_buttons_top');
// Add a submenu to the custom top-level menu:
add_submenu_page(__FILE__, 'Active Ad Buttons', 'Active Ad Buttons', 9, 'ad-buttons-act', 'ad_buttons_act');
}
add_action('admin_menu', 'ad_buttons_stats_actions');
// process ad clicks
function adbuttons_getclick()
{
global $wpdb;
if(isset($_GET['recommends'])) {
$ad_id = $_GET['recommends'];
if(is_numeric($ad_id)){
$results = $wpdb->get_results("SELECT ad_link FROM ".$wpdb->prefix."ad_buttons WHERE id = $ad_id LIMIT 1");
foreach($results as $result){
$send_to_url = $result->ad_link;
if(!is_bot()) {
$wpdb->query("UPDATE ".$wpdb->prefix."ad_buttons
SET ad_clicks = ad_clicks + 1 WHERE id = ".$ad_id);
}
//redirect
header("Location: ".$send_to_url);
exit(0);
}
}
}
}
// widget
function widget_init_adbuttons_widget() {
// Check for required functions
if (!function_exists('register_sidebar_widget'))
return;
function adbuttons_widget($args){
extract($args);
$options = get_option('widget_adbuttons_cfg');
$title = empty($options['title']) ? __('Sponsored Links') : $options['title'];
?>