<?php

Class mysql{

    // Connect to the mysql database.
    public static function Connect(){
        include('config.php');
        echo $mysql_database . "db ";

        $con = mysql_connect('localhost', $mysql_username, $mysql_password);
        mysql_select_db($mysql_database, $con);
    }

    // Disconnect from the mysql database.
    public static function Disconnect(){
        mysql_close();
    }

    // Create a user into the mysql user table.
    public static function createUser($user, $pass,  $extra_info){
        $que = mysql_query("INSERT INTO clients (user, pass, session_id, session_timeout, session_ip, account_status, extra_info) VALUES ($user, $pass, '0', '0', '0', 'active', $extra_info)");
        if  ($que) {
        echo "Worked";
        } else {
        echo "Error";
        }
    }

    // Check session id, mainly to see if someone is logged in.
    public static function checkSession($u, $id){
        $query = "SELECT * FROM clients WHERE user = '$u' AND session_id = '$id' LIMIT 1";
        $result = mysql_query($query);
        $count = mysql_num_rows($result);
        if($count==0){
            return false;
        }
        else {
            return true;
        }

    }

    // Check login for the actual program.
    public static function checkLogin($u, $p){
        $query = "SELECT * FROM clients WHERE user = '$u' AND pass = '$p' LIMIT 1";
        $result = mysql_query($query);
        $count = mysql_num_rows($result);
        if($count==0){
            return false;
            echo "failed";
        }
        else {
            $length = 20;
            $characters = "0123456789abcdefghijklmnopqrstuvwxyz";
            $session_ip = $_SERVER['REMOTE_ADDR'];
            $session_time = time();

            for ($p = 0; $p < $length; $p++) {
                $session_id .= $characters[mt_rand(0, strlen($characters))];
            }
            mysql_query("INSERT INTO clients (session_id, session_ip, session_timeout) VALUES ('$session_id', '$session_ip', '$session_time') WHERE user = '$u'");
            return true;
            echo "success, session_id created.";
        }
    }


// End sql Class
}

error_reporting(E_ALL);
ini_set('display_errors', '1');

echo "test";
mysql::Connect();
echo mysql_error();

mysql::createUser("Matto", "123", "mformatto@hotmail.com");
mysql::Disconnect();

?>