diff options
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/develop/convert_user_regdates.php | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/phpBB/develop/convert_user_regdates.php b/phpBB/develop/convert_user_regdates.php new file mode 100644 index 0000000000..15d397ef36 --- /dev/null +++ b/phpBB/develop/convert_user_regdates.php @@ -0,0 +1,70 @@ +<html> +<body> +<?php + +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>
\ No newline at end of file |