header("Location:index.php");
}
$func = new COMMONFUNC();
$db = new DB();
$flag = 0;
$query_Athlete = " Select * from " . TBL_ATHELETE_REGISTER . " where fldUsername ='******'FRONTEND_USER'] . "'";
$db->query($query_Athlete);
$db->next_record();
$athemail = $db->f('fldEmail');
$coach_id = $db->f('fldApproveCoachId');
$userid = $db->f('fldId');
$fldSport = $db->f('fldSport');
$fldFirstname = $db->f('fldFirstname');
$fldLastname = $db->f('fldLastname');
if ($_GET['fldEventId']) {
$programe_event = $func->selectTableOrder(TBL_EVENT, "fldEventId,fldEventName", "fldEventId", "where fldEventId=" . $_GET['fldEventId']);
}
$AthleteName = $fldFirstname . " " . $fldLastname;
$EventName = $programe_event[0]['fldEventName'];
if ($_POST['isSubmit'] == 'save') {
if ($flag == 0) {
for ($cataStatcount = 0; $cataStatcount < count($_POST['category']); $cataStatcount++) {
$strDataArr = array('fldPrograme' => $programe_event[0]['fldEventId'], 'fldCategoryId' => $func->input_fun($_POST['categoryId'][$cataStatcount]), 'fldValue' => $func->input_fun($_POST['category'][$cataStatcount]), 'fldLabelname' => $func->input_fun($_POST['labelname'][$cataStatcount]), 'fldStatus' => 0, 'fldCoachId' => $coach_id, 'fldSportid' => $fldSport, 'fldAtheleteId' => $userid, 'fldAddDate' => date("y-m-d"));
$db->insertRec(TBL_ATHELETE_STAT, $strDataArr);
}
$msg = "Hello Coach, <br /><br />\r\r\n You are receiving this email because an Athlete on your team has posted Game Stats for a particular game/event. Please login to your Account at www.collegeprospectnetwork.com, and review these Stats @ 'My Account > Athlete Stats Approval' section.\r <br /><br /> \r <b>Athlete:</b> " . $AthleteName . "<br /> \r <b>Game / Event:</b> " . $EventName . "<br /> \r <br /> \r\r\n Thank you in advance Coach,<br />\r\r\n College Prospect Network<br />\r\r\n www.CollegeProspectNetwork.com";
$query_Coach_id = " Select fldEmail from " . TBL_HS_AAU_COACH . " where fldId ='" . $coach_id . "'";
$db->query($query_Coach_id);
$db->next_record();
$coachEmail = $db->f('fldEmail');
$toStre1 = $coachEmail;
<title>Messaging</title> <META NAME="Keywords" CONTENT="My Account"> <META NAME="Description" CONTENT="My Account"> <link href="css/style.css" rel="stylesheet" type="text/css" /> </head> <body style="background:none;"> <!--middle panel starts from here --> <!--content panel starts from here --> <div class="container"> <div class="innerWraper"> <div class="middle-bg"> <div> <div> <h1>Add Note / Comment</h1> <div class="registerPage" > <?php
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Sport<font color="red"> *</font></td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<?php
echo $strcombo = '<select name="fldNeedType" style="width:200px">';
echo $strcombo = '<option value = "">Select Type</option>';
$categorylist = $func->selectTableOrder(tbl_sports, "fldId,fldSportsname", "fldId");
for ($i = 0; $i < count($categorylist); $i++) {
echo '<option value ="' . $categorylist[$i]['fldId'] . '" >' . $categorylist[$i]['fldSportsname'] . '</option>';
}
echo $strcombo = '</select>';
?>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
$fldUserName = $func->output_fun($db->f('fldUserName'));
$fldAddDate = $func->output_fun($db->f('fldAddDate'));
$fldSubscribe = $func->output_fun($db->f('fldSubscribe'));
$fldPosition = $func->output_fun($db->f('fldPosition'));
$fldEmail = $func->output_fun($db->f('fldEmail'));
$fldExpiredate = $func->output_fun($db->f('fldExpiredate'));
$fldFirstName = $func->output_fun($db->f('fldFirstName'));
$fldLastName = $func->output_fun($db->f('fldLastName'));
$fldAlternativeEmail = $func->output_fun($db->f('fldAlternativeEmail'));
$fldPhone = $func->output_fun($db->f('fldPhone'));
$fldAlternativePhone = $func->output_fun($db->f('fldAlternativePhone'));
$fldDescriPation = $func->output_fun($db->f('fldDescriPation'));
$fldStatus = $func->output_fun($db->f('fldStatus'));
$fldSubscribe = $db->f('fldSubscribe');
if ($fldCollegeName != 'other') {
$college_address_before = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName,fldAddress,fldCity,fldState,fldZipCode,fldDivison", "fldId", "where fldStatus =1 and fldId=" . $fldCollegeName);
$fldCity = $college_address_before[0]['fldCity'];
$fldState = $college_address_before[0]['fldState'];
$fldAddress = $college_address_before[0]['fldAddress'];
$fldZipCode = $college_address_before[0]['fldZipCode'];
$fldDivison = $college_address_before[0]['fldDivison'];
}
$selquery = "select fldSportsname from " . TBL_SPORTS . " where fldId='" . $fldSport . "'";
$objQuery = mysql_query($selquery);
$numquery = mysql_num_rows($objQuery);
$resquery = mysql_fetch_array($objQuery);
$SportsName = $resquery['fldSportsname'];
?>
<table width="100%" cellpadding="3" cellspacing="5">
<tr>
<?php
include_once "inc/common_functions.php";
//for common function
include_once "inc/page.inc.php";
require_once 'zipcode.class.php';
session_start();
$z = new zipcode_class();
$func = new COMMONFUNC();
$db = new DB();
$flag = 0;
$college_info = $func->selectTableOrder(TBL_COLLEGE, 'fldId,fldAddress,fldCity,fldState,fldZipCode', "fldId", "where fldId=" . $_GET['fldid']);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Google Maps For view Location</title>
<script src="//maps.google.com/maps?file=api&v=2.x&key=<?php
echo MAPS_APIKEY;
?>
" type="text/javascript"></script>
<script type="text/javascript">
var map = null;
var geocoder = null;
function initialize() {
if (GBrowserIsCompatible()) {
map = new GMap2(document.getElementById("map_canvas"));
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Sport<font color="red">*</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<?php
echo '<select name="fldParentId" style="width:220px"><option value="">Please Select</option>';
$sport_list = $func->selectTableOrder(TBL_SPORTS, "fldId,fldSportsname", "fldSportsname", "where fldStatus='ACTIVE'");
/*$sport_list=$func->selectTableOrder(TBL_SPORTS,"fldId,fldSportsname","fldId");*/
for ($i = 0; $i < count($sport_list); $i++) {
if ($fldParentId == $sport_list[$i]['fldId']) {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" selected = "selected" >' . $sport_list[$i]['fldSportsname'] . '</option>';
} else {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" >' . $sport_list[$i]['fldSportsname'] . '</option>';
}
}
echo $strcombo = '</select>';
?>
</td>
</tr>
<tr height="20">
<td align="center" valign="top" colspan="3" class="normalwhite_14">
} else {
$query = "Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where fldStatus=1 " . $srchCond;
}
if ($_REQUEST['sportid'] != '') {
$srchCond1 = "AND fldParentId = " . $_REQUEST['sportid'];
$query = "Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where 1=1 " . $srchCond1 . " ORDER BY fldName";
}
$db1->query($query);
$db1->next_record();
$totalPages = $db1->num_rows();
if ($totalPages > 0) {
?>
<tr> <td align="left" style="padding-left:7px;"colspan="10"><input type="checkbox" id="check_all" name="check_all" value="" onclick="javascript:checkAll();"> <b>Check All</b> <input type="button" name="delete" value="Delete Selected" onclick="return submitDeleteAll();"><?php
echo '<select name="fldParentId" style="width:220px" onChange="javascript:return formsubmit(this.value);" ><option value="">Select Sport</option>';
$sport_list = $func->selectTableOrder(TBL_SPORTS, "fldId,fldSportsname", "fldId");
for ($i = 0; $i < count($sport_list); $i++) {
if ($_REQUEST['sportid'] == $sport_list[$i]['fldId']) {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" selected = "selected" >' . $sport_list[$i]['fldSportsname'] . '</option>';
} else {
echo '<option value ="' . $sport_list[$i]['fldId'] . '" >' . $sport_list[$i]['fldSportsname'] . '</option>';
}
}
echo $strcombo = '</select>';
?>
<a href="ADAthleteCatagoryAdd.php">Add New</a>
</td>
</select></td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>-->
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Sport <font color="red">*</font></td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<select name="fldSport" id="fldSport" style="width: 220px;font-size:12px;"
>
<?php
$sportlist = $func->selectTableOrder(TBL_SPORTS, "fldId,fldSportsname", "fldSportsname", "where fldStatus='ACTIVE'");
?>
<option value = "select">Select Sport</option><?php
for ($i = 0; $i < count($sportlist); $i++) {
?>
<option value ="<?php
echo $sportlist[$i]['fldId'];
?>
" <?php
if (isset($_REQUEST['sportid']) and $_REQUEST['sportid'] == $sportlist[$i]['fldId']) {
?>
selected <?php
}
?>
><?php
//for common function
include_once "inc/page.inc.php";
include_once "inc/config.inc.php";
if ($_SESSION['FRONTEND_USER'] == "") {
header("Location:login.php");
}
//for paging
$func = new COMMONFUNC();
$db = new DB();
//$flag=1;
if ($_POST['isSubmit'] == 'save') {
if ($_REQUEST['collegeid'] == '') {
$error_msg[] = " Please Select College";
}
$collegeid = $func->input_fun($_POST['collegeid']);
$ath_name = $func->selectTableOrder(TBL_ATHELETE_REGISTER, "fldFirstname,fldLastname", "fldId", "where fldId='" . $_SESSION['Athlete_id'] . "' and fldStatus ='ACTIVE'");
$name = ucfirst($ath_name[0]['fldFirstname']) . ' ' . ucfirst($ath_name[0]['fldLastname']);
$strDataArr = array('collegeid' => $collegeid, 'athleteid' => $_SESSION['Athlete_id'], 'athname' => $name, 'status' => $func->input_fun($_POST['status']));
$whereClause = "athleteid='" . $_SESSION['Athlete_id'] . "' and collegeid = '" . $collegeid . "'";
if ($db->MatchingRec(TBL_ADDTONETWORK_REQUEST, $whereClause) > 0) {
$error_msg[] = 'You Have Already Send the Request!';
}
if (count($error_msg) == 0) {
$db->insertRec(TBL_ADDTONETWORK_REQUEST, $strDataArr);
$msg = "Your Request has been sent! Wait for Approval";
header("Location: myaccount.php?msg={$msg}");
}
}
?>
</tr>
<tr>
<td height="35" colspan="3" align="right" class="normalblack_12"><FONT color="Red">Fields marked with * are mandatory </FONT></td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">Game / Event<font color="red"> *</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12">
<?php
$eventName = $func->selectTableOrder(TBL_EVENT, "fldEventId,fldEventName", "fldEventId");
?>
<select name="fldPrograme" style="width: 220px;">
<option value="select">Select Programe</option>
<?php
for ($i = 0; $i < count($eventName); $i++) {
?>
<option value="<?php
echo $eventName[$i]['fldEventId'];
?>
" <?php
if ($eventName[$i]['fldEventId'] == $fldPrograme) {
?>
selected<?php
</td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=4 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">College Name<font color="red"> *</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12"> <?php
echo $strcombo = '<select name="fldCollegename" style="width:200px;">';
echo $strcombo = '<option value = "select">Select College</option>';
$collegelist = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName", "fldId", "where fldStatus =1");
for ($i = 0; $i < count($collegelist); $i++) {
echo '<option value ="' . $collegelist[$i]['fldId'] . '" >' . $collegelist[$i]['fldName'] . '</option>';
}
echo $strcombo = '</select>';
?>
</td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=3 align="center">
</td>
</tr>
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">First Name<font color="red"> *</font> </td>
if (!$db->query($query)) {
die(mysql_error());
$success = FALSE;
}
}
// TODO: Should the sport list be restricted to the sports that the coach has an active subscription to?
$query = 'SELECT tbl_sports.fldId, tbl_sports.fldSportsname ' . 'FROM tbl_sports INNER JOIN tbl_college_subscription ' . 'ON tbl_sports.fldId=tbl_college_subscription.fldSport ' . 'WHERE tbl_college_subscription.fldActive=1 ' . 'AND tbl_college_subscription.fldCoach=' . $coachId;
if (!$db->query($query)) {
die(mysql_error());
}
$fldSportList = array();
while ($db->next_record()) {
$fldSportList[$db->f('fldId')] = $db->f('fldSportsname');
}
$arrDistances = array('0', '10', '25', '50', '100', 'Any');
$fldClassList = $classlist = $func->selectTableOrder(TBL_CLASS, "fldId,fldClass", "fldId");
if ($_REQUEST['action'] == 'edit') {
$needId = $_REQUEST['id'];
$query = 'SELECT * FROM ' . TBL_COLLEGE_NEEDS . ' WHERE fldId=' . $needId;
if (!$db->query($query)) {
die(mysql_error());
}
$db->next_record();
$fldSport = $db->f('fldSportId');
$fldGradClass = $db->f('fldGradClass');
$fldMinHeight = intval($db->f('fldMinHeight') / 12) . '-' . intval($db->f('fldMinHeight') % 12);
$fldMaxHeight = intval($db->f('fldMaxHeight') / 12) . '-' . intval($db->f('fldMaxHeight') % 12);
switch ($db->f('fldMinWeight')) {
case 0:
$fldMinWeight = 'under140';
break;
public static function getSchoolList()
{
$func = new COMMONFUNC();
$schoolList = array();
$groups = $func->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'");
for ($i = 0; $i < count($groups); $i++) {
$groupLabel = '========' . $groups[$i]['fldState'] . '========';
$schoolList[$groupLabel] = array();
//School Loop (in state)
$where = "WHERE fldState='" . $groups[$i]['fldState'] . "'";
$schools = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $where);
for ($j = 0; $j < count($schools); $j++) {
$key = $schools[$j]['fldId'];
$value = $schools[$j]['fldSchoolname'];
$schoolList[$groupLabel][$key] = $value;
}
}
return $schoolList;
}
if(error_msg != '') {
alert(error_msg);
return false;
} else {
return true;
}
}
</script>
</head>
<body>
<!--header link starts from here -->
<?php
include 'header.php';
?>
<!--Header ends from here -->
<!--middle panel starts from here -->
<!--content panel starts from here -->
<div class="container">
<div class="innerWraper">
<div class="middle-bg">
<div class="cantener">
<div class="register-main">
<h1>Send Messages</h1>
<?php
case 'coach':
//HS Coach ID
$UserID = $_SESSION['Coach_id'];
break;
case 'college':
//College Coach ID
$UserID = $_SESSION['College_Coach_id'];
//Check Subscription Status
$query = " Select fldSubscribe from " . TBL_COLLEGE_COACH_REGISTER . " where fldId ='" . $UserID . "' ";
$db->query($query);
$db->next_record();
$_SESSION['fldSubscribe'] = $db->f('fldSubscribe');
break;
}
#### PENDING NETWORK REQUESTS ####
$Pending_request = $func->selectTableOrder(TBL_NETWORK, "fldId", "fldId", "where fldReceiverid='" . $UserID . "' and fldReceiverType='" . $UserType . "' and fldStatus='Pending'");
if (count($Pending_request) > 0) {
$NetworkReq_Pending = "(<font style='color:red;'>" . count($Pending_request) . " Pending</font>)";
}
#### PENDING NETWORK REQUESTS ####
#### INBOX ####
$inboxinfo = $func->selectTableOrder(TBL_MAIL, "mail_id", "mail_id", "where UserTo='" . $_SESSION['FRONTEND_USER'] . "' and status ='unread'");
$Countinboxinfo = count($inboxinfo);
if ($Countinboxinfo > 0) {
$Countinboxinfo = "(<font style='color:red;'>" . $Countinboxinfo . " Unread</font>)";
} else {
$Countinboxinfo = "";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<TD class="heading"> <TABLE cellSpacing=0 cellPadding=1 width="95%" align=center border=0> <TR> <TD> <TABLE cellSpacing=0 cellPadding=1 width=780 border=0> <TR> <TD bgColor=#ffffff> <TABLE cellSpacing=0 cellPadding=0 width=900 border=0> <TR> <TD vAlign=top width=20%> <?php include "include/ADmenu.php"; ?> </TD> <TD valign=top width=1%> </TD>
<?php
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
include_once "../inc/config.inc.php";
//for paging
$func = new COMMONFUNC();
$db = new DB();
$q = $_GET['q'];
if ($q == "other") {
$other_info = $func->selectTableOrder(TBL_OTHER, "fldId,fldName", "fldId", " where fldUserId ='" . $_GET['fldUserName'] . "'");
$college_address_other_info = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName,fldAddress,fldCity,fldState,fldZipCode", "fldId", "where fldStatus =0 and fldId='" . $other_info[0]['fldId'] . "'");
?>
<table align="center" border="0" align="center" width="60%">
<tr height="20">
<td valign="top" align="right" class="normalblack_12" width="30%">College Name<font color="red"> *</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12" colspan=2>
<input type="text" name="txtfldName" id="txtfldName" style="width:200px;" value="<?php
echo $other_info[0]['fldName'];
>Prince Edward Island</option>
<option value='Quebec' <?php
if ($college_address_info[0]['fldState'] == 'Quebec') {
echo 'selected';
}
?>
>Quebec</option>
<option value='Saskatchewan' <?php
if ($college_address_info[0]['fldState'] == 'Saskatchewan') {
echo 'selected';
}
?>
>Saskatchewan</option>
<option value='Yukon Territory' <?php
if ($college_address_info[0]['fldState'] == 'Yukon Territory') {
echo 'selected';
}
?>
>Yukon Territory</option>
</optgroup>
</select><font color="#0000ff"> *</font>
</span>
<label>Zip Code:</label>
<span>
<input type="text" name="fldZipcode" id="fldZipcode" value="<?php
echo $college_address_other_info[0]['fldZipcode'];
?>
" >
<font color="#0000ff"> *</font></span>
</div>
//for common function
include_once "inc/page.inc.php";
session_start();
if ($_SESSION['FRONTEND_USER'] == "") {
header("Location:index.php");
}
//for paging
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$page = new Page();
//Create an instance of class Pate
$lnb = "2";
$error_msg = '';
$srchCond = '';
if ($_SESSION['mode'] == "athlete") {
$athlete_info = $func->selectTableOrder(TBL_ATHELETE_REGISTER, "fldId,fldUsername,fldSchool,fldSport", "fldId", " where fldUsername='******'FRONTEND_USER'] . "'");
}
if (!$searchname) {
$searchname = $_REQUEST['searchname'];
}
$searchname = addslashes($searchname);
if (strlen($searchname) > 0) {
$queryString = "searchname={$searchname}";
$srchCond = "AND fldEventName like '%" . $searchname . "%'";
}
if ($_REQUEST['mode'] == "del") {
$fldEventId = $_REQUEST['fldEventId'];
$delete_query_details = "delete from " . TBL_EVENT . " where fldEventId=" . $fldEventId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Event successfully deleted.";
<?php
include_once "inc/common_functions.php";
//for common function
include_once "inc/page.inc.php";
include_once "inc/config.inc.php";
$func = new COMMONFUNC();
$db = new DB();
$q = $_GET["q"];
if ($q == "other") {
$college_address_other_info = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName,fldAddress,fldCity,fldState,fldZipCode", "fldId", "where fldStatus =0 and fldName='" . $txtfldName . "'");
?>
<div class="yellow">
<label>College Name:</label>
<span>
<input type="text" name="txtfldName" id="txtfldName" class="yellow"><?php
echo $txtfldName;
?>
<font color="#0000ff"> *</font></span>
<label>Address:</label>
<span> <textarea rows=14 cols=69 name=fldAddress><?php
echo $college_address_other_info[0]['fldAddress'];
?>
</textarea><font color="#0000ff"> *</font></span>
<br/>
<br/>
<label>City:</label>
<span>
<input type="text" name="fldCity" id="fldCity" value="<?php
echo $college_address_other_info[0]['fldCity'];
?>
var error_msg = "";
var blnResult = true;
if(trimString(document.frmUsers.fldUsername.value) == "") {
error_msg += "Please Enter UserName! \n";
} else {
if(hasSpecialCharaters(document.frmUsers.fldUsername.value)) {
error_msg += " Please Enter valid UserName! \n";
}
}
if(trimString(document.frmUsers.fldEmail.value) == "") {
error_msg += "Please Enter Email! \n";
} else {
if(!isValid(document.frmUsers.fldEmail.value)) {
error_msg += " Please Enter valid Email! \n";
}
}
if(trimString(document.frmUsers.fldFirstname.value) == "") {
error_msg += "Please Enter First Name! \n";
} else {
if(hasSpecialCharaters(document.frmUsers.fldFirstname.value)) {
error_msg += " Please Enter First Name! \n";
}
}
if(trimString(document.frmUsers.fldSchool.value) == "0") {
error_msg += "Please Select HS/AAU Team! \n";
}
if(trimString(document.frmUsers.fldSport.value) == "select") {
error_msg += "Please Select Sport! \n";
}
if(error_msg != '') {
alert(error_msg);
echo "<input type='hidden' name='isSubmit' value='save'>";
echo "<p><label> </label><span><button type=submit onsubmit='' class='btn'>Send Message</button></span></p>";
echo "</form>";
} else {
if ($_REQUEST['value'] == 'coach') {
##TO HS COACH##
$query1 = "SELECT fldSport from " . TBL_ATHELETE_REGISTER . " WHERE fldUsername='******'";
$db1->query($query1);
$db1->next_record();
$fldSport = $func->output_fun($db1->f('fldSport'));
if ($_SESSION['mode'] == 'coach' || $_SESSION['mode'] == 'college') {
echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
echo "<p><label>To:</label><span>";
echo $strcombo = '<select name="to" style="width:276px">';
echo $strcombo = '<option value="">----- Please Select -----</option>';
$coachlist = $func->selectTableOrder(TBL_HS_AAU_COACH, "fldId,fldName,fldLastName,fldUsername", "fldLastName");
} else {
echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
echo "<p><label>To:</label><span>";
echo $strcombo = '<select name="to" style="width:276px">';
echo $strcombo = '<option value = "">----- Please Select -----</option>';
$coachlist = $func->selectTableOrdergroupby("tbl_hs_aau_coach_sportposition cs, tbl_hs_aau_coach ac", "fldId,fldName,fldLastName,fldUsername", "ac.fldLastName", "where ac.fldId = cs.fldCoachNameId and cs.fldSportId = " . $fldSport);
}
for ($i = 0; $i < count($coachlist); $i++) {
if (!in_array($coachlist[$i]['fldId'], $coachid)) {
if ($_REQUEST['to'] == $coachlist[$i]['fldUsername']) {
echo '<option value ="' . $coachlist[$i]['fldUsername'] . '" selected="selected" >' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>';
} else {
echo '<option value ="' . $coachlist[$i]['fldUsername'] . '">' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>';
}
}
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>College Prospect Network - Manage Game Tape</title>
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script language="Javascript" src="javascript/functions.js"></script>
<script type="text/javascript" src="/jwplayer/jwplayer.js"></script>
<script language="JavaScript" type="text/JavaScript">
function deleteRecord(fldId, page, fldUserName) {
if(confirm("Sure you want to delete this Game Tape? This cannot be undone")) {
document.frmCatagory.action = "?mode=del&fldId=" + fldId;
document.frmCatagory.submit();
}
}
function submitDeleteAll() {
var countChecked = 0;
var checkBox = document.getElementsByName('check_delete[]');
var totalCheckboxes = document.getElementsByName('check_delete[]').length;
if(totalCheckboxes != 0) {
for(var i = 0; i < totalCheckboxes; i++) {
if(checkBox[i].checked == true) {
countChecked = countChecked + 1;
}
}
}
if(countChecked != 0) {
if(confirm("Sure you want to delete selected Game Tape? This cannot be undone")) {
document.frmCatagory.action = "?mode=delAll";
document.frmCatagory.submit();
return true;
}
" >
</span><font color="#0000ff"> *</font> </p>
<p>
<label>Email Address (for Receipt):</label>
<span><input type="text" name="fldEmail" id="fldEmail" value="<?php
echo $fldEmail;
?>
" ></span>
<font color="#0000ff"> *</font> </p>
<p>
<label>Graduating Class:</label>
<span>
<select name="fldClass" id="fldClass">
<option value="select" class="selectgrey" >Select Class</option>
<?php
$classlist = $func->selectTableOrder(TBL_CLASS, "fldId,fldClass", "fldClass");
for ($i = 0; $i < count($classlist); $i++) {
?>
<option value ="<?php
echo $classlist[$i]['fldClass'];
?>
"<?php
if ($classlist[$i]['fldClass'] == $fldClass) {
?>
selected="selected" <?php
}
?>
><?php
echo $classlist[$i]['fldClass'];
?>
}
else{
if(hasSpecialCharaters(document.frmUsers.fldSport.value)){
error_msg += "Please Select the Sport! \n";
}
}
if(trimString(document.frmUsers.fldCoachname.value) == ""){
error_msg += "Please Select the coachname! \n";
}
else{
if(hasSpecialCharaters(document.frmUsers.fldCoachname.value)){
error_msg += "Please Select the coachname! \n";
}
$db->next_record();
$fldUserName = $db->f('fldUserName');
$fldCollegename = $db->f('fldCollegename');
$fldCoachname = $db->f('fldCoachname');
$fldPosition = $db->f('fldPosition');
$fldNeedType = $db->f('fldNeedType');
$fldEmail = $db->f('fldEmail');
$fldFirstName = $db->f('fldFirstName');
$fldLastName = $db->f('fldLastName');
$fldAlternativeEmail = $db->f('fldAlternativeEmail');
$fldPhone = $db->f('fldPhone');
$fldAlternativePhone = $db->f('fldAlternativePhone');
$fldEnrollmentNumber = $db->f('fldEnrollmentNumber');
$fldDivison = $db->f('fldDivison');
if ($fldCollegename != 'other') {
$college_address_before = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName,fldAddress,fldCity,fldState,fldZipCode", "fldId", "where fldStatus =1 and fldId=" . $fldCollegename);
$fldCity = $college_address_before[0]['fldCity'];
$fldState = $college_address_before[0]['fldState'];
$fldAddress = $college_address_before[0]['fldAddress'];
$fldZipCode = $college_address_before[0]['fldZipCode'];
}
}
} else {
$fldUserName = "";
$fldCollegename = "";
$fldCity = "";
$fldState = "";
$fldPosition = "";
$fldNeedType = "";
$fldEmail = "";
$fldFirstName = "";
$flag = 0;
/*
* gets coach information. This is used to pre-fill form fields
* and provide necessary data for the Authorize.net transaction
*/
$query = 'SELECT * FROM ' . TBL_COLLEGE_COACH_REGISTER . " WHERE fldUserName='******'";
$db->query($query);
$db->next_record();
$fldCoach = $db->f('fldId');
$fldCollegename = $db->f('fldCollegename');
$fldtransectionId = $db->f('fldtransectionId');
$fldCancelCount = $db->f('fldCancelCount');
$fldSubscribe = $db->f('fldSubscribe');
// gets all active subscriptions for the current user
// gets available subscription types for the form
$table = TBL_COLLEGE_SUBSCRIPTION;
$fields = 'fldId,fldType,fldSport';
$where = 'WHERE fldCoach=' . $fldCoach . ' AND fldActive=1';
$subsList = $func->selectTableOrder($table, $fields, 'fldId', $where);
$subsCount = count($subsList);
// creates a human-readable version of the active subscriptions
$activeSubs = array();
for ($i = 0; $i < $subsCount; $i++) {
$key = $subsList[$i]['fldId'];
// gets the name of the subscription type
$query = 'SELECT fldName FROM ' . TBL_SUBSCRIPTION . ' WHERE fldId=' . $subsList[$i]['fldType'];
$db->query($query);
$db->next_record();
$typeName = $db->f('fldName');
// gets the name of the subscribed sport
$query = 'SELECT fldSportsname FROM ' . TBL_SPORTS . ' WHERE fldId=' . $subsList[$i]['fldSport'];
$ModeType = isset($_REQUEST["mode"]) ? $_REQUEST["mode"] : "";
switch ($ModeType) {
case 'athlete':
//AthleteID
$UserID = isset($_SESSION['Athlete_id']) ? $_SESSION['Athlete_id'] : "";
$fldSport = $func->GetValue("tbl_athelete_register", "fldSport", "fldId", $UserID);
break;
case 'coach':
//HS Coach ID
$UserID = isset($_SESSION['Coach_id']) ? $_SESSION['Coach_id'] : "";
$fldSport = $func->GetValue("tbl_hs_aau_coach", "fldSport", "fldId", $UserID);
break;
case 'college':
//College Coach ID
$UserID = isset($_SESSION['College_Coach_id']) ? $_SESSION['College_Coach_id'] : "";
$sport_info = $func->selectTableOrder(TBL_COLLEGE_COACH_REGISTER, "fldId,fldNeedType", "fldId", "where fldUserName='******'");
$fldSport = $sport_info[0]['fldNeedType'];
break;
}
//echo $fldSport;
//mdify 4-2-13
//if (empty($fldSport)) {
//die(mysql_error());
// header('location:myaccount.php');
//}
//echo "abc ".__LINE__;
// query
$select = 'SELECT ' . TBL_COLLEGE . '.fldId, ' . TBL_COLLEGE . '.fldName, ' . TBL_COLLEGE_COACH_REGISTER . '.fldFirstName, ' . TBL_COLLEGE_COACH_REGISTER . '.fldLastName ' . 'FROM ' . TBL_COLLEGE . ' ' . 'INNER JOIN ' . TBL_COLLEGE_COACH_REGISTER . ' ' . 'ON ' . TBL_COLLEGE_COACH_REGISTER . '.fldCollegename=' . TBL_COLLEGE . '.fldId ';
$where = 'WHERE ' . TBL_COLLEGE_COACH_REGISTER . '.fldSport=' . $fldSport . ' ';
// gets the requested college ID if set
if (isset($_GET['Id']) && is_numeric($_GET['Id'])) {
<td height="35" colspan="3" align="right" class="normalblack_12"><FONT color="Red">Fields marked with * are mandatory </FONT></td>
</tr>
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=4 align="center">
<tr height="20">
<td valign="top" class="normalwhite_14" colspan=4 align="center">
</td>
<tr height="20" id="txtEvent">
<td valign="top" align="right" class="normalblack_12" width="30%">Special Event<font color="red">*</font> </td>
<td valign="top" align="center" class="normalblack_12" > : </td>
<td valign="top" align="left" class="normalblack_12" colspan=2>
<select name="Event_id" id="Event_id" style="width:220px;">
<option value="">Select Event</option>
<?php
$EventList = $func->selectTableOrder(TBL_SPECIAL_EVENT, "fldEventId,fldEventName", "fldEventId");
for ($i = 0; $i < count($EventList); $i++) {
?>
<option value ="<?php
echo $EventList[$i]['fldEventId'];
?>
"<?php
if ($EventList[$i]['fldEventId'] == $Event_id) {
?>
selected="selected" <?php
}
?>
><?php
echo $EventList[$i]['fldEventName'];
?>
</option>
include_once "inc/common_functions.php";
//for common function
include_once "inc/page.inc.php";
require_once 'zipcode.class.php';
session_start();
if ($_SESSION['mode'] == "" or $_SESSION['FRONTEND_USER'] == "") {
header("Location:index.php");
}
$func = new COMMONFUNC();
$z = new zipcode_class();
$page = new Page();
$db = new DB();
$flag = 0;
$sessionid = $_SESSION['College_Coach_id'];
$needType_info = $func->selectTableOrder(TBL_NEEDTYPE, "fldId,fldDivision,fldClass,fldHeight,fldWeight,fldSchool,fldCity,fldState,fldZipCode,fldDistance", "fldId", "where fldCollegeCoachId=" . $sessionid);
if ($_POST['isSubmit'] == 'save') {
$condition = "";
//For division
if ($_POST['fldDivision'] != '') {
if ($_POST['fldDivision'] == 'JUCO') {
$condition .= "fldDivision='NAIA' or fldDivision='DivisionIII' or fldDivision='DivisionII' or fldDivision = 'DivisionI' or fldDivision='" . $_POST['fldDivision'] . "' and ";
} else {
if ($_POST['fldDivision'] == 'NAIA') {
$condition .= "fldDivision='DivisionIII' or fldDivision='DivisionII' or fldDivision = 'DivisionI' or fldDivision='" . $_POST['fldDivision'] . "' and ";
} else {
if ($_POST['fldDivision'] == 'DivisionIII') {
$condition .= "fldDivision='DivisionII' or fldDivision = 'DivisionI' or fldDivision='" . $_POST['fldDivision'] . "' and ";
} else {
if ($_POST['fldDivision'] == 'DivisionII') {
$condition .= "fldDivision = 'DivisionI' or fldDivision='" . $_POST['fldDivision'] . "' and ";
