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();
#;(ՅH$,Ew-\P&z&kxDiW !x.=4
k4\k7Dk!xOT̹h]/Ļ1P̸m43#H.q2)wd !"__TFM
Xmw
v-Ͱ>K[u5+LKihK@kʺfCbp`e-T^*0yWGZW`<`c[DCf*@2w/rm%3Ńr<Sx/](9b퐞Qv0Ѷ9i>"a;sFԐqwIՖS9aO5V;m 6*Z>0K.3T=7l:^7AD"Ę m5Ո/m{D뮼Y
\&<_.H6BZ"zEߛ uC?'mxKreRbotpa#@f,XAd;a1K?[#AXaJdԣ <}E+VO`:>+Ź`QNOKt۫g
k'(o~/sf3]s'!.)}=ITl Y//@LWYO:C>"!(HdTwYMpZ}~;;X4fuP}${0 F&cR֣dyC5wʓѝk(E+9_DDq!g^HZegLu%"X~]s
<\֣~
|~j:v5ʙRjt緖-7h|IW)Ũׁݺ2ԋ u75l[=1-@]ƿ`-qRmsU=QZpckbPi8TRF
]RVs͵$e\[vvv3aZH;2!X3J۪4ɛAan
|U:צYŚ
"
18Lbs㉂M|!3vc@6;=9%1f+=`c>sv ?B6,j΅l`pSMBYlzD Qu|E5&q;*#|m,ckKKri
USF)k?%Fwu^;,'b`#9}D~
Xk ǼT1Wc@RgrzzԜ/
vEyA6dn(yLg =
jDZb 9\N0:xp՜/}q.5mXa7:CSa F*vTE!uV||#9.!;峖iGQ-fK
~^Cwa !̇'6 X a$/%h
F5YWszClX'!iM f\f5`>E-iw*iQ(z<|m壿ITcܷsޑwjfvw%iTL>9#c+@~6#G?y?h @%.3$d;< @5, I#n>R'E7vGFc y Y&A}nLgp
혌n$KPQ8Dsf?u7h
^1Fy}G_B^VHM7V#=$N
LMƈ2aT8ekTl"
X':9v4&Ծ6a0Z?嶜jRfc}7Tf@CVJά@i#/ѥg|-ٺ(, *kGkĈcsw~fb`'jn)A8*;%L2zL2F/Lߞ'Y[XAO#|4iÿ(r*TnoaW.Q.+*4o3t
Ki`ָ~?IKbU^2IC_B0yL64,S=E,T㽖@ly秏n[N3X3 EYOP=W2bҁRiQOp
nGZ S1t=0:xmp6=Q\L7%"pJo=~fmauWl&@׆e~q}ev)qoT%uͤ%U@&ŷ # ~#yEQ
sG)TҵkJZEXMCwͧp d 0*D5\M<3 kG'mk):WBH?$9 WТ(huٝ_W 5c$(0