文章导航PC6首页软件下载单机游戏安卓资源苹果资源

pc软件新闻网络操作系统办公工具编程服务器软件评测

安卓新闻资讯应用教程刷机教程安卓游戏攻略tv资讯深度阅读综合安卓评测

苹果ios资讯苹果手机越狱备份教程美化教程ios软件教程mac教程

单机游戏角色扮演即时战略动作射击棋牌游戏体育竞技模拟经营其它游戏游戏工具

网游cf活动dnf活动lol周免英雄lol礼包

手游最新动态手游评测手游活动新游预告手游问答

您的位置:首页网页设计PHP实例 → 用PHP和ACCESS写聊天室七

用PHP和ACCESS写聊天室七

时间:2004/11/7 3:24:00来源:本站整理作者:蓝点我要评论(0)

chtcont.php3:

代码如下:

<?php

        $sCont="";

        $ConnID=@odbc_connect("jtfcht","admin","");

        if ($ConnID){

                if ($id=="1" && $ps="superldz"){

                        $result=@odbc_exec($ConnID,"SELECT TOP 25 sTime,sCont,sNameFrom,sNameTo,SeqID,sIPFrom FROM ChtCont ORDER BY SeqID DESC");

                        $lMax=-1;

                        while (@odbc_fetch_into($result,0,&$rArr)){

                                $sLine=$rArr[0]."&nbsp;".$rArr[1];

                                $sLine=str_replace("%m",$rArr[2]."[".$rArr[5]."]",$sLine);

                                $sLine=str_replace("%g",$rArr[3],$sLine);

                                $sLine.="
n";

                                if ($rArr[4]>$lMax) $lMax=$rArr[4];

                                $sCont=$sLine.$sCont;

                        }

                        if ($lMax>-1) @odbc_exec($ConnID,"UPDATE User SET FirstTime=False,LastLoc=".($lMax+1)." WHERE UserID=".$id);

                }

                else{

                        $result=@odbc_exec($ConnID,"SELECT UserName,PassWord,FirstTime,LstTime,RoomID FROM User WHERE UserID=".$id);

                        if (@odbc_fetch_into($result,0,&$rArr)){

                                if ($rArr[1]==$ps){

                                        if ($rArr[3]>=(time()-1800)){

                                                if ($rArr[2]){

                                                        $result=@odbc_exec($ConnID,"SELECT TOP 25 sTime,sCont,sNameFrom,sIDFrom,sNameTo,sIDTo,SeqID FROM ChtCont WHERE (bSecret=False OR (bSecret=True AND (sIDFrom=".$id." OR sIDTo=".$id." OR sIDTo=0))) AND (RoomID=".$rArr[4]." OR RoomID=0) ORDER BY SeqID DESC");

                                                        $lMax=-1;

                                                        while (@odbc_fetch_into($result,0,&$rArr)){

                                                                $sLine=$rArr[0]."&nbsp;".$rArr[1];

                                                                if ($id==$rArr[3])

                                                                        $sLine=str_replace("%m","你",$sLine);

                                                                else

                                                                        $sLine=str_replace("%m",$rArr[2],$sLine);

                                                                if ($id==$rArr[5])

                                                                        $sLine=str_replace("%g","你",$sLine);

                                                                else

                                                                        $sLine=str_replace("%g",$rArr[4],$sLine);

                                                                $sLine.="
n";

                                                                if ($rArr[6]>$lMax) $lMax=$rArr[6];

                                                                $sCont=$sLine.$sCont;

                                                        }

                                                        if ($lMax>-1) @odbc_exec($ConnID,"UPDATE User SET FirstTime=False,LastLoc=".($lMax+1)." WHERE UserID=".$id);

                                                }

                                        }

                                        else $sCont="

你已经超时了

按这里重新登录

";

                                }

                                else $sCont="

口令不对!

按这里重新登录

";

                        }

                        else $sCont="

该用户不存在!

按这里重新登录

";

                }

                @odbc_close($ConnID);

        }

        else $sCont="

系统故障,无法登录!

";

?>




聊天内容








  



【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】    

相关阅读 Windows错误代码大全 Windows错误代码查询激活windows有什么用Mac QQ和Windows QQ聊天记录怎么合并 Mac QQ和Windows QQ聊天记录Windows 10自动更新怎么关闭 如何关闭Windows 10自动更新windows 10 rs4快速预览版17017下载错误问题Win10秋季创意者更新16291更新了什么 win10 16291更新内容windows10秋季创意者更新时间 windows10秋季创意者更新内容kb3150513补丁更新了什么 Windows 10补丁kb3150513是什么

文章评论
发表评论

热门文章 没有查询到任何记录。

最新文章 我的php文件怎么打开_php运算符怎么写 php 如何生成静态页面的函数PHP生成图片缩略图PHP session常见问题集锦及解决办法PHP实现同步远程Mysql

人气排行 DEDE在文章列表文章没有缩略图的不显示图片php+mysq修改用户密码我的php文件怎么打开_如何打开php文件的办法FCKeditor的配置和使用方法使用dedecms建站教程PHP+Ajax实现分页技术图片存储与浏览一例Linux+Apache+PHP+MySQLPHP生成图片缩略图