電音大帝國 Alpha填入 E-mail ，驗證後取得更多功能（例如：我的最愛...）
E-mail: 請至您的信箱點擊開通連結
登入
信箱:
密碼:
query("SET NAMES 'utf8'");
$q1 = "SELECT passwd FROM user WHERE mail_address='$mail_address'";
$r1 = $conn->query($q1);
if ( $r1 === FALSE ){
echo "Connect Failed with: $conn->error
n";
$conn->close();
exit;
}
else{
$row_data = $r1->fetch_assoc();
}
var_dump($row_data['passwd']);
var_dump($passwd_encrypt);
if ( $row_data['passwd'] == $passwd_encrypt ){
$_SESSION['mail_address'] = $mail_address;
echo $_SESSION['mail_address'];
header('Location: main.php');
}
else{
echo "密碼錯誤";
}
?>
電音大帝國 Alpha成功登入
登出
query("SET NAMES 'utf8'");
$q1 = "UPDATE user SET check_email='1', passwd='$passwd_encrypt' WHERE mail_address='$mail_address'";
$r1 = $conn->query($q1);
if ( $r1 === FALSE ){
echo "Connect Failed with: $conn->error
n";
$conn->close();
exit;
}
else{
$_SESSION['mail_address'] = $_POST['mail_address'];
header('Location: main.php');
}
?>
電音大帝國 Alpha
query("SET NAMES 'utf8'");
$q1 = "SELECT mail_address,passwd FROM user WHERE mail_address = '$mail_address'";
$r1 = $conn->query($q1);
if ( $r1 === FALSE ){
echo "Connect Failed with: $conn->error
n";
$conn->close();
exit;
}
$row_data = $r1->fetch_assoc();
echo "目前密碼為".$row_data['passwd'];
echo "
";
if ( $row_data['passwd'] == $sn ){
echo "您可以設定您自己的密碼，或者直接進入網站";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "
";
}
else{
//寫入 user 資料表的信箱不見得都是已經開通的，要有一個可以區別是否為已開通的帳號的方法
echo "認證錯誤。請重新註冊";
}
?>
query("SET NAMES 'utf8'");
//這邊未來還要再加入驗證 $mail_address 是否已經開通過
$q1 = "INSERT INTO user(mail_address, passwd) VALUES ('$mail_address', '$sn')";
$r1 = $conn->query($q1);
if ( $r1 === FALSE ){
echo "Connect Failed with: $conn->error
n";
$conn->close();
exit;
}
$subject = "電音大帝國帳號開通信件";
$body = "點擊下面開通連結，以取得更多功能！
Click the link to upgrade your account!
http://ccnsweb.twbbs.org/mp3/get_account.php?mail_address=$mail_address&sn=$sn";
$mail = new PHPMailer();
$mail->IsSMTP(); // set mailer to use SMTP
$mail->CharSet = "utf-8";
$mail->Encoding = "base64";
$mail->From = "xxx@gmail.com";
$mail->FromName ="電音大帝國";
$mail->Host ="ssl://smtp.gmail.com";
$mail->Port = 465; //default is 25, gmail is 465 or 587
$mail->SMTPAuth = true;
//ssl://smtp.gmail.com:465
//ssl://smtp.live.com:25 ssl://pop3.live.com:995
$mail->Username = "xxxx@gmail.com";
$mail->Password = "xxxx";
$mail->AddAddress($mail_address);
$mail->WordWrap = 50;
$mail->IsHTML(true);
$mail->Subject = $subject;
$mail->MsgHTML($body);
if(!$mail->Send())
{
echo "驗證信件寄出失敗";
echo "Mailer Error: " . $mail->ErrorInfo;
exit;
}
echo "驗證信件已寄出
請收信並點擊開通連結";
?>
還要有 cookie 才能做自動化登入
Better life with Ubuntu 
