Beispiel #1
0
function setup_announcements()
{
    global $smarty;
    global $Link;
    $currentTimeEpoch = time();
    $announceSelectColumns = 'announceId, announceTitle, announcement, ' . ANNOUNCEMENTS . '.userID, ' . USER . '.userID, firstName, lastName ';
    $announceSelect = "SELECT " . $announceSelectColumns . " FROM " . ANNOUNCEMENTS . " JOIN " . USER . " ON " . ANNOUNCEMENTS . ".userID = " . USER . ".userID WHERE announceBeginDate <= '" . $currentTimeEpoch . "' AND announceEndDate >= '" . $currentTimeEpoch . "' ORDER BY announceID DESC";
    $announceResult = mysql_query($announceSelect, $Link);
    if ($announceResult && mysql_num_rows($announceResult) > 0) {
        $smarty->assign('announcements', 1);
        $smarty->assign('announcementId', array());
        $smarty->assign('announcementTitle', array());
        $smarty->assign('announcementBody', array());
        $smarty->assign('userSubmitted', array());
        while ($announcement = mysql_fetch_array($announceResult, MYSQL_ASSOC)) {
            $announcementId = $announcement['announceId'];
            $announcementTitle = $announcement['announceTitle'];
            $announcementBody = $announcement['announcement'];
            $userSubmitted = format_initial($announcement['firstName']) . '. ' . $announcement['lastName'];
            $smarty->append('announcementId', $announcementId);
            $smarty->append('announcementTitle', $announcementTitle);
            $smarty->append('announcementBody', $announcementBody);
            $smarty->append('userSubmitted', $userSubmitted);
        }
    } else {
        $smarty->assign('announcements', 0);
    }
}
Beispiel #2
0
function setup_draft_info()
{
    global $smarty;
    global $SEASON;
    global $currentRound;
    global $seasonalTeamsCount;
    global $Link;
    //Select teams
    $teamNameSelect = 'SELECT teamId, teamName FROM ' . TEAMS . ' WHERE teamID IN (SELECT teamID FROM ' . TEAMSOFSEASONS . ' WHERE seasonID=' . $SEASON . ' AND teamID != 7 AND teamID != 14) ORDER BY teamID';
    $teamNameResult = mysql_query($teamNameSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
    if ($teamNameResult && mysql_num_rows($teamNameResult) > 0) {
        $teamIdArray = array();
        $smarty->assign('teamId', array());
        $smarty->assign('teamName', array());
        $column = 0;
        $columnNum = array();
        $columnNum[$column] = 0;
        while ($team = mysql_fetch_array($teamNameResult, MYSQL_ASSOC)) {
            $column++;
            $columnNum[$column] = $team['teamId'];
            $teamId = $team['teamId'];
            $teamName = $team['teamName'];
            $smarty->append('teamId', $teamId);
            $smarty->append('teamName', $teamName);
        }
    }
    //Select rounds
    $roundSelect = 'SELECT round FROM ' . DRAFT . ' GROUP BY round';
    $roundResult = mysql_query($roundSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
    $rounds = 0;
    if ($roundResult && mysql_num_rows($roundResult) > 0) {
        $smarty->assign('round', array());
        while ($round = mysql_fetch_array($roundResult, MYSQL_ASSOC)) {
            $rounds = $round['round'];
        }
    }
    $smarty->assign('rounds', $rounds);
    //Select players and create table
    $draftDataRows = '';
    for ($rowNum = 1; $rowNum <= $rounds; $rowNum++) {
        $select = 'SELECT playerFName,playerLName,' . DRAFT . '.playerId,teamId,skillLevelChar FROM ' . DRAFT;
        $select .= ' JOIN ' . PLAYER . ' ON ' . DRAFT . '.playerId = ' . PLAYER . '.playerId';
        $select .= ' JOIN ' . SKILLLEVELS . ' ON ' . PLAYER . '.playerSkillLevel = ' . SKILLLEVELS . '.skillLevelID';
        $select .= ' AND round=' . $rowNum;
        $select .= ' AND ' . DRAFT . '.seasonId=' . $SEASON;
        $select .= ' ORDER BY teamId';
        $result = mysql_query($select, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
        if ($result && mysql_num_rows($result) > 0) {
            $column = 0;
            $row = '<tr><td><b>' . $rowNum . '</b></td>';
            while ($player = mysql_fetch_array($result, MYSQL_ASSOC)) {
                $column++;
                while ($columnNum[$column] != $player['teamId']) {
                    $column++;
                    if (PAGE_TYPE == 'ADMIN' && $rowNum < $currentRound) {
                        $row .= '<td>';
                        $row .= '<form method="post" action="draftmode.php">';
                        $row .= '<input type="hidden" name="currentRound" value="' . $rowNum . '" />';
                        $row .= '<input type="hidden" name="team" value="' . $columnNum[$column - 1] . '" />';
                        $row .= getRedraftPlayerForm();
                        $row .= '<input name="action" type="submit" value="Draft Player" />';
                        $row .= '</form>';
                        $row .= '</td>';
                    } else {
                        $row .= '<td>&nbsp;</td>';
                    }
                }
                $row .= '<td>';
                if (PAGE_TYPE == 'ADMIN') {
                    $row .= '<a href="draftmode.php?deletepick=true&seasonId=' . $SEASON . '&playerId=' . $player['playerId'] . '&round=' . $rowNum . '&teamId=' . $player['teamId'] . '"><img class="imglink" src="images/delete.gif" title="Delete this pick" alt="Delete this pick" onclick=\'return showAlert("that you want to delete this draft pick?")\' /></a>';
                }
                $row .= $player['playerFName'] . ' ' . $player['playerLName'] . ' (' . format_initial($player['skillLevelChar']) . ')</td>';
            }
            //This will fill in the remaining table data cells at the end.
            while ($column != count($columnNum) - 1) {
                $column++;
                if (PAGE_TYPE == 'ADMIN' && $rowNum < $currentRound) {
                    $row .= '<td>';
                    $row .= '<form method="post" action="draftmode.php">';
                    $row .= '<input type="hidden" name="currentRound" value="' . $rowNum . '" />';
                    $row .= '<input type="hidden" name="team" value="' . $columnNum[$column] . '" />';
                    $row .= getRedraftPlayerForm();
                    $row .= '<input name="action" type="submit" value="Draft Player" />';
                    $row .= '</form>';
                    $row .= '</td>';
                } else {
                    $row .= '<td>&nbsp;</td>';
                }
            }
        } else {
            $row = '<tr>';
        }
        $row .= '</tr>';
        $draftDataRows .= $row;
    }
    //for
    $smarty->assign('draftDataRows', $draftDataRows);
}
Beispiel #3
0
function get_site_user_initials($userid)
{
    global $Link;
    $select = 'SELECT firstName, lastName FROM ' . USER . ' WHERE userID=' . $userid;
    $result = mysql_query($select, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
    if ($result && mysql_num_rows($result) > 0) {
        $name = mysql_fetch_assoc($result);
        $fInt = format_initial($name['firstName']);
        $lInt = format_initial($name['lastName']);
        return $fInt . $lInt;
    } else {
        return 'NA';
    }
}