public static function checkStartStopServerState() { $con = Database::getCon(); $res = $con->query("SELECT * FROM gameserver " . "WHERE status = " . GAMESERVER_STATUS_CHECK_START . " " . "OR status = " . GAMESERVER_STATUS_CHECK_STOP); if ($res->num_rows) { $d = array(); while ($row = $res->fetch_assoc()) { $gs = new Gameserver($row["id"], $row); if ($gs->statusWaitedFree()) { $time = time(); $lastUpdate = strtotime($gs->GetData('lastStatusUpdate')); if ($gs->isRunningOnServer()) { echo $gs->getTemplate()->getData("gameName"); echo "-Server started stop.."; $gs->updateStatus(GAMESERVER_STATUS_RUNNING); } else { echo $gs->getTemplate()->getData("gameName"); echo "-Server wasnt started."; $gs->updateStatus(GAMESERVER_STATUS_IDLE); } } } return $d; } else { return false; } }
public static function checkView($servid, $field, $table) { // vamos a verficar que no se haya visto el servicio en un lapso de tiempo $con = Database::getCon(); // $sql = "select serviceview.id as svid, iplog.id as ilid serviceview inner join iplog on (serviceview.iplog_id=iplog.id) where $field=$servid and order by created_at desc limit 1"; $sql = "select * from {$table} where realip='" . IpLogger::getRealIP() . "' and {$field}='{$servid}' order by created_at desc limit 1"; $query = $con->query($sql); $found = false; $ca = 0; while ($r = $query->fetch_array()) { $found = true; $ca = $r['created_at']; } if ($found == true) { $ca2 = $ca + 24 * 3600; if (time() >= $ca2) { $found = false; } } if ($found == false) { return true; } else { return false; } }
public static function doit($sql) { $con = Database::getCon(); if (Core::$debug_sql) { print "<pre>" . $sql . "</pre>"; } return array($con->query($sql), $con->insert_id); }
public function setPassword($password) { $con = Database::getCon(); $password = md5($con->real_escape_string($password)); $id = $this->getData('id'); //$stmt = $con->init(); $stmt = $con->prepare("UPDATE users SET password = ? WHERE id = ?"); $stmt->bind_param("si", $password, $id); $stmt->execute(); }
public function setData($colName, $value) { $this->Data[$colName] = $value; $con = Database::getCon(); $table = $con->escape_string($this->_dbTable); $colname = $con->escape_string($colName); $whereColName = $con->escape_string($this->_dbColName); $prep = $con->prepare("UPDATE {$table} SET {$colName} = ? WHERE {$whereColName} = ?") or die(mysqli_error($con)); $prep->bind_param("ss", $value, $this->_dbColVal); $prep->execute(); }
public function getUsedPorts() { $usedPorts = array(); $con = Database::getCon(); $res = $con->query("SELECT port FROM gameserver WHERE serverID = " . $this->getData("id")); if ($res->num_rows) { while ($row = $res->fetch_assoc()) { $usedPorts[] = $row["port"]; } return $usedPorts; } else { return array(); } }
public static function getAllGameserverTemplates() { $con = Database::getCon(); $res = $con->query("SELECT * FROM templates WHERE baseTemplate = 0"); if ($res->num_rows) { $d = array(); while ($row = $res->fetch_assoc()) { $d[] = new Template($row["id"], $row); } return $d; } else { return false; } }
public static function verifyIP() { $con = Database::getCon(); $sql = "select * from iplog where realip=\"" . self::getRealIP() . "\" and user_id=" . Session::getUID(); $query = $con->query($sql); $found = false; $ca = ""; while ($r = $query->fetch_array()) { $found = true; $ca = $r['created_at']; } if ($found == true) { $ca2 = $ca + 24 * 3600; if (time() >= $ca2) { $found = false; } } return $found; }
public function __construct($id = -1, $row = null) { if ($id != -1) { // Check if (null != $row) { $this->Data = $row; } else { $con = Database::getCon(); $res = $con->query("SELECT * FROM templates WHERE id = {$id}") or die(mysqli_error($con)); $this->Data = $res->fetch_array(); } $this->Data["infoxmlar"] = Utils::xmlToArray(simplexml_load_string($this->Data["infoxml"])); $this->Data["existsInDB"] = true; } else { $this->Data["id"] = -1; $this->Data["gameName"] = ""; $this->Data["iconFile"] = ""; $this->Data["existsInDB"] = false; } }
public static function getOldestUndoneTask() { $con = Database::getCon(); $stmt = $con->prepare("SELECT MIN(id) FROM tasks WHERE done = 0") or die(mysqli_error($con)); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows) { $stmt->bind_result($id); $stmt->fetch(); if (!empty($id)) { $ret = new Task($id); } else { $ret = null; } } else { $ret = null; } $stmt->free_result(); $stmt->close(); return $ret; }
/** * * Returns the latest Task Log * * @param string $log The logname (equals database table without the "logs_" prefix * @param integer $limit Number of log entries * @return array */ private static function getLatestLog($log, $limit) { if (!is_numeric($limit)) { die("Limit has to be a number"); } $con = Database::getCon(); $res = $con->query("SELECT * FROM logs_" . $log . " ORDER BY id DESC LIMIT {$limit}"); $ret = array(); while ($row = $res->fetch_assoc()) { $ret[] = $row; } return $ret; }
public static function addUser($username, $prename, $lastname, $email) { $error = array(); $err = @Utils::checkInput($_POST['username'], "Username", 3, 64, INPUT_TYPE_STRING); if (strlen($err) != 0) { $error[] = $err; } $err = @Utils::checkInput($_POST['prename'], "Prename", 3, 64, INPUT_TYPE_STRING); if (strlen($err) != 0) { $error[] = $err; } $err = @Utils::checkInput($_POST['lastname'], "Lastname", 3, 64, INPUT_TYPE_STRING); if (strlen($err) != 0) { $error[] = $err; } $err = @Utils::checkInput($_POST['email'], "E-Mail", 3, 64, INPUT_TYPE_EMAIL); if (strlen($err) != 0) { $error[] = $err; } if (count($error) == 0) { $con = Database::getCon(); $pass = $con->escape_string(Utils::rand_string(8)); $passHashed = md5($pass); $data = array(); $data["username"] = $username; $data["prename"] = $prename; $data["lastname"] = $lastname; $data["email"] = $email; $data["password"] = $passHashed; Database::insertQuery("users", $data); if (Core::GetConfig("sendEmails")) { $mail = new Mail($email, "CustomerAdd.tpl", "User Creation Wolfpanel"); $mail->assignVar("username", $username); $mail->assignVar("email", $email); $mail->assignVar("website", Core::GetConfig("pubURI")); $mail->assignVar("password", $pass); $mail->send(); } } else { return $error; } }
/** * * Deletes a row by field and value * * @param type $table The mysql table * @param type $field The mysql column name * @param type $value The mysql column value */ public static function rowDeleteByField($table, $field, $value) { $con = Database::getCon(); $stmt = $con->prepare("DELETE FROM {$table} WHERE {$field} = ?") or die(mysqli_error($con)); $stmt->bind_param("i", $value); $stmt->execute(); $stmt->close(); }
public function delete() { $con = Database::getCon(); $con->query("DELETE FROM tasks WHERE id = " . $this->getData("id")); }
public static function getAllPhysicalServer() { $con = Database::getCon(); $res = $con->query("SELECT id FROM physicalserver"); if ($res->num_rows) { $d = array(); while ($row = $res->fetch_assoc()) { $d[] = new PhysicalServer($row["id"]); } return $d; } else { return false; } }
/** * * Saves the user settings to the database and schedules the update of the files. * */ public function saveSettings() { $db = Database::getCon(); $prep = $db->Prepare("UPDATE gameserver SET settings = ? WHERE id = ?"); $jsonSettings = json_encode($this->Data["settings"]); @$prep->bind_param("si", $jsonSettings, $this->getData("id")); $prep->execute(); $this->scheduleSettingsUpdateOnServer(); }
public static function doit($sql) { $con = Database::getCon(); return array($con->query($sql), $con->insert_id); }