phpwiki-checkins Mailing List for PhpWiki (Page 33)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Revision: 10399
          http://sourceforge.net/p/phpwiki/code/10399
Author:   vargenau
Date:     2021-07-29 19:32:25 +0000 (Thu, 29 Jul 2021)
Log Message:
-----------
lib/upgrade.php: remove unused functions installTable and _convert_cached_html

Modified Paths:
--------------
    trunk/lib/upgrade.php

Modified: trunk/lib/upgrade.php
===================================================================

--- trunk/lib/upgrade.php	2021-07-29 19:11:48 UTC (rev 10398)
+++ trunk/lib/upgrade.php	2021-07-29 19:32:25 UTC (rev 10399)
@@ -152,7 +152,8 @@
                 if ($translation == $pagename)
                     $this->doPgsrcUpdate($pagename, $path, $filename);
                 elseif (findLocalizedFile('pgsrc/' . urlencode($translation), 1))
-                    $this->doPgsrcUpdate($translation, $loc_path, urlencode($translation)); else
+                    $this->doPgsrcUpdate($translation, $loc_path, urlencode($translation));
+                else
                     $this->doPgsrcUpdate($pagename, $path, $filename);
             }
         }
@@ -238,200 +239,6 @@
     }
 
     /**
-     * TODO: Search table definition in appropriate schema
-     *       and create it.
-     * Supported: mysql and generic SQL, for ADODB and PearDB.
-     */
-    private function installTable($table, $backend_type)
-    {
-        global $DBParams;
-        if (!$this->isSQL)
-            return;
-        echo _("MISSING"), " ... \n";
-        /*
-          $schema = findFile("schemas/${backend_type}.sql");
-          if (!$schema) {
-          echo "  ",_("FAILED"),": ",sprintf(_("no schema %s found"),
-          "schemas/${backend_type}.sql")," ... <br />\n";
-          return false;
-          }
-        */
-        extract($this->dbi->_backend->_table_names);
-        $prefix = isset($DBParams['prefix']) ? $DBParams['prefix'] : '';
-        switch ($table) {
-            case 'session':
-                assert($session_tbl);
-                if ($backend_type == 'mysql') {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $session_tbl (
-        sess_id     CHAR(32) NOT NULL DEFAULT '',
-        sess_data     BLOB NOT NULL,
-        sess_date     INT UNSIGNED NOT NULL,
-        sess_ip     CHAR(15) NOT NULL,
-        PRIMARY KEY (sess_id),
-    INDEX (sess_date)
-)");
-                } else {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $session_tbl (
-    sess_id     CHAR(32) NOT NULL DEFAULT '',
-        sess_data     " . ($backend_type == 'pgsql' ? 'TEXT' : 'BLOB') . " NOT NULL,
-        sess_date     INT,
-        sess_ip     CHAR(15) NOT NULL
-)");
-                    $this->dbi->genericSqlQuery("CREATE UNIQUE INDEX sess_id ON $session_tbl (sess_id)");
-                }
-                $this->dbi->genericSqlQuery("CREATE INDEX sess_date on session (sess_date)");
-                echo "  ", _("CREATED");
-                break;
-            case 'pref':
-                $pref_tbl = $prefix . 'pref';
-                if ($backend_type == 'mysql') {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $pref_tbl (
-      userid     CHAR(48) BINARY NOT NULL UNIQUE,
-      prefs      TEXT NULL DEFAULT '',
-      PRIMARY KEY (userid)
-)");
-                } else {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $pref_tbl (
-      userid     CHAR(48) NOT NULL,
-      prefs      TEXT NULL DEFAULT ''
-)");
-                    $this->dbi->genericSqlQuery("CREATE UNIQUE INDEX userid ON $pref_tbl (userid)");
-                }
-                echo "  ", _("CREATED");
-                break;
-            case 'member':
-                $member_tbl = $prefix . 'member';
-                if ($backend_type == 'mysql') {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $member_tbl (
-    userid    CHAR(48) BINARY NOT NULL,
-       groupname CHAR(48) BINARY NOT NULL DEFAULT 'users',
-       INDEX (userid),
-       INDEX (groupname)
-)");
-                } else {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $member_tbl (
-    userid    CHAR(48) NOT NULL,
-       groupname CHAR(48) NOT NULL DEFAULT 'users'
-)");
-                    $this->dbi->genericSqlQuery("CREATE INDEX userid ON $member_tbl (userid)");
-                    $this->dbi->genericSqlQuery("CREATE INDEX groupname ON $member_tbl (groupname)");
-                }
-                echo "  ", _("CREATED");
-                break;
-            case 'rating':
-                $rating_tbl = $prefix . 'rating';
-                if ($backend_type == 'mysql') {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $rating_tbl (
-        dimension INT(4) NOT NULL,
-        raterpage INT(11) NOT NULL,
-        rateepage INT(11) NOT NULL,
-        ratingvalue FLOAT NOT NULL,
-        rateeversion INT(11) NOT NULL,
-        tstamp TIMESTAMP(14) NOT NULL,
-        PRIMARY KEY (dimension, raterpage, rateepage)
-)");
-                } else {
-                    $this->dbi->genericSqlQuery("
-CREATE TABLE $rating_tbl (
-        dimension INT(4) NOT NULL,
-        raterpage INT(11) NOT NULL,
-        rateepage INT(11) NOT NULL,
-        ratingvalue FLOAT NOT NULL,
-        rateeversion INT(11) NOT NULL,
-        tstamp TIMESTAMP(14) NOT NULL
-)");
-                    $this->dbi->genericSqlQuery("CREATE UNIQUE INDEX rating"
-                        . " ON $rating_tbl (dimension, raterpage, rateepage)");
-                }
-                echo "  ", _("CREATED");
-                break;
-            case 'accesslog':
-                $log_tbl = $prefix . 'accesslog';
-                // fields according to http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/#id2756178
-                /*
-                  A    User Agent agent    varchar(255)    Mozilla/4.0 (compat; MSIE 6.0; Windows)
-                  a    CGi request arguments    request_args    varchar(255)    user=Smith&cart=1231&item=532
-                  b    Bytes transfered    bytes_sent    int unsigned    32561
-                  c???    Text of cookie    cookie    varchar(255)    Apache=sdyn.fooonline.net 1300102700823
-                  f    Local filename requested    request_file    varchar(255)    /var/www/html/books-cycroad.html
-                  H    HTTP request_protocol    request_protocol    varchar(10)    HTTP/1.1
-                  h    Name of remote host    remote_host    varchar(50)    blah.foobar.com
-                  I    Request ID (from modd_unique_id)    id    char(19)    POlFcUBRH30AAALdBG8
-                  l    Ident user info    remote_logname    varcgar(50)    bobby
-                  M    Machine ID???    machine_id    varchar(25)    web01
-                  m    HTTP request method    request_method    varchar(10)    GET
-                  P    httpd cchild PID    child_pid    smallint unsigned    3215
-                  p    http port    server_port    smallint unsigned    80
-                  R    Referer    referer    varchar(255)    http://www.biglinks4u.com/linkpage.html
-                  r    Request in full form    request_line    varchar(255)    GET /books-cycroad.html HTTP/1.1
-                  S    Time of request in UNIX time_t format    time_stamp    int unsigned    1005598029
-                  T    Seconds to service request    request_duration    smallint unsigned    2
-                  t    Time of request in human format    request_time    char(28)    [02/Dec/2001:15:01:26 -0800]
-                  U    Request in simple form    request_uri    varchar(255)    /books-cycroad.html
-                  u    User info from HTTP auth    remote_user    varchar(50)    bobby
-                  v    Virtual host servicing the request    virtual_host    varchar(255)
-                */
-                $this->dbi->genericSqlQuery("
-CREATE TABLE $log_tbl (
-        time_stamp    int unsigned,
-    remote_host   varchar(100),
-    remote_user   varchar(50),
-        request_method varchar(10),
-    request_line  varchar(255),
-    request_args  varchar(255),
-    request_uri   varchar(255),
-    request_time  char(28),
-    status           smallint unsigned,
-    bytes_sent    smallint unsigned,
-        referer       varchar(255),
-    agent         varchar(255),
-    request_duration float
-)");
-                $this->dbi->genericSqlQuery("CREATE INDEX log_time ON $log_tbl (time_stamp)");
-                $this->dbi->genericSqlQuery("CREATE INDEX log_host ON $log_tbl (remote_host)");
-                echo "  ", _("CREATED");
-                break;
-        }
-        echo "<br />\n";
-    }
-
-    /**
-     * move _cached_html for all pages from pagedata into a new separate blob.
-     * decoupled from action=upgrade, so that it can be used by a WikiAdminUtils button also.
-     */
-    private function _convert_cached_html()
-    {
-        if (!$this->isSQL)
-            return 0;
-
-        $pages = $this->dbi->getAllPages();
-        $cache =& $this->dbi->_cache;
-        $count = 0;
-        extract($this->dbi->_backend->_table_names);
-        while ($page = $pages->next()) {
-            $pagename = $page->getName();
-            $data = $this->dbi->_backend->get_pagedata($pagename);
-            if (!empty($data['_cached_html'])) {
-                $cached_html = $data['_cached_html'];
-                $data['_cached_html'] = '';
-                $cache->update_pagedata($pagename, $data);
-                // store as blob, not serialized
-                $this->dbi->genericSqlQuery("UPDATE $page_tbl SET cached_html=? WHERE pagename=?",
-                    array($cached_html, $pagename));
-                $count++;
-            }
-        }
-        return $count;
-    }
-
-    /**
      * preg_replace over local file.
      * Only line-orientated matches possible.
      */

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.





2000	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct (43)	Nov (73)	Dec (10)
2001	Jan (34)	Feb (110)	Mar (24)	Apr (44)	May (37)	Jun (22)	Jul (20)	Aug (28)	Sep (50)	Oct (11)	Nov (132)	Dec (595)
2002	Jan (1099)	Feb (579)	Mar (63)	Apr	May	Jun	Jul	Aug (125)	Sep (101)	Oct (25)	Nov (34)	Dec (47)
2003	Jan (82)	Feb (182)	Mar (71)	Apr (3)	May (1)	Jun (3)	Jul	Aug	Sep (14)	Oct (6)	Nov (124)	Dec (68)
2004	Jan (64)	Feb (191)	Mar (199)	Apr (298)	May (252)	Jun (426)	Jul (134)	Aug (13)	Sep (96)	Oct (75)	Nov (232)	Dec (171)
2005	Jan (205)	Feb (165)	Mar (8)	Apr (74)	May (21)	Jun (19)	Jul (37)	Aug (69)	Sep (141)	Oct (118)	Nov (31)	Dec (7)
2006	Jan (5)	Feb (10)	Mar (35)	Apr (24)	May (34)	Jun (29)	Jul (5)	Aug (38)	Sep (30)	Oct (37)	Nov (30)	Dec (86)
2007	Jan (414)	Feb (40)	Mar (18)	Apr (10)	May (66)	Jun (60)	Jul (105)	Aug (55)	Sep (64)	Oct (7)	Nov (11)	Dec (5)
2008	Jan (26)	Feb (28)	Mar (79)	Apr (34)	May (61)	Jun (24)	Jul (29)	Aug (160)	Sep (62)	Oct (70)	Nov (32)	Dec (14)
2009	Jan (140)	Feb (135)	Mar (153)	Apr (53)	May (24)	Jun (138)	Jul (90)	Aug (46)	Sep (72)	Oct (84)	Nov (32)	Dec (4)
2010	Jan (13)	Feb (7)	Mar (14)	Apr (55)	May (89)	Jun (131)	Jul (41)	Aug (38)	Sep (42)	Oct (11)	Nov (27)	Dec (54)
2011	Jan (127)	Feb (16)	Mar (71)	Apr (52)	May (32)	Jun (31)	Jul (4)	Aug	Sep (45)	Oct (26)	Nov (36)	Dec (10)
2012	Jan (23)	Feb (6)	Mar (13)	Apr (18)	May (1)	Jun (4)	Jul (3)	Aug (12)	Sep (57)	Oct (96)	Nov (163)	Dec (124)
2013	Jan (11)	Feb (17)	Mar (7)	Apr (48)	May (15)	Jun (29)	Jul (12)	Aug	Sep (9)	Oct	Nov	Dec (3)
2014	Jan (4)	Feb (1)	Mar (2)	Apr (1)	May (8)	Jun (90)	Jul (104)	Aug (12)	Sep (81)	Oct (139)	Nov (111)	Dec (64)
2015	Jan (46)	Feb (74)	Mar (56)	Apr (61)	May (3)	Jun (7)	Jul (11)	Aug (5)	Sep (15)	Oct (1)	Nov (1)	Dec (15)
2016	Jan (25)	Feb (33)	Mar (24)	Apr (4)	May (24)	Jun (3)	Jul (75)	Aug	Sep (2)	Oct (38)	Nov (4)	Dec (18)
2017	Jan (8)	Feb (1)	Mar (1)	Apr	May (14)	Jun	Jul (5)	Aug (9)	Sep	Oct (23)	Nov	Dec
2018	Jan	Feb	Mar	Apr	May	Jun (2)	Jul	Aug	Sep	Oct	Nov	Dec
2019	Jan	Feb	Mar (9)	Apr (60)	May (1)	Jun	Jul (13)	Aug	Sep (11)	Oct	Nov	Dec
2020	Jan	Feb	Mar (15)	Apr (4)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec (47)
2021	Jan (24)	Feb (33)	Mar (1)	Apr	May (1)	Jun (64)	Jul (71)	Aug (114)	Sep (82)	Oct (32)	Nov (76)	Dec (86)
2022	Jan (162)	Feb (41)	Mar (11)	Apr (9)	May	Jun	Jul (1)	Aug (2)	Sep	Oct	Nov	Dec (7)
2023	Jan	Feb (1)	Mar (2)	Apr	May	Jun	Jul (25)	Aug	Sep	Oct	Nov (7)	Dec
2024	Jan (7)	Feb (3)	Mar (3)	Apr (1)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2025	Jan	Feb (90)	Mar (19)	Apr	May (6)	Jun	Jul	Aug	Sep	Oct	Nov	Dec

phpwiki-checkins Mailing List for PhpWiki (Page 33)

phpwiki-checkins — Automatic notification of CVS checkins on PhpWiki.