diff options
Diffstat (limited to 'phpBB/develop/adjust_uids.php')
-rw-r--r-- | phpBB/develop/adjust_uids.php | 129 |
1 files changed, 0 insertions, 129 deletions
diff --git a/phpBB/develop/adjust_uids.php b/phpBB/develop/adjust_uids.php deleted file mode 100644 index 999d9a076a..0000000000 --- a/phpBB/develop/adjust_uids.php +++ /dev/null @@ -1,129 +0,0 @@ -<?php -/** -* Repair bbcodes converted with RC6 -* -* You should make a backup from your users, posts and privmsgs table in case something goes wrong -* Forum descriptions and rules need to be re-submitted manually -* -*/ -die("Please read the first lines of this script for instructions on how to enable it"); - -set_time_limit(0); -@ini_set('memory_limit', '512M'); - -define('IN_PHPBB', true); -define('PHPBB_ROOT_PATH', './../'); -define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1)); -include(PHPBB_ROOT_PATH . 'common.' . PHP_EXT); - -// Start session management -$user->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 '<br />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 '<br />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 '<br />' . "\n"; - $echos = 0; - } - - echo '.'; - $echos++; - - flush(); - } -} -$db->sql_freeresult($result); - -// Done -$db->sql_close(); -echo 'done'; -?>
\ No newline at end of file |