showmessage.php
资源名称:BBWPS.rar [点击查看]
上传用户:yttaitong
上传日期:2009-05-10
资源大小:128k
文件大小:3k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
PHP
- <?
- /*
- [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
- This is NOT a freeware, use is subject to license terms
- 时间:2007年12月
- 描述:查看信息
- */
- $un=$_COOKIE['username'];
- $parseTemplateName="showmessage.html";
- $p->set_file("handle","showmessage.html");
- $sid = $_GET['sid'];
- $p->set_var("city_id",$cid.".html");
- $mid = $_GET['mid'];
- $hits = $db->query("update ".$prefix."message set hits=hits+1 where mid='".$mid."'",1); //得到点击率
- //**********导航条***********
- $sql1 = $db->query("select a.sid,a.sname from ".$prefix."sort as a join ".$prefix."sort as b on
- a.sid=b.sparent where b.sid='".$sid."'",1);
- $result1 = $db->fetch_array($sql1);
- $onesort = $result1["sname"];
- $sql2 = $db->query("select sname from ".$prefix."sort where sid='".$sid."'",1);
- $result2 = $db->fetch_array($sql2);
- $twosort = $result2["sname"];
- if($onesort){
- $o_sort = " <a href=?f-sort--sid-".$result1["sid"]."--cid-".$cid.".html>".$onesort."</a>";
- $p->set_var("sort1",$o_sort);
- $t_sort = " <a href=?f-sort--sid-".$sid."-cid-".$cid.".html>".$twosort."</a>";
- $p->set_var("sort2",$t_sort);
- }
- else{
- $t_sort = " <a href=?f-sort--sid-".$sid."--cid-".$cid.".html>".$twosort."</a>";
- $p->set_var("sort1",$t_sort);
- }
- unset($o_sort,$t_sort);
- //********************具体信息显示*****************************
- $ssql = $db->query("select ".$prefix."message.cid,".$prefix."message.sid,".$prefix."message.title,".$prefix."message.username,".$prefix."message.content,picture,oprice,nprice,btime,etime,cname,sname
- from ".$prefix."message left join ".$prefix."city on ".$prefix."message.cid=".$prefix."city.cid left join ".$prefix."sort on ".$prefix."message.sid=".$prefix."sort.sid where mid='".$mid."'",1);
- $sresult = $db->fetch_array($ssql);
- $p->set_var("city_id",$cid.".html");
- $cont=str_replace("<br />","n",$sresult["content"]);
- $p->set_var($sresult);
- $p->set_var(array("bdate"=> date("Y-m-j",$sresult["btime"]),"edate"=> date("Y-m-j",$sresult["etime"]),"cont"=> $cont));
- if(!$sresult["username"]){$t="管理员";}else{$t=$sresult["username"];}
- $sql="select `cname`,`cparent` from ".$prefix."city where `cid`='$cid' or `cid`= {$sresult['cid']}";
- $rr=$db->query($sql);
- while($rs=$db->fetch_array($rr)){
- if($rs['cparent']==0){ $tem_array[0]=$rs['cname'];}else{$tem_array[1]=$rs['cname'];}
- }
- $p->set_var("addresses",$tem_array[0]." ".$tem_array[1]);
- $p->set_var("uname",$t);
- $p->set_block("handle","op","o");
- if($sresult["picture"]){
- $handle = explode(".",$sresult["picture"]);
- $file = date("Y-m-j",$handle[0]);
- $p->set_var("file",$file);
- $p->set_var("photo",$sresult["picture"]);
- $p->parse("o","op",true);
- }
- //************评论显示***************
- $number = $db->query("select count(mid) from ".$prefix."revert where mid='".$mid."'",1); //总条数
- $num = $db->fetch_array($number);
- $total = $num["count(mid)"];
- $query="f-showmessage--mid-".$mid."--sid-".$sid."--cid-".$cid;
- //评论解析由define_class.php执行
- //*******发表评论************
- $p->set_var(array("mid"=> $mid,"city_id"=> $cid.".html","sid"=> $sid));
- $p->set_var("fenye",showpage($total,$pagesize,$page,$query));
- ?>