$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"; ?>