当前位置:Gxlcms > PHP教程 > 用PHP和ACCESS写聊天室(八)_PHP教程

用PHP和ACCESS写聊天室(八)_PHP教程

时间:2021-07-01 10:21:17 帮助过:35人阅读

emotion.php3:
代码如下:


表情动作




$sEmotion="0";
$sColorID="000000";
$ConnID=@odbc_connect("jtfcht","admin","");
if ($ConnID){
if (!($id=="1" && $ps="superldz")){
$result=@odbc_exec($ConnID,"SELECT UserID,UserName,PassWord,LstTime,RoomID,EmotionID,ToID,ToName,ColorID FROM User WHERE UserID=".$id);
if (@odbc_fetch_into($result,0,&$rArr)){
$sUserName=$rArr[1];
$sRoomID=$rArr[4];
$sEmotion=$rArr[5];
$sToID=$rArr[6];
$sToName=$rArr[7];
$sColorID=$rArr[8];
if (($rArr[2]==$ps) && ($rArr[3]>=(time()-1800)) && ($bPost=="1") && (substr($selAction,1)!="None")){
odbc_exec($ConnID,"UPDATE User SET EmotionID=".$selEmotion.",ColorID='".$selColor."',LstTime=".time()." WHERE UserID=".$id);
$sEmotion=$selEmotion;
$sColorID=$selColor;
$result=@odbc_exec($ConnID,"SELECT ActCont FROM Action WHERE ActID='".substr($selAction,1)."'");
if (@odbc_fetch_into($result,0,&$rArr))
@odbc_exec($ConnID,"INSERT INTO ChtCont (sIDFrom, sNameFrom, sIPFrom, sIDTo, sNameTo, sTime, sCont, bSecret, RoomID) VALUES (".$id.", '".$sUserName."', '".getenv("REMOTE_ADDR")."', ".$sToID.", '".$sToName."', '".date("H:i:s")."', '".trim($rArr[0])."', False, ".$sRoomID.")");
}
}
}
?>


@odbc_close($ConnID);
}
?>




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

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/316520.htmlTechArticleemotion.php3: 代码如下: html head title表情动作/title meta http-equiv=Content-Type content=text/html; charset=gb2312 link rel=stylesheet href=main.css type=text/css /head...

人气教程排行