2 rcs_id('$Id: WikiDB.php,v 1.139 2006-01-12 16:38:07 rurban Exp $');
4 require_once('lib/PageType.php');
7 * The classes in the file define the interface to the
11 * @author Geoffrey T. Dairiki <dairiki@dairiki.org>
16 * Force the creation of a new revision.
17 * @see WikiDB_Page::createRevision()
19 if (!defined('WIKIDB_FORCE_CREATE'))
20 define('WIKIDB_FORCE_CREATE', -1);
23 * Abstract base class for the database used by PhpWiki.
25 * A <tt>WikiDB</tt> is a container for <tt>WikiDB_Page</tt>s which in
26 * turn contain <tt>WikiDB_PageRevision</tt>s.
28 * Conceptually a <tt>WikiDB</tt> contains all possible
29 * <tt>WikiDB_Page</tt>s, whether they have been initialized or not.
30 * Since all possible pages are already contained in a WikiDB, a call
31 * to WikiDB::getPage() will never fail (barring bugs and
32 * e.g. filesystem or SQL database problems.)
34 * Also each <tt>WikiDB_Page</tt> always contains at least one
35 * <tt>WikiDB_PageRevision</tt>: the default content (e.g. "Describe
36 * [PageName] here."). This default content has a version number of
39 * <tt>WikiDB_PageRevision</tt>s have read-only semantics. One can
40 * only create new revisions or delete old ones --- one can not modify
41 * an existing revision.
45 * Open a WikiDB database.
47 * This is a static member function. This function inspects its
48 * arguments to determine the proper subclass of WikiDB to
49 * instantiate, and then it instantiates it.
53 * @param hash $dbparams Database configuration parameters.
54 * Some pertinent paramters are:
57 * <dd> The back-end type. Current supported types are:
60 * <dd> Generic SQL backend based on the PEAR/DB database abstraction
61 * library. (More stable and conservative)
63 * <dd> Another generic SQL backend. (More current features are tested here. Much faster)
65 * <dd> Dba based backend. The default and by far the fastest.
73 * <dd> (Used by the SQL and ADODB backends.)
74 * The DSN specifying which database to connect to.
77 * <dd> Prefix to be prepended to database tables (and file names).
80 * <dd> (Used by the dba backend.)
81 * Which directory db files reside in.
84 * <dd> Used only by the dba backend so far.
85 * And: When optimizing mysql it closes timed out mysql processes.
86 * otherwise only used for dba: Timeout in seconds for opening (and
87 * obtaining lock) on the dbm file.
90 * <dd> (Used by the dba backend.)
92 * Which dba handler to use. Good choices are probably either
96 * @return WikiDB A WikiDB object.
98 function open ($dbparams) {
99 $dbtype = $dbparams{'dbtype'};
100 include_once("lib/WikiDB/$dbtype.php");
102 $class = 'WikiDB_' . $dbtype;
103 return new $class ($dbparams);
113 function WikiDB (&$backend, $dbparams) {
114 $this->_backend = &$backend;
115 // don't do the following with the auth_dsn!
116 if (isset($dbparams['auth_dsn'])) return;
118 $this->_cache = new WikiDB_cache($backend);
119 if (!empty($GLOBALS['request'])) $GLOBALS['request']->_dbi = $this;
121 // If the database doesn't yet have a timestamp, initialize it now.
122 if ($this->get('_timestamp') === false)
125 //FIXME: devel checking.
126 //$this->_backend->check();
130 * Close database connection.
132 * The database may no longer be used after it is closed.
134 * Closing a WikiDB invalidates all <tt>WikiDB_Page</tt>s,
135 * <tt>WikiDB_PageRevision</tt>s and <tt>WikiDB_PageIterator</tt>s
136 * which have been obtained from it.
141 $this->_backend->close();
142 $this->_cache->close();
146 * Get a WikiDB_Page from a WikiDB.
148 * A {@link WikiDB} consists of the (infinite) set of all possible pages,
149 * therefore this method never fails.
152 * @param string $pagename Which page to get.
153 * @return WikiDB_Page The requested WikiDB_Page.
155 function getPage($pagename) {
156 static $error_displayed = false;
157 $pagename = (string) $pagename;
159 if ($pagename === '') {
160 if ($error_displayed) return false;
161 $error_displayed = true;
162 if (function_exists("xdebug_get_function_stack"))
163 var_dump(xdebug_get_function_stack());
164 trigger_error("empty pagename", E_USER_WARNING);
168 assert($pagename != '');
170 return new WikiDB_Page($this, $pagename);
174 * Determine whether page exists (in non-default form).
177 * $is_page = $dbi->isWikiPage($pagename);
181 * $page = $dbi->getPage($pagename);
182 * $current = $page->getCurrentRevision();
183 * $is_page = ! $current->hasDefaultContents();
185 * however isWikiPage may be implemented in a more efficient
186 * manner in certain back-ends.
190 * @param string $pagename string Which page to check.
192 * @return boolean True if the page actually exists with
193 * non-default contents in the WikiDataBase.
195 function isWikiPage ($pagename) {
196 $page = $this->getPage($pagename);
197 return $page->exists();
201 * Delete page from the WikiDB.
203 * Deletes the page from the WikiDB with the possibility to revert and diff.
204 * //Also resets all page meta-data to the default values.
206 * Note: purgePage() effectively destroys all revisions of the page from the WikiDB.
210 * @param string $pagename Name of page to delete.
212 function deletePage($pagename) {
213 // don't create empty revisions of already purged pages.
214 if ($this->_backend->get_latest_version($pagename))
215 $result = $this->_cache->delete_page($pagename);
219 /* Generate notification emails? */
220 if (! $this->isWikiPage($pagename) and !isa($GLOBALS['request'],'MockRequest')) {
221 $notify = $this->get('notify');
222 if (!empty($notify) and is_array($notify)) {
224 //TODO: deferr it (quite a massive load if you remove some pages).
225 //TODO: notification class which catches all changes,
226 // and decides at the end of the request what to mail.
227 // (type, page, who, what, users, emails)
228 // could be used for PageModeration and RSS2 Cloud xml-rpc also.
229 $page = new WikiDB_Page($this, $pagename);
230 list($emails, $userids) = $page->getPageChangeEmails($notify);
231 if (!empty($emails)) {
232 $from = $request->_user->getId() . '@' . $request->get('REMOTE_HOST');
233 $editedby = sprintf(_("Removed by: %s"), $from);
234 $emails = join(',', $emails);
235 $subject = sprintf(_("Page removed %s"), urlencode($pagename));
236 if (mail("<undisclosed-recipients>","[".WIKI_NAME."] ".$subject,
240 "From: $from\r\nBcc: $emails"))
241 trigger_error(sprintf(_("PageChange Notification of %s sent to %s"),
242 $pagename, join(',',$userids)), E_USER_NOTICE);
244 trigger_error(sprintf(_("PageChange Notification Error: Couldn't send %s to %s"),
245 $pagename, join(',',$userids)), E_USER_WARNING);
250 //How to create a RecentChanges entry with explaining summary? Dynamically
252 $page = $this->getPage($pagename);
253 $current = $page->getCurrentRevision();
254 $meta = $current->_data;
255 $version = $current->getVersion();
256 $meta['summary'] = _("removed");
257 $page->save($current->getPackedContent(), $version + 1, $meta);
263 * Completely remove the page from the WikiDB, without undo possibility.
265 function purgePage($pagename) {
266 $result = $this->_cache->purge_page($pagename);
267 $this->deletePage($pagename); // just for the notification
272 * Retrieve all pages.
274 * Gets the set of all pages with non-default contents.
278 * @param boolean $include_defaulted Normally pages whose most
279 * recent revision has empty content are considered to be
280 * non-existant. Unless $include_defaulted is set to true, those
281 * pages will not be returned.
283 * @return WikiDB_PageIterator A WikiDB_PageIterator which contains all pages
284 * in the WikiDB which have non-default contents.
286 function getAllPages($include_empty=false, $sortby=false, $limit=false,
289 // HACK: memory_limit=8M will fail on too large pagesets. old php on unix only!
291 $mem = ini_get("memory_limit");
292 if ($mem and !$limit and !isWindows() and !check_php_version(4,3)) {
294 $GLOBALS['request']->setArg('limit', $limit);
295 $GLOBALS['request']->setArg('paging', 'auto');
298 $result = $this->_backend->get_all_pages($include_empty, $sortby, $limit,
300 return new WikiDB_PageIterator($this, $result,
301 array('include_empty' => $include_empty,
302 'exclude' => $exclude,
307 * $include_empty = true: include also empty pages
308 * exclude: comma-seperated list pagenames: TBD: array of pagenames
310 function numPages($include_empty=false, $exclude='') {
311 if (method_exists($this->_backend, 'numPages'))
312 // FIXME: currently are all args ignored.
313 $count = $this->_backend->numPages($include_empty, $exclude);
315 // FIXME: exclude ignored.
316 $iter = $this->getAllPages($include_empty, false, false, $exclude);
317 $count = $iter->count();
326 * Search for pages containing (or not containing) certain words
329 * Pages are returned in alphabetical order whenever it is
330 * practical to do so.
332 * FIXME: clarify $search syntax. provide glob=>TextSearchQuery converters
335 * @param TextSearchQuery $search A TextSearchQuery object
336 * @return WikiDB_PageIterator A WikiDB_PageIterator containing the matching pages.
337 * @see TextSearchQuery
339 function titleSearch($search, $sortby='pagename', $limit=false, $exclude=false) {
340 $result = $this->_backend->text_search($search, false, $sortby, $limit, $exclude);
341 return new WikiDB_PageIterator($this, $result,
342 array('exclude' => $exclude,
349 * Search for pages containing (or not containing) certain words
350 * in their entire text (this includes the page content and the
353 * Pages are returned in alphabetical order whenever it is
354 * practical to do so.
358 * @param TextSearchQuery $search A TextSearchQuery object.
359 * @return WikiDB_PageIterator A WikiDB_PageIterator containing the matching pages.
360 * @see TextSearchQuery
362 function fullSearch($search, $sortby='pagename', $limit=false, $exclude=false) {
363 $result = $this->_backend->text_search($search, true, $sortby, $limit, $exclude);
364 return new WikiDB_PageIterator($this, $result,
365 array('exclude' => $exclude,
367 'stoplisted' => $result->stoplisted
372 * Find the pages with the greatest hit counts.
374 * Pages are returned in reverse order by hit count.
378 * @param integer $limit The maximum number of pages to return.
379 * Set $limit to zero to return all pages. If $limit < 0, pages will
380 * be sorted in decreasing order of popularity.
382 * @return WikiDB_PageIterator A WikiDB_PageIterator containing the matching
385 function mostPopular($limit = 20, $sortby = '-hits') {
386 $result = $this->_backend->most_popular($limit, $sortby);
387 return new WikiDB_PageIterator($this, $result);
391 * Find recent page revisions.
393 * Revisions are returned in reverse order by creation time.
397 * @param hash $params This hash is used to specify various optional
401 * <dd> (integer) At most this many revisions will be returned.
403 * <dd> (integer) Only revisions since this time (unix-timestamp) will be returned.
404 * <dt> include_minor_revisions
405 * <dd> (boolean) Also include minor revisions. (Default is not to.)
406 * <dt> exclude_major_revisions
407 * <dd> (boolean) Don't include non-minor revisions.
408 * (Exclude_major_revisions implies include_minor_revisions.)
409 * <dt> include_all_revisions
410 * <dd> (boolean) Return all matching revisions for each page.
411 * Normally only the most recent matching revision is returned
415 * @return WikiDB_PageRevisionIterator A WikiDB_PageRevisionIterator containing the
416 * matching revisions.
418 function mostRecent($params = false) {
419 $result = $this->_backend->most_recent($params);
420 return new WikiDB_PageRevisionIterator($this, $result);
426 * @return Iterator A generic iterator containing rows of (duplicate) pagename, wantedfrom.
428 function wantedPages($exclude_from='', $exclude='', $sortby=false, $limit=false) {
429 return $this->_backend->wanted_pages($exclude_from, $exclude, $sortby, $limit);
430 //return new WikiDB_PageIterator($this, $result);
436 * @return array rows of pagenames.
438 function listRelations() {
439 if (method_exists($this->_backend, "list_relations"))
440 return $this->_backend->list_relations();
441 $iter = $this->getAllPages(false, false, false, $exclude);
442 while ($page = $iter->next()) {
443 $reliter = $page->getRelations();
445 while ($rel = $reliter->next()) {
446 $names[] = $rel->getName();
448 $relations = array_merge($relations, $names);
456 * Call the appropriate backend method.
459 * @param string $from Page to rename
460 * @param string $to New name
461 * @param boolean $updateWikiLinks If the text in all pages should be replaced.
462 * @return boolean true or false
464 function renamePage($from, $to, $updateWikiLinks = false) {
465 assert(is_string($from) && $from != '');
466 assert(is_string($to) && $to != '');
468 if (method_exists($this->_backend, 'rename_page')) {
469 $oldpage = $this->getPage($from);
470 $newpage = $this->getPage($to);
471 //update all WikiLinks in existing pages
472 //non-atomic! i.e. if rename fails the links are not undone
473 if ($updateWikiLinks) {
474 require_once('lib/plugin/WikiAdminSearchReplace.php');
475 $links = $oldpage->getBackLinks();
476 while ($linked_page = $links->next()) {
477 WikiPlugin_WikiAdminSearchReplace::replaceHelper($this,
478 $linked_page->getName(),
481 $links = $newpage->getBackLinks();
482 while ($linked_page = $links->next()) {
483 WikiPlugin_WikiAdminSearchReplace::replaceHelper($this,
484 $linked_page->getName(),
488 if ($oldpage->exists() and ! $newpage->exists()) {
489 if ($result = $this->_backend->rename_page($from, $to)) {
490 //create a RecentChanges entry with explaining summary
491 $page = $this->getPage($to);
492 $current = $page->getCurrentRevision();
493 $meta = $current->_data;
494 $version = $current->getVersion();
495 $meta['summary'] = sprintf(_("renamed from %s"), $from);
496 $page->save($current->getPackedContent(), $version + 1, $meta);
498 } elseif (!$oldpage->getCurrentRevision(false) and !$newpage->exists()) {
499 // if a version 0 exists try it also.
500 $result = $this->_backend->rename_page($from, $to);
503 trigger_error(_("WikiDB::renamePage() not yet implemented for this backend"),
506 /* Generate notification emails? */
507 if ($result and !isa($GLOBALS['request'], 'MockRequest')) {
508 $notify = $this->get('notify');
509 if (!empty($notify) and is_array($notify)) {
510 list($emails, $userids) = $oldpage->getPageChangeEmails($notify);
511 if (!empty($emails)) {
512 $oldpage->sendPageRenameNotification($to, $meta, $emails, $userids);
519 /** Get timestamp when database was last modified.
521 * @return string A string consisting of two integers,
522 * separated by a space. The first is the time in
523 * unix timestamp format, the second is a modification
524 * count for the database.
526 * The idea is that you can cast the return value to an
527 * int to get a timestamp, or you can use the string value
528 * as a good hash for the entire database.
530 function getTimestamp() {
531 $ts = $this->get('_timestamp');
532 return sprintf("%d %d", $ts[0], $ts[1]);
536 * Update the database timestamp.
540 $ts = $this->get('_timestamp');
541 $this->set('_timestamp', array(time(), $ts[1] + 1));
546 * Access WikiDB global meta-data.
548 * NOTE: this is currently implemented in a hackish and
549 * not very efficient manner.
553 * @param string $key Which meta data to get.
554 * Some reserved meta-data keys are:
556 * <dt>'_timestamp' <dd> Data used by getTimestamp().
559 * @return scalar The requested value, or false if the requested data
563 if (!$key || $key[0] == '%')
566 * Hack Alert: We can use any page (existing or not) to store
567 * this data (as long as we always use the same one.)
569 $gd = $this->getPage('global_data');
570 $data = $gd->get('__global');
572 if ($data && isset($data[$key]))
579 * Set global meta-data.
581 * NOTE: this is currently implemented in a hackish and
582 * not very efficient manner.
587 * @param string $key Meta-data key to set.
588 * @param string $newval New value.
590 function set($key, $newval) {
591 if (!$key || $key[0] == '%')
594 $gd = $this->getPage('global_data');
595 $data = $gd->get('__global');
602 $data[$key] = $newval;
604 $gd->set('__global', $data);
607 /* TODO: these are really backend methods */
609 // SQL result: for simple select or create/update queries
610 // returns the database specific resource type
611 function genericSqlQuery($sql, $args=false) {
612 if (function_exists('debug_backtrace')) { // >= 4.3.0
613 echo "<pre>", printSimpleTrace(debug_backtrace()), "</pre>\n";
615 trigger_error("no SQL database", E_USER_ERROR);
619 // SQL iter: for simple select or create/update queries
620 // returns the generic iterator object (count,next)
621 function genericSqlIter($sql, $field_list = NULL) {
622 if (function_exists('debug_backtrace')) { // >= 4.3.0
623 echo "<pre>", printSimpleTrace(debug_backtrace()), "</pre>\n";
625 trigger_error("no SQL database", E_USER_ERROR);
629 // see backend upstream methods
630 // ADODB adds surrounding quotes, SQL not yet!
631 function quote ($s) {
637 if (!$request->_dbi) return false;
638 else return false; /* so far only needed for sql so false it.
639 later we have to check dba also */
642 function getParam($param) {
644 if (isset($DBParams[$param])) return $DBParams[$param];
645 elseif ($param == 'prefix') return '';
649 function getAuthParam($param) {
650 global $DBAuthParams;
651 if (isset($DBAuthParams[$param])) return $DBAuthParams[$param];
652 elseif ($param == 'USER_AUTH_ORDER') return $GLOBALS['USER_AUTH_ORDER'];
653 elseif ($param == 'USER_AUTH_POLICY') return $GLOBALS['USER_AUTH_POLICY'];
660 * An abstract base class which representing a wiki-page within a
663 * A WikiDB_Page contains a number (at least one) of
664 * WikiDB_PageRevisions.
668 function WikiDB_Page(&$wikidb, $pagename) {
669 $this->_wikidb = &$wikidb;
670 $this->_pagename = $pagename;
672 if (!(is_string($pagename) and $pagename != '')) {
673 if (function_exists("xdebug_get_function_stack")) {
674 echo "xdebug_get_function_stack(): "; var_dump(xdebug_get_function_stack());
675 } elseif (function_exists("debug_backtrace")) { // >= 4.3.0
676 printSimpleTrace(debug_backtrace());
678 trigger_error("empty pagename", E_USER_WARNING);
682 assert(is_string($pagename) and $pagename != '');
687 * Get the name of the wiki page.
691 * @return string The page name.
694 return $this->_pagename;
697 // To reduce the memory footprint for larger sets of pagelists,
698 // we don't cache the content (only true or false) and
699 // we purge the pagedata (_cached_html) also
701 if (isset($this->_wikidb->_cache->_id_cache[$this->_pagename])) return true;
702 $current = $this->getCurrentRevision(false);
703 if (!$current) return false;
704 return ! $current->hasDefaultContents();
708 * Delete an old revision of a WikiDB_Page.
710 * Deletes the specified revision of the page.
711 * It is a fatal error to attempt to delete the current revision.
715 * @param integer $version Which revision to delete. (You can also
716 * use a WikiDB_PageRevision object here.)
718 function deleteRevision($version) {
719 $backend = &$this->_wikidb->_backend;
720 $cache = &$this->_wikidb->_cache;
721 $pagename = &$this->_pagename;
723 $version = $this->_coerce_to_version($version);
727 $backend->lock(array('page','version'));
728 $latestversion = $cache->get_latest_version($pagename);
729 if ($latestversion && ($version == $latestversion)) {
730 $backend->unlock(array('page','version'));
731 trigger_error(sprintf("Attempt to delete most recent revision of '%s'",
732 $pagename), E_USER_ERROR);
736 $cache->delete_versiondata($pagename, $version);
737 $backend->unlock(array('page','version'));
741 * Delete a revision, or possibly merge it with a previous
745 * Suppose an author make a (major) edit to a page. Shortly
746 * after that the same author makes a minor edit (e.g. to fix
747 * spelling mistakes he just made.)
749 * Now some time later, where cleaning out old saved revisions,
750 * and would like to delete his minor revision (since there's
751 * really no point in keeping minor revisions around for a long
754 * Note that the text after the minor revision probably represents
755 * what the author intended to write better than the text after
756 * the preceding major edit.
758 * So what we really want to do is merge the minor edit with the
761 * We will only do this when:
763 * <li>The revision being deleted is a minor one, and
764 * <li>It has the same author as the immediately preceding revision.
767 function mergeRevision($version) {
768 $backend = &$this->_wikidb->_backend;
769 $cache = &$this->_wikidb->_cache;
770 $pagename = &$this->_pagename;
772 $version = $this->_coerce_to_version($version);
776 $backend->lock(array('version'));
777 $latestversion = $cache->get_latest_version($pagename);
778 if ($latestversion && $version == $latestversion) {
779 $backend->unlock(array('version'));
780 trigger_error(sprintf("Attempt to merge most recent revision of '%s'",
781 $pagename), E_USER_ERROR);
785 $versiondata = $cache->get_versiondata($pagename, $version, true);
787 // Not there? ... we're done!
788 $backend->unlock(array('version'));
792 if ($versiondata['is_minor_edit']) {
793 $previous = $backend->get_previous_version($pagename, $version);
795 $prevdata = $cache->get_versiondata($pagename, $previous);
796 if ($prevdata['author_id'] == $versiondata['author_id']) {
797 // This is a minor revision, previous version is
798 // by the same author. We will merge the
800 $cache->update_versiondata($pagename, $previous,
801 array('%content' => $versiondata['%content'],
802 '_supplanted' => $versiondata['_supplanted']));
807 $cache->delete_versiondata($pagename, $version);
808 $backend->unlock(array('version'));
813 * Create a new revision of a {@link WikiDB_Page}.
817 * @param int $version Version number for new revision.
818 * To ensure proper serialization of edits, $version must be
819 * exactly one higher than the current latest version.
820 * (You can defeat this check by setting $version to
821 * {@link WIKIDB_FORCE_CREATE} --- not usually recommended.)
823 * @param string $content Contents of new revision.
825 * @param hash $metadata Metadata for new revision.
826 * All values in the hash should be scalars (strings or integers).
828 * @param hash $links List of linkto=>pagename, relation=>pagename which this page links to.
830 * @return WikiDB_PageRevision Returns the new WikiDB_PageRevision object. If
831 * $version was incorrect, returns false
833 function createRevision($version, &$content, $metadata, $links) {
834 $backend = &$this->_wikidb->_backend;
835 $cache = &$this->_wikidb->_cache;
836 $pagename = &$this->_pagename;
837 $cache->invalidate_cache($pagename);
839 $backend->lock(array('version','page','recent','link','nonempty'));
841 $latestversion = $backend->get_latest_version($pagename);
842 $newversion = ($latestversion ? $latestversion : 0) + 1;
843 assert($newversion >= 1);
845 if ($version != WIKIDB_FORCE_CREATE and $version != $newversion) {
846 $backend->unlock(array('version','page','recent','link','nonempty'));
852 foreach ($data as $key => $val) {
853 if (empty($val) || $key[0] == '_' || $key[0] == '%')
857 assert(!empty($data['author']));
858 if (empty($data['author_id']))
859 @$data['author_id'] = $data['author'];
861 if (empty($data['mtime']))
862 $data['mtime'] = time();
864 if ($latestversion and $version != WIKIDB_FORCE_CREATE) {
865 // Ensure mtimes are monotonic.
866 $pdata = $cache->get_versiondata($pagename, $latestversion);
867 if ($data['mtime'] < $pdata['mtime']) {
868 trigger_error(sprintf(_("%s: Date of new revision is %s"),
869 $pagename,"'non-monotonic'"),
871 $data['orig_mtime'] = $data['mtime'];
872 $data['mtime'] = $pdata['mtime'];
875 // FIXME: use (possibly user specified) 'mtime' time or
877 $cache->update_versiondata($pagename, $latestversion,
878 array('_supplanted' => $data['mtime']));
881 $data['%content'] = &$content;
883 $cache->set_versiondata($pagename, $newversion, $data);
885 //$cache->update_pagedata($pagename, array(':latestversion' => $newversion,
886 //':deleted' => empty($content)));
888 $backend->set_links($pagename, $links);
890 $backend->unlock(array('version','page','recent','link','nonempty'));
892 return new WikiDB_PageRevision($this->_wikidb, $pagename, $newversion,
896 /** A higher-level interface to createRevision.
898 * This takes care of computing the links, and storing
899 * a cached version of the transformed wiki-text.
901 * @param string $wikitext The page content.
903 * @param int $version Version number for new revision.
904 * To ensure proper serialization of edits, $version must be
905 * exactly one higher than the current latest version.
906 * (You can defeat this check by setting $version to
907 * {@link WIKIDB_FORCE_CREATE} --- not usually recommended.)
909 * @param hash $meta Meta-data for new revision.
911 function save($wikitext, $version, $meta) {
912 $formatted = new TransformedText($this, $wikitext, $meta);
913 $type = $formatted->getType();
914 $meta['pagetype'] = $type->getName();
915 $links = $formatted->getWikiPageLinks();
917 $backend = &$this->_wikidb->_backend;
918 $newrevision = $this->createRevision($version, $wikitext, $meta, $links);
919 if ($newrevision and !WIKIDB_NOCACHE_MARKUP)
920 $this->set('_cached_html', $formatted->pack());
922 // FIXME: probably should have some global state information
923 // in the backend to control when to optimize.
925 // We're doing this here rather than in createRevision because
926 // postgres can't optimize while locked.
927 if ((DEBUG & _DEBUG_SQL) or (time() % 5 == 0)) {
928 if ($backend->optimize())
929 trigger_error(_("Optimizing database"), E_USER_NOTICE);
932 /* Generate notification emails? */
933 if (isa($newrevision, 'WikiDB_PageRevision')) {
934 // Save didn't fail because of concurrent updates.
935 $notify = $this->_wikidb->get('notify');
936 if (!empty($notify) and is_array($notify) and !isa($GLOBALS['request'],'MockRequest')) {
937 list($emails, $userids) = $this->getPageChangeEmails($notify);
938 if (!empty($emails)) {
939 $this->sendPageChangeNotification($wikitext, $version, $meta, $emails, $userids);
942 $newrevision->_transformedContent = $formatted;
948 function getPageChangeEmails($notify) {
949 $emails = array(); $userids = array();
950 foreach ($notify as $page => $users) {
951 if (glob_match($page, $this->_pagename)) {
952 foreach ($users as $userid => $user) {
953 if (!$user) { // handle the case for ModeratePage: no prefs, just userid's.
955 $u = $request->getUser();
956 if ($u->UserName() == $userid) {
957 $prefs = $u->getPreferences();
960 if (ENABLE_USER_NEW) {
961 $u = WikiUser($userid);
962 $u->getPreferences();
963 $prefs = &$u->_prefs;
965 $u = new WikiUser($GLOBALS['request'], $userid);
966 $prefs = $u->getPreferences();
969 $emails[] = $prefs->get('email');
970 $userids[] = $userid;
972 if (!empty($user['verified']) and !empty($user['email'])) {
973 $emails[] = $user['email'];
974 $userids[] = $userid;
975 } elseif (!empty($user['email'])) {
977 // do a dynamic emailVerified check update
978 $u = $request->getUser();
979 if ($u->UserName() == $userid) {
980 if ($request->_prefs->get('emailVerified')) {
981 $emails[] = $user['email'];
982 $userids[] = $userid;
983 $notify[$page][$userid]['verified'] = 1;
984 $request->_dbi->set('notify', $notify);
988 if (ENABLE_USER_NEW) {
989 $u = WikiUser($userid);
990 $u->getPreferences();
991 $prefs = &$u->_prefs;
993 $u = new WikiUser($GLOBALS['request'], $userid);
994 $prefs = $u->getPreferences();
996 if ($prefs->get('emailVerified')) {
997 $emails[] = $user['email'];
998 $userids[] = $userid;
999 $notify[$page][$userid]['verified'] = 1;
1000 $request->_dbi->set('notify', $notify);
1003 // ignore verification
1006 if (!in_array($user['email'],$emails))
1007 $emails[] = $user['email'];
1015 $emails = array_unique($emails);
1016 $userids = array_unique($userids);
1017 return array($emails, $userids);
1021 * Send udiff for a changed page to multiple users.
1022 * See rename and remove methods also
1024 function sendPageChangeNotification(&$wikitext, $version, $meta, $emails, $userids) {
1026 if (@is_array($request->_deferredPageChangeNotification)) {
1027 // collapse multiple changes (loaddir) into one email
1028 $request->_deferredPageChangeNotification[]
1029 = array($this->_pagename, $emails, $userids);
1032 $backend = &$this->_wikidb->_backend;
1033 //$backend = &$request->_dbi->_backend;
1034 $subject = _("Page change").' '.urlencode($this->_pagename);
1035 $previous = $backend->get_previous_version($this->_pagename, $version);
1036 if (!isset($meta['mtime'])) $meta['mtime'] = time();
1038 $difflink = WikiURL($this->_pagename, array('action'=>'diff'), true);
1039 $cache = &$this->_wikidb->_cache;
1040 //$cache = &$request->_dbi->_cache;
1041 $this_content = explode("\n", $wikitext);
1042 $prevdata = $cache->get_versiondata($this->_pagename, $previous, true);
1043 if (empty($prevdata['%content']))
1044 $prevdata = $backend->get_versiondata($this->_pagename, $previous, true);
1045 $other_content = explode("\n", $prevdata['%content']);
1047 include_once("lib/difflib.php");
1048 $diff2 = new Diff($other_content, $this_content);
1049 //$context_lines = max(4, count($other_content) + 1,
1050 // count($this_content) + 1);
1051 $fmt = new UnifiedDiffFormatter(/*$context_lines*/);
1052 $content = $this->_pagename . " " . $previous . " " .
1053 Iso8601DateTime($prevdata['mtime']) . "\n";
1054 $content .= $this->_pagename . " " . $version . " " .
1055 Iso8601DateTime($meta['mtime']) . "\n";
1056 $content .= $fmt->format($diff2);
1059 $difflink = WikiURL($this->_pagename,array(),true);
1060 $content = $this->_pagename . " " . $version . " " .
1061 Iso8601DateTime($meta['mtime']) . "\n";
1062 $content .= _("New page");
1064 $from = $request->_user->getId() . '@' . $request->get('REMOTE_HOST');
1065 $editedby = sprintf(_("Edited by: %s"), $from);
1066 $emails = join(',',$emails);
1067 if (mail("<undisclosed-recipients>",
1068 "[".WIKI_NAME."] ".$subject,
1069 $subject."\n". $editedby."\n". $difflink."\n\n". $content,
1070 "From: $from\r\nBcc: $emails"))
1071 trigger_error(sprintf(_("PageChange Notification of %s sent to %s"),
1072 $this->_pagename, join(',',$userids)), E_USER_NOTICE);
1074 trigger_error(sprintf(_("PageChange Notification Error: Couldn't send %s to %s"),
1075 $this->_pagename, join(',',$userids)), E_USER_WARNING);
1078 /** support mass rename / remove (not yet tested)
1080 function sendPageRenameNotification($to, &$meta, $emails, $userids) {
1082 if (@is_array($request->_deferredPageRenameNotification)) {
1083 $request->_deferredPageRenameNotification[] = array($this->_pagename,
1084 $to, $meta, $emails, $userids);
1086 $oldname = $this->_pagename;
1087 $from = $request->_user->getId() . '@' . $request->get('REMOTE_HOST');
1088 $editedby = sprintf(_("Edited by: %s"), $from);
1089 $emails = join(',',$emails);
1090 $subject = sprintf(_("Page rename %s to %s"), urlencode($oldname), urlencode($to));
1091 $link = WikiURL($to, true);
1092 if (mail("<undisclosed-recipients>",
1093 "[".WIKI_NAME."] ".$subject,
1094 $subject."\n".$editedby."\n".$link."\n\n"."Renamed $from to $to",
1095 "From: $from\r\nBcc: $emails"))
1096 trigger_error(sprintf(_("PageChange Notification of %s sent to %s"),
1097 $oldname, join(',',$userids)), E_USER_NOTICE);
1099 trigger_error(sprintf(_("PageChange Notification Error: Couldn't send %s to %s"),
1100 $oldname, join(',',$userids)), E_USER_WARNING);
1105 * Get the most recent revision of a page.
1109 * @return WikiDB_PageRevision The current WikiDB_PageRevision object.
1111 function getCurrentRevision ($need_content = true) {
1112 $backend = &$this->_wikidb->_backend;
1113 $cache = &$this->_wikidb->_cache;
1114 $pagename = &$this->_pagename;
1116 // Prevent deadlock in case of memory exhausted errors
1117 // Pure selection doesn't really need locking here.
1118 // sf.net bug#927395
1119 // I know it would be better to lock, but with lots of pages this deadlock is more
1120 // severe than occasionally get not the latest revision.
1121 // In spirit to wikiwiki: read fast, edit slower.
1123 $version = $cache->get_latest_version($pagename);
1124 // getRevision gets the content also!
1125 $revision = $this->getRevision($version, $need_content);
1126 //$backend->unlock();
1132 * Get a specific revision of a WikiDB_Page.
1136 * @param integer $version Which revision to get.
1138 * @return WikiDB_PageRevision The requested WikiDB_PageRevision object, or
1139 * false if the requested revision does not exist in the {@link WikiDB}.
1140 * Note that version zero of any page always exists.
1142 function getRevision ($version, $need_content=true) {
1143 $cache = &$this->_wikidb->_cache;
1144 $pagename = &$this->_pagename;
1146 if (! $version or $version == -1) // 0 or false
1147 return new WikiDB_PageRevision($this->_wikidb, $pagename, 0);
1149 assert($version > 0);
1150 $vdata = $cache->get_versiondata($pagename, $version, $need_content);
1152 return new WikiDB_PageRevision($this->_wikidb, $pagename, 0);
1154 return new WikiDB_PageRevision($this->_wikidb, $pagename, $version,
1159 * Get previous page revision.
1161 * This method find the most recent revision before a specified
1166 * @param integer $version Find most recent revision before this version.
1167 * You can also use a WikiDB_PageRevision object to specify the $version.
1169 * @return WikiDB_PageRevision The requested WikiDB_PageRevision object, or false if the
1170 * requested revision does not exist in the {@link WikiDB}. Note that
1171 * unless $version is greater than zero, a revision (perhaps version zero,
1172 * the default revision) will always be found.
1174 function getRevisionBefore ($version=false, $need_content=true) {
1175 $backend = &$this->_wikidb->_backend;
1176 $pagename = &$this->_pagename;
1177 if ($version === false)
1178 $version = $this->_wikidb->_cache->get_latest_version($pagename);
1180 $version = $this->_coerce_to_version($version);
1185 $previous = $backend->get_previous_version($pagename, $version);
1186 $revision = $this->getRevision($previous, $need_content);
1187 //$backend->unlock();
1193 * Get all revisions of the WikiDB_Page.
1195 * This does not include the version zero (default) revision in the
1196 * returned revision set.
1198 * @return WikiDB_PageRevisionIterator A
1199 * WikiDB_PageRevisionIterator containing all revisions of this
1200 * WikiDB_Page in reverse order by version number.
1202 function getAllRevisions() {
1203 $backend = &$this->_wikidb->_backend;
1204 $revs = $backend->get_all_revisions($this->_pagename);
1205 return new WikiDB_PageRevisionIterator($this->_wikidb, $revs);
1209 * Find pages which link to or are linked from a page.
1213 * @param boolean $reversed Which links to find: true for backlinks (default).
1215 * @return WikiDB_PageIterator A WikiDB_PageIterator containing
1216 * all matching pages.
1218 function getLinks ($reversed = true, $include_empty=false, $sortby=false,
1219 $limit=false, $exclude=false) {
1220 $backend = &$this->_wikidb->_backend;
1221 $result = $backend->get_links($this->_pagename, $reversed,
1222 $include_empty, $sortby, $limit, $exclude);
1223 return new WikiDB_PageIterator($this->_wikidb, $result,
1224 array('include_empty' => $include_empty,
1225 'sortby' => $sortby,
1227 'exclude' => $exclude));
1231 * All Links from other pages to this page.
1233 function getBackLinks($include_empty=false, $sortby=false, $limit=false, $exclude=false) {
1234 return $this->getLinks(true, $include_empty, $sortby, $limit, $exclude);
1237 * Forward Links: All Links from this page to other pages.
1239 function getPageLinks($include_empty=false, $sortby=false, $limit=false, $exclude=false) {
1240 return $this->getLinks(false, $include_empty, $sortby, $limit, $exclude);
1243 * Relations: All links from this page to other pages with relation <> 0.
1246 function getRelations($sortby=false, $limit=false, $exclude=false) {
1247 $backend = &$this->_wikidb->_backend;
1248 $result = $backend->get_links($this->_pagename, false, true,
1249 $sortby, $limit, $exclude,
1251 // we do not care for the linked page versiondata, just the pagename and relationname
1252 return new WikiDB_PageIterator($this->_wikidb, $result,
1253 array('include_empty' => true,
1254 'sortby' => $sortby,
1256 'exclude' => $exclude));
1260 * possibly faster link existance check. not yet accelerated.
1262 function existLink($link, $reversed=false) {
1263 $backend = &$this->_wikidb->_backend;
1264 if (method_exists($backend,'exists_link'))
1265 return $backend->exists_link($this->_pagename, $link, $reversed);
1266 //$cache = &$this->_wikidb->_cache;
1267 // TODO: check cache if it is possible
1268 $iter = $this->getLinks($reversed, false);
1269 while ($page = $iter->next()) {
1270 if ($page->getName() == $link)
1277 /* Semantic relations are links with the relation pointing to another page,
1278 the so called "RDF Triple".
1279 [San Diego] is%20a::city
1280 => "At the page San Diego there is a relation link of 'is a' to the page 'city'."
1283 /* Semantic attributes for a page.
1284 [San Diego] population:=1,305,736
1285 Attributes are links with the relation pointing to another page.
1289 * Access WikiDB_Page non version-specific meta-data.
1293 * @param string $key Which meta data to get.
1294 * Some reserved meta-data keys are:
1296 * <dt>'date' <dd> Created as unixtime
1297 * <dt>'locked'<dd> Is page locked? 'yes' or 'no'
1298 * <dt>'hits' <dd> Page hit counter.
1299 * <dt>'_cached_html' <dd> Transformed CachedMarkup object, serialized + optionally gzipped.
1300 * In SQL stored now in an extra column.
1302 * <dt>'pref' <dd> Users preferences, stored only in homepages.
1303 * <dt>'owner' <dd> Default: first author_id. We might add a group with a dot here:
1304 * E.g. "owner.users"
1305 * <dt>'perm' <dd> Permission flag to authorize read/write/execution of
1306 * page-headers and content.
1307 + <dt>'moderation'<dd> ModeratedPage data
1308 * <dt>'score' <dd> Page score (not yet implement, do we need?)
1311 * @return scalar The requested value, or false if the requested data
1314 function get($key) {
1315 $cache = &$this->_wikidb->_cache;
1316 $backend = &$this->_wikidb->_backend;
1317 if (!$key || $key[0] == '%')
1319 // several new SQL backends optimize this.
1320 if (!WIKIDB_NOCACHE_MARKUP
1321 and $key == '_cached_html'
1322 and method_exists($backend, 'get_cached_html'))
1324 return $backend->get_cached_html($this->_pagename);
1326 $data = $cache->get_pagedata($this->_pagename);
1327 return isset($data[$key]) ? $data[$key] : false;
1331 * Get all the page meta-data as a hash.
1333 * @return hash The page meta-data.
1335 function getMetaData() {
1336 $cache = &$this->_wikidb->_cache;
1337 $data = $cache->get_pagedata($this->_pagename);
1339 foreach ($data as $key => $val) {
1340 if (/*!empty($val) &&*/ $key[0] != '%')
1347 * Set page meta-data.
1352 * @param string $key Meta-data key to set.
1353 * @param string $newval New value.
1355 function set($key, $newval) {
1356 $cache = &$this->_wikidb->_cache;
1357 $backend = &$this->_wikidb->_backend;
1358 $pagename = &$this->_pagename;
1360 assert($key && $key[0] != '%');
1362 // several new SQL backends optimize this.
1363 if (!WIKIDB_NOCACHE_MARKUP
1364 and $key == '_cached_html'
1365 and method_exists($backend, 'set_cached_html'))
1367 return $backend->set_cached_html($pagename, $newval);
1370 $data = $cache->get_pagedata($pagename);
1372 if (!empty($newval)) {
1373 if (!empty($data[$key]) && $data[$key] == $newval)
1374 return; // values identical, skip update.
1377 if (empty($data[$key]))
1378 return; // values identical, skip update.
1381 $cache->update_pagedata($pagename, array($key => $newval));
1385 * Increase page hit count.
1387 * FIXME: IS this needed? Probably not.
1389 * This is a convenience function.
1390 * <pre> $page->increaseHitCount(); </pre>
1391 * is functionally identical to
1392 * <pre> $page->set('hits',$page->get('hits')+1); </pre>
1393 * but less expensive (ignores the pagadata string)
1395 * Note that this method may be implemented in more efficient ways
1396 * in certain backends.
1400 function increaseHitCount() {
1401 if (method_exists($this->_wikidb->_backend, 'increaseHitCount'))
1402 $this->_wikidb->_backend->increaseHitCount($this->_pagename);
1404 @$newhits = $this->get('hits') + 1;
1405 $this->set('hits', $newhits);
1410 * Return a string representation of the WikiDB_Page
1412 * This is really only for debugging.
1416 * @return string Printable representation of the WikiDB_Page.
1418 function asString () {
1420 printf("[%s:%s\n", get_class($this), $this->getName());
1421 print_r($this->getMetaData());
1423 $strval = ob_get_contents();
1431 * @param integer_or_object $version_or_pagerevision
1432 * Takes either the version number (and int) or a WikiDB_PageRevision
1434 * @return integer The version number.
1436 function _coerce_to_version($version_or_pagerevision) {
1437 if (method_exists($version_or_pagerevision, "getContent"))
1438 $version = $version_or_pagerevision->getVersion();
1440 $version = (int) $version_or_pagerevision;
1442 assert($version >= 0);
1446 function isUserPage ($include_empty = true) {
1447 if (!$include_empty and !$this->exists()) return false;
1448 return $this->get('pref') ? true : false;
1451 // May be empty. Either the stored owner (/Chown), or the first authorized author
1452 function getOwner() {
1453 if ($owner = $this->get('owner'))
1454 return ($owner == "The PhpWiki programming team") ? ADMIN_USER : $owner;
1455 // check all revisions forwards for the first author_id
1456 $backend = &$this->_wikidb->_backend;
1457 $pagename = &$this->_pagename;
1458 $latestversion = $backend->get_latest_version($pagename);
1459 for ($v=1; $v <= $latestversion; $v++) {
1460 $rev = $this->getRevision($v,false);
1461 if ($rev and $owner = $rev->get('author_id')) {
1462 return ($owner == "The PhpWiki programming team") ? ADMIN_USER : $owner;
1468 // The authenticated author of the first revision or empty if not authenticated then.
1469 function getCreator() {
1470 if ($current = $this->getRevision(1,false)) return $current->get('author_id');
1474 // The authenticated author of the current revision.
1475 function getAuthor() {
1476 if ($current = $this->getCurrentRevision(false)) return $current->get('author_id');
1483 * This class represents a specific revision of a WikiDB_Page within
1486 * A WikiDB_PageRevision has read-only semantics. You may only create
1487 * new revisions (and delete old ones) --- you cannot modify existing
1490 class WikiDB_PageRevision
1492 //var $_transformedContent = false; // set by WikiDB_Page::save()
1494 function WikiDB_PageRevision(&$wikidb, $pagename, $version, $versiondata = false) {
1495 $this->_wikidb = &$wikidb;
1496 $this->_pagename = $pagename;
1497 $this->_version = $version;
1498 $this->_data = $versiondata ? $versiondata : array();
1499 $this->_transformedContent = false; // set by WikiDB_Page::save()
1503 * Get the WikiDB_Page which this revision belongs to.
1507 * @return WikiDB_Page The WikiDB_Page which this revision belongs to.
1509 function getPage() {
1510 return new WikiDB_Page($this->_wikidb, $this->_pagename);
1514 * Get the version number of this revision.
1518 * @return integer The version number of this revision.
1520 function getVersion() {
1521 return $this->_version;
1525 * Determine whether this revision has defaulted content.
1527 * The default revision (version 0) of each page, as well as any
1528 * pages which are created with empty content have their content
1529 * defaulted to something like:
1531 * Describe [ThisPage] here.
1536 * @return boolean Returns true if the page has default content.
1538 function hasDefaultContents() {
1539 $data = &$this->_data;
1540 return empty($data['%content']); // FIXME: what if it's the number 0? <>'' or === false
1544 * Get the content as an array of lines.
1548 * @return array An array of lines.
1549 * The lines should contain no trailing white space.
1551 function getContent() {
1552 return explode("\n", $this->getPackedContent());
1556 * Get the pagename of the revision.
1560 * @return string pagename.
1562 function getPageName() {
1563 return $this->_pagename;
1565 function getName() {
1566 return $this->_pagename;
1570 * Determine whether revision is the latest.
1574 * @return boolean True iff the revision is the latest (most recent) one.
1576 function isCurrent() {
1577 if (!isset($this->_iscurrent)) {
1578 $page = $this->getPage();
1579 $current = $page->getCurrentRevision(false);
1580 $this->_iscurrent = $this->getVersion() == $current->getVersion();
1582 return $this->_iscurrent;
1586 * Get the transformed content of a page.
1588 * @param string $pagetype Override the page-type of the revision.
1590 * @return object An XmlContent-like object containing the page transformed
1593 function getTransformedContent($pagetype_override=false) {
1594 $backend = &$this->_wikidb->_backend;
1596 if ($pagetype_override) {
1597 // Figure out the normal page-type for this page.
1598 $type = PageType::GetPageType($this->get('pagetype'));
1599 if ($type->getName() == $pagetype_override)
1600 $pagetype_override = false; // Not really an override...
1603 if ($pagetype_override) {
1604 // Overriden page type, don't cache (or check cache).
1605 return new TransformedText($this->getPage(),
1606 $this->getPackedContent(),
1607 $this->getMetaData(),
1608 $pagetype_override);
1611 $possibly_cache_results = true;
1613 if (!USECACHE or WIKIDB_NOCACHE_MARKUP) {
1614 if (WIKIDB_NOCACHE_MARKUP == 'purge') {
1615 // flush cache for this page.
1616 $page = $this->getPage();
1617 $page->set('_cached_html', ''); // ignored with !USECACHE
1619 $possibly_cache_results = false;
1621 elseif (USECACHE and !$this->_transformedContent) {
1623 if ($this->isCurrent()) {
1624 $page = $this->getPage();
1625 $this->_transformedContent = TransformedText::unpack($page->get('_cached_html'));
1628 $possibly_cache_results = false;
1630 //$backend->unlock();
1633 if (!$this->_transformedContent) {
1634 $this->_transformedContent
1635 = new TransformedText($this->getPage(),
1636 $this->getPackedContent(),
1637 $this->getMetaData());
1639 if ($possibly_cache_results and !WIKIDB_NOCACHE_MARKUP) {
1640 // If we're still the current version, cache the transfomed page.
1642 if ($this->isCurrent()) {
1643 $page->set('_cached_html', $this->_transformedContent->pack());
1645 //$backend->unlock();
1649 return $this->_transformedContent;
1653 * Get the content as a string.
1657 * @return string The page content.
1658 * Lines are separated by new-lines.
1660 function getPackedContent() {
1661 $data = &$this->_data;
1664 if (empty($data['%content'])) {
1665 include_once('lib/InlineParser.php');
1667 // A feature similar to taglines at http://www.wlug.org.nz/
1668 // Lib from http://www.aasted.org/quote/
1669 if (defined('FORTUNE_DIR')
1670 and is_dir(FORTUNE_DIR)
1671 and in_array($GLOBALS['request']->getArg('action'),
1672 array('create','edit')))
1674 include_once("lib/fortune.php");
1675 $fortune = new Fortune();
1676 $quote = str_replace("\n<br>","\n", $fortune->quoteFromDir(FORTUNE_DIR));
1677 return sprintf("<verbatim>\n%s</verbatim>\n\n"._("Describe %s here."),
1678 $quote, "[" . WikiEscape($this->_pagename) . "]");
1680 // Replace empty content with default value.
1681 return sprintf(_("Describe %s here."),
1682 "[" . WikiEscape($this->_pagename) . "]");
1685 // There is (non-default) content.
1686 assert($this->_version > 0);
1688 if (!is_string($data['%content'])) {
1689 // Content was not provided to us at init time.
1690 // (This is allowed because for some backends, fetching
1691 // the content may be expensive, and often is not wanted
1694 // In any case, now we need to get it.
1695 $data['%content'] = $this->_get_content();
1696 assert(is_string($data['%content']));
1699 return $data['%content'];
1702 function _get_content() {
1703 $cache = &$this->_wikidb->_cache;
1704 $pagename = $this->_pagename;
1705 $version = $this->_version;
1707 assert($version > 0);
1709 $newdata = $cache->get_versiondata($pagename, $version, true);
1711 assert(is_string($newdata['%content']));
1712 return $newdata['%content'];
1715 // else revision has been deleted... What to do?
1716 return __sprintf("Oops! Revision %s of %s seems to have been deleted!",
1717 $version, $pagename);
1722 * Get meta-data for this revision.
1727 * @param string $key Which meta-data to access.
1729 * Some reserved revision meta-data keys are:
1731 * <dt> 'mtime' <dd> Time this revision was created (seconds since midnight Jan 1, 1970.)
1732 * The 'mtime' meta-value is normally set automatically by the database
1733 * backend, but it may be specified explicitly when creating a new revision.
1735 * <dd> To ensure consistency of RecentChanges, the mtimes of the versions
1736 * of a page must be monotonically increasing. If an attempt is
1737 * made to create a new revision with an mtime less than that of
1738 * the preceeding revision, the new revisions timestamp is force
1739 * to be equal to that of the preceeding revision. In that case,
1740 * the originally requested mtime is preserved in 'orig_mtime'.
1741 * <dt> '_supplanted' <dd> Time this revision ceased to be the most recent.
1742 * This meta-value is <em>always</em> automatically maintained by the database
1743 * backend. (It is set from the 'mtime' meta-value of the superceding
1744 * revision.) '_supplanted' has a value of 'false' for the current revision.
1746 * FIXME: this could be refactored:
1748 * <dd> Author of the page (as he should be reported in, e.g. RecentChanges.)
1750 * <dd> Authenticated author of a page. This is used to identify
1751 * the distinctness of authors when cleaning old revisions from
1753 * <dt> 'is_minor_edit' <dd> Set if change was marked as a minor revision by the author.
1754 * <dt> 'summary' <dd> Short change summary entered by page author.
1757 * Meta-data keys must be valid C identifers (they have to start with a letter
1758 * or underscore, and can contain only alphanumerics and underscores.)
1760 * @return string The requested value, or false if the requested value
1763 function get($key) {
1764 if (!$key || $key[0] == '%')
1766 $data = &$this->_data;
1767 return isset($data[$key]) ? $data[$key] : false;
1771 * Get all the revision page meta-data as a hash.
1773 * @return hash The revision meta-data.
1775 function getMetaData() {
1777 foreach ($this->_data as $key => $val) {
1778 if (!empty($val) && $key[0] != '%')
1786 * Return a string representation of the revision.
1788 * This is really only for debugging.
1792 * @return string Printable representation of the WikiDB_Page.
1794 function asString () {
1796 printf("[%s:%d\n", get_class($this), $this->get('version'));
1797 print_r($this->_data);
1798 echo $this->getPackedContent() . "\n]\n";
1799 $strval = ob_get_contents();
1807 * Class representing a sequence of WikiDB_Pages.
1808 * TODO: Enhance to php5 iterators
1810 * apply filters for options like 'sortby', 'limit', 'exclude'
1811 * for simple queries like titleSearch, where the backend is not ready yet.
1813 class WikiDB_PageIterator
1815 function WikiDB_PageIterator(&$wikidb, &$iter, $options=false) {
1816 $this->_iter = $iter; // a WikiDB_backend_iterator
1817 $this->_wikidb = &$wikidb;
1818 $this->_options = $options;
1822 return $this->_iter->count();
1826 * Get next WikiDB_Page in sequence.
1830 * @return WikiDB_Page The next WikiDB_Page in the sequence.
1833 if ( ! ($next = $this->_iter->next()) )
1836 $pagename = &$next['pagename'];
1837 if (!is_string($pagename)) // Bug #1327912 fixed by Joachim Lous
1838 $pagename = strval($pagename);
1840 trigger_error('empty pagename in WikiDB_PageIterator::next()', E_USER_WARNING);
1844 // There's always hits, but we cache only if more
1845 // (well not with file, cvs and dba)
1846 if (isset($next['pagedata']) and count($next['pagedata']) > 1) {
1847 $this->_wikidb->_cache->cache_data($next);
1848 // cache existing page id's since we iterate over all links in GleanDescription
1849 // and need them later for LinkExistingWord
1850 } elseif ($this->_options and array_key_exists('include_empty', $this->_options)
1851 and !$this->_options['include_empty'] and isset($next['id'])) {
1852 $this->_wikidb->_cache->_id_cache[$next['pagename']] = $next['id'];
1854 $page = new WikiDB_Page($this->_wikidb, $pagename);
1855 if (isset($next['linkrelation']))
1856 $page->set('linkrelation', $next['linkrelation']);
1861 * Release resources held by this iterator.
1863 * The iterator may not be used after free() is called.
1865 * There is no need to call free(), if next() has returned false.
1866 * (I.e. if you iterate through all the pages in the sequence,
1867 * you do not need to call free() --- you only need to call it
1868 * if you stop before the end of the iterator is reached.)
1873 $this->_iter->free();
1876 function asArray() {
1878 while ($page = $this->next())
1885 * Apply filters for options like 'sortby', 'limit', 'exclude'
1886 * for simple queries like titleSearch, where the backend is not ready yet.
1887 * Since iteration is usually destructive for SQL results,
1888 * we have to generate a copy.
1890 function applyFilters($options = false) {
1891 if (!$options) $options = $this->_options;
1892 if (isset($options['sortby'])) {
1894 /* this is destructive */
1895 while ($page = $this->next())
1896 $result[] = $page->getName();
1897 $this->_doSort($array, $options['sortby']);
1899 /* the rest is not destructive.
1900 * reconstruct a new iterator
1902 $pagenames = array(); $i = 0;
1903 if (isset($options['limit']))
1904 $limit = $options['limit'];
1907 if (isset($options['exclude']))
1908 $exclude = $options['exclude'];
1909 if (is_string($exclude) and !is_array($exclude))
1910 $exclude = PageList::explodePageList($exclude, false, false, $limit);
1911 foreach($array as $pagename) {
1912 if ($limit and $i++ > $limit)
1913 return new WikiDB_Array_PageIterator($pagenames);
1914 if (!empty($exclude) and !in_array($pagename, $exclude))
1915 $pagenames[] = $pagename;
1916 elseif (empty($exclude))
1917 $pagenames[] = $pagename;
1919 return new WikiDB_Array_PageIterator($pagenames);
1923 function _doSort(&$array, $sortby) {
1924 $sortby = PageList::sortby($sortby, 'init');
1925 if ($sortby == '+pagename')
1926 sort($array, SORT_STRING);
1927 elseif ($sortby == '-pagename')
1928 rsort($array, SORT_STRING);
1935 * A class which represents a sequence of WikiDB_PageRevisions.
1936 * TODO: Enhance to php5 iterators
1938 class WikiDB_PageRevisionIterator
1940 function WikiDB_PageRevisionIterator(&$wikidb, &$revisions, $options=false) {
1941 $this->_revisions = $revisions;
1942 $this->_wikidb = &$wikidb;
1943 $this->_options = $options;
1947 return $this->_revisions->count();
1951 * Get next WikiDB_PageRevision in sequence.
1955 * @return WikiDB_PageRevision
1956 * The next WikiDB_PageRevision in the sequence.
1959 if ( ! ($next = $this->_revisions->next()) )
1962 //$this->_wikidb->_cache->cache_data($next);
1964 $pagename = $next['pagename'];
1965 $version = $next['version'];
1966 $versiondata = $next['versiondata'];
1968 if (!(is_string($pagename) and $pagename != '')) {
1969 trigger_error("empty pagename",E_USER_WARNING);
1972 } else assert(is_string($pagename) and $pagename != '');
1974 if (!is_array($versiondata)) {
1975 trigger_error("empty versiondata",E_USER_WARNING);
1978 } else assert(is_array($versiondata));
1980 if (!($version > 0)) {
1981 trigger_error("invalid version",E_USER_WARNING);
1984 } else assert($version > 0);
1986 return new WikiDB_PageRevision($this->_wikidb, $pagename, $version,
1991 * Release resources held by this iterator.
1993 * The iterator may not be used after free() is called.
1995 * There is no need to call free(), if next() has returned false.
1996 * (I.e. if you iterate through all the revisions in the sequence,
1997 * you do not need to call free() --- you only need to call it
1998 * if you stop before the end of the iterator is reached.)
2003 $this->_revisions->free();
2006 function asArray() {
2008 while ($rev = $this->next())
2017 class WikiDB_Array_PageIterator
2019 function WikiDB_Array_PageIterator($pagenames) {
2021 $this->_dbi = $request->getDbh();
2022 $this->_pages = $pagenames;
2023 reset($this->_pages);
2026 $c =& current($this->_pages);
2027 next($this->_pages);
2028 return $c !== false ? $this->_dbi->getPage($c) : false;
2031 return count($this->_pages);
2034 function asArray() {
2035 reset($this->_pages);
2036 return $this->_pages;
2040 class WikiDB_Array_generic_iter
2042 function WikiDB_Array_generic_iter($result) {
2043 // $result may be either an array or a query result
2044 if (is_array($result)) {
2045 $this->_array = $result;
2046 } elseif (is_object($result)) {
2047 $this->_array = $result->asArray();
2049 $this->_array = array();
2051 if (!empty($this->_array))
2052 reset($this->_array);
2055 $c =& current($this->_array);
2056 next($this->_array);
2057 return $c !== false ? $c : false;
2060 return count($this->_array);
2063 function asArray() {
2064 if (!empty($this->_array))
2065 reset($this->_array);
2066 return $this->_array;
2071 * Data cache used by WikiDB.
2073 * FIXME: Maybe rename this to caching_backend (or some such).
2079 // FIXME: beautify versiondata cache. Cache only limited data?
2081 function WikiDB_cache (&$backend) {
2082 $this->_backend = &$backend;
2084 $this->_pagedata_cache = array();
2085 $this->_versiondata_cache = array();
2086 array_push ($this->_versiondata_cache, array());
2087 $this->_glv_cache = array();
2088 $this->_id_cache = array(); // formerly ->_dbi->_iwpcache (nonempty pages => id)
2092 $this->_pagedata_cache = array();
2093 $this->_versiondata_cache = array();
2094 $this->_glv_cache = array();
2095 $this->_id_cache = array();
2098 function get_pagedata($pagename) {
2099 assert(is_string($pagename) && $pagename != '');
2101 $cache = &$this->_pagedata_cache;
2102 if (!isset($cache[$pagename]) || !is_array($cache[$pagename])) {
2103 $cache[$pagename] = $this->_backend->get_pagedata($pagename);
2104 if (empty($cache[$pagename]))
2105 $cache[$pagename] = array();
2107 return $cache[$pagename];
2109 return $this->_backend->get_pagedata($pagename);
2113 function update_pagedata($pagename, $newdata) {
2114 assert(is_string($pagename) && $pagename != '');
2116 $this->_backend->update_pagedata($pagename, $newdata);
2119 if (!empty($this->_pagedata_cache[$pagename])
2120 and is_array($this->_pagedata_cache[$pagename]))
2122 $cachedata = &$this->_pagedata_cache[$pagename];
2123 foreach($newdata as $key => $val)
2124 $cachedata[$key] = $val;
2126 $this->_pagedata_cache[$pagename] = $newdata;
2130 function invalidate_cache($pagename) {
2131 unset ($this->_pagedata_cache[$pagename]);
2132 unset ($this->_versiondata_cache[$pagename]);
2133 unset ($this->_glv_cache[$pagename]);
2134 unset ($this->_id_cache[$pagename]);
2135 //unset ($this->_backend->_page_data);
2138 function delete_page($pagename) {
2139 $result = $this->_backend->delete_page($pagename);
2140 $this->invalidate_cache($pagename);
2144 function purge_page($pagename) {
2145 $result = $this->_backend->purge_page($pagename);
2146 $this->invalidate_cache($pagename);
2150 // FIXME: ugly and wrong. may overwrite full cache with partial cache
2151 function cache_data($data) {
2153 //if (isset($data['pagedata']))
2154 // $this->_pagedata_cache[$data['pagename']] = $data['pagedata'];
2157 function get_versiondata($pagename, $version, $need_content = false) {
2158 // FIXME: Seriously ugly hackage
2160 if (USECACHE) { //temporary - for debugging
2161 assert(is_string($pagename) && $pagename != '');
2162 // There is a bug here somewhere which results in an assertion failure at line 105
2163 // of ArchiveCleaner.php It goes away if we use the next line.
2164 //$need_content = true;
2165 $nc = $need_content ? '1':'0';
2166 $cache = &$this->_versiondata_cache;
2167 if (!isset($cache[$pagename][$version][$nc])
2168 || !(is_array ($cache[$pagename]))
2169 || !(is_array ($cache[$pagename][$version])))
2171 $cache[$pagename][$version][$nc] =
2172 $this->_backend->get_versiondata($pagename, $version, $need_content);
2174 // If we have retrieved all data, we may as well set the cache for
2175 // $need_content = false
2177 $cache[$pagename][$version]['0'] =& $cache[$pagename][$version]['1'];
2180 $vdata = $cache[$pagename][$version][$nc];
2182 $vdata = $this->_backend->get_versiondata($pagename, $version, $need_content);
2185 if ($readdata && $vdata && !empty($vdata['%pagedata'])) {
2186 $this->_pagedata_cache[$pagename] =& $vdata['%pagedata'];
2191 function set_versiondata($pagename, $version, $data) {
2192 //unset($this->_versiondata_cache[$pagename][$version]);
2194 $new = $this->_backend->set_versiondata($pagename, $version, $data);
2196 $this->_versiondata_cache[$pagename][$version]['1'] = $data;
2197 $this->_versiondata_cache[$pagename][$version]['0'] = $data;
2198 // Is this necessary?
2199 unset($this->_glv_cache[$pagename]);
2202 function update_versiondata($pagename, $version, $data) {
2203 $new = $this->_backend->update_versiondata($pagename, $version, $data);
2205 $this->_versiondata_cache[$pagename][$version]['1'] = $data;
2207 $this->_versiondata_cache[$pagename][$version]['0'] = $data;
2208 // Is this necessary?
2209 unset($this->_glv_cache[$pagename]);
2212 function delete_versiondata($pagename, $version) {
2213 $new = $this->_backend->delete_versiondata($pagename, $version);
2214 if (isset($this->_versiondata_cache[$pagename][$version]))
2215 unset ($this->_versiondata_cache[$pagename][$version]);
2216 // dirty latest version cache only if latest version gets deleted
2217 if (isset($this->_glv_cache[$pagename]) and $this->_glv_cache[$pagename] == $version)
2218 unset ($this->_glv_cache[$pagename]);
2221 function get_latest_version($pagename) {
2223 assert (is_string($pagename) && $pagename != '');
2224 $cache = &$this->_glv_cache;
2225 if (!isset($cache[$pagename])) {
2226 $cache[$pagename] = $this->_backend->get_latest_version($pagename);
2227 if (empty($cache[$pagename]))
2228 $cache[$pagename] = 0;
2230 return $cache[$pagename];
2232 return $this->_backend->get_latest_version($pagename);
2237 function _sql_debuglog($msg, $newline=true, $shutdown=false) {
2241 $stamp = strftime("%y%m%d-%H%M%S");
2242 $fp = fopen("/tmp/sql-$stamp.log", "a");
2243 register_shutdown_function("_sql_debuglog_shutdown_function");
2244 } elseif ($shutdown) {
2248 if ($newline) fputs($fp, "[$i++] $msg");
2249 else fwrite($fp, $msg);
2252 function _sql_debuglog_shutdown_function() {
2253 _sql_debuglog('',false,true);
2256 // $Log: not supported by cvs2svn $
2257 // Revision 1.138 2005/11/14 22:27:07 rurban
2258 // add linkrelation support
2259 // getPageLinks returns now an array of hashes
2260 // pass stoplist through iterator
2262 // Revision 1.137 2005/10/12 06:16:18 rurban
2263 // better From header
2265 // Revision 1.136 2005/10/03 16:14:57 rurban
2266 // improve description
2268 // Revision 1.135 2005/09/11 14:19:44 rurban
2269 // enable LIMIT support for fulltext search
2271 // Revision 1.134 2005/09/10 21:28:10 rurban
2272 // applyFilters hack to use filters after methods, which do not support them (titleSearch)
2274 // Revision 1.133 2005/08/27 09:39:10 rurban
2275 // dumphtml when not at admin page: dump the current or given page
2277 // Revision 1.132 2005/08/07 10:10:07 rurban
2278 // clean whole version cache
2280 // Revision 1.131 2005/04/23 11:30:12 rurban
2281 // allow emtpy WikiDB::getRevisionBefore(), for simplier templates (revert)
2283 // Revision 1.130 2005/04/06 06:19:30 rurban
2284 // Revert the previous wrong bugfix #1175761: USECACHE was mixed with WIKIDB_NOCACHE_MARKUP.
2285 // Fix WIKIDB_NOCACHE_MARKUP in main (always set it) and clarify it in WikiDB
2287 // Revision 1.129 2005/04/06 05:50:29 rurban
2288 // honor !USECACHE for _cached_html, fixes #1175761
2290 // Revision 1.128 2005/04/01 16:11:42 rurban
2293 // Revision 1.127 2005/02/18 20:43:40 uckelman
2294 // WikiDB::genericWarnings() is no longer used.
2296 // Revision 1.126 2005/02/04 17:58:06 rurban
2297 // minor versioncache improvement. part 2/3 of Charles Corrigan cache patch. not sure about the 0/1 issue
2299 // Revision 1.125 2005/02/03 05:08:39 rurban
2300 // ref fix by Charles Corrigan
2302 // Revision 1.124 2005/01/29 20:43:32 rurban
2303 // protect against empty request: on some occasion this happens
2305 // Revision 1.123 2005/01/25 06:58:21 rurban
2308 // Revision 1.122 2005/01/20 10:18:17 rurban
2311 // Revision 1.121 2005/01/04 20:25:01 rurban
2312 // remove old [%pagedata][_cached_html] code
2314 // Revision 1.120 2004/12/23 14:12:31 rurban
2315 // dont email on unittest
2317 // Revision 1.119 2004/12/20 16:05:00 rurban
2318 // gettext msg unification
2320 // Revision 1.118 2004/12/13 13:22:57 rurban
2321 // new BlogArchives plugin for the new blog theme. enable default box method
2322 // for all plugins. Minor search improvement.
2324 // Revision 1.117 2004/12/13 08:15:09 rurban
2325 // false is wrong. null might be better but lets play safe.
2327 // Revision 1.116 2004/12/10 22:15:00 rurban
2328 // fix $page->get('_cached_html)
2329 // refactor upgrade db helper _convert_cached_html() to be able to call them from WikiAdminUtils also.
2330 // support 2nd genericSqlQuery param (bind huge arg)
2332 // Revision 1.115 2004/12/10 02:45:27 rurban
2333 // SQL optimization:
2334 // put _cached_html from pagedata into a new seperate blob, not huge serialized string.
2335 // it is only rarelely needed: for current page only, if-not-modified
2336 // but was extracted for every simple page iteration.
2338 // Revision 1.114 2004/12/09 22:24:44 rurban
2339 // optimize on _DEBUG_SQL only. but now again on every 50th request, not just save.
2341 // Revision 1.113 2004/12/06 19:49:55 rurban
2342 // enable action=remove which is undoable and seeable in RecentChanges: ADODB ony for now.
2343 // renamed delete_page to purge_page.
2344 // enable action=edit&version=-1 to force creation of a new version.
2345 // added BABYCART_PATH config
2346 // fixed magiqc in adodb.inc.php
2347 // and some more docs
2349 // Revision 1.112 2004/11/30 17:45:53 rurban
2350 // exists_links backend implementation
2352 // Revision 1.111 2004/11/28 20:39:43 rurban
2353 // deactivate pagecache overwrite: it is wrong
2355 // Revision 1.110 2004/11/26 18:39:01 rurban
2356 // new regex search parser and SQL backends (90% complete, glob and pcre backends missing)
2358 // Revision 1.109 2004/11/25 17:20:50 rurban
2359 // and again a couple of more native db args: backlinks
2361 // Revision 1.108 2004/11/23 13:35:31 rurban
2362 // add case_exact search
2364 // Revision 1.107 2004/11/21 11:59:16 rurban
2365 // remove final \n to be ob_cache independent
2367 // Revision 1.106 2004/11/20 17:35:56 rurban
2368 // improved WantedPages SQL backends
2369 // PageList::sortby new 3rd arg valid_fields (override db fields)
2370 // WantedPages sql pager inexact for performance reasons:
2371 // assume 3 wantedfrom per page, to be correct, no getTotal()
2372 // support exclude argument for get_all_pages, new _sql_set()
2374 // Revision 1.105 2004/11/20 09:16:27 rurban
2375 // Fix bad-style Cut&Paste programming errors, detected by Charles Corrigan.
2377 // Revision 1.104 2004/11/19 19:22:03 rurban
2378 // ModeratePage part1: change status
2380 // Revision 1.103 2004/11/16 17:29:04 rurban
2381 // fix remove notification error
2382 // fix creation + update id_cache update
2384 // Revision 1.102 2004/11/11 18:31:26 rurban
2385 // add simple backtrace on such general failures to get at least an idea where
2387 // Revision 1.101 2004/11/10 19:32:22 rurban
2388 // * optimize increaseHitCount, esp. for mysql.
2389 // * prepend dirs to the include_path (phpwiki_dir for faster searches)
2390 // * Pear_DB version logic (awful but needed)
2391 // * fix broken ADODB quote
2392 // * _extract_page_data simplification
2394 // Revision 1.100 2004/11/10 15:29:20 rurban
2395 // * requires newer Pear_DB (as the internal one): quote() uses now escapeSimple for strings
2396 // * ACCESS_LOG_SQL: fix cause request not yet initialized
2397 // * WikiDB: moved SQL specific methods upwards
2398 // * new Pear_DB quoting: same as ADODB and as newer Pear_DB.
2399 // fixes all around: WikiGroup, WikiUserNew SQL methods, SQL logging
2401 // Revision 1.99 2004/11/09 17:11:05 rurban
2402 // * revert to the wikidb ref passing. there's no memory abuse there.
2403 // * use new wikidb->_cache->_id_cache[] instead of wikidb->_iwpcache, to effectively
2404 // store page ids with getPageLinks (GleanDescription) of all existing pages, which
2405 // are also needed at the rendering for linkExistingWikiWord().
2406 // pass options to pageiterator.
2407 // use this cache also for _get_pageid()
2408 // This saves about 8 SELECT count per page (num all pagelinks).
2409 // * fix passing of all page fields to the pageiterator.
2410 // * fix overlarge session data which got broken with the latest ACCESS_LOG_SQL changes
2412 // Revision 1.98 2004/11/07 18:34:29 rurban
2413 // more logging fixes
2415 // Revision 1.97 2004/11/07 16:02:51 rurban
2416 // new sql access log (for spam prevention), and restructured access log class
2417 // dbh->quote (generic)
2418 // pear_db: mysql specific parts seperated (using replace)
2420 // Revision 1.96 2004/11/05 22:32:15 rurban
2421 // encode the subject to be 7-bit safe
2423 // Revision 1.95 2004/11/05 20:53:35 rurban
2424 // login cleanup: better debug msg on failing login,
2425 // checked password less immediate login (bogo or anon),
2426 // checked olduser pref session error,
2427 // better PersonalPage without password warning on minimal password length=0
2428 // (which is default now)
2430 // Revision 1.94 2004/11/01 10:43:56 rurban
2431 // seperate PassUser methods into seperate dir (memory usage)
2432 // fix WikiUser (old) overlarge data session
2433 // remove wikidb arg from various page class methods, use global ->_dbi instead
2436 // Revision 1.93 2004/10/14 17:17:57 rurban
2437 // remove dbi WikiDB_Page param: use global request object instead. (memory)
2438 // allow most_popular sortby arguments
2440 // Revision 1.92 2004/10/05 17:00:04 rurban
2441 // support paging for simple lists
2442 // fix RatingDb sql backend.
2443 // remove pages from AllPages (this is ListPages then)
2445 // Revision 1.91 2004/10/04 23:41:19 rurban
2446 // delete notify: fix, @unset syntax error
2448 // Revision 1.90 2004/09/28 12:50:22 rurban
2449 // https://sourceforge.net/forum/forum.php?thread_id=1150924&forum_id=18929
2451 // Revision 1.89 2004/09/26 10:54:42 rurban
2452 // silence deferred check
2454 // Revision 1.88 2004/09/25 18:16:40 rurban
2455 // unset more unneeded _cached_html. (Guess this should fix sf.net now)
2457 // Revision 1.87 2004/09/25 16:25:40 rurban
2458 // notify on rename and remove (to be improved)
2460 // Revision 1.86 2004/09/23 18:52:06 rurban
2461 // only fortune at create
2463 // Revision 1.85 2004/09/16 08:00:51 rurban
2464 // just some comments
2466 // Revision 1.84 2004/09/14 10:34:30 rurban
2467 // fix TransformedText call to use refs
2469 // Revision 1.83 2004/09/08 13:38:00 rurban
2470 // improve loadfile stability by using markup=2 as default for undefined markup-style.
2471 // use more refs for huge objects.
2472 // fix debug=static issue in WikiPluginCached
2474 // Revision 1.82 2004/09/06 12:08:49 rurban
2475 // memory_limit on unix workaround
2476 // VisualWiki: default autosize image
2478 // Revision 1.81 2004/09/06 08:28:00 rurban
2479 // rename genericQuery to genericSqlQuery
2481 // Revision 1.80 2004/07/09 13:05:34 rurban
2484 // Revision 1.79 2004/07/09 10:06:49 rurban
2485 // Use backend specific sortby and sortable_columns method, to be able to
2486 // select between native (Db backend) and custom (PageList) sorting.
2487 // Fixed PageList::AddPageList (missed the first)
2488 // Added the author/creator.. name to AllPagesBy...
2489 // display no pages if none matched.
2490 // Improved dba and file sortby().
2491 // Use &$request reference
2493 // Revision 1.78 2004/07/08 21:32:35 rurban
2494 // Prevent from more warnings, minor db and sort optimizations
2496 // Revision 1.77 2004/07/08 19:04:42 rurban
2497 // more unittest fixes (file backend, metadata RatingsDb)
2499 // Revision 1.76 2004/07/08 17:31:43 rurban
2500 // improve numPages for file (fixing AllPagesTest)
2502 // Revision 1.75 2004/07/05 13:56:22 rurban
2503 // sqlite autoincrement fix
2505 // Revision 1.74 2004/07/03 16:51:05 rurban
2506 // optional DBADMIN_USER:DBADMIN_PASSWD for action=upgrade (if no ALTER permission)
2507 // added atomic mysql REPLACE for PearDB as in ADODB
2508 // fixed _lock_tables typo links => link
2509 // fixes unserialize ADODB bug in line 180
2511 // Revision 1.73 2004/06/29 08:52:22 rurban
2512 // Use ...version() $need_content argument in WikiDB also:
2513 // To reduce the memory footprint for larger sets of pagelists,
2514 // we don't cache the content (only true or false) and
2515 // we purge the pagedata (_cached_html) also.
2516 // _cached_html is only cached for the current pagename.
2517 // => Vastly improved page existance check, ACL check, ...
2519 // Now only PagedList info=content or size needs the whole content, esp. if sortable.
2521 // Revision 1.72 2004/06/25 14:15:08 rurban
2522 // reduce memory footprint by caching only requested pagedate content (improving most page iterators)
2524 // Revision 1.71 2004/06/21 16:22:30 rurban
2525 // add DEFAULT_DUMP_DIR and HTML_DUMP_DIR constants, for easier cmdline dumps,
2526 // fixed dumping buttons locally (images/buttons/),
2527 // support pages arg for dumphtml,
2528 // optional directory arg for dumpserial + dumphtml,
2529 // fix a AllPages warning,
2530 // show dump warnings/errors on DEBUG,
2531 // don't warn just ignore on wikilens pagelist columns, if not loaded.
2532 // RateIt pagelist column is called "rating", not "ratingwidget" (Dan?)
2534 // Revision 1.70 2004/06/18 14:39:31 rurban
2535 // actually check USECACHE
2537 // Revision 1.69 2004/06/13 15:33:20 rurban
2538 // new support for arguments owner, author, creator in most relevant
2539 // PageList plugins. in WikiAdmin* via preSelectS()
2541 // Revision 1.68 2004/06/08 21:03:20 rurban
2542 // updated RssParser for XmlParser quirks (store parser object params in globals)
2544 // Revision 1.67 2004/06/07 19:12:49 rurban
2545 // fixed rename version=0, bug #966284
2547 // Revision 1.66 2004/06/07 18:57:27 rurban
2548 // fix rename: Change pagename in all linked pages
2550 // Revision 1.65 2004/06/04 20:32:53 rurban
2551 // Several locale related improvements suggested by Pierrick Meignen
2552 // LDAP fix by John Cole
2553 // reanable admin check without ENABLE_PAGEPERM in the admin plugins
2555 // Revision 1.64 2004/06/04 16:50:00 rurban
2556 // add random quotes to empty pages
2558 // Revision 1.63 2004/06/04 11:58:38 rurban
2559 // added USE_TAGLINES
2561 // Revision 1.62 2004/06/03 22:24:41 rurban
2562 // reenable admin check on !ENABLE_PAGEPERM, honor s=Wildcard arg, fix warning after Remove
2564 // Revision 1.61 2004/06/02 17:13:48 rurban
2565 // fix getRevisionBefore assertion
2567 // Revision 1.60 2004/05/28 10:09:58 rurban
2568 // fix bug #962117, incorrect init of auth_dsn
2570 // Revision 1.59 2004/05/27 17:49:05 rurban
2571 // renamed DB_Session to DbSession (in CVS also)
2572 // added WikiDB->getParam and WikiDB->getAuthParam method to get rid of globals
2573 // remove leading slash in error message
2574 // added force_unlock parameter to File_Passwd (no return on stale locks)
2575 // fixed adodb session AffectedRows
2576 // added FileFinder helpers to unify local filenames and DATA_PATH names
2577 // editpage.php: new edit toolbar javascript on ENABLE_EDIT_TOOLBAR
2579 // Revision 1.58 2004/05/18 13:59:14 rurban
2580 // rename simpleQuery to genericQuery
2582 // Revision 1.57 2004/05/16 22:07:35 rurban
2583 // check more config-default and predefined constants
2584 // various PagePerm fixes:
2585 // fix default PagePerms, esp. edit and view for Bogo and Password users
2586 // implemented Creator and Owner
2587 // BOGOUSERS renamed to BOGOUSER
2588 // fixed syntax errors in signin.tmpl
2590 // Revision 1.56 2004/05/15 22:54:49 rurban
2591 // fixed important WikiDB bug with DEBUG > 0: wrong assertion
2592 // improved SetAcl (works) and PagePerms, some WikiGroup helpers.
2594 // Revision 1.55 2004/05/12 19:27:47 rurban
2595 // revert wrong inline optimization.
2597 // Revision 1.54 2004/05/12 10:49:55 rurban
2598 // require_once fix for those libs which are loaded before FileFinder and
2599 // its automatic include_path fix, and where require_once doesn't grok
2600 // dirname(__FILE__) != './lib'
2601 // upgrade fix with PearDB
2602 // navbar.tmpl: remove spaces for IE button alignment
2604 // Revision 1.53 2004/05/08 14:06:12 rurban
2605 // new support for inlined image attributes: [image.jpg size=50x30 align=right]
2606 // minor stability and portability fixes
2608 // Revision 1.52 2004/05/06 19:26:16 rurban
2609 // improve stability, trying to find the InlineParser endless loop on sf.net
2611 // remove end-of-zip comments to fix sf.net bug #777278 and probably #859628
2613 // Revision 1.51 2004/05/06 17:30:37 rurban
2614 // CategoryGroup: oops, dos2unix eol
2615 // improved phpwiki_version:
2616 // pre -= .0001 (1.3.10pre: 1030.099)
2617 // -p1 += .001 (1.3.9-p1: 1030.091)
2618 // improved InstallTable for mysql and generic SQL versions and all newer tables so far.
2619 // abstracted more ADODB/PearDB methods for action=upgrade stuff:
2620 // backend->backendType(), backend->database(),
2621 // backend->listOfFields(),
2622 // backend->listOfTables(),
2624 // Revision 1.50 2004/05/04 22:34:25 rurban
2627 // Revision 1.49 2004/05/03 11:16:40 rurban
2628 // fixed sendPageChangeNotification
2629 // subject rewording
2631 // Revision 1.48 2004/04/29 23:03:54 rurban
2632 // fixed sf.net bug #940996
2634 // Revision 1.47 2004/04/29 19:39:44 rurban
2635 // special support for formatted plugins (one-liners)
2636 // like <small><plugin BlaBla ></small>
2637 // iter->asArray() helper for PopularNearby
2638 // db_session for older php's (no &func() allowed)
2640 // Revision 1.46 2004/04/26 20:44:34 rurban
2641 // locking table specific for better databases
2643 // Revision 1.45 2004/04/20 00:06:03 rurban
2644 // themable paging support
2646 // Revision 1.44 2004/04/19 18:27:45 rurban
2647 // Prevent from some PHP5 warnings (ref args, no :: object init)
2648 // php5 runs now through, just one wrong XmlElement object init missing
2649 // Removed unneccesary UpgradeUser lines
2650 // Changed WikiLink to omit version if current (RecentChanges)
2652 // Revision 1.43 2004/04/18 01:34:20 rurban
2653 // protect most_popular from sortby=mtime
2655 // Revision 1.42 2004/04/18 01:11:51 rurban
2656 // more numeric pagename fixes.
2657 // fixed action=upload with merge conflict warnings.
2658 // charset changed from constant to global (dynamic utf-8 switching)
2664 // c-basic-offset: 4
2665 // c-hanging-comment-ender-p: nil
2666 // indent-tabs-mode: nil