Coder Forum

PHP Quellcode

// Prüfen ob eingeloggt
function chkonline()
  {
    $anfrage  = "SELECT `user_id` FROM `users_online` WHERE `ip` = '".$_SERVER['REMOTE_ADDR']."' AND `session` = '".session_id()."'";
    $ergebnis = mysql_query($anfrage);
    if($ergebnis !== false)
    {
      $anz    = mysql_num_rows($ergebnis);
      if ($anz == 0)
      {
        return false;
      }
      $zeile  = mysql_fetch_row($ergebnis);
      return $zeile[0];
    }
    else
    {
      return false;
    }
  }
 
// Switch abfrage im Template ob User eingeloggt ist und bereiche sehen kann. Stammt aus dem phpbb2 bzw 3
if ( chkonline() )
{
	$template->assign_block_vars('switch_user_logged_out', array());
}
else
{
	$template->assign_block_vars('switch_user_logged_in', array());
}

PHP Quellcode

if ( isset($_POST['submit']) )
	{
		$username = income($_POST['username']);
		$password = $_POST['password'];
		$message = false;
 
  	$sql  = "SELECT `id`, `username`, `passwort` FROM `users` WHERE `username` = '".$_POST['username']."'";
  	$result = db_query($sql);
	$row = mysql_fetch_assoc($result);
 
	if ( !$_POST['username'] )
	{
		$message .= $lang['no_username']. '<br />';
		$fehler = true;
	}
	if ( !$_POST['password'] )
	{
		$message .= $lang['no_password']. '<br />';
		$fehler = true;
	}
	if ( !$_POST['username'] == $row['username'] )
	{
		$message .= $lang['no_login_user'] . '<br />';
		$fehler = true;
	}
 
	if ( !isset($fehler) )
	{
		if(chkonline() === false)
      	{
		$sql  = "DELETE FROM `users_online` WHERE `user_id` = '".$row['user_id']."' LIMIT 1";
		$result = db_query($sql);
		$sql  = "INSERT INTO `users_online` VALUES('".$row['id']."','".$row['id']."','".$_SERVER['REMOTE_ADDR']."','".$session_id."')";
		$result = db_query($sql);
		$message .= $lang['login_ok'] . '<br />';
	  }
	  else
	  {
		  $message .= $lang['login_true'] . '<br />';
	  }
	}
}

PHP Quellcode

$user_key = md5($pass.$user).'-irc-'.time().'-'.$user;
setcookie('point', $user_key, time()+(3600*24*100));

PHP Quellcode

$DB->set_sql('SELECT * FROM ircd_users_online
						 WHERE username =:1');
				$DB->execute($user);
				$row = $DB->fetch_assoc();
				$DB->free();
 
				if ( $row != false )
				{
					$DB->set_sql('DELETE FROM ircd_users_online WHERE username =:1  LIMIT 1');
					$DB->execute($user);
					$DB->free();
				}
 
				$user_key = md5($pass.$user).'-irc-'.time().'-'.$user;
				setcookie('point', $user_key, time()+(3600*24*100));
 
				$user_array = array();
				$user_array['user_id']			= $row['user_id'];
				$user_array['username'] 		= (string) $user;
				$user_array['user_key'] 		= (string) $user_key;
 
				$DB->set_sql('INSERT INTO ircd_users_online ' . $DB->syntax_built(SQL_INSERT, $user_array));
				$DB->execute();
				$DB->free();

PHP Quellcode

$Core->page_header('Login');

PHP Quellcode

$User->user_login();
$Core->page_header('Login');

PHP Quellcode

var_dump($_COOKIE['point']);

PHP Quellcode

public function login_status()
	{
		global $DB, $Smarty, $Core;
 
		$user_cookie = $_COOKIE['point'];
		$DB->set_sql('SELECT * FROM ircd_users_online
					 WHERE user_key =:1');
		$DB->execute($user_cookie);
		$login_row = $DB->fetch_assoc();
		$DB->free();
 
		if ( $login_row )
		{
 
		}
		else
		{
 
		}
 
	}
 
$Smarty->assign(array(
			'PAGE_HEADER'			=> $this->config['sitename'] . ' : ' . $this->config['description'] . ' • ' . $title,
			'IS_LOGED'				=> $User->login_status('user_key') == 1 ? true : false,
			'U_LOGIN_SEND'			=> 'login.php?mode=login',
        ));

PHP Quellcode

if ( $login_row )
		{
			return true;
		}
		else
		{
			return false;
		}

PHP Quellcode

// Login Userdaten sammeln
	public function user_data()
	{
		global $DB, $Smarty, $Core, $User;
 
		if ($User->login_status() == false )
		{
			$DB->set_sql('SELECT * 
						 FROM ircd_users
						 WHERE user_id = 1');
			$DB->execute();
			$userdata = $DB->fetch_assoc();
			$DB->free();
		}
		else
		{
			$user_cookie = $_COOKIE['point'];
			$DB->set_sql('SELECT o.*, u.* 
						 FROM ircd_users_online AS o,
						 ircd_users AS u
						 WHERE o.user_key =:1
						 AND o.username = u.username');
			$DB->execute($user_cookie);
			$userdata = $DB->fetch_assoc();
			$DB->free();
 
		}
 
	}