root/components/members.php @ 314

<?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']."$"));
                
                // add academic year to each award, perform slightly nasty hack to add sum for academic year to last of the year
                $yearSum = 0;
                unset($acYear);
                unset($yearStart);
                foreach ($awards as $i => $award) {
                    $awards[$i]['acYear'] = academicYear(strtotime($award['whn']));
                    if ($acYear != $awards[$i]['acYear']) {
                        if(isset($yearStart)) {
                            $awards[$yearStart]['yearSum'] = $yearSum;
                            $yearSum = 0;
                        }
                        $yearSum += $award['score'];
                        $acYear = $awards[$i]['acYear'];
                        $yearStart = $i;
                    } else {
                        $yearSum += $award['score'];
                    }
                }
                if(isset($yearStart)) $awards[$yearStart]['yearSum'] = $yearSum;
                
                
                $usernames[0]['awards'] = $awards; 
                $bananasumsql = "select sum(score) as sum from awards where username ~* ?";
                $bananasum = $DB->GetAll($bananasumsql, array("^".$usernames[0]['uid']."$"));
                $usernames[0]['bananascore'] = $bananasum[0]['sum'];
            }
        }
        $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
?>