Example #1
0
 function tearDown()
 {
     SimpleORMap::expireTableScheme();
     Config::set(null);
     StudipCacheFactory::setConfig(null);
     $GLOBALS['CACHING_ENABLE'] = false;
 }
Example #2
0
 /**
  * Wrapper around the actual #_performRequest memoizing its
  * results to prevent calling Google on each invocation.
  */
 private function performRequest($url, $shorten)
 {
     $cache = \StudipCacheFactory::getCache();
     $cache_key = 'cliqr/google/' . md5($url) . '/' . (int) $shorten;
     $result = unserialize($cache->read($cache_key));
     if ($result === false) {
         $result = $this->_performRequest($url, $shorten);
         $cache->write($cache_key, serialize($result));
     }
     return $result;
 }
Example #3
0
 private static function parseAndCacheFile($path)
 {
     $cache = \StudipCacheFactory::getCache();
     $parsed = unserialize($cache->read('squeeze/' . $path));
     if (!$parsed) {
         $parsed = self::parseFile($path);
         # write to cache and expire in 10 seconds
         $cache->write('squeeze/' . $path, serialize($parsed), 10);
     }
     return $parsed;
 }
 /**
  * Searches on remote hosts for the text.
  * @param $text
  * @param bool|false $tag
  */
 protected static function fetchRemoteSearch($text, $tag = false)
 {
     $cache_name = "Lernmarktplatz_remote_searched_for_" . md5($text) . "_" . ($tag ? 1 : 0);
     $already_searched = (bool) StudipCacheFactory::getCache()->read($cache_name);
     if (!$already_searched) {
         $host = LernmarktplatzHost::findOneBySQL("index_server = '1' AND allowed_as_index_server = '1' ORDER BY RAND()");
         if ($host && !$host->isMe()) {
             $host->fetchRemoteSearch($text, $tag);
         }
         StudipCacheFactory::getCache()->read($cache_name, "1", 60);
     }
 }
Example #5
0
 private static function get_kings()
 {
     if (self::$kings === null) {
         $cache = StudipCacheFactory::getCache();
         # read cache (unserializing a cache miss - FALSE - does not matter)
         $kings = unserialize($cache->read(self::CACHE_KEY));
         # cache miss, retrieve from database
         if ($kings === FALSE) {
             $kings = self::get_kings_uncached();
             # write to cache with an expiry time of 24 hours
             $cache->write(self::CACHE_KEY, serialize($kings), 86400);
         }
         self::$kings = $kings;
     }
     return self::$kings;
 }
Example #6
0
    /**
    * Retrieves the score for the current user
    *
    * @return       integer the score
    *
    */
    static function GetMyScore($user_or_id = null)
    {
        $user = $user_or_id ? User::toObject($user_or_id) : User::findCurrent();
        $cache = StudipCacheFactory::getCache();
        if ($cache->read("user_score_of_".$user->id)) {
            return $cache->read("user_score_of_".$user->id);
        }
        //Behold! The all new mighty score algorithm!
        //Step 1: Select all activities as mkdate-timestamps.
        //Step 2: Group these activities to timeslots of halfhours
        //        with COUNT(*) as a weigh of the timeslot.
        //Step 3: Calculate the measurement of the timeslot from the weigh of it.
        //        This makes the first activity count fully, the second
        //        almost half and so on. We use log_n to make huge amounts of
        //        activities to not count so much.
        //Step 4: Calculate a single score for each timeslot depending on the
        //        measurement and the mkdate-timestamp. Use arctan as the function
        //        here so that older activities tend to zero.
        //Step 5: Sum all scores from all timeslots together.
        $sql = "
            SELECT round(SUM((-atan(measurement / " . round(31556926 / self::MEASURING_STEP) . ") / PI() + 0.5) * 200)) as score
            FROM (
                SELECT ((unix_timestamp() / " . self::MEASURING_STEP . ") - timeslot) / (LN(weigh) + 1) AS measurement
                FROM (
                    SELECT (round(mkdate / " . self::MEASURING_STEP . ")) as timeslot, COUNT(*) AS weigh
                    FROM (
                        " . self::createTimestampQuery() . "
                    ) as mkdates
                    GROUP BY timeslot
                ) as measurements
            ) as dates
        ";
        $stmt = DBManager::get()->prepare($sql);
        $stmt->execute(array(':user' => $user->id));
        $score = $stmt->fetchColumn();
        if ($user->score && $user->score != $score) {
            $user->score = $score;
            $user->store();
        }
        $cache->write("user_score_of_".$user->id, $score, 60 * 5);

        return $score;
    }
Example #7
0
 /**
  * Returns all valid values for a certain criterion type.
  *
  * @param  string $type Name of the criterion type
  * @return array  Associative array containing the values as keys and
  *                descriptive names as values
  */
 public static function getValuesForType($type)
 {
     if (!array_key_exists($type, self::$types)) {
         throw new Exception('[UserLookup] Unknown type "' . $type . '"');
     }
     if (self::USE_CACHE) {
         $cache = StudipCacheFactory::getCache();
         $cache_key = 'UserLookup/' . $type . '/values';
         $cached_values = $cache->read($cache_key);
         if ($cached_values) {
             return unserialize($cached_values);
         }
     }
     $values = call_user_func(self::$types[$type]['values']);
     if (self::USE_CACHE) {
         $cache->write($cache_key, serialize($values), self::CACHE_DURATION);
     }
     return $values;
 }
Example #8
0
 protected function getToplistEntries($sem_status)
 {
     $sql_where_query_seminare = " WHERE 1 ";
     $parameters = array();
     if (!$GLOBALS['perm']->have_perm(get_config('SEM_VISIBILITY_PERM'))) {
         $sql_where_query_seminare .= " AND seminare.visible = 1 ";
     }
     if ($_SESSION['sem_portal']['bereich'] != 'all' && count($sem_status)) {
         $sql_where_query_seminare .= " AND seminare.status IN (?) ";
         $parameters[] = $sem_status;
     }
     switch ($_SESSION['sem_portal']["toplist"]) {
         case 4:
         default:
             $query = "SELECT seminar_id, name, mkdate AS count\n                      FROM seminare\n                      {$sql_where_query_seminare}\n                      ORDER BY mkdate DESC\n                      LIMIT 5";
             $statement = DBManager::get()->prepare($query);
             $statement->execute($parameters);
             $top_list = $statement->fetchAll(PDO::FETCH_ASSOC);
             //$toplist =  $this->getToplist(_('neueste Veranstaltungen'), $query, 'date', $parameters);
             break;
         case 1:
             $query = "SELECT seminare.seminar_id, seminare.name, COUNT(seminare.seminar_id) AS count\n                      FROM seminare\n                      LEFT JOIN seminar_user USING (seminar_id)\n                      {$sql_where_query_seminare}\n                      GROUP BY seminare.seminar_id\n                      ORDER BY count DESC\n                      LIMIT 5";
             $statement = DBManager::get()->prepare($query);
             $statement->execute($parameters);
             $top_list = $statement->fetchAll(PDO::FETCH_ASSOC);
             //$toplist = $this->getToplist(_('Teilnehmeranzahl'), $query, 'count', $parameters);
             break;
         case 2:
             $query = "SELECT dokumente.seminar_id, seminare.name, COUNT(dokumente.seminar_id) AS count\n                      FROM seminare\n                      INNER JOIN dokumente USING (seminar_id)\n                      {$sql_where_query_seminare}\n                      GROUP BY dokumente.seminar_id\n                      ORDER BY count DESC\n                      LIMIT 5";
             $statement = DBManager::get()->prepare($query);
             $statement->execute($parameters);
             $top_list = $statement->fetchAll(PDO::FETCH_ASSOC);
             //$toplist =  $this->getToplist(_('die meisten Materialien'), $query, 'count', $parameters);
             break;
         case 3:
             $cache = StudipCacheFactory::getCache();
             $hash = '/sem_portal/most_active';
             $top_list = unserialize($cache->read($hash));
             if (!$top_list) {
                 // get TopTen of seminars from all ForumModules and add up the
                 // count for seminars with more than one active ForumModule
                 // to get a combined toplist
                 $seminars = array();
                 foreach (PluginEngine::getPlugins('ForumModule') as $plugin) {
                     $new_seminars = $plugin->getTopTenSeminars();
                     foreach ($new_seminars as $sem) {
                         if (!isset($seminars[$sem['seminar_id']])) {
                             $seminars[$sem['seminar_id']] = $sem;
                             $seminars[$sem['seminar_id']]['name'] = $seminars[$sem['seminar_id']]['display'];
                         } else {
                             $seminars[$sem['seminar_id']]['count'] += $sem['count'];
                         }
                     }
                 }
                 // sort the seminars by the number of combined postings
                 usort($seminars, function ($a, $b) {
                     if ($a['count'] == $b['count']) {
                         return 0;
                     }
                     return $a['count'] > $b['count'] ? -1 : 1;
                 });
                 $top_list = $seminars;
                 // use only the first five seminars
                 $top_list = array_slice($top_list, 0, 5);
                 $cache->write($hash, serialize($top_list), 5 * 60);
             }
             break;
     }
     return $top_list;
 }
Example #9
0
/**
 * get the number of currently online users
 *
 * @param int $active_time filter: the time in minutes until last life-sign
 *
 * @return int
 */
function get_users_online_count($active_time = 5)
{
    $cache = StudipCacheFactory::getCache();
    $online_count = $cache->read('online_count');
    if ($online_count === false) {
        $query = "SELECT COUNT(*) FROM user_online\n                  WHERE last_lifesign > ?";
        $statement = DBManager::get()->prepare($query);
        try {
            $statement->execute(array(time() - $active_time * 60));
        } catch (PDOException $e) {
            require_once 'lib/migrations/db_schema_version.php';
            $version = new DBSchemaVersion('studip');
            if ($version->get() < 98) {
                Log::ALERT('get_users_online_count() failed. Check migration no. 98!');
            } else {
                throw $e;
            }
        }
        $online_count = $statement->fetchColumn();
        $cache->write('online_count', $online_count, 180);
    }
    if ($GLOBALS['user']->id && $GLOBALS['user']->id != 'nobody') {
        --$online_count;
    }
    return $online_count > 0 ? $online_count : 0;
}
Example #10
0
 function store()
 {
     $cache = StudipCacheFactory::getCache();
     $cache->expire('course/undecorated_data/' . $this->range_id);
     $this->chdate = time();
     if ($this->ex_termin) {
         $this->killAssign();
         $this->killIssue();
     }
     // date_typ = 0 defaults to TERMIN_TYP[1] because there never exists one with zero
     if (!$this->date_typ) {
         $this->date_typ = 1;
     }
     if ($this->orig_ex != $this->ex_termin) {
         SingleDateDB::deleteSingleDate($this->termin_id, $this->orig_ex);
     }
     return SingleDateDB::storeSingleDate($this);
 }
Example #11
0
 function indicator($key)
 {
     $cache = StudipCacheFactory::getCache();
     if ($found_in_cache = $cache->read(__METHOD__ . $key)) {
         return $found_in_cache;
     }
     $template = $this->template_factory->open('indicator');
     $indicator['seminar_all'] = array("count" => array('count_table_rows', 'seminare'), "title" => _("Aktive Veranstaltungen"), "detail" => _("alle Veranstaltungen, die nicht archiviert wurden"));
     $indicator['seminar_archived'] = array("count" => array('count_table_rows', 'archiv'), "title" => _("Archivierte Veranstaltungen"), "detail" => _("alle Veranstaltungen, die archiviert wurden"));
     $indicator['institute_secondlevel_all'] = array("query" => "SELECT COUNT(*) FROM Institute WHERE Institut_id != fakultaets_id", "title" => _("beteiligte Einrichtungen"), "detail" => _("alle Einrichtungen außer den Fakultäten"));
     $indicator['institute_firstlevel_all'] = array("query" => "SELECT COUNT(*) FROM Institute WHERE Institut_id = fakultaets_id", "title" => _("beteiligte Fakultäten"), "detail" => _("alle Fakultäten"));
     $indicator['user_admin'] = array("query" => "SELECT COUNT(*) FROM auth_user_md5 WHERE perms='admin'", "title" => _("registrierte Administratoren"), "detail" => "");
     $indicator['user_dozent'] = array("query" => "SELECT COUNT(*) FROM auth_user_md5 WHERE perms='dozent'", "title" => _("registrierte Dozenten"), "detail" => "");
     $indicator['user_tutor'] = array("query" => "SELECT COUNT(*) FROM auth_user_md5 WHERE perms='tutor'", "title" => _("registrierte Tutoren"), "detail" => "");
     $indicator['user_autor'] = array("query" => "SELECT COUNT(*) FROM auth_user_md5 WHERE perms='autor'", "title" => _("registrierte Autoren"), "detail" => "");
     $indicator['document'] = array("query" => "SELECT COUNT(*) FROM dokumente WHERE url = ''", "title" => _("Dokumente"), "detail" => "");
     $indicator['link'] = array("query" => "SELECT COUNT(*) FROM dokumente WHERE url != ''", "title" => _("verlinkte Dateien"), "detail" => "");
     $indicator['litlist'] = array("count" => array('count_table_rows', 'lit_list'), "title" => _("Literaturlisten"), "detail" => "", "constraint" => get_config('LITERATURE_ENABLE'));
     $indicator['termin'] = array("count" => array('count_table_rows', 'termine'), "title" => _("Termine"), "detail" => "");
     $indicator['news'] = array("count" => array('count_table_rows', 'news'), "title" => _("Ankündigungen"), "detail" => "");
     $indicator['vote'] = array("count" => array('count_table_rows', 'questionnaires'), "title" => _("Fragebögen"), "detail" => "", "constraint" => get_config('VOTE_ENABLE'));
     $indicator['evaluation'] = array("count" => array('count_table_rows', 'eval'), "title" => _("Evaluationen"), "detail" => "", "constraint" => get_config('VOTE_ENABLE'));
     $indicator['wiki_pages'] = array("query" => "SELECT COUNT(DISTINCT keyword) AS count FROM wiki", "title" => _("Wiki-Seiten"), "detail" => "", "constraint" => get_config('WIKI_ENABLE'));
     $indicator['resource'] = array("count" => array('count_table_rows', 'resources_objects'), "title" => _("Ressourcen-Objekte"), "detail" => _("von Stud.IP verwaltete Ressourcen wie Räume oder Geräte"), "constraint" => Config::get()->RESOURCES_ENABLE);
     if ($key == 'posting') {
         $count = 0;
         // sum up number of postings for all availabe ForumModules
         foreach (PluginEngine::getPlugins('ForumModule') as $plugin) {
             $count += $plugin->getNumberOfPostings();
         }
         $template->title = _('Forenbeiträge');
         $template->detail = _('Anzahl Beiträge aller verwendeten Foren');
         $template->count = $count;
     } else {
         // iterate over the other indicators
         if (in_array($key, array_keys($indicator))) {
             if (!isset($indicator[$key]['constraint']) || $indicator[$key]['constraint']) {
                 if ($indicator[$key]['query']) {
                     $result = $this->db->query($indicator[$key]['query']);
                     $rows = $result->fetch(PDO::FETCH_NUM);
                     $template->count = $rows[0];
                 } else {
                     $template->count = call_user_func($indicator[$key]['count'][0], $indicator[$key]['count'][1]);
                 }
                 $template->title = $indicator[$key]['title'];
                 if ($indicator[$key]['detail']) {
                     $template->detail = $indicator[$key]['detail'];
                 }
             } else {
                 return "";
             }
         } else {
             return "";
         }
     }
     $ret = $template->render();
     $cache->write(__METHOD__ . $key, $ret);
     return $ret;
 }
Example #12
0
 /**
  * force reload of cached table metadata
  */
 public static function expireTableScheme()
 {
     StudipCacheFactory::getCache()->expire('DB_TABLE_SCHEMES');
     self::$schemes = null;
 }
Example #13
0
 function ac_start()
 {
     $this->cache = StudipCacheFactory::getCache();
 }
Example #14
0
 /**
  * Returns a cache instance.
  *
  * @param bool $apply_proxied_operations Whether or not to apply any
  *                                       proxied (disable this in tests!)
  * @return StudipCache the cache instance
  */
 public static function getCache($apply_proxied_operations = true)
 {
     if (is_null(self::$cache)) {
         $proxied = false;
         if (!$GLOBALS['CACHING_ENABLE']) {
             self::$cache = new StudipNullCache();
             // Proxy cache operations if CACHING_ENABLE is different from the globally set
             // caching value. This should only be the case in cli mode.
             if (isset($GLOBALS['GLOBAL_CACHING_ENABLE']) && $GLOBALS['GLOBAL_CACHING_ENABLE']) {
                 $proxied = true;
             }
         } else {
             try {
                 $class = self::loadCacheClass();
                 $args = self::retrieveConstructorArguments();
                 self::$cache = self::instantiateCache($class, $args);
             } catch (Exception $e) {
                 error_log(__METHOD__ . ': ' . $e->getMessage());
                 PageLayout::addBodyElements(MessageBox::error(__METHOD__ . ': ' . $e->getMessage()));
                 $class = self::DEFAULT_CACHE_CLASS;
                 self::$cache = new $class();
             }
         }
         // If proxy should be used, inject it. Otherwise apply pending
         // operations, if any.
         if ($proxied) {
             self::$cache = new StudipCacheProxy(self::$cache);
         } elseif ($GLOBALS['CACHING_ENABLE'] && $apply_proxied_operations) {
             // Even if the above condition will try to eliminate most
             // failures, the following operation still needs to be wrapped
             // in a try/catch block. Otherwise there are no means to
             // execute migration 166 which creates the neccessary tables
             // for said operation.
             try {
                 StudipCacheOperation::apply(self::$cache);
             } catch (Exception $e) {
             }
         }
     }
     return self::$cache;
 }
Example #15
0
    /**
     * Enter description here...
     *
     * @param int $pluginid
     * @return array
     */
    public static function getAssignedPluginRoles($pluginid=-1)
    {
        $cache = StudipCacheFactory::getCache();

        // read plugin roles from cache (unserialize does not matter on cache
        $key = self::ROLES_PLUGINS_CACHE_KEY . (int) $pluginid;
        $result = unserialize($cache->read($key));

        // cache miss, retrieve roles from database
        if (!$result) {

            $result = array();
            $roles = self::getAllRoles();

            $stmt = DBManager::get()->prepare("SELECT * FROM roles_plugins WHERE pluginid=?");
            $stmt->execute(array($pluginid));

            while ($row = $stmt->fetch()) {
                if (isset($roles[$row["roleid"]])) {
                    $result[] = $roles[$row["roleid"]];
                }
            }

            // write to cache
            $cache->write($key, serialize($result));
        }
        return $result;
    }
Example #16
0
    public function addSingleDate(&$singledate)
    {
        // logging >>>>>>
        StudipLog::log("SEM_ADD_SINGLEDATE", $this->getId(), $singledate->toString(), 'SingleDateID: '.$singledate->getTerminID());
        // logging <<<<<<

        $cache = StudipCacheFactory::getCache();
        $cache->expire('course/undecorated_data/'. $this->getId());

        $this->readSingleDates();
        $this->irregularSingleDates[$singledate->getSingleDateID()] =& $singledate;
        NotificationCenter::postNotification("CourseDidChangeSchedule", $this);
        return TRUE;
    }
 /**
  * Removes the cached entries for a specific user.
  *
  * @param String $user_id Id of the user
  */
 protected static function expireCache($user_id)
 {
     $cache = StudipCacheFactory::getCache();
     $hash = self::getCacheHash($user_id);
     $cache->expire($hash);
 }