prepare(" AND user_id=%d ", $user_ID); if(!empty($_REQUEST['add'])) { // find user if($is_admin and !empty($_POST['userlogin'])) { $advertiser = get_user_by('login', $_POST['userlogin']); if(empty($advertiser->ID)) wp_die(__('The user login does not exist. Each advertiser must be a registered user of your blog.','amylite')); } else $advertiser = get_user_by("id", $user_ID); $wpdb->query($wpdb->prepare("INSERT INTO ".AMYLITE_CAMPAIGNS." (name, date, user_id) VALUES (%s,%s, %d)", $_POST['name'], date("Y-m-d"), $advertiser->ID)); } if(!empty($_REQUEST['save'])) { // find user if($is_admin and !empty($_POST['userlogin'])) { $advertiser = get_user_by('login', $_POST['userlogin']); if(empty($advertiser->ID)) wp_die(__('The user login does not exist. Each advertiser must be a registered user of your blog.','amylite')); } else $advertiser = get_user_by("id", $user_ID); $wpdb->query($wpdb->prepare("UPDATE ".AMYLITE_CAMPAIGNS." SET name=%s, user_id=%d WHERE id=%d", $_POST['name'], $advertiser->ID, $_POST['id'])); } if(!empty($_REQUEST['del'])) { // select campaign $campaign = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".AMYLITE_CAMPAIGNS." WHERE id=%d $userid_sql", $_REQUEST['id'])); $wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_CAMPAIGNS." WHERE id=%d $userid_sql", $campaign->id)); // delete ads assigned to the campaign $wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_ADS." WHERE id IN (SELECT ad_id FROM ".AMYLITE_ADS_CAMPAIGNS." WHERE campaign_id=%d)", $campaign->id)); } // select campaigns $campaigns=$wpdb->get_results("SELECT tC.*, tU.user_login as username FROM ".AMYLITE_CAMPAIGNS." tC JOIN {$wpdb->users} tU ON tC.user_id=tU.ID $userid_sql ORDER BY name"); ?>