Import existing members - KyleMassacre

<?php
include "globals.php";
$query=$db->query("SELECT `userid`, `username`, `userpass`, `email`, `signedup` FROM users WHERE userid > 1");
while ($r=$db->fetch_row($query))
{
$link = mysql_connect("localhost", "root", "");
mysql_select_db("smf", $link) or die(mysql_error());
mysql_query("INSERT INTO smf.`smf_members` (member_name,date_registered,real_name,email_address,passwd,userid) VALUES
('{$r['username']}','{$r['signedip']}','{$r['username']}','{$r['email']}', '{$r['userpass']}')") or die(mysql_error());
mysql_close($link);
}
print "Members inserted correctly";
?>