????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 216.73.216.249
Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f
System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64
User : www-data ( 33)
PHP Version : 5.5.9-1ubuntu4.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/www/appsrv.astacus.se/statistics/old/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/www/appsrv.astacus.se/statistics/old/fix.php
<?php
	$link = mysql_connect ("localhost", "root", "root123");
	mysql_select_db ("vpa");

		

$cont = 52;
while ($cont > 0){ 
	
	$SUPERSQL = "";
	
	   
	      $period1 = date("Y-m-d", strtotime('monday this week -'.($cont-1).'weeks'));
			
	      $period2 = date("Y-m-d", strtotime('monday this week -'.($cont).'weeks'));


		 $sql = "SELECT * FROM ProjectTimeV2, EmployeeInfo where EmployeeInfo.Username = ProjectTimeV2.Username and EmployeeInfo.worktype = 'QC' and Workdate >= '$period2' and Workdate < '$period1' OR ProjectId = 1  order by ProjectTimeV2.Activity, Workdate";
		  
		  
		  $result = mysql_query($sql);

	$data = array();
	$data_total = 0;
	 		while ($row = mysql_fetch_assoc($result)){
	
				
				if(array_key_exists("".$row['Activity']."", $data)){
					$data["".$row['Activity'].""] = $data["".$row['Activity'].""] + ($row['Hrs']*60 + $row['Min']);
				}else{
					$data["".$row['Activity'].""] = ($row['Hrs']*60 + $row['Min']);
				}
				$data_total = $data_total + ($row['Hrs']*60 + $row['Min']);
				
				
  }
	

	foreach($data as $key => $value){


			$SUPERSQL = "INSERT INTO KeyStatValues VALUES(NULL,'QC".$key."','".$period1."','".round(($value/$data_total)*100)."');";
		$res = mysql_query($SUPERSQL);
		
	}
	


		  $sql = "SELECT * FROM ProjectTimeV2, EmployeeInfo where EmployeeInfo.Username = ProjectTimeV2.Username and EmployeeInfo.worktype = 'Sales' and Workdate >= '$period2' and Workdate < '$period1' OR ProjectId = 1  order by ProjectTimeV2.Activity, Workdate";
		  
		  $result = mysql_query($sql);

	$data = array();
	$data_total = 0;
	 		while ($row = mysql_fetch_assoc($result)){
	
				
				if(array_key_exists("".$row['Activity']."", $data)){
					$data["".$row['Activity'].""] = $data["".$row['Activity'].""] + ($row['Hrs']*60 + $row['Min']);
				}else{
					$data["".$row['Activity'].""] = ($row['Hrs']*60 + $row['Min']);
				}
				$data_total = $data_total + ($row['Hrs']*60 + $row['Min']);
				
				
  }
	

	foreach($data as $key => $value){


			$SUPERSQL ="INSERT INTO KeyStatValues VALUES(NULL,'Sales".$key."','".$period1."','".round(($value/$data_total)*100)."');";
		$res = mysql_query($SUPERSQL);
		
	}
	
				 

		  $sql = "SELECT * FROM ProjectTimeV2, EmployeeInfo where EmployeeInfo.Username = ProjectTimeV2.Username and EmployeeInfo.worktype = 'Laser' and Workdate >= '$period2' and Workdate < '$period1' OR ProjectId = 1  order by ProjectTimeV2.Activity, Workdate";
		  
		  $result = mysql_query($sql);

	$data = array();
	$data_total = 0;
	 		while ($row = mysql_fetch_assoc($result)){
	
				
				if(array_key_exists("".$row['Activity']."", $data)){
					$data["".$row['Activity'].""] = $data["".$row['Activity'].""] + ($row['Hrs']*60 + $row['Min']);
				}else{
					$data["".$row['Activity'].""] = ($row['Hrs']*60 + $row['Min']);
				}
				$data_total = $data_total + ($row['Hrs']*60 + $row['Min']);
				
				
  }
	

	foreach($data as $key => $value){
			$SUPERSQL = "INSERT INTO KeyStatValues VALUES(NULL,'Laser".$key."','".$period1."','".round(($value/$data_total)*100)."');";
		$res = mysql_query($SUPERSQL);
	}
	



	$cont--;
}
				 


?>

Youez - 2016 - github.com/yon3zu
LinuXploit