makeArray()) {
foreach ($ld->getArray() as $a) {
$retval.= $a['mail'].',';
}
}
return $retval;
}
function post_notification_admin_sub(){
echo '' . __('Manage addresses', 'post_notification') . '
';
if (!$_POST['manage']){
?>
prefix . 'post_notification_emails';
$t_cats = $wpdb->prefix . 'post_notification_cats';
$import_array = preg_split('/[\s\n\[\]<>\t,;]+/',$_POST['imp_emails'],-1, PREG_SPLIT_NO_EMPTY);
foreach($import_array as $addr){
// Set Variables //
$gets_mail = 1;
$now = post_notification_date2mysql();;
// Basic checking
if(!is_email($addr)){
if(!$addr == ""){
echo '' . __('Email is not valid:', 'post_notification') . " $addr
";
}
continue;
}
//*************************************/
//* Check database for duplicates */
//*************************************/
$mid = $wpdb->get_var("SELECT id FROM $t_emails WHERE email_addr = '$addr'");
if($_POST['logic'] == 'del'){
if($mid != ''){
$wpdb->query("DELETE FROM $t_emails WHERE id = $mid");
$wpdb->query("DELETE FROM $t_cats WHERE id = $mid");
echo "" . __('Removed email:', 'post_notification') . " $email_addr
";
} else {
echo '' . __('Email is not in DB:', 'post_notification') . " $addr
";
}
continue;
}
//Let's create an entry
if (!$mid) {
$wpdb->query(
"INSERT " . $t_emails .
" (email_addr, gets_mail, last_modified, date_subscribed) " .
" VALUES ('$addr', '$gets_mail', '$now', '$now')");
echo "" . __('Added Email:', 'post_notification') . " $addr
";
$mid = $wpdb->get_var("SELECT id FROM $t_emails WHERE email_addr = '$addr'");
}
if($mid == ''){
echo '' . __('Something went wrong with the Email:', 'post_notification') . $addr . '
';
continue;
}
if($_POST['logic'] == 'repl'){
$wpdb->query("DELETE FROM $t_cats WHERE id = $mid");
}
$pn_cats = $_POST['pn_cats'];
if(!is_array($pn_cats)) $pn_cats = array(); //Just to make sure it doesn't crash
//Let's see what cats we have
foreach($pn_cats as $cat){
if(is_numeric($cat)){ //Security
if($_POST['logic'] == 'rem'){
$wpdb->query("DELETE FROM $t_cats WHERE id = $mid AND cat_id = $cat");
} else {
if(!$wpdb->get_var("SELECT id FROM $t_cats WHERE id = $mid AND cat_id = $cat")){
$wpdb->query("INSERT INTO $t_cats (id, cat_id) VALUES($mid, $cat)");
}
}
}
}
echo '' . __('Updated Email:', 'post_notification') . " $addr
";
} //end foreach
}
}