Example #1
0
                $f = 'ui.`' . $show[$i] . '`';
            }
            $onewhere = UserSearchDoKeyboard($f, $hh[$i], $keyboard[$i]);
            if ($onewhere) {
                $or = empty($uswhere) ? '' : ' ' . $andor . ' ';
                $uswhere .= $or . '(' . $onewhere . ')';
                $search .= '&show[]=' . $show[$i] . '&hh[]=' . $hh[$i] . '&keyboard[]=' . $keyboard[$i];
            }
        }
        if ($uswhere) {
            $add .= $where . '(' . $uswhere . ')';
        }
    } else {
        $searchf = 'username';
        if ($keyboard[0]) {
            $add .= $where . UserSearchDoKeyboard('u.' . $user_username, $hh[0], $keyboard[0]);
        }
        $search .= '&hh[]=' . $hh[0] . '&keyboard[]=' . $keyboard[0];
    }
}
$add = " LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.{$user_userid}=ui.userid" . $add;
$page = (int) $_GET['page'];
$start = 0;
$line = $public_r['member_num'];
//每页显示条数
$page_line = 12;
//每页显示链接数
$offset = $page * $line;
//总偏移量
$totalnum = (int) $_GET['totalnum'];
if ($totalnum < 1) {
Example #2
0
                $f = 'ui.`' . $show[$i] . '`';
            }
            $onewhere = UserSearchDoKeyboard($f, $hh[$i], $keyboard[$i]);
            if ($onewhere) {
                $or = empty($uswhere) ? '' : ' ' . $andor . ' ';
                $uswhere .= $or . '(' . $onewhere . ')';
                $search .= '&show[]=' . $show[$i] . '&hh[]=' . RepPostStr($hh[$i], 1) . '&keyboard[]=' . RepPostStr($keyboard[$i], 1);
            }
        }
        if ($uswhere) {
            $add .= $where . '(' . $uswhere . ')';
        }
    } else {
        $searchf = 'username';
        if ($keyboard[0]) {
            $add .= $where . UserSearchDoKeyboard('u.' . egetmf('username'), $hh[0], $keyboard[0]);
        }
        $search .= '&hh[]=' . RepPostStr($hh[0], 1) . '&keyboard[]=' . RepPostStr($keyboard[0], 1);
    }
}
$add = " LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u." . egetmf('userid') . "=ui.userid" . $add;
$page = (int) $_GET['page'];
$page = RepPIntvar($page);
$start = 0;
$line = $public_r['member_num'];
//每页显示条数
$page_line = 10;
//每页显示链接数
$offset = $page * $line;
//总偏移量
$totalnum = (int) $_GET['totalnum'];