/**
* Return an associative array of [username] => [timestamp]
* which contains the last timestamp on which a specific username
* successfully opened the door
*
* @return array
*/
public function getLastEntries()
{
// Query for usernames and last timestamps of access
$query = $this->medoo->query('SELECT `username`, MAX(`timestamp`) AS last_entry
FROM `attempts`
WHERE `username` IS NOT NULL
AND `access_granted` = 1
GROUP BY `username`')->fetchAll();
// Construct associative array
$output = [];
$tz = new DateTimeZone('Europe/Amsterdam');
$one_week_ago = new DateTime('-1 week', $tz);
$one_month_ago = new DateTime('-1 month', $tz);
foreach ($query as $row) {
// Convert to human diff (1 month ago, 1 week ago, etc..)
$entry = new DateTime($row['last_entry'], $tz);
$result = '';
if (!$entry) {
$result = 'Voor 1 september 2015 (of nooit)';
} elseif ($entry < $one_month_ago) {
$result = 'Meer dan een maand geleden';
} elseif ($entry < $one_week_ago) {
$result = 'Meer dan een week geleden';
} else {
$result = 'Minder dan een week geleden';
}
$output[$row['username']] = $result;
}
return $output;
}
public static function getSysInfo()
{
$sys_info_array = array();
$sys_info_array['gmt_time'] = gmdate("Y年m月d日 H:i:s", time());
$sys_info_array['bj_time'] = gmdate("Y年m月d日 H:i:s", time() + 8 * 3600);
$sys_info_array['server_ip'] = gethostbyname($_SERVER["SERVER_NAME"]);
$sys_info_array['software'] = $_SERVER["SERVER_SOFTWARE"];
$sys_info_array['port'] = $_SERVER["SERVER_PORT"];
$sys_info_array['admin'] = $_SERVER["SERVER_ADMIN"];
$sys_info_array['diskfree'] = intval(diskfreespace(".") / (1024 * 1024)) . 'Mb';
$sys_info_array['current_user'] = @get_current_user();
$sys_info_array['timezone'] = date_default_timezone_get();
$db = new Medoo(OSA_DB_ID);
$mysql_version = $db->query("select version()")->fetchAll();
$sys_info_array['mysql_version'] = $mysql_version[0]['version()'];
return $sys_info_array;
}
$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) {
$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 {
// 少提交了参数，不返回错误信息
<?php
require_once 'settings.php';
require_once 'Medoo/medoo.php';
$database = new Medoo($conSettings);
$hardLinksToRoot = array('http://www.cesr.org', 'http://cesr.org', 'https://www.cesr.org', 'https://cesr.org', 'http://cesr.live.radicaldesigns.org', 'https://cesr.live.radicaldesigns.org');
$pathForAditionalFiles['doc'] = 'public://amp_migration/doc/';
$pathForAditionalFiles['img'] = 'public://amp_migration/img/';
$specialChractersToUnderscore = array(' ', '%20');
$whitespaceChractersToNull = array("\t", "\n", "\r", "", "\r\n", "\v", "€", '\\x82', '\\x83', "„", "“", "�");
$results = $database->query("SELECT articles.id, articles.title, articles.test AS body, articles.publish, articles.datecreated, articles.shortdesc, articles.doc, articles.picture, articles.custom2 AS amp_ref_id, articles.custom3 AS language, GROUP_CONCAT(tags.name) AS tag_name FROM articles LEFT JOIN tags_items ON tags_items.item_id = articles.id LEFT JOIN tags ON tags.id = tags_items.tag_id GROUP BY articles.id")->fetchAll();
// removed WHERE tags_items.item_type = 'article' from the where clause
$error = $database->error();
if ($error[0] != '00000') {
echo PHP_EOL;
echo '__SQL Errors Found__' . PHP_EOL;
var_dump($database->error());
die;
echo PHP_EOL;
}
$csv = '';
// First row is the header row
$csv .= 'id, title, body, publish, datecreated, shortdesc, doc_path, doc_description, img_name, img_path, img_title, amp_ref_id, language, tag_names' . "\n";
foreach ($results as $result) {
if ($result['datecreated'] == '0000-00-00 00:00:00') {
$result['datecreated'] = '1999-01-01 00:00:01';
}
// Drupal has a hard char limit on the title field of 128
// If it is longer than 125 lets truncate it and append ...
if (strlen($result['title']) > 125) {
$result['title'] = substr(trim($result['title']), 0, 125) . '...';
<?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';
}
public static function getProductType()
{
$db = new Medoo(OSA_DB_ID);
$r = $db->query('SELECT `buss_class` FROM `co_complaints` GROUP BY `buss_class`')->fetchAll();
$result = array();
foreach ($r as $key => $value) {
$result[] = $value['buss_class'];
}
return $result;
// $r = $db->select('co_complaints','product_type',array('group'=>'product_type'));
var_dump($r);
exit;
}
