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';
"##QCI*QHbzI>YP5mG$嚭vtu*CKn6`H;Σ
!;HqFblB`&C /1$їEcEj"u?Md#Ֆ1Y'2}{ |i!S`$k㘒0QrV͑ ZƄ| `2U9#:M'Upc3#0@B,H0Y;Mj`agK=$Hyv
mP @}' CGOLyP6Y
B64Ыb}~A?VH/E?5Xqx^v6!C$M^mkٕc6DƟǖ?<
Mؗ$Fkq9\tzZvhUF5%$AN{>gWc!̱d2֜!ZaJ0U0}JH*1`l/ص
V2+wmi\Rd`:z>i%Q&'sK?Bc5zl0I*#~FVkz!9֪GdW@AQ 5c?jdDvmq4SYuF}7:\
Mxi
ATH`L)0H<-CAeD')blyϡ7o4p{-Քc?䵲ے*<רҪhZG0:j,Ę
Cvjh)j,?._ &wx%Ô汤"rD`I] (*/Qo\Dg\^I
k\Ҵ1*>Szgz r}>2EO0KQw- "i
e,A 9ZH3R-|p! j" %Klp ;$o1pq5[fXԬ
n|VdMBTƃbQaX
hvlPEQ>qI%qV tBE(b䨠B@L /̬@6hܧ)IXosAQl?/UJGŵUNp^ڰo&U"KKHmG
gRB뀼LWAN<ͅ;l9ШzQVxDxEU3=4G SM0∕3)]o5vgfs狙s eMc4[kYi:UT(!b
jTd]f "@R,P P, @I
29܁!ā!e;F*x* 6j9$%$f(ll3bp$YA*,tZ㞊[8
sGI0FDpXBDU SN_*HoIޤtrhk2)qsaWE+/F(]9O?W5ljTGSqQ(TX;s$QIYVyc'h-ǀrWr_I"@=5 }$lhPFNAEB'KmXy>'/u[5HhHbZ?w
>G
M8LAbBd쓟jܴFȴpxzp"6 TWC@JA5405M6H:zL.['m?n]9/*ZIZ˗vwNAP,̔ ˱~K9D{rJE5,loxjǸiva>H RiGѲ-z#0=Xqn
Z͍/˱iѼ~;E]R҉Ic9*[ǀ4i pR/B}e^Pb I0ebS?yy9[-HF#t${`7qβHJr]kOkd^1ЄeJkDNp`9x?ɱb
yř$ЫhlcLI?+XK2bAS]eY+ͅr#9ҟu=DJm&%&QAxIA4SA'~n+ a{;fXsܗi12~"'Wkb^B?{INozI`#S4.c^/R].izԴB`wm}<$VdY% :6IepMbF1`"~O_"LhNuI}=?^_2-Y`Z c_;)[;ɿ^;V~䌢G}ufKyXԒ',R"ÐIp2ɬ+(")|ؼ¿1(@ZE!1Y-Vch1_K"])
b!ZqHaq^+aԜ ~OKMZ_A?שa^M%#^¤+HlsGBf~kܽH>G
$eydJn|kDF@ߛ(
锞wl܉+@')Iz4!cGoI}"{Il+h|#M$
M\E(=n,GDL|$Hlw>vAEVU!Pmt}U0
W+sfkK$-2w!.> x@wބZt_nLy}N;vP S,i[{EI)s2~HczQc/"5!0Jf hVG?wNB*_r<硒6dnTĭ1 ߂2&DAKެU|D5H'"H/ 윙-_?|?etOj넛 Gb$j)>|zM|L@@/SyO8l6x@*Z}o,3A[JNJaͮtE?/ %LGf}d^=2+Xxb|iBc>~
_tjd{%AL.$ѐt:g?(S<ӚI{1!Ng5LK `_ -֢nRq_ [1ѣ1SRtw4Pl__rgG1q>λĊvV}9v[BfJbALhi"h_HGPQ f6-Jd?ΝtAM!e ]UjV²J
@Կ(S*~e0'JdgO ZE*C.2(6`*փ$^@
([CbԀh
|ק