} elseif (!empty(${'u_ccids' . $coid})) { $ccids = ${'u_ccids' . $coid}; } if (!empty($ccids)) { if ($cnsql = cnsql($coid, $ccids, 'a.')) { $wheresql .= " AND {$cnsql}"; } } elseif (!empty(${"ccid{$coid}"}) || !empty(${'u_ccids' . $coid})) { $no_list = true; } ${"ccid{$coid}"} && ($filterstr .= "&ccid{$coid}=" . ${"ccid{$coid}"}); } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'arcsedit', "?entry=archives&action={$action}&page={$page}{$param_suffix}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //模型搜索 if (empty($u_filters) || in_array('channel', $u_filters)) { $chidsarr = array('0' => lang('all_channel')) + chidsarr(); echo "<select style=\"vertical-align: middle;\" name=\"chid\">" . makeoption($chidsarr, $chid) . "</select> "; } $statusarr = array('-1' => lang('nolimit'), '0' => lang('update_need'), '1' => lang('checkneed'), '2' => lang('overupdate')); echo "<select style=\"vertical-align: middle;\" name=\"status\">" . makeoption($statusarr, $status) . "</select> "; echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">" . viewcheck('viewdetail', $viewdetail, $actionid . 'tbodyfilter'); echo "</td></tr>"; //某些固定页面参数
foreach (array('keyword', 'viewdetail', 'caid', 'mainline', 'cnlevel', 'inconfig') as $k) { $filterstr .= "&{$k}=" . urlencode(${$k}); } foreach ($cotypes as $coid => $cotype) { if ($cotype['sortable']) { ${"ccid{$coid}"} = isset(${"ccid{$coid}"}) ? ${"ccid{$coid}"} : 0; if (!empty(${"ccid{$coid}"})) { $filterstr .= "&ccid{$coid}=" . ${"ccid{$coid}"}; $wheresql .= " AND ename REGEXP 'ccid{$coid}=" . ${"ccid{$coid}"} . "(&|\$)'"; } } } $wheresql = $wheresql ? "WHERE " . $wheresql : ""; if (!submitcheck('bcnodescommon')) { url_nav(lang('cnodeadmin'), $urlsarr, 'cnodescommon'); echo form_str('cnodescommon', "?entry={$entry}&action={$action}{$param_suffix}&page={$page}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; echo "<select name=\"caid\">" . makeoption(array('0' => lang('catalog_attr')) + caidsarr($catalogs), $caid) . "</select> "; echo "<select name=\"cnlevel\">" . makeoption(array('0' => lang('cnodelevelnum'), '1' => lang('acrossleve1'), '2' => lang('acrossleve2'), '3' => lang('acrossleve3'), '4' => lang('acrossleve4')), $cnlevel) . "</select> "; echo strbutton('bfilter', 'filter0') . viewcheck('viewdetail', $viewdetail, 'tbodyfilter'); echo "</td></tr>"; echo "<tbody id=\"tbodyfilter\" style=\"display: " . (empty($viewdetail) ? 'none' : '') . "\">"; $mainlinearr = array('-1' => lang('nolimit'), '0' => lang('catalog')); foreach ($cotypes as $k => $v) { if ($v['sortable']) { $mainlinearr[$k] = $v['cname']; } }
${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('checked', 'valid') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } //处理ucotype的筛选 foreach ($ucotypes as $k => $v) { if (!empty(${'uccid' . $k}) && $v['cclass'] == 'offer') { $filterstr .= "&uccid{$k}=" . ${'uccid' . $k}; $wheresql .= " AND cu.uccid{$k}='" . ${'uccid' . $k} . "'"; } } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($action . 'archivesedit', "?action=offers&nmuid={$nmuid}&page={$page}"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //审核状态 if (in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('nolimit') . lang('check'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } //有效状态 if (in_array('valid', $u_filters)) { $validarr = array('-1' => lang('nolimit') . lang('available'), '0' => lang('invalid'), '1' => lang('available')); echo "<select style=\"vertical-align: middle;\" name=\"valid\">" . makeoption($validarr, $valid) . "</select> "; } //栏目搜索 if (in_array('catalog', $u_filters)) {
if (empty($u_tplname) || !empty($u_onlyview)) { $page = !empty($page) ? max(1, intval($page)) : 1; submitcheck('bfilter') && ($page = 1); $keyword = empty($keyword) ? '' : $keyword; $wheresql = "a.aid='{$aid}'"; $fromsql = "FROM {$tblprefix}reports cu LEFT JOIN {$tblprefix}archives a ON a.aid=cu.aid"; //搜索关键词处理 $keyword && ($wheresql .= " AND (cu.mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $filterstr = ''; foreach (array('niuid', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'arcsedit', "?entry=inarchive&action=reports&aid={$aid}&page={$page}{$param_suffix}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">"; echo "</td></tr>"; //某些固定页面参数 trhidden('niuid', $niuid); tabfooter(); //列表区 tabheader($aedit->archive['subject'] . ' ' . lang('report_list'), '', '', 9); $cy_arr = array("<input class=\"checkbox\" type=\"checkbox\" name=\"chkall\" onclick=\"checkall(this.form, 'selectid', 'chkall')\">", lang('title')); if (in_array('mname', $u_lists)) { $cy_arr[] = lang('member');
// $outdays && $wheresql .= ($wheresql ? ' AND ' : '')."regdate<'".($timestamp - 86400 * $outdays)."'"; $filterstr = ''; $keyword && ($filterstr .= "&keyword=" . rawurlencode(stripslashes($keyword))); // foreach($grouptypes as $gtid => $grouptype){ // ${"ugid$gtid"} = empty(${"ugid$gtid"}) ? 0 : ${"ugid$gtid"}; // if(${"ugid$gtid"}){ // $filterstr .= "&ugid$gtid=".${"ugid$gtid"}; // if(!empty(${"u_ugids$k"}) && !in_array(${"ugid$gtid"},${"u_ugids$k"})) $no_list = 1; // $wheresql .= ($wheresql ? ' AND ' : '')."grouptype$gtid='".${"ugid$gtid"}."'"; // }elseif(!empty(${"u_ugids$k"})) $wheresql .= ($wheresql ? ' AND ' : '')."grouptype$gtid ".multi_str(${"ugid$gtid"}); // } $wheresql = empty($no_list) ? $wheresql ? "WHERE {$wheresql}" : '' : 'WHERE 1=0'; //echo $wheresql; if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'memberedit', "?entry={$entry}&action={$action}&page={$page}"); //搜索区块 tabheader_e(); // trhidden('mchid',$mchid); // trhidden('nauid',$nauid); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //类系筛选 // foreach($grouptypes as $gtid => $grouptype){ // if(in_array("ugid$gtid",$u_filters)){ // $ugidsarr = array('0' => $grouptype['cname']) + ugidsarr($gtid); // echo "<select style=\"vertical-align: middle;\" name=\"ugid$gtid\">".makeoption($ugidsarr,${"ugid$gtid"})."</select> "; // } // } echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">";
${"ugid{$k}"} = empty(${"ugid{$k}"}) ? 0 : ${"ugid{$k}"}; if (${"ugid{$k}"}) { $filterstr .= "&ugid{$k}=" . ${"ugid{$k}"}; if (!empty(${"u_ugids{$k}"}) && !in_array(${"ugid{$k}"}, ${"u_ugids{$k}"})) { $no_list = 1; } $wheresql .= ($wheresql ? ' AND ' : '') . "grouptype{$k}='" . ${"ugid{$k}"} . "'"; } elseif (!empty(${"u_ugids{$k}"})) { $wheresql .= ($wheresql ? ' AND ' : '') . "grouptype{$k} " . multi_str(${"u_ugids{$k}"}); } } $wheresql = empty($no_list) ? $wheresql ? "WHERE {$wheresql}" : '' : 'WHERE 1=0'; //echo $wheresql; if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'memberedit', "?entry=members&action=membersedit&page={$page}"); //搜索区块 tabheader_e(); trhidden('mchid', $mchid); trhidden('nauid', $nauid); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //审核状态 if (empty($u_filters) || in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('check_state'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } //类系筛选 foreach ($grouptypes as $gtid => $grouptype) { if (in_array("ugid{$gtid}", $u_filters)) {
} elseif ($u_checked != -1) { $wheresql .= " AND cu.checked='{$u_checked}'"; } //搜索关键词处理 $keyword && ($wheresql .= " AND (cu.mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $filterstr = ''; foreach (array('nimuid', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('checked') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($action . 'arcsedit', "?action=inreplys&aid={$aid}&page={$page}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; if (empty($u_filters) || in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('nolimit') . lang('check'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } echo strbutton('bfilter', 'filter0') . '</td></tr>'; trhidden('nimuid', $nimuid); tabfooter(); //列表区 tabheader(empty($u_mtitle) ? lang('replylist') : $u_mtitle, '', '', 9); $cy_arr = array("<input class=\"checkbox\" type=\"checkbox\" name=\"chkall\" onclick=\"checkall(this.form, 'selectid', 'chkall')\">", array(lang('title'), 'item2'), lang('member')); foreach ($ucotypes as $k => $v) { if (in_array('uccid' . $k, $u_lists) && $v['cclass'] == 'reply') {
!defined('M_COM') && exit('No Permission'); include_once M_ROOT . "./include/arcedit.cls.php"; load_cache('acatalogs,channels,currencys'); $catalogs =& $acatalogs; $forward = empty($forward) ? M_REFERER : $forward; $page = !empty($page) ? max(1, intval($page)) : 1; submitcheck('bfilter') && ($page = 1); $keyword = empty($keyword) ? '' : $keyword; $filterstr = ''; foreach (array('keyword') as $k) { $filterstr .= "&{$k}=" . rawurlencode(${$k}); } $wheresql = "WHERE f.mid='{$memberid}'"; $keyword && ($wheresql .= " AND a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%'"); if (!submitcheck('barcsedit')) { echo form_str($action . 'arcsedit', "?action=favorites"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" style=\"vertical-align: middle;\"> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT f.*,a.* FROM {$tblprefix}favorites f LEFT JOIN {$tblprefix}archives a ON a.aid=f.aid {$wheresql} ORDER BY f.aid DESC LIMIT " . ($pagetmp - 1) * $mrowpp . ",{$mrowpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $itemstr = ''; while ($item = $db->fetch_array($query)) { $aid = $item['aid']; $item['arcurl'] = view_arcurl($item); $castr = empty($catalogs[$item['caid']]) ? lang('nocata') : $catalogs[$item['caid']]['title'];
} if (!empty($aids)) { $aidsarr = array_filter(explode(',', $aids)); $wheresql .= " AND aid " . multi_str($aidsarr); } $table != -1 && ($wheresql .= ($wheresql ? " AND " : "") . "tid='{$table}'"); $filterstr = ''; foreach (array('aids', 'type', 'table') as $k) { $filterstr .= "&{$k}=" . urlencode(${$k}); } if (!submitcheck('buserfilesedit')) { //同include/upload.cls.php中closure函数的$tids变量对应 $tabsarr = array('-1' => lang('alltype'), 1 => lang('archive'), 2 => lang('freeinfo'), 3 => lang('member'), 4 => lang('marchive'), 16 => lang('comment'), 17 => lang('reply'), 18 => lang('offer'), 32 => lang('mcomment'), 33 => lang('mreply'), '0' => lang('other')); $linkarr = array(1 => 'archive&aid=', 2 => 'farchive&aid=', 3 => 'memberinfo&mid=', 4 => 'marchive&maid=', 16 => 'comment&cid=', 17 => 'reply&cid=', 18 => 'offer&cid=', 32 => 'mcomment&cid=', 33 => 'mreply&cid='); $typearr = array('0' => lang('alltype'), 'image' => lang('image'), 'flash' => lang('flash'), 'media' => lang('media'), 'file' => lang('other')); echo form_str($action . 'arcsedit', "?action=userfiles"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('aidstxt') . " <input class=\"text\" name=\"aids\" type=\"text\" value=\"{$aids}\" style=\"vertical-align: middle;\"> "; echo "<select style=\"vertical-align: middle;\" name=\"type\">" . makeoption($typearr, $type) . "</select> "; echo "<select style=\"vertical-align: middle;\" name=\"table\">" . makeoption($tabsarr, $table) . "</select> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}userfiles {$wheresql} ORDER BY ufid DESC LIMIT " . ($pagetmp - 1) * $mrowpp . ",{$mrowpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $itemstr = ''; while ($item = $db->fetch_array($query)) { $item['createdate'] = date("{$dateformat}", $item['createdate']);
function tabheader($tname = '', $fname = '', $furl = '', $col = 2, $fupload = 0, $checksubmit = 0, $newwin = 0) { $_mc = defined('M_MCENTER') ? 1 : 0; $tablestr = ''; if ($fname) { $tablestr .= form_str($fname, $furl, $fupload, $checksubmit, $newwin); } if ($_mc) { $tablestr .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"1\" class=\"tabmain\">\n"; $tablestr .= "<tr class=\"header\"><td colspan=\"{$col}\"><b>{$tname}</b></td></tr>\n"; } else { $tablestr .= "<div class=\"conlist1\">{$tname}</div>"; $tablestr .= "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\" tb tb2 bdbot\">\n"; } echo $tablestr; }
$ucidsarr[$k] = $v['title']; } } if (empty($deal)) { $filterstr = ''; foreach (array('keyword') as $k) { isset(${$k}) || (${$k} = ''); $filterstr .= "&{$k}=" . urlencode(${$k}); } $fromsql = "FROM {$tblprefix}mflinks"; $wheresql = "WHERE mid='{$memberid}' AND checked='0'"; if ($keyword) { $wheresql .= " AND fromname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%'"; } if (!submitcheck('bflinksedit')) { echo form_str($action . 'flinksedit', "?action={$action}&page={$page}"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" style=\"vertical-align: middle;\"> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * {$fromsql} {$wheresql} ORDER BY cid DESC LIMIT " . ($pagetmp - 1) * $mrowpp . ",{$mrowpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $itemstr = ''; while ($item = $db->fetch_array($query)) { $createdatestr = date("{$dateformat}", $item['createdate']); $itemstr .= "<tr><td class=\"item\" width=\"30\"><input class=\"checkbox\" type=\"checkbox\" name=\"selectid[{$item['cid']}]\" value=\"{$item['cid']}\"></td>\n" . "<td class=\"item\" width=\"30\">{$item['mid']}</td>\n" . "<td class=\"item2\"><a href=\"{$mspaceurl}index.php?mid={$item['mid']}\" target=\"_blank\">{$item['mname']}</a></td>\n" . "<td class=\"item\" width=\"60\">{$createdatestr}</td>\n" . "<td class=\"item\" width=\"60\"><a href=\"?action=mflink&mid={$item['mid']}&cid={$item['cid']}\">" . lang('look') . "</a> <a href=\"?action={$action}&deal=delete&cid={$item['cid']}\">" . lang('delete') . "</a></td></tr>\n"; }
} elseif ($u_checked != -1) { $wheresql .= " AND cu.checked='{$u_checked}'"; } //搜索关键词处理 $keyword && ($wheresql .= " AND (cu.mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $filterstr = ''; foreach (array('nimuid', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('checked') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($action . 'arcsedit', "?action=inanswers&aid={$aid}&page={$page}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; if (empty($u_filters) || in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('nolimit') . lang('adopt'), '0' => lang('noadopt'), '1' => lang('adopted')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } echo strbutton('bfilter', 'filter0') . '</td></tr>'; trhidden('nimuid', $nimuid); tabfooter(); //列表区 tabheader((empty($u_mtitle) ? lang('answerlist') : $u_mtitle) . ' - ' . lang('spare') . ':' . $aedit->archive['spare'] . $currencys[$aedit->archive['crid']]['cname'], '', '', 9); $cy_arr = array(array(lang('questiontitle'), 'item2'), lang('adopt'), lang('award'), lang('awarded')); if (in_array('mname', $u_lists)) { $cy_arr[] = lang('member');
$page = !empty($page) ? max(1, intval($page)) : 1; submitcheck('bfilter') && ($page = 1); $keyword = empty($keyword) ? '' : $keyword; $mcnvar = empty($mcnvar) ? '' : $mcnvar; $wheresql = ''; $fromsql = "FROM {$tblprefix}mcnodes"; $mcnvar && ($wheresql .= ($wheresql ? ' AND ' : '') . "mcnvar='{$mcnvar}'"); $keyword && ($wheresql .= ($wheresql ? ' AND ' : '') . "(ename LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR alias LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $wheresql = $wheresql ? "WHERE {$wheresql}" : ''; $filterstr = ''; foreach (array('mcnvar', 'keyword') as $k) { $filterstr .= "&{$k}=" . urlencode(${$k}); } if (!submitcheck('bmcnodesedit')) { url_nav(lang('mcnodeadmin'), $urlsarr, 'mcnodesedit'); echo form_str($actionid . 'mcnodesedit', "?entry={$entry}&action={$action}&page={$page}{$param_suffix}"); tabheader_e(); echo "<tr><td class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; echo "<select style=\"vertical-align: middle;\" name=\"mcnvar\">" . makeoption(array('' => lang('all') . lang('nodetype')) + $mcnvars, $mcnvar) . "</select> "; echo strbutton('bfilter', 'filter0'); echo "</td></tr>"; tabfooter(); $addstr = " <input class=\"checkbox\" type=\"checkbox\" name=\"select_all\" value=\"1\"> " . lang('selectallpage'); tabheader(lang('mcnode_list') . $addstr, '', '', 12); $cy_arr = array("<input class=\"checkbox\" type=\"checkbox\" name=\"chkall\" onclick=\"checkall(this.form, 'selectid', 'chkall')\">", array(lang('cnode_name'), 'txtL'), array(lang('nodetype') . '-ID', 'txtL'), array(lang('look'), 'txtL')); for ($i = 0; $i <= min($mcn_max_addno, 2); $i++) { $cy_arr[] = $i ? lang('addp') . $i . lang('template') : lang('index_tpl'); } $cy_arr[] = lang('detail'); trcategory($cy_arr);
function showlist() { global $db, $tblprefix, $curuser, $eid, $atpp, $page, $mid, $mname, $checked, $dmode, $date1, $date2; if ($eid) { return $this->isadmin ? $this->check() : ($eid == 'new' ? $this->addnew() : $this->show()); } if (!submitcheck('bextedit')) { if (defined('M_MCENTER')) { $css = array('L' => 'item2', 'R' => 'item right', 'C' => 'item'); $membercname = lang('membercname'); $checkstate = lang('checkstate'); } else { $css = array('L' => 'txtL', 'R' => 'txtR', 'C' => 'txtC'); $membercname = lang('member_cname'); $checkstate = lang('check_state'); } $page = !empty($page) ? max(1, intval($page)) : 1; submitcheck('bfilter') && ($page = 1); if ($this->isadmin) { $wheresql = ' 1=1'; $u_lists = array('mname', 'integral', 'total', 'rate', 'checkdate', 'createdate', 'view'); } else { $wheresql = " mid={$curuser->info['mid']}"; $u_lists = array('integral', 'total', 'rate', 'checkdate', 'createdate', 'view'); } $mname && ($wheresql .= " AND mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($mname, '%_')) . "%'"); isset($checked) || ($checked = '-1'); $checked != '-1' && ($wheresql .= ' AND checkdate' . ($checked ? '!' : '') . '=0'); $datefield = $dmode ? 'checkdate' : 'createdate'; if ($date1 && preg_match("/\\s*(\\d{4})-(\\d{1,2})-(\\d{1,2})(?:\\s+(\\d{1,2}):(\\d{1,2}):(\\d{1,2}))?\\s*\$/", $date1, $match)) { $date = mktime(empty($match[4]) ? 0 : $match[4], empty($match[5]) ? 0 : $match[5], empty($match[6]) ? 0 : $match[6], $match[2], $match[3], $match[1]); $date && $date > 0 && ($wheresql .= " AND {$datefield}>='{$date}'"); } if ($date2 && preg_match("/\\s*(\\d{4})-(\\d{1,2})-(\\d{1,2})(?:\\s+(\\d{1,2}):(\\d{1,2}):(\\d{1,2}))?\\s*\$/", $date2, $match)) { $date = mktime(empty($match[4]) ? 24 : $match[4], empty($match[5]) ? 59 : $match[5], empty($match[6]) ? 59 : $match[6], $match[2], $match[3], $match[1]); $date && $date > 0 && ($wheresql .= " AND {$datefield}<='{$date}'"); } echo form_str('extract_list', "?{$_SERVER['QUERY_STRING']}"); if ($this->isadmin) { //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo $membercname . " <input class=\"text\" name=\"mname\" type=\"text\" value=\"{$mname}\" size=\"8\" style=\"vertical-align: middle;\"> "; $checkarr = array('-1' => lang('nolimit'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkarr, $checked) . "</select> "; $dmodearr = array('0' => lang('needtime'), '1' => lang('checkdate')); echo "<select style=\"vertical-align: middle;\" name=\"dmode\">" . makeoption($dmodearr, $dmode) . "</select> " . "<input class=\"text\" id=\"extract_date1\" name=\"date1\" type=\"text\" value=\"{$date1}\" onclick=\"ShowCalendar(this.id);\" style=\"vertical-align: middle;width:120px\"> - " . "<input class=\"text\" id=\"extract_date2\" name=\"date2\" type=\"text\" value=\"{$date2}\" onclick=\"ShowCalendar(this.id);\" style=\"vertical-align: middle;width:120px\"> " . "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\"> " . "</td></tr>"; tabfooter(); } $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}extracts WHERE {$wheresql} ORDER BY {$datefield} DESC LIMIT " . ($pagetmp - 1) * $atpp . ",{$atpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $count = $db->result_one("SELECT count(*) FROM {$tblprefix}extracts WHERE {$wheresql}"); $view = lang('message'); tabheader(lang('extract_list') . ($this->isadmin ? '' : " [<a href=\"?{$_SERVER['QUERY_STRING']}&eid=new\" onclick=\"return floatwin('open_extractview',this)\">" . lang('submit_extract') . '</a>]'), '', '', count($u_lists) + 1); $cy_arr = array(); $this->isadmin && ($cy_arr[] = '<input class="checkbox" type="checkbox" name="chkall" onclick="checkall(this.form, \'selectid\', \'chkall\')">'); in_array('mname', $u_lists) && ($cy_arr[] = array($membercname, $css['L'])); in_array('integral', $u_lists) && ($cy_arr[] = lang('extract_count')); in_array('total', $u_lists) && ($cy_arr[] = lang('extract_getcount')); in_array('rate', $u_lists) && ($cy_arr[] = lang('extract_discount')); in_array('checkdate', $u_lists) && ($cy_arr[] = lang('checkdate')); in_array('createdate', $u_lists) && ($cy_arr[] = lang('needtime')); # in_array('delstate',$u_lists) && $cy_arr[] = lang('delstate'); in_array('view', $u_lists) && ($cy_arr[] = $view); trcategory($cy_arr); while ($item = $db->fetch_array($query)) { # $checked = $item['checked'] ? 'Y' : '-'; # $delete = $item['delstate'] ? 'Y' : '-'; $checkdate = $item['checkdate'] ? date('Y-m-d', $item['checkdate']) : '-'; $createdate = date('Y-m-d', $item['createdate']); $itemstr = '<tr class="txt">'; $this->isadmin && ($itemstr .= "<td class=\"{$css['C']} w40\" ><input class=\"checkbox\" type=\"checkbox\" name=\"selectid[{$item['eid']}]\" value=\"{$item['eid']}\"></td>\n"); in_array('mname', $u_lists) && ($itemstr .= "<td class=\"{$css['L']}\">{$item['mname']}</td>\n"); in_array('integral', $u_lists) && ($itemstr .= "<td class=\"{$css['C']}\">{$item['integral']}</td>\n"); in_array('total', $u_lists) && ($itemstr .= "<td class=\"{$css['C']}\">{$item['total']}</td>\n"); in_array('rate', $u_lists) && ($itemstr .= "<td class=\"{$css['C']}\">{$item['rate']}%</td>\n"); in_array('checkdate', $u_lists) && ($itemstr .= "<td class=\"{$css['C']}\">{$checkdate}</td>\n"); in_array('createdate', $u_lists) && ($itemstr .= "<td class=\"{$css['C']}\">{$createdate}</td>\n"); # in_array('delstate',$u_lists) && $itemstr .= "<td class=\"$css[C]\">$delete</td>\n"; in_array('view', $u_lists) && ($itemstr .= "<td class=\"{$css['C']}\"><a href=\"?{$_SERVER['QUERY_STRING']}&eid={$item['eid']}\" onclick=\"return floatwin('open_extractview',this)\">{$view}</a></td>\n"); $itemstr .= "</tr>\n"; echo $itemstr; } tabfooter(); echo multi($count, $atpp, $page, preg_replace("/[?&]page=\\d+\$|([?&])page=\\d+&/", '$1', "?{$_SERVER['QUERY_STRING']}")); if ($this->isadmin) { tabheader(lang('operate_item')); trbasic(lang('choose_item'), '', '<input class="checkbox" type="checkbox" name="extdeal[delete]" id="extdeal_delete" value="1"><label for="extdeal_delete" >' . lang('delete') . '</label> <input class="checkbox" type="checkbox" name="extdeal[check]" id="extdeal_check" value="1"><label for="extdeal_check" >' . lang('check') . '</label> ', ''); tabfooter('bextedit'); } } elseif ($this->isadmin) { global $selectid, $extdeal, $timestamp; if (function_exists('mcmessage')) { $message = 'mcmessage'; $empty_item = 'selectoperateitem'; } else { $message = 'amessage'; $empty_item = 'selectoperateitem'; } empty($extdeal) && $message($empty_item, axaction(1, M_REFERER)); empty($selectid) && $message('select_extract', axaction(1, M_REFERER)); $wheresql = $this->isadmin ? '' : " AND mid={$curuser->info['mid']}"; $user = new cls_userinfo(); foreach ($selectid as $eid) { if (!empty($extdeal['delete'])) { if ($row = $db->fetch_one("SELECT mid,integral,checkdate FROM {$tblprefix}extracts WHERE eid='{$eid}'{$wheresql} LIMIT 0,1")) { /* if($this->isadmin){ $sql = $row['delstate'] == 2 || !$row['checked'] ? "DELETE FROM {$tblprefix}extracts" :($row['delstate'] == 0 ? "UPDATE {$tblprefix}extracts SET delstate=1" : ''); }else{ $sql = $row['delstate'] == 1 || !$row['checked'] ? "DELETE FROM {$tblprefix}extracts" :($row['delstate'] == 0 ? "UPDATE {$tblprefix}extracts SET delstate=2" : ''); } $sql && $db->query("$sql WHERE eid='$eid'");*/ if ($row['checkdate'] == 0) { $user->activeuser($row['mid']); $user->updatecrids(array('0' => $row['integral']), 1); } $db->query("DELETE FROM {$tblprefix}extracts WHERE eid='{$eid}'"); } continue; } $this->isadmin && $db->query("UPDATE {$tblprefix}extracts SET checkdate={$timestamp} WHERE checkdate=0 AND eid='{$eid}'"); } $this->isadmin && !empty($extdeal['delete']) && adminlog(lang('extract_admin'), lang('extract_operate')); $message('extract_operate_finish', M_REFERER); } }
$pmode = isset($pmode) && strlen($pmode) ? $pmode : '*'; $keyword = empty($keyword) ? '' : $keyword; $filterstr = ''; foreach (array('state', 'pmode', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(${$k})); } $wheresql = "tomid=0 AND delstate!=1"; $state != '*' && ($wheresql .= " AND state='{$state}'"); $pmode != '*' && ($wheresql .= " AND paymode='{$pmode}'"); if ($keyword) { $keyword = str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')); $wheresql .= " AND (mname LIKE '%" . $keyword . "%' OR ordersn LIKE '%" . $keyword . "%')"; } if (!submitcheck('barcsedit')) { url_nav(lang('goodsorder'), $urlsarr, 'order'); echo form_str($action . 'arcsedit', "?entry=orders&action=ordersedit&page={$page}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" style=\"vertical-align: middle;width:200px\"> "; echo "<select style=\"vertical-align: middle;\" name=\"state\">" . makeoption($statearr, $state) . "</select> "; echo "<select style=\"vertical-align: middle;\" name=\"pmode\">" . makeoption($pmodearr, $pmode) . "</select> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}orders WHERE {$wheresql} ORDER BY oid DESC LIMIT " . ($pagetmp - 1) * $atpp . ",{$atpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $strorder = ''; while ($order = $db->fetch_array($query)) { $oid = $order['oid'];
${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('checked') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } //处理ucotype的筛选 foreach ($ucotypes as $k => $v) { if (!empty(${'uccid' . $k}) && $v['uclass'] == 'comment') { $filterstr .= "&uccid{$k}=" . ${'uccid' . $k}; $wheresql .= " AND cu.uccid{$k}='" . ${'uccid' . $k} . "'"; } } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($action . 'archivesedit', "?action=comments&nmuid={$nmuid}&page={$page}"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //审核状态 if (in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('nolimit') . lang('check'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } //栏目搜索 if (in_array('catalog', $u_filters)) { $caidsarr = array('0' => lang('catalog')) + caidsarr($catalogs); echo "<select style=\"vertical-align: middle;\" name=\"caid\">" . makeoption($caidsarr, $caid) . "</select> "; } foreach ($ucotypes as $k => $v) { //报价类系的搜索
$checked = isset($checked) ? $checked : '-1'; $toid = empty($toid) ? 0 : max(0, intval($toid)); $fromid = empty($fromid) ? 0 : max(0, intval($fromid)); $keyword = empty($keyword) ? '' : $keyword; $wheresql = ''; $checked != '-1' && ($wheresql .= ($wheresql ? " AND " : "") . "checked='{$checked}'"); $toid && ($wheresql .= ($wheresql ? " AND " : "") . "toid='{$toid}'"); $fromid && ($wheresql .= ($wheresql ? " AND " : "") . "fromid='{$fromid}'"); $keyword && ($wheresql .= ($wheresql ? " AND " : "") . "mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%'"); $filterstr = ''; foreach (array('checked', 'toid', 'fromid', 'keyword') as $k) { $filterstr .= "&{$k}=" . urlencode(${$k}); } $wheresql = $wheresql ? "WHERE " . $wheresql : ""; if (!submitcheck('bmtransedit')) { echo form_str($actionid . 'utransedit', "?entry=mtrans&action=mtransedit&page={$page}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; $checkedarr = array('-1' => lang('altchesta'), '0' => lang('nocheckalter'), '1' => lang('checkedalter')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; echo "<select style=\"vertical-align: middle;\" name=\"fromid\">" . makeoption(array(0 => lang('sourcechannel')) + mchidsarr(), $fromid) . "</select> "; echo "<select style=\"vertical-align: middle;\" name=\"toid\">" . makeoption(array(0 => lang('targetchannel')) + mchidsarr(), $toid) . "</select> "; echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">"; echo "</td></tr>"; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}mtrans {$wheresql} ORDER BY trid DESC LIMIT " . ($pagetmp - 1) * $atpp . ",{$atpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp);
if (!empty($aids)) { $aidsarr = array_filter(explode(',', $aids)); $wheresql .= ($wheresql ? " AND " : "") . "aid " . multi_str($aidsarr); } $table != -1 && ($wheresql .= ($wheresql ? " AND " : "") . "tid='{$table}'"); $filterstr = ''; foreach (array('aids', 'type', 'table') as $k) { $filterstr .= "&{$k}=" . urlencode(${$k}); } $wheresql = $wheresql ? "WHERE {$wheresql}" : ""; if (!submitcheck('buserfilesedit')) { //同include/upload.cls.php中closure函数的$tids变量对应 $tabsarr = array('-1' => lang('alltype'), 1 => lang('archive'), 2 => lang('freeinfo'), 3 => lang('member'), 4 => lang('marchive'), 16 => lang('comment'), 17 => lang('reply'), 18 => lang('offer'), 32 => lang('mcomment'), 33 => lang('mreply'), '0' => lang('other')); $linkarr = array(1 => 'archive&action=archivedetail&aid=', 2 => 'farchive&action=farchivedetail&aid=', 3 => 'member&action=memberdetail&mid=', 4 => 'marchives&action=marchivedetail&maid=', 16 => 'comments&action=commentdetail&cid=', 17 => 'replys&action=replydetail&cid=', 18 => 'offers&action=offerdetail&cid=', 32 => 'mcomments&action=mcommentdetail&cid=', 33 => 'mreplys&action=mreplydetail&cid='); $typearr = array('0' => lang('alltype'), 'image' => lang('image'), 'flash' => lang('flash'), 'media' => lang('media'), 'file' => lang('other')); echo form_str($action . 'arcsedit', "?entry={$entry}&action={$action}"); tabheader_e(); echo "<tr><td class=\"txtL\">"; echo lang('aidstxt') . " <input class=\"text\" name=\"aids\" type=\"text\" value=\"{$aids}\" style=\"vertical-align: middle;\"> "; echo "<select style=\"vertical-align: middle;\" name=\"type\">" . makeoption($typearr, $type) . "</select> "; echo "<select style=\"vertical-align: middle;\" name=\"table\">" . makeoption($tabsarr, $table) . "</select> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}userfiles {$wheresql} ORDER BY ufid DESC LIMIT " . ($pagetmp - 1) * $atpp . ",{$atpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $itemstr = ''; while ($item = $db->fetch_array($query)) { $item['createdate'] = date("{$dateformat}", $item['createdate']);
} //搜索关键词处理 $keyword && ($wheresql .= " AND (a.mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $filterstr = ''; foreach (array('nimuid', 'caid', 'chid', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('nsid') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } $wheresql = empty($no_list) ? $wheresql : 'WHERE 1=0'; //echo $wheresql; if (!submitcheck('bloadold')) { if (empty($u_tplname)) { //需要归入的合辑管理区*********************************************************** echo form_str($action . 'albumadmin', "?action=loadold&aid={$aid}&page={$page}{$param_suffix}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"item2\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //模型搜索 if (empty($u_filters) || in_array('channel', $u_filters)) { $chidsarr = array('0' => lang('all_channel')) + chidsarr(1); echo "<select style=\"vertical-align: middle;\" name=\"chid\">" . makeoption($chidsarr, $chid) . "</select> "; } //所在子站搜索 if (empty($u_filters) || in_array('subsite', $u_filters)) { $sidsarr = array('-1' => lang('nolimit') . lang('subsite'), '0' => lang('msite')) + sidsarr(); echo "<select style=\"vertical-align: middle;\" name=\"nsid\">" . makeoption($sidsarr, $nsid) . "</select> "; }
switch ($action) { case '': //审核列表 if (!submitcheck('bmemcertlist')) { $wheresql = ''; if (empty($keyword)) { $keyword = ''; } else { $wheresql = " AND mname like '%{$keyword}%'"; } if (empty($mcid)) { $mcid = ''; } else { $wheresql = " AND mcid='{$mcid}'"; } echo form_str('memcert_list', "?entry={$entry}&action={$action}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //认证类型 $mcids = array('0' => lang('nolimit')); if (!empty($memcerts)) { foreach ($memcerts as $k => $v) { $mcids[$k] = $v['title']; } } echo "<select style=\"vertical-align: middle;\" name=\"mcid\">" . makeoption($mcids, $mcid) . "</select> " . "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">" . "</td></tr>"; tabfooter(); tabheader(lang('memcert_list'));
if ($qstate) { $wheresql .= ($wheresql ? ' AND ' : '') . "qstate='{$qstate}'"; } //搜索关键词处理 $keyword && ($wheresql .= ($wheresql ? ' AND ' : '') . "(mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $wheresql = empty($no_list) ? $wheresql ? "WHERE {$wheresql}" : '' : 'WHERE 1=0'; $filterstr = ''; foreach (array('nauid', 'fcaid', 'qstate', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('checked', 'valid') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'arcsedit', "?entry=farchives&action=farchivesedit&page={$page}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; trhidden('fcaid', $fcaid); trhidden('nauid', $nauid); //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //审核状态 if (empty($u_filters) || in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('check_state'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } //有效状态 if (empty($u_filters) || in_array('valid', $u_filters)) { $validarr = array('-1' => lang('validperiod_state'), '0' => lang('invalid'), '1' => lang('available'));
} elseif (!empty(${'u_ccids' . $coid})) { $ccids = ${'u_ccids' . $coid}; } if (!empty($ccids)) { if ($cnsql = cnsql($coid, $ccids, 'a.')) { $wheresql .= " AND {$cnsql}"; } } elseif (!empty(${"ccid{$coid}"}) || !empty(${'u_ccids' . $coid})) { $no_list = true; } ${"ccid{$coid}"} && ($filterstr .= "&ccid{$coid}=" . ${"ccid{$coid}"}); } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'arcsedit', "{$urlpre}action={$action}&page={$page}{$param_suffix}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //模型搜索 if (empty($u_filters) || in_array('channel', $u_filters)) { $chidsarr = array('0' => lang('all_channel')) + chidsarr(); echo "<select style=\"vertical-align: middle;\" name=\"chid\">" . makeoption($chidsarr, $chid) . "</select> "; } $statusarr = array('-1' => lang('nolimit'), '0' => lang('update_need'), '1' => lang('checkneed'), '2' => lang('overupdate')); echo "<select style=\"vertical-align: middle;\" name=\"status\">" . makeoption($statusarr, $status) . "</select> "; echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">" . viewcheck('viewdetail', $viewdetail, $actionid . 'tbodyfilter'); echo "</td></tr>"; //某些固定页面参数
} else { $wheresql .= " AND cu.cuid='{$cuid}'"; } } elseif (!empty($u_cuids)) { $wheresql .= " AND cu.cuid " . multi_str($u_cuids); } //搜索关键词处理 $keyword && ($wheresql .= " AND (cu.mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $filterstr = ''; foreach (array('nauid', 'viewdetail', 'caid', 'cuid', 'chid', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } $wheresql = "WHERE " . (empty($no_list) ? $wheresql : '1=0'); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'arcsedit', "?entry=reports&action=reportsedit&page={$page}{$param_suffix}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; //合辑类型搜索 if (empty($u_filters) || in_array('commu', $u_filters)) { $cuidsarr = array('0' => lang('all_cuitem')); foreach ($commus as $k => $v) { if ($v['cclass'] == 'report') { $cuidsarr[$k] = $v['cname']; } } echo "<select style=\"vertical-align: middle;\" name=\"cuid\">" . makeoption($cuidsarr, $cuid) . "</select> "; }
} else { $wheresql .= " AND chid={$nchid}"; } } else { $wheresql .= " AND chid " . multi_str($nchids); } if (!$isopen) { if ($memberid) { $wheresql .= " AND mid='{$memberid}'"; } else { $no_list = 1; } } $keyword && ($wheresql .= " AND (mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); $wheresql = empty($no_list) ? $wheresql : 'WHERE 1=0'; echo form_str('choosealbum', "?win_id={$win_id}&field_id={$field_id}&show_id={$show_id}&page={$page}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; $chidsarr = array('0' => lang('all_channel')); foreach ($channels as $k => $v) { if (in_array($k, $nchids)) { $chidsarr[$k] = $v['cname']; } } echo "<select style=\"vertical-align: middle;\" name=\"nchid\">" . makeoption($chidsarr, $nchid) . "</select> "; //某些固定页面参数 trhidden('chid', $chid); trhidden('isopen', $isopen); echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">"; echo "</td></tr></table>";
$state = isset($state) && strlen($state) ? $state : '*'; $pmode = isset($pmode) && strlen($pmode) ? $pmode : '*'; $keyword = empty($keyword) ? '' : $keyword; $filterstr = ''; foreach (array('state', 'pmode', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(${$k})); } $wheresql = "mid={$memberid} AND delstate!=2"; $state != '*' && ($wheresql .= " AND state='{$state}'"); $pmode != '*' && ($wheresql .= " AND paymode='{$pmode}'"); if ($keyword) { $keyword = str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')); $wheresql .= " AND (mname LIKE '%" . $keyword . "%' OR ordersn LIKE '%" . $keyword . "%')"; } if (!submitcheck('barcsedit')) { echo form_str($action . 'arcsedit', "?action=orders"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" style=\"vertical-align: middle;width:200px\"> "; echo "<select style=\"vertical-align: middle;\" name=\"state\">" . makeoption($statearr, $state) . "</select> "; echo "<select style=\"vertical-align: middle;\" name=\"pmode\">" . makeoption($pmodearr, $pmode) . "</select> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}orders WHERE {$wheresql} ORDER BY oid DESC LIMIT " . ($pagetmp - 1) * $mrowpp . ",{$mrowpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $strorder = ''; while ($order = $db->fetch_array($query)) { $oid = $order['oid'];
$viewdetail = empty($viewdetail) ? 0 : $viewdetail; $gathered = isset($gathered) ? $gathered : '-1'; $outputed = isset($outputed) ? $outputed : '-1'; $abover = isset($abover) ? $abover : '-1'; $keyword = empty($keyword) ? '' : $keyword; $filterstr = ''; foreach (array('viewdetail', 'gathered', 'outputed', 'abover', 'keyword') as $k) { $filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k})); } $wheresql = "WHERE gsid='{$gsid}'"; $gathered != '-1' && ($wheresql .= " AND gatherdate" . ($gathered ? '!=' : '=') . "'0'"); $outputed != '-1' && ($wheresql .= " AND outputdate" . ($outputed ? '!=' : '=') . "'0'"); $abover != '-1' && ($wheresql .= " AND abover='{$abover}'"); $keyword && ($wheresql .= " AND utitle LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%'"); if (!submitcheck('barcsedit')) { echo form_str($actionid . 'arcsedit', "?entry=gmissions&action=contentsoption&gsid={$gsid}&use_push=1&page={$page}{$param_suffix}"); tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; $gatheredarr = array('-1' => lang('gather_state'), '0' => lang('no1_gather'), '1' => lang('already1_gather')); echo "<select style=\"vertical-align: middle;\" name=\"gathered\">" . makeoption($gatheredarr, $gathered) . "</select> "; $outputedarr = array('-1' => lang('output_state'), '0' => lang('no1_output'), '1' => lang('already1_output')); echo "<select style=\"vertical-align: middle;\" name=\"outputed\">" . makeoption($outputedarr, $outputed) . "</select> "; $aboverarr = array('-1' => lang('weather_abover_album'), '0' => lang('noabover'), '1' => lang('abover')); echo "<select style=\"vertical-align: middle;\" name=\"abover\">" . makeoption($aboverarr, $abover) . "</select> "; echo strbutton('bfilter', 'filter0'); echo "</td></tr>"; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * FROM {$tblprefix}gurls {$wheresql} ORDER BY guid DESC LIMIT " . ($pagetmp - 1) * $atpp . ",{$atpp}");
<?php !defined('M_COM') && exit('No Permission'); load_cache('channels,acatalogs,currencys'); include_once M_ROOT . "./include/arcedit.cls.php"; $catalogs =& $acatalogs; $page = empty($page) ? 1 : max(1, intval($page)); $keyword = empty($keyword) ? '' : $keyword; $filterstr = ''; foreach (array('keyword') as $k) { $filterstr .= "&{$k}=" . rawurlencode(${$k}); } $wheresql = "WHERE cu.mid={$memberid} AND cu.oid>0"; $keyword && ($wheresql .= " AND a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%'"); echo form_str($action . 'arcsedit', "?action={$action}&page={$page}"); tabheader_e(); echo "<tr><td class=\"item2\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" style=\"vertical-align: middle;\"> "; echo strbutton('bfilter', 'filter0') . '</td></tr>'; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT cu.*,cu.createdate AS ucreatedate,a.sid,a.createdate,a.caid,a.chid,a.customurl,a.subject AS asubject FROM {$tblprefix}purchases cu LEFT JOIN {$tblprefix}archives a ON (a.aid=cu.aid) {$wheresql} ORDER BY cu.cid DESC LIMIT " . ($pagetmp - 1) * $mrowpp . ",{$mrowpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $itemstr = ''; $i = $pagetmp * $mrowpp; while ($item = $db->fetch_array($query)) { $i++; $item['arcurl'] = view_arcurl($item); $item['catalog'] = empty($catalogs[$item['caid']]) ? lang('nocata') : $catalogs[$item['caid']]['title'];
foreach (array('nauid', 'mchid', 'cuid', 'keyword') as $k) { ${$k} && ($filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k}))); } foreach (array('checked') as $k) { ${$k} != -1 && ($filterstr .= "&{$k}=" . ${$k}); } $wheresql = empty($no_list) ? $wheresql ? "WHERE {$wheresql}" : '' : "WHERE 1=0"; if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { $cuidsarr = array(); foreach ($mcommus as $k => $v) { if ($v['cclass'] == 'comment') { $cuidsarr[$k] = $v['cname']; } } echo form_str($action . 'archivesedit', "?entry={$entry}&action={$action}&nauid={$nauid}&page={$page}"); tabheader_e(); echo "<tr><td class=\"txtL\">"; echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; if (in_array('check', $u_filters)) { $checkedarr = array('-1' => lang('nolimit') . lang('check'), '0' => lang('nocheck'), '1' => lang('checked')); echo "<select style=\"vertical-align: middle;\" name=\"checked\">" . makeoption($checkedarr, $checked) . "</select> "; } if (in_array('commu', $u_filters)) { echo "<select style=\"vertical-align: middle;\" name=\"cuid\">" . makeoption(array('0' => lang('commuitem')) + $cuidsarr, $cuid) . "</select> "; } echo strbutton('bfilter', 'filter0') . '</td></tr>'; trhidden('mchid', $mchid); tabfooter(); $pagetmp = $page; do {
$url_type = 'langs'; include 'urlsarr.inc.php'; url_nav(lang('lanpackmanage'), $urlsarr, 'alang'); if ($action == 'alangsedit') { $page = !empty($page) ? max(1, intval($page)) : 1; submitcheck('bfilter') && ($page = 1); $keyword = empty($keyword) ? '' : $keyword; $wheresql = ''; $fromsql = "FROM {$tblprefix}alangs"; $keyword && ($wheresql = "WHERE ename LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR content LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%'"); $filterstr = ''; foreach (array('keyword') as $k) { $filterstr .= "&{$k}=" . rawurlencode(stripslashes(${$k})); } if (!submitcheck('balangsedit')) { echo form_str($actionid . 'arcsedit', "?entry=alangs&action=alangsedit&page={$page}"); tabheader_e(); echo "<tr><td class=\"txt txtleft\">"; echo lang('search_keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"10\"> "; echo strbutton('bfilter', 'filter0'); echo "</td></tr>"; tabfooter(); $pagetmp = $page; do { $query = $db->query("SELECT * {$fromsql} {$wheresql} ORDER BY ename LIMIT " . ($pagetmp - 1) * $atpp . ",{$atpp}"); $pagetmp--; } while (!$db->num_rows($query) && $pagetmp); $itemstr = ''; while ($item = $db->fetch_array($query)) { $itemstr .= "<tr class=\"txt\"><td class=\"txtC w40\"><input class=\"checkbox\" type=\"checkbox\" name=\"delete[{$item['ename']}]\" value=\"{$item['ename']}\">\n" . "<td class=\"txtL\">{$item['ename']}</td>\n" . "<td class=\"txtL\"><input type=\"text\" size=\"80\" name=\"alangsnew[{$item['ename']}][content]\" value=\"" . htmlspecialchars($item['content']) . "\"></td>\n" . "<td class=\"txtC w40\"><a href=\"?entry=alangs&action=alangdetail&ename={$item['ename']}\">" . lang('edit') . "</a></td>\n" . "</tr>\n"; }
} if (!$caids) { $no_list = true; } elseif (!in_array(-1, $caids)) { $wheresql .= " AND a.caid " . multi_str($caids); } if ($appealed != -1) { $wheresql .= " AND s.appeals" . ($appealed ? '!' : '') . "='0'"; } $fromsql = "FROM {$tblprefix}archives a LEFT JOIN {$tblprefix}archives_sub s ON s.aid=a.aid"; //搜索关键词处理 $keyword && ($wheresql .= " AND (a.mname LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%' OR a.subject LIKE '%" . str_replace(array(' ', '*'), '%', addcslashes($keyword, '%_')) . "%')"); !empty($no_list) && ($wheresql = "WHERE 1=0"); if (!submitcheck('barcsedit')) { if (empty($u_tplname)) { echo form_str($actionid . 'arcsedit', "?entry=awnotas&action=awnotasedit{$param_suffix}&page={$page}"); //搜索区块 tabheader_e(); echo "<tr><td colspan=\"2\" class=\"txt txtleft\">"; //关键词固定显示 echo lang('keyword') . " <input class=\"text\" name=\"keyword\" type=\"text\" value=\"{$keyword}\" size=\"8\" style=\"vertical-align: middle;\"> "; $appealedarr = array('-1' => lang('nolimit') . lang('appeal'), '0' => lang('noappeal'), '1' => lang('appealed')); echo "<select style=\"vertical-align: middle;\" name=\"appealed\">" . makeoption($appealedarr, $appealed) . "</select> "; echo "<input class=\"btn\" type=\"submit\" name=\"bfilter\" id=\"bfilter\" value=\"" . lang('filter0') . "\">"; echo "</td></tr>"; //某些固定页面参数 trhidden('caid', $caid); trhidden('nauid', $nauid); tabfooter(); //列表区 tabheader(lang('nota_item_list') . " <input class=\"checkbox\" type=\"checkbox\" name=\"select_all\" value=\"1\"> " . lang('selectallpage'), '', '', 9);