From 38f73720eaec5f49752589ac088b04b3fa734117 Mon Sep 17 00:00:00 2001
From: Starla Insigna <hatkirby@fourisland.com>
Date: Mon, 5 Jan 2009 18:01:06 -0500
Subject: Integreated Fourm users

---
 includes/session.php | 70 +++++++++++++++++++++++++++++++++++++++-------------
 1 file changed, 53 insertions(+), 17 deletions(-)

(limited to 'includes/session.php')

diff --git a/includes/session.php b/includes/session.php
index ff47e12..a4a7604 100755
--- a/includes/session.php
+++ b/includes/session.php
@@ -24,38 +24,74 @@ require('headerproc.php');
 
 session_start();
 
-function sess_exists($name)
+function getSessionID()
 {
-	return(isset($_SESSION[$name]));
-}
+	$getconfig = "SELECT * FROM phpbb_config WHERE config_name LIKE \"cookie_name\"";
+	$getconfig2 = mysql_query($getconfig);
+	$getconfig3 = mysql_fetch_array($getconfig2);
 
-function sess_set($name,$value)
-{
-	$_SESSION[$name] = $value;
+	if (isset($_COOKIE[$getconfig3['config_value'] . '_sid']))
+	{
+		return $_COOKIE[$getconfig3['config_value'] . '_sid'];
+	}
+
+	return false;
 }
 
-function sess_get($name)
+function getSessionUsername()
 {
-	return $_SESSION[$name];
-}
+	$getconfig = "SELECT * FROM phpbb_config WHERE config_name LIKE \"cookie_name\"";
+	$getconfig2 = mysql_query($getconfig);
+	$getconfig3 = mysql_fetch_array($getconfig2);
+
+	if (isset($_COOKIE[$getconfig3['config_value'] . '_sid']))
+	{
+		$getsession = "SELECT * FROM phpbb_sessions AS s, phpbb_users AS u WHERE s.session_id LIKE \"" . mysql_real_escape_string($_COOKIE[$getconfig3['config_value'] . '_sid']) . "\" AND u.user_id = s.session_user_id";
+		$getsession2 = mysql_query($getsession) or die($getsession);
+		$getsession3 = mysql_fetch_array($getsession2);
 
+		return $getsession3['username'];
+	}
+
+	return false;
+}
 
-function sess_getifset($name)
+function isLoggedIn()
 {
-	if (sess_exists($name))
+	$getconfig = "SELECT * FROM phpbb_config WHERE config_name LIKE \"cookie_name\"";
+	$getconfig2 = mysql_query($getconfig);
+	$getconfig3 = mysql_fetch_array($getconfig2);
+
+	if (isset($_COOKIE[$getconfig3['config_value'] . '_sid']))
 	{
-		return sess_get($name);
-	} else {
-		return false;
+		$getsession = "SELECT * FROM phpbb_sessions WHERE session_id LIKE \"" . mysql_real_escape_string($_COOKIE[$getconfig3['config_value'] . '_sid']) . "\"";
+		$getsession2 = mysql_query($getsession);
+		$getsession3 = mysql_fetch_array($getsession2);
+
+		if ($getsession3['session_user_id'] != '1')
+		{
+			return true;
+		}
 	}
+
+	return false;
 }
 
-function sess_delete($name)
+function isAdmin()
 {
-	if (sess_exists($name))
+	if (isLoggedIn())
 	{
-		unset($_SESSION[$name]);
+		$getgroup = "SELECT COUNT(*) FROM phpbb_user_group, phpbb_users WHERE phpbb_user_group.user_id = phpbb_users.user_id AND phpbb_users.username = \"" . getSessionUsername() . "\" AND phpbb_user_group.group_id = 2";
+		$getgroup2 = mysql_query($getgroup);
+		$getgroup3 = mysql_fetch_array($getgroup2);
+
+		if ($getgroup3['COUNT(*)'] == '1')
+		{
+			return true;
+		}
 	}
+
+	return false;
 }
 
 ?>
-- 
cgit 1.4.1