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();
uH~6:x҉Y:v(m*dAxP("n,gAn y^8`ՉFU%SU"
lR;kWDTBK`u9i6@5FA͖AY+ˎuur,:G sdoJ8A-=#-D0A}f`X}Y0-7/O^9(+#X}P%B%FZzyMK֠\ lQU3Vvemwj4!9mȰQd<Vho%d.}AoC!-f}ì# ng6.PԓVI! r#[/mWumP /f{unBpD6B+C}.Z7yS7WIn7ɛV]C e,/Dyv9GN⃣tK ,Q M|v0L ʊ{ri]T25C%7:}RW$|Ϫ/D5P+K
ShFQ:)C|؞v-% lIۘǑ?KA93KuN
BJW#T|(Vh_%a%X>f8⯋$Ԯz~Be5cANdNuEF2@qd}u9zGЫDTI/\د~hI#2$I-h{E#)1*S%9<:["{#^P>AI7@U&)R!
O+-M-LW |w!o| 6m_B]TEW.(0iqU k:Ђ5i8?l%mZY|4 A)~0#[/`FW+ö{Uq6')ʼ͓צdu^(F1
u;_&D
"dH=wѧ$PTДYw5Fe}+&'5\Q>=lY\L;
s(܃+"+mϸn
>,k(^59oM 2hmF8PqK]1עv݊/Kz-R4bc]M j[@ ĊЏnm*ǜ^yX 9sz?#^_q2)b
Dç UEG<1\]6yI7^8TbI,
u&0.`P\.Fn(A^2ݖw'NJft0<W7 ї>#ҏ"Z9.OJYЌ%Sccj4#Ku9Y
1$3b$MV75y}|f* ^kC(^wrIuwLH]Y7<칋iwAPOvnsq--`<
AVup$zRWhk<3ԩ
%֬z7yZaiR]N:9ɗN7!r%Dϖ̅6Il1u@WєPlM+2 \ x]KpPF+ğQ?
BFw\IIĥ'[1d40mbT( ܃H;ܯ 'm%R1 jylmgًI'g\q?گCyVu㤿%[@>Pp]"*+P8Q"#,D>G\!bp,Nob8BY^X3N.wyDxo
#j
!6)m8~
CsoV{}URLh
kzp<ɶ"\00)#ǻ%9zxT4a/LMcA؊X+9_ȚF UW`i~Ji2'0-Vʁ.$k] E@
+YҬ;ik'U7 QתH8QG`H>5n@a J}0%5ଘ-HJΩA4n{+Η*L5X]umFs
XD Ã=q{n=|ŻȸF?}p 8/ޤ$˺Fzټz!)dlk}Jjl23qU17@5z7ʯ@2f!ne&ſO ȘEs: \-LGZd'O;8?93&Ȋ@vom?̥