Изменения
→Найти свободные диапазоны UID
SELECT *
FROM (
SELECT z.expected AS gap_start, IF(z.got - 1 > z.expected, z.got - 1, z.expected) as AS gap_end
FROM (
SELECT @rownum := CONVERT(@rownum + 1, SIGNED INTEGER) AS expected, IF(@rownum = uid, 0, @rownum := uid) AS got
) AS z
WHERE z.got != 0
UNION
SELECT MAX(uid) + 1 AS gap_start, 65535 AS gap_end FROM users
) AS gaps
WHERE gap_start <= gap_end AND gap_end > = 10000; -- if you need a specific range
</pre>
= Выбор юзеров вместе в полными адресами в файл=
