ciao Mauri grazie della risposta, allora quello l ho gia inserito
Codice PHP:
$result = mysql_query( $query ) or die ("didn't query");
ti inserisco il file php che riguarda il login utente cosi se riesci puoi vedere meglio
grazie mille intanto
Codice PHP:
<? include ("../database_config.php");
$user=$_POST['user'];
$pass=$_POST['pass'];
$mode = $_GET['mode'];
if ($user && $pass){
mysql_pconnect($mysql_server,$mysql_user,$mysql_pass) or die ("didn't connect to mysql");
mysql_select_db($mysql_db) or die ("no database");
$query = "SELECT * FROM fadmin_login WHERE username = '$user' AND password = '$pass'";
$query2 = "SELECT * FROM fadmin_login WHERE userapr = 'pending'";
$result = mysql_query( $query ) or die ("didn't query");
$result2 = mysql_query( $query2 ) or die ("didn't query");
$num = mysql_num_rows( $result );
$numofpending = mysql_num_rows( $result2 );
$row = mysql_fetch_array ($result);
if ($num == 1){
print "&checklog=1¤tuser=".$row['realname']."&userstatus=".$row['userstate']."¤tusername=".$row['username']."&fadminpath=".$sitepath."&userapr=".$row['userapr']."&numofpending=".$numofpending."";
} else {
print "status=Sorry,rong username and password!&checklog=2";
}; };
if($mode =='reguser'){ $usermail = $_GET['usermail'];
$username = $_GET['username']; mysql_pconnect($mysql_server,$mysql_user,$mysql_pass) or die ("didn't connect to mysql");
mysql_select_db($mysql_db) or die ("no database");
$query = "SELECT * FROM fadmin_login WHERE username = '$username' OR usermail = '$usermail' OR usermail = '$sitemail'";
$result = mysql_query( $query ) or die ("didn't query");
$num = mysql_num_rows( $result );
$row = mysql_fetch_array ($result);
if ($num >= 1){
if($username == $row['username']){
print "status=Username already exists";
}else{
print "status=E-mail already exists";
}; }else{
$realname = $_GET['realname']; $usermail = $_GET['usermail']; $username = $_GET['username']; $userstatus = $_GET['userstatus']; $userpass = $_GET['userpass']; $verification = $_GET['verification']; mysql_query("INSERT INTO fadmin_login SET username = '$username', realname = '$realname', usermail = '$usermail', userstate = '$userstatus', password = '$userpass', verification = '$verification', userapr = 'pending'");
print "status=Welcome";
$subject = '['.$sitename.'] Welcome to '.$sitename;
$to = $usermail;
$messageToBeSend = '<html><head></head><body>Congratulations '.$realname.' on creating your new '.$sitename.' account
Please keep this email for your records, as it contains an
important verification code that you may need should you ever encounter problems or forget your password.
You can login to your account <a href="'.$sitepath.'">HERE<a/>
Username: '.$username.'
Password: '.$userpass.'
Verification code: '.$verification.'
The '.$sitename.' Team
</body></html>';
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
$headers .= "From: ".$sitemail. "\r\n".'Reply-To: '.$sitemail."\r\n".'X-Mailer: PHP/'.phpversion();
$status = mail($to, $subject, $messageToBeSend, $headers);
}; }; if($mode =='forgotpass'){ $usermail = $_GET['usermail'];
$verification = $_GET['verification']; mysql_pconnect($mysql_server,$mysql_user,$mysql_pass) or die ("didn't connect to mysql");
mysql_select_db($mysql_db) or die ("no database");
$query = "SELECT * FROM fadmin_login WHERE verification = '$verification' AND usermail = '$usermail'";
$result = mysql_query( $query ) or die ("didn't query");
$num = mysql_num_rows( $result );
$row = mysql_fetch_array ($result);
if ($num == 1){
$subject = '['.$sitename.'] - password retrieve';
$to = $usermail;
$messageToBeSend = '<html><head></head><body>Someone, hopefully you are requested password retrieve<br/ >
Your password is: '.$row['password'].'
The '.$sitename.' Team
</body></html>';
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
$headers .= "From: ".$sitemail. "\r\n".'Reply-To: '.$sitemail."\r\n".'X-Mailer: PHP/'.phpversion();
$status = mail($to, $subject, $messageToBeSend, $headers);
print "status=Done";
}else{
print "status=Sorry no match";
}; }; ?>