Exemple #1
0
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);
    }
}
Exemple #2
0
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>&shy;" . $name["last_name"] . "</span>";
?>
	</h1>
	</section>

	<?php 
include "sections/generic/games-view.php";
?>
	
	<?php 
include "sections/generic/money-view.php";
Exemple #5
0
        }
    } 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;
         }
Exemple #8
0
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);
    }
    //
}
Exemple #9
0
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);
    }
}
Exemple #10
0
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');
        }
    }
}
Exemple #11
0
    } 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 = "&nbsp;";
                }
                if (strlen($registrant['homePhone']) > 0) {
                    $homephone = $registrant['homePhone'];
                } else {
                    $homephone = "&nbsp;";
                }
                if (strlen($registrant['workPhone']) > 0) {
                    $workphone = $registrant['workPhone'];
                } else {
                    $workphone = "&nbsp;";
                }
                if (strlen($registrant['cellPhone']) > 0) {
                    $cellphone = $registrant['cellPhone'];
                } else {
                    $cellphone = "&nbsp;";
                }
                $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 = "&nbsp;";
                }
                if (strlen($registrant['homePhone']) > 0) {
                    $homephone = $registrant['homePhone'];
                } else {
                    $homephone = "&nbsp;";
                }
                if (strlen($registrant['workPhone']) > 0) {
                    $workphone = $registrant['workPhone'];
                } else {
                    $workphone = "&nbsp;";
                }
                if (strlen($registrant['cellPhone']) > 0) {
                    $cellphone = $registrant['cellPhone'];
                } else {
                    $cellphone = "&nbsp;";
                }
                $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);
        }
    }
}