/** * 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; }
<?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) . '...';
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; }