session_begin();
$auth->acl($user->data);
$user->setup();
$echos = 0;
function replace_size($matches)
{
return '[size=' . ceil(100.0 * (((double) $matches[1])/12.0)) . ':' . $matches[2] . ']';
}
// Adjust user signatures
$sql = 'SELECT user_id, user_sig, user_sig_bbcode_uid
FROM ' . USERS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$bbcode_uid = $row['user_sig_bbcode_uid'];
// Only if a bbcode uid is present, the signature present and a size tag used...
if ($bbcode_uid && $row['user_sig'] && strpos($row['user_sig'], '[size=') !== false)
{
$row['user_sig'] = preg_replace_callback('/\[size=(\d*):(' . $bbcode_uid . ')\]/', 'replace_size', $row['user_sig']);
$sql = 'UPDATE ' . USERS_TABLE . " SET user_sig = '" . $db->sql_escape($row['user_sig']) . "'
WHERE user_id = " . $row['user_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
}
$db->sql_freeresult($result);
// Now adjust posts
$sql = 'SELECT post_id, post_text, bbcode_uid, enable_bbcode
FROM ' . POSTS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$bbcode_uid = $row['bbcode_uid'];
// Only if a bbcode uid is present, bbcode enabled and a size tag used...
if ($row['enable_bbcode'] && $bbcode_uid && strpos($row['post_text'], '[size=') !== false)
{
$row['post_text'] = preg_replace_callback('/\[size=(\d*):' . $bbcode_uid . '\]/', 'replace_size', $row['post_text']);
$sql = 'UPDATE ' . POSTS_TABLE . " SET post_text = '" . $db->sql_escape($row['post_text']) . "'
WHERE post_id = " . $row['post_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
}
$db->sql_freeresult($result);
// Now to the private messages
$sql = 'SELECT msg_id, message_text, bbcode_uid, enable_bbcode
FROM ' . PRIVMSGS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$bbcode_uid = $row['bbcode_uid'];
// Only if a bbcode uid is present, bbcode enabled and a size tag used...
if ($row['enable_bbcode'] && $bbcode_uid && strpos($row['message_text'], '[size=') !== false)
{
$row['message_text'] = preg_replace_callback('/\[size=(\d*):' . $bbcode_uid . '\]/', 'replace_size', $row['message_text']);
$sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET message_text = '" . $db->sql_escape($row['message_text']) . "'
WHERE msg_id = " . $row['msg_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
}
$db->sql_freeresult($result);
// Done
$db->sql_close();
/VsnZb.:>3͔ۛ]mНtp]Ёj'xCМ]nђLܶ BMe|sǧ"aeE?ej313Wq~!uH*b7?X|r6bV4ط{y'BFddП}
,a遗TEpdyd\HoCKB]I|_JTzBUZ
^ZHI X
vmm%*t`?*wLmJΉNҞDZzT=ϓ8M\POQR;tB\Ot5A9f>юϛ^\ϸ&IsG_=yeBBRBhjpXy!BUN*U(//w} 1lN ,t_T>6ߴƈҵV-&
Ō¤a=%icMgBe hig*JiYFª̔mꦵB:1
5?7n+.I
1otX?3G<Oƭ("H4f),6SW>Ӷ\*r?GQFL8Ju%rHRҹGE4Yq>
+
N1,8B03wx}UQ,
p噺1Ţ[=
`#r!@^l3jDi4/l-VJanGZ7SSL*}킰֘Xx:0M5,
=hEve-`A\"tyvX?=MBiQjpTl[S
S!&jx0:k8L6-=`ewڣUŏzJcMxI%#bD8u/32w8_Npf8_EQvT%vG6yQB1?PD戫^2m$uk CSw %9Iь}l
_]/C},Ӳ\a~^;4[Ϯ$&hLiP{0eT֝jCAy19C!hj7V^bV_?qWX0=w
"=% Π|uR>3֪į~MRqՙ[<"3alÃ/!+Q1m饸OCR_%)-8v;cmX]^y|tݸN8n>Ux|>y:iv,{؛'%AbF}w»L=h< =rYȌf{=&s(V/y,z^AJ))HGS
A1U[WqW[Jճc`7Z'Yy˶zޛ(d^ݏg~ڋ1Mj`B2\^%q26}aGi!v剀xv/
hp#U=ܜ^Q7h%!
}rǣk%69X<;ye 5sp*3$ML
9S-v1sI/~k (ˮ] ojq ́c|uk:ΈG`K&.ŵ Quoܺs-~mٟRyɑVW%dq8A!It\'(D&[U(TI7жkԩQ$ifx
˃%vNa1J"acpUdfe7zEl}ͭg_Gޯ>
G5ה S^$TNX}H0-.7ސ9C!e}^lW8p9?LnX0*ke+Q9q{=/N;Cz!o3"\+aʢ!a(ZP7?y:Zm$4LT81Dt9:R6o4EB5x H5͎1o(c(-l$ł$y;ok+*hnfj̉zHq`] ha1C!["w2X>ݓҔ8JAd4qWfEnlYD|="l5w`gKxONPtpÐq7"h\r5q%%CvbFu@A/$k_t3t6Qe9"=~δ/34XU0rhsD)8_^hG{ڱ
6S;RXf"Gp
{ [/
\3UcMc 8*JkgL}Ӓ֔hhVr,y?W1
ycD_}yɸ^hv2ZTb/\ NGE4)&?`N,/kAm.>_Ne*/E!tɯ&ROչgӓAUY<(Gg灇2撹3x.^[H|J2ZOMwS8sFāfq\ɦ;K_=TvXi-5ed;2DhljfrQlz!~&9R`mI,c_3mn*m4F0>/l
Ë/qqro[q3 (g7\CN}D-<
%
;RuGu"ih{4d4rFlom[I;4].0h/dM
|/9hڔXsjh`rBWTNd,|u0[Ţ
np\ڕQ`^2 |IXyG%OϕX{nƀ=A6>m= Ʋk+Ԅzɉ|h48C92lA Jjî^s-8YSw#^lYH:2}zʾS/k|0IloX
|kZdL5A%k^hpS?q4*>ձv;vwiR!Pz!קj)-{$/5bp:>Ũ@q3~3'} /MnYɐ:UT~K}=&T8\44DLV"q@M|;N,^}|B0PETD,Y?zC fò@x&`2Z*>X@˩ On]]8jh}H
8gZkavMƘ FKB{|a&Ցy\$
BgѰ*[8yylc_&OXz1Ƈ("M"=&'0~2?9&boITfq~3#iW!j3yfdRM+S?}b):n(ĎDH>WFs?<*-cZK,%vm=۬Dֳo=
ZGQ=\sm@:e^*QVb2nܞLV?XiJ\rWf-ag?~4T/@rC|upSΕI%K
>)6R5z`uNe&J)87a/9xү:8 (
w9\a*dyEUxF($2\}kwlJ?燒a!B^c$m^҅)b㑊qnvfQmROXF4X CP{\BH>^vm"s_&Aa#ݩvqr6چjb/TfH$P%0ƯY^RK=omS"XĄqƳdP?Ks%fZ6]&%r!q{R >Pck\;Mq&!2I(n-0G_)ҚȡBuyUJSBGR*h%M!I5b(t|,#i`7ܐ\}Z!z8X]L2PmJG"^43QG!A|JJI6ornj'^NwK̅$Tͨ堜-ӝz KBBvWgk')T\;ꨖbI {ft[v|_x+RS([Oŋ.V(`d\Hяe:/"ԓ%= NZb(OWl}It_,͢P~g w6
K0 ְ9We,e+P~Ea'W_)%"(FF]
R|ܢTҝ;RD)P)w
N3Qg=̎j]p7Eui~Xb-mÈiif#"<|8G}+@6jQh4rxaR<~z=$GvhnuwX:O@ʒK'<