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})ϡA0*r(a'F")?)&
Td?qAmk}/~c;MXC-7u8fRLMOH(;>亂[֞Lpx]nyl9%vIz:COT)
dm`awM[S9 jמȋ|Rz0\?u4T䲇'4=γ综ժoQ613gyՊAHb)$u7^jF.qZd;/XYVLtL9V% m&f9KYl
I$HaH"J_'xãA= о!-u@AXrV~!,#wac-]4M뤊
2D)m|< 7aR&lٱT4gцaA`GHS\H5rSI*DjR!K{ҊDjRgszA5:R?|'TO9sL%=3!FL\ަkj-tE&nԼQ4b~sbx +GIxPpcGO=Jpq<HXUXuGgꢕLDfо|Skcv"+Z%TKڤQBTTVPx#f wU̩Oj$Ebf&մ=ebڶHx)$[S?L0f $V(9! S4$H2xyFpܒxRe犇z^^hkw*R+T֒H4]VךФ<^lӥ5L+BlVD)JEUR+@~EBa2̈́v=Y;8ViM4g۴!L
Tg6-t-횾$pT "P{w:hp7tT
`,][#=VԎ)j>0bqʆIM,#hrSյ^̴=]WTڗpmɥ$kIݝy?~P)ԀP27{O|A}WiZcb66f?c }Hݬs'l?5=-/ٯ#;Gf|V#:n%LbF.X `/Z S%{$
!%4.؆B8֍ݕS_ HwA2i>䃴YP/EB4xza
7zi'tBY??R0Q1&_y@4[A7֬;JV(DޡF%& mi!CLlL^\A0;7˳
*/H9]1?K"n" Th8m4ߵ.J^O~e@SďTL[KvOZA&&~G~hp.;S*oL$Wb$Iڽ Y'GٗE֖7^ձ4Ux7'=p62HW {ǵHc?몈H]o~<E\5o/2"2hllo%b>B
F4W;ZT6 P#l#8@ψۃ%AD@@[%ẽ0у쉦xKxist>(Mj@y]45iB5>Ww罬Ld&^G).zJJ irA'`t_JS|NǐFiCK6}$U2 adN`
8Ҏ2\$zPp-yz]KNLE_!vws(('$}K?Lg n
`:GO|K4y=gHmHE[joDї0o#276sz2Z7BRX8~l`M.)oKT=8-]5i}+qB C3Sܒ\$11Na"'6twr}RL猓!1r-ɭ^Kf)gcfΈI18IN_=Ikk!܋Mt6|mE_}ibCȰо.ƨ&"HC
" Sхd#0T "XCw?>@x Ezb&յp˻.|A):#x%(X=b*2 ygqS*$}K*OIiY|z/[g4}r5-|a Kg:#7&+k/K'$NKJk_4Z"i#agIά9K2l $$80l0!FqPcrƁ#pa .a@?d'#`=
*8`3T`FGLf1C5LH"MA #`ؒÃT mXRN fp$jdT pqÎy͉27ᘋ,H"29Y'Q&d%KfP $5ΐAp 9=D:IHI!Dw(([",Z!v7Yc-. 8,!c$oL{|Zg3C.(jWY:sobNk~$M&LHeF%($$=a
2tfrIP$$?HbiB$4l'P'^.tď31*^U}VZ4-bc>.TϠ"dTlԆtoK566ٻKzr1
\<{uV{|Af03$ި%`Ү[GP-Mi[YjMUsط7UDp'.Nז pSmI@ͼW,|f~aL>'1<"PIA:6`s!S?LqC)C>՟+伂aq\`\NH6=@S.ӫ{[c݁v!W2bc?vsؔ-it}" ]
<8@ V%Sn+30WЮU&)Le"N.R:g0Ipj( $Hu0r,葉$qLx^@LA~3{ ,gM6LO< 4o33.L1>/ F`@A;-_~z|YZp:Qkm aT" "BI= `0c^yW#-50lJg
v4CCO,-U-OuB\~13yjo]I!u!a4c Is0/Yhjd v׆x# K
$
?Q[TܳZN j! e{˳g?th, Ȧx.K~uUv[ -L`RM[A۲yqY!?oO:\/Kk?~)ҧV0 }/
m|+N` wYZ(+f/w[Ɣ#kR?y%emʩ/'qqiN3Oɸ6ќ@L=c
Ȯ#I{Vj/Wz$v0N4z혣kj\A