ممكن حد يقولي فين الخطا

[زائرalnnarry]

<?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>";
     }
    }


?>

[زائرalnnarry]

مستني ردكم

[المهمة9]

طيب اخوي ممكن تكتب لنا شو الخطا اللى يطلع لك لو امكن

[dr_bltman]

طيب اخوي ممكن تكتب لنا شو الخطا اللى يطلع لك لو امكن

يبقى افصل

[زائرalnnarry]

بيتظهر صفحه فاضيه ولا يتم شئ
اكتبولي شرط بحيث لو عمل بنجاح يكتب
دا سكربت تحويل
يحول اعضاء vbzoom لxoops

[زائرalnnarry]

ارجوا الحل ياجماعه

[إنترنت بلس]

<?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());

   $i;
    $query = mysql_query("SELECT * FROM Member",$vConnect) or die(mysql_error());
    while ($row = mysql_fetch_array($query) or die(mysql_error())) {
   $i++;
   echo "<br>" . $i . ": ";
   $insert1 = "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]')";
echo $insert1;
$insert = mysql_query($insert1,$xConnect);
     if ($insert) {
      echo $row[UserName] . " Was inserted" . "<br>";
     }
    }


?>

جرب عشان نشوف الخطأ فين ..

[زائرalnnarry]

1612: 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('1625',' elzahraa','elzahraa_2004@yahoo.com','http://','black/v1.gif','','','','b0baee9d279d34fa1dfd71aadb908c3f','0','2005-04-01','196.205.41.161','1','23:47 PM','1978-07-04','0','0','f','','1','','مصر','','','1','1','1','0','','6191')
1613: 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('1626','محمد الفهد','m_egyptionstar2010@yahoo.com','http://yahoo','image/v8.gif','لايوجد','','لايوجد','b8f52269d33ef2863546cf1ea8abede9','0','2005-04-02','82.129.161.26','1','0:06 AM','1992-08-08','0','0','m','','1','m_egyptionstar2010@yahoo.com','مصر','المصارعة الحرة','طالب','1','1','1','0','','2090')Unknown column 'LastVisitDate' in 'field list'



والباقي زي كدا
عدد الأعضاء كلهم يعني

[زائرalnnarry]

وجربت ادخل بالأعضاء المجله مافيش ولا عضو دخل كأنه لم يضفهم

[زائرalnnarry]

منتظر ردود حضراتكم

[زائرalnnarry]

حضوركم مهم نفسي اعرف

[إنترنت بلس]

المشكلة انه مش مديك اي رسالة خطأ .. يعني بينفذ صح ..
طيب .. اتعب شوية معانا وجرب:
في سطر الانسرت: كل ما تلاقي:

'$rs[xxxxxxxxxx]' 

غيرها للتالي:

' . $rs['xxxxxxxxx'] . ' 

وشوف النتيجة ..

[زائرalnnarry]

بس استبدلها منين انت بتكلم مبتدأ
وازاي استبدلها

[إنترنت بلس]

$insert1 = "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'] . "')"; 

[زائرalnnarry]

30: 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('25', 'spider_manx2', 'hare_botter@hotmail.com', 'www.art.com', 'http://staracademylbc.jeeran.com/9999.jpg', '?', '', 'hare_botter@hotmail.com', '8db5deca09c0d6a4a37608f32de3212f', '180', '2004-09-28', '62.139.91.145', '38', '23:56 PM', '1985-07-03', '1', '0', 'm', '1095666456', '0', '?', 'البرازيل', 'النت والاغانى والهدووووووووء', 'طالب كليه اداب', '1', '1', '1', '|', '', '6078')


نفس الكلام مافيش حاجه حصلت مش عارف ليه