function setup_balances()
{
global $smarty;
global $SEASON;
global $Link;
$select = 'SELECT ' . REFEREESOFSEASONS . '.playerID, level FROM ' . REFEREESOFSEASONS . ' JOIN ' . PLAYER . ' ON ' . REFEREESOFSEASONS . '.playerID = ' . PLAYER . '.playerID WHERE ' . REFEREESOFSEASONS . '.seasonID=' . $SEASON . ' ORDER BY level DESC, playerLName';
$result = mysql_query($select, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($result && mysql_num_rows($result) > 0) {
$countRefs = 0;
$smarty->assign('playerID', array());
$smarty->assign('playerName', array());
$smarty->assign('level', array());
$smarty->assign('gamesReffed', array());
$smarty->assign('balance', array());
while ($player = mysql_fetch_array($result, MYSQL_ASSOC)) {
$countRefs++;
$playerId = $player['playerID'];
$playerName = get_player_name($player['playerID']);
$level = $player['level'];
$gamesReffed = get_games_reffed($playerId);
$balance = calculate_balance($level, $gamesReffed);
$smarty->append('playerID', $playerId);
$smarty->append('playerName', $playerName);
$smarty->append('level', $level);
$smarty->append('gamesReffed', $gamesReffed);
$smarty->append('balance', $balance);
}
$smarty->assign('countRefs', $countRefs);
}
}
function setup_user_list()
{
global $smarty;
global $Link;
$selectColumns = 'userID,firstName,lastName,eMail,registeredDate,accessLevel,requestedPlayerStats,playerId';
$userSelect = 'SELECT ' . $selectColumns . ' FROM ' . USER . ' WHERE userID > 1 ORDER BY accessLevel DESC,lastName';
$userResult = mysql_query($userSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($userResult && mysql_num_rows($userResult) > 0) {
$countUsers = 0;
$smarty->assign('userID', array());
$smarty->assign('name', array());
$smarty->assign('userName', array());
$smarty->assign('registeredDate', array());
$smarty->assign('accessLevel', array());
$smarty->assign('reqPlayerId', array());
$smarty->assign('reqPlayerName', array());
$smarty->assign('playerId', array());
$smarty->assign('playerName', array());
while ($user = mysql_fetch_array($userResult, MYSQL_ASSOC)) {
$countUsers++;
$userID = $user['userID'];
$name = $user['firstName'] . ' ' . $user['lastName'];
$userName = $user['eMail'];
$registeredDate = $user['registeredDate'];
$accessLevel = $user['accessLevel'];
$reqPlayerId = $user['requestedPlayerStats'];
if ($reqPlayerId > 0) {
$reqPlayerName = get_player_name($reqPlayerId);
} else {
$reqPlayerId = -1;
$reqPlayerName = 'NO ONE';
}
$playerId = $user['playerId'];
if ($playerId > 0) {
$playerName = get_player_name($playerId);
} else {
$playerId = -1;
$playerName = 'NO ONE';
}
$smarty->append('userID', $userID);
$smarty->append('name', $name);
$smarty->append('userName', $userName);
$smarty->append('registeredDate', $registeredDate);
$smarty->append('accessLevel', $accessLevel);
$smarty->append('reqPlayerId', $reqPlayerId);
$smarty->append('reqPlayerName', $reqPlayerName);
$smarty->append('playerId', $playerId);
$smarty->append('playerName', $playerName);
}
$smarty->assign('countUsers', $countUsers);
}
}
$i++;
$doomsday->MoveNext();
}
if($affliction == 1) // Space Plague
{
echo "The horsmen release the Space Plague!<BR>.";
$db->Execute("UPDATE $dbtables[planets] SET colonists = ROUND(colonists-colonists*$space_plague_kills) WHERE planet_id = $targetinfo[planet_id]");
$logpercent = ROUND($space_plague_kills * 100);
playerlog($targetinfo[owner],LOG_SPACE_PLAGUE,"$targetinfo[name]|$targetinfo[sector_id]|$logpercent");
$name = get_player_name($targetinfo[owner]);
$headline="Travel Advisory";
$news = addslashes("The Universe Health Organization warned visitors to refrain from visiting $targetinfo[name] due to an outbreak of Space Plague. Millions are reported dead. The plague was blamed on colonist overcrowding by $name. Shame!");
$db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$news','$targetinfo[owner]',NOW(), 'plague')");
}
else
{
echo "The horsemen release a Plasma Storm!<BR>.";
$db->Execute("UPDATE $dbtables[planets] SET energy = 0 WHERE planet_id = $targetinfo[planet_id]");
playerlog($targetinfo[owner],LOG_PLASMA_STORM,"$targetinfo[name]|$targetinfo[sector_id]");
$name = get_player_name($targetinfo[owner]);
$headline="Weather Report";
$news = addslashes("A plasma storm struck $name's sector today. No casualties were reported.");
$db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$news','$targetinfo[owner]',NOW(), 'plasma')");
}
}
echo "<BR>";
$temp_runtime= time() - $temp_time;
echo "<p>The apocolypse took $temp_runtime seconds to execute.<p>";
?>
highlight: "#5AD3D1",
label: "Win Percentage"
},
{
value: <?php
echo $stats["all"]["loss_percentage"];
?>
,
color:"#F7464A",
highlight: "#FF5A5E",
label: "Losing Percentage"
}
];
</script>
<section class="name">
<h1>
<?php
$name = get_player_name($player_id);
echo $name["first_name"] . "<span>­" . $name["last_name"] . "</span>";
?>
</h1>
</section>
<?php
include "sections/generic/games-view.php";
?>
<?php
include "sections/generic/money-view.php";
}
} else {
if ($row['amount'] >= 1000000000000) {
$sql2 = $db->Execute("SELECT * FROM {$db->prefix}news WHERE user_id = ? AND news_type = 'credit_2';", array($row['owner']));
db_op_result($db, $sql2, __LINE__, __FILE__, $db_logging);
if ($sql2->EOF) {
$name = get_player_name($row['owner']);
$headline = "Federation Credit Inspection Report";
$l_news = "While doing routine checks on planets, it was discovered that " . $name . "'s empire has amassed a vast wealth of over 1 Trillion credits in storage, why " . $name . " is building up a large cash reserve has yet to be determined!.";
$news = $db->Execute("INSERT INTO {$db->prefix}news (headline, newstext, user_id, date, news_type) VALUES (?, ?, ?, NOW(), 'credit_2');", array($headline, $l_news, $row['owner']));
db_op_result($db, $news, __LINE__, __FILE__, $db_logging);
}
} else {
if ($row['amount'] >= 100000000000000) {
$sql2 = $db->Execute("SELECT * FROM {$db->prefix}news WHERE user_id = ? AND news_type = 'credit_3';", array($row['owner']));
db_op_result($db, $sql2, __LINE__, __FILE__, $db_logging);
if ($sql2->EOF) {
$name = get_player_name($row['owner']);
$headline = "Federation Credit Inspection Report";
$l_news = "After previous reports, inspectors organised another inspection of " . $name . "'s banks, however while carrying out this inspection, the inspectors went missing. A coded message was later intercepted, and contain the following.. " . $name . " has amassed a vast wealth of over 100 trillion credits, and is in a position to threaten the stability of the federation.";
$news = $db->Execute("INSERT INTO {$db->prefix}news (headline, newstext, user_id, date, news_type) VALUES (?, ?, ?, NOW(), 'credit_3');", array($headline, $l_news, $row['owner']));
db_op_result($db, $news, __LINE__, __FILE__, $db_logging);
}
}
}
}
$sql->MoveNext();
}
// while
$multiplier = 0;
// No need to run this again
</option> </select> <br> <select onchange="select_swap(this.id)" id="FW3" style="width: 263px; height: 25px; background-color:#deb258; border-color:#000000; border:0px; position:relative; top:6px; border:0px;"> <option value="FW1"><?php echo get_player_name($FW[1]); ?> </option> <option value="FW2"><?php echo get_player_name($FW[2]); ?> </option> <option selected="selected" value="FW3"><?php echo get_player_name($FW[3]); ?> </option> </select> </form> <!-- END_Team Selection Forms --> <!--
$smarty->assign('gameGuestTeam', array());
$smarty->assign('gameHomeTeam', array());
$smarty->assign('gameReferee1', array());
$smarty->assign('gameReferee2', array());
$smarty->assign('gameReferee3', array());
$smarty->assign('postponed', array());
$smarty->assign('announcementID', array());
while ($game = mysql_fetch_array($scheduleResult, MYSQL_ASSOC)) {
$gameId = $game['gameID'];
$gameDate = date('D, M jS', $game['gameTime']);
$gameTime = date('g:i a', $game['gameTime']);
$gameGuest = get_team_name($game['gameGuestTeam']);
$gameHome = get_team_name($game['gameHomeTeam']);
$gameRef1 = get_player_name($game['gameReferee1']);
$gameRef2 = get_player_name($game['gameReferee2']);
$gameRef3 = get_player_name($game['gameReferee3']);
$gamePostponed = $game['postponed'];
if ($game['announcementID'] > 0) {
$gameAnnouncementId = $game['announcementID'];
} else {
$gameAnnouncementId = 'NA';
}
$gameDateLabel = '';
if ($todayBeginningOfDay <= $game['gameTime'] && $game['gameTime'] <= $todayEndOfDay) {
$gameDateLabel .= 'Today';
} else {
if ($tomorrowBeginningOfDay <= $game['gameTime'] && $game['gameTime'] <= $tomorrowEndOfDay) {
$gameDateLabel .= 'Tomorrow';
} else {
$gameDateLabel .= $gameDate;
}
function setup_current_game_refs()
{
global $smarty;
global $gameid;
global $Link;
//$playersSelect = 'SELECT '.REFEREESOFSEASONS.'.playerID,playerFName,playerLName FROM '.REFEREESOFSEASONS.' JOIN '.PLAYER.' ON '.REFEREESOFSEASONS.'.playerID = '.PLAYER.'.playerID WHERE '.REFEREESOFSEASONS.'.seasonID='.$SEASON.' ORDER BY playerLName';
$refSelect = 'SELECT gameReferee1,gameReferee2,gameReferee3 FROM ' . GAME;
$refSelect .= ' WHERE gameID=' . $gameid;
$refResult = mysql_query($refSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($refResult && mysql_num_rows($refResult) > 0) {
$ref = mysql_fetch_assoc($refResult);
$refOnePlayerId = $ref['gameReferee1'];
$refTwoPlayerId = $ref['gameReferee2'];
$refThreePlayerId = $ref['gameReferee3'];
$refOnePlayerName = get_player_name($refOnePlayerId);
$refTwoPlayerName = get_player_name($refTwoPlayerId);
$refThreePlayerName = get_player_name($refThreePlayerId);
$smarty->assign('refOnePlayerId', $refOnePlayerId);
$smarty->assign('refTwoPlayerId', $refTwoPlayerId);
$smarty->assign('refThreePlayerId', $refThreePlayerId);
$smarty->assign('refOnePlayerName', $refOnePlayerName);
$smarty->assign('refTwoPlayerName', $refTwoPlayerName);
$smarty->assign('refThreePlayerName', $refThreePlayerName);
}
//
}
function setup_registrant_details()
{
global $smarty;
global $registrantid;
global $Link;
$registrantSelect = 'SELECT * FROM ' . REGISTRATION . ' JOIN ' . SKILLLEVELS . ' ON ' . REGISTRATION . '.skillLevel = ' . SKILLLEVELS . '.skillLevelID AND registrationId=' . $registrantid;
$registrantResult = mysql_query($registrantSelect, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($registrantResult && mysql_num_rows($registrantResult) > 0) {
$registrant = mysql_fetch_assoc($registrantResult);
$smarty->assign('seasonId', get_season_name($registrant['seasonId']));
$smarty->assign('registrationId', $registrant['registrationId']);
$smarty->assign('playerId', $registrant['playerId']);
if (isset($registrant['playerId']) && $registrant['playerId'] > 0) {
$smarty->assign('playerName', get_player_name($registrant['playerId']));
}
$smarty->assign('fname', $registrant['fName']);
$smarty->assign('lname', $registrant['lName']);
$smarty->assign('address', $registrant['addressOne'] . ' ' . $registrant['addressTwo'] . '; ' . $registrant['city'] . ', ' . $registrant['state'] . ' ' . $registrant['postalCode']);
$smarty->assign('email', $registrant['eMail']);
$smarty->assign('position', $registrant['position']);
$smarty->assign('jerseySize', $registrant['jerseySize']);
$smarty->assign('jerseyNumberOne', $registrant['jerseyNumberOne']);
$smarty->assign('jerseyNumberTwo', $registrant['jerseyNumberTwo']);
$smarty->assign('jerseyNumberThree', $registrant['jerseyNumberThree']);
$smarty->assign('homePhone', $registrant['homePhone']);
$smarty->assign('workPhone', $registrant['workPhone']);
$smarty->assign('cellPhone', $registrant['cellPhone']);
$smarty->assign('skillLevel', $registrant['skillLevelName']);
$smarty->assign('wantToSub', $registrant['wantToSub']);
$smarty->assign('subSunday', $registrant['subSunday']);
$smarty->assign('subMonday', $registrant['subMonday']);
$smarty->assign('subTuesday', $registrant['subTuesday']);
$smarty->assign('subWednesday', $registrant['subWednesday']);
$smarty->assign('subThursday', $registrant['subThursday']);
$smarty->assign('subFriday', $registrant['subFriday']);
$smarty->assign('subSaturday', $registrant['subSaturday']);
$smarty->assign('travelingWithWho', $registrant['travelingWithWho']);
$smarty->assign('wantToBeATeamRep', $registrant['wantToBeATeamRep']);
$smarty->assign('wantToBeARef', $registrant['wantToBeARef']);
$smarty->assign('paymentPlan', $registrant['paymentPlan']);
$smarty->assign('registrationApproved', $registrant['registrationApproved']);
$smarty->assign('additionalNotes', $registrant['notes']);
$smarty->assign('drilLeague', $registrant['drilLeague']);
$smarty->assign('payToday', $registrant['payToday']);
if (strlen($registrant['usaHockeyMembership']) > 0) {
$smarty->assign('usaHockeyMembership', $registrant['usaHockeyMembership']);
} else {
$smarty->assign('usaHockeyMembership', 'NONE');
}
$skillDiv = "";
if ($registrant['skillLevelID'] == 1) {
$skillDiv = "beginDiv";
} else {
if ($registrant['skillLevelID'] == 2) {
$skillDiv = "leveloneDiv";
} else {
if ($registrant['skillLevelID'] == 3) {
$skillDiv = "leveltwoDiv";
} else {
if ($registrant['skillLevelID'] == 4) {
$skillDiv = "levelthreeDiv";
} else {
if ($registrant['skillLevelID'] == 5) {
$skillDiv = "levelfourDiv";
}
}
}
}
}
$smarty->assign('skillDivId', $skillDiv);
}
}
function setup_team_rep()
{
global $smarty;
global $Link;
global $SEASON;
global $TEAM;
$select = 'SELECT teamRep FROM ' . TEAMSOFSEASONS . ' WHERE teamID=' . $TEAM . ' AND seasonID=' . $SEASON;
$result = mysql_query($select, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($result && mysql_num_rows($result) > 0) {
$rep = mysql_fetch_assoc($result);
if ($rep['teamRep'] > 0) {
$smarty->assign('teamRep', get_player_name($rep['teamRep']));
} else {
$smarty->assign('teamRep', 'No Team Rep');
}
}
}
} else {
// If errors occur while trying to create user, we need to return with errors.
if ($errors = process_editplayerstat_form()) {
handle_errors($errors);
} else {
header("Location: managegamestats.php?gameid={$GAMEID}");
}
}
}
$select = 'SELECT * FROM ' . PLAYERSTAT . ' WHERE gameID=' . $GAMEID . ' AND playerID=' . $PLAYERID . ' AND teamID=' . $TEAMID;
$result = mysql_query($select, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($result && mysql_num_rows($result) > 0) {
$stat = mysql_fetch_assoc($result);
$smarty->assign('gameID', $stat['gameID']);
$smarty->assign('playerID', $stat['playerID']);
$smarty->assign('playerName', get_player_name($stat['playerID']));
$smarty->assign('teamID', $stat['teamID']);
$smarty->assign('goals', $stat['goals']);
$smarty->assign('assists', $stat['assists']);
$smarty->assign('pim', $stat['pim']);
}
$smarty->assign('page_name', 'Edit Player Stat');
// Build the page
require 'global_begin.php';
$smarty->display('admin/editplayerstat.tpl');
require 'global_end.php';
/*
* ********************************************************************************
* ********************************************************************************
* **************************L O C A L F U N C T I O N S**************************
* ********************************************************************************
if ($sql2->EOF) {
$colcount = 100;
$name = get_player_name($row[owner]);
$l_news_p_headline2=str_replace("[player]",$name,$l_news_p_headline);
$headline = $l_news_p_headline2 . $colcount . $l_news_cols;
$l_news_c_text1002=str_replace("[name]",$name,$l_news_c_text100);
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$l_news_c_text1002','$row[owner]',NOW(), 'col100')");
}
}
elseif ($row[amount] >= 25000000) {
$sql2 = $db->Execute("select * from $dbtables[news] where user_id='$row[owner]' and news_type='col25'");
if ($sql2->EOF) {
$colcount = 25;
$name = get_player_name($row[owner]);
$l_news_p_headline2=str_replace("[player]",$name,$l_news_p_headline);
$headline = $l_news_p_headline2 . $colcount . $l_news_cols;
$l_news_c_text252=str_replace("[name]",$name,$l_news_c_text25);
$news = $db->Execute("INSERT INTO $dbtables[news] (headline, newstext, user_id, date, news_type) VALUES ('$headline','$l_news_c_text252','$row[owner]',NOW(), 'col25')");
}
}
$sql->MoveNext();
} // while
// end generation of colonist amount
$multiplier = 0; //no use to run this more than once per tick
?>
function setup_registration_lists()
{
global $smarty;
global $SEASON;
global $Link;
$selectColumns = 'registrationId,playerId,fName,lName,addressOne,addressTwo,city,state,postalCode,eMail,homePhone,workPhone,cellPhone';
$approvedRegistrations = 'SELECT ' . $selectColumns . ' FROM ' . REGISTRATION . ' WHERE registrationApproved=1 AND SeasonId=' . $SEASON . ' ORDER BY fName,lName';
$approvedResult = mysql_query($approvedRegistrations, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($approvedResult) {
if (mysql_num_rows($approvedResult) > 0) {
$countApproved = 0;
$smarty->assign('approvedRegistrations', "TRUE");
$smarty->assign('registrationId', array());
$smarty->assign('playerName', array());
$smarty->assign('fname', array());
$smarty->assign('lname', array());
$smarty->assign('address', array());
$smarty->assign('email', array());
$smarty->assign('homephone', array());
$smarty->assign('workphone', array());
$smarty->assign('cellphone', array());
while ($registrant = mysql_fetch_array($approvedResult, MYSQL_ASSOC)) {
$countApproved++;
$registrationId = $registrant['registrationId'];
if (isset($registrant['playerId']) && $registrant['playerId'] > 0) {
$playername = get_player_name($registrant['playerId']);
} else {
$playername = 'None Assigned';
}
$fname = $registrant['fName'];
$lname = $registrant['lName'];
$address = $registrant['addressOne'] . ' ' . $registrant['addressTwo'] . '<br />' . $registrant['city'] . ', ' . $registrant['state'] . ' ' . $registrant['postalCode'];
if (strlen($registrant['eMail']) > 0) {
$email = $registrant['eMail'];
} else {
$email = " ";
}
if (strlen($registrant['homePhone']) > 0) {
$homephone = $registrant['homePhone'];
} else {
$homephone = " ";
}
if (strlen($registrant['workPhone']) > 0) {
$workphone = $registrant['workPhone'];
} else {
$workphone = " ";
}
if (strlen($registrant['cellPhone']) > 0) {
$cellphone = $registrant['cellPhone'];
} else {
$cellphone = " ";
}
$smarty->append('registrationId', $registrationId);
$smarty->append('playerName', $playername);
$smarty->append('fname', $fname);
$smarty->append('lname', $lname);
$smarty->append('address', $address);
$smarty->append('email', $email);
$smarty->append('homephone', $homephone);
$smarty->append('workphone', $workphone);
$smarty->append('cellphone', $cellphone);
}
$smarty->assign('countApproved', $countApproved);
}
}
$unapprovedRegistrations = 'SELECT ' . $selectColumns . ' FROM ' . REGISTRATION . ' WHERE registrationApproved=0 AND SeasonId=' . $SEASON . ' ORDER BY fName,lName';
$unapprovedResult = mysql_query($unapprovedRegistrations, $Link) or die("sp_clubs (Line " . __LINE__ . "): " . mysql_errno() . ": " . mysql_error());
if ($unapprovedResult) {
if (mysql_num_rows($unapprovedResult) > 0) {
$countUnapproved = 0;
$smarty->assign('unapprovedRegistrations', "TRUE");
$smarty->assign('naregistrationId', array());
$smarty->assign('nafname', array());
$smarty->assign('nalname', array());
$smarty->assign('naaddress', array());
$smarty->assign('naemail', array());
$smarty->assign('nahomephone', array());
$smarty->assign('naworkphone', array());
$smarty->assign('nacellphone', array());
while ($registrant = mysql_fetch_array($unapprovedResult, MYSQL_ASSOC)) {
$countUnapproved++;
$registrationId = $registrant['registrationId'];
$fname = $registrant['fName'];
$lname = $registrant['lName'];
$address = $registrant['addressOne'] . ' ' . $registrant['addressTwo'] . '<br />' . $registrant['city'] . ', ' . $registrant['state'] . ' ' . $registrant['postalCode'];
if (strlen($registrant['eMail']) > 0) {
$email = $registrant['eMail'];
} else {
$email = " ";
}
if (strlen($registrant['homePhone']) > 0) {
$homephone = $registrant['homePhone'];
} else {
$homephone = " ";
}
if (strlen($registrant['workPhone']) > 0) {
$workphone = $registrant['workPhone'];
} else {
$workphone = " ";
}
if (strlen($registrant['cellPhone']) > 0) {
$cellphone = $registrant['cellPhone'];
} else {
$cellphone = " ";
}
$smarty->append('naregistrationId', $registrationId);
$smarty->append('nafname', $fname);
$smarty->append('nalname', $lname);
$smarty->append('naaddress', $address);
$smarty->append('naemail', $email);
$smarty->append('nahomephone', $homephone);
$smarty->append('naworkphone', $workphone);
$smarty->append('nacellphone', $cellphone);
}
$smarty->assign('countUnapproved', $countUnapproved);
}
}
}
