Vergleich inc/functions_massmail.php - 1.4.0 - 1.4.6

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 24Zeile 24
		return '';
}


		return '';
}


	$search_sql = '1=1';

	$search_sql = 'u.allownotices=1';


// List of valid LIKE search fields
$user_like_fields = array("username", "email");


// List of valid LIKE search fields
$user_like_fields = array("username", "email");

Zeile 54Zeile 54
				default:
$direction = "=";
}

				default:
$direction = "=";
}

			$search_sql .= " AND u.{$search_field}{$direction_field}'".$db->escape_string_like($conditions[$search_field])."'";

			$search_sql .= " AND u.{$search_field}{$direction}'".$db->escape_string_like($conditions[$search_field])."'";

		}
}


		}
}


Zeile 74Zeile 74
				case "sqlite3":
case "sqlite2":
$additional_sql .= " OR ','||additionalgroups||',' LIKE '%,{$usergroup},%'";

				case "sqlite3":
case "sqlite2":
$additional_sql .= " OR ','||additionalgroups||',' LIKE '%,{$usergroup},%'";

 
					break;

				default:
$additional_sql .= " OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'";
}
}

				default:
$additional_sql .= " OR CONCAT(',',additionalgroups,',') LIKE '%,{$usergroup},%'";
}
}

		$search_sql .= " AND (u.usergroup IN (".implode(",", $conditions['usergroup']).") {$additional_sql})";

		$search_sql .= " AND (u.usergroup IN (".$db->escape_string(implode(",", $conditions['usergroup'])).") {$additional_sql})";

	}

return $search_sql;

	}

return $search_sql;