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';
HšjZ#%wszҔokB-v[q͚|vbyAV]G?@߁bBc+yF*51"\ rn@zבӭ: Vj7c}-m;X L
w^Xsg '
mJv$*o\%L-S>Q/,ح{#C=KGԬ{ªv{u?]*w:$|d25jᢊrUtǦψjdY0ySz+5Zfth1bFd,-NJf|E`D m_Y[X+AeTٔk{y?+WVAmS9m`0>8̞cm~Ck;>'>S~+@M~PX{c%Rѫst濅i
+@u)."TN"]'fӜ}ma?we
KtVJpi>:g5MI+@֫RIio7AP&oI:cпhTG".LKA0Gzѿnb^=5mu$}(Q?.`GpTW?9;5Q6~e8]p?lt\hA 6LyKiq*JjEo #
<Ό9.RiM238he2}mHt^̷<49+Q#yNVj]S@RpebӀapA~
&;=#(SG85']_YAGg|b܍ٸT{#hJz:U:
>-Rdr5sIL +ӟq<ϲ(
M6܆ ŌO'j'm
ޑR9m2^O]w0zn
rYWVycV?7K4T[4uȪ\/q0sm,eS]I-c]N˵=Vsҵ; I@bp/^N%.=4/#nH߂|2dQQ=sH-D
|MO=Gğvᶮy{_0U'ENE-8VD2"YInJ}G#]!V( 7*V\fآ6ZSfj{9KcLE)b z_֠$ HCpZ#z\Ǻ˼ 5FE?+Ԛ!B2wÙkVNy[b!QY䢲6iUWlKG<ݘGcֳ%Z4^
t:h-Ly5^ij9>`L#P]ѥ2K"W9fU1{OϾr!OFAVv#&㺠˳ld |FL9XQ>3 a(t~Z5SD{P3IiQ2Dt}%ǕkkC4ȰolaޚRKט1vopX|2NcM:Med0{k{ _]B$$}P#Ԉ/Y~h6Wպ0xI->"9QCWTX2op8ѹFIQ\å9]Sp|@8Ma`Ɗ{]7A0[h2Xosq ڎeMtNL=WvR7Aժ`Mt `K(A8N[6zyPiYMQz̋p=|
=~=x4$e5-alrTpޅc~{yJ_ eX/rI7gQװab>ݿ?\.'Y,#bgI%w)j4g&:k+.ZV|4p=$;Rub ͚)B\s?bȕK}:PeĠם+A5 Vb$o2#ayD\a?n"x6c=ړ#ѷ/f6ReA6QLBV`e#V.d2OQAZ0`&'YMaPeҠ] jnL:v0)tb >I2myd,c;goXЋ cc~RpڬEW*(8&6;zx$N);clɽaB G<SN/0$\\
EzndR~aTE +bjMbiyXl$3+ԆR%m1,}ɎحCZxa_kv
jEƵW8Tu2 iɼQ쮗E&pj
f{7QEȃnne'!}So2vahEE[]aտB%Lec%/
I-lFw:.l~oIDiKL6H8&ffePi.B%$1X\FTq[cQS $I"ĚCTv@}1NoDd0sGHVm
筬0G
Ki&WǍ(nC