ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); session_start(); include("_CORE/_data.php"); if (isset($_GET["action"]) && ($_GET["action"] == "logout")) { setcookie("userid", "", time()+3600*24*365); setcookie("email_login", "", time()+3600*24*365); setcookie("k", "", time()+3600*24*365); setcookie("club_secret", "", time()+3600*24*365); Header("Location: index?alert=loggedout"); die(); } if (isset($_POST["action"]) && ($_POST["action"] == "resetpw")) { if ($_POST["email"] != "") { $query = "select * from users where email = '" . cleanValue($_POST["email"]) . "' limit 1"; $result = $mysqli->query($query); if ($result->num_rows > 0) { $user = $result->fetch_assoc(); // UPDATE PROFILE $k = generateKey(); $query = "update users set reset_k = '" . $k . "' where id = '" . $user["id"] . "' limit 1"; $result = $mysqli->query($query); $link = $setting["app_url"] . "/index.php?&action=resetpw&k=" . $k; $body = getTexts(16); $subject = str_replace("#firstname", $user["firstname"], $subject); $subject = str_replace("#lastname", $user["lastname"], $subject); $message = $body; $message = str_replace("#firstname", $user["firstname"], $message); $message = str_replace("#link", $link, $message); include("assets/emails/template.php"); $to = $user["email"]; $reply_to = $setting["mail_from_replyto"]; mailGun($domain, $mg_from_name, $mg_from_email, $to, $reply_to, $subject, $mail); Header("Location: index.php?action=forgotpw&alert=success"); die(); }else{ Header("Location: index.php?action=forgotpw&alert=unknown"); die(); } }else{ Header("Location: index.php?action=forgotpw&alert=unknown"); die(); } } if (isset($_POST["action"]) && ($_POST["action"] == "setpw")) { if ($_POST["password"] != "") { $query = "select * from users where reset_k = '" . cleanValue($_POST["k"]) . "' limit 1"; $result = $mysqli->query($query); if ($result->num_rows > 0) { $user = $result->fetch_assoc(); $password = md5($password_needle . "_" . cleanValue($_POST["password"])) . md5(cleanValue($_POST["password"])); // UPDATE PROFILE $query = "update users set reset_k = '', password = '" . $password . "' where id = '" . $user["id"] . "' limit 1"; $result = $mysqli->query($query); $body = getTexts(35); $subject = str_replace("#firstname", $user["firstname"], $subject); $subject = str_replace("#lastname", $user["lastname"], $subject); $message = $body; $message = str_replace("#firstname", $user["firstname"], $message); $message = str_replace("#site_name", $setting["site_name"], $message); include("_CORE/_email_template.php"); $to = $user["email"]; $reply_to = $setting["mail_from_replyto"]; mailGun($domain, $mg_from_name, $mg_from_email, $to, $reply_to, $subject, $mail); Header("Location: index.php?alert=pwchanged"); die(); }else{ Header("Location: index.php?alert=unknown&k=" . $_POST["k"]); die(); } }else{ Header("Location: index.php?alert=unknown&k=" . $_POST["k"]); die(); } } if ($_POST) { if (($_POST["email"] != "") && ($_POST["password"] != "")) { $password = md5($password_needle . "_" . cleanValue($_POST["password"])) . md5(cleanValue($_POST["password"])); $query = "select * from users where email = '" . cleanValue($_POST["email"]) . "' and password = '" . cleanValue($password) . "' limit 1"; $result = $mysqli->query($query); if ($result->num_rows > 0) { $userrow = $result->fetch_assoc(); if ($userrow["active"] != "1") { Header("Location: index.php?alert=notactive"); die(); } setcookie("userid", $userrow["id"], time()+3600*24*365); setcookie("email", $userrow["email"], time()+3600*24*365); setcookie("k", $userrow["cookie_k"], time()+3600*24*365); // LOG $query = "insert into log (user_id, type, page, useragent) values ( '" . $userrow["id"] . "', 'login', 'index.php', '" . cleanValue($_SERVER['HTTP_USER_AGENT']) . "')"; $result = $mysqli->query($query); if (!isset($_COOKIE["target"]) || ($_COOKIE["target"] == "")) { Header("Location: dashboard"); die(); }else{ Header("Location: " . $_COOKIE["target"]); die(); } }else{ Header("Location: index.php?alert=pw"); die(); } }else{ Header("Location: index.php?alert=pw"); die(); } } // COOKIE CHECK if (isset($_COOKIE["userid"]) && ($_COOKIE["userid"] != "") && (isset($_COOKIE["k"]) && ($_COOKIE["k"] != ""))) { $query = "select * from users where (email = '" . cleanValue($_COOKIE["email"]) . "') AND id = '" . cleanValue($_COOKIE["userid"]) . "' AND cookie_k = '" . cleanValue($_COOKIE["k"]) . "' LIMIT 1"; $result = $mysqli->query($query); //die('cookie forward: ' . $query); if ($result->num_rows > 0) { //Header("Location: dashboard.php"); //exit(); } } $club["id"] = "1"; getSettings(); ?>
Data Driven Scouting Solutions
and Software for Premium Football Clubs