PHP dselect函数代码示例

<?php

defined('DT_ADMIN') or exit('Access Denied');
require MD_ROOT . '/grade.class.php';
$do = new grade();
$menus = array(array('升级记录', '?moduleid=' . $moduleid . '&file=' . $file), array('审核申请', '?moduleid=' . $moduleid . '&file=' . $file . '&action=check'), array('拒绝记录', '?moduleid=' . $moduleid . '&file=' . $file . '&action=reject'), array(VIP . '管理', '?moduleid=4&file=vip'));
if (in_array($action, array('', 'check', 'reject'))) {
    $sfields = array('按条件', '公司名', '会员名', '联系人', '电话', '手机', 'Email', 'MSN', 'QQ', 'IP', '附言', '备注', '优惠码');
    $dfields = array('company', 'company', 'username', 'truename', 'telephone', 'mobile', 'email', 'msn', 'qq', 'ip', 'content', 'note', 'promo_code');
    $sorder = array('结果排序方式', '申请时间降序', '申请时间升序', '受理时间降序', '受理时间升序', '付款金额降序', '付款金额升序');
    $dorder = array('addtime DESC', 'addtime DESC', 'addtime ASC', 'edittime DESC', 'edittime ASC', 'amount DESC', 'amount ASC');
    isset($fields) && isset($dfields[$fields]) or $fields = 0;
    isset($order) && isset($dorder[$order]) or $order = 0;
    $fields_select = dselect($sfields, 'fields', '', $fields);
    $order_select = dselect($sorder, 'order', '', $order);
    $condition = '';
    if ($keyword) {
        $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
    }
}
$menuon = array('4', '2', '1', '0');
switch ($action) {
    case 'edit':
        $itemid or msg();
        $do->itemid = $itemid;
        if ($submit) {
            if ($do->edit($post)) {
                dmsg('操作成功', $forward);
            } else {
                msg($do->errmsg);
            }

 $groupid = isset($groupid) ? intval($groupid) : 0;
 $valid = isset($valid) ? intval($valid) : 0;
 $level = isset($level) ? intval($level) : 0;
 $uid = isset($uid) ? intval($uid) : '';
 $username = isset($username) ? trim($username) : '';
 isset($fromtime) or $fromtime = '';
 isset($totime) or $totime = '';
 isset($timetype) or $timetype = 'totime';
 $fields_select = dselect($sfields, 'fields', '', $fields);
 $level_select = level_select('level', '级别', $level);
 $order_select = dselect($sorder, 'order', '', $order);
 $valid_select = dselect($svalid, 'valid', '', $valid);
 $group_select = group_select('groupid', '会员组', $groupid);
 $mode_select = dselect($modes, 'mode', '', $mode);
 $type_select = dselect($types, 'type', '', $type);
 $size_select = dselect($sizes, 'size', '', $size);
 $condition = 'groupid>5';
 if ($_areaids) {
     $condition .= " AND areaid IN (" . $_areaids . ")";
 }
 //CITY
 if ($keyword) {
     $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
 }
 if ($groupid) {
     $condition .= " AND groupid={$groupid}";
 }
 if ($vip > -1) {
     $condition .= " AND vip={$vip}";
 }
 if ($level) {

    require DT_ROOT . '/admin/admin_check.inc.php';
}
$this_forward = '?moduleid=' . $moduleid . '&file=' . $file;
if (in_array($action, array('', 'check'))) {
    $sorder = array('结果排序方式', '更新时间降序', '更新时间升序', '是否文字降序', '是否文字升序', '是否推荐降序', '是否推荐升序');
    $dorder = array('listorder DESC,itemid DESC', 'edittime DESC', 'eidttime ASC', 'type DESC', 'type ASC', 'elite DESC', 'elite ASC');
    $stype = array('类型', '文字', 'LOGO');
    $dtype = array('0', '1', '2');
    $level = isset($level) ? intval($level) : 0;
    $typeid = isset($typeid) ? intval($typeid) : 0;
    $type = isset($type) ? intval($type) : 0;
    isset($order) && isset($dorder[$order]) or $order = 0;
    $type_select = type_select('link', 1, 'typeid', '请选择分类', $typeid);
    $order_select = dselect($sorder, 'order', '', $order);
    $level_select = level_select('level', '级别', $level);
    $_type_select = dselect($stype, 'type', '', $type);
    $condition = '';
    if ($_areaids) {
        $condition .= " AND areaid IN (" . $_areaids . ")";
    }
    //CITY
    if ($keyword) {
        $condition .= " AND title LIKE '%{$keyword}%'";
    }
    if ($typeid) {
        $condition .= " AND typeid={$typeid}";
    }
    if ($type) {
        $condition .= $type == 1 ? " AND thumb=''" : " AND thumb<>''";
    }
    if ($level) {

                dmsg('修改成功', $forward);
            } else {
                msg($do->errmsg);
            }
        } else {
            extract($do->get_one());
            include tpl('favorite_edit', $module);
        }
        break;
    case 'delete':
        $itemid or msg('请选择收藏');
        $do->delete($itemid);
        dmsg('删除成功', $forward);
        break;
    default:
        $sfields = array('按条件', '标题', 'URL');
        $dfields = array('title', 'title', 'url');
        isset($fields) && isset($dfields[$fields]) or $fields = 0;
        $userid = isset($userid) ? intval($userid) : '';
        $fields_select = dselect($sfields, 'fields', '', $fields);
        $condition = '1';
        if ($keyword) {
            $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
        }
        if ($userid) {
            $condition .= " AND userid={$userid}";
        }
        $lists = $do->get_list($condition);
        include tpl('favorite', $module);
        break;
}

$fromtime = $fromdate ? strtotime($fromdate . ' 0:0:0') : 0;
$todate = isset($todate) && is_date($todate) ? $todate : '';
$totime = $todate ? strtotime($todate . ' 23:59:59') : 0;
$sfields = array($L['by_auto'], $L['by_title'], $L['by_content'], $L['by_introduce']);
$dfields = array('keyword', 'title', 'content', 'introduce');
$sorder = array($L['order'], $L['order_auto']);
$dorder = array($MOD['order'], '');
if (!$MOD['fulltext']) {
    unset($sfields[2], $dfields[2]);
}
isset($fields) && isset($dfields[$fields]) or $fields = 0;
isset($order) && isset($dorder[$order]) or $order = 0;
$category_select = ajax_category_select('catid', $L['all_category'], $catid, $moduleid);
$area_select = ajax_area_select('areaid', $L['all_area'], $areaid);
$order_select = dselect($sorder, 'order', '', $order);
$type_select = dselect($TYPE, 'typeid', $L['all_type'], $typeid);
$tags = array();
if ($DT_QST) {
    if ($kw) {
        if (strlen($kw) < $DT['min_kw'] || strlen($kw) > $DT['max_kw']) {
            message(lang($L['word_limit'], array($DT['min_kw'], $DT['max_kw'])), $MOD['linkurl'] . 'search.php');
        }
        if ($DT['search_limit'] && $page == 1) {
            if ($DT_TIME - $DT['search_limit'] < get_cookie('last_search')) {
                message(lang($L['time_limit'], array($DT['search_limit'])), $MOD['linkurl'] . 'search.php');
            }
            set_cookie('last_search', $DT_TIME);
        }
    }
    $pptsql = '';
    if ($CP) {

//.........这里部分代码省略.........
    if (!$sth) {
        echo "Database failure!";
    }
    while ($pids = mysql_fetch_row($sth)) {
        $next_prod_id = next_in_queue(0, $pids[0]);
        if ($next_prod_id) {
            $uid = get_uid_by_pid($pids[0]);
            if (has_ressources($uid, $next_prod_id)) {
                $sth1 = mysql_query("update o_production set pos=1 where planet_id=" . $pids[0] . " and prod_id={$next_prod_id}");
                $sth1 = mysql_query("select metal,energy,mopgas,erkunum,gortium,susebloom from production where prod_id={$next_prod_id}");
                list($metal, $energy, $mopgas, $erkunum, $gortium, $susebloom) = mysql_fetch_row($sth1);
                $sth1 = mysql_query("update ressources set metal=metal-{$metal},energy=energy-{$energy},mopgas=mopgas-{$mopgas},erkunum=erkunum-{$erkunum},gortium=gortium-{$gortium},susebloom=susebloom-{$susebloom} where uid={$uid}");
            }
        }
    }
    // Orbital Ende
    // Planet production
    $sth = mysql_query("select * from p_production where time=1 and pos=1");
    if (!$sth) {
        echo "Database failure!\n";
        return 0;
    }
    while ($buildings = mysql_fetch_array($sth)) {
        $sth1 = mysql_query("select uid,name from planets where id=" . $buildings["planet_id"]);
        if (!$sth1) {
            echo "Database failure!";
        }
        $uid = mysql_fetch_array($sth1);
        if ($uid["name"] == "Unnamed") {
            $uid["name"] = get_planetname($buildings["planet_id"]);
        }
        $sth1 = mysql_query("select name from production where prod_id=" . $buildings["prod_id"]);
        // Schilde einbauen
        list($value, $shield) = dselect("CONV(SUBSTRING(special FROM 2),10,10), shield", "shipvalues", "special LIKE 'H%' AND prod_id=" . $buildings["prod_id"]);
        if ($value) {
            $janne = mysql_query("REPLACE INTO planetary_shields (pid, prod_id, value, max_value, regeneration, \n        regeneration_bonus) VALUES (" . $buildings["planet_id"] . ", " . $buildings["prod_id"] . ", {$shield}, {$shield},\n          {$value}, 0)");
        }
        if (!$sth1) {
            echo "Database failure!";
        }
        $blub = mysql_fetch_array($sth1);
        ticker($uid["uid"], "*lproduction.php?act=build&pid=" . $buildings["planet_id"] . "*" . $uid["name"] . ": " . $blub["name"] . " constructed.", "w");
        $sth1 = mysql_query("insert into constructions (pid,prod_id,type) values ('" . $buildings["planet_id"] . "','" . $buildings["prod_id"] . "',0)");
        if (!$sth1) {
            echo "Database failure! (CREATING BUILDING ON PLANET)";
        }
        $sth1 = mysql_query("delete from p_production where planet_id='" . $buildings["planet_id"] . "' and prod_id='" . $buildings["prod_id"] . "'");
        if (!$sth1) {
            echo "Database failure! (DELETING PLANETAR PRODUCTION)";
        }
    }
    $sth = mysql_query("update p_production set time=time-'1' where time>1 and pos=1");
    if (!$sth) {
        echo "Database failure!";
        return 0;
    }
    $sth = mysql_query("select distinct p1.planet_id from p_production as p1 left join p_production as p2 on p2.pos=1 and p2.planet_id=p1.planet_id where p1.pos!=1 and p2.pos is NULL");
    if (!$sth) {
        echo "Database failure!";
    }
    while ($pids = mysql_fetch_row($sth)) {
        $next_prod_id = next_in_queue(1, $pids[0]);
        if ($next_prod_id) {
            $uid = get_uid_by_pid($pids[0]);
            if (has_ressources($uid, $next_prod_id)) {
                $sth1 = mysql_query("update p_production set pos=1 where planet_id=" . $pids[0] . " and prod_id={$next_prod_id}");

$menus = array(array('评论列表', '?moduleid=' . $moduleid . '&file=' . $file), array('评论审核', '?moduleid=' . $moduleid . '&file=' . $file . '&action=check'), array('评论禁止', '?moduleid=' . $moduleid . '&file=' . $file . '&action=ban'), array('模块设置', '?moduleid=' . $moduleid . '&file=setting#' . $file));
$this_forward = '?moduleid=' . $moduleid . '&file=' . $file;
if (in_array($action, array('', 'check'))) {
    $sfields = array('内容', '原文标题', '会员名', 'IP', '原文ID', '评论ID');
    $dfields = array('content', 'item_title', 'username', 'ip', 'item_id', 'itemid');
    $sorder = array('结果排序方式', '添加时间降序', '添加时间升序', '回复时间降序', '回复时间升序', '引用次数降序', '引用次数升序', '支持次数降序', '支持次数升序', '反对次数降序', '反对次数升序', '评分高低降序', '评分高低升序');
    $dorder = array('itemid desc', 'addtime DESC', 'addtime ASC', 'replytime DESC', 'replytime ASC', 'quote DESC', 'quote ASC', 'agree DESC', 'agree ASC', 'against DESC', 'against ASC', 'star DESC', 'star ASC');
    $sstar = $L['star_type'];
    isset($fields) && isset($dfields[$fields]) or $fields = 0;
    isset($order) && isset($dorder[$order]) or $order = 0;
    isset($star) && isset($sstar[$star]) or $star = 0;
    isset($ip) or $ip = '';
    $fields_select = dselect($sfields, 'fields', '', $fields);
    $module_select = module_select('mid', '模块', $mid);
    $order_select = dselect($sorder, 'order', '', $order);
    $star_select = dselect($sstar, 'star', '', $star);
    $condition = '';
    if ($keyword) {
        $condition .= in_array($dfields[$fields], array('item_id', 'itemid', 'ip')) ? " AND {$dfields[$fields]}='{$kw}'" : " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
    }
    if ($mid) {
        $condition .= " AND item_mid='{$mid}'";
    }
    if ($ip) {
        $condition .= " AND ip='{$ip}'";
    }
    if ($star) {
        $condition .= " AND star='{$star}'";
    }
}
switch ($action) {

     $money = number_format($money, 2, '.', '');
     $forward = urlencode($DT_URL);
     $head_title = $L['group_order_title'];
 } else {
     $sfields = $L['group_sfields'];
     $dfields = array('title', 'title ', 'amount', 'password', 'buyer', 'buyer_name', 'buyer_address', 'buyer_postcode', 'buyer_mobile', 'buyer_phone', 'send_type', 'send_no', 'note');
     $gid = isset($gid) ? intval($gid) : 0;
     isset($buyer) && check_name($buyer) or $buyer = '';
     isset($pass) && preg_match("/^[a-z0-9]{6}\$/", $pass) or $pass = '';
     isset($fields) && isset($dfields[$fields]) or $fields = 0;
     isset($fromtime) or $fromtime = '';
     isset($totime) or $totime = '';
     $status = isset($status) && isset($dstatus[$status]) ? intval($status) : '';
     $nav = isset($nav) ? intval($nav) : -1;
     $fields_select = dselect($sfields, 'fields', '', $fields);
     $status_select = dselect($dstatus, 'status', $L['status'], $status, '', 1, '', 1);
     $condition = "seller='{$_username}'";
     if ($keyword) {
         $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
     }
     if ($fromtime) {
         $condition .= " AND addtime>" . strtotime($fromtime . ' 00:00:00');
     }
     if ($totime) {
         $condition .= " AND addtime<" . strtotime($totime . ' 23:59:59');
     }
     if ($status !== '') {
         $condition .= " AND status='{$status}'";
     }
     if ($itemid) {
         $condition .= " AND itemid={$itemid}";

</span> <span class="f_gray">(最多可选<?php 
echo $MOD['mode_max'];
?>
种)</span></td>
</tr>
<tr>
<td class="tl"><span class="f_hid">*</span> 公司规模</td>
<td><?php 
echo dselect($COM_SIZE, 'member[size]', '请选择规模', $size, '', 0);
?>
</td>
</tr>
<tr>
<td class="tl"><span class="f_hid">*</span> 注册资本</td>
<td><?php 
echo dselect($MONEY_UNIT, 'member[regunit]', '', $regunit, '', 0);
?>
 <input type="text" size="6" name="member[capital]" id="capital" value="<?php 
echo $capital;
?>
"/> 万</td>
</tr>
<tr>
<td class="tl"><span class="f_red">*</span> 公司成立年份</td>
<td><input type="text" size="15" name="member[regyear]" id="regyear" value="<?php 
echo $regyear;
?>
"/>&nbsp;<span id="dregyear" class="f_red"></span> <span class="f_gray">(年份，如：2004)</span></td>
</tr>
<tr>
<td class="tl"><span class="f_red">*</span> 公司地址</td>

 $minsms = isset($minsms) ? intval($minsms) : '';
 $maxsms = isset($maxsms) ? intval($maxsms) : '';
 $mindeposit = isset($mindeposit) ? intval($mindeposit) : '';
 $maxdeposit = isset($maxdeposit) ? intval($maxdeposit) : '';
 $fields_select = dselect($sfields, 'fields', '', $fields);
 $order_select = dselect($sorder, 'order', '', $order);
 $gender_select = dselect($sgender, 'gender', '', $gender);
 $avatar_select = dselect($savatar, 'avatar', '', $avatar);
 $group_select = group_select('groupid', '会员组', $groupid);
 $vprofile_select = dselect($sprofile, 'vprofile', '', $vprofile);
 $vemail_select = dselect($semail, 'vemail', '', $vemail);
 $vmobile_select = dselect($smobile, 'vmobile', '', $vmobile);
 $vtruename_select = dselect($struename, 'vtruename', '', $vtruename);
 $vbank_select = dselect($sbank, 'vbank', '', $vbank);
 $vcompany_select = dselect($scompany, 'vcompany', '', $vcompany);
 $vtrade_select = $DT['trade_nm'] ? dselect($strade, 'vtrade', '', $vtrade) : '';
 $condition = $action ? 'groupid=4' : 'groupid!=4';
 //
 if ($_areaids) {
     $condition .= " AND areaid IN (" . $_areaids . ")";
 }
 //CITY
 if ($keyword) {
     $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
 }
 if ($gender) {
     $condition .= " AND gender={$gender}";
 }
 if ($avatar) {
     $condition .= $avatar == 1 ? " AND avatar=1" : " AND avatar=0";
 }

 $mincredit = isset($mincredit) ? intval($mincredit) : '';
 $maxcredit = isset($maxcredit) ? intval($maxcredit) : '';
 $minsms = isset($minsms) ? intval($minsms) : '';
 $maxsms = isset($maxsms) ? intval($maxsms) : '';
 $fields_select = dselect($sfields, 'fields', '', $fields);
 $order_select = dselect($sorder, 'order', '', $order);
 $gender_select = dselect($sgender, 'gender', '', $gender);
 $avatar_select = dselect($savatar, 'avatar', '', $avatar);
 $group_select = group_select('groupid', '会员组', $groupid);
 $vprofile_select = dselect($sprofile, 'vprofile', '', $vprofile);
 $vemail_select = dselect($semail, 'vemail', '', $vemail);
 $vmobile_select = dselect($smobile, 'vmobile', '', $vmobile);
 $vtruename_select = dselect($struename, 'vtruename', '', $vtruename);
 $vbank_select = dselect($sbank, 'vbank', '', $vbank);
 $vcompany_select = dselect($scompany, 'vcompany', '', $vcompany);
 $vtrade_select = dselect($strade, 'vtrade', '', $vtrade);
 $condition = $action ? 'groupid=4' : 'groupid!=4';
 //
 if ($_areaids) {
     $condition .= " AND areaid IN (" . $_areaids . ")";
 }
 //CITY
 if ($keyword) {
     $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
 }
 if ($gender) {
     $condition .= " AND gender={$gender}";
 }
 if ($avatar) {
     $condition .= $avatar == 1 ? " AND avatar=1" : " AND avatar=0";
 }

     } else {
         if ($all) {
             dheader('?moduleid=3&file=announce&action=html&all=1&one=' . $one);
         }
         dmsg('生成成功', "?moduleid={$_moduleid}&file={$file}");
     }
     msg('ID从' . $fid . '至' . ($aid - 1) . '[广告]生成成功' . progress($sid, $fid, $tid), "?moduleid={$_moduleid}&file={$file}&action={$action}&sid={$sid}&fid={$aid}&tid={$tid}&num={$num}&all={$all}&one={$one}");
     break;
 default:
     isset($typeid) or $typeid = 0;
     $width = isset($width) ? intval($width) : '';
     $height = isset($height) ? intval($height) : '';
     $open = isset($open) ? $open : -1;
     $thumb = isset($thumb) ? intval($thumb) : 0;
     $condition = '1';
     $type_select = dselect($TYPE, 'typeid', '', $typeid);
     if ($keyword) {
         $condition .= " AND name LIKE '%{$keyword}%'";
     }
     if ($typeid) {
         $condition .= " AND typeid={$typeid}";
     }
     if ($width) {
         $condition .= " AND width={$width}";
     }
     if ($height) {
         $condition .= " AND height={$height}";
     }
     if ($thumb) {
         $condition .= " AND thumb<>''";
     }

$maxcapital = isset($maxcapital) ? dround($maxcapital) : '';
$maxcapital or $maxcapital = '';
if (!$areaid && $cityid && strpos($DT_URL, 'areaid') === false) {
    $areaid = $cityid;
    $ARE = $AREA[$cityid];
}
isset($mode) && isset($modes[$mode]) or $mode = 0;
isset($type) && isset($types[$type]) or $type = 0;
isset($size) && isset($sizes[$size]) or $size = 0;
isset($vip) && isset($vips[$vip]) or $vip = 0;
$category_select = ajax_category_select('catid', $L['all_category'], $catid, $moduleid);
$area_select = ajax_area_select('areaid', $L['all_area'], $areaid);
$mode_select = dselect($modes, 'mode', '', $mode);
$type_select = dselect($types, 'type', '', $type);
$size_select = dselect($sizes, 'size', '', $size);
$vip_select = dselect($vips, 'vip', '', $vip);
$tags = array();
if ($DT_QST) {
    if ($kw) {
        if (strlen($kw) < $DT['min_kw'] || strlen($kw) > $DT['max_kw']) {
            message(lang($L['word_limit'], array($DT['min_kw'], $DT['max_kw'])), $MOD['linkurl'] . 'search.php');
        }
        if ($DT['search_limit'] && $page == 1) {
            if ($DT_TIME - $DT['search_limit'] < get_cookie('last_search')) {
                message(lang($L['time_limit'], array($DT['search_limit'])), $MOD['linkurl'] . 'search.php');
            }
            set_cookie('last_search', $DT_TIME);
        }
    }
    $fds = $MOD['fields'];
    $condition = "groupid>5 AND catids<>''";

     $item = $do->get_one();
     $item or msg();
     extract($item);
     include tpl('message_show', $module);
     break;
 default:
     $sfields = array('标题', '发件人', '收件人', 'IP', '内容');
     $dfields = array('title', 'fromuser', 'touser', 'ip', 'content');
     $S = array('状态', '草稿箱', '发件箱', '收件箱', '回收站');
     isset($fields) && isset($dfields[$fields]) or $fields = 0;
     $typeid = isset($typeid) ? intval($typeid) : -1;
     $read = isset($read) ? intval($read) : -1;
     $send = isset($send) ? intval($send) : -1;
     $status = isset($status) ? intval($status) : 0;
     $fields_select = dselect($sfields, 'fields', '', $fields);
     $status_select = dselect($S, 'status', '', $status);
     $condition = "groupids=''";
     if ($keyword) {
         $condition .= " AND {$dfields[$fields]} LIKE '%{$keyword}%'";
     }
     if ($status) {
         $condition .= " AND status={$status}";
     }
     if ($typeid > -1) {
         $condition .= " AND typeid={$typeid}";
     }
     if ($read > -1) {
         $condition .= " AND isread={$read}";
     }
     if ($send > -1) {
         $condition .= " AND issend={$send}";