<?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>";

}