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/footer.php | 41 +++++++++++++++++++++++++++++------------
 1 file changed, 29 insertions(+), 12 deletions(-)

(limited to 'includes/footer.php')

diff --git a/includes/footer.php b/includes/footer.php
index dadb6f5..0a93ae9 100755
--- a/includes/footer.php
+++ b/includes/footer.php
@@ -93,14 +93,14 @@ if (!isset($noRightbar))
 	$i=0;
 	while ($getcomments3[$i] = mysql_fetch_array($getcomments2))
 	{
-		$getuser = "SELECT * FROM users WHERE username = \"" . $getcomments3[$i]['username'] . "\"";
+		$getuser = "SELECT * FROM phpbb_users WHERE username = \"" . $getcomments3[$i]['username'] . "\"";
 		$getuser2 = mysql_query($getuser);
 		$getuser3 = mysql_fetch_array($getuser2);
 
 		if ($getuser3['username'] == $getcomments3[$i]['username'])
 		{
 			$username = $getuser3['username'];
-			$website = $getuser3['website'];
+			$website = $getuser3['user_website'];
 		} else {
 			$getanon = "SELECT * FROM anon_commenters WHERE username = \"" . $getcomments3[$i]['username'] . "\"";
 			$getanon2 = mysql_query($getanon);
@@ -125,7 +125,7 @@ if (!isset($noRightbar))
 									'CODED' => $getpost3['slug'],
 									'ENDING' => '/',
 									'TITLE' => stripslashes($getpost3['title']),
-									'AUTHOR' => (($website != '') ? '<A HREF="http://' . $website . '">' . $username . '</A>' : $username)));
+									'AUTHOR' => (($website != '') ? '<A HREF="' . $website . '">' . $username . '</A>' : $username)));
 			$i++;
 		} else if (strpos($getcomments3[$i]['page_id'], 'quote') !== FALSE)
 		{
@@ -136,11 +136,12 @@ if (!isset($noRightbar))
 									'CODED' => $num,
 									'ENDING' => '.php',
  									'TITLE' => 'Quote #' . $num,
-									'AUTHOR' => (($website != '') ? '<A HREF="http://' . $website . '">' . $username . '</A>' : $username)));
+									'AUTHOR' => (($website != '') ? '<A HREF="' . $website . '">' . $username . '</A>' : $username)));
 			$i++;			
 		}
 	}
 
+	$users = array();
 	$getusers = "SELECT DISTINCT username FROM comments";
 	$getusers2 = mysql_query($getusers);
 	$i=0;
@@ -150,14 +151,14 @@ if (!isset($noRightbar))
 		$getcount2 = mysql_query($getcount);
 		$getcount3 = mysql_fetch_array($getcount2);
 
-		$getuser = "SELECT * FROM users WHERE username = \"" . $getusers3[$i]['username'] . "\"";
+		$getuser = "SELECT * FROM phpbb_users WHERE username = \"" . $getusers3[$i]['username'] . "\"";
 		$getuser2 = mysql_query($getuser);
 		$getuser3 = mysql_fetch_array($getuser2);
 
 		if ($getuser3['username'] == $getusers3[$i]['username'])
 		{
 			$username = $getuser3['username'];
-			$website = $getuser3['website'];
+			$website = $getuser3['user_website'];
 		} else {
 			$getanon = "SELECT * FROM anon_commenters WHERE username = \"" . $getusers3[$i]['username'] . "\"";
 			$getanon2 = mysql_query($getanon);
@@ -170,23 +171,39 @@ if (!isset($noRightbar))
 			}
 		}
 
-		$name = (($website != '') ? '<A HREF="http://' . $website . '">' . $username . '</A>' : $username);
-		$users[$name] = $getcount3[0];
+		$name = (($website != '') ? '<A HREF="' . $website . '">' . $username . '</A>' : $username);
+		$users[] = array('name' => $name, 'count' => $getcount3['COUNT(*)']);
 
 		$i++;
 	}
 
-	arsort($users);
+	function count_sort($a, $b)
+	{
+		$a = $a['count'];
+		$b = $b['count'];
+
+		if ($a > $b)
+		{
+			return -1;
+		} else if ($a < $b)
+		{
+			return 1;
+		} else {
+			return 0;
+		}
+	}
+
+	usort($users, 'count_sort');
 	$i=0;
-	foreach ($users as $name => $count)
+	foreach ($users as $value)
 	{
 		if ($i == 5)
 		{
 			break;
 		}
 
-		$template->adds_block('TOP', array(	'USERNAME' => $name,
-							'COUNT' => $count));
+		$template->adds_block('TOP', array(	'USERNAME' => $value['name'],
+							'COUNT' => $value['count']));
 		$i++;
 	}
 
-- 
cgit 1.4.1