sql_query("SELECT * FROM ". $prefix ."_users");
while ($row = $db->sql_fetchrow($read))
{
$query = "INSERT INTO vwar_member (name,realname,country,email,homepage,icq,aim,yim,msn,password,status,language) VALUES('$row[username]','$row[name]','$row[user_from]','$row[user_email]','$row[user_website]','$row[user_icq]','$row[user_aim]','$row[user_yim]','$row[user_msmm]','c21f969b5f03d33d43e04f8f136e7682',$memberstatus,'$row[user_lang]')";
$write1 = $db->sql_query($query) or die(mysql_error());
$lastinsert = mysql_insert_id();
$write2 = $db->sql_query("INSERT INTO vwar_memberprofilefield (memberprofilefieldid,memberid,profilefieldid,fieldvalue) VALUES ('','$lastinsert',2,'')");
$write3 = $db->sql_query("INSERT INTO vwar_memberprofilefield (memberprofilefieldid,memberid,profilefieldid,fieldvalue) VALUES ('','$lastinsert',1,'')");
$write4 = $db->sql_query("INSERT INTO vwar_memberprofilefield (memberprofilefieldid,memberid,profilefieldid,fieldvalue) VALUES ('','$lastinsert',3,'')");
$write5 = $db->sql_query("INSERT INTO vwar_memberprofilefield (memberprofilefieldid,memberid,profilefieldid,fieldvalue) VALUES ('','$lastinsert',4,'')");
echo "Read/Write User -> " . $row[username] . "
\n";
}
?>