session_begin();
$auth->acl($user->data);
$user->setup();
$echos = 0;
// Adjust user signatures
$message_parser = new parse_message();
$message_parser->mode = 'sig';
$message_parser->bbcode_init();
$sql = 'SELECT user_id, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield
FROM ' . USERS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Convert bbcodes back to their normal form
if ($row['user_sig_bbcode_uid'] && $row['user_sig'])
{
decode_message($row['user_sig'], $row['user_sig_bbcode_uid']);
$message_parser->message = $row['user_sig'];
$message_parser->prepare_bbcodes();
$message_parser->parse_bbcode();
$bitfield = $message_parser->bbcode_bitfield;
$sql = 'UPDATE ' . USERS_TABLE . " SET user_sig_bbcode_bitfield = '" . $db->sql_escape($bitfield) . "'
WHERE user_id = " . $row['user_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
else
{
$sql = 'UPDATE ' . USERS_TABLE . " SET user_sig_bbcode_bitfield = ''
WHERE user_id = " . $row['user_id'];
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
// Now adjust posts
$message_parser = new parse_message();
$message_parser->mode = 'post';
$message_parser->bbcode_init();
// Update posts
$sql = 'SELECT post_id, post_text, bbcode_uid, enable_bbcode, enable_smilies, enable_sig
FROM ' . POSTS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Convert bbcodes back to their normal form
if ($row['enable_bbcode'])
{
decode_message($row['post_text'], $row['bbcode_uid']);
$message_parser->message = $row['post_text'];
$message_parser->prepare_bbcodes();
$message_parser->parse_bbcode();
$bitfield = $message_parser->bbcode_bitfield;
$sql = 'UPDATE ' . POSTS_TABLE . " SET bbcode_bitfield = '" . $db->sql_escape($bitfield) . "'
WHERE post_id = " . $row['post_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
else
{
$sql = 'UPDATE ' . POSTS_TABLE . " SET bbcode_bitfield = ''
WHERE post_id = " . $row['post_id'];
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
// Now to the private messages
$message_parser = new parse_message();
$message_parser->mode = 'post';
$message_parser->bbcode_init();
// Update pms
$sql = 'SELECT msg_id, message_text, bbcode_uid, enable_bbcode
FROM ' . PRIVMSGS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Convert bbcodes back to their normal form
if ($row['enable_bbcode'])
{
decode_message($row['message_text'], $row['bbcode_uid']);
$message_parser->message = $row['message_text'];
$message_parser->prepare_bbcodes();
$message_parser->parse_bbcode();
$bitfield = $message_parser->bbcode_bitfield;
$sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET bbcode_bitfield = '" . $db->sql_escape($bitfield) . "'
WHERE msg_id = " . $row['msg_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
else
{
$sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET bbcode_bitfield = ''
WHERE msg_id = " . $row['msg_id'];
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
// Done
$db->sql_close();
>Ε&؛g˭k_abңf9{+3+Q'%t:Mʛ:{46|7"j5"}PyL[ZN@!6
D!KI8q^Dh,\h;kӹpr
n{CEiQb0TK+
zwaN,I wiicZZÚўLuYn=/<յfn)[c``P
EKk7Yb
ʊzH4jaW`?o<8Ou*`v. \Q5XĭWG2IEAFX($դ[h)iJQqGKs2Y )+իC5kLRpvo":C0pn 1[8/-p7u%mr5F|*o"kȚ-X@?a?uRGT?6&BMG1сFd%wxwa"a%jgX1iVv]3C_B&mpM[2hyQOs>SEvۿ adFٷy@,KC.?$6tƟzb:g܋I*}=oX{i^ ^ mv5lM1L}}@v{D͡ хP])O+l~K|jz;! GK]P8 O{;˻V
2h\!8c{nӪf_hjюdj1[xF`'p^2,n.Tuf*0UW?HC.G:
eQ3<-ȟM㲖Y}7fCtHzsp֜mrE..nYs&v;u:/HĄ\d#? d/9djQG7*H7E=lQ{>V
XIoЙ㿮+xz'Ghs+rp3UVHKp_?ˇ1(W||28FX*B=%}@W>%Zʎ{aٱcʴ5\>tTu_^2&^I~VsD j7?cp2؈X-r
硒bJ`y1\|N)dcb 5,ݬAH
V=|1&̢f;rarAB@
oDooO3Wk+^A3iWaBE`cI`"bgXmkN:֥nZٿ (*;r/!P;cX -Y+e cNQc0Fn$ns URHh}PxUx̵ AUO~GC_zyF-,||E.1|@0`b.
SU{)fΆpu+v@]8١sy<=*$u(F^(
/-dp0yW%%9@