mirror of
https://gitlab.com/JKANetwork/CheckServer.git
synced 2026-02-14 17:21:35 +01:00
54 lines
2.0 KiB
PHP
54 lines
2.0 KiB
PHP
<?php
|
|
echo "<h2>Updater of CheckServer</h2>";
|
|
echo "<p>Connecting to database</p>";
|
|
require_once 'lib/dbwrapper.php';
|
|
$db_file = __DIR__."/sqlite.db3";
|
|
if (!is_file($db_file)){ //Go to install if not.
|
|
header("Location: install.php");
|
|
die();
|
|
}
|
|
$db_conn = dbw_connect("sqlite",$db_file); //Database
|
|
dbw_query($db_conn,"UPDATE SYS SET value='1' WHERE option='maintenance'");
|
|
$version = dbw_query_fetch_array($db_conn,"SELECT value FROM SYS WHERE option = 'version'")[0];
|
|
echo "<p>Your version: ".$version;
|
|
echo "<p>Updating to lastest</p>";
|
|
switch ($version){
|
|
case '0.9':
|
|
echo "<p>0.9->0.9.1<p>";
|
|
dbw_query($db_conn,"DELETE FROM SYS WHERE option='maxChecksSave'");
|
|
dbw_query($db_conn,"INSERT INTO SYS VALUES('maxTimeSave',14)");
|
|
//Can not delete USERS.SessionID because sqlite3 not supports it, but doesn't do any harm.
|
|
case '0.9.1':
|
|
echo "<p>0.9.1->0.9.2</p>";
|
|
case '0.9.2':
|
|
echo "<p>0.9.2->0.9.3</p>";
|
|
dbw_query($db_conn,'ALTER TABLE CHECKS RENAME TO CHECKS_orig;');
|
|
dbw_query($db_conn,'
|
|
CREATE TABLE "CHECKS" (
|
|
`ID_C` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`ID_G` INTEGER,
|
|
`ID_TC` INTEGER,
|
|
`name` TEXT NOT NULL,
|
|
`url` TEXT,
|
|
`manStatus` INTEGER,
|
|
`urlParam` TEXT,
|
|
`exceptedRes` TEXT,
|
|
FOREIGN KEY(`ID_G`) REFERENCES `GROUPS`(`ID_G`),
|
|
FOREIGN KEY(`ID_TC`) REFERENCES `TYPECHK`(`ID_TC`)
|
|
);
|
|
');
|
|
dbw_query($db_conn,"INSERT INTO CHECKS(ID_C, ID_G,ID_TC,name,url,manStatus,urlParam) SELECT ID_C,ID_G,ID_TC,name,URL,manStatus,TCParam FROM CHECKS_orig;");
|
|
dbw_query($db_conn,"DROP TABLE CHECKS_orig");
|
|
dbw_query($db_conn,"INSERT INTO SYS VALUES ('maintenance','1')"); //New system opt
|
|
|
|
case '0.9.3':
|
|
echo "<p>0.9.3->0.9.4</p>";
|
|
case '0.9.4':
|
|
dbw_query($db_conn,"UPDATE SYS SET value='0.9.4' WHERE option='version'");
|
|
dbw_query($db_conn,"UPDATE SYS SET value='0' WHERE option='maintenance'");
|
|
echo "<p>0.9.4-Lastest</p>";
|
|
echo "<p>Updated to lastest. Close this and go to index</p>";
|
|
echo "<p>Remember to delete updater.php and install.php for security!</p>";
|
|
|
|
}
|