diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2008-12-24 13:14:24 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2008-12-24 13:14:24 +0000 |
| commit | e85f9f79bc892533e8b67d80ae265167f2e5d4cd (patch) | |
| tree | c6d6e55e75c2cf80cc380f5540a8e62b54e0c3c3 /phpBB/develop/adjust_bbcodes.php | |
| parent | 8c9af252cba9c0d61351f7eb14e983b23b0c4256 (diff) | |
| download | forums-e85f9f79bc892533e8b67d80ae265167f2e5d4cd.tar forums-e85f9f79bc892533e8b67d80ae265167f2e5d4cd.tar.gz forums-e85f9f79bc892533e8b67d80ae265167f2e5d4cd.tar.bz2 forums-e85f9f79bc892533e8b67d80ae265167f2e5d4cd.tar.xz forums-e85f9f79bc892533e8b67d80ae265167f2e5d4cd.zip | |
remove no longer necessary files... hooray
git-svn-id: file:///svn/phpbb/trunk@9221 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/develop/adjust_bbcodes.php')
| -rw-r--r-- | phpBB/develop/adjust_bbcodes.php | 174 |
1 files changed, 0 insertions, 174 deletions
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 @@ -<?php -/** -* Only adjust bitfields, do not rewrite text... -* All new parsings have the img, flash and quote modes set to true -* -* 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); - -define('IN_PHPBB', true); -define('PHPBB_ROOT_PATH', './../'); -define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1)); -include(PHPBB_ROOT_PATH . 'common.' . PHP_EXT); -include(PHPBB_ROOT_PATH . 'includes/message_parser.' . PHP_EXT); - -// Start session management -$user->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 '<br />' . "\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 '<br />' . "\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 '<br />' . "\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 |