/**
  * Get the query log as an array.
  *
  * @param boolean $sorted Get the queries sorted by time taken, defaults to false.
  * @return array Array of queries run as an array
  * @access public
  */
 function getLog($sorted = false, $clear = true)
 {
     if ($sorted) {
         $log = sortByKey($this->_queriesLog, 'took', 'desc', SORT_NUMERIC);
     } else {
         $log = $this->_queriesLog;
     }
     if ($clear) {
         $this->_queriesLog = array();
     }
     return array('log' => $log, 'count' => $this->_queriesCnt, 'time' => $this->_queriesTime);
 }

 /**
  * sortImageArray will sort an array of Images based on the given key. The
  * key must be one of (filename, title, sort_order) at the moment.
  *
  * @param array $images The array of filenames to be sorted.
  * @param  string $sorttype optional sort type
  * @param  string $sortdirection optional sort direction
  * @param bool $mine set to true/false to override ownership clause
  * @return array
  */
 protected function sortImageArray($images, $sorttype, $sortdirection, $mine = NULL)
 {
     if (is_null($mine)) {
         $mine = $this->isMyItem(LIST_RIGHTS | MANAGE_ALL_ALBUM_RIGHTS);
     }
     if ($mine && !($mine & MANAGE_ALL_ALBUM_RIGHTS)) {
         //	check for managed album view unpublished image rights
         $mine = $this->albumSubRights() & (MANAGED_OBJECT_RIGHTS_EDIT | MANAGED_OBJECT_RIGHTS_VIEW);
     }
     $sortkey = $this->getImageSortKey($sorttype);
     if ($sortkey == '`sort_order`' || $sortkey == 'RAND()') {
         // manual sort is always ascending
         $order = false;
     } else {
         if (!is_null($sortdirection)) {
             $order = strtoupper($sortdirection) == 'DESC';
         } else {
             $order = $this->getSortDirection('image');
         }
     }
     $result = query($sql = "SELECT * FROM " . prefix("images") . " WHERE `albumid`= " . $this->getID() . ' ORDER BY ' . $sortkey . ' ' . $sortdirection);
     $results = array();
     while ($row = db_fetch_assoc($result)) {
         $filename = $row['filename'];
         if (($key = array_search($filename, $images)) !== false) {
             // the image exists in the filesystem
             $results[] = $row;
             unset($images[$key]);
         } else {
             // the image no longer exists
             $id = $row['id'];
             query("DELETE FROM " . prefix('images') . " WHERE `id`={$id}");
             // delete the record
             query("DELETE FROM " . prefix('comments') . " WHERE `type` ='images' AND `ownerid`= '{$id}'");
             // remove image comments
         }
     }
     db_free_result($result);
     foreach ($images as $filename) {
         // these images are not in the database
         $imageobj = newImage($this, $filename);
         $results[] = $imageobj->getData();
     }
     // now put the results into the right order
     $results = sortByKey($results, str_replace('`', '', $sortkey), $order);
     // the results are now in the correct order
     $images_ordered = array();
     foreach ($results as $key => $row) {
         // check for visible
         switch (checkPublishDates($row)) {
             case 1:
                 $imageobj = newImage($this, $row['filename']);
                 $imageobj->setShow(0);
                 $imageobj->save();
             case 2:
                 $row['show'] = 0;
                 break;
         }
         if ($row['show'] || $mine) {
             // don't display it
             $images_ordered[] = $row['filename'];
         }
     }
     return $images_ordered;
 }

 /**
  * Outputs the contents of the queries log. If in a non-CLI environment the sql_log element
  * will be rendered and output.  If in a CLI environment, a plain text log is generated.
  *
  * @param boolean $sorted Get the queries sorted by time taken, defaults to false.
  * @return void
  */
 function showLog($sorted = false)
 {
     if ($sorted) {
         $log = sortByKey($this->_queriesLog, 'took', 'desc', SORT_NUMERIC);
     } else {
         $log = $this->_queriesLog;
     }
     if ($this->_queriesCnt > 1) {
         $text = 'queries';
     } else {
         $text = 'query';
     }
     if (PHP_SAPI != 'cli') {
         $summary = "{$this->_queriesCnt} {$text} took {$this->_queriesTime} ms";
         $body = array();
         $body[] = array("Nr", "Query", "Error", "Affected", "Num. rows", "Took (ms)");
         foreach ($log as $k => $i) {
             $body[] = array($k + 1, $i['query'], $i['error'], $i['affected'], $i['numRows'], $i['took']);
         }
         fb(array($summary, $body), FirePHP::TABLE);
     } else {
         foreach ($log as $k => $i) {
             print $k + 1 . ". {$i['query']} {$i['error']}\n";
         }
     }
 }

 /**
  * Get the query log as an array.
  *
  * @param boolean $sorted Get the queries sorted by time taken, defaults to false.
  * @param boolean $clear Clear after return logs
  * @return array Array of queries run as an array
  */
 public function getLog($sorted = false, $clear = true)
 {
     if ($sorted) {
         $log = sortByKey($this->_requestsLog, 'took', 'desc', SORT_NUMERIC);
     } else {
         $log = $this->_requestsLog;
     }
     if ($clear) {
         $this->_requestsLog = array();
     }
     return array('log' => $log, 'count' => count($log), 'time' => array_sum(Set::extract('{n}.took', $log)));
 }

    /**
     * Outputs the contents of the queries log.
     *
     * @param boolean $sorted
     */
    function showLog($sorted = false) {
        if ($sorted) {
            $log = sortByKey($this->_queriesLog, 'took', 'desc', SORT_NUMERIC);
        } else {
            $log = $this->_queriesLog;
        }

        if ($this->_queriesCnt > 1) {
            $text = 'queries';
        } else {
            $text = 'query';
        }

        if (php_sapi_name() != 'cli') {
            print ("<table id=\"cakeSqlLog\" cellspacing=\"0\" border = \"0\">\n<caption>{$this->_queriesCnt} {$text} took {$this->_queriesTime} ms</caption>\n");
            print ("<thead>\n<tr><th>Nr</th><th>Query</th><th>Error</th><th>Affected</th><th>Num. rows</th><th>Took (ms)</th></tr>\n</thead>\n<tbody>\n");

            foreach ($log as $k => $i) {
                print ("<tr><td>" . ($k +1) . "</td><td>{$i['query']}</td><td>{$i['error']}</td><td style = \"text-align: right\">{$i['affected']}</td><td style = \"text-align: right\">{$i['numRows']}</td><td style = \"text-align: right\">{$i['took']}</td></tr>\n");
            }
            print ("</table>\n");
        } else {
            foreach ($log as $k => $i) {
                print (($k +1) . ". {$i['query']} {$i['error']}\n");
            }
        }
    }

 /**
  * Outputs the contents of the queries log.
  *
  * @param boolean $sorted
  */
 function showLog($sorted = false)
 {
     if ($sorted) {
         $log = sortByKey($this->_queriesLog, 'took', 'desc', SORT_NUMERIC);
     } else {
         $log = $this->_queriesLog;
     }
     if ($this->_queriesCnt > 1) {
         $text = 'queries';
     } else {
         $text = 'query';
     }
     if (php_sapi_name() != 'cli') {
         print "<table class=\"cakeSqlLog\" id=\"cakeSqlLog_" . preg_replace('/[^A-Za-z0-9_]/', '_', uniqid(time(), true)) . "\" summary=\"Cake SQL Log\" cellspacing=\"0\" border = \"0\">\n<caption>{$this->_queriesCnt} {$text} took {$this->_queriesTime} ms</caption>\n";
         print "<thead>\n<tr><th>Nr</th><th>Query</th><th>Error</th><th>Affected</th><th>Num. rows</th><th>Took (ms)</th></tr>\n</thead>\n<tbody>\n";
         foreach ($log as $k => $i) {
             print "<tr><td>" . ($k + 1) . "</td><td>" . h($i['query']) . "</td><td>{$i['error']}</td><td style = \"text-align: right\">{$i['affected']}</td><td style = \"text-align: right\">{$i['numRows']}</td><td style = \"text-align: right\">{$i['took']}</td></tr>\n";
         }
         print "</tbody></table>\n";
     } else {
         foreach ($log as $k => $i) {
             print $k + 1 . ". {$i['query']} {$i['error']}\n";
         }
     }
 }

 /**
  * Returns a of a slice of the images for this album. They will
  * also be sorted according to the sort type of this album, or by filename if none
  * has been set.
  *
  * @param string $page  Which page of images should be returned. If zero, all images are returned.
  * @param int $firstPageCount count of images that go on the album/image transition page
  * @param string $sorttype optional sort type
  * @param string $sortdirection optional sort direction
  * @param bool $care set to false if the order of the images does not matter
  * @param bool $mine set true/false to override ownership
  *
  * @return array
  */
 function getImages($page = 0, $firstPageCount = 0, $sorttype = null, $sortdirection = null, $care = true, $mine = NULL)
 {
     if ($mine || is_null($this->images) || $care && $sorttype . $sortdirection !== $this->lastimagesort) {
         $this->images = NULL;
         $images = array();
         $result = query('SELECT * FROM ' . prefix('plugin_storage') . ' WHERE `type`="favorites" AND `aux`=' . db_quote($this->getInstance()) . ' AND `data` LIKE "%s:4:\\"type\\";s:6:\\"images\\";%"');
         if ($result) {
             while ($row = db_fetch_assoc($result)) {
                 $id = $row['id'];
                 $data = getSerializedArray($row['data']);
                 $imageObj = newImage(NULL, array('folder' => dirname($data['id']), 'filename' => basename($data['id'])), true);
                 if ($imageObj->exists) {
                     $images[] = array_merge(array('folder' => dirname($data['id']), 'filename' => basename($data['id'])), $imageObj->getData());
                 } else {
                     query("DELETE FROM " . prefix('plugin_storage') . ' WHERE `id`=' . $row['id']);
                 }
             }
             db_free_result($result);
             if (is_null($sorttype)) {
                 $sorttype = $this->getSortType();
             }
             $sortkey = str_replace('` ', ' ', $this->getImageSortKey($sorttype));
             if ($sortkey == 'sort_order' || $sortkey == 'RAND()') {
                 // manual sort is always ascending
                 $order = false;
             } else {
                 if (!is_null($sortdirection)) {
                     $order = strtoupper($sortdirection) == 'DESC';
                 } else {
                     $order = $this->getSortDirection('image');
                 }
             }
             $images = sortByKey($images, $sortkey, $order);
             $this->images = array();
             foreach ($images as $data) {
                 $this->images[] = array('folder' => $data['folder'], 'filename' => $data['filename']);
             }
             $this->lastimagesort = $sorttype . $sortdirection;
         }
     }
     return parent::getImages($page, $firstPageCount);
 }

 /**
  * Get the query log as an array.
  *
  * @param boolean $sorted Get the queries sorted by time taken, defaults to false.
  * @return array Array of queries run as an array
  */
 public function getLog($sorted = false)
 {
     if ($sorted) {
         $log = sortByKey($this->_queriesLog, 'took', 'desc', SORT_NUMERIC);
     } else {
         $log = $this->_queriesLog;
     }
     return $log;
 }

 /**
  * Sort the album array based on either according to the sort key.
  * Default is to sort on the `sort_order` field.
  *
  * Returns an array with the albums in the desired sort order
  *
  * @param  array $albums array of album names
  * @param  string $sortkey the sorting scheme
  * @param string $sortdirection
  * @param bool $mine set true/false to override ownership
  * @return array
  *
  * @author Todd Papaioannou ([email protected])
  * @since  1.0.0
  */
 function sortAlbumArray($parentalbum, $albums, $sortkey = 'sort_order', $sortdirection = NULL, $mine = NULL)
 {
     if (count($albums) == 0) {
         return array();
     }
     if (is_null($mine) && zp_loggedin(MANAGE_ALL_ALBUM_RIGHTS)) {
         $mine = true;
     }
     if (is_null($parentalbum)) {
         $albumid = ' IS NULL';
         $obj = $this;
         $viewUnpublished = $mine;
     } else {
         $albumid = '=' . $parentalbum->getID();
         $obj = $parentalbum;
         $viewUnpublished = zp_loggedin() && $obj->subRights() & (MANAGED_OBJECT_RIGHTS_EDIT | MANAGED_OBJECT_RIGHTS_VIEW);
     }
     if (trim($sortkey . '`') != 'sort_order' || $sortkey == 'RAND()') {
         // manual sort is always ascending
         $order = false;
     } else {
         if (is_null($sortdirection)) {
             $sortdirection = $this->getSortDirection('album');
         }
         $order = $sortdirection && strtolower($sortdirection) != 'asc';
     }
     $sql = 'SELECT * FROM ' . prefix("albums") . ' WHERE `parentid`' . $albumid . ' ORDER BY ' . db_escape($sortkey);
     if ($order) {
         $sql .= ' DESC';
     }
     $result = query($sql);
     $results = array();
     //	check database aganist file system
     while ($row = db_fetch_assoc($result)) {
         $folder = $row['folder'];
         if (($key = array_search($folder, $albums)) !== false) {
             // album exists in filesystem
             $results[$row['folder']] = $row;
             unset($albums[$key]);
         } else {
             // album no longer exists
             $id = $row['id'];
             query("DELETE FROM " . prefix('albums') . " WHERE `id`={$id}");
             // delete the record
             query("DELETE FROM " . prefix('comments') . " WHERE `type` ='images' AND `ownerid`= '{$id}'");
             // remove image comments
             query("DELETE FROM " . prefix('obj_to_tag') . "WHERE `type`='albums' AND `objectid`=" . $id);
             query("DELETE FROM " . prefix('albums') . " WHERE `id` = " . $id);
         }
     }
     db_free_result($result);
     foreach ($albums as $folder) {
         // these albums are not in the database
         $albumobj = newAlbum($folder);
         if ($albumobj->exists) {
             // fail to instantiate?
             $results[$folder] = $albumobj->getData();
         }
     }
     //	now put the results in the right order
     $results = sortByKey($results, $sortkey, $order);
     //	albums are now in the correct order
     $albums_ordered = array();
     foreach ($results as $row) {
         // check for visible
         $folder = $row['folder'];
         $album = newAlbum($folder);
         $subrights = $album->subrights();
         if ($mine || ($row['show'] || $viewUnpublished) || $subrights && is_null($album->getParent()) || $subrights && $subrights & MANAGED_OBJECT_RIGHTS_VIEW) {
             $albums_ordered[] = $folder;
         }
     }
     return $albums_ordered;
 }

 /**
  * Sort the album array based on either according to the sort key.
  * Default is to sort on the `sort_order` field.
  *
  * Returns an array with the albums in the desired sort order
  *
  * @param  array $albums array of album names
  * @param  string $sortkey the sorting scheme
  * @param string $sortdirection
  * @param bool $mine set true/false to override ownership
  * @return array
  *
  * @author Todd Papaioannou ([email protected])
  * @since  1.0.0
  */
 function sortAlbumArray($parentalbum, $albums, $sortkey = '`sort_order`', $sortdirection = NULL, $mine = NULL)
 {
     if (is_null($parentalbum)) {
         $albumid = ' IS NULL';
         $obj = $this;
     } else {
         $albumid = '=' . $parentalbum->id;
         $obj = $parentalbum;
     }
     if ($sortkey == '`sort_order`' || $sortkey == 'RAND()') {
         // manual sort is always ascending
         $order = false;
     } else {
         if (!is_null($sortdirection)) {
             $order = strtoupper($sortdirection) == 'DESC';
         } else {
             $order = $obj->getSortDirection('album');
         }
     }
     if (count($albums) == 0) {
         return array();
     }
     $sql = 'SELECT * FROM ' . prefix("albums") . ' WHERE `parentid`' . $albumid;
     $result = query($sql);
     $results = array();
     while ($row = db_fetch_assoc($result)) {
         $results[$row['folder']] = $row;
     }
     //	check database aganist file system
     foreach ($results as $dbrow => $row) {
         $folder = $row['folder'];
         if (($key = array_search($folder, $albums)) !== false) {
             // album exists in filesystem
             unset($albums[$key]);
         } else {
             // album no longer exists
             $id = $row['id'];
             query("DELETE FROM " . prefix('albums') . " WHERE `id`={$id}");
             // delete the record
             query("DELETE FROM " . prefix('comments') . " WHERE `type` ='images' AND `ownerid`= '{$id}'");
             // remove image comments
             query("DELETE FROM " . prefix('obj_to_tag') . "WHERE `type`='albums' AND `objectid`=" . $id);
             query("DELETE FROM " . prefix('albums') . " WHERE `id` = " . $id);
             unset($results[$dbrow]);
         }
     }
     foreach ($albums as $folder) {
         // these albums are not in the database
         $albumobj = new Album($this, $folder);
         if ($albumobj->exists) {
             // fail to instantiate?
             $results[$folder] = $albumobj->data;
         }
     }
     //	now put the results in the right order
     $results = sortByKey($results, $sortkey, $order);
     //	albums are now in the correct order
     $albums_ordered = array();
     foreach ($results as $row) {
         // check for visible
         $folder = $row['folder'];
         $album = new Album($this, $folder);
         if ($row['show'] || $mine || is_null($mine) && $album->isMyItem(LIST_RIGHTS)) {
             $albums_ordered[] = $folder;
         }
     }
     return $albums_ordered;
 }

function excerpt_matches($text, $words, $length = 100, $prefix = "...", $suffix = null, $options = array())
{
    // Set default score modifiers [tweak away...]
    $options = am(array('exact_case_bonus' => 2, 'exact_word_bonus' => 3, 'abs_length_weight' => 0.0, 'rel_length_weight' => 1.0, 'debug' => false), $options);
    // Null suffix defaults to same as prefix
    if (is_null($suffix)) {
        $suffix = $prefix;
    }
    // Not enough to work with?
    if (strlen($text) <= $length) {
        return $text;
    }
    // Just in case
    if (!is_array($words)) {
        $words = array($words);
    }
    // Build the event list
    // [also calculate maximum word length for relative weight bonus]
    $events = array();
    $maxWordLength = 0;
    foreach ($words as $word) {
        if (strlen($word) > $maxWordLength) {
            $maxWordLength = strlen($word);
        }
        $i = -1;
        while (($i = stripos($text, $word, $i + 1)) !== false) {
            // Basic score for a match is always 1
            $score = 1;
            // Apply modifiers
            if (substr($text, $i, strlen($word)) == $word) {
                // Case matches exactly
                $score += $options['exact_case_bonus'];
            }
            if ($options['abs_length_weight'] != 0.0) {
                // Absolute length weight (longer words count for more)
                $score += strlen($word) * $options['abs_length_weight'];
            }
            if ($options['rel_length_weight'] != 0.0) {
                // Relative length weight (longer words count for more)
                $score += strlen($word) / $maxWordLength * $options['rel_length_weight'];
            }
            if (preg_match('/\\W/', substr($text, $i - 1, 1))) {
                // The start of the word matches exactly
                $score += $options['exact_word_bonus'];
            }
            if (preg_match('/\\W/', substr($text, $i + strlen($word), 1))) {
                // The end of the word matches exactly
                $score += $options['exact_word_bonus'];
            }
            // Push event occurs when the word comes into range
            $events[] = array('type' => 'push', 'word' => $word, 'pos' => max(0, $i + strlen($word) - $length), 'score' => $score);
            // Pop event occurs when the word goes out of range
            $events[] = array('type' => 'pop', 'word' => $word, 'pos' => $i + 1, 'score' => $score);
            // Bump event makes it more attractive for words to be in the
            // middle of the excerpt [@todo: this needs work]
            $events[] = array('type' => 'bump', 'word' => $word, 'pos' => max(0, $i + floor(strlen($word) / 2) - floor($length / 2)), 'score' => 0.5);
        }
    }
    // If nothing is found then just truncate from the beginning
    if (empty($events)) {
        return '';
    }
    // We want to handle each event in the order it occurs in
    //
    $events = sortByKey($events, 'pos');
    $scores = array();
    $score = 0;
    $current_words = array();
    // Process each event in turn
    foreach ($events as $idx => $event) {
        $thisPos = floor($event['pos']);
        $word = strtolower($event['word']);
        switch ($event['type']) {
            case 'push':
                if (empty($current_words[$word])) {
                    // First occurence of a word gets full value
                    $current_words[$word] = 1;
                    $score += $event['score'];
                } else {
                    // Subsequent occurrences mean less and less
                    $current_words[$word]++;
                    $score += $event['score'] / sizeof($current_words[$word]);
                }
                break;
            case 'pop':
                if ($current_words[$word] == 1) {
                    unset($current_words[$word]);
                    $score -= $event['score'];
                } else {
                    $current_words[$word]--;
                    $score -= $event['score'] / sizeof($current_words[$word]);
                }
                break;
            case 'bump':
                if (!empty($event['score'])) {
                    $score += $event['score'];
                }
                break;
            default:
        }
//.........这里部分代码省略.........

function sortKeyAscending($array)
{
    echo "<br/>sortKeyAscending<br/>";
    return sortByKey($array);
}

 /**
  * Browse repository
  *
  * @param Revision $revision
  * @param string $path
  * @return array 
  */
 function browse($revision, $path = '', $peg_revision = null)
 {
     if (intval($revision) !== intval($peg_revision)) {
         $peg = !is_null($peg_revision) ? "@" . $peg_revision : '';
     } else {
         $peg = '';
     }
     // if
     $string = 'list -r ' . $revision . ' --xml ' . $this->getRealPath($path) . $peg;
     $this->execute($string);
     $list_data = xml2array(implode("\n", $this->output), 1, array('entry'));
     $list['current_dir'] = $list_data['lists']['list']['attr']['path'];
     $entries = array();
     $dirs = array();
     $files = array();
     $i = 0;
     foreach ($list_data['lists']['list']['entry'] as $entry) {
         // put dirs and files into separate arrays
         if ($entry['attr']['kind'] == 'dir') {
             $dirs[$i]['kind'] = $entry['attr']['kind'];
             $dirs[$i]['name'] = $entry['name']['value'];
             $dirs[$i]['size'] = $entry['size']['value'];
             $dirs[$i]['revision'] = $entry['commit']['attr']['revision'];
             $dirs[$i]['author'] = $entry['commit']['author']['value'];
             $dirs[$i]['date'] = new DateTimeValue($entry['commit']['date']['value']);
         } else {
             $files[$i]['kind'] = $entry['attr']['kind'];
             $files[$i]['name'] = $entry['name']['value'];
             $files[$i]['size'] = format_file_size($entry['size']['value']);
             $files[$i]['revision'] = $entry['commit']['attr']['revision'];
             $files[$i]['author'] = $entry['commit']['author']['value'];
             $files[$i]['date'] = new DateTimeValue($entry['commit']['date']['value']);
         }
         $i++;
     }
     // merge dirs and files array into one array with each of them sorted by name, but
     // directories go first
     $list['entries'] = array_merge(sortByKey($dirs, 'name'), sortByKey($files, 'name'));
     return $list;
 }