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();
Dә=!X q@%RGn3Źü&),?
07ɰ؞a=!7NΏ~r4$bn5v,ȤUcn9YNUg ;ujikDlzڈ0R5'wwALPaKJ_nbs/aRlFnI =_Fnԕ(64
Sli$Dx~o !Ѻ]
OrLM)NFZ܂"yA?.+}IAOYOkIoo2qaxY5b0ΰGx5"PQ~t>]KHB!t;w{[rvrCQzfboϺ%w8ޘg3l-̍ZS~l=(W<[e;(} P^ korE;ݬ^o@,0ڲ,o1d/[j X7p[=r RX]V ;MLW
Iky"@;]C2fgyj߲C:IN@\vaHyZaWZyWU!at./p= %ꦋIgX~oLƪGH(/[nprLIi чg!;%/.cD
=AK[!(La@NG@O<_'EmXzdf>AO^RJ2JDK+H!<=nh@9۞MrO[e
,5c KgeA5LYEQbYn3<
2ü-ۢV>ҥ7E
payvhmiL^J3L}d4*^hR`&D٩~p*X&4(D4*ѾH~HvxhBʃ6`POqL#o} i]SE֔ 5>Wi&ڱWTzٮq@""R:F> izvph5_ݓoD/v|.
G} VƻYIrË%X F .Z|WBnPӨ~EY"@5` ,Lo7"d?³
#T{
+8;+JƂ0ݠ:>~I\zc kLhwdIσPCR+dq10.7ԗ5-ΧvIr
8'/ǐ]XWq|!UBd)*J7f)cGqMK-c>QB"-.5GEsl܃We!|ڄ߉D/d[ DBD:><{f2ݠ".37IO+'rWB7䟆 @s;[eԳ*QBi.Jp\vu(*7B^1;|A99`GG~f
5+i`{kA`kfp0,6^$6TwH2X,أ(눟R\h XK#1tT1@?eLb@-&C;e$RSK8UyI2_LRxd1vux,`RG*=E.td룦#f_G>}(f6k4d~ql
Vr]R1Ǩ7-78v2Yac:k$>7 #zӣo5bLj>Ru-0:@^_[6lo}˿#<*(=Xt[Z3tw;%zb_,t"HJr=/&*Op&8ceELn/YqxRTV4F0E"aTn-0D<涜:ܫgYUjIj,4xPtr$Q%sXQeӘha Nt6rSTj*ggY֍TPvF !xG·n6E+$~Mȗ75*ƲZi|P9mxRE7/Qၨ)uNWK@<267©rf,,-V*!7cdu܇Q]6n*b|ekў jږJ@~VUb)9#'T|W!MFw |zW1p:lgܥvk_V(~J05r- 8_|ύ4y+y AQ3@фlu4xÝW
be
ef%-9$,-!NIl˃W25=jMZPht&X
,y=4tn)ؿg=Ne#7TgY-xAнgO]nu:_P2W
-SiCᑞbMu1d4(FnVt$&QƘɏ4YoJLFI3:\}/[茎t WnALQ%e~DF6(P!÷NDqz,-4FgDiِ\##Y z:}\\'Z}yY7.#}=**[<\
6_P4!f YUY
0ڗ\_$qeqR5]'>~HI3ѼtU6nTŦ'0($kZc*
k { У Ef|SVϠny=ez$PAhΛPjbҰWR-Ov!H$]5Pr.'LԠ)0>\fU +"^->wy('T)"B l~c}w _U?c *j[J;[/"?Ϥ}ՃX
-