[F] SQL error in build_mass_mail_query()

[WDZ]

File /inc/functions_massmail.php, function build_mass_mail_query

PHP Code:

switch($conditions[$direction_field])
{
    case "greater_than":
        $direction = ">";
        break;
    case "less_than":
        $direction = "<";
        break;
    default:
        $direction = "=";
}
$search_sql .= " AND u.{$search_field}{$direction_field}'".$db->escape_string_like($conditions[$search_field])."'"; 


The $direction variable is set up but never used... $direction_field is used instead, which causes an SQL error.

[Dennis Tsang]

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.