public static function getProvince($format = false)
{
$db = new Medoo(OSA_DB_ID);
$r = $db->select('province', '*', array('ORDER' => 'pinyin'));
$tmp = array();
foreach ($r as $key => $value) {
$tmp[$value['id']] = $value;
}
$r = $tmp;
if ($format) {
$user_info = UserSession::getSessionInfo();
$html = '<select name="province" id="DropDownTimezone"><option value="0" id="DropDownTimezone-0">全部</option>';
if ($user_info && $user_info['province_id'] > 0) {
$html .= '<option value="' . $user_info['province_id'] . '" id="DropDownTimezone-0">' . $r[$user_info['province_id']]['name'] . '</option>';
} else {
foreach ($r as $key => $value) {
$html .= '<option value="' . $value['id'] . '" id="DropDownTimezone-0">' . $value['name'] . '</option>';
}
}
$html .= '</select>';
$r = $html;
}
return $r;
}
$message[] = '该账号已被注册';
}
}
}
}
if (isset($message)) {
$title = '账户';
include 'views/register.php';
}
} else {
if ($action == 'home') {
$token = check_token();
if (!$token) {
header('Location: member.php?action=login');
} else {
$region = $db->select('region', array('id', 'name', 'introduction'));
$member = $db->get('member', array('id', 'name', 'email', 'money', 'phone', 'password', 'salt'), array('name' => $token['username']));
if (!$member) {
header('Location: member.php?action=logout');
} else {
include 'library/region.php';
$title = '账户';
include 'views/home.php';
}
}
} else {
if ($action == 'home_region_ajax') {
// 通过 Ajax 查询当前 Token 用户在提供区域的账号信息
$token = check_token();
if (!$token) {
echo json_encode(array('message' => 'token 授权失败', 'error' => true));
/**
* Return the last valid pass ID
* @return string full ID of the pass
*/
public function getLastRefusedPass()
{
// Get the last failure from the database
$query = $this->medoo->select('attempts', ['card_id'], ['access_granted' => false, 'LIMIT' => 1, 'ORDER' => 'timestamp DESC']);
return $query[0]['card_id'];
}
<?php
// $start_time = microtime();
include 'library/medoo.php';
include 'library/region.php';
$db = new Medoo();
if (isset($_GET['action'])) {
$action =& $_GET['action'];
if ($action == 'commodity') {
$where = array();
$region_where = array();
if (isset($_GET['region'])) {
$where = array('region' => &$_GET['region']);
$region_where = array('id' => &$_GET['region']);
}
$region = $db->get('region', array('id', 'name', 'introduction', 'max_member'), $region_where);
$region_db = new Medoo($region_connect[$region['id']]);
$region['active_member'] = $region_db->count('user', array('expired_time[>]' => time()));
$region['usable_member'] = $region['max_member'] - $region['active_member'];
unset($region['active_member'], $region['max_member']);
$commodity = $db->select('commodity', array('id', 'name', 'introduction', 'time', 'price'), $where);
echo json_encode(array('commodity' => $commodity, 'region' => $region));
} else {
header('Location: index.php');
}
} else {
$title = '入门';
$region = $db->select('region', array('id', 'name'));
include 'views/index.php';
}
