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();
}nfpJl:HV\֯gl &\d&GXOR
5&yֲa*u0/^̒c;Ҹ2M o*eI}+'-+x2*Gi]֟`5&(um5P{}8csUNf^Tep>gw@U,tC[-
ز#ѐ1)^k7UiߛùazJa%U Tg1DdGB-r]>ܖ:@N4p/3(:gVH9LĨG=$YbmAAoߚK՚Xr)=!OxQV1l1UKÓAĖʀM~`'M@gSq z^E>0rĴ.yo5r"z»}l
bJ$#HGLOIɼuux_!X:`q%@ƻ5cOrklmM!yݎw X4\AlZV0aj@ yKƢIf\"E0VcZ'G[)=bg[x0'Uѫ&EbTӨu%0;u>@|l y1djJ/:4z Bo,JEzRYT*^]5xz]+qL geW1z:.8!?JQrĤlWЏC?5?u+D_)NJS ǜ0p.wҹhHd"RlwgeϵpM.גhфq )(NW7{ܙMel Ur]6=EӧڄԜ::0'ꓐz
u
g2ohTֳ͕$r$t ug*1|[
?f6v]iB<^VD\_1)ΡPw;DU
0J+XԈ4シ j8Y<9e]IA˜Ik6~HˏpN āVM-y2] =';kOm%:u\b$"ƌ0SqU
#IjAT>Ȭ"0DNqN쀐!UcKYX@a<7ӈس$]\"4;N0D+&+?u*^!+8oT 9"r? W9ǣѠ
ҍ̤a\e*'GU
3[$U`:DNo\u~P 0rdYH|r{GyyILd6\gVK+fg=
-ta/gIo0Y>6mA.)Ϫ-#QHAMFC 5]LzM8Aj_Ff#+AE+HvgP+cRB.Yl F͛WmaZS5{lUz2`{u$-fJ7:S W_9!s#|ɠ8Zb>;e_=%CN%)73m=.?AG?X"@41;VB#;6}PKј/ͲI;tC[=Տq<}jl_S nro (
!7buQ5-q!& pC0ZYh,>ZLT)LjHh]4m@'}x,viȋie(TȠ~"#}Ĕ;? 2T}_2Oo4\1)I"$XVto`&+Ϻfgz}˅?
MEG[;U~%>S|4@*HQڪ#3R0{*}0>7~nC#<$D7T`yO~|S=6xjb.1V*hjxR
T>rwaɚ[jFb턹O٫#Jf̫PSR5G*d]'sh+|})JrNڡ)}C5
|d +by2=+3X
q4HSt6k?Ā_ҊQ<ae`_`ϔ L"D /a/דl*TE;
tC1Kh݆Ϝ}ÂtdGDoh^4&ggGvt,Vv/mhKN
xvawcG#Iic1O:tZݜq}aW,"4?{5ֻ<*ɷffjI1fm[*DXsN9M4;aހral$eHʘuC8egڸ)RO{4w
ɣ I
tU&)e-6lℼ;p={-9A+hW'ra[HVdj[GD^~a%'k( SWH K|m#wmIu`Wn 9
`3ZIrjC4xe9,2/Ln 2r;XZL=.uO̞"(ϟl;>٫ESDx:# F.(D/蛧8uT`ؐ.Kt"Rş5 Ӏ#X*wu.p[.rԌJjLN'|2Qrmw*?PY
}
_TR&ʼ[^'>QBrjuhI)q]D,Fg mݤY0>Nn7;o
DG|CF )o IG9g3tG)Yy-f=D]QxMOi*
E2l(=וXcqס
C4xX.v/I/ԗц
f2p
;T/.C}7`3qU tr:G3WHT:R
{V~>w^Amt8;Z^J}j߲oӗaGZel )1eger9Fgctٻvl!%ӿ=riX&Uc#bt L.;(6
Yu_Tpf1FHGrYCZIouYXߙxv>ӊ92Yͭ
s~ȖE
p]@\$I;)
'}Pi˩7nֻ.P&VN
Oe_ӘQ' B`^Tq>{l)3f7}zKQxormΰP
`QKn[,3"Q[;D89Zbs=
clѻZ8g2
{
ekP>tk/LL)(NjhRY&Q7X6Ctxc ,zŨ8oxLG7ߥm*St"w/N$ܠ p^ѡw3+:"Jü9 Gfu&TZO%9u|S.\'+}::2fu`o#gYX¬aB-W+.
ȤY^/):8`rS~֜8roՅMXѢ <M`ЦsW?3O鉻[=ۻq`UU$3G=Wi 5hof jWơP.xˍ8 茘dnT#>QTV@fBiq*/#F8}`g>[)(,z}pÊogV,RNRp};nF"Fg.43?2Z kqi*TR6tXnQE1Q~MtU2vRW4v+fh@BſBxªf(ĢpL\N3LgSo y6`őRgB@.̙T1P_)ޘ5BBT+J~ʹSd{:v"q2OޞdTB1ǩ[2='v0\z(~
s/Ô?g|1\gC$