Fully operational SQL
diff --git a/php/login.php b/php/login.php
index 2dd713e..4dd5ee7 100644
--- a/php/login.php
+++ b/php/login.php
@@ -1,55 +1,6 @@
<?php
- class User{
- public $id;
- public $nomcomplet;
- public $curs;
- public $grau;
- public $quimata;
-
- public function nom() {
- $noms = explode(" ", $this->nomcomplet);
- return $noms[0];
- }
- }
-
- function get_user($id) {
- $user = new User();
-
- // Define MySQL login variables
- $servername = "localhost"; // "fdb22.awardspace.net";
- $username = "root"; // "3155560_users";
- $password = ""; // "btechnoro@fox4news.info";
-
- // Create connection
- $conn = new mysqli($servername, $username, $password, "pastanaga");
- if ($conn->connect_error) die("Connection failed: " . $conn->connect_error);
- $conn->set_charset("utf8");
-
- // Do the query
- $query = "SELECT * FROM users WHERE id=".$id;
-
- // Fetch the information of the user
- if ($result = $conn->query($query)) {
- while ($row = $result->fetch_row()) {
- $user->id = $row[0];
- $user->nomcomplet = $row[1];
- $user->curs = $row[2];
- $user->grau = $row[3];
- $user->quimata = $row[4];
- $user->requested = $row[5];
- $user->mort = $row[6];
- }
- $result->close();
- } else {
- die("Wrong query: " . $query);
- }
-
- // Close connection
- $conn->close();
-
- return $user;
- }
-
- $user = get_user($_GET['user']);
- $victim = get_user($user->quimata);
+ require 'utils.php';
+ $user = get_users($_GET['user']);
+ $victim = get_users($user->quimata);
+ if ($user->mort) die("Puto mort de merda");
?>