www和@都挂静态网站不要有交互,网站全部用二级搭建
<?php
/**
* Template name: XY-用户封禁
* Description: block page
*/
get_header();
global $wpdb;
$total = $wpdb->get_var( "SELECT COUNT(`meta_value`) FROM $wpdb->usermeta WHERE meta_key='banned' AND meta_value !='0'" );
function block_banned(){
global $wpdb;
//获取分页数据 :每页显示的数量 默认为50
$limit = 20;
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
//计算每一页第一条记录的显示偏移量
//偏移量 = (页码 -1) \* 每页的显示数量
$offset = ( $paged - 1 ) * $limit;
$total = $wpdb->get_var( "SELECT COUNT(`meta_value`) FROM $wpdb->usermeta WHERE meta_key='banned' AND meta_value !='0'" );
$pages = ceil( $total / $limit );
//调用
$banned = $wpdb->get_results("SELECT meta_value,user_id,meta_key FROM {$wpdb->usermeta} WHERE meta_key='banned' AND meta_value !='0' ORDER BY user_id DESC LIMIT $limit OFFSET {$offset}");
$html = '
<div class="zib-widget">
<div class="xypro_describe">
<div class="xypro_describe_title">
封禁列表('.$total.'名成员)
</div>
<div id="xy_hide" class="xypro_describe_content xy_height_hide">
<table class="yq">
<thead>
<tr>
<th align="center" width="5%"><strong>用户名</strong></th>
<th align="center" width="5%"><strong>封禁时间</strong></th>
<th align="center" width="5%"><strong>封禁类型</strong></th>
<th align="center" width="5%"><strong>封禁时长</strong></th>
<th align="center" width="5%"><strong>封禁原因</strong></th>
<th align="center" width="5%"><strong>备注</strong></th>
</tr>
</thead>';
$html .= ' <tbody class="link-list">';
foreach ($banned as $k => $v){
$is_ban = zib_get_user_ban_info($v->user_id);
$name = zib_get_user_name_link($v->user_id);
$time = strtotime($is_ban['banned_time']) - strtotime($is_ban['time']);
$time = $time / 86400 .'天';
$no_appeal = !empty($is_ban['no_appeal']); //禁止申诉 不能申诉
if($no_appeal){
$no_appeal = '(不可申诉)';
}else{
$no_appeal = '(可申诉)';
}
$html .= '<tr class="yq_link">
<td>'.$name.'</td>
<td>'.$is_ban['time'].'</td>
<td>'.(2 == $is_ban['type'] ? '禁封中' : '小黑屋') .'</td>
<td>'.($is_ban['banned_time'] ? $time : '永久') .'<span style="color:var(--theme-color);">'.$no_appeal.'</span></td>
<td>'.$is_ban['reason'] .'</td>
<td>'.$is_ban['desc'].'</td>
</tr>';
}
$html .= '</tbody></table>';
$html .= $banned ? xy2_pages($pages,$paged) : '<div class="text-center ajax-item "><img style="width:280px;opacity: .7;border: none;" src="https://oss.zibll.com/zibll.com/zibll-img/img/thumbnail.svg" data-src="'.ZIB_TEMPLATE_DIRECTORY_URI.'/img/null.svg"><p class="em09 muted-3-color separator">暂无封禁用户</p></div>';
$html .= '</div></div></div>';
return $html;
}
/**
* 数字分页函数
* 因为wordpress默认仅仅提供简单分页
* 所以要实现数字分页,需要自定义函数
*/
function xy2_pages($max_page,$paged) {
$html = '';
$html.= '<style>
.pagination{margin:0;text-align:center;font-size:12px;display:block;border-radius:0}
.excerpts .pagination{margin-bottom: 10px;}
.pagination ul{display:inline-block !important;margin-left:0;margin-bottom:0;padding:0}
.pagination ul > li{display:inline}
.pagination ul > li > a,.pagination ul > li > span{margin:0 2px;padding:8px 12px;background-color:#ddd;color:#666;border-radius:2px;opacity:.88}
.pagination ul > li > a:hover,.pagination ul > li > a:focus{opacity:1}
.pagination ul > .active > a,.pagination ul > .active > span{background-color:#000;color:#fff}
.pagination ul > .active > a,.pagination ul > .active > span{cursor:default}
.pagination ul > li > span,.pagination ul > .disabled > span,.pagination ul > .disabled > a,.pagination ul > .disabled > a:hover,.pagination ul > .disabled > a:focus{color:#999999;background-color:transparent;cursor:default}
</style>';
$p = 2;
if ( $max_page == 1 ) {
return;
}
$html.= '<span class="pagination"><ul>';
$paged = !empty( $paged ) ? $paged : 1;
if ( $paged > 1 ) {
$html.= '<li><a href="'.esc_html( get_pagenum_link( 1 ) ).'">首页</a></li>';
}
$html.= '<li class="prev-page">';
$html.= '</li>';
for ( $i = $paged - $p; $i <= $paged + $p; $i++ ) {
if ( $i > 0 && $i <= $max_page ) {
if($i == $paged){
$html.= "<li class=\"active\"><span>{$i}</span></li>";
}else{
$html.= '<li><a href="'.esc_html( get_pagenum_link( $i ) ).'">'. $i .'</a></li>';
}
}
}
$html.= '<li class="next-page">';
$html.= '</li>';
$html.= '<li><a href="'.esc_html( get_pagenum_link( $max_page ) ).'">尾页</a></li>';
//$html.= '<li><span>共 '.$max_page.' 页</span></li>';
$html.= '</ul></span>';
return $html;
}
?>
<style>
.wp-posts-content p{margin: 0 0 10px;}
.xypro_describe {position: relative;border: 1px dashed #dcdfe6;line-height: 26px;margin-top: 10px;}
.xypro_describe_title {position: absolute;top: 0;left: 8px;-webkit-transform: translateY(-50%);transform: translateY(-50%);background:var(--main-bg-color);padding: 0 5px;font-weight: 500;max-width: 200px;white-space: nowrap;overflow: hidden;text-overflow: ellipsis;}
.xypro_describe_content{color: #606266;padding: 18px 15px 0;width: 100%;text-overflow: ellipsis;white-space: nowrap;overflow: hidden;overflow-x: scroll;}
.yq{max-width: 100%;table-layout: fixed;color: #909399;margin-bottom: 18px;border-top: 1px solid #ebeef5;border-left: 1px solid #ebeef5;}
#xy_hide::-webkit-scrollbar {
display: none;
}
.yq thead th {font-weight: 500;background: #ebeef5;text-align: center;padding: 8px;border-bottom: 1px solid #ebeef5;border-right: 1px solid #ebeef5;}
.yq_link td {text-align: center;padding: 8px;border-bottom: 1px solid #ebeef5;border-right: 1px solid #ebeef5;text-overflow: ellipsis;
white-space: nowrap;overflow: hidden;}
@media screen and (max-width: 700px){
.yq{width: 600px !important;}
}
</style>
<main class="container">
<div class="content-wrap">
<div class="content-layout xy-article">
<div class="nopw-sm box-body theme-box radius8 main-bg main-shadow">
<article class="article wp-posts-content">
<div class="wp-block-zibllblock-quote">
<div class="quote_q" data-color="#fb2121" style="--quote-color:#fb2121">
<i class="fa fa-quote-left"></i>
<p>本网站严禁发布违法违规以及发布毫无意义的评论等内容,如有违反,封禁处理,以下是本站封禁用户列表,请大家珍惜自己的账户!</p>
</div>
</div>
<div style="padding: 0 20px;margin-bottom: 20px;">
<p><strong>封禁类型说明:</strong></p>
<p>1.小黑屋:用户拉入小黑屋后,用户将失去所有的发布权限及大部分的操作权限,例如发帖、评论、下载等;</p>
<p>2.封号:禁封的用户将不能登录,将失去全部权限;</p>
<p class="mb10-sm" style="color:#fb2121;">累计封禁用户:<?php echo $total ? $total : 0;?>个 数据截止日期:<?php echo date("Y-m-d", time()+8*60*60);?></p>
</div>
<?php echo block_banned();?>
<div style="text-align:center;color:var(--theme-color);">
- - - 善语结善缘,恶语伤人心 - - -
</div>
</div>
</article>
</div>
</div>
</div>
</main>
<?php
get_footer()
把上面代码命名为block_banned.php上传到pages文件夹内,然后在打开主题根目录的functions.php,在引入
if (file_exists(get_theme_file_path('/xy_block.php'))) {
require_once get_theme_file_path('/xy_block.php');
}
































