测试排行榜会员排行页面排序调整及主题标签长度修改 [复制链接] [手机版]

zhangjingyu 感谢楼主，祝福家园！

——本帖通过论坛手机版回复. (2020-09-16 23:39)  查看本帖 

zhangjingyu 继续测试，成功执行！
显示行 0 - 29 (104 总计, 查询花费 0.0035 秒)
看来随意指定顺序是差不多可行了！ (2020-09-16 23:30)  查看本帖 

zhangjingyu [图片]
本地测试数据共163条，按mark（排行榜类型）和value（值）降序排列（文件里sql查询语句）。mark值依次是：todaypost（今日发帖）、rvrc（威望）、postnum（发帖）、onlinetime（在线时间）、monthpost（本月发帖）、monoltime（本月在线）、money（铜币）、f_nu .. (2020-02-02 17:22)  查看本帖 

$query = $this->db->query("SELECT * FROM pw_elements WHERE TYPE =  'usersort' and mark in('todaypost','monthpost','postnum','digests','onlinetime','monoltime','money','rvrc','currency','credit','f_num','postMostUser') order by instr('todaypost,monthpost,postnum,digests,onlinetime,monoltime,money,rvrc,currency,credit,f_num,postMostUser',mark),value desc");

图片:会员排行榜.gif

<form action="$basename&adminitem=pwcache" method="post">
  <input type="hidden" name="step" value="2">
  <h2 class="h1"><span class="mr20">PW缓存库设置</span><span class="linka">勾选缓存项，提交后完成开启。<font color="red">开启后，请务必点击后面的更新缓存按钮</font></span></h2>
  <div class="admin_table mb10">
    <table cellpadding="0" cellspacing="0" width="100%">
    <tr class="tr1 vt">
        <td class="td2" width="20"><input type="checkbox" value="1" name="config[ifpwcache][]" $ifpwcache_1></td>
        <td class="td3"> 会员信息(总发帖,本月发帖,今日发帖,在线时间,会员积分)</td>
        <td class="td2">
            <span class="bt2"><span><button type="button" onclick="window.location=('$basename&adminitem=pwcache&action=update&type=usersort');">更新缓存</button></span></span>
        </td>
    </tr>

    function userSortUpdate($winddb) {
        global $timestamp, $tdtime, $montime, $_CREDITDB;
        if ($this->_inUidBlackList($winddb['uid'])) {
            return false;
        }
        $usersort_judge = array();
        //* include pwCache::getPath(D_P . 'data/bbscache/usersort_judge.php');
        extract(pwCache::getData(D_P . 'data/bbscache/usersort_judge.php', false));
        $winddb['lastpost'] < $tdtime && $winddb['todaypost'] = 0;
        $winddb['lastpost'] < $montime && $winddb['monthpost'] = 0;
        $sorttype = array(
            'money',
            'rvrc',
            'credit',
            'currency',
            'todaypost',
            'monthpost',
            'postnum',
            'monoltime',
            'onlinetime',
            'digests',
            'f_num'
        );
        if ($_CREDITDB) {
            $query = $this->db->query("SELECT cid,value FROM pw_membercredit WHERE uid=" . S::sqlEscape($winddb['uid']));
            while ($rt = $this->db->fetch_array($query)) {
                if (!$rt['value']) continue;
                $winddb[$rt['cid']] = $rt['value'];
            }
            foreach ($_CREDITDB as $key => $val) {
                is_numeric($key) && $sorttype[] = $key;
            }
        }
        $change = $marks = array();
        foreach ($sorttype as $value) {
            if (in_array($value,$sorttype) && $winddb[$value]>PW_OVERFLOW_NUM) {
                $this->_excuteOverflow($winddb['uid'],$value);
                $winddb[$value] = 0;
            }
            if ($winddb[$value] > $usersort_judge[$value]) {
                $marks[] = $value;
                if ($value == 'rvrc') {
                    $winddb[$value] = floor($winddb[$value] / 10);
                } elseif ($value == 'onlinetime') {
                    $winddb[$value] = floor($winddb[$value] / 3600);
                } elseif ($value == 'monoltime') {
                    $winddb[$value] = round($winddb[$value] / 3600,2);
                }
                $change[] = array(
                    'usersort',
                    $value,
                    $winddb['uid'],
                    $winddb[$value],
                    $winddb['username'],
                    $timestamp
                );
            }
        }
        $rand_array = array(
            'todaypost',
            'monthpost',
            'monoltime'
        );
        $rand_key = array_rand($rand_array);
        $rand_mark = $rand_array[$rand_key];
        if (!in_array($rand_mark, $marks)) {
            $marks[] = $rand_mark;
        }
        if ($marks && $change) {
            $this->db->update("REPLACE INTO pw_elements(type,mark,id,value,addition,time) VALUES " . S::sqlMulti($change, false));
            $sortlist = array();
            $dellist = array();
            $query = $this->db->query("SELECT * FROM pw_elements WHERE type='usersort' AND mark IN (" . S::sqlImplode($marks) . ") ORDER BY mark,value DESC");
            while ($rt = $this->db->fetch_array($query)) {
                if (($rt['mark'] == 'todaypost' && $rt['time'] < $tdtime) || (in_array($rt['mark'], array(
                    'monthpost',
                    'monoltime'
                )) && $rt['time'] < $montime)) {
                    $dellist[] = $rt['eid'];
                    continue;
                }
                $sortlist[$rt['mark']][] = $rt;
            }
            $judge = $usersort_judge;
            foreach ($sortlist as $key => $value) {
                if (count($value) > $this->cachenum) {
                    $tem = array_pop($value);
                    $dellist[] = $tem['eid'];
                }
                if (count($value) == $this->cachenum) {
                    $tem = end($value);
                    $judge[$key] = $tem['value'];
                } else {
                    $judge[$key] = '0';
                }
            }
            if ($dellist) {
                $this->db->update("DELETE FROM pw_elements WHERE eid IN (" . S::sqlImplode($dellist) . ")");
            }
            if ($judge != $usersort_judge) {
                pwCache::setData(D_P . 'data/bbscache/usersort_judge.php', "<?php\r\n\$usersort_judge=" . pw_var_export($judge) . ";\r\n?>");
            }
        }
    }