www.gusucode.com > ShopEx481 & PHPWind 整合版码程序 > bbs/admin/draftset.php
<?php !function_exists('adminmsg') && exit('Forbidden'); $basename="$admin_file?adminjob=draftset"; if(!$action){ InitGP(array('page','uid','username','keyword')); $sqladd = 'WHERE 1'; if(is_numeric($uid)){ $sqladd .= " AND uid='$uid'"; } elseif($username){ @extract($db->get_one("SELECT uid FROM pw_members WHERE username='$username'")); $sqladd .= " AND uid='$uid'"; } if($keyword){ $sqladd .= " AND content LIKE '%$keyword%'"; } require_once(R_P.'require/forum.php'); $db_perpage = 15; (!is_numeric($page) || $page < 1) && $page = 1; $limit = "LIMIT ".($page-1)*$db_perpage.",$db_perpage"; $rt = $db->get_one("SELECT COUNT(*) AS n FROM pw_draft $sqladd"); $pages = numofpage($rt['n'],$page,ceil($rt['n']/$db_perpage),"$basename&uid=$uid&keyword=".rawurlencode($keyword)."&"); $draft = array(); $query = $db->query("SELECT d.*,m.username FROM pw_draft d LEFT JOIN pw_members m USING(uid) $sqladd $limit"); while($rt = $db->fetch_array($query)){ $draft[] = $rt; } include PrintEot('draftset');exit; } elseif($action=='del'){ if(!$_POST['step']){ include PrintEot('draftset');exit; } else{ InitGP(array('username','keyword','num','clear')); if($clear){ $db->query("TRUNCATE TABLE pw_draft"); } else{ $num<1 && $num = 200; $sql = ''; if($username){ $rt = $db->get_one("SELECT uid FROM pw_members WHERE username='$username'"); if(!$rt){ $errorname = Char_cv($username); adminmsg('user_not_exists'); } $sql .= " AND uid='$rt[uid]'"; } if($keyword){ $sql .= " AND content LIKE '%$keyword%'"; } $db->update("DELETE FROM pw_draft WHERE 1 $sql LIMIT $num"); } adminmsg('operate_success'); } } elseif($_POST['action']=='draft'){ InitGP(array('selid')); if(!$selid = checkselid($selid)){ adminmsg('operate_error'); } $db->update("DELETE FROM pw_draft WHERE did IN($selid)"); adminmsg("operate_success"); } ?>