session_begin();
$auth->acl($user->data);
$user->setup();
$echos = 0;
// Adjust user signatures
$sql = 'SELECT user_id, user_sig, user_sig_bbcode_uid
FROM ' . USERS_TABLE . '
ORDER BY user_id ASC';
$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 (!empty($bbcode_uid) && strpos($row['user_sig'], $bbcode_uid) === false)
{
$row['user_sig'] = preg_replace('/\:[0-9a-z]{8}\]/', ":$bbcode_uid]", $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 '
User: ' . "{$row['user_id']}\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 . '
ORDER BY post_id ASC';
$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'] && !empty($bbcode_uid) && strpos($row['post_text'], $bbcode_uid) === false)
{
$row['post_text'] = preg_replace('/\:[0-9a-z]{8}\]/', ":$bbcode_uid]", $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 '
Post: ' . "{$row['post_id']} \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'] && !empty($bbcode_uid) && strpos($row['message_text'], $bbcode_uid) === false)
{
$row['message_text'] = preg_replace('/\:[0-9a-z]{8}\]/', ":$bbcode_uid]", $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();
echo 'done';
oq/ww₃BYAc21H !I #"&q` H D)B@QNT/%rv$dh!aJ F :jij1#>Nm4[*-XLWsH#4)'3uD[Lt$X)[j"*E]IOg`aˌЊA@~5j_Lٹr!Hn"2B2.O{`$
PU ,A@PPXO2T(Th)5A@_O暑$S$!Ī` =0?@
>~:-oECWHx,|r
i_C:&'BM$
,!1MʉRfj)&<#taJ-.TG
A6q7ۗUstPEpa
3N',V͆=âM!>DwۥSN
UA{1
9CᢚlC`m8듮Ws_giMIn
Vku!h22m_&ݟ_]D_-/2ΰ[*tp>t=0Obm
~ylqOhLTO@`
B*/{"XJrڻ2OeL1"X1%TrtEXCr""H
/E(J~*׀JU n*D
>I&%R{I(A^緖xcϺ'? @?E/T=AybֶZDc0@:fϷbxQ?$A|"T
ϾR H=x ]/1ќ4A{J\+85] @@Jd@Va|gWR>Rŀ$
ċ$*RR
EPbtdw!rYFzj9Q
Au+
g^!?>
,cUﲣ_`lwPQIL[g?ǛAH=˺@0S8!PܶZml0@LHSP r! J"#2\cd~y`$@w
)hzX::⌀#(~S0I!99IB|4x9g6O˘+OL?=*>-jH1!ݞxeEJ蘬C{FwmVODy>,a){`g~/@_>4~?0qㅒJG1
PQ͋}x8TwV LI6o|~O
W3teUB=?T'<4'!!`F!' ;zkϛ..!"ЈeAЀy7ӿv/023oW^[o9X +ʷ*
>y}^秷O,(b>&O6c(E8!Izexq>@=O]ԎL
HGyA;kT1D윈^HA! |^ӶS.@%$DCUCi@IWf%5c~SW:zYgשׂlOzJ}~1~W1Ɂ
o-ȴg˻KZ4
R7\ϴeGhQ.WN3wӖ=$D$dh<)XEbljI@|7]=^?ɼ $H=(C !<p~ P$\IZ 7ā녀,P祑Ր,%U*(lk 7qdPDd&2VBO)q$A;ҧf>+'M,h(T0B}ekF:F1Gk`Wo|շxƱLRG;]kƱXmOA@H@a]k%w}*$`¯n|3~ͻQ@uk7*'ѻ`j\>gXP,Σ|0xupUʑJ:UQl@iIȁg-̰b;[FWW]t@P"1bHyk\o+n|<{3Cd&HξcN]"kpPm ԡH _{mX1̀%4g$g)f.N-M8@DE$EAHĐ~z?rhٯxXQ) 9WfChDfoֶ$D!E !z0+A,.b_dJ[=3jv
/E Ң(Ȑ "A ȨX*^[ 89Dez>]̱{
xj:pۿqDGu.o~2Sv=اH}W\A @iD~$ L3 Q;- x@U=i@T6 (( T"q Ӄz8i7ѥj?Z@p1Հir!@^?ʪ@N~.Q 0|ժBA]nGeGD]VTa_UƊ{t?dx&'P
p/O>c}T$IB@:?TA|͌;ᄡ jU[&iR9LH3kgI0pBCw|>K^!H:']~TX:EM:Q\ r(͓;$""tok_xx("Ԯ0ja`0TȴU
p
+"*
,P*+Q$ A@V$y,&vT"Ry/hQ`q4QZ#e_ɛB h ȍFHn;6ܒ ?p(d*#ݕȻlRh=D~=Ob @EKU$VCީꂅpqG;&g.H!5q,[q˛`hbfeRyY)Q7\ TЪ$iEͣO)~|낋'C#'Z}$BRhUeUd ,7|Ì5)Ģ"!d~zD4nqQb`