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;
     }
 }
Пример #2
0
 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;
     }
 }
Пример #3
0
 public static function doit($sql)
 {
     $con = Database::getCon();
     if (Core::$debug_sql) {
         print "<pre>" . $sql . "</pre>";
     }
     return array($con->query($sql), $con->insert_id);
 }
Пример #4
0
 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;
     }
 }
Пример #8
0
 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;
 }
Пример #9
0
 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;
     }
 }
Пример #10
0
 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;
 }
Пример #11
0
 /**
  * 
  * 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;
 }
Пример #12
0
 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;
     }
 }
Пример #13
0
 /**
  * 
  * 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();
 }
Пример #14
0
 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;
     }
 }
Пример #16
0
 /**
  * 
  * 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();
 }
Пример #17
0
 public static function doit($sql)
 {
     $con = Database::getCon();
     return array($con->query($sql), $con->insert_id);
 }