query("UPDATE ".$wpdb->prefix."ad_buttons SET ad_active = 0 WHERE id = $ad_button"); } elseif($ad_button_action == 'activate') { $ol_flash = "Ad Button $ad_button has been activated."; $wpdb->query("UPDATE ".$wpdb->prefix."ad_buttons SET ad_active = 1 WHERE id = $ad_button"); } elseif($ad_button_action == 'delete') { $ol_flash = "Ad Button $ad_button has been deleted."; $wpdb->query("UPDATE ".$wpdb->prefix."ad_buttons SET ad_active = 2 WHERE id = $ad_button"); } elseif($ad_button_action == 'edit') { $ab_formfunc= 'edit'; $this_ad = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."ad_buttons WHERE id = $ad_button"); $ab_img = $this_ad->ad_picture; $ab_link = $this_ad->ad_link; $ab_txt = $this_ad->ad_text; } $widget_adbuttons_cfg = array( 'ab_cfg1' => '' ); $widget_adbuttons_cfg = get_option('widget_adbuttons_cfg'); // check if the form has been submitted and validate input if(isset($_POST['ab_img']) || isset($_POST['ab_link']) || isset($_POST['ab_txt'])) { if (isset($_POST['ab_img'])) { $ab_img = $htp.str_replace($htp, "", $_POST['ab_img']); } if (isset($_POST['ab_link'])) { $ab_link = $htp.str_replace($htp, "", $_POST['ab_link']); } if (isset($_POST['ab_txt'])) { $ab_txt = $_POST['ab_txt']; } if($ab_img == $htp || $ab_img == ''){ $ab_img_err = 'Please fill in the link to your image file'; } if($ab_link == $htp || $ab_link == ''){ $ab_link_err = 'Please fill in the target link for your ad'; } if($ab_img_err == '' && $ab_link_err == ''){ // everything looks good, lets write to the database $table = $wpdb->prefix."ad_buttons"; if($ab_formfunc=='add'){ $wpdb->query("INSERT INTO $table(ad_picture, ad_link, ad_text, ad_active) VALUES('$ab_img', '$ab_link', '$ab_txt', 0)"); $ol_flash = 'Your Ad Button has been created!'; $ab_img = $htp; $ab_link = $htp; $ab_txt = ''; $ab_img_err = ''; $ab_link_err= ''; }elseif($ab_formfunc=='edit'){ $wpdb->query("UPDATE ".$wpdb->prefix."ad_buttons SET ad_picture = '$ab_img', ad_link = '$ab_link', ad_text = '$ab_txt' WHERE id = $ad_button"); $ol_flash = "Ad Button $ad_button has been updated."; } } } ?>

' . $ol_flash . '

'; ?>

Ad Buttons ad management

Edit Ad Button"; }else{ echo "

Create new Ad Button

";} ?>

Ad Button Image \"$ab_txt\"";}?>
Ad Button Link
Ad Button Text

" />

Active Ad Buttons

get_results("SELECT * FROM ".$wpdb->prefix."ad_buttons WHERE ad_active = 1"); foreach($results as $result) { if($result->ad_views){ $ad_ctr = round((($result->ad_clicks / $result->ad_views) * 100 ), 2); } else { $ad_ctr = 0; } echo " "; } ?>
Ad ID Ad Button Ad Text Ad Views Ad Clicks CTR Action
$result->id ad_link\" target=\"_blank\" title=\"$result->ad_text\">ad_picture\" alt=\"$result->ad_text\" align=\"left\" vspace=\"10\" hspace=\"10\" border=\"0\"> $result->ad_text $result->ad_views $result->ad_clicks $ad_ctr%

Inactive Ad Buttons

get_results("SELECT * FROM ".$wpdb->prefix."ad_buttons WHERE ad_active = 0"); foreach($results as $result) { if($result->ad_views){ $ad_ctr = round((($result->ad_clicks / $result->ad_views) * 100 ), 2); } else { $ad_ctr = 0; } echo " "; } ?>
Ad ID Ad Button Ad Text Ad Views Ad Clicks CTR Action
$result->id ad_link\" target=\"_blank\" title=\"$result->ad_text\">ad_picture\" alt=\"$result->ad_text\" align=\"left\" vspace=\"10\" hspace=\"10\" border=\"0\"> $result->ad_text $result->ad_views $result->ad_clicks $ad_ctr%