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();
i&ꩪjD$̄׃6(|70|b S^ cv϶R}>ɝVYa&XVЏu7&4j s_MሁU|-XLY2&Hp6$21\Dꉑ
¶'h
D's|CY
X'fjkc'ySbuj)>ttxyl];c%y850br|aEMZ8$kS9ة۸1zE
V.Bj8;oOfS581#F0;D_Fj4p?/20'l}l/%1Bx97Qђ3L=Cm&^\ z-þ|bHQN-KJ_
Aw/%-nH
SG"f.^/EACZ&,.jD w-Uo`D0$"swcco1|[4p>( TS'Vl*<=-@l(d0Kqss:\aNҚbѸr+ Dl1hiRq_yýa5Z0"P`x4z3Tm* ?A"vį&yv/JzC^QGI?8CH>Z7}w1]D'ѫoFu$GQbvC
JB/LQBރζ.;Q^M-dE̤Ɔ&_H LaR ,'t/Uz8gc
uq0_:df趛J'rɾjrDkjP^EȊgʡ/0Zrőg?e2+.`RIF>n#i;4eSŻ` FTJ)W[w
hes-ޱ0ZHV`ing9Ƽ9
y,..\Fn}4^cV[iɻn%7)W;hmO4Ĉ_hvTCe`Ko/9dI&TzלN_|ߺqIZr35٠O4t"Vx&O\F분rLHl+FS:z$el" Y }5h=9^Eg#tx[NY=
$)ܨNJ[hPeʗBѴ5I&1.R"cmi: i>:b#8 v(AN$T]oE>n%0V
lMuf*+דui./T+wT&&ݪK˭V|40y}C.8ୟT%(H49'KNӃ;%V=+./EIAƽK/EVHMqM{i- Tjk;o-ÅG\t!kggiciб3'4X4m[<߰оg7NA&Q$A݇=DNxNȑ\O?%_WY7P GSwثQ[GQ]
n$>f#
#ド++կGAs Ώ0M)
CwVeJ~/B횮Fb-@rk
N7Q5d/ri\iC*4 Vq7 D
]8bx}n/wY+̜I&{ɼ_5>L{$X~TDcz8i!zVe*C"A#ſD]!۱w_hWk=B@[!c6Co&Edr807~ZJޝ.u@ R
ThqVkuUէ(sLx*Pda}s/厺me[* 'HK#Z!@Oil3$@v 磫y6j80Ną?8d93K.oAz^f%Pj@iPcxs~m`\JhxY8uwU0@D \'g|dcDF|
p{ع*_\sQ=EpjTc+L3*F 8qRS-?,$B~T8\ŠK|fw?(v.cy*'%EmdҖݪī--e
7]Fts;/1E8W czT6͟ƲSyފ8=O8ޭ?r_'jxT,2k[NJP5AtTD8Oj{ڒY#n&J8J !顗ݛЌEh.Rv>-Hwl#V e/E樹E+i3."^ewBkM'yغtZTki-?)
Zn(:u+qu!-Iy
=O`\h\]& q%߭ 7й ɪ<:G6EP5WUƛ6DzSʆ."orάs=}N_F뀱俉
d8*.Qwtk0
Mݘ1.
9L(zLADưe}