/
update.php
416 lines (343 loc) · 19.2 KB
/
update.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
<?php
// -----------------------------------------------------------
// Version 2.1.12
// -----------------------------------------------------------
require_once ('paths.php');
require_once (INCLUDES.'url_variables.inc.php');
$section = "update";
ini_set('session.cookie_httponly', 1);
ini_set('session.use_only_cookies', 1);
// Uses a secure connection (HTTPS) if possible
ini_set('session.cookie_secure', 1);
if (SINGLE) require_once(SSO.'sso.inc.php');
require_once (LIB.'common.lib.php');
require_once (LIB.'update.lib.php');
require_once (INCLUDES.'db_tables.inc.php');
require_once (LIB.'help.lib.php');
require_once (DB.'common.db.php');
require_once (INCLUDES.'constants.inc.php');
require_once (LANG.'language.lang.php');
require_once (INCLUDES.'headers.inc.php');
require_once (INCLUDES.'scrubber.inc.php');
if (HOSTED) check_hosted_gh();
// Get current version from DB
if (table_exists($prefix."system")) {
$query_system = sprintf("SELECT version FROM %s", $prefix."system");
$system = mysqli_query($connection,$query_system) or die (mysqli_error($connection));
$row_system = mysqli_fetch_assoc($system);
$version = $row_system['version'];
}
// Define vars
$section = "update";
// Set timezone globals for the site
$timezone_raw = "0";
// Check whether prefs have been established
// If so, get time zone set by admin
if (check_setup($prefix."preferences",$database)) {
$query_prefs_tz = sprintf("SELECT prefsTimeZone FROM %s WHERE id='1'", $prefix."preferences");
$prefs_tz = mysqli_query($connection,$query_prefs_tz) or die (mysqli_error($connection));
$row_prefs_tz = mysqli_fetch_assoc($prefs_tz);
$totalRows_prefs_tz = mysqli_num_rows($prefs_tz);
if ($totalRows_prefs_tz > 0) {
$timezone_raw = $row_prefs_tz['prefsTimeZone'];
}
}
// Establish time zone for all date-related functions
$timezone_prefs = get_timezone($timezone_raw);
date_default_timezone_set($timezone_prefs);
$tz = date_default_timezone_get();
// Check for Daylight Savings Time (DST) - if true, add one hour to the offset
$bool = date("I");
if ($bool == 1) $timezone_offset = number_format(($timezone_raw + 1.000),0);
else $timezone_offset = number_format($timezone_raw,0);
$filename = INCLUDES."version.inc.php";
$update_alerts = "";
$update_body = "";
$output = "";
if (file_exists($filename)) {
// check to see if the "system" db table is present, if not, use the legacy hard-coded version
if (!check_setup($prefix."system",$database)) require(INCLUDES.'version.inc.php');
if (($action == "default") && ($version != $current_version)) $update_alerts .= "<div class=\"alert alert-info\"><span class=\"fa fa-lg fa-info-circle\"></span> <strong>The BCOE&M ".$current_version_display." Database Update Script must be run to update the database.</strong></div>";
if (check_setup($prefix."preferences",$database)) {
if ((isset($_SESSION['loginUsername'])) && ($_SESSION['userLevel'] <= 1)) {
if (($current_version != $version) || (($current_version == $version) && ($version_date < $current_version_date))) {
if ($action == "default") {
$update_alerts .= "<div class=\"alert alert-danger\"><span class=\"fa fa-lg fa-exlamation-circle text-danger\"></span> <strong>Before running this script</strong>, make sure that you have uploaded the necessary version ".$current_version_display." files to your installation's root folder on your webserver and <strong>BACKED UP</strong> your MySQL database.</div>";
$update_body .= "<p class=\"lead\">";
$update_body .= "This script will update your BCOE&M database from its current version, ";
$update_body .= $version;
if (($version == $current_version) && ($version_date < $current_version_date)) $update_body .= " (Build ".$row_version['version_date'].")";
$update_body .= ", to the latest version, ";
$update_body .= $current_version;
if (($version == $current_version) && ($version_date < $current_version_date)) $update_body .= " (Build ".$current_version_date_display.")";
$update_body .= ".</p>";
$update_body .= "<p class=\"lead\"><small><strong class=\"text-danger\">Please note!</strong> This update contains a conversion script that affects each table in your database. Therefore, it may take a while to run. Please be patient!</small></p>";
$update_body .= "<div class=\"bcoem-admin-element-bottom\"><a class=\"btn btn-primary btn-lg btn-block\" href=\"update.php?action=update\" data-confirm=\"Are you sure? Have you backed up your MySQL database? This will update your current installation and cannot be stopped once begun. Please note that the update may take some time to complete, so patience is warranted!\"><span class=\"fa fa-cog fa-spin\"></span> Begin The Update</a></div>";
}
if ($action == "update") {
// Perform updates to the db based upon the current version
$version = str_replace(".","",$version);
if ($version == "200") $version = "2000";
if ($version < "113") {
$update_alerts .= "<div class=\"alert alert-danger\"><span class=\"fa fa-lg fa-exclamation-circle\"></span> Your installed version is incompatible with this update script.</div>";
$output .= "<p>Please update your database and files manually through version 1.1.2.0 to utilize the update feature.</p>";
}
if (($version == "113") || ($version == "1130")) {
include (UPDATE.'1.1.4.0_update.php');
include (UPDATE.'1.1.5.0_update.php');
include (UPDATE.'1.1.6.0_update.php');
include (UPDATE.'1.2.0.0_update.php');
include (UPDATE.'1.2.0.3_update.php');
include (UPDATE.'1.2.1.0_update.php');
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version == "114") || ($version == "1140")) {
include (UPDATE.'1.1.5.0_update.php');
include (UPDATE.'1.1.6.0_update.php');
include (UPDATE.'1.2.0.0_update.php');
include (UPDATE.'1.2.0.3_update.php');
include (UPDATE.'1.2.1.0_update.php');
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version == "115") || ($version == "1150")) {
include (UPDATE.'1.1.6.0_update.php');
include (UPDATE.'1.2.0.0_update.php');
include (UPDATE.'1.2.0.3_update.php');
include (UPDATE.'1.2.1.0_update.php');
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version == "116") || ($version == "1160") || ($version == "1161")) {
include (UPDATE.'1.2.0.0_update.php');
include (UPDATE.'1.2.0.3_update.php');
include (UPDATE.'1.2.1.0_update.php');
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "1200") && ($version < "1203")) {
include (UPDATE.'1.2.0.3_update.php');
include (UPDATE.'1.2.1.0_update.php');
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "1203") && ($version < "1210")) {
include (UPDATE.'1.2.1.0_update.php');
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "1210") && ($version < "1300")) {
include (UPDATE.'1.3.0.0_update.php');
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "1300") && ($version < "1320")) {
include (UPDATE.'1.3.2.0_update.php');
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "1320") && ($version < "2000")) {
include (UPDATE.'2.0.0.0_update.php');
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "2000") && ($version < "2100")) {
include (UPDATE.'2.1.0.0_update.php');
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "2100") && ($version < "2150")) {
include (UPDATE.'2.1.5.0_update.php');
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "2150") && ($version < "2180")) {
include (UPDATE.'2.1.8.0_update.php');
include (UPDATE.'current_update.php');
}
if (($version >= "2180") && ($version < "21120")) {
include (UPDATE.'current_update.php');
}
if ($version >= "113") {
// Due to session caching introduced in 1.3.0.0, need to destroy the session.
session_unset();
session_destroy();
session_write_close();
session_regenerate_id(true);
$update_alerts .= "<div class=\"alert alert-success\"><span class=\"fa fa-lg fa-check-circle\"></span> <strong>Update to ".$current_version_display." Complete!</strong></div>";
// -----------------------------------------------------------
// Finish and Clean Up
// -----------------------------------------------------------
$update_body .= "<p>To take advantage of this version's added features, you'll need to log in again and update the following:</p>";
$update_body .= "<ul>";
$update_body .= "<li>Your site preferences.</li>";
$update_body .= "<li>Your site judging preferences.</li>";
$update_body .= "<li>Your competition’s specific information.</li>";
$update_body .= "</ul>";
$update_body .= "<a class=\"btn btn-primary btn-lg\" role=\"button\" href='".$base_url."index.php?section=login'>Log In</a>";
$update_body .= "<h3>Updates Performed Are Detailed Below</h3>";
$update_body .= $output;
}
} // end if ($action == "update")
} // end compare versions
// if current version is same as installed version...
else {
$update_alerts .= "<div class=\"alert alert-info\"><span class=\"fa fa-lg fa-info-circle\"></span> No database updates are necessary for version ".$current_version_display.".</div>";
$update_body .= "<p class=\"lead\">Your installation is up to date!</p>";
$update_body .= "<div class=\"btn-group\" role=\"group\">";
$update_body .= "<a class=\"btn btn-default btn-lg\" href=\"".$base_url."\">Go to the Home Page</a>";
$update_body .= "<a class=\"btn btn-default btn-lg\" href=\"".$base_url."index.php?section=admin\">Go to the Admin Dashboard</a>";
$update_body .= "</div>";
}
} // end check of user level
// if user is not logged in or an admin...
else {
$update_alerts .= "<div class=\"alert alert-danger\"><span class=\"fa fa-lg fa-exclamation-circle\"></span> <strong>Only top level administrators are able to access and perform updates.</strong>";
if ((isset($_SESSION['loginUsername'])) && ($row_user_level['userLevel'] > 0)) $update_alerts .= " You do not have administrative access to this site.";
$update_alerts .= "</div>";
if (!isset($_SESSION['loginUsername'])) {
$update_body .= "<p class=\"lead\">If you are an administrator of this site, log in and try again.</p>";
}
}
} // end if preferences exists check
// If preferences table does not exist...
else {
$update_alerts .= "<div class=\"alert alert-danger\"><span class=\"fa fa-lg fa-exclamation-circle\"></span> <strong>It looks like one or more tables in the database called $database are either missing or not setup correctly.</strong></div>";
if ($prefix != "") $update_alerts .= "<h3>Prefix Defined</h3>";
$update_body .= "<p>You have indicated in the config.php file that a prefix of $prefix should be prepended to each table name. Is this correct? If not, make the required changes to the config.php file and try again.</p>";
$update_body .= "<p>Please run the <a href='setup.php'>install and setup utility</a> to install the correct database tables.</p>";
}
} // end if version.inc.php file exists
else {
$update_alerts .= "<div class=\"alert alert-danger\"><span class=\"fa fa-lg fa-exclamation-circle\"></span> <strong>The update script cannot run.</strong> The version.inc.php file does not exist in the /includes/ directory of your BCOE&M installation.</div>";
$update_body .= "<p>Currently your installation's base URL is <strong><?php echo $base_url; ?></strong>. If this is incorrect, you will need to <strong>edit the $base_url variable in the config.php file</strong>, located in your installation's /sites/ directory.</p>";
$update_body .= "<p><strong>Make sure the version.inc.php file from your <em>previous</em> installation is in your current installation's /includes/ directory.</strong> The update script utilizes this file to determine which database tables to update and install.</p>";
$update_body .= "<p>If you do not have the version.inc.php file from your previous version, create a new document locally, name it <em>version.inc.php</em> and copy/paste the following single line of code into the new document. <strong> Don't forget to change the version number!</strong></p>";
$update_body .= "<blockquote><pre><?php $version = \"1.2.0.4\"; ?></pre></blockquote>";
$update_body .= "<p>Save the file, upload to your installation's /includes/ directory, and run this script again.</p>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Update to BCOE&M <?php echo $current_version_display; ?></title>
<!-- Load jQuery / http://jquery.com/ -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
<!-- Load Bootstrap / http://www.getbootsrap.com -->
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<!-- Load Font Awesome / https://fortawesome.github.io/Font-Awesome -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">
<!-- Load BCOE&M Custom Theme CSS - Contains Bootstrap overrides and custom classes -->
<link rel="stylesheet" type="text/css" href="<?php echo $base_url; ?>/css/default.min.css" />
<!-- Load BCOE&M Custom JS -->
<script src="<?php echo $base_url; ?>js_includes/bcoem_custom.min.js"></script>
</head>
<body>
<!-- MAIN NAV -->
<div class="container-fluid hidden-print">
<!-- Fixed navbar -->
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bcoem-navbar-collapse" aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
</div>
<div class="collapse navbar-collapse" id="bcoem-navbar-collapse">
<ul class="nav navbar-nav">
<li><a href="<?php echo $base_url; ?>">Home</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<?php if (isset($_SESSION['loginUsername'])) { ?>
<li role="presentation" class="text-muted"><a href="#">Logged in as <?php echo $_SESSION['loginUsername']; ?></a></li>
<?php } else { ?>
<li><a href="<?php echo $base_url; ?>index.php?section=login">Log In</a></li>
<?php } ?>
</ul>
</div><!--/.nav-collapse -->
</div>
</nav>
</div><!-- container -->
<!-- ./MAIN NAV -->
<!-- ALERTS -->
<div class="container-fluid bcoem-warning-container">
<?php echo $update_alerts; ?>
</div><!-- ./container -->
<!-- ./ALERTS -->
<!-- Update Pages (Fluid Layout) -->
<div class="container-fluid">
<?php if (DEBUG_SESSION_VARS) include (DEBUGGING.'session_vars.debug.php'); ?>
<div class="page-header">
<h1>BCOE&M <?php echo $current_version_display; ?> Update</h1>
</div>
<?php echo $update_body; ?>
<?php if (!isset($_SESSION['loginUsername'])) { ?>
<div class="bcoem-admin-element-bottom">
<?php include (SECTIONS.'login.sec.php'); ?>
</div>
<?php } ?>
</div><!-- ./container-fluid -->
<!-- ./Update Pages -->
<!-- Footer -->
<footer class="footer">
<nav class="navbar navbar-inverse navbar-fixed-bottom">
<div class="container-fluid text-center">
<p class="navbar-text col-md-12 col-sm-12 col-xs-12 text-muted small"><?php include (SECTIONS.'footer.sec.php'); ?></p>
</div>
</nav>
</footer><!-- ./footer -->
<!-- ./ Footer -->
</body>
</html>