"._MAILUSERS.""; if(isset($_POST['submit'])) { $who = isset($_POST['who']) ? $_POST['who'] : false; $category = isset($_POST['category']) ? $_POST['category'] : false; if($who == "authors") $select = "SELECT "._EMAILFIELD." as email, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_authorprefs as ap WHERE "._UIDFIELD." = ap.uid AND ap.stories > 0"; else if($who == "admins") $select = "SELECT "._EMAILFIELD." as email, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE.", ".TABLEPREFIX."fanfiction_authorprefs as ap WHERE "._UIDFIELD." = ap.uid AND ap.level > 0"; else $select = "SELECT "._EMAILFIELD." as email, "._PENNAMEFIELD." as penname FROM "._AUTHORTABLE; if($who == "admins" && $_POST['category'] != "all" && isNumber($_POST['category'])) $select .= " AND (FIND_IN_SET(".$_POST['category'].", ap.categories) > 0 OR ap.categories = 0)"; $query = dbquery($select); $subject = strip_tags(descript($_POST['subject'])); $mailtext = descript($_POST['mailtext']); $sent = 0; while($result = dbassoc($query)){ $mailresult = sendemail($result['penname'], $result['email'], $sitename, $siteemail, $subject, $mailtext, "html"); if($mailresult) $sent++; $output .= $result['penname']." \"check\"
"; } if($sent) $output .= write_message(_MESSAGESENT." $sent
"._ACTIONSUCCESSFUL); else $output .= write_message(_NOMAILSENT); } else { $output .= "
"; $output .= "

"._EMAILWARNING."

"; } ?>