?>
<table width="97%" border="0" align="left" height="212">
<tr>
<td height="21" align="center">
<?php
// Checking form-data
if(!$username)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Pseudo incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
if(!$email)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>E-mail incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$name1)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Prйnom incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$name2)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Nom incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$address)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Adresse incorrecte! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$city)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Ville incorrecte! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$state)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Dйpartement incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$zip)
{
echo"<b><font size=4 color= red>ERROR!</font></b><P>Erreur!</font></b><P>Code postal incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$country)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Pays incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$password)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Mot de passe incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if($password != $confirmpassword)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Mot de passe de confirmation incorrect! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
else if(!$agree)
{
echo"<b><font size=4 color= red>Erreur!</font></b><P>Vous devez accepter le rиglement de $ptrname ! Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;}
$sql=mysql_query("SELECT * FROM users WHERE username='$username'");
if(mysql_num_rows($sql))
{
echo"<font color=red size=3><b>Erreur!</b><br></font><b>Ce nom d'utilisateur existe dйjа!</b><br>Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;
}
$sql=mysql_query("SELECT * FROM users WHERE femail='$email'");
if(mysql_num_rows($sql))
{
echo"<font color=red size=3><b>Erreur!</b><br></font><b>Cette adresse e-mail est dйjа utilisйe!</b><br>Cliquez sur le bouton 'Prйcйdent' et rйessayez...";
exit;
}
if($refer=='no_referrer'){$refer='no_referrer'; $refer2='no_referrer'; $refer3='no_referrer'; $refer4='no_referrer'; $refer5='no_referrer'; $refer6='no_referrer'; $refer7='no_referrer'; $refer8='no_referrer'; $refer9='no_referrer'; $refer10='no_referrer'; }
if($refer!='no_referrer')
{
extract(mysql_fetch_array(mysql_query("SELECT refcount FROM users WHERE fid=$refer")));
$refcount=$refcount+1;
mysql_query("UPDATE users SET refcount=$refcount WHERE fid=$refer");
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer2=$frefer;
}
else $refer2="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer2'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer3=$frefer;
}
else $refer3="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer3'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer4=$frefer;
}
else $refer4="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer4'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer5=$frefer;
}
else $refer5="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer5'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer6=$frefer;
}
else $refer6="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer6'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer7=$frefer;
}
else $refer7="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer7'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer8=$frefer;
}
else $refer8="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer8'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer9=$frefer;
}
else $refer9="no_referrer";
$sq=mysql_query("SELECT * FROM users WHERE fid='$refer9'");
if(mysql_num_rows($sq))
{
$arr=mysql_fetch_array($sq); extract($arr);
$refer10=$frefer;
}
else $refer10="no_referrer";
}
$userip=$REMOTE_ADDR;
$query = "SELECT * FROM users WHERE userip='$userip'";
$eredm = mysql_query($query) or die("error by plugin");
if (mysql_num_rows($eredm)>0){
echo"<b><font size=4 color= red>Erreur!</font></b><P>Votre adresse IP indique que vous кtes dйjа inscrit sur le site!";
exit;
}
if($refer=='no_referrer')
{
$sql=mysql_query("SELECT fid AS refid FROM users WHERE gold='yes'");
$i=@rand(0, (mysql_num_rows($sql)-1));
@mysql_data_seek($sql, $i); @$arr=mysql_fetch_array($sql); @extract($arr);
$refer=$refid;
}
if(!$lang1)$lang1=0; if(!$lang2)$lang2=0; if(!$lang3)$lang3=0; if(!$lang4)$lang4=0; if(!$lang5)$lang5=0; if(!$lang6)$lang6=0; if(!$lang7)$lang7=0; if(!$lang8)$lang8=0; if(!$lang9)$lang9=0; if(!$lang10)$lang10=0;
if(!$incoming)$incoming=0;
srand((double)microtime()*1000000);
$r=rand();
$sql=mysql_query("INSERT INTO users (username, fgender, fage, fincoming, lang1, lang2, lang3, lang4, lang5, lang6, lang7, lang8, lang9, lang10, femail, fname1, fname2, faddress, fcity, fstate, fzip, fcountry, frefer, frefer2, frefer3, frefer4, frefer5, frefer6, frefer7, frefer8, frefer9, frefer10, fintarts, fintauto, fintbusiness, fintcomputers, finteducation, fintentertainment, fintfinancial, fintgames, finthealth, finthome, fintinternet, fintintnews, fintmedia, fintrecreation, fintreference, fintsearch, finttechnology, fintsocial, fintsports, finttravel, fpaymethod, fpayacc, fpassword, userip, regdate, refcount,accstatus,confid) VALUES ('$username', '$gender', $age, $incoming, $lang1, $lang2, $lang3, $lang4, $lang5, $lang6, $lang7, $lang8, $lang9, $lang10, '$email', '$name1', '$name2', '$address', '$city', '$state', '$zip', '$country', '$refer', '$refer2', '$refer3', '$refer4', '$refer5', '$refer6', '$refer7', '$refer8', '$refer9', '$refer10', '$int1', '$int2', '$int3', '$int4', '$int5', '$int6', '$int7', '$int8', '$int9', '$int10', '$int11', '$int12', '$int13', '$int14', '$int15', '$int16', '$int17', '$int18', '$int19', '$int20', '$paymethod', '$payacc', '$password', '$userip', now(), 0, 'waiting','$r')") or die (mysql_error());
$sq=mysql_query("SELECT * FROM users WHERE femail='$email'") or die(mysql_error());
$arr=mysql_fetch_array($sq); extract($arr);
if(mysql_affected_rows) echo "<center><P><P><P><b>Merci de vous кtre inscrit!</b><br>Votre Pseudo est <b>$username</b><br>Votre ID# de membre est <b>$fid</b><br>Votre Mot de Passe est <b>$fpassword</b><b><p><font color=darkred>Vous devez confirmer votre e-mail avant de vous connecter.<br>Lisez l'e-mail envoyй pour confirmer.<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br></b></font></p></center>";
$fr="From: $adminemail";
$con="Merci de vous кtre inscrit sur $ptrname! \n Votre ID de membre est : $fid \n Votre Pseudo est: $username \n Votre Mot de Passe est: $fpassword \n Vous devez confirmer votre inscription avant de vous connecter sur le site. \n Lien de Confirmation: $ptrurl/confirm.php?uid=$fid&r=$r \n Utilisez ce lien pour vous connecter а votre compte: \n $ptrurl?tp=member";
$tem="Confirmation d'Inscription а $ptrname";
@mail($email, $tem, $con, $fr);
?>
</td>
</tr>
</table>
Това ми е register.php,но като се опитам да се регна ми се появява това:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\Programs_\1XAMPP1\xampp\htdocs\ptc\register.php on line 86
Warning: extract() [function.extract]: First argument should be an array in D:\Programs_\1XAMPP1\xampp\htdocs\ptc\register.php on line 86
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'milan1@abv.bg', 'Milan', 'Milanov', 'Gospodim' at line 1
Сайта не е мой,някакъв френски..Аз ниши не разбирам от php,та ако може някой да ми помогне... Червеният цвят дава грешка...
