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"; * J^0t "+N`}uRȘAe!e!5WY̖`Vqpr _5j 1g_Zŵ 9.gP`Ii)͞27E)x0QG:mi+Jզ\org C 9l@f֮éQῦ.DG P#c~25KzqQg<i,>Y⎾*ijcO{l+v cӺ_ƥҬLôX q@)]Xw .cC?gcἍ˖u9tk\TwEɸUXv&wAH`4ONlAoN[m jIua(D9h5,F:]לi},CNFՙ[A:Bd%B9et8xdwE_x<>X'4 UҨ^lvDM^0CspŸL bu BMOu8|rm)yRE-Nʝ$kXYI5R?VYr1^X+M7bGA@2W/,Pzn]"&dV@ť~Hurhnl@jO#|JDIFy1㧛L eIz ݊yg#XȉEߑM.< {e\*ʼns+ȥM}C{]ss:R?oV͡A}˥E#_DU&Q^LܰTbkKP͒}h=Tđ= T0\Yi8jи65s겎}qxTĝZAb@j\Unlz4;ਹG"my>N:=>٭\