members.php

<?php

include("../lib/members.php");
include_once("../lib/date.php");
$members = new Members;

if ($session->loggedin) {
	$usernames = $members->getMemberList();

	$smarty->assign('members', $usernames);
	$sidebar = $smarty->fetch('members-search.tpl');
	$smarty->assign('secondary', $sidebar);

	// Show Searched for users depending on the method provided
	$value = '';
	$uid = false;
	$pathCount = count($pathlist) -1;
	if ( isset($_POST['search']) ) {
		$value = $_POST['search'];
		$uid = true;
		$usernames = $members->memberSearch($value);
	} else if ( isset($_POST['member']) ) {
		$value = $_POST['member'];
		$uid = true;
		$usernames = $members->memberView($value);
	} else if ( $component['path'] != $path ) {
		$value = $pathlist[$pathCount];
		$usernames = $members->memberView($value);
	}
	if (!empty($value) ) {
		// Redirect if we have found a valid single user
		if (count($usernames) == 1) {
			$smarty->assign('who', $usernames[0]['uid']);
			// Add banana widget to the sidebar 
			$who = $usernames[0]['uid'];
			include("../lib/banana-admin.php");
			// Needs Redirection
			if ($uid) {
				header('Location: ' . $component['path'] . '/' . $usernames[0]['uid']);
			} else {
				// Pictures
				if (file_exists('pictures/people/' . $usernames[0]['uid'] . '.png')) {
					$usernames[0]['picture'] = '/pictures/people/' . $usernames[0]['uid'] . '.png';
				}
				// Account type
				$homedir  = explode('/', $usernames[0]['homedir']);
				$usernames[0]['acctype'] = ucfirst($homedir[2]);
				// Project
				if (file_exists( $usernames[0]['homedir'] . '/.project')) {
					$usernames[0]['project'] = file_get_contents($usernames[0]['homedir'] . '/.project');
				}
				// Plan
				if (file_exists( $usernames[0]['homedir'] . '/.plan')) {
					$usernames[0]['plan'] = file_get_contents($usernames[0]['homedir'] . '/.plan');
				}
				// Website	
				if ( file_exists( $usernames[0]['homedir'] . '/public_html') &&
				     !file_exists( $usernames[0]['homedir'] . '/public_html/robots.txt'))  {
					$usernames[0]['website'] = true;
				}
				// Blog
				require_once("/usr/share/adodb/adodb.inc.php");
				$BlogDB = NewADOConnection('postgres8');
				$BlogDB->Connect('dbname=blogs');
				$BlogDB->SetFetchMode(ADODB_FETCH_ASSOC);
				require_once('../lib/blog/validation.lib.php');
				if (blogger($usernames[0]['uid'])) {
					$usernames[0]['blog'] = $BlogDB->GetOne("select title from users where username='".$usernames[0]['uid']."'");
				}
				// Bananas stuff
				$bananasql = "SELECT *, date_trunc('second', whn) FROM awards ";
				$bananasql .= "WHERE username ~* ? ORDER BY WHN DESC";
				$awards = $DB->GetAll($bananasql, array("^".$usernames[0]['uid']."$"));
				
				// arrange by academic year, calculate sums as we go
				foreach ($awards as $award) {
					$acyear = academicYear(strtotime($award['whn']));
					$awards_by_year[$acyear]['awards'][] = $award;
					$awards_by_year[$acyear]['sum'] += $award['score']; 
					$bananasum += $award['score'];
				} 
				
				$usernames[0]['awardsbyyear'] = &$awards_by_year; 
				$usernames[0]['bananascore'] = $bananasum;
			}
		}
		$smarty->assign('results', $usernames);
	
	} else {
	// generate fun data to put on index page
		
		// top 5
		$stats['top'] = $DB->GetAll("SELECT username, sum(score) as sum FROM awards GROUP BY username ORDER BY sum DESC LIMIT 5");

		// top 5 (this academic year)
		$yeartop_sql = "SELECT username, sum(score) as sum FROM awards ";
		$yeartop_sql .= "WHERE whn > date(?) GROUP BY username ORDER BY sum DESC LIMIT 5";
		$stats['yeartop'] = $DB->GetAll($yeartop_sql, array(academicYear(time())."-09-01"));

		// bottom 5
		$stats['bottom'] = $DB->GetAll("SELECT username, sum(score) as sum FROM awards GROUP BY username ORDER BY sum ASC LIMIT 5");
		// recent awards
		// today's definition of "recent" is all awards within three days of the newest award and a minimum of five... 
		// if this seems like a dumb method then try something else :-)
		$recentAwards_sql = "(SELECT * FROM awards WHERE whn > (SELECT whn - interval '3 days' FROM awards ORDER BY whn DESC LIMIT 1))";
		$recentAwards_sql .= " UNION (SELECT * FROM awards ORDER BY whn DESC LIMIT 5) ORDER BY 4 DESC";
		$stats['recent'] = $DB->GetAll($recentAwards_sql);


                // retrieve the usernames for top stats, bottom stats, and all users - so we can filter out who's a user and who's not
                foreach ($usernames as $i => $value) {
                        $realUsers[] = $usernames[$i]['uid'];
                }
                foreach ($stats['yeartop'] as $i => $value) {
                        if (in_array(strtolower($stats['yeartop'][$i]['username']), $realUsers)) {
                                $stats['yeartop'][$i]['real'] = TRUE;
                        } else {
                                $stats['yeartop'][$i]['real'] = FALSE;
                        }
                }
                foreach ($stats['top'] as $i => $value) {
                        if (in_array(strtolower($stats['top'][$i]['username']), $realUsers)) {
                                $stats['top'][$i]['real'] = TRUE;
                        } else {
                                $stats['top'][$i]['real'] = FALSE;
                        }
                }
                foreach ($stats['bottom'] as $i => $value) {
                        if (in_array(strtolower($stats['bottom'][$i]['username']), $realUsers)) {
                                $stats['bottom'][$i]['real'] = TRUE;
                        } else {
                                $stats['bottom'][$i]['real'] = FALSE;
                        }
                }
                foreach ($stats['recent'] as $i => $value) {
                        if (in_array(strtolower($stats['recent'][$i]['username']), $realUsers)) {
                                $stats['recent'][$i]['real'] = TRUE;
                        } else {
                                $stats['recent'][$i]['real'] = FALSE;
                        }
                }
	
		$smarty->assign("stats", $stats);
		$secondary = $smarty->get_template_vars("secondary");
		$secondary .= $smarty->fetch("banana-leaders.tpl");
		$smarty->assign("secondary", $secondary);

	}
} else {
	// not logged in. Show a list of members with websites
	$usernames = $members->getMemberList();

	foreach ($usernames as $user) {
		if ( file_exists( $user['homedir'] . '/public_html') &&
		     !file_exists( $user['homedir'] . '/public_html/robots.txt'))  {
			$public_usernames[] = $user;
		}
	}
	$smarty->assign("public_members", $public_usernames);
}
	

$smarty->assign('url', $component['path']);
$smarty->assign('extra_styles', "/css/members.css");
$result = $smarty->fetch('members.tpl');
$smarty->assign('title', "Members");
$smarty->assign('body', $result);

// End Actual Code
?>