Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/kidscolorchamp/admin

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: results.php

<?php
session_start();
ob_start();
include("config/db.php");	
include_once 'functions/processes.php';
include 'functions/pagination.class.php';
$Login_Process = new Login_Process;
$Login_Process->check_status($_SERVER['SCRIPT_NAME']);

if($_SESSION['user_level'] >= 5)
{
	$smarty->assign('admin','Admin');
	
	$where='order by sort_order';
}
else
{
	$where='WHERE admin_menu.status=1 order by sort_order';

}

// table
$TABLE_EVENT=$smarty->getTemplateVars('TABLE_EVENT_LIST');
$TABLE_CLASS=$smarty->getTemplateVars('TABLE_CLASS');
$TABLE_PRIZE=$smarty->getTemplateVars('TABLE_PRIZE');

$TABLE_ADMIN_MENU=$smarty->getTemplateVars('TABLE_ADMIN_MENU');
$TABLE_STATUS=$smarty->getTemplateVars('TABLE_STATUS');

// menu 
 $sql_menu = "SELECT admin_menu_id, menu_name, menu_link, sort_order, status_name FROM ".$TABLE_ADMIN_MENU." LEFT JOIN ".$TABLE_STATUS." ON  ".$TABLE_ADMIN_MENU.".status=".$TABLE_STATUS.".status ".$where."  ";
 
$result_menu = mysqli_query($_SESSION['con'],$sql_menu) or die('Query failed1.'); 
	
while($row_menu = mysqli_fetch_array($result_menu))
{
	$menu[] = $row_menu; 
}
// menu

// sortby dropdown

$sql_filter = "SELECT * FROM ".$TABLE_EVENT."";
	$result_filter = mysqli_query($_SESSION['con'],$sql_filter) or die('Query failed2.'); 
	while($row_filter = mysqli_fetch_array($result_filter))
	{
		$datafilter_event[] = $row_filter; 
	}
	$smarty->assign('datafilter_event',$datafilter_event);

$sql_filter = "SELECT * FROM ".$TABLE_CLASS."";
	$result_filter = mysqli_query($_SESSION['con'],$sql_filter) or die('Query failed3.'); 
	while($row_filter = mysqli_fetch_array($result_filter))
	{
		$datafilter[] = $row_filter; 
	}
	$smarty->assign('datafilter_class',$datafilter);
	
	$sql_filter_sub = "SELECT * FROM ".$TABLE_PRIZE." ";
	
	$result_filter_sub = mysqli_query($_SESSION['con'],$sql_filter_sub) or die('Query failed4.'); 
	while($row_filter_sub = mysqli_fetch_array($result_filter_sub))
	{
		$datafilter_sub[] = $row_filter_sub; 
	}
	$smarty->assign('datafilter_prize',$datafilter_sub);
	
	
	
// end dropdown

// add entry
if($_GET['action']=='add')
{	
	if($_GET['event']=="save")	
	{
		$smarty->display("results/results_form.tpl");

$sql = "insert into results (name,school,event_id,class_id,prize_id,sort_order,status_id) values('".$_POST['name']."', '".$_POST['school']."', '".$_POST['event_id']."', '".$_POST['class_id']."', '".$_POST['prize_id']."', '".$_POST['sort_order']."','1')";
		
		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed5.'); 		
			 
		header("Location: results.php");
	}
	else if($_GET['event']=="notsave")	
	{
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysqli_query($_SESSION['con'],$qry_status) or die('Query failed6.'); 
		while($row_status = mysqli_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
		$smarty->assign('status',$status);		
		
		$qry_event = "SELECT * FROM ".$TABLE_EVENT." ";
		$res_event = mysqli_query($_SESSION['con'],$qry_event) or die('Query failed event.'); 
		while($row_event= mysqli_fetch_array($res_event))
		{
			$event[] = $row_event; 
		}
		$smarty->assign('event',$event);		
		
		$qry_class = "SELECT * FROM ".$TABLE_CLASS." ";
		$res_class = mysqli_query($_SESSION['con'],$qry_class) or die('Query failed class.'); 
		while($row_class = mysqli_fetch_array($res_class))
		{
			$class[] = $row_class; 
		}
		$smarty->assign('class',$class);		
		
		$qry_prize = "SELECT * FROM ".$TABLE_PRIZE." ";
		$res_prize = mysqli_query($_SESSION['con'],$qry_prize) or die('Query failed prize.'); 
		while($row_prize = mysqli_fetch_array($res_prize))
		{
			$prize[] = $row_prize; 
		}
		$smarty->assign('prize',$prize);	
		
		$smarty->assign('menu',$menu);
		$smarty->display("results/results_form.tpl");	
	}
}
// update entry
else if($_GET['action']=='edit')
{	
	if($_GET['event']=="save")	
	{	
			
		$sql = "update results set name='".$_POST['name']."', school='".$_POST['school']."', event_id='".$_POST['event_id']."', class_id='".$_POST['class_id']."', prize_id='".$_POST['prize_id']."', status_id='".$_POST['status_id']."', sort_order='".$_POST['sort_order']."' where results_id='".$_GET['id']."' ";
	
		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed7.'); 
				
		header("Location: results.php?gid=".$_GET['gid']."&page=".$_GET['page']);
	}
	else if($_GET['event']=="notsave")	
	{
		$sql = "SELECT * FROM results where results_id='".$_GET['id']."'";
		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed8.'); 
		while($row = mysqli_fetch_array($result))
		{
			$data[] = $row; 
		}
		$smarty->assign('data',$data);
		
		$qry_event = "SELECT * FROM ".$TABLE_EVENT." ";
		$res_event = mysqli_query($_SESSION['con'],$qry_event) or die('Query failed event.'); 
		while($row_event= mysqli_fetch_array($res_event))
		{
			$event[] = $row_event; 
		}
		$smarty->assign('event',$event);		
		
		$qry_class = "SELECT * FROM ".$TABLE_CLASS." ";
		$res_class = mysqli_query($_SESSION['con'],$qry_class) or die('Query failed class.'); 
		while($row_class = mysqli_fetch_array($res_class))
		{
			$class[] = $row_class; 
		}
		$smarty->assign('class',$class);		
		
		$qry_prize = "SELECT * FROM ".$TABLE_PRIZE." ";
		$res_prize = mysqli_query($_SESSION['con'],$qry_prize) or die('Query failed prize.'); 
		while($row_prize = mysqli_fetch_array($res_prize))
		{
			$prize[] = $row_prize; 
		}
		$smarty->assign('prize',$prize);	
		
		
		// get status array 
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysqli_query($_SESSION['con'],$qry_status) or die('Query failed9.'); 
		while($row_status = mysqli_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
		$smarty->assign('status',$status);	
		
		$sql_career= "SELECT * FROM career where status_id=1 ";		
		$result_career = mysqli_query($_SESSION['con'],$sql_career);
		while($row_career=mysqli_fetch_array($result_career))
		{
			$career[]=$row_career;
		}
		
		$smarty->assign('career',$career);
		
		$smarty->assign('menu',$menu);		
		$smarty->display("results/results_edit_form.tpl");	
	}
}
// delete record
else if($_GET['action']=='delete')
{	
	$sql = "delete from results where results_id='".$_GET['id']."' ";
	$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed10.');

header("Location: results.php?gid=".$_GET['gid']."&page=".$_GET['page']);		
}

else if($_GET['action']=='viewrecords')
{	
   if(isset($_POST['delete']))
   {
		$count= count($_POST['checkbox']);
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "delete from results where results_id='".$del_id."' ";
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed11.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: results.php?gid=".$_GET['gid']."&page=".$_GET['page']);		
		}
	}
	
	// disable start
	if(isset($_POST['disable']))
   {
		$count= count($_POST['checkbox']);
		
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "update results set status_id=0  where results_id='".$del_id."' ";
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed12.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: results.php?gid=".$_GET['gid']."&page=".$_GET['page']);		
		}
	}
	// disable end
	
	
	// enable start
	if(isset($_POST['enable']))
   {
		$count= count($_POST['checkbox']);
		
		for($i=0;$i<$count;$i++)
		{
			$del_id = $_POST['checkbox'][$i];
			$sql = "update results set status_id=1 where results_id='".$del_id."' ";
			$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed13.');
		}
		// if successful redirect to delete_multiple.php
		if($result)
		{
			header("Location: results.php?gid=".$_GET['gid']."&page=".$_GET['page']);		
		}
	}
	// enable end

// order by id
	if($_GET['orderby']=='id')
	{
		$orderby='order by results_id asc ';
	}	
	// order by engine model
	else if($_GET['orderby']=='event')
	{
		$orderby='order by event_id asc ';
	}
	// order by Displacement
	else if($_GET['orderby']=='class')
	{
		$orderby='order by class_id asc ';
	}
	// order by rated output
	else if($_GET['orderby']=='prize')
	{
		$orderby='order by prize_id asc ';
	}
	// order by Fuel
	else if($_GET['orderby']=='name')
	{
		$orderby='order by name asc ';
	}	
	// order by Fuel
	else if($_GET['orderby']=='school')
	{
		$orderby='order by school asc ';
	}	
	// order by sort order
	else if($_GET['orderby']=='sortorder')
	{
		$orderby='order by sort_order asc ';
	}
	// order by status
	else if($_GET['orderby']=='status')
	{
		$orderby='order by results.status_id asc ';
	}
	// default
	else 
	{
		$orderby='order by sort_order asc ';
	}
	
	
		$sql = "SELECT r.*, e.title, c.class, p.prize_name FROM results as r LEFT JOIN event_list as e ON r.event_id=e.event_list_id LEFT JOIN class as c ON c.class_id=r.class_id	LEFT JOIN prize as p ON r.prize_id=p.prize_id where r.status_id='1' ".$orderby." ";
	 
		$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed14.'); 
		while($row = mysqli_fetch_array($result))
		{
			$data[] = $row; 		
			
		}
		
		$sql=mysqli_query($_SESSION['con'],"select * from cw_users order by userid desc");
		$r=mysqli_fetch_array($sql);
		$pg_admin=$r['pg_admin'];
		
		
		// pg admin
		
		// Smarty Pagination Script Start 
			
		if (count($data))
		{
			$pagination = new pagination($data, (isset($_GET['page']) ? $_GET['page'] : 1), $pg_admin);
			$pagination->setShowFirstAndLast(false);
			$pagination->setMainSeperator('  ');
			  // Parse through the pagination class
			  $productPages = $pagination->getResults();
			  // If we have items 
			  if (count($productPages) != 0) 
			  {
				$pageNumbers = '<div class="numbers">'.$pagination->getLinks($_GET).'</div>';
				$smarty->assign('data',$productPages);	
				$smarty->assign('pageNumbers',$pageNumbers);		
			  }
		} 
		
		$smarty->assign('menu',$menu);	
		$smarty->display("results/results.tpl");	
	//orderby end
}
else if($_REQUEST['action'] == 'getRecords'){
	$eid = $_REQUEST['eid'];
	$cid = $_REQUEST['cid'];
	$pid = $_REQUEST['pid'];
	$sql = "SELECT * FROM results WHERE event_id = '".$eid."' AND class_id = '".$cid."' AND prize_id = '".$pid."'";
	$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed15.'); 
		while($row = mysqli_fetch_assoc($result))
		{
			$dataa[] = $row; 		
			
		}
		
		echo json_encode($dataa);
}
// default display
else
{
	if(!empty($_GET['gid'])){
		$sql = "SELECT r.*, e.title, c.class, p.prize_name FROM results as r LEFT JOIN event_list as e ON r.event_id=e.event_list_id LEFT JOIN class as c ON c.class_id=r.class_id	LEFT JOIN prize as p ON r.prize_id=p.prize_id where event_id='".$_GET['gid']."' order by sort_order asc";	
	}
	else{
	
	$sql = "SELECT r.*, e.title, c.class, p.prize_name FROM results as r LEFT JOIN event_list as e ON r.event_id=e.event_list_id LEFT JOIN class as c ON c.class_id=r.class_id	LEFT JOIN prize as p ON r.prize_id=p.prize_id order by sort_order asc";	
	
	}
	
	$result = mysqli_query($_SESSION['con'],$sql) or die('Query failed9.'); 
	while($row = mysqli_fetch_array($result))
	{
		$data[] = $row; 	
		
	}
	
	// pg from admin	
	$sql=mysqli_query($_SESSION['con'],"select * from cw_users order by userid desc");
	$r=mysqli_fetch_array($sql);
	$pg_admin=$r['pg_admin'];
	
	
	// pg admin
	
	// Smarty Pagination Script Start 
		
    if (count($data))
	{
    	$pagination = new pagination($data, (isset($_GET['page']) ? $_GET['page'] : 1), $pg_admin);
    	$pagination->setShowFirstAndLast(false);
        $pagination->setMainSeperator('  ');
          // Parse through the pagination class
          $productPages = $pagination->getResults();
          // If we have items 
          if (count($productPages) != 0) 
		  {
          	$pageNumbers = '<div class="numbers">'.$pagination->getLinks($_GET).'</div>';
           	$smarty->assign('data',$productPages);	
		    $smarty->assign('pageNumbers',$pageNumbers);		
		  }
    }
	
	$smarty->assign('menu',$menu);
	$smarty->display("results/results.tpl");	
}		
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: results.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation