phpBB.de

Code: Alles auswählen

	$sql = ( $group_id != -1 ) ? "SELECT u.user_email FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug WHERE ug.group_id = $group_id AND ug.user_pending <> " . TRUE . " AND u.user_id = ug.user_id" : "SELECT user_email FROM " . USERS_TABLE;

Code: Alles auswählen

	// --- quick&dirty MOD by mad-manne starts here ---
		// this excludes banned users from mass-email!!
		// special thanks @ Pyramide for helping out finding correct SQL-statement ;-)
	if ( $group_id != -1 )
	{
		$sql = "SELECT u.user_email, ub.ban_userid
			FROM ( " . USER_GROUP_TABLE . " ug 
			JOIN " . USERS_TABLE . " u ON u.user_id = ug.user_id
			LEFT JOIN " . BANLIST_TABLE . " ub ON ub.ban_userid = u.user_id )
			WHERE ug.group_id = $group_id
				AND ug.user_pending <> " . TRUE . " 
				AND u.user_id = ug.user_id
			HAVING ub.ban_userid IS NULL";
	}
	else
	{
		 $sql = "SELECT u.user_email, ub.ban_userid
		 	FROM ( " . USERS_TABLE . " u
			LEFT JOIN " . BANLIST_TABLE . " ub ON ub.ban_userid = u.user_id )
				HAVING ub.ban_userid IS NULL";
	}
	// --- quick&dirty MOD by mad-manne ends here ---