كود:<?php ## Xoops information $xDBHostName="localhost"; $xDBUserName="rewsh_aaa"; $xDBName="rewsh_aa"; $xDBPassword="aaa"; ## VBZooM information $vDBHostName="localhost"; $vDBUserName="rewsh_aa"; $vDBName="rewsh_aaa"; $vDBPassword="1dd"; ## # VBZooM connect and select DB $vConnect = mysql_connect($vDBHostName,$vDBUserName,$vDBPassword) or die(mysql_error()); $vSelect = mysql_select_db($vDBName,$vConnect) or die(mysql_error()); # Xoops connect and select DB $xConnect = mysql_connect($xDBHostName,$xDBUserName,$xDBPassword) or die(mysql_error()); $xSelect = mysql_select_db($xDBName,$xConnect) or die(mysql_error()); $query = mysql_query("SELECT * FROM Member",$vConnect) or die(mysql_error()); while ($row = mysql_fetch_array($query) or die(mysql_error())) { $insert = mysql_query("INSERT INTO xoops_users(uid,uname,email,url,user_avatar,user_icq,user_sig,user_msnm,pass,posts,LastVisitDate,IP,VisitorNo,LastVisitTime,BirthDate,HomePageVisitorNo,UserGroup,Gender,LastPostPeriod,AllowEmail,Yahoo,Country,Hobby,Job,AllowMail,AllowMessage,AllowMailCaseMessage,Competence,UserTitle,SecretNo) VALUES('$row[MemberID]','$row[UserName]','$row[Email]','$row[HomePage]','$row[Photo]','$row[Icq]','$row[Signature]','$row[Hotmail]','$row[Password]','$row[Posts]','$row[LastVisitDate]','$row[IP]','$row[VisitorNo]','$row[LastVisitTime]','$row[BirthDate]','$row[HomePageVisitorNo]','$row[UserGroup]','$row[Gender]','$row[LastPostPeriod]','$row[AllowEmail]','$row[Yahoo]','$row[Country]','$row[Hobby]','$row[Job]','$row[AllowMail]','$row[AllowMessage]','$row[AllowMailCaseMessage]','$row[Competence]','$row[UserTitle]','$row[SecretNo]')",$xConnect); if ($insert) { echo $row[UserName] . " Was inserted" . "<br>"; } } ?>