public function actionCheckReady()
{
//check databse
$database = getSQLDB();
if (!$database) {
$this->result["status"] = -2;
$this->result["msg"] = "Cannot connect to DB";
return;
}
if ($this->checkReady() != true) {
$this->result["status"] = -1;
return;
}
//gather system info
$info = array();
$info["version"] = $this->version;
dispatchEventToModules("onSystemInfo", $info);
$this->result["info"] = $info;
$this->result["status"] = 1;
}
public function searchFilesFromDBByCategory($unit_id, $category, $limit = 50, $offset = 0)
{
$category = addslashes($category);
$database = getSQLDB();
$query = "SELECT * FROM `" . DB_PREFIX . "files` WHERE `category` = '" . $category . "' AND unit_id = " . intval($unit_id) . " LIMIT " . intval($offset) . "," . intval($limit);
//debug($query);
$result = $database->query($query);
if (!$result) {
return null;
}
$files = array();
while ($file = $result->fetch_object()) {
$files[] = $file;
}
return $files;
}
public function createTables()
{
$database = getSQLDB();
//USERS table
$query = "CREATE TABLE IF NOT EXISTS " . DB_PREFIX . "users (\r\n\t\t `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `username` varchar(255) NOT NULL,\r\n\t\t `password` varchar(255) NOT NULL,\r\n\t\t `email` varchar(255) NOT NULL,\r\n\t\t `roles` varchar(255) NOT NULL,\r\n\t\t `data` text NOT NULL,\r\n\t\t `used_space` int(10),\r\n\t\t `total_space` int(10),\r\n\t\t PRIMARY KEY (`id`),\r\n\t\t UNIQUE KEY `email` (`email`),\r\n\t\t `status` ENUM('PENDING','VALID','BANNED') NOT NULL\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
$result = $database->query($query);
if ($result !== TRUE) {
debug("Users table not created");
$this->result["msg"] = "Users table not created";
$this->result["status"] = -1;
return false;
} else {
debug("Users table created");
}
//SESSIONS table
$query = "CREATE TABLE IF NOT EXISTS " . DB_PREFIX . "sessions (\r\n\t\t `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `user_id` int(10) NOT NULL,\r\n\t\t `token` varchar(255) NOT NULL,\r\n\t\t `timestamp` TIMESTAMP NOT NULL,\r\n\t\t PRIMARY KEY (id)\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
$result = $database->query($query);
if ($result !== TRUE) {
debug("Users sessions table not created");
$this->result["msg"] = "Users sessions table not created";
$this->result["status"] = -1;
return false;
} else {
debug("Users sessions table created");
}
//PASS RECOVERY table
$query = "CREATE TABLE IF NOT EXISTS " . DB_PREFIX . "pass_recovery (\r\n\t\t `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t `user_id` int(10) NOT NULL,\r\n\t\t `token` varchar(255) NOT NULL,\r\n\t\t `timestamp` TIMESTAMP NOT NULL,\r\n\t\t PRIMARY KEY (id)\r\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1";
$result = $database->query($query);
if ($result !== TRUE) {
debug("Password recovery table not created");
$this->result["msg"] = "Password recovery table not created";
$this->result["status"] = -1;
return false;
} else {
debug("Password recovery table created");
}
return true;
}
if (!file_exists(__DIR__ . "/include/config.php")) {
showMessage("Cannot find <strong>include/config.php</strong> file, please remember to create a copy of <strong>config.sample.php</strong> as <strong>config.php </strong> and edit it with your DB values.");
die($end_string);
} else {
showMessage("config.php found, testing database connection", "success");
}
//include core
require_once 'include/core.php';
loadModules("*");
//check config has valid values
if (ADMIN_PASS == "" || ADMIN_MAIL == "") {
showMessage("Error: Config.php must be changed, edit the config.php and add a password and an email for the admin account.");
die($end_string);
}
//check if config works
$database = getSQLDB();
if (!$database) {
showMessage("Cannot connect to database, check that the info inside config.php is correct and your databse running.");
die($end_string);
} else {
showMessage("Database connection established", "success");
}
//check if there is data still
$system = getModule("system");
$is_ready = $system->checkReady();
if ($is_ready && $console && count($argv) > 1 && $argv[1] == "upgrade") {
showMessage("Upgrading system...", "primary");
$system->upgradeSystem();
showMessage("System upgraded", "success");
die($end_string);
}
