Offline |
|
|
Csatlakozott:2018.11.02. 12:23 Hozzászólások:148 Megköszönt másnak: 2 alkalommal Megköszönték neki: 19 alkalommal
|
Szia kedves idegen. [profil]BeepBeep[/profil] Ebből a cfg fájlból, kellene kinyerni az SQL táblákat és oszlopokat. Tudom nincs sehol se értek, de értelem szerűen, ha password van, akkor az VARCHAR és legyen 64 karakterig terjedő. Nem egy nagy meló szerintem, de nekem nincs nagyon időm Egy kis segítség:PREPARE("SELECT id FROM `users` WHERE username = :username"); PREPARE("SELECT id FROM `users` WHERE megerosito = :megerosito"); PREPARE("SELECT id FROM `ftpd` WHERE User = :username"); PREPARE("SELECT id FROM `users` WHERE email = :email"); PREPARE("SELECT id FROM `servers` WHERE port = :port"); PREPARE("SELECT id FROM `servers` WHERE owner = :owner"); PREPARE("SELECT id FROM `servers` WHERE port = :port AND owner = :owner"); PREPARE("SELECT id FROM `log` WHERE ki = :ki"); PREPARE("SELECT rank FROM `users` WHERE id = :id"); PREPARE("SELECT * FROM `beallitasok` WHERE karbantartas = :id"); PREPARE("SELECT username FROM `users` WHERE id = :id"); PREPARE("SELECT gamename FROM `games` WHERE id = :id"); PREPARE("SELECT gameid FROM `servers` WHERE port = :port"); PREPARE("SELECT uid FROM `ftpd` WHERE Uid = :uid"); PREPARE("SELECT created, expire FROM `servers` WHERE port = :port"); PREPARE("SELECT inactive FROM `servers` WHERE port = :port"); PREPARE("SELECT expire FROM `servers` WHERE port = :port"); PREPARE("SELECT owner FROM `servers` WHERE port = :port"); PREPARE("SELECT configfile FROM `games` WHERE id = :id"); PREPARE("SELECT gameinstall FROM `games` WHERE id = :id"); PREPARE("SELECT accepted FROM `bizonylatok` WHERE port = :port ORDER BY accepted ASC LIMIT 1"); PREPARE("SELECT startfile FROM `games` WHERE id = :id"); PREPARE("SELECT email, fullname FROM `users` WHERE username = :user"); PREPARE("SELECT id FROM `log` WHERE ki = :ki"); PREPARE("UPDATE `users` SET megerosito = :megerosito WHERE username = :owner"); PREPARE("UPDATE `users` SET password = :pass, megerosito = :megerosito WHERE username = :owner"); PREPARE("INSERT INTO `log` (ki, mit, mikor, ip) VALUES (:username, :mit, :mikor, :ip)");
db = NEW PDO("mysql:dbname=nulledhu_*****;host=localhost","nulledhu_*****","tesztelek"); $this -> db2 = NEW PDO("mysql:dbname=nulledhu_teszt;host=localhost","nulledhu_*****","tesztelek"); $this -> db -> query("SET NAMES UTF8"); } FUNCTION __destruct() { } FUNCTION iMessage($type = 'danger', $str) { echo ' '.$str.' '; } FUNCTION isLogged() { IF(isset($_SESSION["LoggedID"]) && $_SESSION["LoggedID"] > 0) RETURN TRUE; RETURN FALSE; } FUNCTION Logout() { IF(!$this -> isLogged()) RETURN FALSE; $_SESSION["LoggedID"] = 0; unset($_SESSION["LoggedID"]); } FUNCTION checkPass($pass) { $char_1 = 'A_dFcWFqA-Ux'; $char_2 = '1SEPAy2=[Z22'; RETURN sha1($char_1.$pass.$char_2); } FUNCTION isAdmin($id) { IF($id == '') $id = $_SESSION["LoggedID"]; IF(!$this -> isLogged()) RETURN FALSE; $isadmin = $this -> db -> PREPARE("SELECT rank FROM `users` WHERE id = :id"); $isadmin -> bindParam(":id", $id); $isadmin -> EXECUTE(); IF($isadmin -> fetchColumn() == 1) RETURN TRUE; RETURN FALSE; } FUNCTION Karbantartas() { $karbantartas = 1; $iskarbantartas = $this -> db -> PREPARE("SELECT * FROM `beallitasok` WHERE karbantartas = :id"); $iskarbantartas -> bindParam(":id", $karbantartas); $iskarbantartas -> EXECUTE(); IF($iskarbantartas -> fetchColumn() == 1) RETURN TRUE; RETURN FALSE; } FUNCTION isMenuActive($menu) { IF(empty($menu)) { IF(!isset($_GET["page"]) || isset($_GET["page"]) && empty($_GET["page"])) echo 'active'; } ELSE { IF($menu == $_GET["page"]) echo 'active'; } } FUNCTION LoggedID() { RETURN $_SESSION["LoggedID"]; } FUNCTION Username($loggedid) { $usnameforid = $this -> db -> PREPARE("SELECT username FROM `users` WHERE id = :id"); $usnameforid -> bindParam(":id", $_SESSION["LoggedID"]); $usnameforid -> EXECUTE(); RETURN $usnameforid -> fetchColumn(); } FUNCTION isValidEmail($value){ $pattern = "/^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/"; RETURN preg_match($pattern, $value); } FUNCTION Rank($rank) { switch($rank) { CASE 0: $rang = 'Bérlõ'; break; CASE 1: $rang = 'Adminisztrátor'; break; } RETURN $rang; } FUNCTION IDFromName($id) { $idfromname = $this -> db -> PREPARE("SELECT username FROM `users` WHERE id = :id"); $idfromname -> bindParam(":id", $id); $idfromname -> EXECUTE(); RETURN $idfromname -> fetchColumn(); } FUNCTION existUsername($username) { $eusername = $this -> db -> PREPARE("SELECT id FROM `users` WHERE username = :username"); $eusername -> bindParam(":username", $username); $eusername -> EXECUTE(); IF($eusername -> rowCount() > 0) RETURN TRUE; RETURN FALSE; } FUNCTION existcheckpw($checkkod) { $checkactive = $this -> db -> PREPARE("SELECT id FROM `users` WHERE megerosito = :megerosito"); $checkactive -> bindParam(":megerosito", $checkkod); $checkactive -> EXECUTE(); IF($checkactive -> rowCount() > 0) RETURN TRUE; RETURN FALSE; } FUNCTION existFTPUsername($username) { $eusername = $this -> db -> PREPARE("SELECT id FROM `ftpd` WHERE User = :username"); $eusername -> bindParam(":username", $username); $eusername -> EXECUTE(); IF($eusername -> rowCount() > 0) RETURN TRUE; RETURN FALSE; } FUNCTION existEmail($email) { $eusername = $this -> db -> PREPARE("SELECT id FROM `users` WHERE email = :email"); $eusername -> bindParam(":email", $email); $eusername -> EXECUTE(); IF($eusername -> rowCount() > 0) RETURN TRUE; RETURN FALSE; } FUNCTION existPort($port) { $eusername = $this -> db -> PREPARE("SELECT id FROM `servers` WHERE port = :port"); $eusername -> bindParam(":port", $port); $eusername -> EXECUTE(); IF($eusername -> rowCount() > 0) RETURN TRUE; RETURN FALSE; } FUNCTION GameIDFromName($gameid) { $gameidfromname = $this -> db -> PREPARE("SELECT gamename FROM `games` WHERE id = :id"); $gameidfromname -> bindParam(":id", $gameid); $gameidfromname -> EXECUTE(); RETURN $gameidfromname -> fetchColumn(); } FUNCTION PortForGameID($port) { $portforgameid = $this -> db -> PREPARE("SELECT gameid FROM `servers` WHERE port = :port"); $portforgameid -> bindParam(":port", $port); $portforgameid -> EXECUTE(); RETURN $portforgameid -> fetchColumn(); } FUNCTION get_numerics($str) { preg_match_all('/\d+/', $str, $matches); RETURN $matches[0]; } FUNCTION FTPUsers($uid) { $ftpusers = $this -> db -> PREPARE("SELECT uid FROM `ftpd` WHERE Uid = :uid"); $ftpusers -> bindParam(":uid", $uid); $ftpusers -> EXECUTE(); RETURN $ftpusers -> rowCount(); } FUNCTION GameServers($user) { $servers = $this -> db -> PREPARE("SELECT id FROM `servers` WHERE owner = :owner"); $servers -> bindParam(":owner", $user); $servers -> EXECUTE(); RETURN $servers -> rowCount(); } FUNCTION isExpire($port) { $ex = $this -> db -> PREPARE("SELECT created, expire FROM `servers` WHERE port = :port"); $ex -> bindParam(":port", $port); $ex -> EXECUTE(); $row = $ex -> fetch(PDO::FETCH_ASSOC); IF(TIME() > $row["expire"]) RETURN TRUE; RETURN FALSE; } FUNCTION isBizonylatExpire($port) { $ex = $this -> db -> PREPARE("SELECT created, expire FROM `servers` WHERE port = :port"); $ex -> bindParam(":port", $port); $ex -> EXECUTE(); $row = $ex -> fetch(PDO::FETCH_ASSOC); IF(TIME() > $row["expire"]-864000) RETURN TRUE; RETURN FALSE; } FUNCTION isInactive($port) { $i = $this -> db -> PREPARE("SELECT inactive FROM `servers` WHERE port = :port"); $i -> bindParam(":port", $port); $i -> EXECUTE(); IF($i -> fetchColumn() == 1) RETURN TRUE; RETURN FALSE; } FUNCTION Hatravan($port) { $h = $this -> db -> PREPARE("SELECT expire FROM `servers` WHERE port = :port"); $h -> bindParam(":port", $port); $h -> EXECUTE(); $expire = $h -> fetchColumn(); IF(TIME() > $expire) RETURN 'Befizetésre vár!'; $expire = $expire - TIME(); $hour = FLOOR($expire / (60 * 60)); $day = FLOOR($expire / (60 * 60 * 24)); RETURN $day.' nap'; } FUNCTION PortForOwner($port) { $p = $this -> db -> PREPARE("SELECT owner FROM `servers` WHERE port = :port"); $p -> bindParam(":port", $port); $p -> EXECUTE(); RETURN $p -> fetchColumn(); } FUNCTION IsConfigFile($port) { $c = $this -> db -> PREPARE("SELECT configfile FROM `games` WHERE id = :id"); $c -> bindParam(":id", $this -> PortForGameID($port)); $c -> EXECUTE(); $configfile = $c -> fetchColumn(); IF(!empty($configfile)) RETURN $configfile; RETURN FALSE; } FUNCTION PortOwner($port) { $portowner = $this -> db -> PREPARE("SELECT id FROM `servers` WHERE port = :port AND owner = :owner"); $portowner -> bindParam(":port", $port); $portowner -> bindParam(":owner", $this -> Username()); $portowner -> EXECUTE(); IF($portowner -> rowCount() > 0) RETURN TRUE; RETURN FALSE; } FUNCTION PortForGameInstall($port) { $gameinstall = $this -> db -> PREPARE("SELECT gameinstall FROM `games` WHERE id = :id"); $gameinstall -> bindParam(":id", $this -> PortForGameID($port)); $gameinstall -> EXECUTE(); RETURN $gameinstall -> fetchColumn(); } FUNCTION IsDocUpload($port) { $d = $this -> db -> PREPARE("SELECT accepted FROM `bizonylatok` WHERE port = :port ORDER BY accepted ASC LIMIT 1"); $d -> bindParam(":port", $port); $d -> EXECUTE(); IF($d -> rowCount() == 0) RETURN TRUE; $accepted = $d -> fetchColumn(); IF($accepted == 1) RETURN TRUE; RETURN FALSE; } FUNCTION PortForStartFile($port) { $p = $this -> db -> PREPARE("SELECT startfile FROM `games` WHERE id = :id"); $p -> bindParam(":id", $this -> PortForGameID($port)); $p -> EXECUTE(); RETURN $p -> fetchColumn(); } FUNCTION SendMail($email, $subject, $message) { $header = "MIME-Version: 1.0\n"; $header .= "Content-Type: text/html; charset=utf8\n"; $header .= "From: FPS-System - GameHosting \n"; mail($email, $subject, $message, $header); } FUNCTION generatePassword($length=22, $strength=8) { $vowels = 'aeuy'; $consonants = 'bdghjmnpqrstvz123456789&@]{}@'; IF ($strength & 1) { $consonants .= 'BDGHJLMNPQRSTVWXZ'; } IF ($strength & 2) { $vowels .= "AEUY"; } IF ($strength & 4) { $consonants .= '23456789'; } IF ($strength & 8) { $consonants .= '@#$%'; } $password = ''; $alt = TIME() % 2; FOR ($i = 0; $i < $length; $i++) { IF ($alt == 1) { $password .= $consonants[(rand() % strlen($consonants))]; $alt = 0; } ELSE { $password .= $vowels[(rand() % strlen($vowels))]; $alt = 1; } } RETURN $password; } FUNCTION PWMegerosito($user) { $us = $this -> db -> PREPARE("SELECT email, fullname FROM `users` WHERE username = :user"); $us -> bindParam(":user", $user); $us -> EXECUTE(); IF($us -> rowCount() == 0) RETURN FALSE; $arr = $us -> fetch(PDO::FETCH_ASSOC); $pass = $this -> db -> PREPARE("UPDATE `users` SET megerosito = :megerosito WHERE username = :owner"); // ellenõrzõkód generálás $karakterek = "abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"; $i = 0; $generaltkod = ""; while ($i <= 32) { $generaltkod .= $karakterek{mt_rand(0,strlen($karakterek))}; $i++; } // ellenõrzõkód generálás $pass -> bindParam(":megerosito", $generaltkod); $pass -> bindParam(":owner", $user); $pass -> EXECUTE(); $this -> SendMail($arr["email"], 'FPS-System - Elfelejtett jelszó!',' Kedves '.$arr["fullname"].'! Amennyiben te kértél, jelszó emlékeztetõt akkor, kattints az alábbi linkre: http://s2.fps-system.eu/?page=forgotpas ... eraltkod.' Amennyiben nem te voltál, akkor hagyd figyelmen kivül, ezt az emailt! Kérvényezõ:'.$_SERVER['REMOTE_ADDR'].' Üdvözlettel: FPS-System Team! '); } FUNCTION KarbantartasSET($karbantartas) { $cfg = $this -> db -> PREPARE("UPDATE `beallitasok` SET karbantartas = :karbantartas"); $cfg -> bindParam(":karbantartas", $karbantartas); $cfg -> EXECUTE(); } FUNCTION NewPassword($user) { $megerosito = ''; $passw = $this -> generatePassword(); $newpass = $this -> checkPass($passw); $us = $this -> db -> PREPARE("SELECT email, fullname FROM `users` WHERE username = :user"); $us -> bindParam(":user", $user); $us -> EXECUTE(); IF($us -> rowCount() == 0) RETURN FALSE; $arr = $us -> fetch(PDO::FETCH_ASSOC); $pass = $this -> db -> PREPARE("UPDATE `users` SET password = :pass, megerosito = :megerosito WHERE username = :owner"); $pass -> bindParam(":pass", $newpass); $pass -> bindParam(":owner", $user); $pass -> bindParam(":megerosito",$megerosito); $pass -> EXECUTE(); $this -> SendMail($arr["email"], 'FPS-System - Elfelejtett jelszó!',' Kedves '.$arr["fullname"].'! Új jelszavad: '.$passw.' Üdvözlettel: FPS-System Team! '); } FUNCTION Naplozas2($ki,$mit) { $log = $this -> db -> PREPARE("INSERT INTO `log` (ki, mit, mikor, ip) VALUES (:username, :mit, :mikor, :ip)"); $log -> bindParam(":username", $ki); $log -> bindParam(":mit", $mit); $log -> bindParam(":mikor", TIME()); $log -> bindParam(":ip", $_SERVER['REMOTE_ADDR']); $log -> EXECUTE(); } FUNCTION Naplozasok($user) { $servers = $this -> db -> PREPARE("SELECT id FROM `log` WHERE ki = :ki"); $servers -> bindParam(":ki", $user); $servers -> EXECUTE(); RETURN $servers -> rowCount(); } } ?>
Aki hibátlanul megcsinálja, megy a pacsi.
|
|