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();
?>+GxѺ9Dcv]_j
["NcE3Ay퓐
d}C
;k2L\(W"TiшOJnReZ<FɄ͵"Yx&8]{ה?*hʙ-(WEo'ydZy5ɰD,d,<Q֙uM'w>uFH`=vҔ?հ@!
abxNS3Cg
u
rKXɑL}U_ʞN |0EחeX&9BFYݍޛDq)-2"}hug}נ!EW,NTLr.-ODWQP`)
Q{N"AuvN*jo~" "`mTB]]Ec
PqM+-5MU"vK+,teՠj0|G&Yh)h9N~d\na8ck5u4>':<ۺ"r>\%yUѴ6~^W݄+tv!ְ(p&/Q]j=>
w
խd]?' :C|eH,o{ $hFWwv0QLR/͚ʀbQ8L\t+w>X{CuHAj ơjNt6KM+{)0poMvA:q^t三얂yfp[M͝,e]ajNcRՋ(aU(%,?c9p7ZCG}sP@O:X9ӵ<+Zㆍ%S"5dӊ[]J"_~)]i'ěK5ԁ8W`N
F`"=#p<Ī w+Jv⮽q _9,/l7zECQ}+pk$GT
6=}Y0ܐ ;v|\Ψd̗(GT%|u~C_j}.Uqt),;UY+gVXu8L(*c>
²w12.N7au^B
&("5/GIQlFO="gFej?, 0 :'+2A5F`۽6)VHT^,WBO v(TL!!9̂%Wfq&%شy̯^ wB䳬9!
P7pjdFycyykԲ)WzxBX\Yq0E-3k
/(gHPdjxԊe/~VE1T߿RۯQlwUg}*zZZ6GTPs2\"(qt6 jxE=c6
*?M.ȜJʟGt}
+g=wN MGA\#AzD{>} ?` 8U
2 G3! LfJI-$
QE&`Ev^-Z
}*FTDvǙ#g_:BgPu;Šj.nW\.hy/]Du>x
TU̦7Js73<+&8G[Z"A^;-; Oˠ!ڞTYkl`OE#0Ur
7mmH6 4#Gn2kNC}m[1[MSǁw?^jQPnૠu-IxMMj
xl*dƂHjSY
#1=EH M_bS53^EIҐ+fogw-ӵJ/rcsՀ up\%`W!űn1~C@Ѿo>*/NNUZ\$D!78?YAHd