Gecko [ dp-client.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
common-js.php	197 B	-rw-r--r--
dbconnect.php	273 B	-rw-r--r--
footer.php	1.59 KB	-rw-r--r--
function.php	3.23 KB	-rw-r--r--
header.php	4.63 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
top-nav.php	3.45 KB	-rw-r--r--

Code Editor : function.php

<?php
include'dbconnect.php';
function user_datails($table,$id)
{	
 	$str = "SELECT * FROM $table WHERE id='".$id."'";
	$rslt=mysqli_query($GLOBALS['conn'],$str);
	if(!$rslt)
	{
		echo mysqli_error();
	}
	else
	{
		$GLOBALS['usr']=mysqli_fetch_array($rslt);
	}
}

function user_list($table)
{	
 	$str = "SELECT * FROM $table ";
	$rslt=mysqli_query($GLOBALS['conn'],$str);
	if(!$rslt)
	{
		echo mysqli_error();
	}
	else
	{
		$GLOBALS['usrl']=$rslt;
	}
}

function keywords_list($table,$uid,$sid,$mof,$mot,$kyd)
{

if($uid=='' && $sid=='' && $mof=='' && $mot=='' && $kyd=='')
	{
			$str = "SELECT * FROM $table order by months_value desc";
	}
	else
	{
		if($uid !=''){ $uidd ="and user_id='$uid'"; }else{	$uidd=''; }
		if($sid !=''){ $sidd ="and 	service_id='$sid'"; }else{	$sidd=''; }
		if($mof !='' && $mot=='')
		{
			$moff="and months_value='$mof'";
			$mott='';
		}
		else if($mof =='' && $mot !='')
		{
			$mott="and months_value='$mot'";
			$moff='';
		}
		else if($mof !='' && $mot !='')
		{
				$mott="and months_value BETWEEN '$mof' AND '$mot'";
			    $moff='';
		}
		else
		{
			$moff='';
			$mott='';
		}
		
		if($kyd !=''){ $kydd ="and keywods like '%$kyd%'"; }else{	$kydd=''; }

$str = "SELECT * FROM $table WHERE 1=1 $uidd $sidd $moff $mott $kydd order by months_value desc";
	}
	$rslt=mysqli_query($GLOBALS['conn'],$str);
	if(!$rslt)
	{
		echo mysqli_error();
	}
	else
	{
		$GLOBALS['keyw']=$rslt;
	}
}

function line_chart($keyword='tailor made shirts',$year=2020,$type=null)
{	
    mysqli_query($GLOBALS['conn'],"set session sql_mode=''");
 	 $str = "SELECT id,keywods,months_value,SUM(1_week) as '1_week',SUM(2_week) as '2_week',SUM(3_week) as '3_week',SUM(4_week) as '4_week' ,str_to_date(concat(months_value,'-01'),'%Y-%m-%d') as full_date,SUM(1_week+2_week+3_week+4_week) as mnth_data FROM `keyword_ranking` WHERE keywods='".mysqli_real_escape_string($GLOBALS['conn'],$keyword)."' and year(str_to_date(concat(months_value,'-01'),'%Y-%m-%d'))='".mysqli_real_escape_string($GLOBALS['conn'],$year)."' GROUP by month(full_date),year(full_date) order by  month(full_date),year(full_date)";
	return mysqli_query($GLOBALS['conn'],$str);

}

function gkeywords_list()
{	
   
 	 $str = "SELECT distinct keywods from keyword_ranking order by keywods";
	return mysqli_query($GLOBALS['conn'],$str);

}

${this.title}

Code Editor : function.php