<?php
$SessionUserID = isset($_SESSION['Athlete_id']) ? $_SESSION['Athlete_id'] : 0;
$rating_func = new COMMONFUNC();
$rating_db = new DB();
if ($SessionUserID > 0) {
$query = "Select * from tbl_athelete_register where fldId = '{$SessionUserID}' ";
$rating_db->query($query);
$rating_db->next_record();
$totalPages = $rating_db->num_rows();
if ($totalPages > 0) {
$UserID = $rating_db->f('fldId');
$uploadImage = $rating_db->f('fldImage');
$coachApprove = $rating_db->f('fldApproveCoachId');
$uploadVideo = $rating_func->GetValue("tbl_athlete_video", "fldId", "fldAthleteId", $rating_db->f('fldId'));
$uploadGameSchedule = $rating_func->GetValue("tbl_event", "fldEventId", "fld_UserType='athlete' AND fldUserName", $rating_db->f('fldUsername'));
$fldGPA = $rating_func->output_fun($rating_db->f('fldGPA'));
$fldSATScore = $rating_func->output_fun($rating_db->f('fldSATScore'));
$fldACTScore = $rating_func->output_fun($rating_db->f('fldACTScore'));
$fldClassRank = $rating_func->output_fun($rating_db->f('fldClassRank'));
$fldClearinghouseEligible = $rating_func->output_fun($rating_db->f('fldClearinghouseEligible'));
$fldIntendedMajor = $rating_func->output_fun($rating_db->f('fldIntendedMajor'));
$fldClass = $rating_func->output_fun($rating_db->f('fldClass'));
$fldHeight = $rating_func->output_fun($rating_db->f('fldHeight'));
$fldWeight = $rating_func->output_fun($rating_db->f('fldWeight'));
$fldSport = $rating_func->output_fun($rating_db->f('fldSport'));
//$fldJerseyNumber = $rating_func -> output_fun($rating_db -> f('fldJerseyNumber'));
$fldPrimaryPosition = $rating_func->output_fun($rating_db->f('fldPrimaryPosition'));
$fldSecondaryPosition = $rating_func->output_fun($rating_db->f('fldSecondaryPosition'));
$fldVertical = $rating_func->output_fun($rating_db->f('fldVertical'));
$fld40_yardDash = $rating_func->output_fun($rating_db->f('fld40_yardDash'));
"fldId",
" WHERE fldUsername='******'FRONTEND_USER']. "'"
);*/
$collegeuser_id = $_SESSION['FRONTEND_USER'];
// gets the user's sport and makes sure it's not empty
$fldSport = 0;
$network_for = isset($_REQUEST["network_for"]) ? $_REQUEST["network_for"] : "";
$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
$rating_db_3 = new DB();
$rating_db_4 = new DB();
$profile_db = new DB();
$coach_db = new DB();
##############################################
######### MONDAY REMINDERS START ################
##############################################
$query_1 = "select * from tbl_event where (date(fldEventStartDate) <= (now()) AND date(fldEventEndDate) <= (now())) and fld_UserType='athlete'";
$rating_db->query($query_1);
$rating_db->next_record();
$totalPages = $rating_db->num_rows();
if ($totalPages > 0) {
for ($k = 0; $k < $totalPages; $k++) {
$userName = $rating_db->f('fldUserName');
$EventId = $rating_db->f('fldEventId');
$UserId = $rating_func->GetValue("tbl_athelete_register", "fldId", "fldUsername", $userName);
$eventTitle = $rating_func->GetValue("tbl_event", "fldEventName", "fldEventId", $EventId);
/************/
$query_1_1 = "select * from tbl_athelete_stat WHERE fldAtheleteId='" . $UserId . "' AND fldPrograme='" . $EventId . "' GROUP BY fldAtheleteId,fldPrograme";
$rating_db_1->query($query_1_1);
$rating_db_1->next_record();
$arr_info_1 = array();
$totalPages_1 = $rating_db_1->num_rows();
if ($totalPages_1 == 0) {
$msg = "Hello " . $userName . ", <br /><br />\r\r\n\t\t\t\t\tYou are receiving this email because you have not posted Game Stats for a particular game/event. Please login to your Account at www.collegeprospectnetwork.com, and post Game Stats.\r\r\n\t\t\t\t\t<br /><br />\r\r\n\t\t\t\t\t*It's import to keep your profile accurate as possible. Please post Game Stats carefully & make your changes.\r\r\n\t\t\t\t\t<br /><br />\r\r\n\t\t\t\t\t<b>Game / Event:</b> " . $eventTitle . "<br /> \r\r\n\t\t\t\t\t<br /> \r\r\n\t\t\t\t\tThank you in advance " . $userName . ",<br />\r\r\n\t\t\t\t\tCollege Prospect Network<br />\r\r\n\t\t\t\t\twww.CollegeProspectNetwork.com";
$athleteEmail = $rating_func->GetValue("tbl_athelete_register", "fldEmail", "fldUsername", $userName);
$toStre1 = "*****@*****.**";
$subjectStre = "College Prospect Network - Request for post Game Stats";
$bodyStre = $msg;
$t = $rating_func->sendEmail($toStre1, $subjectStre, $bodyStre, $athleteEmail);
}
######### WEEKLY RATING START ################
##############################################
########### ADDING_GAME_STATE ################
$query_1 = "select * from tbl_event where ((date(fldEventStartDate) < (now()) AND date(fldEventStartDate) >= (DATE_SUB(now(), INTERVAL 8 day))) OR date(fldEventEndDate) >= (DATE_SUB(now(), INTERVAL 8 day))) and fld_UserType='athlete'";
$rating_db_1->query($query_1);
$rating_db_1->next_record();
$arr_info = array();
$totalPages = $rating_db_1->num_rows();
if ($totalPages > 0) {
for ($k = 0; $k < $totalPages; $k++) {
$arr_info[$k]['fldUserName'] = $rating_db_1->f('fldUserName');
// $arr_info[$k]['fldEventStartDate'] = $rating_db_1 -> f('fldEventStartDate');
$rating_db_1->next_record();
}
for ($kj = 0; $kj < count($arr_info); $kj++) {
$fldAthleteId = $rating_func->GetValue("tbl_athelete_register", "fldId", "fldUserName", $arr_info[$kj]['fldUserName']);
$rating_func->setAtheleteRating("WEEKLY", $fldAthleteId, "ADDING_GAME_STATE", true);
}
}
##############################################
########### RESPONDING_TO_EMAILS #############
$query_2 = "select * from tbl_mail where (date(SentDate) >= (DATE_SUB(now(), INTERVAL 8 day)) AND date(SentDate)< (now())) AND Usertypeto='athlete'";
$rating_db_2->query($query_2);
$totalPages = $rating_db_2->num_rows();
$arr_info = array();
if ($totalPages > 0) {
$rating_db_2->next_record();
for ($k = 0; $k < $totalPages; $k++) {
$checkUnread = $rating_func->GetValue("tbl_mail", "mail_id", "status='unread' AND UserTo", $rating_db_2->f('UserTo'));
if (trim($checkUnread) == "") {
$arr_info[$k] = trim($rating_db_2->f('UserTo'));
$func = new COMMONFUNC();
// access to common functions
$athletes = array();
// list of athletes returned by the search query
$isError = FALSE;
// flag indicating if an error occurred during the search
$errorMsg = NULL;
// error message to display if an error occurred during the search
$coachId = "";
$fldSport = 0;
$UserID = "";
switch ($ModeType) {
case 'athlete':
//AthleteID
$UserID = isset($_SESSION['Athlete_id']) ? $_SESSION['Athlete_id'] : "";
$fldSport = $func->GetValue("tbl_athelete_register", "fldSport", "fldId", $UserID);
//$fldSport = $func->GetValue(TBL_HS_AAU_TEAM,"fldSport","fldId",$db3->f('fldSchool'));
$sportList = array($fldSport);
$sport1 = each($sportList);
$coachId = "";
break;
case 'coach':
//HS Coach ID
$UserID = isset($_SESSION['Coach_id']) ? $_SESSION['Coach_id'] : "";
$fldSport = $func->GetValue("tbl_hs_aau_coach", "fldSport", "fldId", $UserID);
$sportList = array($fldSport);
$sport1 = each($sportList);
$coachId = "";
break;
case 'college':
//College Coach ID
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">
<div class="registerPage">
<h1>HS / AAU Coach Listing</h1>
<?php
if ($_REQUEST['msg'] != "") {
echo '<font class="thankyoumessage">' . $_REQUEST['msg'] . '</font>';
}
?>
<table cellspacing="2" cellpadding="5" bordercolor="#808080" border="0" width="100%" class="tablePadd" style="border-collapse: collapse;">
$flag = 0;
$network_for = isset($_REQUEST["network_for"]) ? $_REQUEST["network_for"] : "";
$ModeType = isset($_REQUEST["mode"]) ? $_REQUEST["mode"] : "";
$mode_1 = isset($_REQUEST["mode_1"]) ? $_REQUEST["mode_1"] : "";
$Id = isset($_REQUEST["Id"]) ? $_REQUEST["Id"] : 0;
$fldUserName = isset($_SESSION['FRONTEND_USER']) ? $_SESSION['FRONTEND_USER'] : "";
//Global Vars
$UserID = "";
$PageTitle = "";
$displayMessage = "";
$fld_Sport = "";
switch ($ModeType) {
case 'athlete':
//AthleteID
$UserID = isset($_SESSION['Athlete_id']) ? $_SESSION['Athlete_id'] : "";
$fld_Sport = $func->GetValue("tbl_athelete_register", "fldSport", "fldId", $UserID);
break;
case 'coach':
//HS Coach ID
$UserID = isset($_SESSION['Coach_id']) ? $_SESSION['Coach_id'] : "";
$fld_Sport = $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='******'");
$fld_Sport = $sport_info[0]['fldNeedType'];
break;
}
switch ($network_for) {
case 'athlete':
</h3>
<div class="right-boxes">
<?php
if ($query_note) {
$db_note->query($query_note);
$rowcount = $db_note->num_rows();
if ($rowcount > 0) {
echo '<table width="100%" cellspacing="2" cellpadding="5" bordercolor="#808080" border="0" style="border-collapse: collapse;" class="tablePadd">';
while ($db_note->next_record()) {
//$date = new DateTime($db_note->f('fldPostDate'));
//$date=$db_note->f('fldPostDate');
//$Note_Postdate = $date->format('d-m-Y');
$Note_Postdate = $db_note->f('fldPostDate');
$Note_Comment = $func->GetValue("tbl_notes", "fldDescription", "fldId", $db_note->f('fldNoteId'));
echo '<tr><td valign="middle" align="left" class="normalblack_12_stat">';
echo $Note_Comment . '<br>';
echo '<span style="color:#CCCCCC;float:right;">' . $Note_Postdate . '</span>';
echo '</td></tr>';
}
if ($rowcount > 1) {
echo '<tr><td valign="middle" align="right" class="normalblack_12_stat">';
echo '<a href="javascript:void(0);" onclick="window.open(\'view_more_notes.php?fldAthleteid=' . $uid . '&usertype=athlete\',\'winname\',\'directories=0,titlebar=0,toolbar=0,location=0,status=0,menubar=0,scrollbars=no,resizable=no,width=980px,height=380\');" class="gametape" style="float:right;">view more</a>';
echo '</td></tr>';
}
echo '</table>';
} else {
if (isset($_SESSION['Athlete_id']) && $_SESSION['Athlete_id'] != "") {
echo "You have not added any comments yet.";
} else {
