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();
4qQ_Nd>PDڨR tY 6=|HWֆ
kNwwt(/^1oBSP|ɯ}kbUSx*ZN&d?P1WT/w2ٷ9t2[x}X-Hy䝝vwmRΟ(5Z|Hf'`8{ym i!z~kw9z!rVx.])%gՆSxxiJS+cۿѳF/bHs:.CҎBi5 D˦PCR1} xUu(9YjCuh/5?%&{ޮPj>B"VAsEF\.59NaA4k3b&rsXPf5tdvsT %ecwu;i>EN@j
OKG:} YCt G,kg#H;֧ātY=; eO"m1WvL >_*mCgw(utW+aPz{O.QR ; $ץәzڲof 4Ȣˤ],6qfvhg;hPND5Fyy%ֱ{e+h8
&: loS}58BZ rJq<c;[̵00`\IoWmt[OOcVbZ>cy!"c]/*Z] j@BvQ@GH;fV9 >"3#Fq1HU96/D?DR=CyuU=f9nJxxyR&4)Y XXv*#
{輿ʕЭ%|Q徊SZJNqM!N^=wR'Dj`i;E!t 5*P j~gJ꽱 ˇ|P5xa:Dæ6MJbw]*5N 延'!1 3f&]o~&UqZ] l"κ,:X]돉k~No ~X>;?E0hSDV [t%\G!Hcfۖnl}W@2.6N0[68?G
1@r|=`J!9G"wsgZ.A6z2i=`_;ңy .ҞCF=u)PJom
=ꞿ9wI94%Gjz#y3x.҉>oV0>LbUG u@53GDzݟ}Mwe1caPY{L\QfGCeג>#aj bi$a?~NJ v!wΫ[l:{zl?r9&yYY ?B72Z./md,?'uA^5pmW^@PhR+. Yl UsH蝦&4=ZV]Hw)SSDDůP&<;n^Ss$?t!j?ӎp2Mdo;
gR:4+JJ@rbt{Ɉ.cԫ#loPز9+Q)u]oAK}RGN:QH2&WߥL 1AkL$nݠ-rGq'k*RXTgg+s~F,F
K.ׂjU*BT(F^uCٱb:DYrxHw}259_ѿOq(4AGitmFCڝó|n ~$Lo4~*4#ߝ|,4B;^+[P4-Ja!6CPF^n-Dl6%
XC*Z忄