和回复 同时更新用户评论数 此处也需要删除待验证和回收站回复数据
function comment_delete_by_tid($tid)
{
$thread = well_thread_read_cache($tid);
if (empty($thread)) return FALSE;
$posts = $thread['posts'];
if (0 == $posts) return FALSE;
$size = 1000;
if ($posts > $size) {
$n = ceil($posts / $size);
} else {
$n = $posts;
}
for ($i = 0; $i <= $n; ++$i) {
// 查询回复小表(仅通过审核的评论) 该主题回复 pid
$arr = comment_pid__find(array('tid' => $tid), array(), 1, $size, '');
if (empty($arr)) return FALSE;
$pidarr = array();
$uidarr = array();
foreach ($arr as $val) {
$pidarr[] = $val['pid'];
isset($uidarr[$val['uid']]) ? $uidarr[$val['uid']] += 1 : $uidarr[$val['uid']] = 1;
}
$uids = array();
$user_update = array();
foreach ($uidarr as $_uid => $n) {
$uids[] = $_uid;
$user_update[$_uid]['comments-'] = $n;
}
user_big_update(array('uid' => $uids), $user_update);
// 删除所有回复和小表
comment_delete($pidarr);
}
return $posts;
}
/*
* @param $tids 数组array(1,2,3)
* @param $n 删除的总评论数量
* @return int 返回删除的数量
*/
function comment_delete_by_tids($tids, $n)
{
// 查询回复小表(仅通过审核的评论) 该主题回复 pid
$arrlist = comment_pid__find(array('tid' => $tids), array('pid' => 1), 1, $n, '');
if (!$arrlist) return 0;
$pids = array();
$uidarr = array();
foreach ($arrlist as $val) {
$pids[] = $val['pid'];
isset($uidarr[$val['uid']]) ? $uidarr[$val['uid']] += 1 : $uidarr[$val['uid']] = 1;
}
comment_pid_delete($pids);
comment__delete(array('pid' => $pids));
// 删除附件
well_attach_delete_by_pid($pids);
$uids = array();
$update = array();
foreach ($uidarr as $_uid => $n) {
$uids[] = $_uid;
$update[$_uid] = array('comments-' => $n);
}
// 更新用户评论数
user_big_update(array('uid' => $uids), $update);
return count($pids);
}
function comment_delete_by_pids($pids)
{
$commentlist = comment__find(array('pid' => $pids), array('pid' => -1), 1, count($pids));
$pidarr = array();
$uidarr = array();
$tidarr = array();
foreach ($commentlist as $comment) {
// 每个栏目下的回复数
$pidarr[] = $comment['pid'];
// uid
isset($uidarr[$comment['uid']]) ? $uidarr[$comment['uid']] += 1 : $uidarr[$comment['uid']] = 1;
// tid
isset($tidarr[$comment['tid']]) ? $tidarr[$comment['tid']] += 1 : $tidarr[$comment['tid']] = 1;
}
unset($postist);
if (!empty($pidarr)) {
// 删除附件
well_attach_delete_by_pid($pidarr);
// 删除主表
comment__delete(array('pid' => $pidarr));
// 删除小表
comment_pid_delete($pidarr);
runtime_set('comments-', count($pidarr));
}
// 更新用户评论数
if (!empty($uidarr)) {
$uids = array();
$update = array();
foreach ($uidarr as $_uid => $n) {
$uids[] = $_uid;
$update[$_uid] = array('credits-' => $n);
}
user_big_update(array('uid' => $uids), $update);
}
// 更新主题回复数
if (!empty($tidarr)) {
$tids = array();
$update = array();
foreach ($tidarr as $_tid => $n) {
$tids[] = $_tid;
$update[$_tid] = array('posts-' => $n);
}
thread_big_update(array('tid' => $tids), $update);
}
}
function comment_format_by_tid(&$post)
{
global $conf, $uid, $gid;
if (empty($post)) return;
$post['create_date_fmt'] = humandate($post['create_date']);
//$post['message'] = stripslashes(htmlspecialchars_decode($post['message']));
$user = user_read_cache($post['uid']);
$post['username'] = array_value($user, 'username');
$post['user_avatar_url'] = array_value($user, 'avatar_url');
$post['user'] = $user ? $user : user_guest();
isset($post['floor']) || $post['floor'] = 0;
// 权限判断
$post['allowupdate'] = ($uid == $post['uid']) || forum_access_mod($post['fid'], $gid, 'allowupdate');
$post['allowdelete'] = (group_access($gid, 'allowuserdelete') AND $uid == $post['uid']) || forum_access_mod($post['fid'], $gid, 'allowdelete');
$post['user_url'] = url('user-' . $post['uid'] . ($post['uid'] ? '' : '-' . $post['pid']));
if ($post['files'] > 0) {
list($attachlist, $imagelist, $post['filelist']) = well_attach_find_by_pid($post['pid']);
// 使用图床 评论使用图床，mysql会过多，写死链接到内容是减轻mysql的过多的方法
if (2 == $conf['attach_on']) {
foreach ($imagelist as $key => $attach) {
$url = $conf['upload_url'] . 'website_attach/' . $attach['filename'];
// 替换成图床
$post['message'] = FALSE !== strpos($post['message'], $url) && $attach['image_url'] ? str_replace($url, $attach['image_url'], $post['message']) : $post['message'];
}
}
} else {
$post['filelist'] = array();
}
$post['classname'] = 'post';
}
function comment_format(&$post)
{
global $conf, $uid, $gid, $forumlist;
if (empty($post)) return;
$forum = $post['fid'] ? forum_read($post['fid']) : '';
$thread = well_thread_read_cache($post['tid']);
if ($thread) {
//$post['fid'] = $thread['fid'];
$post['closed'] = $thread['closed'];
$post['subject'] = $thread['subject'];
$post['url'] = $thread['url'];
} else {
$post['closed'] = 0;
$post['subject'] = lang('thread_not_exists');
$post['url'] = '';
}
$post['create_date_fmt'] = humandate($post['create_date']);
//$post['message'] = stripslashes(htmlspecialchars_decode($post['message']));
$user = user_read_cache($post['uid']);
$post['username'] = array_value($user, 'username');
$post['user_avatar_url'] = array_value($user, 'avatar_url');
$post['user'] = $user ? user_safe_info($user) : user_guest();
isset($post['floor']) || $post['floor'] = 0;
// 权限判断
$post['allowupdate'] = 2 == array_value($forum, 'comment', 0) && ($uid == $post['uid'] || forum_access_mod($post['fid'], $gid, 'allowupdate'));
$post['allowdelete'] = group_access($gid, 'allowuserdelete') && $uid == $post['uid'] || forum_access_mod($post['fid'], $gid, 'allowdelete');
$post['user_url'] = url('user-' . $post['uid'] . ($post['uid'] ? '' : '-' . $post['pid']));
if ($post['files'] > 0) {
list($attachlist, $imagelist, $filelist) = well_attach_find_by_pid($post['pid']);
// 使用图床 评论使用图床，mysql会过多，写死链接到内容是减轻mysql的过多的方法
if (2 == $conf['attach_on']) {
foreach ($imagelist as $key => $attach) {
$url = $conf['upload_url'] . 'website_attach/' . $attach['filename'];
// 替换成图床
$post['message'] = FALSE !== strpos($post['message'], $url) && $attach['image_url'] ? str_replace($url, $attach['image_url'], $post['message']) : $post['message'];
}
}
$post['filelist'] = $filelist;
} else {
$post['filelist'] = array();
}
$post['classname'] = 'post';
}
function comment_format_message(&$val)
{
global $conf;
if (empty($val)) return;
// 使用云储存
if (1 == $conf['attach_on'] && 1 == $val['attach_on']) {
$val['message'] = str_replace('="upload/', '="' . file_path($val['attach_on']), $val['message']);
} elseif (2 == $conf['attach_on'] && 2 == $val['attach_on']) {
// 使用图床
list($attachlist, $imagelist, $filelist) = well_attach_find_by_tid($val['tid']);
foreach ($imagelist as $key => $attach) {
$url = $conf['upload_url'] . 'website_attach/' . $attach['filename'];
// 替换成图床
$val['message'] = FALSE !== strpos($val['message'], $url) && $attach['image_url'] ? str_replace($url, $attach['image_url'], $val['message']) : $val['message'];
}
} else {
$val['message'] = str_replace('="upload/', '="' . file_path($val['attach_on']), $val['message']);
}
//$val['message'] = stripslashes(htmlspecialchars_decode($val['message']));
}
// 把内容中使用了云储存的附件链接替换掉
function comment_message_replace_url($pid, $message)
{
global $conf;
if (0 == $conf['attach_on']) {
$message = FALSE !== strpos($message, '="../upload/') ? str_replace('="../upload/', '="upload/', $message) : $message;
$message = FALSE !== strpos($message, '="/upload/') ? str_replace('="/upload/', '="upload/', $message) : $message;
} elseif (1 == $conf['attach_on']) {
// 使用云储存
$message = str_replace('="' . $conf['cloud_url'] . 'upload/', '="upload/', $message);
} elseif (2 == $conf['attach_on']) {
// 使用图床 评论使用图床，mysql会过多，写死链接到内容是减轻mysql的过多的方法
list($attachlist, $imagelist, $filelist) = well_attach_find_by_pid($pid);
foreach ($imagelist as $key => $attach) {
$url = $conf['upload_url'] . 'website_attach/' . $attach['filename'];
// 替换回相对链接
$message = $attach['image_url'] && FALSE !== strpos($message, $attach['image_url']) ? str_replace($attach['image_url'], $url, $message) : $message;
}
}
return $message;
}
function comment_filter($val)
{
unset($val['userip']);
return $val;
}
function comment_highlight_keyword($str, $k)
{
$r = str_ireplace($k, '' . $k . '', $str);
return $r;
}
// 
//
function comment_message_format(&$s)
{
if (xn_strlen($s) < 100) return;
$s = preg_replace('#.*?
#is', '', $s);
$s = str_ireplace(array('
', '
', '
', '', '', '', '', '' . ''), "\r\n", $s);
$s = str_ireplace(array(' '), " ", $s);
$s = strip_tags($s);
$s = preg_replace('#[\r\n]+#', "\n", $s);
$s = xn_substr(trim($s), 0, 100);
$s = str_replace("\n", '
', $s);
}
// 对内容进行引用
function comment_quote($quotepid)
{
$quotepost = comment_read($quotepid);
if (empty($quotepost)) return '';
$uid = $quotepost['uid'];
$s = $quotepost['message'];
$s = comment_brief($s, 100);
$userhref = url('user-' . $uid);
$user = user_read_cache($uid);
$r = '
' . $user['username'] . '
' . $s . '
';
return $r;
}
// 获取内容的简介 0: html, 1: txt; 2: markdown; 3: ubb
function comment_brief($s, $len = 100)
{
$s = strip_tags($s);
$s = htmlspecialchars($s);
$more = xn_strlen($s) > $len ? ' ... ' : '';
$s = xn_substr($s, 0, $len) . $more;
return $s;
}
?>
热噪声功率谱密度的疑惑-Linux大棚
热噪声功率谱密度的疑惑
热噪声功率-174dBm/Hz=-114dBm/MHz为什么？是因为-174dBm/Hz为单位赫兹内的噪声谱功率，而-114dBm/MHz是单位MHz的噪声谱功率，即-174dBm+10log（10×6）Hz=-114dBm/MHz。以上为个人解释，如有不妥之处，还请各位同行指出。
本文标签：
热噪声功率谱密度的疑惑
最新文章
admin 管理员组
发表评论