framework.php

<?php
// don't mess with below
if(!$usecookies){
    session_start();
}
// don't mess with the above
/*
Well hello there! :D
Don't be scared, I'll be here to guide you along here.
Although before you can use this, I'd like to say a few things.
1. You can use this framework FREE OF CHARGE! There's no warranty or anything though so if you ask me for help on this, and i don't respond, sucks to suck
2. If you encounter a problem, try solving it yourself! If you solve it, make a pull request to make life easier for other developers! (and me. D:) If you can't solve it, create an issue. (https://github.com/TermOfficial/Term-Framework)
3. Enjoy!

This script uses MySQLi, file_get_contents (you must be able to get contents from raw.githubusercontent.com with an https request header.)
If you don't have the following, the script won't function.

In order to connect to your database, you can use your own script by specifying it in config, but it needs one requirement. The database must be connected to under $db.
If you don't want to use your own script, use the connector below.

INSTALLATION:
in every script, require the framework.
Then, for the first time upon using the framework, run the function setup();
This will then setup the database and create all files required.

If you want to use one of the functions, e.g:
function login($username, $password){
  my login script would be here
}

Then use it like this:
login("username", "password");
and if it is a success, it will return 1. otherwise, it will return the error it ran into.
*/
// Config
$connscript = ""; // Replace the value with the location of your script.
$usecookies = true; // Use cookies instead of PHP Session. No idea if this is more secure or not. Probably not, but if you want it enabled, go ahead.
$dbhost = "localhost"; // the last few variables should be self-explanitory. This value is usually localhost.
$dbuser = "";
$dbpass = "";
$dbname = "";

// If you want to fix an issue, open the script on github.
function checkver($ver){ // PLEASE FIX!
  if($ver != file_get_contents("https://raw.githubusercontent.com/TermOfficial/Term-Framework/main/framework-true.php")){
    echo "<script>console.warn('Term-Framework is out of date. Update the script here: https://github.com/TermOfficial/Term-Framework ~Term-Framework~')</script>";
  } else {
    echo "<script>console.log('Update check pass. ~Term-Framework~')</script>";
}
}

// connect to the db!
if($connscript != NULL){
    require($connscript);
} else {
    $db = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
    if($db->error){
        exit("Connection failure.");
    }
}

// use this to test Term-Framework's functionality
function test(){
  echo "Term-Framework test script.";
}

// use this only once!
function setup(){
    echo "Setting up DB";
    global $db;
    global $dbname;
    $setup = $db->prepare("CREATE TABLE `".$dbname."`.`users` ( `id` INT NOT NULL AUTO_INCREMENT , `username` VARCHAR(64) NOT NULL , `password` VARCHAR(64) NOT NULL , PRIMARY KEY (`id`)) ENGINE = MyISAM;");
    $setup->execute();
    if(!$setup->error){
        echo "<br>users created";
      $setup = $db->prepare("CREATE TABLE `".$dbname."`.`token` ( `uid` INT(10) NOT NULL , `token` VARCHAR(64) NOT NULL ) ENGINE = MyISAM;");
      $setup->execute();
      if(!$setup->error){
         echo "<br>tokens created";
         $setup = $db->prepare("CREATE TABLE `".$dbname."`.`bans` ( `uid` INT(10) NOT NULL ) ENGINE = MyISAM;");
         $setup->execute();
         if($setup->error){
            echo "Failed, DB is probably already setup";
            return $setup->error();
         } else {
         return 1;
         }
      } else {
        echo "Failed, DB is probably already setup";
        return $setup->error();
      }
    } else {
        echo "Failed, DB is probably already setup";
        return $setup->error();
    }
}

function clogin($username, $password){
  global $db;
  $duplicate = $db->prepare("SELECT `id` FROM `users` WHERE username = ?");
  $duplicate->bind_param("s", $username);
  $duplicate->execute();
  $dres = $duplicate->get_result();
  if($dres->num_rows == 0){
  $hash = password_hash($password, PASSWORD_BCRYPT);
  $makeacc = $db->prepare("INSERT INTO `users` (`id`, `username`, `password`) VALUES (NULL, ?, ?);");
  $makeacc->bind_param("ss", $username, $hash);
  $makeacc->execute();
  if($makeacc->error){
    return $makeacc->error();
  } else {
    return 1;
  }
  } else {
    return "alreadyexists";
  }
}

function login($username, $password){
  global $usecookies;
  global $db;
  $login = $db->prepare("SELECT * FROM users WHERE username = ?");
  $login->bind_param("s", $username);
  $login->execute();
  $result = $login->get_result();
  if($result->num_rows == 0){
    return "noaccount";
  } else {
    $row = $result->fetch_assoc();
    if(!password_verify($password, $row["password"])){
      return "invalid password";
    } else {
      $token = "DO NOT SHARE YOUR COOKIES TO ANYBODY. value: ".bin2hex(openssl_random_pseudo_bytes(64))."";
      $login = $db->prepare("INSERT INTO token (uid, token) VALUES (?, ?)");
      $login->bind_param("is", $row["id"], $token);
      $login->execute();
      if(!$login->error){
          if($usecookies){
            global $_COOKIE;
            setcookie("DO NOT GIVE YOUR COOKIES TO ANYBODY", "DO NOT GIVE YOUR COOKIES TO ANYBODY", time()+99999);
            setcookie("token", $token, time()+99999, "/");
            setcookie("id", $row["id"], time()+99999, "/");
            setcookie("username", $row["username"], time()+99999, "/");
            return 1;
          } else {
            global $_SESSION;
            // I would put a don't give your cookies to anybody here, but guess what? You can't read PHP Session IDs! :DDD But seriously. don't give your cookies to anybody.
            $_SESSION["token"] = $token;
            $_SESSION["id"] = $row["id"];
            $_SESSION["username"] = $row["username"];
            return 1;
          }
      } else {
        return $login->error();
      }
    }
  }
}

function logout(){
  global $usecookies;
  if($usecookies){
    setcookie('DO NOT GIVE YOUR COOKIES TO ANYBODY', null, -1); 
    setcookie('token', null, -1, '/'); 
    setcookie('id', null, -1, '/');
    setcookie('username', null, -1, '/');
    return 1;
  } else {
    global $_SESSION;
    session_destroy();
    return 1;
  }
}

function insertrow($table, $data, $value){
    $query = $db->prepare("INSERT INTO `".$table."` (".$data.") VALUES (".$value.")");
    $query->execute();
    if($query->error){
        return $query->error();
    } else {
        return 1;
    }
}

function selectrow($table, $where){
    $query = $db->prepare("SELECT * FROM `".$table."` WHERE ".$where."");
    $query->execute();
    if($query->error){
        return $query->error();
    } else {
        $result = $query->get_result();
        $row = $result->fetch_assoc();
        return $row;
    }
}

function checktoken($username, $token){
  return "not implemented";
}
//checkver("b1027");
?>