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"; } ?>
Make your own free website on Tripod.com