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();
?>[M#u)zFTWOO]'蹹\s7m`X 4Oc2AfR!!GSѴ9reBM_ҢPܝUP=z@&S@aa)eeVT?A]c3E$G0])zsꭣql!*M Ss?"\ک]Ӟ8j_EGR̢'^{7]wOY^6X
kݾ|n8^)`Pf 4Ԥ[h
C[ۧh"<
;i,D͍XՉ]г>w74u(X3v!h_S=*G.8 Bd`M#8_:%K.nCT@=*WrR̝y?8otJE2jM w=k(Mc4, #Z|i?MqQ.zGEdѣ]p]L2NkVKb@Z&- Թ汸VuemSeRKtarkصIF;Ģ2I/6fFiu>J)q8¶{~/*iED )KE/盍6)@,(J>Qwvքle&,qZgeEake{cxt1Փ-bon'1{|iZAgzx%Ǖ`W%Xzx]R]Np<>lSI`iZa5cIwob9;:G6~OY
rW}xEXȂ~'`o/,ݸ7e=JPьXlLzoBb)8Y=O}?[{n#g\yt];
"'yӺge5Әuzu
JMh{'P]-/yݽf݄T1MGw>B$ (gL.;<8^թk\@N(UATha
3-pV/d6Xh?eq\-n|r-,qw],"'|<7vL/j4<` OF~~I9Hf͂5̔ލ#ir{`
ŵ{M(PEt}n&V_wD.9t湿:5 Lÿ|@Fe*VъYo+(Mw""j]#_e*_I(ijw5!J^2tok~Fd:foѤCSFe2ã
%9S%s
O@)QUylclytMHbOUZ #V̓(WZ-sQHY?~7;a'.RdE)H\2;¬|PM;+ zCHKcȉ3m&R'L9b4!sJm7,L4ӎ(P
1suAs~ԗTэ'Y0H;ob7ٓ^UUgo`cX{*c9E=_Jv_Ec֒'vo~'/Hr\v(CoZۄGLvԚ>=xT'GFڶ] M,pcE\SS'=l!"Ƕ~p8^emG!0In#/˔;Q:7ey$'Lv<ς[l[RxVAqAMl.!"L bBu/Yzˎl}mi
%TQ{uγw)w6a!p.Mә:I|SaL?k@ΓLXɩ6nT۩F {Ŵ{yn
ϢpaFlny$B+i$C[b-
υ 'n42"6r
m@r{!ucn^Ӣ-U+Ԥdn[D"FD? +Q39EuZro
^i^U萿:fbFs_b%UذM=FJ̎W&Ds%W9OL2r\5༔jQ@F
ձ(vTLSQSvUA,F(ʖE˄'z
zHr=FbHʕhXsl֙Pc !耂: WM+ "]FHG^t))nHMy{q۷w5"jr'Sdf$pR,r=(}MEXX-╣) M\bvLR~3x=;
^+7$]JV4J:dG3\fc8xP/o$;
yfu#~(Q]$KP̩Ώ-KQ%nfZSze>f:/],*=W:@D%y}$N[xP?>^]`fjeD3ERRSV'G6G|ڛmfZF Ψ.uZt%A:{'Q_vTrv40`Qs8w"Ӷuy&EkތlBэgs\*j`"EcpÎ_?ɒ֪`օ*
cuLYtC]FV 3
rټ'T읩M\#fa;a?RNoJe
vҦ+Ф,$
~1fCjtJ,m-Tbf6րbN
dnAvK>fwzm:ڐ1mMᘄڶiWB#g4&:XKs1H&JYTI5iU bdW5Q%reL=X#a(dߒ*LC ͂mMn(:w=&W