2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Blue Static
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
22 define('STOP_MARK', 4);
23 define('ACTIVE_SITE', 'upgrade11.php');
25 require_once('./global.php');
26 require_once('./includes/functions_datastore.php');
30 // ###################################################################
32 if ($bugsys->in
['mark'] == 0)
35 <h1
>Welcome to Bugdar
</h1
>
37 <p
>This upgrade will move you from Bugdar
1.1.5 to Bugdar
1.2.0 Beta
1.</p
>
39 <p
>To begin the process
, please click the button below
.</p
>
43 // ###################################################################
45 if ($bugsys->in
['mark'] == 1)
48 <h1
>Minor Database Table Changes
</h1
>
50 <p
>There are a few minor changes made to Bugdar
's database schema that need to be propagated.</p>
53 $db->query("ALTER TABLE " . TABLE_PREFIX . "comment ADD parselinks BOOL NULL");
54 echo "Adding comment.parselinks to add an option to parse links in comments<br />\n";
56 $db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD columnoptions TEXT NULL");
57 echo "Adding user.columnoptions to allow for custom column sorting<br />\n";
59 $db->query("ALTER TABLE " . TABLE_PREFIX . "product CHANGE componentmother parentid INT UNSIGNED NULL");
60 echo "Renaming product.componentmother to product.parentid<br />\n";
62 $db->query("ALTER TABLE " . TABLE_PREFIX . "version ADD obsolete BOOL NULL");
63 echo "Adding version.obsolete so products cannot be filed against certain versions<br />\n";
65 $db->query("ALTER TABLE " . TABLE_PREFIX . "user ADD authid VARCHAR(255) NULL");
66 echo "Adding user.authid for the Authentication API<br />\n";
68 echo "... done<br />\n";
71 // ###################################################################
73 if ($bugsys->in['mark
'] == 2)
76 <h1>Search Table Changes</h1>
78 <p>To support saved searches, a few major modifications need to be performed on the search table.</p>
81 $db->query("ALTER TABLE " . TABLE_PREFIX . "search DROP PRIMARY KEY");
82 echo "Dropping current primary key<br />\n";
84 $db->query("ALTER TABLE " . TABLE_PREFIX . "search ADD searchid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY");
85 echo "Adding search.searchid as a new primary key<br />\n";
87 $db->query("ALTER TABLE " . TABLE_PREFIX . "search ADD name VARCHAR(250) NULL");
88 echo "Adding search.name to allow naming of searches<br />\n";
90 echo "... done<br />\n";
93 // ###################################################################
95 if ($bugsys->in['mark
'] == 3)
98 <h1>Database Table Additions</h1>
100 <p>A few new features require new database tables, so we're adding those now
.</p
>
104 CREATE TABLE " . TABLE_PREFIX
. "passwordreset
106 activatorid VARCHAR(250) NOT NULL,
108 dateline INT NOT NULL,
109 PRIMARY KEY (activatorid)
112 echo "Creating passwordreset table to create a 'lost password' functionality<br />\n";
115 CREATE TABLE " . TABLE_PREFIX
. "adminsession
117 sessionid VARCHAR(250) NOT NULL,
118 userid INT UNSIGNED NOT NULL,
119 dateline INT UNSIGNED NOT NULL,
120 PRIMARY KEY (sessionid)
123 echo "Creating adminsession table to greatly improve the admin control panel security<br />\n";
126 CREATE TABLE " . TABLE_PREFIX
. "template
128 filename VARCHAR(255) NOT NULL,
129 template TEXT NOT NULL,
130 timestamp INT(10) UNSIGNED NOT NULL,
131 PRIMARY KEY (filename)
134 echo "Creating template table to cache templates in the database to greatly inprove speed<br />\n";
136 echo "... done<br />\n";
139 // ###################################################################
141 if ($bugsys->in
['mark'] == 4)
144 <h1
>Version Number Change
</h1
>
146 <p
>This step finishes the upgrade by inreasing your version number
.</p
>
150 require_once('./includes/settings.php');
152 $db->query("UPDATE " . TABLE_PREFIX
. "setting SET value = '1.2.0 Beta 1' WHERE varname = 'trackerversion'");
163 // ###################################################################
167 /*=====================================================================*\
168 || ###################################################################
171 || ###################################################################
172 \*=====================================================================*/