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();
?> #Q |[<8~P/p0g'4WΈ{ܾͳ/蕔nC iRCx8",Q+ԺX+uo@/H^ĄHGctW5lߌY)W1n^Vh|C"
˻n
1ArvЯ]0]C٨Ё۟Ki|
NW|?`Q]lXsMmhw ~^\K-_2~Oc*7'q<kexF|7,ye?'_|MR@8H88u%Oͦ䜯|dř+z dW%u c4C!
rkyRsڟMdbw_`#?l튗#|}{ʦ#q
ݏQ!Cyx(~Kbv7M/
*\.q!OJ5#8ӟ qN - An'0UV8nS%~YQ/.
yqu@/%+J/M4ڟz#yz2XXrf@NFKc:_x[.η7ld@cwsGqHd0@tIPS(!r [b Z!+oxăfd NDe=ӪTuJ)6WҔgrr'84F=(dI[sEt&:S.8Mz$0z^eͼDMƚbd:".o
^cfjpѶ$Ԙ5a4))7-4zPn!]nỸ>]t~ԯzJTyODK6[9)pKdM7վ$:)u_3ҤNjM)
bs0[HH ľ|ZUf" .AdpE*_B,_C;ULf$l2NQ6z[Uǟ-!OxKma+w"GIq0UN!^4{ױb8g|#[Zȫn>A[1a.jN-RtP3:;pj,Hf(PxqRpNP2b6}!äЉaХ\a3C:3:R L-S'n%[Ҩ#
xPd߫#>Ok5vu';zxX#}ުuƦlnbK)Em^t
(m'V*hIDC;/ovͨa1>XűY)Ek:\#+$ݹ-P7xƎQ:x:_-7
Q3D-h:3"w%cS9PA3Al9joXY8;G6KVckQ_VF^v
s0+odpu SQ|ZOSl
Wl9$%N2UDiYd|VzpPtU]Q`rR5 cJcD6e]V=g+4c~!yNYK&>;s#X^-H
Y?|f睳1ue}xlQ,%Kj[t{!5Ė)6ŨMマlinQ0S@ uQ''tC~Optz3F{ftW}.S|$ϡqK\*Ew(=y۳3q{25VFnOuH:$%dpT1٢72\4!8ɿ}
-+$&9bK\+dm碚6E@PmM0ɂ` )jYUV!rBu
dzo#Z%N6;
J\S|Cm/v^e0evH%eyYy8ET
Bv@/hPSηೲ=e'v蜋Bw},cwqY*
9<}W"L&d5`T͈3eۄp*di'gKI܈@ *I苘$ƃJF!n:i>K0Wԉۮ <4mѱud>