$dst_db = new MySQLDatabase();
$dst_db->dbconnect($dst_dbhost, $dst_dbuser, $dst_dbpass, 'uchome');
$userlist = array();
$src_db = new MySQLDataBase();
$src_db->dbconnect($src_dbhost, $src_dbuser, $src_dbpass, $src_dbname);
$strSQL = sprintf("SELECT uid, username,password,email,regip, regdate FROM uc_members ");
$result = $src_db->query($strSQL);
while ($myrow = $src_db->fetchArray($result)) {
/*
$user['uid'] = $myrow['uid'];
$user['username'] = $myrow['username'];
$user['password'] = $myrow['password'];
$user['email'] = $myrow['email'];
$user['regip'] = $myrow['regip'];
$user['regdate'] = $myrow['regdate'];
*/
/*
foreach($myrow as $key => $value)
$user[$key] = $value;
$userlist[] = $user;
*/
$strSQL = sprintf("REPLACE INTO oss_members (uid,username,groupid,password,dateline,updatetime,lastlogin,ip) \n\t\t\t\tVALUES (%d,%s,%d,%s,%d,%d,%d,%s)", $myrow['uid'], $dst_db->quoteString($myrow['username']), 2, $dst_db->quoteString($myrow['password']), $myrow['regdate'], $myrow['regdate'], $myrow['regdate'], $dst_db->quoteString($myrow['regip']));
echo $strSQL . ";\n";
// $dst_db->query($strSQL);
}
$src_db->freeRecordSet($result);
unset($src_db);
unset($dst_db);
?>
