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(); ns
context:
space:
mode:
authorThierry Vignaud <tv@mandriva.org>2008-01-12 16:38:23 +0000
committerThierry Vignaud <tv@mandriva.org>2008-01-12 16:38:23 +0000
commit6b5820883fc8a2fc716345c8c6b99a58d81a6751 (patch)
tree4c9dcea46778dea6954cc50fb8fb861bbfd2e2cf
parenteecf94a45856bb44d84a1282a19eadaec8682cc4 (diff)
downloadrpmdrake-6b5820883fc8a2fc716345c8c6b99a58d81a6751.tar
rpmdrake-6b5820883fc8a2fc716345c8c6b99a58d81a6751.tar.gz
rpmdrake-6b5820883fc8a2fc716345c8c6b99a58d81a6751.tar.bz2
rpmdrake-6b5820883fc8a2fc716345c8c6b99a58d81a6751.tar.xz
rpmdrake-6b5820883fc8a2fc716345c8c6b99a58d81a6751.zip
sync with code
Diffstat