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)); } } }