$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'));
$fldShuttleRun = $rating_func->output_fun($rating_db->f('fldShuttleRun'));
$fldBenchPressMax = $rating_func->output_fun($rating_db->f('fldBenchPressMax'));
$fldSquatMax = $rating_func->output_fun($rating_db->f('fldSquatMax'));
##############################################
######### PROFILE COMLITION RATING START #####
##############################################
####### APPROVED_BY_COACH ################
if ($coachApprove > 0 || $coachApprove != "") {
$rating_func->setAtheleteRating("PROFILE", $UserID, "APPROVED_BY_COACH", true);
} else {
$rating_func->setAtheleteRating("PROFILE", $UserID, "APPROVED_BY_COACH", false);
}
##########################################
####### UPLOADING_GAME_TAPE ##############
if ($uploadVideo > 0 || $uploadVideo != "") {
$rating_func->setAtheleteRating("PROFILE", $UserID, "UPLOADING_GAME_TAPE", true);
} else {
$rating_func->setAtheleteRating("PROFILE", $UserID, "UPLOADING_GAME_TAPE", false);
}
#########################################
####### ADDING_PROFILE_PICTURE ##########
if ($uploadImage != "default.jpg" || $uploadImage != "") {
$rating_func->setAtheleteRating("PROFILE", $UserID, "ADDING_PROFILE_PICTURE", true);
} else {
##############################################
########### 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'));
}
