www.gusucode.com > ShopEx481 & PHPWind 整合版码程序 > bbs/admin/viewban.php
<?php !function_exists('adminmsg') && exit('Forbidden'); $basename="$admin_file?adminjob=viewban"; if(empty($action)){ InitGP(array('page','banuser','bantype','adminban','starttime','endtime')); include_once(R_P.'require/forum.php'); (!is_numeric($page) || $page < 1) && $page = 1; $limit = "LIMIT ".($page-1)*$db_perpage.",$db_perpage"; $sql = "WHERE 1"; $url = $basename; $count = 0; if($banuser){ $sql .= " AND m.username='$banuser'"; $count = 1; } if($bantype){ $sql .= " AND b.type='$bantype'"; $url .= "&bantype=$bantype"; } if($adminban){ $sql .= " AND b.admin='$adminban'"; $url .= "&adminban=".rawurlencode($adminban); } if($starttime){ !is_numeric($starttime) && $starttime = PwStrtoTime($starttime); $sql .= " AND b.startdate>'$starttime'"; $url .= "&starttime=$starttime"; } if($endtime){ !is_numeric($endtime) && $endtime = PwStrtoTime($endtime); $sql .= " AND b.startdate<'$endtime'"; $url .= "&endtime=$endtime"; } if($count<1){ @extract($db->get_one("SELECT COUNT(*) AS count FROM pw_banuser b $sql")); } $pages = numofpage($rt['sum'],$page,ceil($count/$db_perpage),"$url&"); $bandb = array(); $query = $db->query("SELECT b.*, m.username FROM pw_banuser b LEFT JOIN pw_members m ON b.uid=m.uid $sql $limit"); while($rt=$db->fetch_array($query)){ if($rt['type']==1 && $timestamp-$rt['startdate']>$rt['days']*86400){ $db->update("DELETE FROM pw_banuser WHERE uid='$rt[uid]'"); $db->update("UPDATE pw_members SET groupid='-1' WHERE uid='$rt[uid]'"); } else{ $rt['startdate'] && $rt['date'] = get_date($rt['startdate']); $bandb[] = $rt; } } include PrintEot('viewban');exit; } elseif($_POST['action']=='freeban'){ InitGP(array('free'),'P'); !$free && adminmsg('operate_error'); $uids="'".implode("','",$free)."'"; $db->update("UPDATE pw_members SET groupid='-1' WHERE uid IN($uids)"); $db->update("DELETE FROM pw_banuser WHERE uid IN($uids)"); adminmsg('operate_success'); } ?>