$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')); }