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();
7CӠ\yGk
\YSM4n+U,@ض0k$bEbA( w=v
Ωhx7:Jm Y{BS.=ynT'H?gЅY=pl'J:O^QJ@zዛL46FL&YsFrݩl6a{`=Ȩ#/JH
;PC~T
?Bdo,U|jC± 5^kf6c6t+P*f@vK6elS!Nb9fHǯz4!,Ɵ.~F$>u7siY8n-NKU)~a ,L_ GΛxEU$ʫenǦL{b*!W OAjf'^!)8,BBݤY
1#&ԗ$1HI& cj4a4
05%~
]ċaPD33X?3xD2:;=}CT5\@A,93ѻ˒9BbYԠݽ9u8rvIX|+頫+yTO4]"#,rT(tnLoKyy.gY+̌\ϬBtFp*>q%)a1=q4 VxCЍ.vG(b&8A[2XgGFݨFÃn=rc!nݽHENO^tԪ&ѥ
g}btA5ƗpmAZpˌb?%b
PҎ&edHKTLEuc!v(P%O~Hĵ(B/G%-JhNhw$E|mR7^w=7VsRZgd1|V8ߚo]?;\:Y ( /g_Ƀε;N\#$162qxҚ$Wf^UGyOS{cJxd&.]5Ĺ&j{ς|O,Zg脛 DGx>6xUc!ܙwpvic00\0~0l
,3lДh_WC g :zЉ89YwZ;!*oZyG^/Y1LD⾵ygω<?Dlòl+(J9"b.=UPoJcZAh5@SB5 7ߦ\M,ޒ!N.efi3Q3g)#{דݦK/?+($z3
$IkƐSId/~S@Nu (0d_ ڬU
d$0LqqPcqc@
N&62pbIDxA`AAa?lfI2DI $lXpqʒ
\kb?I
L!C#"sbFk\3rʼnP x݆G!IIAR䙔$A&H
F$ryS3\?kBKvt!D B$ޅ&`qdþf-8 +` YAĘ\ǃ.~~T0|:0w9cX]BօW?=ͳ^{V 2@}ӞYd1V2+"=tI?BA/!S4"fW0