$where_schoolreg_update = "fldId = " . $NewUserId;
$db->updateRec(TBL_ATHELETE_REGISTER, $strDataArr_schoolreg_update, $where_schoolreg_update);
################# Insert Custom College #################
}
// Send email to coach for Approval
if ($_POST['fldSchool'] != "other") {
//User Selected School
$schoolid = $func->input_fun($_POST['fldSchool']);
$sportid = $func->input_fun($_POST['fldSport']);
$emailarr = array();
$selquery = 'select first.fldId,first.fldEmail as fldEmail,first.fldName as name,first.fldLastName as lname,first.fldUsername as HSCoachUsername,first.fldPassword as HSCoachPassword from ' . TBL_HS_AAU_COACH . ' first,' . TBL_HS_AAU_COACH_SPORT_POSITION . ' second where second.fldCoachNameId = first.fldId and second.fldSportId =' . $sportid . ' and first.fldSchool =' . $schoolid;
$db->query($selquery);
$db->next_record();
if ($db->num_rows() > 0) {
for ($i = 0; $i < $db->num_rows(); $i++) {
$emailarr[] = $func->output_fun($db->f('fldEmail'));
$name = $func->output_fun($db->f('name'));
$lname = $func->output_fun($db->f('lname'));
#Login Info
$HSCoachUsername = $func->output_fun($db->f('HSCoachUsername'));
$HSCoachPassword = $func->output_fun($db->f('HSCoachPassword'));
$db->next_record();
}
foreach ($emailarr as $key => $emailvalue) {
######################## EMAIL to HS COACH - Athlete Approval Notification ########################
#Subject
$subjectStre = "College Prospect Network - Athlete Pending Approval";
#Intro
$bodyStre = "Hi Coach " . ucfirst($name) . ' ' . ucfirst($lname) . ",<br /><br />";
#Main Body
$bodyStre .= "You are receiving this email because " . ucfirst($aname) . " " . ucfirst($anamel) . " has applied to join <a href=http://www.CollegeProspectNetwork.com>www.CollegeProspectNetwork.com.</a> <br />";
$db->next_record();
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr><td align="center" class="normalblack_12" width="4%"> </td>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>Event Name</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Details</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db->num_rows(); $i++) {
$fldEventId = $func->output_fun($db->f('fldEventId'));
$fldEventName = $func->output_fun($db->f('fldEventName'));
$pageURL = "ADEventDetails.php?fldEventId={$fldEventId}";
$detailsWindowTitle = "AdminEventDetails";
echo '<tr><td align="center" class="normalblack_12"> ';
echo '<input type="checkbox" id="check_delete[]" name="check_delete[]" value="' . $fldEventId . '" onclick="return checkItSelf();">';
echo '<td align="left" class="normalblack_12"> ' . ($count + $_REQUEST['page'] * 10) . '</td>';
echo '
<td align="left" class="normalblack_12" >' . wordwrap($fldEventName, 17, "\n", true) . '</td>
';
echo '<td class="normalblack_12" align="center"><a href="ADEventEdit.php?mode=edit&fldEventId=' . $db->f('fldEventId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
echo ' <td class="normalblack_12" align="center"><a href="javascript:deleteRecord(\'' . $fldEventId . '\',' . $pageno . ')"><img src="images/b_drop.png" border="0" title="Delete"></a></td>';
echo '<td class="normalblack_12" align="center"><a href="javascript:ShowDetails(\'' . $pageURL . '\',\'' . $detailsWindowTitle . '\')">View</a></td>';
echo '</tr>';
echo $discount_amount = $func->output_fun($db->f('amount'));
$StartDate = $func->output_fun($db->f('StartDate'));
$EndDate = $func->output_fun($db->f('EndDate'));
$Status = $func->output_fun($db->f('Status'));
}
}
}*/
if ($_GET['mode'] == 'edit' and $id != "") {
#get the records
$query = " Select * from " . $tbl_transportation_discount . " where id =" . $id;
$db->query($query);
$db->next_record();
if ($db->num_rows() > 0) {
$db->query($query);
$db->next_record();
$id = $func->output_fun($db->f('id'));
$Event_id = $func->output_fun($db->f('Event_id'));
$Diparture_City = $func->output_fun($db->f('Diparture_City'));
$Departure_Time1 = $func->output_fun($db->f('Departure_Time'));
$Time = explode(":", $Departure_Time1);
$hour = $Time[0];
$option1 = explode(" ", $Time[1]);
$minute = $option1[0];
$option = $option1[1];
$Transportation_charge = $func->output_fun($db->f('Transportation_charge'));
$status = $func->output_fun($db->f('status'));
}
} else {
$id = "";
$Event_id = "";
$Diparture_City = "";
//Create an instance of class COMMONFUNC
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>College Details</TITLE>
<link href="css/styles.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<?php
$fldId = $_REQUEST['fldId'];
$query = " Select * from " . TBL_COLLEGE_COACH_REGISTER . " where fldId = '{$fldId}'";
$db->query($query);
$db->next_record();
$fldId = $func->output_fun($db->f('fldId'));
$fldCollegeName = $func->output_fun($db->f('fldCollegename'));
//$fldCity = $func->output_fun($db->f('fldCity'));
//$fldState = $func->output_fun($db->f('fldState'));
$fldSport = $func->output_fun($db->f('fldNeedType'));
$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'));
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>Coach Details</TITLE>
<link href="css/styles.css" rel="stylesheet" type="text/css">
</HEAD>
<BODY>
<?php
$fldId = $_REQUEST['fldId'];
$query = "Select * from " . TBL_SPORTS . " where fldId = '{$fldId}' ";
$db->query($query);
$db->next_record();
$fldId = $db->f('fldId');
$fldSportsname = $func->output_fun($db->f('fldSportsname'));
$fldDescription = $func->output_fun($db->f('fldDescription'));
$fldStatus = $func->output_fun($db->f('fldStatus'));
?>
<table width="100%" cellpadding="3" cellspacing="5">
<tr>
<td width="100%" align="center">
<table width="95%" cellpadding="0" cellspacing="3">
<tr>
<td width="100%" class="SearchHead"><b>Sports Details</b></td>
</tr>
<tr>
<td width="100%" class="GeneralFont"> </td>
</tr>
<tr>
$db->query($query);
$db->next_record();
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr><td align="center" class="normalblack_12" width="4%"> </td>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>Member Title</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db->num_rows(); $i++) {
$fldPageId = $func->output_fun($db->f('fldPageId'));
$fldPageTitle = $func->output_fun($db->f('fldPageTitle'));
$pageURL = "ADPageDetails.php?fldPageId={$fldPageId}";
$detailsWindowTitle = "AdminPageDetails";
echo '<tr><td align="center" class="normalblack_12"> ';
echo '<input type="checkbox" id="check_delete[]" name="check_delete[]" value="' . $fldPageId . '" onclick="return checkItSelf();">';
echo '<td align="left" class="normalblack_12"> ' . ($count + $_REQUEST['page'] * 10) . '</td>';
echo '
<td align="left" class="normalblack_12" >' . wordwrap($fldPageTitle, 17, "\n", true) . '</td>
';
echo '<td class="normalblack_12" align="center"><a href="ADPageEdit.php?mode=edit&fldPageId=' . $db->f('fldPageId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
echo ' <td class="normalblack_12" align="center"><a href="javascript:deleteRecord(\'' . $fldPageId . '\',' . $pageno . ')"><img src="images/b_drop.png" border="0" title="Delete"></a></td>';
echo '</tr>';
$db->next_record();
$db->query($query);
$db->next_record();
if ($db->num_rows() > 0) {
$db->query($query);
$db->next_record();
$fldUsername = $db->f('fldUsername');
$fldEmail = $db->f('fldEmail');
$fldFirstname = $db->f('fldFirstname');
$fldLastname = $db->f('fldLastname');
$fldClass = $db->f('fldClass');
$fldHeight = $db->f('fldHeight');
$fldWeight = $db->f('fldWeight');
$fldDescription = $db->f('fldDescription');
$fldSchool = $db->f('fldSchool');
$fldSport = $db->f('fldSport');
$fldPrimaryPosition = $func->output_fun($db->f('fldPrimaryPosition'));
$fldSecondaryPosition = $func->output_fun($db->f('fldSecondaryPosition'));
$fldVertical = $func->output_fun($db->f('fldVertical'));
$fld40_yardDash = $func->output_fun($db->f('fld40_yardDash'));
$fldShuttleRun = $func->output_fun($db->f('fldShuttleRun'));
$fldBenchPressMax = $func->output_fun($db->f('fldBenchPressMax'));
$fldSquatMax = $func->output_fun($db->f('fldSquatMax'));
$fldGPA = $func->output_fun($db->f('fldGPA'));
$fldSATScore = $func->output_fun($db->f('fldSATScore'));
$fldACTScore = $func->output_fun($db->f('fldACTScore'));
$fldClassRank = $func->output_fun($db->f('fldClassRank'));
$fldClearinghouseEligible = $func->output_fun($db->f('fldClearinghouseEligible'));
$fldIntendedMajor = $func->output_fun($db->f('fldIntendedMajor'));
$fldStatus = $db->f('fldStatus');
}
} else {
if ($_SESSION['mode'] == "" or $_SESSION['FRONTEND_USER'] == "") {
header("Location:index.php");
}
//for paging
$func = new COMMONFUNC();
$db = new DB();
$flag = 0;
$error_msg = '';
$fldUsername = $_SESSION['FRONTEND_USER'];
$query = " Select * from " . TBL_ATHELETE_REGISTER . " where fldUsername = '******' ";
$db->query($query);
$db->next_record();
$Status = $db->f('fldStatus');
$image_name = $db->f('fldImage');
$fldAthleteid = $db->f('fldId');
$fldFirstname = $func->output_fun($db->f('fldFirstname'));
$fldLastname = $func->output_fun($db->f('fldLastname'));
$fldClass = $func->output_fun($db->f('fldClass'));
$fldHeight = $func->output_fun($db->f('fldHeight'));
$fldWeight = $func->output_fun($db->f('fldWeight'));
$fldDescription = $func->output_fun($db->f('fldDescription'));
$fldDescription = str_replace("<br>", "\n", $fldDescription);
$fldEmail = $func->output_fun($db->f('fldEmail'));
$fldUsername = $func->output_fun($db->f('fldUsername'));
$fldSchool = $func->output_fun($db->f('fldSchool'));
$fldSport = $func->output_fun($db->f('fldSport'));
$fldJerseyNumber = $func->output_fun($db->f('fldJerseyNumber'));
$fldPrimaryPosition = $func->output_fun($db->f('fldPrimaryPosition'));
$fldSecondaryPosition = $func->output_fun($db->f('fldSecondaryPosition'));
$fldVertical = $func->output_fun($db->f('fldVertical'));
$fld40_yardDash = $func->output_fun($db->f('fld40_yardDash'));
<h1>Find Colleges for Your Network</h1>
<table cellspacing="2" cellpadding="5" bordercolor="#808080" border="0" width="100%" class="tablePadd" style="border-collapse: collapse;">
<tr>
<td align='center' colspan='4' height='30' valign='middle' width="100%"><font class="thankyoumessage"><?php
if ($_REQUEST['msg'] != "") {
echo $_REQUEST['msg'];
} else {
echo " ";
}
?>
</font></td>
</tr>
<tr>
<td align="right" colspan='4' height='30' valign='middle'>
<form name="searchFrm" id="searchFrm" action="<?php
echo $PHP_SELF;
?>
" method="POST">
<input type="hidden" name="page" id="page" value="0">
<input type="text" name="searchname" id="searchname">
<input type="submit" name="search" id="search" value="Search">
</form></td>
</tr>
<form name="frmCatagory" action="" method="post" onsubmit="">
<?php
if (!$searchname) {
if ($_REQUEST['Id']) {
$query = " Select * from " . TBL_COLLEGE_COACH_REGISTER . " where fldNeedType = '" . $athlete_info[0]['fldSport'] . "' AND fldCollegename='" . $_REQUEST['Id'] . "' and `fldStatus` ='ACTIVE'";
} else {
$query = " Select * from " . TBL_COLLEGE_COACH_REGISTER . " where fldNeedType = '" . $athlete_info[0]['fldSport'] . "' AND `fldStatus` ='ACTIVE'";
}
$db->next_record();
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>Title</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
//echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
//echo '<td class="normalblack_12" width="7%" align="center"><strong>View</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db->num_rows(); $i++) {
$fldId = $func->output_fun($db->f('fldId'));
$fldTitle = $func->output_fun($db->f('fldTitle'));
$pageURL = "ADHomeContentDetails.php?fldId={$fldId}";
$detailsWindowTitle = "Home Page Content";
echo '<tr>';
echo '<td align="left" class="normalblack_12"> ' . ($count + $_REQUEST['page'] * 10) . '</td>';
echo '
<td align="left" class="normalblack_12" >' . wordwrap($fldTitle, 17, "\n", true) . '</td>
';
echo '<td class="normalblack_12" align="center"><a href="ADHomeContentEdit.php?mode=edit&fldId=' . $db->f('fldId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
echo '</tr>';
$db->next_record();
$count++;
}
$Id = $_REQUEST['Id'];
$active_query_details = "update " . TBL_ADDTONETWORK_REQUEST . " set status = 'DEACTIVE' where Id='" . $Id . "'";
$activemsg = $db->query($active_query_details);
if (isset($activemsg)) {
$_REQUEST['msg'] = "Request successfully updated.";
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CPN - College Network Request</title>
<META NAME="Keywords" CONTENT="My Account">
<META NAME="Description" CONTENT="My Account">
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script language="Javascript" src="javascript/functions.js"></script>
<script language="JavaScript" type="text/JavaScript">
function activeRequest(Id) {
if(confirm("Sure you want to approve this request?")) {
document.frmUsers.action = "?mode=active&Id=" + Id;
document.frmUsers.submit();
}
}
function dectiveRequest(Id) {
if(confirm("Sure you want to deny this request? You can approve still approve it later.")) {
document.frmUsers.action = "?mode=deactive&Id=" + Id;
document.frmUsers.submit();
}
}
</script>
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();
$tbl_transportation_discount = 'tbl_transportation_discount';
$c = $_REQUEST["c"];
$que = "select * from " . $tbl_transportation_discount . " where id='" . $c . "'";
$db->query($que);
if ($db->num_rows() > 0) {
?>
<?php
while ($db->next_record()) {
$Transportation_charge = $func->output_fun($db->f('Transportation_charge'));
}
?>
<p>
<label>Transportation Charge:</label>
<span>
<input type="text" name="Transportation_charge" id="Transportation_charge" value="<?php
echo $Transportation_charge;
?>
" readonly />
<!-- <span style="color:#444;line-height:18px;margin-left:230px;">
<font style="color:#777;">* We provide Transportation for Event and our charge is $20 <br />from sterling high school.<br></font>
<font style="color:#777;">* Bus leave at 6:15am & back at 8:00 pm<br />* If you want to interesting so selecting above Select Transportation</font>-->
</span>
</p>
</head>
<body>
<?php
include 'header.php';
?>
<!--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" style="height:629px;">
<div class="registerPage_cmspage">
<?php
echo $func->output_fun($db->f('fldPageDescraption'));
?>
<?php
if (isset($_REQUEST['page_name']) and $_REQUEST['page_name'] == 'contactus') {
?>
<script language="JavaScript" type="text/JavaScript">
function validate() {
var error_msg = "";
if(trimString(document.frmAthReg.fldName.value) == "") {
error_msg += "Please Enter Name! \n";
} else {
if(hasSpecialCharaters(document.frmAthReg.fldName.value)) {
error_msg += "Enter valid Name! \n";
}
if ($_SESSION['mode'] == '') {
header("Location:index.php");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View Game Log</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>
<!--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>View Game Log</h1>
<div class="registerPage">
<?php
if ($_REQUEST['id']) {
$athleteid = $_REQUEST['id'];
} else {
$athleteid = $_SESSION['Athlete_id'];
}
$query = " Select * from " . TBL_ATHELETE_STAT . " where fldAtheleteId=" . $athleteid . " group by fldPrograme ";
$db->query($query);
echo $discount_amount = $func->output_fun($db->f('amount'));
$StartDate = $func->output_fun($db->f('StartDate'));
$EndDate = $func->output_fun($db->f('EndDate'));
$Status = $func->output_fun($db->f('Status'));
}
}
}*/
if ($_GET['mode'] == 'edit' and $Couponid != "") {
#get the records
$query = " Select * from " . $tbl_coupon . " where id =" . $Couponid;
$db->query($query);
$db->next_record();
if ($db->num_rows() > 0) {
$db->query($query);
$db->next_record();
$coupon_name = $func->output_fun($db->f('cpn_number'));
$discount_amount = $func->output_fun($db->f('amount'));
$StartDate = $func->output_fun($db->f('start_date'));
$EndDate = $func->output_fun($db->f('end_date'));
$event_id1 = $func->output_fun($db->f('event_id'));
$Status = $func->output_fun($db->f('Status'));
}
} else {
$coupon_name = "";
$discount_amount = "";
$StartDate = "";
$EndDate = "";
$event_id = "";
$Status = "";
}
if ($_POST['isSubmit'] == 'save') {
<div class="container">
<div class="innerWraper">
<div class="middle-bg">
<div class="cantener">
<div class="register-main">
<h1>Messaging</h1>
<div class="registerPage messaging">
<?php
$username = $_SESSION['FRONTEND_USER'];
?>
<?php
$query = "SELECT COUNT(*) as count from " . TBL_MAIL . " WHERE UserTo='{$username}' and status='unread' and visible='ACTIVE'";
$db->query($query);
$db->next_record();
$count = $func->output_fun($db->f('count'));
?>
<div style="margin-bottom:15px;" class="messagecenter">
<?php
if ($count > 0) {
?>
<a href="Athmessage.php?action=inbox" <?php
echo $_REQUEST['action'] == 'inbox' || $_REQUEST['action'] == '' ? 'class="active"' : '';
?>
>Inbox (<?php
echo $count;
?>
)</a>
<?php
//echo $queryString;
$db->query($query);
$db->next_record();
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr>
<td align="left" class="normalblack_12" width="25%"> <strong>Event Name</strong></td>
<td align="left" class="normalblack_12" width="12%"> <strong>Event date</strong></td>';
echo '<td class="normalblack_12" width="4%" align="center" style="text-align:center;"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="4%" align="center" style="text-align:center;"><strong>View</strong></td>';
echo '<td class="normalblack_12" width="8%" align="center" style="text-align:center;"><strong>Upload Stats</strong></td>';
echo '<td class="normalblack_12" width="5%" align="center" style="text-align:center;"><strong>Delete</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db->num_rows(); $i++) {
if ($func->output_fun($db->f('fld_UserType') == 'athlete') and $func->output_fun($db->f('fldUserName')) == $_SESSION['FRONTEND_USER'] or $func->output_fun($db->f('fld_UserType')) == 'admin') {
$fldEventId = $func->output_fun($db->f('fldEventId'));
$fldEventName = $func->output_fun($db->f('fldEventName'));
$pageURL = "ViewEventDetail.php?fldEventId={$fldEventId}";
$detailsWindowTitle = "ViewEventDetail";
$past_db = strtotime($func->output_fun($db->f('fldEventEndDate')));
$past_courrent = time();
echo '<tr>';
echo '<td align="left" class="normalblack_12">' . $fldEventName . '</td>';
echo '<td align="left" class="normalblack_12">' . $db->f('fldEventStartDate') . '</td>';
if ($func->output_fun($db->f('fld_UserType')) == 'athlete' and $func->output_fun($db->f('fldUserName')) == $_SESSION['FRONTEND_USER']) {
echo '<td class="normalblack_12" align="center" style="text-align:center;"><a href="editevent.php?mode=edit&fldEventId=' . $db->f('fldEventId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
} else {
echo '<td class="normalblack_12" align="center" style="text-align:center;">Not Allowed</td>';
}
echo '<td class="normalblack_12" align="center" style="text-align:center;"><a href="javascript:ShowDetails(\'' . $pageURL . '\',\'' . $detailsWindowTitle . '\')"><img src="admin/images/view.gif" border="0" title="View"></a></td>';
$AAUCity = $row['AAUCity'];
$AAUState = $row['AAUState'];
$AAUZipCode = $row['AAUZipCode'];
$AAUOther = $row['AAUOther'];
// END ADD fIELD ON 16-2-13
$fldTransportation = $row['fldTransportation'];
if (isset($row['fldTranscript'])) {
$fldTranscript = $row['fldTranscript'];
}
$fldCouponNumber = $row['fldCouponNumber'];
$fldprice = $row['fldprice'];
$fldpaymentstatus = $row['fldpaymentstatus'];
$evquery = "SELECT * FROM " . TBL_SPECIAL_EVENT . " WHERE `fldEventId` ='" . $fldSpecialEvent . "' ";
$db->query($evquery);
$db->next_record();
$fldEventStatus = $func->output_fun($db->f('fldEventStatus'));
$fldEventStartDate = $func->output_fun($db->f('fldEventStartDate'));
$fldEventName = $func->output_fun($db->f('fldEventName'));
$fldEventcurrentprice = $func->output_fun($db->f('fldEventcurrentprice'));
$fldEventfutureprice = $func->output_fun($db->f('fldEventfutureprice'));
$Early_Discount_day = $func->output_fun($db->f('Early_Discount_day'));
$Early_discount_rate = $func->output_fun($db->f('Early_discount_rate'));
$Transcript_discount = $func->output_fun($db->f('Transcript_discount'));
}
function getExtension($str)
{
$i = strrpos($str, ".");
if (!$i) {
return "";
}
$l = strlen($str) - $i;
$db1->query($query);
$db1->next_record();
if ($db1->num_rows() > 0) {
#check for record availability
echo '<tr><td align="center" class="normalblack_12" width="4%"> </td>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>Category Name</strong></td>
<td align="left" class="normalblack_12" width="15%"> <strong>Category (Initials)</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>View</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db1->num_rows(); $i++) {
$fldId = $func->output_fun($db1->f('fldId'));
$fldNameint = $func->output_fun($db1->f('fldNameint'));
$fldName = $func->output_fun($db1->f('fldName'));
$pageURL = "ADAthleteCategoryDetails.php?fldId={$fldId}";
$detailsWindowTitle = "Details";
echo '<tr><td align="center" class="normalblack_12"> ';
echo '<input type="checkbox" id="check_delete[]" name="check_delete[]" value="' . $fldId . '" onclick="return checkItSelf();">';
echo '<td align="left" class="normalblack_12"> ' . ($count + $_REQUEST['page'] * 10) . '</td>';
echo '
<td align="left" class="normalblack_12" >' . wordwrap($fldName, 17, "\n", true) . '</td>
<td align="left" class="normalblack_12" >' . wordwrap($fldNameint, 17, "\n", true) . '</td>
';
echo '<td class="normalblack_12" align="center"><a href="ADAthleteCatagoryEdit.php?mode=edit&fldId=' . $db1->f('fldId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
echo ' <td class="normalblack_12" align="center"><a href="javascript:deleteRecord(\'' . $fldId . '\',' . $pageno . ')"><img src="images/b_drop.png" border="0" title="Delete"></a></td>';
echo '<td class="normalblack_12" align="center"><a href="javascript:ShowDetailssmall(\'' . $pageURL . '\',\'' . $detailsWindowTitle . '\')">View</a></td>';
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr><td align="center" class="normalblack_12" width="4%"> </td>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>HS/AAU Name</strong></td>
<td align="left" class="normalblack_12" width="15%"> <strong>City</strong></td>
<td align="left" class="normalblack_12" width="10%"> <strong>State</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Details</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db->num_rows(); $i++) {
$fldId = $func->output_fun($db->f('fldId'));
$fldSchoolname = $func->output_fun($db->f('fldSchoolname'));
$fldCity = $func->output_fun($db->f('fldCity'));
$fldState = $func->output_fun($db->f('fldState'));
$pageURL = "ADSchoolDetails.php?fldId={$fldId}";
$detailsWindowTitle = "AdminUserDetails";
echo '<tr><td align="center" class="normalblack_12"> ';
echo '<input type="checkbox" id="check_delete[]" name="check_delete[]" value="' . $fldId . '" onclick="return checkItSelf();">';
echo '<td align="left" class="normalblack_12"> ' . ($count + $_REQUEST['page'] * 10) . '</td>
<td align="left" class="normalblack_12" >' . wordwrap($fldSchoolname, 17, "\n", true) . '</td>
<td align="left" class="normalblack_12">' . $fldCity . '</td>
<td align="left" class="normalblack_12">' . wordwrap($fldState, 10, "\n", true) . '</td>
';
echo '<td class="normalblack_12" align="center"><a href="ADSchoolEdit.php?mode=edit&fldId=' . $db->f('fldId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
if(trimString(document.messageform.message.value) == "") {
error_msg += "Please Enter Message. \n";
} else {
if(hasSpecialCharaters(document.messageform.message.value)) {
error_msg += "Enter valid Message. \n";
}
}
//Display Error
if(error_msg != '') {
alert(error_msg);
return false;
} else {
return true;
}
}
</script>
</head>
<body>
<!--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>Messaging</h1>
<div class="registerPage popupsmall">
<?php
if ($_REQUEST['action'] == "compose2") {
## Get Athlete Data
#########################################
//Build Query - by query or session variable
if ($_REQUEST['fldId'] != '') {
//get querystring fldId
$query = " Select * from " . TBL_ATHELETE_REGISTER . " where fldId = " . $_REQUEST['fldId'];
} else {
//get session Athlete_id
$query = " Select * from " . TBL_ATHELETE_REGISTER . " where fldId = " . $_SESSION['Athlete_id'];
}
//echo $query;
//Get Query Results
$db->query($query);
$db->next_record();
//Bind Data
$fldFirstname = $func->output_fun($db->f('fldFirstname'));
$fldLastname = $func->output_fun($db->f('fldLastname'));
$fldImage = $func->output_fun($db->f('fldImage'));
$fldDescription = $func->output_fun($db->f('fldDescription'));
$fldDescription = str_replace("\n", "<br>", $fldDescription);
$fldEmail = $func->output_fun($db->f('fldEmail'));
$fldComments = $func->output_fun($db->f('fldComments'));
$fldId = $func->output_fun($db->f('fldId'));
$fldForvideoId = $db->f('fldId');
$fldApproveCoachId = $db->f('fldApproveCoachId');
$fldJerseyNumber = $db->f('fldJerseyNumber');
$fldSport = $func->output_fun($db->f('fldSport'));
$query_coach_info = " Select * from " . TBL_HS_AAU_COACH . " where fldId = " . $fldApproveCoachId;
$db1->query($query_coach_info);
$db1->next_record();
$teaminfo = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname,fldAddress,fldEnrollment", "fldSchoolname", "where fldId='" . $db1->f('fldSchool') . "'");
}
if ($_REQUEST['mode'] == "del") {
$fldId = $_REQUEST['fldId'];
//Check if video belongs to THIS USER
$query = " Select fldVideo from " . TBL_ATHLETE_VIDEO . " where fldAthleteId='" . $_SESSION['Athlete_id'] . "' and fldId='" . $fldId . "' ";
$db2->query($query);
$db2->next_record();
if ($db2->num_rows() > 0) {
##Delete Video in Database
$delete_query_details = "delete from " . TBL_ATHLETE_VIDEO . " where fldId=" . $fldId;
$delmsg = $db->query($delete_query_details);
if (isset($delmsg)) {
$_REQUEST['msg'] = "Video successfully deleted.";
##Delete Local Video Files
//delete .flv
$FLVname = $func->output_fun($db2->f('fldVideo'));
$vidpath = 'video/' . $FLVname;
if (is_file($vidpath)) {
//fclose($vidpath);
unlink($vidpath);
}
//delete .jpg
$JPGname = str_replace(".flv", ".jpg", $FLVname);
$jpgpath = 'video/' . $JPGname;
if (is_file($jpgpath)) {
//fclose($jpgpath);
unlink($jpgpath);
}
}
} else {
$_REQUEST['msg'] = "Video not deleted, this video does not belong to you";
##############################################
##############################################
$query = "Select * from tbl_athelete_register where fldStatus = 'ACTIVE'";
$profile_db->query($query);
$profile_db->next_record();
$totalPages = $profile_db->num_rows();
if ($totalPages > 0) {
for ($k = 0; $k < $totalPages; $k++) {
$athlete_pending_task = array();
$uploadImage = $profile_db->f('fldImage');
$coachApprove = $profile_db->f('fldApproveCoachId');
$fldId = $profile_db->f('fldId');
$uploadVideo = $rating_func->GetValue("tbl_athlete_video", "fldId", "fldAthleteId", $fldId);
$fldUsername = $profile_db->f('fldUsername');
$uploadGameSchedule = $rating_func->GetValue("tbl_event", "fldEventId", "fld_UserType='athlete' AND fldUserName", $fldUsername);
$fldGPA = $rating_func->output_fun($profile_db->f('fldGPA'));
$fldSATScore = $rating_func->output_fun($profile_db->f('fldSATScore'));
$fldACTScore = $rating_func->output_fun($profile_db->f('fldACTScore'));
$fldClassRank = $rating_func->output_fun($profile_db->f('fldClassRank'));
$fldClearinghouseEligible = $rating_func->output_fun($profile_db->f('fldClearinghouseEligible'));
$fldIntendedMajor = $rating_func->output_fun($profile_db->f('fldIntendedMajor'));
$fldEmail = $rating_func->output_fun($profile_db->f('fldEmail'));
$fldClass = $rating_func->output_fun($profile_db->f('fldClass'));
$fldHeight = $rating_func->output_fun($profile_db->f('fldHeight'));
$fldWeight = $rating_func->output_fun($profile_db->f('fldWeight'));
$fldSport = $rating_func->output_fun($profile_db->f('fldSport'));
$fldSchool = $rating_func->output_fun($profile_db->f('fldSchool'));
$fldPrimaryPosition = $rating_func->output_fun($profile_db->f('fldPrimaryPosition'));
$fldSecondaryPosition = $rating_func->output_fun($profile_db->f('fldSecondaryPosition'));
$fldVertical = $rating_func->output_fun($profile_db->f('fldVertical'));
$fld40_yardDash = $rating_func->output_fun($profile_db->f('fld40_yardDash'));
<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>
$func = new COMMONFUNC();
$db = new DB();
$coachflag = 0;
$Athleteflag = 0;
$collegeflag = 0;
if ($_SESSION['mode'] == '') {
header("Location:index.php");
}
$fldEventId = $_REQUEST['fldEventId'];
$query = "Select * from " . TBL_EVENT . " where fldEventId = '{$fldEventId}' ";
$db->query($query);
$db->next_record();
$fldfldEventId = $db->f('fldEventId');
$fldEventName = $db->f('fldEventName');
$fldSport = $db->f('fldSport');
$fldEventDescription = $func->output_fun($db->f('fldEventDescription'));
$fldEventDescription = str_replace("\n", "<br>", $fldEventDescription);
$fldEventLocation = $db->f('fldEventLocation');
$fldEventStartDate = $db->f('fldEventStartDate');
$fldEventEndDate = $db->f('fldEventEndDate');
$fldHomeTeam = $db->f('fldHomeTeam');
$fldAwayTeam = $db->f('fldAwayTeam');
$fldEventStatus = $db->f('fldEventStatus');
$query_sport = "Select * from " . TBL_SPORTS . " where fldId = '{$fldSport}' ";
$db1->query($query_sport);
$db1->next_record();
$sport_nmae = $db1->f('fldSportsname');
$query_School = "Select * from " . TBL_HS_AAU_TEAM . " where fldId = '{$fldHomeTeam}' ";
$db2->query($query_School);
$db2->next_record();
$team_name = $db2->f('fldSchoolname');
<META NAME="Keywords" CONTENT="My Account">
<META NAME="Description" CONTENT="My Account">
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script language="Javascript" src="javascript/functions.js"></script>
<script language="JavaScript" type="text/JavaScript">
function refreshParent() {
window.opener.location.href = window.opener.location.href;
if(window.opener.progressWindow) {
window.opener.progressWindow.close()
}
window.close();
}
function validate() {
var error_msg = "";
//Check Values
if(trimString(document.frmSubmit.fldDivision.value) == "select") {
error_msg += "Please Select the Athlete's Projected Division. \n";
}
if(trimString(document.frmSubmit.fldComments.value) == "") {
error_msg += "Please Fill the Comment Box. \n";
} else {
if(hasSpecialChars(document.frmSubmit.fldComments.value)) {
error_msg += "Your Comment has special characters. Please remove: ^, {, }, <, > \n";
}
}
//Display Error
if(error_msg != '') {
alert(error_msg);
</script>
</head>
<body>
<?php
include 'header.php';
?>
<!--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">
$db->next_record();
if ($db->num_rows() > 0) {
#check for record availability
echo '<tr><td align="center" class="normalblack_12" width="4%"> </td>
<td align="left" class="normalblack_12" width="8%"> <strong>S.No.</strong></td>
<td align="left" class="normalblack_12" width="25%"> <strong>HS AAU Team Name</strong></td>
';
echo '<td class="normalblack_12" width="5%" align="center"><strong>Edit</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>Delete</strong></td>';
echo '<td class="normalblack_12" width="7%" align="center"><strong>View</strong></td>';
echo '</tr>';
$count = "1";
for ($i = 0; $i < $db->num_rows(); $i++) {
$fldId = $func->output_fun($db->f('fldId'));
$fldName = $func->output_fun($db->f('fldName'));
$pageURL = "HSAAUTeamNameDetails.php?fldId={$fldId}";
$detailsWindowTitle = "HS AAU Team Name";
echo '<tr><td align="center" class="normalblack_12"> ';
echo '<input type="checkbox" id="check_delete[]" name="check_delete[]" value="' . $fldId . '">';
echo '<td align="left" class="normalblack_12"> ' . ($count + $_REQUEST['page'] * 10) . '</td>';
echo '
<td align="left" class="normalblack_12" >' . wordwrap($fldName, 17, "\n", true) . '</td>
';
echo '<td class="normalblack_12" align="center"><a href="HSAAUTeamNameUpdate.php?mode=edit&fldId=' . $db->f('fldId') . '&page=' . $pageno . '"><img src="images/b_edit.png" border="0" title="Edit"></a></td>';
echo ' <td class="normalblack_12" align="center"><a href="javascript:deleteRecord(\'' . $fldId . '\',' . $pageno . ')"><img src="images/b_drop.png" border="0" title="Delete"></a></td>';
echo ' <td class="normalblack_12" align="center"><a href="javascript:ShowDetails(\'' . $pageURL . '\',\'' . $detailsWindowTitle . '\')">View</a></td>';
echo '</tr>';
<TD> </TD> </TR> <!-- ##################### CENTER CONTENT STARTS HERE (Left Menu and Center Content) ##############################--> <TR> <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"; ?>