最近一段时间在校也闲得没事干,反正是好长一段时间,干脆就做一个《中国象棋》网游耍耍打发时间。弄了好久没有写总结,以及整个过程中遇到的问题,今天就赶紧写一哈,难免后面就会忘了。
一、注册登录界面:
可能会说这么简单的游戏,网上可能例子很多,也没有必要弄注册这样的功能,其实我只是学着玩玩哈。
关于注册我使用的是php与as3.0交互做的,有与php学的非常浅,也遇到了不少问题:
1.检测是否注册成功:这个也困了时间不是很长,但是觉得比较重要,我搜了一些资料找到的:
mysql_affected_rows()// 函数返回前一次 MySQL 操作所影响的记录行数。执行成功,则返回受影响的行的数目,如果最近一次查询失败的话,函数返回 -1。
2.邮箱激活验证:
<?phpclass smtp{/* Public Variables */var $smtp_port;var $time_out;var $host_name;var $log_file;var $relay_host;var $debug;var $auth;var $user;var $pass;/* Private Variables */ var $sock;/* Constractor */function smtp($relay_host = "", $smtp_port = 25,$auth = false,$user,$pass){$this->debug = FALSE;$this->smtp_port = $smtp_port;$this->relay_host = $relay_host;$this->time_out = 30; //is used in fsockopen() #$this->auth = $auth;//auth$this->user = $user;$this->pass = $pass;#$this->host_name = "localhost"; //is used in HELO command $this->log_file = "";$this->sock = FALSE;}/* Main Function */function sendmail($to, $from, $subject = "", $body = "", $mailtype, $cc = "", $bcc = "", $additional_headers = ""){$mail_from = $this->get_address($this->strip_comment($from));$body = ereg_replace("(^|(rn))(.)", "1.3", $body);$header = "MIME-Version:1.0rn";if($mailtype=="HTML"){$header .= "Content-Type:text/htmlrn";}$header .= "To: ".$to."rn";if ($cc != "") {$header .= "Cc: ".$cc."rn";}$header .= "From: $from<".$from.">rn";$header .= "Subject: ".$subject."rn";$header .= $additional_headers;$header .= "Date: ".date("r")."rn";$header .= "X-Mailer:By Redhat (PHP/".phpversion().")rn";list($msec, $sec) = explode(" ", microtime());$header .= "Message-ID: <".date("YmdHis", $sec).".".($msec*1000000).".".$mail_from.">rn";$TO = explode(",", $this->strip_comment($to));if ($cc != "") {$TO = array_merge($TO, explode(",", $this->strip_comment($cc)));}if ($bcc != "") {$TO = array_merge($TO, explode(",", $this->strip_comment($bcc)));}$sent = TRUE;foreach ($TO as $rcpt_to) {$rcpt_to = $this->get_address($rcpt_to);if (!$this->smtp_sockopen($rcpt_to)) {$this->log_write("Error: Cannot send email to ".$rcpt_to."n");$sent = FALSE;continue;}if ($this->smtp_send($this->host_name, $mail_from, $rcpt_to, $header, $body)) {$this->log_write("E-mail has been sent to <".$rcpt_to.">n");} else {$this->log_write("Error: Cannot send email to <".$rcpt_to.">n");$sent = FALSE;}fclose($this->sock);$this->log_write("Disconnected from remote hostn");}return $sent;}/* Private Functions */function smtp_send($helo, $from, $to, $header, $body = ""){if (!$this->smtp_putcmd("HELO", $helo)) {return $this->smtp_error("sending HELO command");}#authif($this->auth){if (!$this->smtp_putcmd("AUTH LOGIN", base64_encode($this->user))) {return $this->smtp_error("sending HELO command");}if (!$this->smtp_putcmd("", base64_encode($this->pass))) {return $this->smtp_error("sending HELO command");}}#if (!$this->smtp_putcmd("MAIL", "FROM:<".$from.">")) {return $this->smtp_error("sending MAIL FROM command");}if (!$this->smtp_putcmd("RCPT", "TO:<".$to.">")) {return $this->smtp_error("sending RCPT TO command");}if (!$this->smtp_putcmd("DATA")) {return $this->smtp_error("sending DATA command");}if (!$this->smtp_message($header, $body)) {return $this->smtp_error("sending message");}if (!$this->smtp_eom()) {return $this->smtp_error("sending <CR><LF>.<CR><LF> [EOM]");}if (!$this->smtp_putcmd("QUIT")) {return $this->smtp_error("sending QUIT command");}return TRUE;}function smtp_sockopen($address){if ($this->relay_host == "") {return $this->smtp_sockopen_mx($address);} else {return $this->smtp_sockopen_relay();}}function smtp_sockopen_relay(){$this->log_write("Trying to ".$this->relay_host.":".$this->smtp_port."n");$this->sock = @fsockopen($this->relay_host, $this->smtp_port, $errno, $errstr, $this->time_out);if (!($this->sock && $this->smtp_ok())) {$this->log_write("Error: Cannot connenct to relay host ".$this->relay_host."n");$this->log_write("Error: ".$errstr." (".$errno.")n");return FALSE;}$this->log_write("Connected to relay host ".$this->relay_host."n");return TRUE;;}function smtp_sockopen_mx($address){$domain = ereg_replace("^.+@([^@]+)$", "1", $address);if (!@getmxrr($domain, $MXHOSTS)) {$this->log_write("Error: Cannot resolve MX "".$domain.""n");return FALSE;}foreach ($MXHOSTS as $host) {$this->log_write("Trying to ".$host.":".$this->smtp_port."n");$this->sock = @fsockopen($host, $this->smtp_port, $errno, $errstr, $this->time_out);if (!($this->sock && $this->smtp_ok())) {$this->log_write("Warning: Cannot connect to mx host ".$host."n");$this->log_write("Error: ".$errstr." (".$errno.")n");continue;}$this->log_write("Connected to mx host ".$host."n");return TRUE;}$this->log_write("Error: Cannot connect to any mx hosts (".implode(", ", $MXHOSTS).")n");return FALSE;}function smtp_message($header, $body){fputs($this->sock, $header."rn".$body);$this->smtp_debug("> ".str_replace("rn", "n"."> ", $header."n> ".$body."n> "));return TRUE;}function smtp_eom(){fputs($this->sock, "rn.rn");$this->smtp_debug(". [EOM]n");return $this->smtp_ok();}function smtp_ok(){$response = str_replace("rn", "", fgets($this->sock, 512));$this->smtp_debug($response."n");if (!ereg("^[23]", $response)) {fputs($this->sock, "QUITrn");fgets($this->sock, 512);$this->log_write("Error: Remote host returned "".$response.""n");return FALSE;}return TRUE;}function smtp_putcmd($cmd, $arg = ""){if ($arg != "") {if($cmd=="") $cmd = $arg;else $cmd = $cmd." ".$arg;}fputs($this->sock, $cmd."rn");$this->smtp_debug("> ".$cmd."n");return $this->smtp_ok();}function smtp_error($string){$this->log_write("Error: Error occurred while ".$string.".n");return FALSE;}function log_write($message){$this->smtp_debug($message);if ($this->log_file == "") {return TRUE;}$message = date("M d H:i:s ").get_current_user()."[".getmypid()."]: ".$message;if (!@file_exists($this->log_file) || !($fp = @fopen($this->log_file, "a"))) {$this->smtp_debug("Warning: Cannot open log file "".$this->log_file.""n");return FALSE;;}flock($fp, LOCK_EX);fputs($fp, $message);fclose($fp);return TRUE;}function strip_comment($address){$comment = "([^()]*)";while (ereg($comment, $address)) {$address = ereg_replace($comment, "", $address);}return $address;}function get_address($address){$address = ereg_replace("([ trn])+", "", $address);$address = ereg_replace("^.*<(.+)>.*$", "1", $address);return $address;}function smtp_debug($message){if ($this->debug) {echo $message;}}}?>
这个需要配置SMTP服务,现在QQ邮箱网易邮箱等都可以去设置,然后作为代理邮箱。
$smtp = new smtp($smtpserver,$smtpserverport,true,$smtpuser,$smtppass);
$smtp->debug = false;//关闭调试
$state = $smtp->sendmail($smtpemailto, $smtpusermail, $mailtitle, $mailcontent, $mailtype);
在整个数据库操作过程中使用一个变量来监控是否出现操作错误,来返回是否注册成功;
error_reporting(E_ERROR | E_WARNING | E_PARSE);//屏蔽所有错误警告等
激活页面:
<?php header("Content-Type:text/html;charset=utf-8"); require_once "sendEmail/mysqlInfo/sqlInfo.php"; $name=base64_decode($_GET['isdhf']); if($name=="") { exit(); }else{ $con=@mysql_connect(DB_USER,DB_ROOT,DB_PWD)or die('连接错误'); //选择数据库 mysql_select_db(DB_NAME,$con)or die('Occured error'); mysql_query('SET NAMES UTF8') or die('显示错误'); $sql="SELECT isActivated FROM chinesechess WHERE nickname='{$name}'"; //$row=@mysql_query($query) or die('error'); $result=mysql_query($sql,$con)or die('error'); //关闭数据库 $arr=mysql_fetch_array($result); if($arr['isActivated']=='0') { //如果没有激活,就输出激活页面,否则网页不存在;echo '<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><link rel="stylesheet" href="css/index_CSS.css" /><style type="text/css">body,td,th { font-size: xx-large; font-family: "Lucida Sans Unicode", "Lucida Grande", sans-serif;}</style><title>游戏注册[欢迎注册]</title> <script type="text/javascript"> function havedActivate() { var name=document.getElementById("nickname").title; window.location.href="activated.php?key="+name; } </script></head><body> <div id="tDiv"> <table> <td></td> </table> <h2>账户激活</h2> <p> </p> <table width="100%" border="0"> <tr> <td id="tDL"><p>您的随机昵称为:<label id="nickname" title="".$name.'">"'.$name.'"</label></p> <p> </p></td> </tr> <tr> <td align="center" id="tDL"> <p> <input type="submit" value="确认激活" id="activateBtn" onClick="havedActivate();"/> </p> </td> </tr> </table> <p> </p> </div></body></html>'; }else { echo "该网页不存在"; } mysql_close(); }?>
<?php header("Content-Type:text/html;charset=utf-8"); require_once "sendEmail/mysqlInfo/sqlInfo.php"; error_reporting(E_ERROR | E_WARNING | E_PARSE);//禁止显示错误警号等 $name=$_GET['key']; if($name=="") { exit(); }else { $con=@mysql_connect(DB_USER,DB_ROOT,DB_PWD)or die('连接错误'); //选择数据库 mysql_select_db(DB_NAME,$con)or die('Occured error'); mysql_query('SET NAMES UTF8') or die('显示错误'); $sql="UPDATE chinesechess SET isActivated='1' WHERE nickname='{$name}'"; $result = mysql_query($sql,$con) or die('error'); //关闭数据库 mysql_close(); echo'<html> <head> <meta charset="utf-8" /> <title>账号已激活</title> <link rel="stylesheet" href="css/index_CSS.css" />'; $name=" <script type='text/javascript'> document.write(getName()); function getName(){ var str=window.location.search; var args=str.split('?'); var retval=''; if(args[0]==str){return '';}//参数为空; return args[1].split('=')[1]; } </script>"; echo '</head> <body> <div id="tDiv"> <table> <td></td> </table> <h2>账户已激活</h2> <p> </p> <table width="100%" border="0"> <tr> <td id="tDL"><p>您的随机昵称为:<label>'.$name.'</label></p> <p> </p></td> </tr> <tr> <td align="center" id="tDL"> <p> <p><font color="#FF0000">您的账号已激活,祝您游戏愉快!</font></p> </p> </td> </tr> </table> <p> </p> </div> </body></html>'; }?>
CSS:
@charset "utf-8";/* CSS Document */h2{ font-size:56px; font-weight:bold; text-align:center;}body{ width:auto; height:auto; background-image:url(../images/03.png); background-repeat:no-repeat; background-size:100% 100%; background-attachment:fixed; background-position:center;}#tDiv{ background-image:url(../images/o1.png); background-repeat:repeat; margin-left:auto; margin-right:auto; margin-top:200px; width:550px; height:auto; font-size:10px; border:2px solid #CCC;}#tDL{ font-size:24px; text-align:center;}
登录:
<?php header("Content-Type:text/html;charset=utf-8"); require_once "sendEmail/mysqlInfo/sqlInfo.php"; error_reporting(E_ERROR | E_WARNING | E_PARSE);//禁止显示错误警号等 $sign=''; $_email=$_POST['_email']; $_paswd=$_POST['_pasd'];// $_email="2810718058@qq.com";// $_paswd="1234567890"; $_activate='1'; //激活变量 //连接数据库 $con=@mysql_connect(DB_USER,DB_ROOT,DB_PWD)or die('连接错误'); mysql_select_db(DB_NAME,$con)or die('Occured error'); mysql_query('SET NAMES UTF8') or die('显示错误'); $sql="SELECT * FROM chinesechess WHERE user_email='{$_email}'and password='{$_paswd}' and isActivated='{$_activate}'"; $result = mysql_query($sql,$con); $source=mysql_fetch_array($result); if($source) { $sign="succeed"; $name=$source['nickname']; $pasd=$source['password']; $mail=$source['user_email']; echo 'strings=name='.$name.'<br/>'; echo 'pasd='.$pasd.'<br/>'; echo 'mail='.$mail.'<br/>'; echo 'sign='.$sign.'<br/>'; }else { $sign="faild"; $name="null"; $pasd="000000"; $mail="null@cn.com"; echo 'strings=name='.$name.'<br/>'; echo 'pasd='.$pasd.'<br/>'; echo 'mail='.$mail.'<br/>'; echo 'sign='.$sign.'<br/>'; } mysql_close();?>
Resource id #num
由于本人是一枚初学者,对mysql查询返回值等理解不够,遇到了一点困惑,mysql_query() 仅对 SELECT,SHOW,EXPLAIN 或 DESCRIBE 语句返回一个资源标识符,如果查询执行不正确则返回 FALSE。要使用mysql_fatch_array()函数或者mysql_fetch_object()函数进行转换,然后对相应数组或者对象进行操作。
总的来说这部分遇到的困难也不是很多,经过自己的努力很快就解决了。