comments_frame.php
1.16 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
/**
*
* 二级域名评论调用
*
* @version $Id: comments_frame.php 1 20:43 2010年7月8日Z cha369 $
* @package DedeCMS.Site
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__)."/../include/common.inc.php");
require_once(DEDEINC."/datalistcp.class.php");
$action = isset($action) ? trim($action) : '';
$id = empty($id)? 0 : intval(preg_replace("/[^\d]/",'', $id));
if($id < 1) exit();
$siteurl = '';
$sql ="SELECT arctype.siteurl FROM #@__archives arc LEFT JOIN #@__arctype arctype ON arctype.id=arc.typeid WHERE arc.id=$id";
$row = $dsql->GetOne($sql);
if(is_array($row)) $siteurl = $row['siteurl'];
$sql = "SELECT fb.*,mb.userid,mb.face as mface,mb.spacesta,mb.scores
FROM `#@__feedback` fb
LEFT JOIN `#@__member` mb ON mb.mid = fb.mid
WHERE fb.aid=$id and fb.ischeck='1'
ORDER BY fb.id DESC
";
$dlist = new DataListCP();
$dlist->pageSize = 6;
$dlist->SetParameter('id', $id);
$dlist->SetTemplet(DEDETEMPLATE.'/plus/comments_frame.htm');
$dlist->SetSource($sql);
$dlist->display();