PHP AppCore::GetDatabase方法代码示例

 /**
  * Constructor
  * @param string $slug
  */
 public function __construct($slug)
 {
     $Database = AppCore::GetDatabase();
     $Cache = AppCore::GetMemcached();
     $mckey = "railpage:news.article_slug=" . $slug;
     $loaded = false;
     if ($story_id = $Cache->fetch($mckey)) {
         try {
             parent::__construct($story_id);
             $loaded = true;
         } catch (Exception $e) {
         }
     }
     /**
      * Fall back to a database query if we can't load the news article from Memcached
      */
     if (!$loaded) {
         $story_id = $Database->fetchOne("SELECT sid FROM nuke_stories WHERE slug = ?", $slug);
         if (filter_var($story_id, FILTER_VALIDATE_INT)) {
             $Cache->save($mckey, $story_id, strtotime("+6 months"));
             parent::__construct($story_id);
         } else {
             throw new Exception("Could not find a story matching URL slug " . $slug);
             return false;
         }
     }
 }

 /**
  * Constructor
  * @since Version 3.10.0
  * @return \Railpage\Railcams\Storage
  */
 public function __construct($id = null)
 {
     $this->db = AppCore::GetDatabase();
     if (filter_var($id, FILTER_VALIDATE_INT)) {
         $this->id = $id;
         $this->getConfig();
     }
 }

 /**
  * Constructor
  * @since Version 3.10.0
  * @param \Railpage\Railcams\Camera $cameraObject
  * @param int|null $id
  */
 public function __construct(Camera $cameraObject, $id = null)
 {
     $this->setCamera($cameraObject);
     $this->db = AppCore::GetDatabase();
     if (filter_var($id, FILTER_VALIDATE_INT)) {
         $this->id = $id;
         $this->getFootage();
     }
 }

 /**
  * Get read news articles for the given user
  * @since Version 3.10.0
  * @param \Railpage\Users\User $User
  * @return array
  */
 public static function getReadArticlesForUser($User)
 {
     if (!$User instanceof User || $User->id == 0 || $User->guest) {
         return array();
     }
     $Database = AppCore::GetDatabase();
     $query = "SELECT v.story_id, s.title AS story_title FROM nuke_stories_view AS v LEFT JOIN nuke_stories AS s ON s.sid = v.story_id WHERE v.user_id = ?";
     return $Database->fetchAll($query, intval($User->id));
 }

 /**
  * Get most recent push notification for a given user
  * @since Version 3.10.0
  * @param \Railpage\Users\User|int $User
  * @return array
  */
 public static function getCurrentNotification($User)
 {
     if ($User instanceof User) {
         $User = $User->id;
     }
     $query = "SELECT n.* FROM notifications AS n LEFT JOIN notifications_recipients AS nr ON n.id = nr.notification_id WHERE nr.user_id = ? AND n.transport = ? ORDER BY n.date_sent DESC LIMIT 1";
     $params = [$User, Notifications::TRANSPORT_PUSH];
     $result = AppCore::GetDatabase()->FetchRow($query, $params);
     $result['meta'] = json_decode($result['meta'], true);
     return $result;
 }

 /**
  * Get a phpBB config item
  * @since Version 3.10.0
  * @param string $key
  * @return mixed
  */
 public static function getPhpBB($key = null)
 {
     $Memcached = AppCore::GetMemcached();
     $cachekey = sprintf("railpage:config_phpbb:%s", $key);
     if ($rs = $Memcached->fetch($cachekey)) {
         return $rs;
     }
     $Database = AppCore::GetDatabase();
     $query = "SELECT config_value FROM nuke_bbconfig WHERE config_name = 'allow_html_tags'";
     $rs = $Database->fetchOne($query);
     $Memcached->save($cachekey, $rs, strtotime("+1 month"));
     return $rs;
 }

 /**
  * Update the user regdate if required
  * @since Version 3.10.0
  * @param array $data
  * @return array
  */
 public static function checkUserRegdate($data)
 {
     if (!empty($data['user_regdate_nice']) && $data['user_regdate_nice'] != "0000-00-00") {
         return $data;
     }
     if ($data['user_regdate'] == 0) {
         $data['user_regdate'] = date("Y-m-d");
     }
     $datetime = new DateTime($data['user_regdate']);
     $data['user_regdate_nice'] = $datetime->format("Y-m-d");
     $update['user_regdate_nice'] = $data['user_regdate_nice'];
     AppCore::GetDatabase()->update("nuke_users", $update, array("user_id = ?" => $data['user_id']));
     return $data;
 }

 /**
  * Create a camera object from an ID or URL slug
  * @since Version 3.10.0
  * @param string|int $id
  * @return \Railpage\Images\Camera
  */
 public static function CreateCamera($id)
 {
     $Database = AppCore::GetDatabase();
     $Memcached = AppCore::GetMemcached();
     $Redis = AppCore::getRedis();
     $Registry = Registry::getInstance();
     if (!filter_var($id, FILTER_VALIDATE_INT)) {
         $cachekey = sprintf("railpage:images.camera.id=%s", $id);
         if (!($lookup = $Memcached->fetch($cachekey))) {
             $lookup = $Database->fetchOne("SELECT id FROM image_camera WHERE url_slug = ?", $id);
             if ($lookup) {
                 $Memcached->save($cachekey, $lookup);
             }
         }
         if (!filter_var($lookup, FILTER_VALIDATE_INT)) {
             throw new Exception("Could not find a camera ID from URL slug " . $id);
         }
         $id = $lookup;
     }
     $regkey = sprintf(Camera::CACHE_KEY, $id);
     try {
         $Camera = $Registry->get($regkey);
     } catch (Exception $e) {
         if (!($Camera = $Redis->fetch($regkey))) {
             $Camera = new Camera($id);
             $Redis->save($regkey, $Camera, strtotime("+1 day"));
         }
         $Registry->set($regkey, $Camera);
     }
     return $Camera;
 }

 /**
  * @depends test_newUser
  */
 public function test_getNumRegistrationsByMonth($User)
 {
     $User->setUserAccountStatus(User::STATUS_ACTIVE);
     $Base = new Base();
     $Database = AppCore::GetDatabase();
     $From = new DateTime("today");
     $To = new DateTime();
     $Base->getNumRegistrationsByMonth($From, $To);
 }

 /**
  * Get liveries tagged in photos of a locomotive or loco class
  * @since Version 3.9.1
  * @param array $params
  * @return array
  */
 private static function getLiveriesFromObject($params)
 {
     $Database = AppCore::GetDatabase();
     $query = "SELECT DISTINCT l.livery_id, l.livery AS name, l.photo_id AS livery_photo_id\n                    FROM loco_livery AS l\n                    LEFT JOIN image_link AS il ON il.namespace_key = l.livery_id\n                    WHERE il.namespace = 'railpage.locos.liveries.livery'\n                    AND il.image_id IN (\n                        SELECT image_id FROM image_link WHERE namespace = '" . $params['namespace'] . "' AND namespace_key = ?\n                    )\n                    ORDER BY l.livery";
     $return = array();
     foreach ($Database->fetchAll($query, $params['namespace_key']) as $row) {
         $return[$row['livery_id']] = array("id" => $row['livery_id'], "name" => $row['name'], "photo" => array("id" => $row['livery_photo_id'], "provider" => "flickr"));
     }
     return $return;
 }

 /**
  * Set some default values for the user data array
  * @since Version 3.10.0
  * @param array $data
  * @param \Railpage\Users\User $ThisUser
  * @return array
  */
 public static function setDefaults($data, User $userObject)
 {
     $defaults = ["provider" => "railpage", "rank_title" => null, "timezone" => "Australia/Melbourne", "theme" => User::DEFAULT_THEME, "meta" => [], "user_id" => $userObject->id];
     $data = array_merge($defaults, $data);
     $data['user_lastvisit_nice'] = date($data['user_dateformat'], $data['user_lastvisit']);
     // Fix a dodgy timezone
     if ($data['timezone'] == "America/Kentucky") {
         $data['timezone'] = "America/Kentucky/Louisville";
         $update['timezone'] = $data['timezone'];
         AppCore::GetDatabase()->update("nuke_users", $update, array("user_id = ?" => $data['user_id']));
     }
     // Backwards compatibility
     if ($data['timezone']) {
         $timezone = new DateTime(null, new DateTimeZone($data['timezone']));
         $data['user_timezone'] = str_pad($timezone->getOffset() / 60 / 60, 5, ".00");
     }
     return $data;
 }

 /**
  * Get the subscription statuses for a given user
  * @since Version 3.10.0
  * @param \Railpage\Users\User $User
  * @return array
  */
 public static function getSubscriptionFlags(User $User)
 {
     $Database = AppCore::GetDatabase();
     $query = "SELECT COALESCE(newsletter_daily, 1) AS newsletter_daily,\n                             COALESCE(newsletter_weekly, 1) AS newsletter_weekly,\n                             COALESCE(newsletter_monthly, 1) AS newsletter_monthly,\n                             COALESCE(notify_photocomp, 1) AS notify_photocomp,\n                             COALESCE(notify_pm, 1) AS notify_pm,\n                             COALESCE(notify_forums, 1) AS notify_forums\n                      FROM nuke_users_flags\n                      WHERE user_id = ?";
     return $Database->fetchRow($query, $User->id);
 }

 /**
  * Fetch the latest information on an album from the relevant provider
  * @since Version 3.10.0
  * @param array $album
  * @return void
  */
 public static function ScrapeAlbum($album)
 {
     Debug::LogCLI("Scraping album ID " . $album['album_id'] . " from provider " . $album['provider']);
     set_time_limit(30);
     $Database = AppCore::GetDatabase();
     $Provider = ImageUtility::CreateImageProvider($album['provider']);
     // Assume Flickr for now, we can update the internal code later
     $params = ["photoset_id" => $album['album_id']];
     $albumdata = $Provider->execute("flickr.photosets.getInfo", $params);
     // Insert this shit into the database
     $data = ["scraped" => new Zend_Db_Expr("NOW()"), "meta" => json_encode($albumdata['photoset'])];
     $where = ["id = ?" => $album['id']];
     $Database->update("image_scrape_album", $data, $where);
     // Fetch the photos
     $params['user_id'] = $albumdata['photoset']['owner'];
     $photos = $Provider->execute("flickr.photosets.getPhotos", $params);
     foreach ($photos['photoset']['photo'] as $photo) {
         Debug::LogCLI("Scraping photo ID " . $photo['id']);
         set_time_limit(10);
         ImageFactory::CreateImage($photo['id'], $album['provider']);
         Debug::LogCLI("Sleeping for 2 seconds...");
         sleep(2);
     }
 }

 /**
  * Suggest locos to tag
  * Ported from \Railpage\Images\Image
  * @since Version 3.10.0
  * @param \Railpage\Images\Image $imageObject
  * @param bool|null $skipTagged
  * @return array
  */
 public static function suggestLocos(Image $imageObject, $skipTagged = null)
 {
     $locolookup = array();
     $locos = array();
     $title = self::getCleanedTitleOrDesc($imageObject->title);
     $desc = self::getCleanedTitleOrDesc($imageObject->description);
     /**
      * Loop through all our possible regexes and search
      */
     $regexes = array("[a-zA-Z0-9\\w+]{4,6}", "[0-9\\w+]{3,5}", "[a-zA-Z0-9\\w+]{2}", "[a-zA-Z0-9\\s\\w+]{4,6}");
     foreach ($regexes as $regex) {
         $regex = "/\\b(" . $regex . ")\\b/";
         preg_match_all($regex, $title, $matches['title']);
         preg_match_all($regex, $desc, $matches['description']);
         if (isset($imageObject->meta['tags']) && count($imageObject->meta['tags'])) {
             foreach ($imageObject->meta['tags'] as $tag) {
                 // strip the tags
                 #$tag = trim(preg_replace($stripetc, "", $tag));
                 $tag = self::getCleanedTitleOrDesc($tag);
                 if (empty($tag)) {
                     continue;
                 }
                 preg_match_all($regex, $tag, $matches[]);
             }
         }
         foreach ($matches as $matched) {
             foreach ($matched as $array) {
                 foreach ($array as $v) {
                     if (empty($v) || !preg_match("/([0-9])/", $v) || preg_match("/(and|to|or|for)/", $v)) {
                         continue;
                     }
                     if (in_array(trim($v), $locolookup)) {
                         continue;
                     }
                     $locolookup[] = trim($v);
                     /*
                     if (!empty( $v ) && preg_match("/([0-9])/", $v) && !preg_match("/(and|to|or|for)/", $v)) {
                         if (!in_array(trim($v), $locolookup)) {
                             $locolookup[] = trim($v);
                         }
                     }
                     */
                 }
             }
         }
     }
     /**
      * Try to include loco numbers with spaces (eg RT 40 vs RT40) in the lookup
      */
     foreach ($locolookup as $num) {
         if (preg_match("/(\\s)/", $num)) {
             preg_match("/([a-zA-Z0-9]+)(\\s)([a-zA-Z0-9]+)/", $num, $matches);
             if (isset($matches[3])) {
                 $prop = sprintf("%s%s", $matches[1], $matches[3]);
                 if (!in_array($prop, $locolookup)) {
                     $locolookup[] = $prop;
                 }
             }
         } elseif (strlen($num) == 5) {
             preg_match("/([a-zA-Z0-9]{2})([0-9]{3})/", $num, $matches);
             if (isset($matches[2])) {
                 $prop = sprintf("%s %s", $matches[1], $matches[2]);
                 if (!in_array($prop, $locolookup)) {
                     $locolookup[] = $prop;
                 }
             }
         }
     }
     $locolookup = array_unique($locolookup);
     /**
      * Prepare the SQL query
      */
     $query = "SELECT l.loco_id, l.loco_num, l.class_id, c.name AS class_name, s.name AS status_name, s.id AS status_id, t.id AS type_id, t.title AS type_name, g.gauge_id, CONCAT(g.gauge_name, ' ', g.gauge_imperial) AS gauge_formatted, o.operator_id, o.operator_name\r\n            FROM loco_unit AS l \r\n                LEFT JOIN loco_class AS c ON l.class_id = c.id \r\n                LEFT JOIN loco_type AS t ON c.loco_type_id = t.id\r\n                LEFT JOIN loco_status AS s ON l.loco_status_id = s.id\r\n                LEFT JOIN loco_gauge AS g ON g.gauge_id = l.loco_gauge_id\r\n                LEFT JOIN operators AS o ON l.operator_id = o.operator_id\r\n            WHERE l.loco_num IN ('" . implode("','", $locolookup) . "') \r\n                AND l.loco_status_id NOT IN (2)";
     /**
      * Remove existing tags from our DB query
      */
     if ($skipTagged === true) {
         $tags = $imageObject->getObjects("railpage.locos.loco");
         if (count($tags)) {
             $ids = array();
             foreach ($tags as $tag) {
                 $ids[] = $tag['namespace_key'];
             }
             $query .= " AND l.loco_id NOT IN (" . implode(",", $ids) . ")";
         }
         $query .= " ORDER BY CHAR_LENGTH(l.loco_num) DESC";
     }
     /**
      * Loop through the DB results
      */
     $i = 0;
     foreach (AppCore::GetDatabase()->fetchAll($query) as $row) {
//.........这里部分代码省略.........

 /**
  * Get screeners who haven't done any work in the last seven days
  * @since Version 3.10.0
  * @return array
  */
 public static function getLazyScreeners()
 {
     $Database = AppCore::GetDatabase();
     $query = "SELECT * FROM ( \r\n            SELECT u.user_id, u.username, u.user_email, MAX(s.screened_on) AS last_screen \r\n            FROM image_flags AS s \r\n            LEFT JOIN nuke_users AS u ON u.user_id = s.screened_by \r\n            GROUP BY u.user_id \r\n        ) AS screeners \r\n        WHERE user_id NOT IN (2) \r\n        AND last_screen < DATE_SUB(NOW(), INTERVAL 7 DAY)";
     return $Database->fetchAll($query);
 }