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();
F6řh]sHJ] Pwf'{m{{gWk\wS`eeŪsn1F -&Iiab@PHu
@ܚ$/Δ$m3O~|1{{ޗ3\v}׃RCvu#ʤӶmU6z3(l-pp7lzTS]/x퓆&i
W\ޣ@n<+S'2kv&E Vj bOyYlu\r9:ƜF~'AةkXn[^(id0{yqyA[O?{|۽%??ǵ!goǏ?zu)|}Gyp_MRM{ww|._RA/oi!Á$;$Ц'Y/k`/%AbtvC
[DysJD'a`p%`}QJe(>5jݝ|)'eò7,^"Mp*r(mdGԼH'TR%NW1r@'?Rco!à^V#l=uHζlWrC[WsS2_5Y,g6#i.xQ=ckz-Y`&ёC_(.&qlP*,l('nM{MneWq!{5✮̕~G.?OX06mN%?S.Tp֘y1*COt-6뤗 13toUc@͓)v؎5N*xbOyO3i[PѸ3
aҫR9C1X22uj~:pǙ>];:
YlC駗HIDBux0cD3Sebnw\Oj>C⎤@;횵]`FJ6vwuL:wDW9f:JƬ}.f{v=Rp
9q,o/c>gPV6"S8rّtbzu[+Kb`텪hsⲐLke@Ta$P.)Z4l2-q'٧Z1CjZl\:;wjW/|!H|v!*aJ1'XK
8IJPKL
SPX@UxZypUGeM #q9%(h{=$3fd`P]Ijtu'aqC}>\Qԧ" +SqCAQQN?Cwus;R#ŝiŅ5$.tBM/c+EP%O9'jwtW:6 rc.,SJqh.eu.\]؝X.[ e}ԆRGn$Rqj$HKY`)ꆶPs^.*\{V nXE5qoFT!o3q!F4?G
{@M/\C6ͤMvbǚglaY/y"oMZmnƚc$&J 9t?HX'zrdD62:98>aD/mt2˰JiaǰQe1,{IF7OvfRrr Ӎϡⓗg/<1_g&.nϢOB`8
%oif(pճc~Edלy
.Y9CXkweڔ[Jfm%k,!2}-)"H
Q@`H7eB.P(ʫHMv K+?W2f$z9A$r2Y"xfCDfƯݞ 9d0%Q:pBjXH-Zd(+N.ƕtmV"FYLj:MA\[:u%P-GUd*u63
Xq.X8ȇK&˪TSC*d&]`UT\ sl3 )- Fy
Sh
ĭ!ZV*t`Фi*ۄzOPDd9e9gU<3n,+H Y#/ge06]ˇF &iRUoBkQT?Y
1<:h8^Q'z21N\5 UfrX3O}@vj3 D)EXT/s$3P3Nm@ 56W"J1+ anl
La\sdKGfD,wq5mF_ $0AU\@"AzKIx5kkna{uwtց?~y$c
]RdVOb!#Bڳ )lmY=@nRضDݡxayݿ 臗ƫTK:a^j1'yu;yuA%d
kĸ/d(_BchjÒ>Et#
NFN}nݠֹIeY/x_jɮH2<-8J!GQZQΒל*[6sDOFlOFF~'y;ëڴbfK<.d[Cqh#Vh6X,b;f