Пример #1
0
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
//for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
$fldPageStatus = 1;
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldPageTitle = $func->input_fun($_POST['fldPageTitle']);
    $fldPageDescraption = $func->input_fun($_POST['fldPageDescraption']);
    $fldPageMetaTitle = $func->input_fun($_POST['fldPageMetaTitle']);
    $fldPageMetaDescraption = $func->input_fun($_POST['fldPageMetaDescraption']);
    $fldPageMetaKeyword = $func->input_fun($_POST['fldPageMetaKeyword']);
    $fldPageStatus = $func->input_fun($_POST['fldPageStatus']);
    $whereClause = "fldPageTitle='" . $func->input_fun($_POST['fldPageTitle']) . "'";
    if ($db->MatchingRec(TBL_PAGE, $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This Page Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldPageTitle' => $func->input_fun($_POST['fldPageTitle']), 'fldPageDescraption' => $func->input_fun($_POST['fldPageDescraption']), 'fldPageMetaTitle' => $func->input_fun($_POST['fldPageMetaTitle']), 'fldPageMetaDescraption' => $func->input_fun($_POST['fldPageMetaDescraption']), 'fldPageMetaKeyword' => $func->input_fun($_POST['fldPageMetaKeyword']), 'fldPageAddedDate' => date("d-y-m"), 'fldPageStatus' => $func->input_fun($_POST['fldPageStatus']));
        $db->insertRec(TBL_PAGE, $strDataArr);
Пример #2
0
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
//for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
$fldStatus = 1;
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldTitle = $func->input_fun($_POST['fldTitle']);
    $fldDescription = $func->input_fun($_POST['fldDescription']);
    $fldStatus = $func->input_fun($_POST['fldStatus']);
    $whereClause = "fldTitle='" . $func->input_fun($_POST['fldTitle']) . "'";
    if ($db->MatchingRec("tbl_notes", $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This Note Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldTitle' => $func->input_fun($_POST['fldTitle']), 'fldDescription' => $func->input_fun($_POST['fldDescription']), 'fldStatus' => $func->input_fun($_POST['fldStatus']));
        $db->insertRec("tbl_notes", $strDataArr);
        #redirect to listing page on successfull updation
        header("Location: ADNotesList.php?msg=Note is Added Successfully, ");
    }
include_once "inc/common_functions.php";
//for common function
include_once "inc/page.inc.php";
include_once "inc/config.inc.php";
//for paging
$func = new COMMONFUNC();
$db = new DB();
?>
<!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>Comments From My Coach</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 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") {
    $fldVertical = "";
    $fld40_yardDash = "";
    $fldShuttleRun = "";
    $fldBenchPressMax = "";
    $fldSquatMax = "";
    $fldGPA = "";
    $fldSATScore = "";
    $fldACTScore = "";
    $fldClassRank = "";
    $fldClearinghouseEligible = "";
    $fldIntendedMajor = "";
}
if ($_POST['isSubmit'] == 'save') {
    if ($_GET['fldId'] != "") {
        //Edit the user info
        $fldUsername = $func->input_fun($_POST['fldUsername']);
        $fldEmail = $func->input_fun($_POST['fldEmail']);
        $fldFirstname = $func->input_fun($_POST['fldFirstname']);
        $fldLastname = $func->input_fun($_POST['fldLastname']);
        $fldClass = $func->input_fun($_POST['fldClass']);
        $fldHeight = $func->input_fun($_POST['fldHeight']);
        $fldWeight = $func->input_fun($_POST['fldWeight']);
        $fldDescription = $func->input_fun($_POST['fldDescription']);
        $fldSchool = $func->input_fun($_POST['fldSchool']);
        $fldSport = $func->input_fun($_POST['fldSport']);
        $fldPrimaryPosition = $func->input_fun($_POST['fldPrimaryPosition']);
        $fldSecondaryPosition = $func->input_fun($_POST['fldSecondaryPosition']);
        $fldVertical = $func->input_fun($_POST['fldVertical']);
        $fld40_yardDash = $func->input_fun($_POST['fldSport']);
        $fldShuttleRun = $func->input_fun($_POST['fld40_yardDash']);
        $fldBenchPressMax = $func->input_fun($_POST['fldBenchPressMax']);
$lnb = "10";
$error_msg = '';
$flag = 0;
function getExtension($str)
{
    $i = strrpos($str, ".");
    if (!$i) {
        return "";
    }
    $l = strlen($str) - $i;
    $ext = substr($str, $i + 1, $l);
    return $ext;
}
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldSchoolname = $func->input_fun($_POST['fldSchoolname']);
    $fldUserName = $func->input_fun($_POST['fldUserName']);
    //$city        = $func->input_fun($_POST['city']);
    $whereClause = "fldUserName='******'";
    if ($db->MatchingRec(TBL_HS_AAU_TEAM, $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This School User Name Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        define("MAX_SIZE", "400");
        $errors = 0;
        ///////////
        $image = $_FILES['fldLogo']['name'];
        if ($image) {
            $filename = stripslashes($_FILES['fldLogo']['name']);
        $db->next_record();
        $fldName = $db->f('fldName');
        $fldNameint = $db->f('fldNameint');
        $fldParentId = $db->f('fldParentId');
        $fldStatus = $db->f('fldStatus');
    }
} else {
    $fldName = "";
    $fldNameint = "";
    $fldParentId = "";
    $fldStatus = "";
}
if ($_POST['isSubmit'] == 'save') {
    $where = "fldId=" . $fldId;
    //Update data
    $strDataArr = array('fldName' => $func->input_fun($_POST['fldName']), 'fldNameint' => $func->input_fun($_POST['fldNameint']), 'fldParentId' => $func->input_fun($_POST['fldParentId']), 'fldStatus' => $func->input_fun($_POST['fldStatus']));
    $db->updateRec(TBL_ATHLETE_STATS_CATAGORY, $strDataArr, $where);
    #redirect to listing page on successfull updation
    header("Location: ADAthleteCatagoryList.php?page=" . $_REQUEST['page'] . "&msg=Category Updated Successfully!");
    if ($error_msg != "") {
        $fldName = $_REQUEST['fldName'];
        $fldNameint = $_REQUEST['fldNameint'];
        $fldParentId = $_REQUEST['fldParentId'];
        $fldfldStatus = $_REQUEST['fldfldStatus'];
    }
}
//END if submit
?>


<script language="JavaScript" type="text/JavaScript">
        $db->next_record();
        $fldName = $db->f('fldName');
        $fldAddress = $db->f('fldCoachName');
        $fldContactInfo = $db->f('fldCoachPhone');
        $fldStatus = $db->f('fldStatus');
    }
} else {
    $fldName = "";
    $fldAddress = "";
    $fldContactInfo = "";
    $fldStatus = "";
}
if ($_POST['isSubmit'] == 'save') {
    $where = "fldId=" . $fldId;
    //Update data
    $strDataArr = array('fldCoachName' => $func->input_fun($_POST['fldAddress']), 'fldCoachPhone' => $func->input_fun($_POST['fldContactInfo']), 'fldStatus' => $func->input_fun($_POST['fldStatus']));
    $db->updateRec(TBL_HS_AAU_TEAM_OTHER, $strDataArr, $where);
    if ($_POST['fldStatus'] == 1) {
        $query_others = "select * from " . TBL_HS_AAU_TEAM_OTHER;
        $db1->query($query_others);
        $db1->next_record();
        $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";
        }
    $fldStatus = "";
    $fldSubscribe = "";
    $fldPosition = "";
    $fldNeedType = "";
    $fldEmail = "";
    $fldFirstName = "";
    $fldLastName = "";
    $fldAlternativeEmail = "";
    $fldPhone = "";
    $fldAlternativePhone = "";
    $fldDescriPation = "";
}
if ($_POST['isSubmit'] == 'save') {
    if ($_GET['fldId'] != "") {
        //Edit the user info
        $fldUserName = $func->input_fun($_POST['fldUserName']);
        $fldPassword = $func->input_fun($_POST['fldPassword']);
        $fldCollegename = $func->input_fun($_POST['fldCollegename']);
        $fldCity = $func->input_fun($_POST['fldCity']);
        $fldState = $func->input_fun($_POST['fldState']);
        $fldStatus = $func->input_fun($_POST['fldStatus']);
        $fldSubscribe = $func->input_fun($_POST['fldSubscribe']);
        $fldPosition = $func->input_fun($_POST['fldPosition']);
        $fldNeedType = $func->input_fun($_POST['fldNeedType']);
        $fldEmail = $fldDescriPation = $func->input_fun($_POST['fldEmail']);
        $fldFirstName = $func->input_fun($_POST['fldFirstName']);
        $fldLastName = $func->input_fun($_POST['fldLastName']);
        $fldAlternativeEmail = $func->input_fun($_POST['fldAlternativeEmail']);
        $fldPhone = $func->input_fun($_POST['fldPhone']);
        $fldAlternativePhone = $func->input_fun($_POST['fldAlternativePhone']);
        $fldDescriPation = $func->input_fun($_POST['fldDescriPation']);
##	Copyright   :       Synapse Communications Private Limited.
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
// for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldSchoolname = $func->input_fun($_POST['fldSchoolname']);
    $whereClause = "fldSchoolname='" . $fldSchoolname . "'";
    if ($db->MatchingRec(TBL_HS_AAU_TEAM, $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This HS/AAU Team Code Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        $errors = 0;
        //Insert data
        $Zipcode_lat_lon = $func->getLatLong($func->input_fun($_POST['fldZipcode']), MAPS_APIKEY);
        $strDataArr = array('fldSchoolname' => $func->input_fun($_POST['fldSchoolname']), 'fldAddress' => $func->input_fun($_POST['fldAddress']), 'fldCity' => $func->input_fun($_POST['fldCity']), 'fldState' => $func->input_fun($_POST['fldState']), 'fldZipcode' => $func->input_fun($_POST['fldZipcode']), 'fldStatus' => $func->input_fun($_POST['fldStatus']), 'fldEnrollment' => $func->input_fun($_POST['fldEnrollment']), 'fldLatitude' => $Zipcode_lat_lon['Latitude'], 'fldLongitude' => $Zipcode_lat_lon['Longitude']);
        //$s=$_POST;
        //print_r($s);
        $db->insertRec(TBL_HS_AAU_TEAM, $strDataArr);
        #redirect to listing page on successfull updation
##	Page name	:		ADChangePassword.php
##	Create Date	:		23/06/2009
##  Description :		It is use to change the admin password.
##	Copyright   :       Synapse Communications Private Limited.
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include "include/ADsessionAdmin.php";
// for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "0";
$error_msg = '';
if ($_POST['isSubmit'] == 'save') {
    if ($_SESSION['ADMIN_USER'] != "") {
        $whereClause = "username='******'ADMIN_USER'] . "' and password ='******'oldpassword']) . "'";
        if ($db->MatchingRec(TBL_ADMIN, $whereClause) == 0) {
            $error_msg = 'Please enter correct old password!';
        } else {
            if ($error_msg == '') {
                $strDataArr = array('password ' => $func->input_fun($_POST['newpassword']));
                $where = "username='******'ADMIN_USER'] . "'";
                $db->updateRec(TBL_ADMIN, $strDataArr, $where);
                header("Location: ADChangePassword.php?page=" . $_REQUEST['page'] . "&msg=Admin password changed successfully!");
            }
        }
    }
    //this section is use to filup the value after erro message.
    if ($error_msg != "") {
        $oldpassword = $_REQUEST['oldpassword'];
        $newpassword = $_REQUEST['newpassword'];
         $size = filesize($_FILES['fldImage']['tmp_name']);
         if ($size > MAX_SIZE * 1024 * 1024) {
             $error_msg = "You have exceeded the size limit";
             $errors = 1;
         }
         $image_name = "cpn_" . time() . '.' . $extension;
         $newname = "athimages/" . $image_name;
         $copied = copy($_FILES['fldImage']['tmp_name'], $newname);
     }
 }
 //Update data
 $fldUsername = $_SESSION['FRONTEND_USER'];
 $where = "fldUsername='******'";
 if ($fldAdminAthleticStat != 1) {
     $nowToday = strtotime(date("now"));
     $strDataArr = array('fldEmail' => $func->input_fun($_POST['fldEmail']), 'fldFirstname' => $func->input_fun($_POST['fldFirstname']), 'fldLastname' => $func->input_fun($_POST['fldLastname']), 'fldClass' => $func->input_fun($_POST['fldClass']), 'fldHeight' => $func->input_fun($_POST['fldHeight']), 'fldWeight' => $func->input_fun($_POST['fldWeight']), 'fldDescription' => $func->input_fun($_POST['fldDescription']), 'fldPrimaryPosition' => $func->input_fun($_POST['fldPrimaryPosition']), 'fldSecondaryPosition' => $func->input_fun($_POST['fldSecondaryPosition']), 'fldVertical' => $func->input_fun($_POST['fldVertical']), 'fld40_yardDash' => $func->input_fun($_POST['fld40_yardDash']), 'fldShuttleRun' => $func->input_fun($_POST['fldShuttleRun']), 'fldBenchPressMax' => $func->input_fun($_POST['fldBenchPressMax']), 'fldSquatMax' => $func->input_fun($_POST['fldSquatMax']), 'fldGPA' => $func->input_fun($_POST['fldGPA']), 'fldSATScore' => $func->input_fun($_POST['fldSATScore']), 'fldACTScore' => $func->input_fun($_POST['fldACTScore']), 'fldClassRank' => $func->input_fun($_POST['fldClassRank']), 'fldClearinghouseEligible' => $func->input_fun($fldClearinghouseEligible), 'fldJerseyNumber' => $func->input_fun($_POST['fldJerseyNumber']), 'fldImage' => $image_name, 'fldIntendedMajor' => $func->input_fun($_POST['fldIntendedMajor']));
 } else {
     if ($fldAdminAthleticStat == 1) {
         $strDataArr = array('fldEmail' => $func->input_fun($_POST['fldEmail']), 'fldFirstname' => $func->input_fun($_POST['fldFirstname']), 'fldLastname' => $func->input_fun($_POST['fldLastname']), 'fldClass' => $func->input_fun($_POST['fldClass']), 'fldWeight' => $func->input_fun($_POST['fldWeight']), 'fldDescription' => $func->input_fun($_POST['fldDescription']), 'fldVertical' => $func->input_fun($_POST['fldVertical']), 'fldBenchPressMax' => $func->input_fun($_POST['fldBenchPressMax']));
     }
 }
 if ($_POST['fldSchool'] != "others") {
     if ($fldSchool == 'others') {
         $String_Delete_Query = "delete from " . TBL_HS_AAU_TEAM_OTHER . " where  fldUserId =" . $fldAthleteid;
         $db->query($String_Delete_Query);
     }
 }
 if ($_POST['fldSchool'] == "others") {
     $whereClause_team = "fldSchoolname='" . $func->input_fun($_POST['txtfldName']) . "'";
     $flagss = 0;
     if ($db->MatchingRec(TBL_HS_AAU_TEAM, $whereClause_team) > 0) {
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
//for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
$fldStatus = 1;
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldName = $func->input_fun($_POST['fldName']);
    $fldNameint = $func->input_fun($_POST['fldNameint']);
    $fldParentId = $func->input_fun($_POST['fldParentId']);
    $fldStatus = $func->input_fun($_POST['fldStatus']);
    $whereClause = "fldName='" . $func->input_fun($_POST['fldName']) . "'";
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldName' => $func->input_fun($_POST['fldName']), 'fldNameint' => $func->input_fun($_POST['fldNameint']), 'fldParentId' => $func->input_fun($_POST['fldParentId']), 'fldStatus' => $func->input_fun($_POST['fldStatus']));
        $db->insertRec(TBL_ATHLETE_STATS_CATAGORY, $strDataArr);
        #redirect to listing page on successfull updation
        header("Location: ADAthleteCatagoryList.php?msg=Catagory is Added Successfully, ");
    }
    //this section is use to filup the value after erro message.
    if ($error_msg != "") {
        $fldName = $_REQUEST['fldName'];
        $fldNameint = $_REQUEST['fldNameint'];
Пример #13
0
    $db->query($query);
    $db->next_record();
    if ($db->num_rows() > 0) {
        $fldTitle = $db->f('fldTitle');
        $fldVideo = $db->f('fldVideo');
        $fldStatus = $db->f('fldStatus');
    }
} else {
    $fldTitle = " ";
    $fldVideo = " ";
    $fldStatus = " ";
}
//Submit Form
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldTitle = $func->input_fun($_POST['fldTitle']);
    $fldStatus = $func->input_fun($_POST['fldStatus']);
    $video_upload = $_FILES['fldVideo']['name'];
    if ($video_upload) {
        $filename = stripslashes($_FILES['fldVideo']['name']);
        $extension = getExtension($filename);
        $extension = strtolower($extension);
        if ($extension != "mov" && $extension != "flv" && $extension != "avi" && $extension != "mp4" && $extension != "wmv" && $extension != "mpeg" && $extension != "mpg") {
            $error_msg = 'Unknown Video Extension: only .mov .flv .avi .mp4 .wmv .mpeg .mpg are supported';
            $flag++;
        } else {
            $size = filesize($_FILES['fldVideo']['tmp_name']);
            if ($size > MAX_SIZE * 1024) {
                $error_msg = 'This Game Tape exceeds the 200MB Size Limit, please upload a smaller version.';
                $flag++;
            }
    $db->query($query);
    $db->next_record();
    if ($db->num_rows() > 0) {
        $db->query($query);
        $db->next_record();
        $fldName = $db->f('fldName');
        $fldStatus = $db->f('fldStatus');
    }
} else {
    $fldName = "";
    $fldStatus = "";
}
if ($_POST['isSubmit'] == 'save') {
    $where = "fldId=" . $fldId;
    //Update data
    $strDataArr = array('fldStatus' => $func->input_fun($_POST['fldStatus']));
    $db->updateRec(TBL_OTHER, $strDataArr, $where);
    if ($_POST['fldStatus'] == 1) {
        $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";
ini_set('max_execution_time', 600);
//Get Video Extension
function getExtension($str)
{
    $i = strrpos($str, ".");
    if (!$i) {
        return "";
    }
    $l = strlen($str) - $i;
    $ext = substr($str, $i + 1, $l);
    return $ext;
}
//Submit Form
if ($_POST['isSubmit'] == 'save') {
    //get form data
    $fldTitle = $func->input_fun($_POST['fldTitle']);
    $fldStatus = $func->input_fun($_POST['fldStatus']);
    $video_upload = $_FILES['fldVideo']['name'];
    if ($video_upload) {
        $filename = stripslashes($_FILES['fldVideo']['name']);
        $extension = getExtension($filename);
        $extension = strtolower($extension);
        if ($extension != "mov" && $extension != "flv" && $extension != "avi" && $extension != "mp4" && $extension != "wmv" && $extension != "mpeg" && $extension != "mpg") {
            $error_msg = 'Unknown Video Extension: only .mov .flv .avi .mp4 .wmv .mpeg .mpg are supported';
            $flag++;
        } else {
            $size = filesize($_FILES['fldVideo']['tmp_name']);
            if ($size > MAX_SIZE * 1024) {
                $error_msg = 'This Game Tape exceeds the 50MB Size Limit, please upload a smaller version.';
                $flag++;
            }
##	Copyright   :       Synapse Communications Private Limited.
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
// for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
if ($_POST['isSubmit'] == 'save') {
    //Insert the block message info
    $fldFrom = $func->input_fun($_POST['fldFrom']);
    $fldSport = $func->input_fun($_POST['fldSport']);
    $fldTo = $func->input_fun($_POST['fldTo']);
    $fldStartdate = $func->input_fun($_POST['fldStartdate']);
    $fldEndDate = $func->input_fun($_POST['fldEndDate']);
    $fldStatus = $func->input_fun($_POST['fldStatus']);
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldFrom' => $func->input_fun($_POST['fldFrom']), 'fldSport' => $func->input_fun($_POST['fldSport']), 'fldTo' => $func->input_fun($_POST['fldTo']), 'fldStartdate' => $func->input_fun($_POST['fldStartdate']), 'fldEndDate' => $func->input_fun($_POST['fldEndDate']), 'fldStatus' => $func->input_fun($_POST['fldStatus']));
        $db->insertRec(TBL_BLOCK_MESSAGE, $strDataArr);
        #redirect to listing page on successfull updation
        header("Location: ADBlockMessageList.php?msg=You have Successfully Block Messaging between the selected Criteria ");
    }
    //this section is use to filup the value after erro message.
    if ($error_msg != "") {
        $fldFrom = $_REQUEST['fldFrom'];
$error_msg = '';
$flag = 0;
$fldEventStatus = 1;
if ($_POST['isSubmit'] == 'save') {
    /* Validation Area Start*/
    hb_php_validate($_POST['fldEventName'], "Please Enter Special Event Name!");
    hb_php_validate($_POST['fldEventLocation'], "Please Enter Special Event Loacation!");
    hb_php_validate($_POST['fldEventStartDate'], "Please Enter Special Event Start Date!");
    hb_php_validate($_POST['fldEventcurrentprice'], "Please Enter Special Event Current Price!");
    hb_php_validate($_POST['fldEventfutureprice'], "Please Enter Special Event Future Price!");
    hb_php_validate($_POST['Early_Discount_day'], "Please Enter Early Discount Day!");
    hb_php_validate($_POST['Early_discount_rate'], "Please Enter Early Discount Price!");
    hb_php_validate($_POST['Transcript_discount'], "Please Enter Transcript Discount Price!");
    /* Validation Area End*/
    //Edit the user info
    $fldEventName = $func->input_fun($_POST['fldEventName']);
    /*$fldSport					=$func->input_fun($_POST['fldSport']);*/
    $fldEventDescription = $func->input_fun($_POST['fldEventDescription']);
    $fldEventLocation = $func->input_fun($_POST['fldEventLocation']);
    $fldEventStartDate = $func->input_fun($_POST['fldEventStartDate']);
    $fldEventcurrentprice = $func->input_fun($_POST['fldEventcurrentprice']);
    $fldEventfutureprice = $func->input_fun($_POST['fldEventfutureprice']);
    $Early_Discount_day = $func->input_fun($_POST['Early_Discount_day']);
    $Early_discount_rate = $func->input_fun($_POST['Early_discount_rate']);
    $Transcript_discount = $func->input_fun($_POST['Transcript_discount']);
    /*$fldEventEndDate 		 = $func->input_fun($_POST['fldEventEndDate']);*/
    /*$fldHomeTeam 		 = $func->input_fun($_POST['fldHomeTeam']);
    		$fldAwayTeam 		 = $func->input_fun($_POST['fldAwayTeam']);*/
    $fldEventStatus = $func->input_fun($_POST['fldEventStatus']);
    $cur_price = $_POST['fldEventcurrentprice'];
    $future_price = $_POST['fldEventfutureprice'];
Пример #18
0
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
// for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$page = new Page();
//Create an instance of class Pate
$lnb = "2";
$error_msg = '';
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldSportsname = $func->input_fun($_POST['fldSportsname']);
    $whereClause = "fldSportsname='" . $fldSportsname . "'";
    if ($db->MatchingRec(TBL_SPORTS, $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This Coach is Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldSportsname' => $func->input_fun($_POST['fldSportsname']), 'fldDescription' => $func->input_fun($_POST['fldDescription']), 'fldStatus' => $func->input_fun($_POST['fldStatus']));
        $db->insertRec(TBL_SPORTS, $strDataArr);
        #redirect to listing page on successfull updation
        header("Location: ADSportList.php?msg={$fldSportsname} is Added Successfully, ");
    }
    //this section is use to filup the value after erro message.
    if ($error_msg != "") {
		<?php 
        exit;
    }
    if ($evnt_price < $_POST['Transcript_discount']) {
        ?>
<script type="text/javascript">
			alert("Please Enter Current Price Larger then Transcript Discount!");
			window.history.go(-1);
			</script>
		<?php 
        exit;
    }
    /* validation area ended */
    $where = "fldEventId=" . $fldEventId;
    //Update data
    $strDataArr = array('fldEventName' => $func->input_fun($_POST['fldEventName']), 'fldSport' => $func->input_fun($_POST['fldSport']), 'fldEventDescription' => $func->input_fun($_POST['fldEventDescription']), 'fldEventLocation' => $func->input_fun($_POST['fldEventLocation']), 'fldEventStartDate' => $func->input_fun($_POST['fldEventStartDate']), 'fldEventEndDate' => $func->input_fun($_POST['fldEventEndDate']), 'fldHomeTeam' => $func->input_fun($_POST['fldHomeTeam']), 'fldAwayTeam' => $func->input_fun($_POST['fldAwayTeam']), 'fldEventcurrentprice' => $func->input_fun($_POST['fldEventcurrentprice']), 'fldEventfutureprice' => $func->input_fun($_POST['fldEventfutureprice']), 'Early_Discount_day' => $func->input_fun($_POST['Early_Discount_day']), 'Early_discount_rate' => $func->input_fun($_POST['Early_discount_rate']), 'Transcript_discount' => $func->input_fun($_POST['Transcript_discount']), 'fldEventStatus' => $func->input_fun($_POST['fldEventStatus']));
    $db->updateRec(TBL_SPECIAL_EVENT, $strDataArr, $where);
    #redirect to listing page on successfull updation
    header("Location: ADSpecialEventList.php?page=" . $_REQUEST['page'] . "&msg=Special Event Updated Successfully!");
    if ($error_msg != "") {
        $fldEventName = $_REQUEST['fldEventName'];
        $fldSport = $_REQUEST['fldSport'];
        $fldEventDescription = $_REQUEST['fldEventDescription'];
        $fldEventLocation = $_REQUEST['fldEventLocation'];
        $fldEventStartDate = $_REQUEST['fldEventStartDate'];
        $fldEventEndDate = $_REQUEST['$fldEventEndDate'];
        $fldHomeTeam = $_REQUEST['fldHomeTeam'];
        $fldAwayTeam = $_REQUEST['fldAwayTeam'];
        $fldEventcurrentprice = $_POST['fldEventcurrentprice'];
        $fldEventfutureprice = $_POST['fldEventfutureprice'];
        $Early_Discount_day = $_POST['Early_Discount_day'];
Пример #20
0
//for common function
include_once "inc/page.inc.php";
//for paging
include_once "inc/config.inc.php";
$func = new COMMONFUNC();
$db = new DB();
if ($_POST['isSubmit'] == 'save') {
    if ($_REQUEST['fldUsername'] == '') {
        $error_msg[] = " Please Enter User Name";
    }
    if ($_REQUEST['fldPassword'] == '') {
        $error_msg[] = "Please enter Password";
    }
    if ($_REQUEST['logininfo'] == "athlete") {
        ########### ATHLETE #############
        $fldUsername = $func->input_fun($_POST['fldUsername']);
        $fldPassword = $func->input_fun($_POST['fldPassword']);
        $whereClause = "fldUsername='******' and fldPassword= '******' ";
        $retVal = $db->MatchingRec(TBL_ATHELETE_REGISTER, $whereClause);
        //If Username & Password Matches
        if ($retVal != 0) {
            $query = " Select fldUsername,fldEmail,fldId,fldApproveCoachId,fldStatus from " . TBL_ATHELETE_REGISTER . " where  fldUsername = '******' ";
            $db->query($query);
            $db->next_record();
            $fldUsername = $db->f('fldUsername');
            $Email = $db->f('fldEmail');
            $fldId = $db->f('fldId');
            //IsApproveds
            $sessIsApproved = 0;
            $fldApproveCoachId = $db->f('fldApproveCoachId ');
            if ($fldApproveCoachId != 0) {
##	Create Date	:		19/07/2011
##  Description :		It is use to send the message to athlete.
##	Copyright   :       Synapse Communications Private Limited.
## *****************************************************************
include_once "inc/common_functions.php";
//for common function
include_once "inc/page.inc.php";
include_once "inc/config.inc.php";
session_start();
//for paging
$func = new COMMONFUNC();
$db = new DB();
?>
<!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>Messaging</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"></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">
                $trans = mysql_query("select * from " . $tbl_transportation_discount . " where id='" . $fldTransportation . "'");
                $re = mysql_fetch_array($trans);
                $Transportation_charge = $re['Transportation_charge'];
                $fldprice = $fldprice + $Transportation_charge;
                $transportationCharge = $fldprice;
            }
            $coupon = mysql_query("select * from tbl_cupon where cpn_number='" . $_POST['fldCouponNumber'] . "' AND status='1'");
            $re = mysql_fetch_array($coupon);
            if ($_POST['fldCouponNumber'] == $re['cpn_number']) {
                $fldprice = $fldprice - $re['amount'];
                $coupondiscount = $re['amount'];
            }
            $fldpaymentstatus = "INCOMPLETE";
            ##INSERT Enent###
            #######################################
            $strDataArr = array('fldFirstName' => $func->input_fun($_POST['fldFirstName']), 'fldLastName' => $func->input_fun($_POST['fldLastName']), 'fldAddress' => $func->input_fun($_POST['fldBSAddress']), 'fldCity' => $func->input_fun($_POST['fldBSCity']), 'fldState' => $func->input_fun($_POST['fldBSState']), 'fldZipCode' => $func->input_fun($_POST['fldBSZipCode']), 'fldPhone' => $func->input_fun($_POST['fldPhone']), 'fldEmail' => $func->input_fun($_POST['fldEmail']), 'fldSpecialEvent' => $func->input_fun($_POST['fldSpecialEvent']), 'fldReferredBy' => $func->input_fun($_POST['fldReferredBy']), 'fldClass' => $func->input_fun($_POST['fldClass']), 'fldPrimaryPosition' => $func->input_fun($_POST['fldPrimaryPosition']), 'fldSecondaryPosition' => $func->input_fun($_POST['fldSecondaryPosition']), 'fldHSCoachName' => $func->input_fun($_POST['fldHSCoachName']), 'fldSchool' => $func->input_fun($fldSchool), 'fldOthers' => $func->input_fun($_POST['txtfldName']), 'Address' => $func->input_fun($Address), 'City' => $func->input_fun($City), 'State' => $func->input_fun($State), 'Zipcode' => $func->input_fun($Zipcode), 'fldAAUCoachName' => $func->input_fun($_POST['fldAAUCoachName']), 'AAUOther' => $func->input_fun($_POST['txtfldAAUName']), 'HS_AAU_Team' => $func->input_fun($fldAAUSchool), 'AAUAddress' => $func->input_fun($fldAAUAddress), 'AAUCity' => $func->input_fun($fldAAUCity), 'AAUState' => $func->input_fun($fldAAUState), 'AAUZipCode' => $func->input_fun($fldAAUZipcode), 'fldCouponNumber' => $func->input_fun($_POST['fldCouponNumber']), 'fldTransportation' => $func->input_fun($fldTransportation), 'fldTranscript' => $newname, 'fldprice' => $fldprice, 'fldpaymentstatus' => $fldpaymentstatus, 'fldAddDate' => date("y-m-d"));
            //print_r($strDataArr);
            $debugstep = 2;
            //Insert Data - Get NewUserID
            if (isset($_REQUEST['fld_id']) && $_REQUEST['fld_id'] != '') {
                $where_reg_update = "fldId = " . $_REQUEST['fld_id'];
                $result = $db->updateRec(TBL_SPECIAL_EVENT_REGISTER, $strDataArr, $where_reg_update);
                $NewUserId = $_SESSION['fld_id'];
            } else {
                $NewUserId = $db->insertRec(TBL_SPECIAL_EVENT_REGISTER, $strDataArr);
            }
            $error_msg = "Thankyou for Register with Our Event";
            $_SESSION['fld_id'] = $NewUserId;
            $debugstep = 3;
            ?>
    $db->next_record();
    if ($db->num_rows() > 0) {
        $db->query($query);
        $db->next_record();
        $fldTitle = $db->f('fldTitle');
        $fldDescription = $db->f('fldDescription');
    }
} else {
    $fldTitle = "";
    $fldDescription = "";
    $fldStatus = "";
}
if ($_POST['isSubmit'] == 'save') {
    $where = "fldId='" . $fldId . "'";
    //Update data
    $strDataArr = array('fldDescription' => $func->input_fun($_POST['fldDescription']), 'fldStatus' => 1);
    $db->updateRec(TBL_HOME_CONTENT, $strDataArr, $where);
    #redirect to listing page on successfull updation
    header("Location: ADHomeContentList.php?page=" . $_REQUEST['page'] . "&msg=Content Updated Successfully!");
    if ($error_msg != "") {
        $fldTitle = $_REQUEST['fldTitle'];
        $fldDescription = $_REQUEST['fldDescription'];
    }
}
?>



<HTML><HEAD><TITLE>Add User Info</TITLE>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/styles.css" rel="stylesheet" type="text/css">
    $fldPosition = "";
    $fldNeedType = "";
    $fldEmail = "";
    $fldFirstName = "";
    $fldLastName = "";
    $fldAlternativeEmail = "";
    $fldPhone = "";
    $fldAlternativePhone = "";
    $fldAddress = "";
    $fldEnrollmentNumber = "";
    $fldDivison = "";
}
if ($_POST['isSubmit'] == 'save') {
    if ($fldId != "") {
        //Edit the user info
        $fldUserName = $func->input_fun($_POST['fldUserName']);
        $fldCollegename = $func->input_fun($_POST['fldCollegename']);
        $fldCity = $func->input_fun($_POST['fldCity']);
        $fldState = $func->input_fun($_POST['fldState']);
        $fldSport = $func->input_fun($_POST['fldSport']);
        $fldCoachname = $func->input_fun($_POST['fldCoachname']);
        $fldPosition = $_POST['fldPosition'];
        $fldNeedType = $_POST['fldNeedType'];
        $fldEmail = $_POST['fldEmail'];
        $fldFirstName = $_POST['fldFirstName'];
        $fldLastName = $_POST['fldLastName'];
        $fldAlternativeEmail = $_POST['fldAlternativeEmail'];
        $fldPhone = $_POST['fldPhone'];
        $fldAlternativePhone = $_POST['fldAlternativePhone'];
        $fldAddress = $_POST['fldAddress'];
        $fldEnrollmentNumber = $_POST['fldEnrollmentNumber'];
## *****************************************************************
session_start();
include_once "inc/common_functions.php";
//for common function
include_once "inc/config.inc.php";
//for paging
$func = new COMMONFUNC();
$db = new DB();
$fldAthleteid = isset($_REQUEST["fldAthleteid"]) ? $_REQUEST["fldAthleteid"] : 0;
$fldYoutubelink = "";
$fldYoutubeModifiedDate = "";
$youID = "";
$error_msg = "";
if ($_POST['isSubmit'] == 'save') {
    $nowToday = date('Y-m-d H:i:s');
    $fldNoteID = $func->input_fun($_POST['fldNoteID']);
    if ($fldNoteID <= 0 || $fldNoteID == "") {
        $error_msg = '<div class="thankyoumessage" style="margin-right:29px;">Please select Note.</div>';
    } else {
        $strDataArr = array('fldAthleteId' => $fldAthleteid, 'fldNoteId' => $fldNoteID, 'fldPostDate' => $nowToday);
        $db->insertRec("tbl_athlete_notes", $strDataArr, "");
        $error_msg = '

				<script language="JavaScript" type="text/JavaScript">

				window.opener.location.reload(false);

				self.close();

				</script>
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
//for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
$fldStatus = 1;
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldName = $func->input_fun($_POST['fldName']);
    $fldDescription = $func->input_fun($_POST['fldCost']);
    $fldStatus = $func->input_fun($_POST['fldStatus']);
    $fldPeriod = $func->input_fun($_POST['fldPeriod']);
    $whereClause = "fldName='" . $func->input_fun($_POST['fldName']) . "'";
    if ($db->MatchingRec(TBL_SUBSRIPTION, $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This Subsription Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldName' => $func->input_fun($_POST['fldName']), 'fldCost' => $func->input_fun($_POST['fldCost']), 'fldStatus' => $func->input_fun($_POST['fldStatus']), 'fldPeriod' => $func->input_fun($_POST['fldPeriod']));
        $db->insertRec(TBL_SUBSRIPTION, $strDataArr);
        #redirect to listing page on successfull updation
        header("Location: ADSubsriptionList.php?msg=Subsription is Added Successfully, ");
##	Copyright   :       Synapse Communications Private Limited.
## *****************************************************************
include_once "../inc/common_functions.php";
//for common function
include_once "../inc/page.inc.php";
//for paging
include "include/ADsessionAdmin.php";
// for admin login
$func = new COMMONFUNC();
//Create an instance of class COMMONFUNC
$lnb = "10";
$error_msg = '';
$flag = 0;
if ($_POST['isSubmit'] == 'save') {
    //Edit the user info
    $fldCollegename = $func->input_fun($_POST['fldCollegename']);
    $fldUserName = $func->input_fun($_POST['fldUserName']);
    $fldEmail = $func->input_fun($_POST['fldEmail']);
    $fldAlternativeEmail = $func->input_fun($_POST['fldAlternativeEmail']);
    $fldPhone = $func->input_fun($_POST['fldPhone']);
    $fldAlternativePhone = $func->input_fun($_POST['fldAlternativePhone']);
    $fldDescriPation = $func->input_fun($_POST['fldDescriPation']);
    $whereClause = "fldUserName='******' or fldCollegename ='{$fldCollegename}' or fldEmail='{$fldEmail}'";
    if ($db->MatchingRec(TBL_COLLEGE_REGISTER, $whereClause) > 0) {
        #user Username already exists
        $error_msg = 'This College is  Already Exists!';
        $flag++;
    }
    if ($flag == 0) {
        //Insert data
        $strDataArr = array('fldUserName' => $func->input_fun($_POST['fldUserName']), 'fldPassword' => $func->input_fun($_POST['fldPassword']), 'fldCollegename' => $func->input_fun($_POST['fldCollegename']), 'fldCity' => $func->input_fun($_POST['fldCity']), 'fldState' => $func->input_fun($_POST['fldState']), 'fldStatus' => $func->input_fun($_POST['fldStatus']), 'fldAddDate' => date("y-m-d"), 'fldSubscribe' => $func->input_fun($_POST['fldSubscribe']), 'fldPosition' => $func->input_fun($_POST['fldPosition']), 'fldNeedType' => $func->input_fun($_POST['fldNeedType']), 'fldEmail' => $func->input_fun($_POST['fldEmail']), 'fldFirstName' => $func->input_fun($_POST['fldFirstName']), 'fldLastName' => $func->input_fun($_POST['fldLastName']), 'fldAlternativeEmail' => $func->input_fun($_POST['fldAlternativeEmail']), 'fldPhone' => $func->input_fun($_POST['fldPhone']), 'fldAlternativePhone' => $func->input_fun($_POST['fldAlternativePhone']), 'fldDescriPation' => $func->input_fun($_POST['fldDescriPation']));
        $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') {
    $where = "id=" . $Couponid;
    //Update data
    $strDataArr = array('cpn_number' => $func->input_fun($_POST['coupon_name']), 'amount' => $func->input_fun($_POST['discount_amount']), 'start_date' => $func->input_fun($_POST['StartDate']), 'end_date' => $func->input_fun($_POST['EndDate']), 'event_id' => $func->input_fun($_POST['event_id']), 'status' => $func->input_fun($_POST['Status']));
    $db->updateRec($tbl_coupon, $strDataArr, $where);
    #redirect to listing page on successfull updation
    header("Location: ADCouponManage.php?page=" . $_REQUEST['page'] . "&msg=Coupon Updated Successfully!");
    if ($error_msg != "") {
        $coupon_name = $_REQUEST['cpn_number'];
        $discount_amount = $_REQUEST['discount_amount'];
        $StartDate = $_REQUEST['StartDate'];
        $EndDate = $_REQUEST['EndDate'];
        $event_id = $_REQUEST['event_id'];
        $Status = $_REQUEST['status'];
    }
}
//END if submit
?>
        $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 = "";
    $Departure_Time = "";
    $Transportation_charge = "";
    $status = "";
}
if ($_POST['isSubmit'] == 'save') {
    $where = "id=" . $id;
    //Update data
    $strDataArr = array('Event_id' => $func->input_fun($_POST['Event_id']), 'Diparture_City' => $func->input_fun($_POST['Diparture_City']), 'Departure_Time' => $func->input_fun($_POST['hours'] . ":" . $_POST['minute'] . " " . $_POST['option']), 'Transportation_charge' => $func->input_fun($_POST['Transportation_charge']), 'status' => $func->input_fun($_POST['status']));
    $db->updateRec($tbl_transportation_discount, $strDataArr, $where);
    #redirect to listing page on successfull updation
    header("Location: ADTransportationManage.php?page=" . $_REQUEST['page'] . "&msg=Transportation Discount Updated Successfully!");
    if ($error_msg != "") {
        $Event_id = $_REQUEST['Event_id'];
        $Diparture_City = $_REQUEST['Diparture_City'];
        $Departure_Time = $_POST['hours'] . ":" . $_POST['minute'] . " " . $_POST['option'];
        $Transportation_charge = $_REQUEST['Transportation_charge'];
        $Status = $_REQUEST['status'];
    }
}
//END if submit
?>

<script language="JavaScript" type="text/JavaScript">
Пример #30
0
    $fldLastName = "";
    $fldEmail = "";
    $fldAEmail = "";
    $fldPhone = "";
    $fldAPhone = "";
    //$fldDescription    = "";
    $fldSchool = "";
    $fldSport = "";
    $fldPosition = "";
    $fldPassword = "";
    $fldStatus = "";
}
if ($_POST['isSubmit'] == 'save') {
    if ($_GET['fldId'] != "") {
        //Edit the user info
        $fldUsername = $func->input_fun($_POST['fldUsername']);
        $fldName = $func->input_fun($_POST['fldName']);
        $fldLastName = $func->input_fun($_POST['fldLastName']);
        $fldEmail = $func->input_fun($_POST['fldEmail']);
        $fldAEmail = $func->input_fun($_POST['fldAEmail']);
        $fldPhone = $func->input_fun($_POST['fldPhone']);
        $fldAPhone = $func->input_fun($_POST['fldAPhone']);
        $fldSchool = $func->input_fun($_POST['fldSchool']);
        $fldSport = $func->input_fun($_POST['fldSport']);
        $fldPosition = $func->input_fun($_POST['fldPosition']);
        $fldPassword = $func->input_fun($_POST['fldPassword']);
        $fldStatus = $func->input_fun($_POST['fldStatus']);
        if ($_GET['fldId'] != $_GET['fldId']) {
            $whereClause = "fldId='" . $func->input_fun($_GET['fldId']) . "'";
            if ($db->MatchingRec(TBL_HS_AAU_COACH, $whereClause) > 0) {
                #user Username already exists