From e85f9f79bc892533e8b67d80ae265167f2e5d4cd Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Wed, 24 Dec 2008 13:14:24 +0000 Subject: remove no longer necessary files... hooray git-svn-id: file:///svn/phpbb/trunk@9221 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/develop/adjust_bbcodes.php | 174 --------------------------------------- 1 file changed, 174 deletions(-) delete mode 100644 phpBB/develop/adjust_bbcodes.php (limited to 'phpBB/develop/adjust_bbcodes.php') diff --git a/phpBB/develop/adjust_bbcodes.php b/phpBB/develop/adjust_bbcodes.php deleted file mode 100644 index 27af105f28..0000000000 --- a/phpBB/develop/adjust_bbcodes.php +++ /dev/null @@ -1,174 +0,0 @@ -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(); - -?> \ No newline at end of file -- cgit v1.2.1