<?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'; }
if ($region_member) { $node_list = $db->select('node', array('name', 'introduction', 'address', 'type'), array('region' => $_GET['id'])); $title = '区域'; include 'views/region.php'; } else { header('Location: member.php?action=home'); } } } } else { if ($action == 'quick_config') { $token = check_token(); if ($token) { if (isset($_GET['id'], $region_connect[$_GET['id']])) { $region_db = new Medoo($region_connect[$_GET['id']]); $region_member = $region_db->get('user', array('id', 'passwd', 'transfer_enable', 'port', 'enable', 'u', 'd', 'switch', 't', 'expired_time', 'username'), array('username' => $token['username'])); if (!$region_member || $region_member['expired_time'] < time()) { header('Location: member.php?action=home'); } else { $server = $db->select('node', array('name', 'address', 'type'), array('region' => $_GET['id'])); $gui_config = array('configs' => array(), 'strategy' => 'com.shadowsocks.strategy.ha', 'index' => -1, 'global' => true, 'enabled' => true, 'shareOverLan' => false, 'isDefault' => false, 'localPort' => 1080, 'pacUrl' => null, 'useOnlinePac' => false, 'availabilityStatistics' => false); foreach ($server as $node) { $gui_config['configs'][] = array('server' => $node['address'], 'server_port' => $region_member['port'], 'password' => $region_member['passwd'], 'method' => strtolower($node['type']), 'remarks' => $node['name']); } header('Content-type: application/octet-stream'); header('Content-Disposition: attachment; filename="gui-config.json"'); echo json_encode($gui_config); } } else { // 少提交了参数,不返回错误信息 header('Location: member.php?action=home');
public static function getProvinceById($id) { $db = new Medoo(OSA_DB_ID); $r = $db->get('province', 'name', array('id' => $id)); if (isset($r['id'])) { return $r['id']; } return ''; }