$db1->next_record(); if($db1->num_rows()>0){ $fadd = $db1->f('fld_add'); $fedit = $db1->f('fld_edit'); $fdelete = $db1->f('fld_delete'); $fview = $db1->f('fld_view'); } */ ##****************************************************************** if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_CATAGORY . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Catagory Deleted Successfully!"; $count = $func->totalRows(TBL_CATAGORY); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { //print_r($_POST['check_delete']); for ($i = 0; $i < count($_POST['check_delete']); $i++) { //print_r($fldPageId); //print_r($k); $delete_query_details = "delete from " . TBL_CATAGORY . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); }
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldName like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_COLLEGE_COACH . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Team Deleted Successfully!"; $count = $func->totalRows(TBL_COLLEGE_COACH); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_COLLEGE_COACH . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "College Deleted Successfully!"; $count = $func->totalRows(TBL_COLLEGE_COACH);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldClass like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_CLASS . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Class Deleted Successfully!"; $count = $func->totalRows(TBL_CLASS); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { //print_r($_POST['check_delete']); for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_CLASS . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Class Deleted Successfully!";
if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldTitle like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $query_Image = " Select * from " . TBL_BANNER . " where fldId ='" . $fldId . "'"; $db1->query($query_Image); $db1->next_record(); echo $db1->f('fldImage'); @unlink('../banner/' . $db1->f('fldImage')); $delete_query_details = "delete from " . TBL_BANNER . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Banner Deleted Successfully!"; $count = $func->totalRows(TBL_BANNER); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $query_Image = " Select * from " . TBL_BANNER . " where fldId ='" . $_POST['check_delete'][$i] . "'"; $db1->query($query_Image); $db1->next_record(); echo $db1->f('fldImage'); @unlink('../banner/' . $db1->f('fldImage')); $delete_query_details = "delete from " . TBL_BANNER . " where fldId='" . $_POST['check_delete'][$i] . "'";
$db1->next_record(); if($db1->num_rows()>0){ $fadd = $db1->f('fld_add'); $fedit = $db1->f('fld_edit'); $fdelete = $db1->f('fld_delete'); $fview = $db1->f('fld_view'); } */ ##****************************************************************** if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_OTHER . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Other Deleted Successfully!"; $count = $func->totalRows(TBL_OTHER); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { //print_r($_POST['check_delete']); for ($i = 0; $i < count($_POST['check_delete']); $i++) { //print_r($fldPageId); //print_r($k); $delete_query_details = "delete from " . TBL_OTHER . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); }
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldSportsname like '%{$searchname}%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_SPORTS . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Sport Deleted Successfully!"; $count = $func->totalRows(TBL_SPORTS); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { foreach ($_REQUEST['check_delete'] as $key => $fldId) { $delete_query_details = "delete from " . TBL_SPORTS . " where fldId='{$fldId}'"; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Sports Deleted Successfully!"; $count = $func->totalRows(TBL_SPORTS);
} } } if ($_POST['search'] == 'Search') { $fldStartdate = $_POST['fldStartdate']; $fldEndDate = $_POST['fldEndDate']; $fldcontent = $_POST['fldcontent']; } if ($_REQUEST['mode'] == "delAll") { foreach ($_REQUEST['check_delete'] as $k => $mail_id) { $delete_query_details = "delete from " . TBL_MAIL . " where mail_id='{$mail_id}'"; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Message Deleted Successfully!"; $count = $func->totalRows(TBL_MAIL); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "dective") { $mail_id = $_REQUEST['mail_id']; $active_query_details = "update " . TBL_MAIL . " set visible = 'DECTIVE' where mail_id='" . $mail_id . "'"; $activemsg = $db->query($active_query_details); if (isset($activemsg)) { $_REQUEST['msg'] = "Message De-Active Successfully!"; } }
$db1->next_record(); $db1->num_rows(); if ($db->num_rows() == 0) { $delete_query_details = "delete from " . TBL_ATHLETE_STATS_CATAGORY . " where fldId=" . $fldId; $delmsg = $db1->query($delete_query_details); } else { ?> <script type="text/javascript"> alert("You have to delete its Subcategory first"); </script> <?php } if (isset($delmsg)) { $_REQUEST['msg'] = "Category Deleted Successfully!"; $count = $func->totalRows(TBL_ATHLETE_STATS_CATAGORY); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $query_child = " Select * from " . TBL_ATHLETE_STATS_CATAGORY . " where fldParentId =" . $_POST['check_delete'][$i]; $db1->query($query_child); $db1->next_record(); $db1->num_rows(); if ($db1->num_rows() == 0) { $delete_query_details = "delete from " . TBL_ATHLETE_STATS_CATAGORY . " where fldId=" . $_POST['check_delete'][$i];
header("Location:login.php"); } //for paging $func = new COMMONFUNC(); $page = new Page(); $db = new DB(); $db2 = new DB(); $flag = 0; //Local Variables $IsMyProfile = 0; if ($_REQUEST['mode'] == "del") { $delete_query_details = "delete from " . TBL_COLLEGE_NEEDS . " where fldId='" . $_REQUEST['fldId'] . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Need Type successfully deleted."; $count = $func->totalRows(TBL_NEEDTYPE); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } //Detect if this Athlete is Athlete viewing profile if ($_REQUEST['collegeid'] != '' and $_SESSION['College_Coach_id'] != '' and $_REQUEST['collegeid'] == $_SESSION['College_Coach_id']) { $IsMyProfile = 1; } ####################################### ## SEND NETWORK REQUEST //Insert, Display Notification, and Email Recipient $GLOBALPage = "collegeprofile.php?collegeid=";
$srchCond = "AND ((fldName like '%{$searchname}%') OR (fldSchool = '{$searchteam}'))"; } } else { if (!$_REQUEST['searchname'] and $_REQUEST['fldSchool'] != 0) { $searchteam = $_REQUEST['fldSchool']; $srchCond = "AND fldSchool = '{$searchteam}'"; $flag++; } } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_HS_AAU_COACH . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "High School / AAU Coach Deleted Successfully!"; $count = $func->totalRows(TBL_HS_AAU_COACH); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { foreach ($_REQUEST['check_delete'] as $key => $fldId) { $delete_query_details = "delete from " . TBL_HS_AAU_COACH . " where fldId='{$fldId}'"; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "High School / AAU Coach Deleted Successfully!"; $count = $func->totalRows(TBL_HS_AAU_COACH);
/*if(!$searchname){ $searchname=$_REQUEST['searchname']; } $searchname = addslashes($searchname); if(strlen($searchname)>0) { $queryString="searchname=$searchname"; $srchCond= "AND fldEventName like '%".$searchname."%'"; } */ if ($_REQUEST['mode'] == "del") { $id = $_REQUEST['id']; $delete_query_details = "delete from " . $tbl_transportation_discount . " where id=" . $id; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Transportation Discount Deleted Successfully!"; $count = $func->totalRows($tbl_transportation_discount); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . $tbl_transportation_discount . " where id=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Transportation Discount Deleted Successfully!"; $count = $func->totalRows($tbl_transportation_discount);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldTitle like '%" . $searchname . "%' OR fldDescription like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from tbl_notes where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Note Deleted Successfully!"; $count = $func->totalRows("tbl_notes"); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from tbl_notes where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Note Deleted Successfully!"; $count = $func->totalRows("tbl_notes");
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldCollegename like '%{$searchname}%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_COLLEGE_REGISTER . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "College Deleted Successfully!"; $count = $func->totalRows(TBL_COLLEGE_REGISTER); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { foreach ($_REQUEST['check_delete'] as $k => $fldId) { $delete_query_details = "delete from " . TBL_COLLEGE_REGISTER . " where fldId='{$fldId}'"; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "College Deleted Successfully!"; $count = $func->totalRows(TBL_COLLEGE_REGISTER);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "fldStatus=1 AND fldName like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_COLLEGE . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "College Deleted Successfully!"; $count = $func->totalRows(TBL_COLLEGE); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_COLLEGE . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "College Deleted Successfully!"; $count = $func->totalRows(TBL_COLLEGE);
$db1->next_record(); if($db1->num_rows()>0){ $fadd = $db1->f('fld_add'); $fedit = $db1->f('fld_edit'); $fdelete = $db1->f('fld_delete'); $fview = $db1->f('fld_view'); } */ ##****************************************************************** if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_ATHELETE_STAT . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Athlete Stat Deleted Successfully!"; $count = $func->totalRows(TBL_ATHELETE_STAT); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_ATHELETE_STAT . " where fldId='" . $_POST['check_delete'][$i] . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Athlete Stat Deleted Successfully!"; $count = $func->totalRows(TBL_ATHELETE_STAT); $offset = $_REQUEST['page'] * 10;
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldPageTitle like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldPageId = $_REQUEST['fldPageId']; $delete_query_details = "delete from " . TBL_PAGE . " where fldPageId='" . $fldPageId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Page Deleted Successfully!"; $count = $func->totalRows(TBL_PAGE); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_PAGE . " where fldPageId='" . $_POST['check_delete'][$i] . "'"; } $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Page Deleted Successfully!"; $count = $func->totalRows(TBL_PAGE);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldFirstName like '%" . $searchname . "%' OR fldLastName like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_SPECIAL_EVENT_REGISTER . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Special Event Register Deleted Successfully!"; $count = $func->totalRows(TBL_SPECIAL_EVENT_REGISTER); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_SPECIAL_EVENT_REGISTER . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Special Event Deleted Successfully!"; $count = $func->totalRows(TBL_SPECIAL_EVENT_REGISTER);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldName like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_HS_AAU_TEAM_OTHER . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Other HS / AAU Team Name Deleted Successfully!"; $count = $func->totalRows(TBL_HS_AAU_TEAM_OTHER); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { //print_r($_POST['check_delete']); for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_HS_AAU_TEAM_OTHER . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Other HS / AAU Team Name Deleted Successfully!";
/*if(!$searchname){ $searchname=$_REQUEST['searchname']; } $searchname = addslashes($searchname); if(strlen($searchname)>0) { $queryString="searchname=$searchname"; $srchCond= "AND fldEventName like '%".$searchname."%'"; } */ if ($_REQUEST['mode'] == "del") { $fldEventId = $_REQUEST['fldEventId']; $delete_query_details = "delete from " . $tbl_coupon . " where id=" . $fldEventId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Coupon Deleted Successfully!"; $count = $func->totalRows($tbl_coupon); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . $tbl_coupon . " where id=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Coupon Deleted Successfully!"; $count = $func->totalRows($tbl_coupon);
//fclose($jpgpath); unlink($jpgpath); } } } else { $_REQUEST['msg'] = "Video not deleted, this video does not belong to you"; } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_ATHLETE_VIDEO . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Video(s) successfully deleted."; $count = $func->totalRows(TBL_ATHLETE_VIDEO); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['page'] == '') { $pageno = '0'; } else { $pageno = $_REQUEST['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">
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 = ''; $srchCond = ''; if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_BLOCK_MESSAGE . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Message Block Deleted Successfully!"; $count = $func->totalRows(TBL_BLOCK_MESSAGE); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { foreach ($_REQUEST['check_delete'] as $k => $fldId) { $delete_query_details = "delete from " . TBL_BLOCK_MESSAGE . " where fldId='{$fldId}'"; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Message Block Deleted Successfully!"; $count = $func->totalRows(TBL_BLOCK_MESSAGE);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldEventName like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldEventId = $_REQUEST['fldEventId']; $delete_query_details = "delete from " . TBL_EVENT . " where fldEventId=" . $fldEventId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Event Deleted Successfully!"; $count = $func->totalRows(TBL_EVENT); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_EVENT . " where fldEventId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Event Deleted Successfully!"; $count = $func->totalRows(TBL_EVENT);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND fldTitle like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_HOME_CONTENT . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Content Deleted Successfully!"; $count = $func->totalRows(TBL_HOME_CONTENT); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_HOME_CONTENT . " where fldId='" . $_POST['check_delete'][$i] . "'"; } $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Content Deleted Successfully!"; $count = $func->totalRows(TBL_HOME_CONTENT);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "fldStatus=1 AND fldName like '%" . $searchname . "%'"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_HS_AAU_TEAM_NAME . " where fldId=" . $fldId; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "HS AAU Team Name Deleted Successfully!"; $count = $func->totalRows(TBL_HS_AAU_TEAM_NAME); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { for ($i = 0; $i < count($_POST['check_delete']); $i++) { $delete_query_details = "delete from " . TBL_HS_AAU_TEAM_NAME . " where fldId=" . $_POST['check_delete'][$i]; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "HS AAU Team Deleted Successfully!"; $count = $func->totalRows(TBL_HS_AAU_TEAM_NAME);
$srchCond = ''; if (!$searchname) { $searchname = $_REQUEST['searchname']; } $searchname = addslashes($searchname); if (strlen($searchname) > 0) { $queryString = "searchname={$searchname}"; $srchCond = "AND ((fldFirstname like '%{$searchname}%') or (fldLastname like '%{$searchname}%'))"; } if ($_REQUEST['mode'] == "del") { $fldId = $_REQUEST['fldId']; $delete_query_details = "delete from " . TBL_ATHELETE_REGISTER . " where fldId='" . $fldId . "'"; $delmsg = $db->query($delete_query_details); if (isset($delmsg)) { $_REQUEST['msg'] = "Athelete Deleted Successfully!"; $count = $func->totalRows(TBL_ATHELETE_REGISTER); $offset = $_REQUEST['page'] * 10; if ($count <= $offset) { $offset = $offset - $count; $_REQUEST['page'] = $offset / 10; } } } if ($_REQUEST['mode'] == "delAll") { foreach ($_REQUEST['check_delete'] as $k => $fldId) { $delete_query_details = "delete from " . TBL_ATHELETE_REGISTER . " where fldId='{$fldId}'"; $delmsg = $db->query($delete_query_details); } if (isset($delmsg)) { $_REQUEST['msg'] = "Athlete Deleted Successfully!"; $count = $func->totalRows(TBL_ATHELETE_REGISTER);