diff options
Diffstat (limited to 'phpBB/develop/convert_user_regdates.php')
| -rw-r--r-- | phpBB/develop/convert_user_regdates.php | 84 |
1 files changed, 0 insertions, 84 deletions
diff --git a/phpBB/develop/convert_user_regdates.php b/phpBB/develop/convert_user_regdates.php deleted file mode 100644 index 21737edda4..0000000000 --- a/phpBB/develop/convert_user_regdates.php +++ /dev/null @@ -1,84 +0,0 @@ -<html> -<body> -<?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. -// - - -chdir("../"); - -include('extension.inc'); -include('config.'.$phpEx); -include('includes/constants.'.$phpEx); -include('includes/db.'.$phpEx); - - $months = array( - "Jan" => 1, - "Feb" => 2, - "Mar" => 3, - "Apr" => 4, - "May" => 5, - "Jun" => 6, - "Jul" => 7, - "Aug" => 8, - "Sep" => 9, - "Oct" => 10, - "Nov" => 11, - "Dec" => 12 - ); - - $sql = "SELECT user_id, user_regdate FROM ".USERS_TABLE; - $result = $db->sql_query($sql); - if(!$result) - { - die("OOpppps, that didn't work!"); - } - - $all_old_dates = $db->sql_fetchrowset($result); - - $sql = "ALTER TABLE ".USERS_TABLE." - CHANGE user_regdate user_regdate INT (11) NOT NULL"; - $result = $db->sql_query($sql); - if(!$result) - { - die("Opps, that didn't work either ... oh damn!"); - } - - - for($i = 0; $i < count($all_old_dates); $i++) - { - if(is_string($all_old_dates[$i]['user_regdate'])) - { - if(eregi("^([a-zA-Z]{3}) ([0-9]+), ([0-9]{4})", $all_old_dates[$i]['user_regdate'], $result)) - { - echo $all_old_dates[$i]['user_regdate']." : "; - echo $new_time = gmmktime(0, 1, 0, $months[$result[1]], $result[2], $result[3]); - echo " : ".gmdate("M d, Y", $new_time)."<br>"; - $sql = "UPDATE phpbb_users - SET user_regdate = '$new_time' - WHERE user_id = '".$all_old_dates[$i]['user_id']."'"; - $result = $db->sql_query($sql); - if(!$result) - { - die("Oh damn it, now that's really broken it!"); - } - } - } - } - - echo "<br>That's All Folks!"; - -?> -</body> -</html> |