diff options
Diffstat (limited to 'phpBB/develop/convert_avatars.php')
| -rw-r--r-- | phpBB/develop/convert_avatars.php | 65 |
1 files changed, 0 insertions, 65 deletions
diff --git a/phpBB/develop/convert_avatars.php b/phpBB/develop/convert_avatars.php deleted file mode 100644 index 4f090451d6..0000000000 --- a/phpBB/develop/convert_avatars.php +++ /dev/null @@ -1,65 +0,0 @@ -<?php - -// -// Security message: -// -// This script is potentially dangerous. -// Remove or comment the next line (die(".... ) to enable this script. -// Do NOT FORGET to either remove this script or disable it after you have used it. -// -die("Please read the first lines of this script for instructions on how to enable it"); - -// -// Do not change anything below this line. -// - - -$phpbb_root_path = "../"; - -include($phpbb_root_path . 'extension.inc'); -include($phpbb_root_path . 'config.'.$phpEx); -include($phpbb_root_path . 'includes/constants.'.$phpEx); -include($phpbb_root_path . 'includes/db.'.$phpEx); - - -$sql = "ALTER TABLE " . USERS_TABLE . " - ADD user_avatar_type TINYINT(4) DEFAULT '0' NOT NULL"; -if( !$result = $db->sql_query($sql) ) -{ - die("Couldn't alter users table"); -} - -$sql = "SELECT user_id, user_avatar - FROM " . USERS_TABLE; -if( $result = $db->sql_query($sql) ) -{ - $rowset = $db->sql_fetchrowset($result); - - for($i = 0; $i < count($rowset); $i++) - { - if( ereg("^http", $rowset[$i]['user_avatar'])) - { - $sql_type = USER_AVATAR_REMOTE; - } - else if( $rowset[$i]['user_avatar'] != "" ) - { - $sql_type = USER_AVATAR_UPLOAD; - } - else - { - $sql_type = USER_AVATAR_NONE; - } - - $sql = "UPDATE " . USERS_TABLE . " - SET user_avatar_type = $sql_type - WHERE user_id = " . $rowset[$i]['user_id']; - if( !$result = $db->sql_query($sql) ) - { - die("Couldn't update users table- " . $i); - } - } -} - -echo "<BR><BR>COMPLETE<BR>"; - -?> |