Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_COOKIE["Champions_cookielogin"])) {
- $email = getCurrentUser();
- $username = getUserNameFromName($email);
- $registerdate = getRegisterdateFromName($email);
- $accountid = getAccountIDFromName($email);
- $user_level = getUserLevelFromName($email);
- $champions_uniqueid = getUniqueIDFromEmail($email);
- $champions_count = getChampionCount($email);
- $champions_max = getChampionMax($email);
- if(isset($_COOKIE["Champions_cookieselectedchampion"])) {
- $selected = getCurrentSelected();
- $arr = getCharactervalues($selected);
- $Power = $arr[0];
- $Speed = $arr[1];
- $Ironflesh = $arr[2];
- $Power_Strike = $arr[3];
- $Power_Throw = $arr[4];
- $Power_Draw = $arr[5];
- $Shield = $arr[6];
- $Athletics = $arr[7];
- $Riding = $arr[8];
- $Proficiencies = $arr[9];
- }
- } else {
- header('Location: index.php');
- }
- <?php
- ini_set('display_errors', 0);
- // clearHeader()
- // Used for the URL-Requests-related scripts. It's mandatory to avoid bugs and problems and has to be executed at the beginning of the scripts.
- function clearHeader() {
- header_remove();
- function set_content_length($output)
- {
- header("Content-Length: ".strlen($output));
- return $output;
- }
- ob_start("set_content_length");
- }
- // db_login()
- // Gets executed every time by accessing the database in any way.
- function db_login() {
- $server = "localhost";
- $user = "root";
- $password = "-";
- $database = "-";
- return mysqli_connect($server, $user, $password, $database);
- }
- function getCurrentUser() {
- return $_COOKIE["Champions_cookielogin"];
- }
- function getCurrentSelected() {
- return $_COOKIE["Champions_cookieselectedchampion"];
- }
- function getUserNameFromName($email) {
- $db = db_login();
- $abfrage = "SELECT Username FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->Username;
- }
- return "null";
- }
- function getRegisterdateFromName($email) {
- $db = db_login();
- $abfrage = "SELECT user_registerdate FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->user_registerdate;
- }
- return "Unknown Date";
- }
- function getAccountIDFromName($email) {
- $db = db_login();
- $abfrage = "SELECT id FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->id;
- }
- return "Unknown ID";
- }
- function checkEmail($email) {
- $db = db_login();
- $abfrage = "SELECT ID FROM account WHERE Email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->ID;
- }
- return 0;
- }
- function checkUsername($username) {
- $db = db_login();
- $abfrage = "SELECT ID FROM account WHERE Username = '$username'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->ID;
- }
- return 0;
- }
- function getPasswordRequestFromEmail($email) {
- $db = db_login();
- $abfrage = "SELECT pwrequest FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->pwrequest;
- }
- return 0;
- $row->close();
- $db->close();
- }
- function getUserLevelFromName($email) {
- $db = db_login();
- $abfrage = "SELECT user_level FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->user_level;
- }
- return 0;
- }
- function getUniqueIDFromEmail($email) {
- $db = db_login();
- $abfrage = "SELECT unique_id FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->unique_id;
- }
- return 0;
- }
- function getChampionMadeDate($username) {
- $db = db_login();
- $abfrage = "SELECT champion_createddate FROM champions WHERE Username = '$username'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->champion_createddate;
- }
- return "0000-00-00 00:00:00";
- }
- function getChampionCount($email) {
- $db = db_login();
- $abfrage = "SELECT Username FROM champions WHERE ChampionEmail = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- $count = mysqli_num_rows($ergebnis);
- return $count;
- }
- function checkChampionName($championname) {
- $db = db_login();
- $abfrage = "SELECT ID FROM champions WHERE Username = '$championname'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->ID;
- }
- return 0;
- }
- function getChampionPower($username) {
- $db = db_login();
- $abfrage = "SELECT Power FROM champions WHERE Username = '$username'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->Power;
- }
- return 0;
- }
- function getChampionSpeed($username) {
- $db = db_login();
- $abfrage = "SELECT Speed FROM champions WHERE Username = '$username'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->Speed;
- }
- return 0;
- }
- function getChampionMax($email) {
- $db = db_login();
- $abfrage = "SELECT maxChampions FROM account WHERE email = '$email'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->maxChampions;
- }
- return 0;
- }
- function getChampionID($username) {
- $db = db_login();
- $abfrage = "SELECT ID FROM champions WHERE Username = '$username'";
- $ergebnis = mysqli_query($db, $abfrage);
- while($row = mysqli_fetch_object($ergebnis))
- {
- return $row->ID;
- }
- return 0;
- }
- function checkChampionOwnerByEmail($email, $delete) {
- $db = db_login();
- $query = "SELECT ChampionEmail, Username FROM champions WHERE ChampionEmail = '$email' AND Username = '$delete'";
- $ergebnis = mysqli_query($db, $query);
- $num_rows = mysqli_num_rows($ergebnis);
- if ($num_rows > 0) {
- return $num_rows;
- } else {
- return 0;
- }
- }
- function RegisterAccount($username, $email, $password, $hash) {
- $db = db_login();
- $abfrage = "INSERT INTO `account` (`username`, `email`, `password`, `hash`) VALUES ('$username', '$email', '$password', '$hash')";
- $ergebnis = mysqli_query($db, $abfrage);
- }
- function RegisterChampion($championname, $email) {
- $db = db_login();
- $abfrage = "INSERT INTO `champions` (`Username`, `ChampionEmail`) VALUES ('$championname', '$email')";
- $ergebnis = mysqli_query($db, $abfrage);
- }
- function ResetPW($email, $hash) {
- $db = db_login();
- $query = "UPDATE account SET pwhash = '$hash', pwrequest = '1' WHERE email='$email' AND pwrequest = '0'";
- $execute = mysqli_query($db, $query);
- }
- function getChampionClassName($championstrength, $championagility) {
- if($championstrength == 6 && $championagility == 6) {
- return "Peasant";
- } else {
- return "Unknown";
- }
- }
- function getCharactervalues($selected) {
- $db = db_login();
- $abfrage = "SELECT * FROM champions WHERE Username = '$selected'";
- $ergebnis = mysqli_query($db, $abfrage);
- $arr = array();
- while($row = mysqli_fetch_object($ergebnis))
- {
- array_push($arr, $row->Power);
- array_push($arr, $row->Speed);
- array_push($arr, $row->Ironflesh);
- array_push($arr, $row->Power_Strike);
- array_push($arr, $row->Power_Throw);
- array_push($arr, $row->Power_Draw);
- array_push($arr, $row->Shield);
- array_push($arr, $row->Athletics);
- array_push($arr, $row->Riding);
- array_push($arr, $row->Proficiencies);
- }
- return $arr;
- }
- function getUserInfo($email) {
- $db = db_login();
- $abfrage = "SELECT * FROM account WHERE email = $email";
- $ergebnis = mysqli_query($db, $abfrage);
- $arr = array();
- while($row = mysqli_fetch_object($ergebnis))
- {
- array_push($arr, $row->Username);
- array_push($arr, $row->user_level);
- array_push($arr, $row->id);
- array_push($arr, $row->unique_id);
- array_push($arr, $row->maxChampions);
- }
- return $arr;
- }
- function SaveSkillsChampion($selected, $Power, $Speed) {
- $db = db_login();
- $query = "UPDATE champions SET Power = '$Power', Speed = '$Speed' WHERE Username='$selected'";
- $execute = mysqli_query($db, $query);
- }
- ?>
Add Comment
Please, Sign In to add comment