Quote:
Originally Posted by babyhamsta
I get a error in the database.. it says [Err] 1062 - Duplicate entry '1' for key 'PRIMARY'
Fixed.. Now on the home page I get these and
PLEASE HELP ME FIX!
PICTURE: [Only registered and activated users can see links. Click Here To Register...]
|
Replace util/Auth.php by this :
PHP Code:
<?php
class Auth
{
public static function handleLogin()
{
@session_start();
$logged = Session::get('loggedIn');
if ($logged == false)
{
Session::destroy();
header('location: /index');
exit;
}
}
public static function isLogged()
{
@session_start();
$logged = Session::get('loggedIn');
if($logged == true)
{
header('location: /internalStart');
exit;
}
}
public static function getUser($data)
{
@session_start();
$logged = Session::get('loggedIn');
if ($logged == true)
{
$db = new Database(DB_TYPE, DB_HOST, DB_NAME, DB_USER, DB_PASS);
$returnvalue = $db->select('SELECT '.$data.' FROM users WHERE id= :account_id', array('account_id' => Session::get('account_ID')));
return $returnvalue[0][$data];
}
}
public static function getUserSettings($data)
{
@session_start();
$logged = Session::get('loggedIn');
if ($logged == true)
{
$db = new Database(DB_TYPE, DB_HOST, DB_NAME, DB_USER, DB_PASS);
$returnvalue = $db->select('SELECT '.$data.' FROM users_settings WHERE playerid= :account_id', array('account_id' => Session::get('account_ID')));
return $returnvalue[0][$data];
}
}
public static function getUserByID($data, $id)
{
$db = new Database(DB_TYPE, DB_HOST, DB_NAME, DB_USER, DB_PASS);
$returnvalue = $db->select('SELECT '.$data.' FROM users WHERE id= :account_id', array('account_id' => $id));
return $returnvalue[0][$data];
}
}
?>
And also replace util/Server_status.php by this :
PHP Code:
<?php
class Server_status
{
public static function online_users()
{
$db = new Database(DB_TYPE, DB_HOST, DB_NAME, DB_USER, DB_PASS);
$req = $db->prepare('SELECT sval FROM server_statistics WHERE skey="active_connections"');
$req->execute();
$resultat = $req->fetch();
return $resultat[0];
}
}
?>