function setup_sponsor()
{
global $smarty;
global $SPONSOR;
global $Link;
$columns = 'sponsorID, sponsorName, sponsorURL, sponsorAbout, sponsorLogoWidth, sponsorLogoHeight';
$sponsorsSelect = 'SELECT ' . $columns . ' FROM ' . SPONSORS . ' WHERE sponsorID=' . $SPONSOR;
$sponsorsResult = mysql_query($sponsorsSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($sponsorsResult && mysql_num_rows($sponsorsResult) > 0) {
$sponsor = mysql_fetch_array($sponsorsResult, MYSQL_ASSOC);
$id = $sponsor['sponsorID'];
$name = $sponsor['sponsorName'];
$url = $sponsor['sponsorURL'];
$about = $sponsor['sponsorAbout'];
$logoWidth = $sponsor['sponsorLogoWidth'];
$logoHeight = $sponsor['sponsorLogoHeight'];
$smarty->assign('sponsorID', $id);
$smarty->assign('sponsorName', $name);
$smarty->assign('sponsorURL', $url);
$smarty->assign('sponsorAbout', $about);
if ($logoWidth > 0) {
$smarty->assign('imageSize', imageSize($logoWidth, $logoHeight, 400));
}
}
}
function setup_award()
{
global $smarty;
global $AWARD;
global $Link;
$columns = 'awardID, seasonID, award, about, recipient, imageWidth, imageHeight';
$awardSelect = 'SELECT ' . $columns . ' FROM ' . AWARDS . ' WHERE awardID=' . $AWARD;
$awardResult = mysql_query($awardSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($awardResult && mysql_num_rows($awardResult) > 0) {
$award = mysql_fetch_array($awardResult, MYSQL_ASSOC);
$id = $award['awardID'];
$awardName = $award['award'];
$recipient = $award['recipient'];
$about = $award['about'];
$seasonName = get_season_name($award['seasonID']);
$imageWidth = $award['imageWidth'];
$imageHeight = $award['imageHeight'];
$smarty->assign('awardID', $id);
$smarty->assign('award', $awardName);
$smarty->assign('recipient', $recipient);
$smarty->assign('about', $about);
$smarty->assign('seasonName', $seasonName);
if ($imageWidth > 0) {
$smarty->assign('imageSize', imageSize($imageWidth, $imageHeight, 700));
}
}
}
function get_current_sponsor_from_db()
{
global $smarty;
global $Link;
global $SPONSOR;
global $IMAGE_WIDTH;
$sponsorSelect = 'SELECT sponsorName, sponsorURL, sponsorAbout, sponsorLogoWidth, sponsorLogoHeight FROM ' . SPONSORS . ' WHERE sponsorID=' . $SPONSOR;
$sponsorResult = mysql_query($sponsorSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($sponsorResult && mysql_num_rows($sponsorResult) > 0) {
$sponsor = mysql_fetch_array($sponsorResult, MYSQL_ASSOC);
$sn = $sponsor['sponsorName'];
$su = $sponsor['sponsorURL'];
$sa = $sponsor['sponsorAbout'];
$logoWidth = $sponsor['sponsorLogoWidth'];
$logoHeight = $sponsor['sponsorLogoHeight'];
$sa = str_replace('<br />', '', $sa);
$smarty->assign('sn', $sn);
$smarty->assign('su', $su);
$smarty->assign('sa', $sa);
$smarty->assign('logoWidth', $logoWidth);
$smarty->assign('logoHeight', $logoHeight);
if ($logoWidth > 0) {
$smarty->assign('imageSize', imageSize($logoWidth, $logoHeight, $IMAGE_WIDTH));
}
}
}
function setup_sponsorships()
{
global $smarty;
global $Link;
global $SEASON;
$smarty->assign('SPONSOR_GROUP', 'League');
$foundSeasonWithSponsors = false;
$seasonTest = $SEASON;
while (!$foundSeasonWithSponsors) {
$select = 'SELECT * FROM ' . SPONSORSOFSEASONS . ' WHERE seasonID=' . $seasonTest . ' LIMIT 1';
$result = mysql_query($select, $Link);
if ($result && mysql_num_rows($result) > 0) {
$foundSeasonWithSponsors = true;
} else {
$seasonTest--;
if ($seasonTest == 0) {
$foundSeasonWithSponsors = true;
}
}
}
if ($foundSeasonWithSponsors && $seasonTest != 0) {
$selectColumns = 'sponsorID,sponsorName,sponsorLogoWidth, sponsorLogoHeight';
$subQuery = 'SELECT distinct sponsorID FROM ' . SPONSORSOFSEASONS . ' WHERE seasonID=' . $seasonTest;
$sponsorsSelect = 'SELECT ' . $selectColumns . ' FROM ' . SPONSORS . ' WHERE sponsorID IN (' . $subQuery . ') ORDER BY sponsorName';
$sponsorsResult = mysql_query($sponsorsSelect, $Link);
if ($sponsorsResult) {
if (mysql_num_rows($sponsorsResult) > 0) {
$countSponsors = 0;
$smarty->assign('sponsorID', array());
$smarty->assign('sponsorName', array());
$smarty->assign('imageSize', array());
while ($sponsor = mysql_fetch_array($sponsorsResult, MYSQL_ASSOC)) {
$countSponsors++;
$sponsorId = $sponsor['sponsorID'];
$sponsorName = $sponsor['sponsorName'];
$logoWidth = $sponsor['sponsorLogoWidth'];
$logoHeight = $sponsor['sponsorLogoHeight'];
$smarty->append('sponsorID', $sponsorId);
$smarty->append('sponsorName', $sponsorName);
if ($logoWidth > 0) {
$smarty->append('imageSize', imageSize($logoWidth, $logoHeight, 200));
} else {
$smarty->append('imageSize', 0);
}
}
$smarty->assign('countSponsors', $countSponsors);
}
}
}
}
$smarty->assign('boardMemberCellPhone', array());
$smarty->assign('boardMemberDuties', array());
$smarty->assign('boardMemberImageSize', array());
foreach ($BoardMembersArray as $BoardMember) {
$count++;
$smarty->append('boardMemberID', $BoardMember->get_boardMemberID());
$smarty->append('boardMemberName', $BoardMember->get_boardMemberFirstName() . ' ' . $BoardMember->get_boardMemberLastName());
$smarty->append('boardMemberFirstName', $BoardMember->get_boardMemberFirstName());
$smarty->append('boardMemberLastName', $BoardMember->get_boardMemberLastName());
$smarty->append('boardMemberEmail', strToHex($BoardMember->get_boardMemberEmail()));
$smarty->append('boardMemberHomePhone', $BoardMember->get_boardMemberHomePhone());
$smarty->append('boardMemberWorkPhone', $BoardMember->get_boardMemberWorkPhone());
$smarty->append('boardMemberCellPhone', $BoardMember->get_boardMemberCellPhone());
$smarty->append('boardMemberDuties', $BoardMember->get_boardMemberDuties());
if ($BoardMember->get_boardMemberImageWidth() > 0) {
$smarty->append('boardMemberImageSize', imageSize($BoardMember->get_boardMemberImageWidth(), $BoardMember->get_boardMemberImageWidth(), $BoardMember->get_imageMaxWidth()));
} else {
$smarty->append('boardMemberImageSize', 0);
}
}
$smarty->assign('count', $count);
}
// Build the page
require 'global_begin.php';
$smarty->display('public/boardmembers.tpl');
require 'global_end.php';
/*
* ********************************************************************************
* ********************************************************************************
* **************************L O C A L F U N C T I O N S**************************
* ********************************************************************************
function get_current_award_from_db()
{
global $smarty;
global $Link;
global $AWARD;
global $IMAGE_WIDTH;
global $priority;
global $SEASON;
$awardSelect = 'SELECT award, seasonID, recipient, about, priority, imageWidth, imageHeight FROM ' . AWARDS . ' WHERE awardID=' . $AWARD;
$awardResult = mysql_query($awardSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($awardResult && mysql_num_rows($awardResult) > 0) {
$award = mysql_fetch_array($awardResult, MYSQL_ASSOC);
$awardName = $award['award'];
$SEASON = $award['seasonID'];
$recipient = $award['recipient'];
$priority = $award['priority'];
$about = $award['about'];
$imageWidth = $award['imageWidth'];
$imageHeight = $award['imageHeight'];
$about = str_replace('<br />', '', $about);
$smarty->assign('aw', $awardName);
$smarty->assign('re', $recipient);
$smarty->assign('ab', $about);
$smarty->assign('imageWidth', $imageWidth);
$smarty->assign('imageHeight', $imageHeight);
if ($imageWidth > 0) {
$smarty->assign('imageSize', imageSize($imageWidth, $imageHeight, $IMAGE_WIDTH));
}
}
}
