<?php 





require_once("mainfile.php"); 


global $user_prefix,$db; 





$months = array("abc","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); 





$result = $db->sql_query("SELECT user_id, username, user_regdate FROM ".$user_prefix."_users"); 





echo "Fetching information for ".$db->sql_numrows($result)." users...<br><br>"; 





while($row = $db->sql_fetchrow($result)) { 


        $date = $row['user_regdate']; 


        $tmp = explode(" ",$date); 


        $day = substr($tmp[1],0,2); 


        $month = $tmp[0]; 


        while($month_name = current($months)) { 


                if($month_name == $month) { 


                        $month = key($months); 


                } 


                next($months); 


        } 


        reset($months); 


        $year = $tmp[2]; 


        $unixdate = mktime(0,0,0,$month,$day,$year); 


        echo "Converting regdate for ".$row['username']."..."; 


        $result2 = $db->sql_query("UPDATE ".$user_prefix."_users SET user_regdate=".$unixdate." WHERE user_id=".$row['user_id']); 


        if(!$result2) { 


                echo "<font color=\"#ff0000\"><b>Error!</b></font><br>"; 


        } 


        else { 


                echo "<font color=\"#00ff00\"><b>Success!</b></font><br>"; 


        } 


} 





?>