sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false);
$start = 0;
do
{
// Batch query for group members, call group_user_del
$sql = "SELECT user_id, user_email
FROM {$table_prefix}users
LIMIT $start, 100";
$result = $db->sql_query($sql);
if ($row = $db->sql_fetchrow($result))
{
do
{
$sql = "UPDATE {$table_prefix}users
SET user_email_hash = " . (crc32(strtolower($row['user_email'])) . strlen($row['user_email'])) . '
WHERE user_id = ' . $row['user_id'];
$db->sql_query($sql);
$start++;
}
while ($row = $db->sql_fetchrow($result));
echo "
Batch -> $start\n";
flush();
}
else
{
$start = 0;
}
$db->sql_freeresult($result);
}
while ($start);
echo "
Done
\n"; ?>6~FY$b0DDHګ"K=U"sQHD㡇3~r3]ڠ.=zgc#X%h{Yڷ ;JPJX>"hL/]kŮ#:ø&-1,o7xz0-2**VlmVҳ'oJ^"_f'ڛLLWX;&aO^9sW8 Cv^ϦS2Ti(8%=lW~%:pGw RFC,32o˺C7]C;ex*k[DqKAOd7hJҐ;,0;2l{MED{V7YEۜ0yI֛ɓ3oˀ/`J3qN7|RC;&j\A3c[,SW1@skH+H-+>ׅ>P0uPrq~߮^ !B. t4FLA#bAe#;h!g7LfJ/=)9nHBly=H/}TZCOV~8a" P^[7fef{Ai+NW&*+Q%g*=%.yAGoO{riX*U Ƿ+ W&rQ>GO#;FJVzq$"Xt!jTD{ʥ^pVJ#a3e4_C'4h\;ESMJFGsjq;e<:7yHO9:{Y?u24#LR,w⣁Gl~QM` DQ]$ &܆HR#om>u VAӏl#ʖ}$#3y9 {mQ