$s_a_dbr = sprintf('select a.*, b.power, b.name from %s as a, %s as b where a.cid=%s and a.aid=b.id and a.disp=0 order by a.datetime desc', $dbprefix . 'ccomment', $dbprefix . 'member', $r_dbc['id']);
$q_a_dbr = mysql_query($s_a_dbr) or die('');
$c_dbr = mysql_num_rows($q_a_dbr);
if ($c_dbr > 0) {
$p_dbr = ceil($c_dbr / $config['pagesize']);
if ($page > $p_dbr) {
$page = $p_dbr;
}
$s_dbr = sprintf('%s limit %d, %d', $s_a_dbr, ($page - 1) * $config['pagesize'], $config['pagesize']);
$q_dbr = mysql_query($s_dbr) or die('');
$r_dbr = mysql_fetch_assoc($q_dbr);
do {
$content .= '<div class="topic" id="topic-' . $r_dbr['id'] . '"><a href="?m=user&id=' . $r_dbr['aid'] . '">' . $r_dbr['name'] . '</a> ' . getldate($r_dbr['datetime']) . '<div class="list_c">';
if ($r_dbr['sid'] > 0) {
$pr = getpinfo($r_dbr['sid']);
$content .= '<a href="?m=album&id=' . $r_dbr['sid'] . '"><img src="' . getmthu($pr) . '" alt="" title="' . ($pr['vid'] > 0 ? '[视频]' : '') . $pr['title'] . '" width="70" height="70" class="photo"/></a>';
$reply_s = 5;
$s_dbb = sprintf('select a.id, a.aid, a.content, a.datetime, b.name from %s as a, %s as b where a.pid=%s and a.aid=b.id and a.disp=0 order by a.datetime desc limit %d', $dbprefix . 'pcomment', $dbprefix . 'member', $r_dbr['sid'], $reply_s);
$q_dbb = mysql_query($s_dbb) or die('');
$r_dbb = mysql_fetch_assoc($q_dbb);
if (mysql_num_rows($q_dbb) > 0) {
$content .= '<div class="reply_d">';
$i = 0;
$fid = 0;
do {
if ($i == 0) {
$fid = $r_dbb['id'];
}
$content .= '<div class="reply_v"><a href="?m=user&id=' . $r_dbb['aid'] . '">' . $r_dbb['name'] . '</a>：' . mbookencode($r_dbb['content']) . '<div class="reply_i">- ' . getldate($r_dbb['datetime']) . '</div></div>';
$i++;
} while ($r_dbb = mysql_fetch_assoc($q_dbb));
header('Location:./');
exit;
}
mysql_free_result($q_dbp);
} else {
$title .= '照片视频';
$s_a_dbp = sprintf('select a.id, a.upload, a.vid, a.url, a.title, b.name from %s as a, %s as b where a.aid=b.id and a.disp=0 order by a.datetime desc', $dbprefix . 'photo', $dbprefix . 'member');
$q_a_dbp = mysql_query($s_a_dbp) or die('');
$c_dbp = mysql_num_rows($q_a_dbp);
if ($c_dbp > 0) {
$p_dbp = ceil($c_dbp / $pagesize);
if ($page > $p_dbp) {
$page = $p_dbp;
}
$s_dbp = sprintf('%s limit %d, %d', $s_a_dbp, ($page - 1) * $pagesize, $pagesize);
$q_dbp = mysql_query($s_dbp) or die('');
$r_dbp = mysql_fetch_assoc($q_dbp);
$content .= '<center>';
do {
$content .= '<a href="?m=album&id=' . $r_dbp['id'] . '"><img src="' . getmthu($r_dbp) . '" width="70" height="70" class="photo" alt="" title="' . ($r_dbp['vid'] > 0 ? '[视频]' : '') . ($r_dbp['title'] != '' ? $r_dbp['title'] . '，' : '') . '上传：' . $r_dbp['name'] . '"/></a>';
} while ($r_dbp = mysql_fetch_assoc($q_dbp));
$content .= '</center>';
mysql_free_result($q_dbp);
if ($p_dbp > 1) {
$content .= getpage($page, $p_dbp);
}
} else {
$content .= '<div class="title">照片视频</div><div class="lcontent">没有照片/视频</div>';
}
mysql_free_result($q_a_dbp);
}
