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();
?>=eH8O/]sr}ĩ)"sjÌa0KzX+!.I
E~=$V?H@tĒ' -˟ MZo],`5o&|8hHSퟡL7Uޘ<6FP!zx=|,MUR1ҙoI mx7>L{/_oG¾Mp a%o5K,*4|qjrOݙrucJ
ZAˇpQq9"4E^,%n^{S
g
gvhg 'wu3{0._$/2*(\J`KG=OeiYGB;jFq=2#H7\º_{X쩵w|fF,y'gJPqr"L7[nW
w)u8ìhtC#5)nLlgd PK^F"-/Trd/r#we6x6'SsLm,E]ԣjߣa[mCxjov \k۸'.V}phB` ˃4
JU4Q8t;a_
DS.fJDDe1 &{v"B1<-Ņo|E Ro9]p/K{2_qѺ0Oz]Jkkt#ѭ 2^=Kϙ5 -U 58a:+{a<%su(n˥Eb?g!#vωu8:Ր-I9#7Pj'`/6;Xd~xC\"`j {qtl[|
TmsG!c@x41 dp夾AMTq^m`wˑkk
L sPtS|8q`*+nHz07p1A;]òt%)h|Ic*ҙ(tU6@_x"9g^7P͖;P;o+='2vy rJ BXTN(o/4`F7۳q?T#b;@J)¨R<KdqM uz+3!P@ >hloǘ%=1hGeNtb,P̀!dtxh #QAqRw:ۨpڢhSUTz·-
X($DLc!6ЏmB%!u\X#;) T!~I]C`I{ jD3
s{rW(0c*I$B{x!k1Kɿ6:<6-0aomGy2 NSGg'GsF]ć>Ӫ=kۋhwP;*dLQT=p_y3.3Ѧ7yZcn,hp]]?zaŴ32Xen]$\x(PQ?U´zp~e?:@'_n(=\<4a&?X
vy-ӉzV%yM^=>b:+yԋ3Wǃ.Páx.D|ԁO {L7iq+W = ϲEy)Id+5ހyjTEVnSp0I`F#WLEWSsE7'9)D`#)2