PHP AppCore::GetMemcached方法代码示例

 /**
  * 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;
         }
     }
 }

 /**
  * Get a location ID from a URL slug
  * @since Version 3.10.0
  * @param string $slug
  * @return int
  */
 public static function getLocationId($slug)
 {
     $Redis = AppCore::GetRedis();
     $Memcached = AppCore::GetMemcached();
     $Database = (new AppCore())->getDatabaseConnection();
     $key = sprintf("railpage:locations.slug=%s", $slug);
     if (!($id = $Memcached->fetch($key))) {
         $id = $Database->fetchOne("SELECT id FROM location WHERE slug = ?", $slug);
         $Memcached->save($key, $id, 0);
     }
     return $id;
 }

 /**
  * Find a user ID from a given push registration ID
  * @since Version 3.10.0
  * @param string $registration_id
  * @return int
  */
 public static function getUserIdFromRegistrationId($registration_id)
 {
     $Database = AppCore::GetDatabase();
     $Memcached = AppCore::GetMemcached();
     $key = sprintf("railpage:gcm.subscription.key=%s", $registration_id);
     if (!($user_id = $Memcached->fetch($key))) {
         $query = "SELECT user_id FROM nuke_user_push WHERE registration_id = ?";
         $user_id = $Database->fetchOne($query, $registration_id);
         $Memcached->save($key, $user_id, 0);
     }
     return $user_id;
 }

 /**
  * 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;
 }

 /**
  * Get the formatted lead text for this article
  * @since Version 3.10.0
  * @param \Railpage\News\Article $Article
  * @param string $section The section of the article (lead or paragraphs) to format
  * @return string
  */
 public static function FormatArticleText($Article, $section = "lead")
 {
     $Memcached = AppCore::GetMemcached();
     $cachekey = $section == "lead" ? Article::CACHE_KEY_FORMAT_LEAD : Article::CACHE_KEY_FORMAT_PARAGRAPHS;
     $cachekey = sprintf($cachekey, $Article->id);
     $whitespace_find = array("<p> </p>", "<p></p>", "<p>&nbsp;</p>");
     $whitespace_replace = array("", "", "");
     #$Memcached->delete($cachekey);
     if (!($text = $Memcached->Fetch($cachekey))) {
         $text = $section == "lead" ? $Article->getLead() : $Article->getParagraphs();
         if (function_exists("format_post")) {
             $text = str_replace($whitespace_find, $whitespace_replace, $text);
             $text = format_post($text);
             if (is_object($text)) {
                 $text = $text->__toString();
             }
             $Memcached->save($cachekey, $text, 0);
         }
     }
     return $text;
 }

 /**
  * Get $num newest images
  * @since Version 3.10.0
  * @param int $num
  * @return array
  * @todo $cacheProvider doesn't seem to bloody work!
  */
 public static function getNewest($num = 5)
 {
     $cacheProvider = AppCore::GetMemcached();
     $mckey = sprintf("railpage:images.recent=%d;url.cached", $num);
     if ($newphotos = $cacheProvider->fetch($mckey)) {
         Debug::LogCLI("Fetched new photos from cache provider using cache key " . $mckey);
         return $newphotos;
     }
     $newphotos = (new Images())->getRecentAdditions(5);
     shuffle($newphotos);
     foreach ($newphotos as $id => $data) {
         $newphotos[$id]['meta']['sizes']['medium']['source'] = ImageCache::cache($newphotos[$id]['meta']['sizes']['medium']['source']);
     }
     $rs = $cacheProvider->save($mckey, $newphotos, 900);
     // save for 15 minutes
     Debug::LogCLI("Saved new photos in cache provider using cache key " . $mckey);
     if ($res = $cacheProvider->fetch($mckey)) {
         Debug::LogCLI("new photos found in cache, success");
     }
     return $newphotos;
 }

    /**
     * Get the SVG string for a gaussian blur of an image thumbnail, blown up to full size
     * Displayed while the full image loads in the background
     * @since Version 3.10.0
     * @param \Railpage\Images\Images $imageObject
     * @return string
     */
    public static function GetLoadingSVG(Image $imageObject)
    {
        $cachekey = sprintf("railpage:base64.image.svg=%d", $imageObject->id);
        $Memcached = AppCore::GetMemcached();
        // Check our base64 hash against a known, shitty hash, itself hashed in md5
        $badhash = ["f8984b3824a761805223862ca156bf1e", "10a7bf41c903ba2b3fab231fc34e4637"];
        $base64 = $Memcached->Fetch($cachekey);
        if (!$base64 || in_array(md5($base64), $badhash)) {
            /*
                    global $User; 
                    if ($User->id == 45) {
                        $base64 = $Memcached->Fetch($cachekey); 
                        
                        //echo $base64;die;
                    }
                    
                    if (!$base64 = $Memcached->Fetch($cachekey)) {*/
            $thumbnail = $imageObject->sizes['thumb']['source'];
            $cached_url = ImageCache::cache($thumbnail);
            $base64 = base64_encode(file_get_contents($cached_url));
            $Memcached->save($cachekey, $base64);
        }
        $dstw = $imageObject->sizes['largest']['width'];
        $dsth = $imageObject->sizes['largest']['height'];
        $string = '
<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="' . $dstw . '" height="' . $dsth . '" viewBox="0 0 ' . $dstw . ' ' . $dsth . '">
<filter id="blur" filterUnits="userSpaceOnUse" color-interpolation-filters="sRGB">
<feGaussianBlur stdDeviation="20 20" edgeMode="duplicate" />
<feComponentTransfer>
  <feFuncA type="discrete" tableValues="1 1" />
</feComponentTransfer>
</filter>
<image filter="url(#blur)" xlink:href="data:image/jpeg;base64,' . $base64 . '" x="0" y="0" height="100%25" width="100%25"/>
</svg>';
        $find = [" ", "<", ">", "\"", ":", "(", ")", ";", ",", "#", "=", "\n"];
        $replace = ["%20", "%3C", "%3E", "%22", "%3A", "%28", "%29", "%3B", "%2C", "%23", "%3D", "%0A"];
        return "data:image/svg+xml;charset=utf-8," . str_replace($find, $replace, trim($string));
    }

 /**
  * Commit changes to this competition
  * @since Version 3.9.1
  * @return \Railpage\Images\Competition
  */
 public function commit()
 {
     $this->validate();
     $data = array("title" => $this->title, "theme" => $this->theme, "description" => $this->description, "slug" => $this->slug, "status" => $this->status, "author" => $this->Author->id, "voting_date_open" => $this->VotingDateOpen instanceof DateTime ? $this->VotingDateOpen->format("Y-m-d H:i:s") : "0000-00-00 00:00:00", "voting_date_close" => $this->VotingDateClose instanceof DateTime ? $this->VotingDateClose->format("Y-m-d H:i:s") : "0000-00-00 00:00:00", "submissions_date_open" => $this->SubmissionsDateOpen instanceof DateTime ? $this->SubmissionsDateOpen->format("Y-m-d H:i:s") : "0000-00-00 00:00:00", "submissions_date_close" => $this->SubmissionsDateClose instanceof DateTime ? $this->SubmissionsDateClose->format("Y-m-d H:i:s") : "0000-00-00 00:00:00", "meta" => json_encode($this->meta));
     if (filter_var($this->id, FILTER_VALIDATE_INT)) {
         $where = array("id = ?" => $this->id);
         $this->db->update("image_competition", $data, $where);
     }
     if (!filter_var($this->id, FILTER_VALIDATE_INT)) {
         $this->db->insert("image_competition", $data);
         $this->id = $this->db->lastInsertId();
     }
     /**
      * Clear the cache
      */
     $regkey = sprintf(self::CACHE_KEY, $this->id);
     $Redis = AppCore::GetRedis();
     $Memcached = AppCore::GetMemcached();
     $Redis->delete($regkey);
     $Memcached->delete($regkey);
     /**
      * Check our themes and see if we need to mark this theme as used
      */
     $themes = (new Competitions())->getSuggestedThemes();
     foreach ($themes as $key => $theme) {
         $theme['theme'] = ContentUtility::FormatTitle($theme['theme']);
         if ((!isset($theme['used']) || $theme['used'] === false) && $theme['theme'] === $this->theme) {
             $themes[$key]['used'] = true;
         }
     }
     $Config = new Config();
     $Config->set("image.competition.suggestedthemes", json_encode($themes), "Photo competition themes");
     $this->url = Utility\Url::makeCompetitionUrls($this);
     return $this;
 }

 /**
  * 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;
 }

 /**
  * Constructor
  * @since Version 3.10.0
  */
 public function __construct()
 {
     $this->smarty = AppCore::GetSmarty();
     $this->cacheProvider = AppCore::GetMemcached();
 }

 /**
  * Get a user ID from a given username
  * @since Version 3.10.0
  * @param string $username
  * @return int
  */
 public static function getUserId($username)
 {
     $dataBase = (new AppCore())->getDatabaseConnection();
     $cacheHandler = AppCore::GetMemcached();
     $user_id = false;
     $mckey = sprintf("railpage:username=%s;user_id", $username);
     if (!($user_id = $cacheHandler->fetch($mckey))) {
         $query = "SELECT user_id FROM nuke_users WHERE username = ? LIMIT 0, 1";
         $user_id = $dataBase->fetchOne($query, $username);
         $cacheHandler->save($mckey, $user_id, strtotime("+1 year"));
     }
     return $user_id;
 }

    /**
     * Convert a Google Maps link into embedded content
     * @since Version 3.10.0
     * @param \DOMElement $e
     * @return \DOMElement
     */
    public static function EmbedGoogleMap(DOMElement $e)
    {
        $timer = Debug::GetTimer();
        $Config = AppCore::GetConfig();
        $lookup = pq($e)->attr("href");
        // Prevent this from fucking with links in the middle of sentences
        if (pq($e)->text() != $lookup) {
            return $e;
        }
        if (!preg_match("#google.com(.au)?/maps/(.*)\\@([0-9\\-.]{8,13}),([0-9\\-.]{8,13})#", $lookup, $matches[0]) && !preg_match("#goo.gl/maps/([a-zA-Z0-9]{10,13})#", $lookup, $matches[1])) {
            return $e;
        }
        $basehtml = '<iframe width="%s" height="%s" frameborder="0" style="border:0"
src="https://www.google.com/maps/embed/v1/view?key=%s
&zoom=%d&maptype=%s&center=%s" allowfullscreen>
</iframe>';
        $params = ["100%", 600, $Config->Google->API_Key, 15, "satellite"];
        foreach ($matches as $val) {
            if (!count($val)) {
                continue;
            }
            // Co-ordinates known, great
            if (count($val) === 5) {
                $params[] = $val[3] . "," . $val[4];
                continue;
            }
            // Co-ordinates not known. Shit. Better look 'em up
            if (count($val) !== 2) {
                continue;
            }
            $Memcached = AppCore::GetMemcached();
            $cachekey = sprintf("google:url.shortner=%s", $val[1]);
            if (!($return = $Memcached->fetch($cachekey))) {
                $GuzzleClient = new Client();
                $url = sprintf("https://www.googleapis.com/urlshortener/v1/url?shortUrl=%s&key=%s", $lookup, "AIzaSyC1lUe1h-gwmFqj9xDTDYI9HYVTUxNscCA");
                $response = $GuzzleClient->get($url);
                // Fucked it
                if ($response->getStatusCode() != 200) {
                    return $e;
                }
                $return = json_decode($response->getBody(), true);
                $Memcached->save($cachekey, $return);
            }
            // Get out if it looks problematic
            if ($return['status'] != "OK") {
                return $e;
            }
            pq($e)->attr("href", $return['longUrl'])->text($return['longUrl']);
            return self::EmbedGoogleMap($e);
            continue;
        }
        pq($e)->replaceWith(vsprintf($basehtml, $params));
        Debug::LogEvent(__METHOD__, $timer);
        return $e;
    }

 /**
  * Commit changes to this camera
  * @since Version 3.10.0
  * @return \Railpage\Images\Camera
  */
 public function commit()
 {
     $this->validate();
     $data = ["make" => $this->manufacturer, "model" => $this->name, "url_slug" => $this->slug, "image" => $this->image, "text" => $this->text, "meta" => json_encode($this->meta)];
     if (filter_var($this->id, FILTER_VALIDATE_INT)) {
         $where = ["id = ?" => $this->id];
         $this->db->update("image_camera", $data, $where);
     }
     if (!filter_var($this->id, FILTER_VALIDATE_INT)) {
         $this->db->insert("image_camera", $data);
         $this->id = $this->db->lastInsertId();
     }
     /**
      * Flush cache
      */
     $regkey = sprintf(self::CACHE_KEY, $this->id);
     $Redis = AppCore::GetRedis();
     $Memcached = AppCore::GetMemcached();
     $Redis->delete($regkey);
     $Memcached->delete($regkey);
     $this->makeURLs();
     return $this;
 }

 /**
  * Render the page 
  * @since Version 3.10.0
  * @return string
  */
 public function render()
 {
     if (!$this->userObject instanceof User) {
         throw new InvalidArgumentException("No valid user object has been provided");
     }
     #$this->smarty->clearCache($this->template, $this->unique);
     if ($this->smarty->isCached($this->template, $this->unique)) {
         Debug::LogCLI("!! Template file " . $this->template . " is already cached for unique ID " . $this->unique);
         return $this->smarty->fetch($this->template, $this->unique);
     }
     Debug::LogCLI("Template file " . $this->template . " is NOT cached for unique ID \"" . $this->unique . "\"");
     /**
      * Get user alerts
      */
     if (!$this->userObject->guest) {
         global $acl;
         $alerts = $this->userObject->getAlerts($acl);
         $this->smarty->Assign("alerts", $alerts, true);
     }
     /**
      * Get the latest jobs
      */
     $newjobs = array();
     foreach ((new Jobs())->yieldNewJobs(5) as $Job) {
         $newjobs[] = $Job->getArray();
     }
     $this->smarty->Assign("jobs", $newjobs, true);
     /**
      * Upcoming events
      */
     $Memcached = AppCore::GetMemcached();
     $cachekey = "railpage.home.upcomingevents";
     $upcoming = [];
     if (!($upcoming = $Memcached->fetch($cachekey))) {
         $Events = new Events();
         $upcoming = [];
         foreach ($Events->getUpcomingEvents(5) as $row) {
             //$Event = EventsFactory::CreateEvent($row['event_id']);
             $EventDate = new EventDate($row['id']);
             $data = $EventDate->getArray();
             $upcoming[] = $data;
         }
         $Memcached->save("railpage.home.upcomingevents", $upcoming, strtotime("+5 minutes"));
     }
     $this->smarty->Assign("upcomingevents", $upcoming);
     /**
      * New photos
      */
     $this->smarty->Assign("newphotos", RecentImages::getNewest(5));
     /**
      * Chronicle
      */
     $Chronicle = new Chronicle();
     $this->smarty->Assign("chronicle", $Chronicle->getEntriesForToday(10));
     /**
      * Get the latest railcam photo
      */
     $Camera = new Camera(1);
     $Photo = $Camera->getLatest(false);
     $railcam = $Photo->getArray();
     $railcam['sizes']['small']['source'] = ImageCache::cache($railcam['sizes']['small']['source']);
     $this->smarty->Assign("railcam", $railcam);
     $this->smarty->Assign("railcam_updated", ContentUtility::relativeTime($railcam['dates']['taken']));
     /**
      * First check if this user has a personalised news feed
      */
     if (filter_var($this->userObject->id, FILTER_VALIDATE_INT) && $this->userObject->id > 0) {
         $Feed = new Feed();
         $Feed->setUser($this->userObject)->getFilters();
         if (count($Feed->filter_words) || count($Feed->filter_topics)) {
             $latest = $Feed->findArticles(0, 20);
             foreach ($latest as $id => $article) {
                 $article['sid'] = $article['story_id'];
                 $article['catid'] = $article['topic_id'];
                 $article['hometext'] = preg_replace("@(\\[b\\]|\\[\\/b\\])@", "", $article['story_blurb']);
                 $article['informant'] = $article['username'];
                 $article['informant_id'] = $article['user_id'];
                 $article['ForumThreadId'] = $article['forum_topic_id'];
                 $article['topictext'] = $article['topic_title'];
                 $article['topic'] = $article['topic_id'];
                 $article['featured_image'] = $article['story_image'];
                 $article['title'] = $article['story_title'];
                 $article['time_relative'] = time2str($article['story_time_unix']);
                 $latest[$id] = $article;
             }
         }
     }
     $this->smarty->Assign("personalfeed", isset($latest));
     /**
      * No personal news feed - go ahead as normal
      */
     if (!isset($latest)) {
         /**
          * Instantiate the base News module
          */
//.........这里部分代码省略.........

 /**
  * Get path of this route
  * @since Version 3.9
  * @return array
  */
 public function getPath()
 {
     $mckey = sprintf("railpage:gtfs.path;provider=%s;route=%s", $this->Provider->getProviderName(), $this->short_name);
     $Memcached = AppCore::GetMemcached();
     if ($path = $Memcached->fetch($mckey)) {
         return $path;
     }
     $query = sprintf("SELECT id, service_id, trip_id, trip_headsign, shape_id, meta FROM %s_trips WHERE route_id = '%s' LIMIT 1", $this->Provider->getDbPrefix(), $this->short_name);
     $result = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
     if ($result) {
         foreach ($result as $row) {
             $trip = $row->getArrayCopy();
         }
     }
     if (!isset($trip)) {
         return false;
     }
     $query = "SELECT t.id, t.arrival_time, t.departure_time, t.stop_id, t.stop_sequence, t.pickup_type, t.drop_off_type, t.timepoint, t.meta AS time_meta, \r\n                    s.stop_code, s.stop_name, s.stop_lat, s.stop_lon, s.location_type, s.wheelchair_boarding, s.platform_code, s.meta AS stop_meta\r\n                    FROM %s_stop_times AS t LEFT JOIN %s_stops AS s ON t.stop_id = s.stop_id\r\n                    WHERE t.trip_id = %d ORDER BY t.stop_sequence";
     $query = sprintf($query, $this->Provider->getDbPrefix(), $this->Provider->getDbPrefix(), $trip['trip_id']);
     $result = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
     $path = array();
     if ($result) {
         foreach ($result as $row) {
             $url = new Url(sprintf("/timetables?mode=stop&provider=%s&id=%d", $this->Provider->getProviderName(), $row['stop_id']));
             $row = $row->getArrayCopy();
             $row['stop_meta'] = json_decode($row['stop_meta'], true);
             $row['time_meta'] = json_decode($row['time_meta'], true);
             $row['url'] = $url->getURLs();
             $path[] = $row;
         }
     }
     $Memcached->save($mckey, $path, strtotime("+1 month"));
     return $path;
 }