[Takamine334]

PHP Code:

<?



function  dbconnect($mysql_host, $mysql_user, $mysql_pass,$mysql_db)
{
global $link ;
 $link = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
    if (!$link) return false ;
   $select =    mysql_select_db($mysql_db);
   if (!$select) return false;
   return true ;
}

function get_date_time($timestamp = 0)
{
  if ($timestamp)
    return date("Y-m-d H:i:s", $timestamp);
  else
    return gmdate("Y-m-d H:i:s");
}

echo "<center><font size=8><b><u>Users Import Script</u></b></font></center><hr>";
echo "This script will now import all users from Vbulletin forum into the database of the tracker !<br>";
echo "If you see any error message, check your config.php files and put the right parameters inside.<hr>" ;

require_once("config.php");

if ( dbconnect($mysql_host, $mysql_user, $mysql_pass,$mysql_db) )
{
echo "<li>Connection to SQL database was a success</li>";

$res = mysql_query("SELECT username,password,email FROM ".$tableprefix."user")  ;

if ($res) {
echo "<li>Connection to Vbulletin users list was a success !</li>";
while ($dat=mysql_fetch_array($res))
{
echo "<br>Now adding: <font color=green>".$dat['username']."</font> into tracker users list";

         $rz = mysql_query("INSERT INTO users (username, password,  email, status, added) VALUES
         ('" . $dat['username'] . "',
         '" . $dat['password'] . "',
        '" . $dat['email'] . "',
          'confirmed' ,'" . get_date_time() . "' )
          ");
        $userid2 = mysql_insert_id();
echo "with id : <font color=green>".$userid2."</font> .";
 if (!$rz) {
      echo "<br><font color=red>An error occured :</font> ";
      if (mysql_errno() == 1062)
        echo "Username already exists!";
    }

}
}
else echo "<li>Cannot retrieve Vbulletin users list !</li>";
}
else echo "<li>Connection to SQL database failed</li>";

?>

What this script does is adds users from the USER table and puts them in a table called USERS. It's for a Bit Torrent tracker page.

The problem is it pulls the users in numerical order and adds them.
Example:

Table USER
INSERT INTO `user` VALUES (1,6,'',0,'Admin',
INSERT INTO `user` VALUES (2,2,'',0,'smssf',
INSERT INTO `user` VALUES (3,2,'',0,'tcort','
INSERT INTO `user` VALUES (4,2,'',0,'AtEaseWeb.com Kids Suck!',
INSERT INTO `user` VALUES (5,2,'',0,'thebigguy','
INSERT INTO `user` VALUES (1668,3,'',0,'nemo45',
INSERT INTO `user` VALUES (7,2,'',0,'luvdmb36',
INSERT INTO `user` VALUES (8,2,'',0,'Cole','
INSERT INTO `user` VALUES (9,2,'',0,'roach',

notice the user nemo45 with USERID of 1668

once the script is run to add the users, here's what I get:


Table USERS
INSERT INTO `users` VALUES (1,'Admin',
INSERT INTO `users` VALUES (2,'smssf',
INSERT INTO `users` VALUES (3,'tcort',
INSERT INTO `users` VALUES (4,'AtEaseWeb.com Kids Suck!',
INSERT INTO `users` VALUES (5,'thebigguy',
INSERT INTO `users` VALUES (6,'nemo45',
INSERT INTO `users` VALUES (7,'luvdmb36',
INSERT INTO `users` VALUES (8,'Cole',
INSERT INTO `users` VALUES (9,'roach',

Now notice nemo45

Since Nemo45 is the 6th user added, it gave it USERID 6 instead of USERID 1668.

This is a bug that will show wrong users on my Vbulletin website when they post music files. Can someone please edit this script so that it pulls the correct USERID in table USER and puts it in table USERS?