Exemplo n.º 1
0
 function getSql($type, $pageno = '', $pagesize = '', $postinfo = '', $addtype = '', $pid_list = '', $get_order_by_str = '')
 {
     require_once './class/db.class.php';
     $sql = '';
     if (!empty($type)) {
         switch ($type) {
             //首页
             case 'top':
                 //头条大图
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.summary,a.idtype,a.id,b.closed FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id=b.tid WHERE a.bid=" . TOPBID . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'tops':
                 //头条小图
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.summary,a.idtype,a.id,b.closed FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id=b.tid WHERE a.bid=" . TOPSBID . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'topic_pic':
                 //话题大图
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT title,pic,idtype,id FROM `" . DB_PRE . "common_block_item_data` WHERE bid=" . TOPICPICBID . " ORDER BY dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'topic':
                 //话题
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.idtype,a.id,a.dateline,c.name FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id = b.tid LEFT JOIN `" . DB_PRE . "forum_forum` as c ON b.fid = c.fid WHERE a.bid=" . TOPICBID . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'poll':
                 //投票
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.idtype,a.id,b.subject,b.dateline,c.expiration FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id = b.tid LEFT JOIN `" . DB_PRE . "forum_poll` as c ON a.id = c.tid WHERE a.bid=" . POLLBID . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'poll_detail':
                 //投票详情
                 $sql = "SELECT votes,polloption,polloptionid FROM `" . DB_PRE . "forum_polloption` WHERE tid = '" . $_GET['tid'] . "' ORDER BY polloptionid asc";
                 break;
             case 'poll_result':
                 //投票结果统计
                 $sql = "SELECT a.votes,a.polloption,b.voters FROM `" . DB_PRE . "forum_polloption` as a LEFT JOIN `" . DB_PRE . "forum_poll` as b ON a.tid=b.tid WHERE a.tid = '" . $_GET['tid'] . "' ORDER BY a.polloptionid asc";
                 break;
             case 'allpoll':
                 $sql = "SELECT title FROM `" . DB_PRE . "common_block_item_data` WHERE bid=" . POLLBID . " ORDER BY dateline desc";
                 break;
             case 'index2':
                 //茶座
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.summary,a.idtype,a.id,b.closed FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id=b.tid WHERE a.bid=" . INDEX2 . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'index3':
                 //焦点
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.summary,a.idtype,a.id,b.closed FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id=b.tid WHERE a.bid=" . INDEX3 . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'index4':
                 //娱乐
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.summary,a.idtype,a.id,b.closed FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id=b.tid WHERE a.bid=" . INDEX4 . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'index5':
                 //情感
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.title,a.pic,a.summary,a.idtype,a.id,b.closed FROM `" . DB_PRE . "common_block_item_data` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.id=b.tid WHERE a.bid=" . INDEX5 . " ORDER BY a.dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
                 //生活
             //生活
             case 'second1':
                 //美食
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . SECOND1 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'second2':
                 //汽车
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . SECOND2 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'second3':
                 //房产
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . SECOND3 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'second4':
                 //家装
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . SECOND4 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'second5':
                 //婚姻
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . SECOND5 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'second6':
                 //母婴
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . SECOND6 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
                 //安卓额外
             //安卓额外
             case 'third1':
                 //板块1
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . THIRD1 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'third2':
                 //板块1
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . THIRD2 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'third3':
                 //板块1
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . THIRD3 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'third4':
                 //板块1
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . THIRD4 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'third5':
                 //板块1
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . THIRD5 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'third6':
                 //板块1
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE `displayorder` = '0' AND `fid` = '" . THIRD6 . "' " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
                 //论坛部分
             //论坛部分
             case 'forum_list':
                 //论坛板块列表
                 $sql = "SELECT a.fid,a.fup,a.type,a.name,a.status,b.viewperm,b.postperm,b.replyperm,b.postimageperm,b.formulaperm,b.moderators,b.spviewperm FROM `" . DB_PRE . "forum_forum` as a LEFT JOIN `" . DB_PRE . "forum_forumfield` as b ON a.fid=b.fid WHERE a.status = 1 ORDER BY a.displayorder asc";
                 break;
             case 'thread_list':
                 //板块帖子列表(需要传一个fid参数)
                 //调取板块默认排序方式
                 $orderby = '';
                 $ascdesc = '';
                 $forums_sql = "SELECT * FROM `" . DB_PRE . "common_syscache` WHERE cname = 'forums'";
                 $db = new DB();
                 $forums_info = $db->fetch_all($forums_sql);
                 $forums_string = $forums_info[0]['data'];
                 if (strtoupper(DBCHARSET) == 'GBK') {
                     $forums_string = mb_convert_encoding($forums_string, 'GBK', 'UTF-8');
                 }
                 $forums = unserialize($forums_string);
                 if (!empty($forums)) {
                     foreach ($forums as $k => $v) {
                         if ($v['fid'] == $_GET['fid']) {
                             $orderby = $v['orderby'];
                             $ascdesc = $v['ascdesc'];
                             break;
                         }
                     }
                 }
                 $orderby = $this->getorderby($orderby, $ascdesc);
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 if ($_GET['orderby'] == '') {
                     $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE displayorder != '-1' AND fid=" . $_GET['fid'] . $orderby . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 } else {
                     $sql = "SELECT subject,author,dateline,views,replies,tid,fid,closed FROM `" . DB_PRE . "forum_thread` WHERE displayorder != '-1' AND fid=" . $_GET['fid'] . " " . $get_order_by_str . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 }
                 break;
             case 'threadcount':
                 $sql = "SELECT count(tid) as num FROM `" . DB_PRE . "forum_thread` WHERE displayorder = '0' AND fid=" . $_GET['fid'];
                 break;
             case 'thread_detail_getpid':
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 if ($addtype == 'only_owner') {
                     //只看楼主
                     $sql = "SELECT pid FROM `" . DB_PRE . "forum_post` WHERE tid = '" . $_GET['tid'] . "' AND invisible = '0' AND authorid = '" . $_GET['authorid'] . "' GROUP BY pid ORDER BY dateline asc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 } elseif ($addtype == 'last_post') {
                     //最新回复
                     $sql = "SELECT pid FROM `" . DB_PRE . "forum_post` WHERE tid = '" . $_GET['tid'] . "' AND invisible = '0' GROUP BY pid ORDER BY dateline desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 } else {
                     $sql = "SELECT pid FROM `" . DB_PRE . "forum_post` WHERE tid = '" . $_GET['tid'] . "' AND invisible = '0' GROUP BY pid ORDER BY dateline asc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 }
                 break;
             case 'thread_detail':
                 //帖子详细(需要传一个tid参数)
                 //$limit_param  = $this->getLimitParam($pageno,$pagesize);
                 if ($addtype == 'only_owner') {
                     //只看楼主
                     $sql = "SELECT a.status,a.anonymous,a.pid,subject,message,a.dateline,a.tid,author,b.uid,fid,avatarstatus,c.attachment,c.remote FROM `" . DB_PRE . "forum_post` as a LEFT JOIN `" . DB_PRE . "common_member` as b ON a.authorid=b.uid LEFT JOIN `" . DB_PRE . "forum_attachment_" . gettableidbytid($_GET['tid']) . "` as c ON a.pid=c.pid WHERE a.pid IN (" . $pid_list . ") ORDER BY dateline asc";
                 } elseif ($addtype == 'last_post') {
                     //最新回复
                     $sql = "SELECT a.status,a.anonymous,a.pid,subject,message,a.dateline,a.tid,author,b.uid,fid,avatarstatus,c.attachment,c.remote FROM `" . DB_PRE . "forum_post` as a LEFT JOIN `" . DB_PRE . "common_member` as b ON a.authorid=b.uid LEFT JOIN `" . DB_PRE . "forum_attachment_" . gettableidbytid($_GET['tid']) . "` as c ON a.pid=c.pid WHERE a.pid IN (" . $pid_list . ") ORDER BY dateline desc";
                 } else {
                     $sql = "SELECT a.status,a.anonymous,a.pid,subject,message,a.dateline,a.tid,author,b.uid,fid,avatarstatus,c.attachment,c.remote FROM `" . DB_PRE . "forum_post` as a LEFT JOIN `" . DB_PRE . "common_member` as b ON a.authorid=b.uid LEFT JOIN `" . DB_PRE . "forum_attachment_" . gettableidbytid($_GET['tid']) . "` as c ON a.pid=c.pid WHERE a.pid IN (" . $pid_list . ") ORDER BY dateline asc";
                 }
                 break;
             case 'owner_authorid':
                 $sql = "SELECT authorid FROM `" . DB_PRE . "forum_post` WHERE tid=" . $_GET['tid'] . " AND first = '1'";
                 break;
             case 'postcount':
                 //帖子楼层总数
                 if ($addtype == 'only_owner') {
                     //只看楼主
                     $sql = "SELECT count(pid) as num FROM `" . DB_PRE . "forum_post` WHERE invisible = '0' AND tid=" . $_GET['tid'] . " AND authorid=" . $_GET['authorid'];
                 } else {
                     $sql = "SELECT count(pid) as num FROM `" . DB_PRE . "forum_post` WHERE invisible = '0' AND tid=" . $_GET['tid'];
                 }
                 break;
             case 'top_thread':
                 //置顶帖子(需要传一个fid参数)
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid FROM `" . DB_PRE . "forum_thread` WHERE displayorder>0 AND fid=" . $_GET['fid'] . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'top_thread_count':
                 //置顶帖子数量
                 $sql = "SELECT count(tid) as num FROM `" . DB_PRE . "forum_thread` WHERE displayorder>0 AND fid=" . $_GET['fid'] . " ORDER BY dateline desc";
                 break;
             case 'digest_thread':
                 //精华帖(需要传一个fid参数)
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid FROM `" . DB_PRE . "forum_thread` WHERE digest!=0 AND fid=" . $_GET['fid'] . " LIMIT " . $limit_param[0] . "," . $limit_param[1] . " ORDER BY dateline desc";
                 break;
             case 'digest_thread_count':
                 //精华帖子数量
                 $sql = "SELECT count(tid) as num FROM `" . DB_PRE . "forum_thread` WHERE digest!=0 AND fid=" . $_GET['fid'];
                 break;
             case 'search_thread':
                 //搜索帖子(需要传一个fid参数+一个keyword参数<经过url编码过的>)
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT subject,author,dateline,views,replies,tid,fid FROM `" . DB_PRE . "forum_thread` WHERE subject like '%" . urldecode($_GET['keyword']) . "%' AND fid=" . $_GET['fid'] . " LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'search_thread_count':
                 //搜索结果帖子数量
                 $sql = "SELECT count(tid) as num FROM `" . DB_PRE . "forum_thread` WHERE subject like '%" . urldecode($_GET['keyword']) . "%' AND fid=" . $_GET['fid'];
                 break;
             case 'post_step1':
                 //发帖插入主题表(需要传一个fid参数)
                 if ($_GET['img'] == '1') {
                     $sql = "INSERT INTO `" . DB_PRE . "forum_thread` (`fid`,`author`,`authorid`,`subject`,`dateline`,`lastpost`,`lastposter`,`views`,`attachment`,`typeid`,`displayorder`) VALUES ('" . $_GET['fid'] . "','" . $postinfo['author'] . "','" . $postinfo['authorid'] . "','" . $postinfo['subject'] . "','" . $postinfo['date'] . "','" . $postinfo['date'] . "','" . $postinfo['author'] . "','1','2','" . $postinfo['typeid'] . "','" . $postinfo['verify'] . "')";
                 } else {
                     $sql = "INSERT INTO `" . DB_PRE . "forum_thread` (`fid`,`author`,`authorid`,`subject`,`dateline`,`lastpost`,`lastposter`,`views`,`typeid`,`displayorder`) VALUES ('" . $_GET['fid'] . "','" . $postinfo['author'] . "','" . $postinfo['authorid'] . "','" . $postinfo['subject'] . "','" . $postinfo['date'] . "','" . $postinfo['date'] . "','" . $postinfo['author'] . "','1','" . $postinfo['typeid'] . "','" . $postinfo['verify'] . "')";
                 }
                 break;
             case 'post_step2':
                 //发帖插入帖子表(需要传一个fid参数)
                 if ($_GET['img'] == '1') {
                     $sql = "INSERT INTO `" . DB_PRE . "forum_post` (`pid`,`fid`,`tid`,`first`,`author`,`authorid`,`subject`,`dateline`,`message`,`useip`,`bbcodeoff`,`smileyoff`,`usesig`,`attachment`,`invisible`,`status`) VALUES ('" . $postinfo['pid'] . "','" . $_GET['fid'] . "','" . $postinfo['tid'] . "','1','" . $postinfo['author'] . "','" . $postinfo['authorid'] . "','" . $postinfo['subject'] . "','" . $postinfo['date'] . "','" . strtr(addslashes($postinfo['message']), array('(' => '\\(', ')' => '\\)')) . "','" . $postinfo['useip'] . "','-1','0','1','2','" . $postinfo['verify'] . "','" . $postinfo['status'] . "')";
                 } else {
                     $sql = "INSERT INTO `" . DB_PRE . "forum_post` (`pid`,`fid`,`tid`,`first`,`author`,`authorid`,`subject`,`dateline`,`message`,`useip`,`bbcodeoff`,`smileyoff`,`usesig`,`invisible`,`status`) VALUES ('" . $postinfo['pid'] . "','" . $_GET['fid'] . "','" . $postinfo['tid'] . "','1','" . $postinfo['author'] . "','" . $postinfo['authorid'] . "','" . $postinfo['subject'] . "','" . $postinfo['date'] . "','" . strtr(addslashes($postinfo['message']), array('(' => '\\(', ')' => '\\)')) . "','" . $postinfo['useip'] . "','-1','0','1','" . $postinfo['verify'] . "','" . $postinfo['status'] . "')";
                 }
                 break;
             case 'reply':
                 //回帖(需要传一个tid参数)
                 if ($_GET['img'] == '1') {
                     $sql = "INSERT INTO `" . DB_PRE . "forum_post` (`pid`,`fid`,`tid`,`first`,`author`,`authorid`,`subject`,`dateline`,`message`,`useip`,`bbcodeoff`,`smileyoff`,`usesig`,`attachment`,`invisible`,`status`) VALUES ('" . $postinfo['pid'] . "','" . $_GET['fid'] . "','" . $_GET['tid'] . "','0','" . $postinfo['author'] . "','" . $postinfo['authorid'] . "','" . $postinfo['subject'] . "','" . $postinfo['date'] . "','" . strtr(addslashes($postinfo['message']), array('(' => '\\(', ')' => '\\)')) . "','" . $postinfo['useip'] . "','" . $postinfo['bbcodeoff'] . "','0','1','2','" . $postinfo['verify'] . "','" . $postinfo['status'] . "')";
                 } else {
                     $sql = "INSERT INTO `" . DB_PRE . "forum_post` (`pid`,`fid`,`tid`,`first`,`author`,`authorid`,`subject`,`dateline`,`message`,`useip`,`bbcodeoff`,`smileyoff`,`usesig`,`invisible`,`status`) VALUES ('" . $postinfo['pid'] . "','" . $_GET['fid'] . "','" . $_GET['tid'] . "','0','" . $postinfo['author'] . "','" . $postinfo['authorid'] . "','" . $postinfo['subject'] . "','" . $postinfo['date'] . "','" . strtr(addslashes($postinfo['message']), array('(' => '\\(', ')' => '\\)')) . "','" . $postinfo['useip'] . "','" . $postinfo['bbcodeoff'] . "','0','1','" . $postinfo['verify'] . "','" . $postinfo['status'] . "')";
                 }
                 break;
             case 'smiley':
                 $sql = "SELECT code,url FROM `" . DB_PRE . "common_smiley` WHERE type='smiley' AND typeid='" . SMILEY_TYPEID . "' ORDER BY displayorder asc";
                 break;
             case 'all_smiley':
                 $sql = "SELECT code,url,directory FROM `" . DB_PRE . "common_smiley` as a LEFT JOIN `" . DB_PRE . "forum_imagetype` as b ON a.typeid=b.typeid WHERE a.type='smiley' AND b.available != '0'";
                 break;
             case 'memberinfo':
                 $sql = "SELECT username,adminid,groupid FROM `" . DB_PRE . "common_member` WHERE uid = " . intval($_GET['uid']);
                 break;
             case 'picshow_info':
                 $limit_param = $this->getLimitParam($pageno, $pagesize);
                 $sql = "SELECT a.picshow_id,a.picshow_title,a.picshow_coverpic,a.tid,b.fid FROM `" . DB_PRE . "common_picshow` as a LEFT JOIN `" . DB_PRE . "forum_thread` as b ON a.tid=b.tid ORDER BY a.picshow_addtime desc LIMIT " . $limit_param[0] . "," . $limit_param[1];
                 break;
             case 'picshow_pic_info':
                 $sql = "SELECT a.*,b.picshow_title,b.picshow_content FROM `" . DB_PRE . "common_pic` as a LEFT JOIN `" . DB_PRE . "common_picshow` as b ON a.picshow_id=b.picshow_id WHERE a.picshow_id = '" . $_GET['picshow_id'] . "'";
                 break;
             default:
                 $sql = "none";
         }
         return $sql;
     }
 }
Exemplo n.º 2
0
        echo '<script>alert("成功新增一条图片新闻!");window.location.href="picshow_list.php"</script>';
        die;
    } else {
        echo '<script>alert("新增一条图片新闻失败");history.back();</script>';
        die;
    }
}
if ($_GET['tid'] == '' || $_GET['tid'] == '0') {
    echo '<script>alert("参数错误");history.back();</script>';
} else {
    $sql = "SELECT pid,author,authorid,subject,message FROM `" . DB_PRE . "forum_post` WHERE tid = '" . $_GET['tid'] . "' ORDER BY pid asc LIMIT 0,1";
    $thread_info = $db->fetch_all($sql);
    if (empty($thread_info)) {
        echo '<script>alert("帖子信息为空");history.back();</script>';
    } else {
        $picsql = "SELECT attachment FROM `" . DB_PRE . "forum_attachment_" . gettableidbytid($_GET['tid']) . "` WHERE pid = '" . $thread_info[0]['pid'] . "'";
        $picinfo = $db->fetch_all($picsql);
    }
}
/**
 * 根据tid获取到附件表的tableid
 */
function gettableidbytid($tid)
{
    $tid_s = (string) $tid;
    $tableid = intval($tid_s[strlen($tid_s) - 1]);
    return $tableid;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
Exemplo n.º 3
0
                         $tmp_data_array[$tk]['attachment'] = $tmp_data_array[$tk]['attachment'] != '' ? $tmp_data_array[$tk]['attachment'] . ',' . $data_array[$k]['attachment'] : $data_array[$k]['attachment'];
                         //将图片加入attachment
                     }
                     break;
                 }
             }
             if ($sign) {
                 $tmp_data_array[$v['pid']] = $data_array[$k];
             }
         }
         unset($tmp_attchment_array);
         unset($first_c);
     }
 }
 $data_array = $tmp_data_array;
 $tableid = gettableidbytid(intval($_GET['tid']));
 if (!empty($data_array)) {
     foreach ($data_array as $k => $v) {
         //添加用户头像信息
         if ($v['avatarstatus'] == '1' && $v['anonymous'] == '0') {
             //有头像
             $data_array[$k]['avatar_url'] = getuseravatarurl($v['uid']);
         } else {
             //无头像则返回默认头像
             $data_array[$k]['avatar_url'] = UC_URL . '/images/noavatar_small.gif';
         }
         //对用户名进行匿名和游客的判断
         if ($v['uid'] == 0) {
             $data_array[$k]['author'] = '游客';
         }
         if ($v['anonymous'] == '1') {