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_usernames.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_usernames.php')
| -rw-r--r-- | phpBB/develop/adjust_usernames.php | 52 |
1 files changed, 0 insertions, 52 deletions
diff --git a/phpBB/develop/adjust_usernames.php b/phpBB/develop/adjust_usernames.php deleted file mode 100644 index 4bae774634..0000000000 --- a/phpBB/develop/adjust_usernames.php +++ /dev/null @@ -1,52 +0,0 @@ -<?php -/** -* Adjust username_clean column. -* -* You should make a backup from your users table in case something goes wrong -*/ -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); - -// Start session management -$user->session_begin(); -$auth->acl($user->data); -$user->setup(); - -$echos = 0; - -$sql = 'SELECT user_id, username - FROM ' . USERS_TABLE; -$result = $db->sql_query($sql); - -while ($row = $db->sql_fetchrow($result)) -{ - $sql = 'UPDATE ' . USERS_TABLE . " - SET username_clean = '" . $db->sql_escape(utf8_clean_string($row['username'])) . "' - WHERE user_id = " . $row['user_id']; - $db->sql_query($sql); - - if ($echos > 200) - { - echo '<br />' . "\n"; - $echos = 0; - } - - echo '.'; - $echos++; - - flush(); -} -$db->sql_freeresult($result); - -echo 'FINISHED'; - -// Done -$db->sql_close(); - -?>
\ No newline at end of file |