网游练习题总结(1)-php教程-PHP中文網

账户激活

账户已激活

首頁

後端開發

php教程

网游练习题总结(1)

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 pm 12:28 PM

gt lt return smtp this

网游练习总结(1)

最近一段时间在校也闲得没事干，反正是好长一段时间，干脆就做一个《中国象棋》网游耍耍打发时间。弄了好久没有写总结，以及整个过程中遇到的问题，今天就赶紧写一哈，难免后面就会忘了。

一、注册登录界面：

可能会说这么简单的游戏，网上可能例子很多，也没有必要弄注册这样的功能，其实我只是学着玩玩哈。

关于注册我使用的是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("(^|(\r\n))(\.)", "\1.\3", $body);$header = "MIME-Version:1.0\r\n";if($mailtype=="HTML"){$header .= "Content-Type:text/html\r\n";}$header .= "To: ".$to."\r\n";if ($cc != "") {$header .= "Cc: ".$cc."\r\n";}$header .= "From: $from<".$from.">\r\n";$header .= "Subject: ".$subject."\r\n";$header .= $additional_headers;$header .= "Date: ".date("r")."\r\n";$header .= "X-Mailer:By Redhat (PHP/".phpversion().")\r\n";list($msec, $sec) = explode(" ", microtime());$header .= "Message-ID: <".date("YmdHis", $sec).".".($msec*1000000).".".$mail_from.">\r\n";$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 host\n");}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 ([email&#160;protected]($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."\r\n".$body);$this->smtp_debug("> ".str_replace("\r\n", "\n"."> ", $header."\n> ".$body."\n> "));return TRUE;}function smtp_eom(){fputs($this->sock, "\r\n.\r\n");$this->smtp_debug(". [EOM]\n");return $this->smtp_ok();}function smtp_ok(){$response = str_replace("\r\n", "", fgets($this->sock, 512));$this->smtp_debug($response."\n");if (!ereg("^[23]", $response)) {fputs($this->sock, "QUIT\r\n");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."\r\n");$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 ([email&#160;protected]_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("([ \t\r\n])+", "", $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);<br />$smtp->debug = false;//关闭调试<br />$state = $smtp->sendmail($smtpemailto, $smtpusermail, $mailtitle, $mailcontent, $mailtype);<br />

登入後複製

在整个数据库操作过程中使用一个变量来监控是否出现操作错误，来返回是否注册成功；

error_reporting(E_ERROR | E_WARNING | E_PARSE);//屏蔽所有错误警告等

登入後複製

激活页面：

<?<span style="color: #000000;">php     </span><span style="color: #008080;">header</span>("Content-Type:text/html;charset=utf-8"<span style="color: #000000;">);      </span><span style="color: #0000ff;">require_once</span> "sendEmail/mysqlInfo/sqlInfo.php"<span style="color: #000000;">;     </span><span style="color: #800080;">$name</span>=<span style="color: #008080;">base64_decode</span>(<span style="color: #800080;">$_GET</span>['isdhf'<span style="color: #000000;">]);            </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$name</span>==""<span style="color: #000000;">)      {          </span><span style="color: #0000ff;">exit</span><span style="color: #000000;">();      }</span><span style="color: #0000ff;">else</span><span style="color: #000000;">{                     </span><span style="color: #800080;">$con</span>=@<span style="color: #008080;">mysql_connect</span>(DB_USER,DB_ROOT,DB_PWD)or <span style="color: #0000ff;">die</span>('连接错误'<span style="color: #000000;">);       </span><span style="color: #008000;">//</span><span style="color: #008000;">选择数据库</span>       <span style="color: #008080;">mysql_select_db</span>(DB_NAME,<span style="color: #800080;">$con</span>)or <span style="color: #0000ff;">die</span>('Occured error'<span style="color: #000000;">);       </span><span style="color: #008080;">mysql_query</span>('SET NAMES UTF8') or <span style="color: #0000ff;">die</span>('显示错误'<span style="color: #000000;">);               </span><span style="color: #800080;">$sql</span>="SELECT isActivated FROM chinesechess WHERE nickname='{<span style="color: #800080;">$name</span>}'"<span style="color: #000000;">;        </span><span style="color: #008000;">//</span><span style="color: #008000;">[email&#160;protected]_query($query) or die('error');</span>        <span style="color: #800080;">$result</span>=<span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$con</span>)or <span style="color: #0000ff;">die</span>('error'<span style="color: #000000;">);       </span><span style="color: #008000;">//</span><span style="color: #008000;">关闭数据库</span>        <span style="color: #800080;">$arr</span>=<span style="color: #008080;">mysql_fetch_array</span>(<span style="color: #800080;">$result</span><span style="color: #000000;">);        </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$arr</span>['isActivated']=='0'<span style="color: #000000;">)        {          </span><span style="color: #008000;">//</span><span style="color: #008000;">如果没有激活，就输出激活页面，否则网页不存在；</span><span style="color: #0000ff;">echo</span> '<span style="color: #000000;"><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 id="账户激活">账户激活</h2>   <p> </p>   <table width="100%" border="0">     <tr>       <td id="tDL"><p>您的随机昵称为：<label id="nickname" title="</span>'.<span style="color: #800080;">$name</span>.'">"'.<span style="color: #800080;">$name</span>.'<span style="color: #000000;">"</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></span>'<span style="color: #000000;">;            }</span><span style="color: #0000ff;">else</span><span style="color: #000000;">            {                </span><span style="color: #0000ff;">echo</span> "该网页不存在"<span style="color: #000000;">;            }    </span><span style="color: #008080;">mysql_close</span><span style="color: #000000;">();    }</span>?>

登入後複製

<?<span style="color: #000000;">php   </span><span style="color: #008080;">header</span>("Content-Type:text/html;charset=utf-8"<span style="color: #000000;">);        </span><span style="color: #0000ff;">require_once</span> "sendEmail/mysqlInfo/sqlInfo.php"<span style="color: #000000;">;        </span><span style="color: #008080;">error_reporting</span>(<span style="color: #ff00ff;">E_ERROR</span> | <span style="color: #ff00ff;">E_WARNING</span> | <span style="color: #ff00ff;">E_PARSE</span>);<span style="color: #008000;">//</span><span style="color: #008000;">禁止显示错误警号等</span>          <span style="color: #800080;">$name</span>=<span style="color: #800080;">$_GET</span>['key'<span style="color: #000000;">];    </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$name</span>==""<span style="color: #000000;">)    {        </span><span style="color: #0000ff;">exit</span><span style="color: #000000;">();    }</span><span style="color: #0000ff;">else</span><span style="color: #000000;">    {       </span><span style="color: #800080;">$con</span>=@<span style="color: #008080;">mysql_connect</span>(DB_USER,DB_ROOT,DB_PWD)or <span style="color: #0000ff;">die</span>('连接错误'<span style="color: #000000;">);       </span><span style="color: #008000;">//</span><span style="color: #008000;">选择数据库</span>       <span style="color: #008080;">mysql_select_db</span>(DB_NAME,<span style="color: #800080;">$con</span>)or <span style="color: #0000ff;">die</span>('Occured error'<span style="color: #000000;">);       </span><span style="color: #008080;">mysql_query</span>('SET NAMES UTF8') or <span style="color: #0000ff;">die</span>('显示错误'<span style="color: #000000;">);               </span><span style="color: #800080;">$sql</span>="UPDATE chinesechess SET isActivated='1' WHERE nickname='{<span style="color: #800080;">$name</span>}'"<span style="color: #000000;">;        </span><span style="color: #800080;">$result</span> = <span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$con</span>) or <span style="color: #0000ff;">die</span>('error'<span style="color: #000000;">);       </span><span style="color: #008000;">//</span><span style="color: #008000;">关闭数据库</span>    <span style="color: #008080;">mysql_close</span><span style="color: #000000;">(); </span><span style="color: #0000ff;">echo</span>'<span style="color: #000000;"><html>    <head>        <meta charset="utf-8" />        <title>账号已激活</title>        <link rel="stylesheet" href="css/index_CSS.css" /></span>'<span style="color: #000000;">;        </span><span style="color: #800080;">$name</span>="<span style="color: #000000;">        <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></span>"<span style="color: #000000;">;    </span><span style="color: #0000ff;">echo</span> '<span style="color: #000000;"></head>    <body>    <div id="tDiv">   <table>  <td></td>   </table>   <h2 id="账户已激活">账户已激活</h2>   <p> </p>   <table width="100%" border="0">     <tr>       <td id="tDL"><p>您的随机昵称为：<label></span>'.<span style="color: #800080;">$name</span>.'<span style="color: #000000;"></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></span>'<span style="color: #000000;">;      }</span>?>

登入後複製

CSS：

<span style="color: #800000;">@charset "utf-8";</span><span style="color: #008000;">/*</span><span style="color: #008000;"> CSS Document </span><span style="color: #008000;">*/</span><span style="color: #800000;">h2</span>{<span style="color: #ff0000;">    font-size</span>:<span style="color: #0000ff;">56px</span>;<span style="color: #ff0000;">    font-weight</span>:<span style="color: #0000ff;">bold</span>;<span style="color: #ff0000;">    text-align</span>:<span style="color: #0000ff;">center</span>;}<span style="color: #800000;">body</span>{<span style="color: #ff0000;">    width</span>:<span style="color: #0000ff;">auto</span>;<span style="color: #ff0000;">    height</span>:<span style="color: #0000ff;">auto</span>;<span style="color: #ff0000;">    background-image</span>:<span style="color: #0000ff;">url(../images/03.png)</span>;<span style="color: #ff0000;">    background-repeat</span>:<span style="color: #0000ff;">no-repeat</span>;<span style="color: #ff0000;">    background-size</span>:<span style="color: #0000ff;">100% 100%</span>;<span style="color: #ff0000;">    background-attachment</span>:<span style="color: #0000ff;">fixed</span>;<span style="color: #ff0000;">    background-position</span>:<span style="color: #0000ff;">center</span>;}<span style="color: #800000;">#tDiv</span>{<span style="color: #ff0000;">    background-image</span>:<span style="color: #0000ff;">url(../images/o1.png)</span>;<span style="color: #ff0000;">    background-repeat</span>:<span style="color: #0000ff;">repeat</span>;<span style="color: #ff0000;">    margin-left</span>:<span style="color: #0000ff;">auto</span>;<span style="color: #ff0000;">    margin-right</span>:<span style="color: #0000ff;">auto</span>;<span style="color: #ff0000;">    margin-top</span>:<span style="color: #0000ff;">200px</span>;<span style="color: #ff0000;">    width</span>:<span style="color: #0000ff;">550px</span>;<span style="color: #ff0000;">    height</span>:<span style="color: #0000ff;">auto</span>;<span style="color: #ff0000;">    font-size</span>:<span style="color: #0000ff;">10px</span>;<span style="color: #ff0000;">    border</span>:<span style="color: #0000ff;">2px solid #CCC</span>;}<span style="color: #800000;">#tDL</span>{<span style="color: #ff0000;">    font-size</span>:<span style="color: #0000ff;">24px</span>;<span style="color: #ff0000;">    text-align</span>:<span style="color: #0000ff;">center</span>;}

登入後複製

<?<span style="color: #000000;">php     </span><span style="color: #008080;">header</span>("Content-Type:text/html;charset=utf-8"<span style="color: #000000;">);          </span><span style="color: #0000ff;">require_once</span> "sendEmail/mysqlInfo/sqlInfo.php"<span style="color: #000000;">;          </span><span style="color: #008080;">error_reporting</span>(<span style="color: #ff00ff;">E_ERROR</span> | <span style="color: #ff00ff;">E_WARNING</span> | <span style="color: #ff00ff;">E_PARSE</span>);<span style="color: #008000;">//</span><span style="color: #008000;">禁止显示错误警号等</span>     <span style="color: #800080;">$sign</span>=''<span style="color: #000000;">;            </span><span style="color: #800080;">$_email</span>=<span style="color: #800080;">$_POST</span>['_email'<span style="color: #000000;">];         </span><span style="color: #800080;">$_paswd</span>=<span style="color: #800080;">$_POST</span>['_pasd'<span style="color: #000000;">];</span><span style="color: #008000;">//</span><span style="color: #008000;">     $_email="[email&#160;protected]";//     $_paswd="1234567890";</span>     <span style="color: #800080;">$_activate</span>='1';  <span style="color: #008000;">//</span><span style="color: #008000;">激活变量     //连接数据库</span>     <span style="color: #800080;">$con</span>=@<span style="color: #008080;">mysql_connect</span>(DB_USER,DB_ROOT,DB_PWD)or <span style="color: #0000ff;">die</span>('连接错误'<span style="color: #000000;">);         </span><span style="color: #008080;">mysql_select_db</span>(DB_NAME,<span style="color: #800080;">$con</span>)or <span style="color: #0000ff;">die</span>('Occured error'<span style="color: #000000;">);     </span><span style="color: #008080;">mysql_query</span>('SET NAMES UTF8') or <span style="color: #0000ff;">die</span>('显示错误'<span style="color: #000000;">);        </span><span style="color: #800080;">$sql</span>="SELECT * FROM chinesechess WHERE user_email='{<span style="color: #800080;">$_email</span>}'and password='{<span style="color: #800080;">$_paswd</span>}' and isActivated='{<span style="color: #800080;">$_activate</span>}'"<span style="color: #000000;">;    </span><span style="color: #800080;">$result</span> = <span style="color: #008080;">mysql_query</span>(<span style="color: #800080;">$sql</span>,<span style="color: #800080;">$con</span><span style="color: #000000;">);    </span><span style="color: #800080;">$source</span>=<span style="color: #008080;">mysql_fetch_array</span>(<span style="color: #800080;">$result</span><span style="color: #000000;">);        </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$source</span><span style="color: #000000;">)    {        </span><span style="color: #800080;">$sign</span>="succeed"<span style="color: #000000;">;                 </span><span style="color: #800080;">$name</span>=<span style="color: #800080;">$source</span>['nickname'<span style="color: #000000;">];             </span><span style="color: #800080;">$pasd</span>=<span style="color: #800080;">$source</span>['password'<span style="color: #000000;">];             </span><span style="color: #800080;">$mail</span>=<span style="color: #800080;">$source</span>['user_email'<span style="color: #000000;">];                 </span><span style="color: #0000ff;">echo</span> 'strings=name='.<span style="color: #800080;">$name</span>.'<br/>'<span style="color: #000000;">;        </span><span style="color: #0000ff;">echo</span> 'pasd='.<span style="color: #800080;">$pasd</span>.'<br/>'<span style="color: #000000;">;        </span><span style="color: #0000ff;">echo</span> 'mail='.<span style="color: #800080;">$mail</span>.'<br/>'<span style="color: #000000;">;        </span><span style="color: #0000ff;">echo</span> 'sign='.<span style="color: #800080;">$sign</span>.'<br/>'<span style="color: #000000;">;    }</span><span style="color: #0000ff;">else</span><span style="color: #000000;">    {         </span><span style="color: #800080;">$sign</span>="faild"<span style="color: #000000;">;                 </span><span style="color: #800080;">$name</span>="null"<span style="color: #000000;">;                 </span><span style="color: #800080;">$pasd</span>="000000"<span style="color: #000000;">;                 </span><span style="color: #800080;">$mail</span>="[email&#160;protected]"<span style="color: #000000;">;                 </span><span style="color: #0000ff;">echo</span> 'strings=name='.<span style="color: #800080;">$name</span>.'<br/>'<span style="color: #000000;">;        </span><span style="color: #0000ff;">echo</span> 'pasd='.<span style="color: #800080;">$pasd</span>.'<br/>'<span style="color: #000000;">;        </span><span style="color: #0000ff;">echo</span> 'mail='.<span style="color: #800080;">$mail</span>.'<br/>'<span style="color: #000000;">;        </span><span style="color: #0000ff;">echo</span> 'sign='.<span style="color: #800080;">$sign</span>.'<br/>'<span style="color: #000000;">;            }            </span><span style="color: #008080;">mysql_close</span><span style="color: #000000;">();</span>?>

登入後複製

Resource id #num

由于本人是一枚初学者，对mysql查询返回值等理解不够，遇到了一点困惑，mysql_query() 仅对 SELECT，SHOW，EXPLAIN 或 DESCRIBE 语句返回一个资源标识符，如果查询执行不正确则返回 FALSE。要使用mysql_fatch_array()函数或者mysql_fetch_object()函数进行转换，然后对相应数组或者对象进行操作。

总的来说这部分遇到的困难也不是很多，经过自己的努力很快就解决了。

本網站聲明

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn