escape_string_like($conditions[$search_field])."%'"; } } // LESS THAN or GREATER THAN $direction_fields = array("postnum"); foreach($direction_fields as $search_field) { $direction_field = $search_field."_dir"; if($conditions[$search_field] && $conditions[$direction_field]) { switch($conditions[$direction_field]) { case "greater_than": $direction = ">"; break; case "less_than": $direction = "<"; break; default: $direction = "="; } $search_sql .= " AND u.{$search_field}{$direction}'".intval($conditions[$search_field])."'"; } } // Usergroup based searching if($conditions['usergroup']) { if(!is_array($conditions['usergroup'])) { $conditions['usergroup'] = array($conditions['usergroup']); } $conditions['usergroup'] = array_map('intval', $conditions['usergroup']); foreach($conditions['usergroup'] as $usergroup) { switch($db->type) { case "pgsql": case "sqlite": $additional_sql .= " OR ','||additionalgroups||',' LIKE '%,{$usergroup},%'"; break; default: $additional_sql .= " OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'"; } } $search_sql .= " AND (u.usergroup IN (".implode(",", $conditions['usergroup']).") {$additional_sql})"; } return $search_sql; } /** * Create a text based version of a HTML mass email. * * @param string The HTML version. * @return string The generated text based version. */ function create_text_message($message) { // Cut out all current line breaks // Makes links CONTENT (link) $message = make_pretty_links($message); $message = str_replace(array("\r\n", "\n"), "\n", $message); $message = preg_replace("#
#i", "\n\n", $message); $message = preg_replace("#]*?>#i", "", $message); $message = preg_replace("#