view the auth_database.php file

from 'view auth_database.php content + editor' you can add some codes in this file with php editor.
file name: auth_database.php
Size: 1.67 KB
date: Jun 25 09 at 04:33 PM

This file is located in php-auth_v1.3.1.zip

<?php
	$auth_db_link = mysql_connect($config['database']['server'], $config['database']['username'],
$config['database']['password'])
		or trigger_error("MySQL error: " . mysql_error());
	mysql_select_db($config['database']['db'])
		or trigger_error("MySQL error: " . mysql_error());
		
	function check_auth($sessionid)
	{
		global $config;
		$auth_sql = "SELECT * FROM `{$config['tables']['users']}` WHERE `cookie` =
'$sessionid'";
		$result = mysql_query($auth_sql)
			or trigger_error(mysql_error());
		if(mysql_num_rows($result)==1)
		{
			return true;
		}
		else
		{
			return false;
		}
	}
	
	function log_event($event)
	{
		global $config;
		$log_sql = "INSERT INTO `{$config['tables']['log']}`
(`event_time`,`event`,`url`,`username`,`ip_address`)
VALUES(NOW(),'$event','{$_SERVER['REQUEST_URI']}','{$_SESSION['user']['username']}','{$_SERVER['REMO
TE_ADDR']}')";
		mysql_query($log_sql)
			or trigger_error(mysql_error());
	}
	
	function get_user($username)
	{
		global $config;
		$username = mysql_real_escape_string($username);
		$auth_sql = "SELECT * FROM `{$config['tables']['users']}` WHERE `username` =
'$username'";
		$result = mysql_query($auth_sql)
			or trigger_error(mysql_error());
		return mysql_fetch_assoc($result);
	}
	
	function login($username,$sessionid)
	{
		global $config;
		$auth_sql = "UPDATE `{$config['tables']['users']}` SET `cookie` = '$sessionid' WHERE
`username` = '$username'";
		mysql_query($auth_sql)
			or trigger_error(mysql_error());
	}
	
	function logout($sessionid)
	{
		global $config;
		$logout_sql = "UPDATE `{$config['tables']['users']}` SET `cookie` = NULL WHERE `cookie` =
'$sessionid'";
		mysql_query($logout_sql)
			or trigger_error(mysql_error());
	}
?>