$fld_other_username = $db1->f('fldUserId');
$query_others = "select * from " . TBL_ATHELETE_REGISTER . " where fldId ='" . $fld_other_username . "' and fldSchool ='others'";
$db2->query($query_others);
$db2->next_record();
$db2->f('fldEmail');
$where1 = "fldId ='" . $fld_other_username . "'";
//Update data
if ($func->input_fun($_POST['fldStatus']) == 1) {
$status = "ACTIVE";
}
$strDataArr_college = array('fldCoachPhone' => $func->input_fun($_POST['fldCoachPhone']), 'fldStatus' => $status);
$db3->updateRec(TBL_HS_AAU_TEAM, $strDataArr_college, $where1);
$subjectStre = "HS / AAU TEAM Add Confirmation";
$bodyStre = "Hi (Username)</br>College XXXXXXX has been added in the college list. Please edit your profile and update college name. </br>Thanks</br>Admin</br>www.ddd.com</br>\r\r\n";
$fldEmail = "Admin";
$func->sendEmail($db2->f('fldEmail'), $subjectStre, $bodyStre, $db2->f('fldEmail'));
$func->sendEmail(ADMIN_EMAIL, $subjectStre, $bodyStre, ADMIN_EMAIL);
}
#redirect to listing page on successfull updation
header("Location: HsAauOtherList.php?page=" . $_REQUEST['page'] . "&msg=Other Updated Successfully!");
if ($error_msg != "") {
$fldName = $_REQUEST['fldName'];
$fldAddress = $_REQUEST['fldCoachName'];
$fldContactInfo = $_REQUEST['fldCoachPhone'];
$fldfldStatus = $_REQUEST['fldfldStatus'];
}
}
//END if submit
?>
$fldCancelCount = $db1->f('fldCancelCount');
$new_fldSubscribe = $subsCount > 0 ? 1 : 0;
$new_fldCancelCount = $fldCancelCount + 1;
// updates the record in tbl_college_coach_register
$data = array('fldSubscribe' => $new_fldSubscribe, 'fldCancelCount' => $new_fldCancelCount);
$rows = $db1->updateRec(TBL_COLLEGE_COACH_REGISTER, $data, 'fldId=' . $fldCoach);
} else {
// gets the transaction ID to save in the subscription table
$transactionResponse = $response->getTransactionResponse();
$transactionId = $transactionResponse->transaction_id;
// send a confirmation email to the user and the site admin
$toStre = $fldEmail;
$subjectStre = "College Prospect Network - Subscription Renewal";
$bodyTpl = 'Dear %s %s' . '<br /><br />' . 'Your subscription was automatically renewed and is currently active.' . '<br /><br />' . 'Order ID: %s' . '<br />' . 'Order Date: %s' . '<br /><br />' . 'College Prospect Network' . '<br />' . '<a href="http://www.collegeprospectnetwork.com">www.CollegeProspectNetwork.com</a>';
$bodyStre = sprintf($bodyTpl, $fldFirstName, $fldLastName, $transactionId, date('Y-m-d'));
$func->sendEmail($toStre, $subjectStre, $bodyStre, ADMIN_EMAIL);
$func->sendEmail(ADMIN_EMAIL, $subjectStre, $bodyStre, ADMIN_EMAIL);
// update the subscriptions table with a new next bill date
$fldNextBillDate = null;
switch (intval($fldType)) {
case 16:
$fldNextBillDate = date('Y-m-d', strtotime('+1 month'));
break;
case 17:
$fldNextBillDate = date('Y-m-d', strtotime('+1 year'));
break;
case 18:
$fldNextBillDate = date('Y-m-d', strtotime('+3 years'));
break;
}
$db1->updateRec(TBL_COLLEGE_SUBSCRIPTION, array('fldNextBillDate' => $fldNextBillDate), 'fldId=' . $fldId);
$query_others = "select * from " . TBL_OTHER;
$db1->query($query_others);
$db1->next_record();
$fld_other_username = $db1->f('fldUserId');
$query_others = "select * from " . TBL_COLLEGE_COACH_REGISTER . " where fldUserName ='******' and fldCollegename ='other' and fldStatus ='ACTIVE'";
$db2->query($query_others);
$db2->next_record();
$db2->f('fldEmail');
$where1 = "fldName ='" . $fldName . "'";
//Update data
$strDataArr_college = array('fldStatus' => $func->input_fun($_POST['fldStatus']));
$db3->updateRec(TBL_COLLEGE, $strDataArr_college, $where1);
$subjectStre = "College Add Confirmation";
$bodyStre = "College has been added now please update your college Name";
$fldEmail = "Admin";
$func->sendEmail($db2->f('fldEmail'), $subjectStre, $bodyStre, $db2->f('fldEmail'));
}
#redirect to listing page on successfull updation
header("Location: ADListOther.php?page=" . $_REQUEST['page'] . "&msg=Other Updated Successfully!");
if ($error_msg != "") {
$fldName = $_REQUEST['fldName'];
$fldfldStatus = $_REQUEST['fldfldStatus'];
}
}
//END if submit
?>
<script language="JavaScript" type="text/JavaScript">
function validate(){
$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);
}
/************/
$rating_db->next_record();
}
}
##############################################
##############################################
##############################################
$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();
$db1->next_record();
$sports_name = $func->output_fun($db1->f('fldSportsname'));
//display Sport - Position
$bodyStre .= $sports_name . ": " . $func->input_fun($_POST['fldPosition']);
} else {
$fldSport = $func->input_fun($_POST['fldSport' . $n]);
$sportquery = "SELECT fldSportsname from " . TBL_SPORTS . " WHERE fldId='{$fldSport}'";
$db1->query($sportquery);
$db1->next_record();
$sports_name = $func->output_fun($db1->f('fldSportsname'));
//display Sport - Position
$bodyStre .= "<br />" . $sports_name . ": " . $func->input_fun($_POST['fldPosition' . $n]);
}
}
$bodyStre .= "<br /><br />" . $_SERVER['HTTP_USER_AGENT'];
$func->sendEmail(ADMIN_EMAIL, $subjectStre, $bodyStre, $fldEmail);
#################END Notifcation Email#################
$msg = "Thank you for your Registration";
header("Location:myaccount.php?msg={$msg}");
}
}
?>
<!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>College Prospect Network</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script language="Javascript" src="javascript/functions.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
<script language="javascript" type="text/javascript">
$db2->next_record();
$EmailUsername = $func->output_fun($db2->f('fldUserName'));
$EmailPassword = $func->output_fun($db2->f('fldPassword'));
$EmailTo = $func->output_fun($db2->f('fldEmail'));
$EmailFirstname = $func->output_fun($db2->f('fldFirstName'));
$EmailLastname = $func->output_fun($db2->f('fldLastName'));
$EmailUserType = "College Coach";
break;
}
$bodyStrek = "Hi " . $EmailFirstname . " " . $EmailLastname . ",<br /><br />";
$bodyStrek .= "You have been sent a new Network Request. Please login to your account to Approve/Deny at 'My Account > Users In My Network' <br /><br />";
$bodyStrek .= "-------------------------------------------------------- <br />";
$bodyStrek .= "Login: <a href=http://www.collegeprospectnetwork.com/login.php>http://www.collegeprospectnetwork.com/login.php</a><br />";
$bodyStrek .= "Username: "******"<br />";
$bodyStrek .= "Password: "******"<br />";
$bodyStrek .= "User Type: " . $EmailUserType . "<br />";
$bodyStrek .= "-------------------------------------------------------- <br />";
$bodyStrek .= "<br />";
$bodyStrek .= "Please do not respond to this email. If you have any questions, use the Contact Us page on the website.<br /><br />";
$bodyStrek .= "Thank you,<br />";
$bodyStrek .= "College Prospect Network";
$func->sendEmail($EmailTo, $subjectStrek, $bodyStrek, "*****@*****.**");
#//End EMAIL
$msg = "RequestSending";
##DISPLAY SUCCESS
// $msg = "Thank you, your Network Request has been successfully sent. You will be notified when they accept or deny request.";
// header("Location: " . $GLOBALPage . "$ReceiverID&msg=$msg");
}
}
echo $msg;
##### //END Add Network Request #####
}
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\rYou are receiving this email because an athlete has added stats against a particular event. Please take a couple of minutes and review these stats <br><br>\rWe also ask that you project the top level of competition at which you can contribute and look over the information he/she has entered to confirm accuracy. It is a simple process and will only take a couple of minutes. <br><br> \r\rThank you in advance Coach,<br>\rCollege Prospect Network<br>\rwww.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;
$subjectStre = "Stats Approvel Request From Athlete";
$bodyStre = $msg;
$t = $func->sendEmail($coachEmail, $subjectStre, $bodyStre, $athemail);
header("Location: AtheleteStat.php?msg=1&fldEventId=" . $_GET['fldEventId'] . "&&page =" . $_GET['page']);
}
}
?>
<!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>College Prospect Network</title>
<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 validate() {
var error_msg = "";
var x = document.getElementsByName("category[]")
$db->query($query);
$db->next_record();
for ($i = 0; $i < $db->num_rows(); $i++) {
$firstname = $func->output_fun($db->f('fldFirstname'));
$password = $func->output_fun($db->f('fldPassword'));
$username = $func->output_fun($db->f('fldUsername'));
$subjectStre = "College Prospect Network - Login Information";
$bodyStre = "Hello " . ucfirst($firstname) . ",<br /><br />";
$bodyStre .= "Here is your Login Information for College Prospect Network:<br /><br />";
$bodyStre .= "Type: Athlete<br /><br />";
$bodyStre .= "Username: "******"<br />";
$bodyStre .= "Password: "******"<br /><br />";
$bodyStre .= "Thank you," . "<br />";
$bodyStre .= "College Prospect Network Support";
$adminmail = ADMIN_EMAIL;
$func->sendEmail($fldEmail, $subjectStre, $bodyStre, $adminmail);
$db->next_record();
}
header("Location: login.php?&msgforpass=Your password has been sent to your email from notifications@collegeprospectnetwork.com");
}
}
}
/////////////// HS Coach //////////////////
if ($logininfo == 'coach') {
$logininfoSpecific = "High School / AAU Coach";
$whereClause = "fldEmail='" . $fldEmail . "' and fldAnswer='" . $answer . "' ";
if ($db->MatchingRec(TBL_HS_AAU_COACH, $whereClause) == 0) {
$error_msg = 'Invalid Answer, Please retry. If you still have problems, please contact us through our Contact page. ';
} else {
if ($error_msg == '') {
$query = "select fldName,fldUsername,fldPassword from " . TBL_HS_AAU_COACH . " where fldEmail = " . "'{$fldEmail}'";
$coach_information = $func->selectTableOrder(TBL_HS_AAU_COACH, "fldName,fldLastName", "fldId", "where fldId=" . $_SESSION['Coach_id']);
$toStre = $_POST['fldEmail'];
$subjectStre = "Coach " . $coach_information[0]['fldName'] . " " . $coach_information[0]['fldLastName'] . " Has Invited You to Join Our Site!";
// $bodyStre = 'Hello,<br/>
// <br/>
// Your coach, ' . $coach_information[0]['fldName'] . ' ' . $coach_information[0]['fldLastName'] . ', has invited you to join College Prospect Network. Our website is designed to help high school athletes get recruited to play sports <br/>in college and your coach thinks you deserve the opportunity to be seen.<br/>
// <br/>
// The site is 100 percent free for you and your coach so join today and start being seen by colleges! Click this link <a href="' . SITE_URL . '/Registration-Athlete.php">College Prospect Network</a> to get started. <br/>
// <br/>
// Congratulations on being invited to join the site,<br/>
// Thadd Fifer <br/>
// President <br/>
// College Prospect Network';
$bodyStre = 'Hello,<br/><br/>
Your coach, ' . $coach_information[0]['fldName'] . ' ' . $coach_information[0]['fldLastName'] . ', has referred you to join College Prospect Network. Our website is designed to help high school athletes get recruited to play sports
in college and your coach thinks you deserve the opportunity to be seen.
<br/><br/>
The site costs you and your coach absolutely nothing so join today and start being seen by colleges! Click this link <a href="' . SITE_URL . 'Registration-Athlete.php" title="College Prospect Network">College Prospect Network</a> to get started. If you have any questions, please use the Contact Us page located on the website.
<br/><br/>
Welcome to the site,<br/><br/>
Thadd Fifer<br/>
President<br/>
College Prospect Network';
$adminmail = ADMIN_EMAIL;
$func->sendEmail($toStre, $subjectStre, $bodyStre, "*****@*****.**");
header("Location: invite.php?&msg=1");
}
//this section is use to filup the value after erro message.
if ($error_msg != "") {
$fldEmail = $_REQUEST['fldEmail'];
}
