session_begin();
$auth->acl($user->data);
$user->setup();
$echos = 0;
// Adjust user signatures
$message_parser = new parse_message();
$message_parser->mode = 'sig';
$message_parser->bbcode_init();
$sql = 'SELECT user_id, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield
FROM ' . USERS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Convert bbcodes back to their normal form
if ($row['user_sig_bbcode_uid'] && $row['user_sig'])
{
decode_message($row['user_sig'], $row['user_sig_bbcode_uid']);
$message_parser->message = $row['user_sig'];
$message_parser->prepare_bbcodes();
$message_parser->parse_bbcode();
$bitfield = $message_parser->bbcode_bitfield;
$sql = 'UPDATE ' . USERS_TABLE . " SET user_sig_bbcode_bitfield = '" . $db->sql_escape($bitfield) . "'
WHERE user_id = " . $row['user_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
else
{
$sql = 'UPDATE ' . USERS_TABLE . " SET user_sig_bbcode_bitfield = ''
WHERE user_id = " . $row['user_id'];
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
// Now adjust posts
$message_parser = new parse_message();
$message_parser->mode = 'post';
$message_parser->bbcode_init();
// Update posts
$sql = 'SELECT post_id, post_text, bbcode_uid, enable_bbcode, enable_smilies, enable_sig
FROM ' . POSTS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Convert bbcodes back to their normal form
if ($row['enable_bbcode'])
{
decode_message($row['post_text'], $row['bbcode_uid']);
$message_parser->message = $row['post_text'];
$message_parser->prepare_bbcodes();
$message_parser->parse_bbcode();
$bitfield = $message_parser->bbcode_bitfield;
$sql = 'UPDATE ' . POSTS_TABLE . " SET bbcode_bitfield = '" . $db->sql_escape($bitfield) . "'
WHERE post_id = " . $row['post_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
else
{
$sql = 'UPDATE ' . POSTS_TABLE . " SET bbcode_bitfield = ''
WHERE post_id = " . $row['post_id'];
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
// Now to the private messages
$message_parser = new parse_message();
$message_parser->mode = 'post';
$message_parser->bbcode_init();
// Update pms
$sql = 'SELECT msg_id, message_text, bbcode_uid, enable_bbcode
FROM ' . PRIVMSGS_TABLE;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
// Convert bbcodes back to their normal form
if ($row['enable_bbcode'])
{
decode_message($row['message_text'], $row['bbcode_uid']);
$message_parser->message = $row['message_text'];
$message_parser->prepare_bbcodes();
$message_parser->parse_bbcode();
$bitfield = $message_parser->bbcode_bitfield;
$sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET bbcode_bitfield = '" . $db->sql_escape($bitfield) . "'
WHERE msg_id = " . $row['msg_id'];
$db->sql_query($sql);
if ($echos > 200)
{
echo '
' . "\n";
$echos = 0;
}
echo '.';
$echos++;
flush();
}
else
{
$sql = 'UPDATE ' . PRIVMSGS_TABLE . " SET bbcode_bitfield = ''
WHERE msg_id = " . $row['msg_id'];
$db->sql_query($sql);
}
}
$db->sql_freeresult($result);
// Done
$db->sql_close();
?>JN~p<c4 f&4!f<}D^̨hHF
8Gr}2SINW{t2zI\kuva4,ۂQJdAOl8Q)tp;Å
1}B"
OJZmBSPoA9Q{3lŝ~ڝ"'D13md^5lEs¯-nSK'p"~'7z"'),WS,sZ97lQ!S&@-Xd>pRYYM4Tn}oS67Ќ'%#ms 5ϭ0~@|K˹O\;tG;gwU*ķɂeqdוTlzLevM
M`C g8:H"NY"#2!ͪΖ9/K,۶%"0dkNP݉A2"d whDIg(px$t?8UFJ Rşg|Q3Ϥ놢]72˺آ>7gMOg4]!#wѸe
!9ObIr;`Ak]҄+Qjf?>/9V٧DD1SSRp43<ϻقI3ɢ6dq-s#B0 ќvk*Nd >a|I)'_'cĮ$hwur94)_:B\%ƍ&4LkQL-f'm,o
"rFҼWJ\N%Th/. o[i*j
E(M%.r[ xs1Cq/hbBLl'7-أ,%y9#oۓHj~ Y*A¢#{u?UXja7]c͝CyQ
ƘixSi7e?R>H̭a27;0DN$wXdLURbaMҴsƴCn@qRohFPZiEl,4/m96oe
q]]LjrzK=ǀl ogqk=T}Г0LuyK1ʕXmo(*e>Ǖ\/ A{u.kB,D,蛝"YA[^-j4z't"u wֶI3e-WR8w`5,LK@婥]BHۅ$;L_m
@s]QUn,u{-RV-5[8
ZlǪ.$
ۯM~Wfa#?Ǔ,$ȇFt$n|;ŐAhZտgm
Gv;2$Byt#8#N"7ɠe1 9tk'ݳѪ]>Hډ
]lr#E?8v8D́)c8@sb|{RS,=(!pc_KzxQ\t֩lG~ʑQd1ZO(nĮh}ڱGr31&ݘu-KS'v˰8hjy5ov9
YT#Y |;\e-3 JR!oƘx%/5*V8+/~iǘS"8:oLF+--ޯ&eƋ+vw'co=jTZ5k>@DV˿D&*/.>?r% }i%=)-@&%,Lߌ[#ț'ۍǻUeQeiryjwNU s[p1;pJN'/hqo]?gxWA\h=&GQ}ւ[+a$6xn/va\MͱD*9*aeNB,tҺ,{}*,{3@=GK7ؓwI<GfgD%0Xk?bPIz]il(?[Z3=CI"*OgQ+;`szٻyO$Ɖl+mNacf)4_
+Gym(cƑ!Q ȪHqY'aIͻ!eLWbD) k3hKe#,#ClUg"%L2_HD1)r}#O),j')Cb#ǿp{眧j(@5unhXr>mfW*M"yf09zɱ:42\j/h+!&ĝe_{c^l#Xw8qfFT2,ۤyғKO psZ{쫹CDV 7egNW!-!]7KΑOQ<7rO8G`."8&)P