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/public_html/crm

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: cron_update_google_ranking.php

<?php include('db_connection.php'); ?>
<!doctype html>
<html>
  <head>
    <meta name="viewport" content="width=device-width" />
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>Google Ranking Update</title>
 
<?php 
/**
 * This class crawls google and find out on which page a website is lisited, based on the keyword searched.
 *
 * @author Rochak Chauhan <rochakchauhan@gmail.com>
 * @see This class does NOT calculated the Google Page Rank
 */
class PhpKeywordAnalyser {
	private $website="";
	private $keyword="";
	private $url="";
	private $start=0;
	private $page=false;
	private $records=false;

/**
	 * Function to pre process and store the values of Keyword and Website
	 *
	 * @param string $keyword
	 * @param string $website
	 * @return resource
	 */
	public function __construct(){
		
	}

public function initSpider($keyword, $website){
		
		if(trim($keyword)==""){
			trigger_error("Keyword cannot the left blank.",E_USER_ERROR); die();
		}
		if(trim($website)==""){
			trigger_error("Website cannot the left blank.",E_USER_ERROR); die();
		}
		$website=strtolower(trim($website));
		$website=str_replace("http://www.","",$website);
		$website=str_replace("http://","",$website);
		$website=str_replace("www.","",$website);
		$website=str_replace("/","",$website);
	
		$this->website=$website;
		$this->keyword=trim($keyword);
		$this->enableVerbose=$enableVerbose;		
		$this->url=$this->updateUrl($keyword, $this->start);
		
		//echo "<p>Searching: <b>".$this->keyword."</b> and Looking for: <b>".$this->website."</b></p>";
		//echo str_repeat(" ", 256);
		$i=10;
		$c=1;
		while($c<=5) {			
			//echo "<ul><li><b>Searching in Page: $c</b></li>";				
			$records= $this->getRecordsAsArray($this->url); 
			$count=count($records);
			//echo "<ul>";
			for($k=0;$k<$count;$k++){
				$j=$k+1;
				$link=$records[$k][2];
				$link=strip_tags($link);
				$link=str_replace("http://www.","",$link);
				$link=str_replace("http://","",$link);
				$link=str_replace("www.","",$link);
				$pos=strpos($link, "/");
				$link=trim(substr($link,0,$pos));
				
				if($this->website==$link){
					$domain=$this->website;
				//	echo "<li><h1>Result was found in Page: $c and Record: $j</h1></li>";
				//	echo "<div>Congrats, We searched google's top 10 pages for <b>\"".$this->keyword."</b>\", we found your domain <b>\"$domain\"</b> listed on page: $c at $j place </div>";echo "</ul></ul>";
				//	exit;
				return (($c-1)*10)+$j;
				exit;
				}
								
			}
			//echo "</ul></ul>";
			$c++;
			$this->url = $this->updateUrl($this->keyword, $i);
		}
		//echo "Crawled through all 10 pages.";			
		return 0;
				exit;
		
	}
	
	public function initSpiderOrg2($keyword, $website){
		
		if(trim($keyword)==""){
			trigger_error("Keyword cannot the left blank.",E_USER_ERROR); die();
		}
		if(trim($website)==""){
			trigger_error("Website cannot the left blank.",E_USER_ERROR); die();
		}
		$website=strtolower(trim($website));
		$website=str_replace("http://www.","",$website);
		$website=str_replace("http://","",$website);
		$website=str_replace("www.","",$website);
		$website=str_replace("/","",$website);
	
		$this->website=$website;
		$this->keyword=trim($keyword);
		$this->enableVerbose=$enableVerbose;		
		$this->url=$this->updateUrl($keyword, $this->start);
		
		echo "<p>Searching: <b>".$this->keyword."</b> and Looking for: <b>".$this->website."</b></p>";
		echo str_repeat(" ", 256);
		$i=10;
		$c=1;
		while($c<=10) {			
			echo "<ul><li><b>Searching in Page: $c</b></li>";				
			flush();ob_flush();
			$records= $this->getRecordsAsArray($this->url); 
			$count=count($records);
			echo "<ul>";
			for($k=0;$k<$count;$k++){
				$j=$k+1;
				$link=$records[$k][2];
				$link=strip_tags($link);
				$link=str_replace("http://www.","",$link);
				$link=str_replace("http://","",$link);
				$link=str_replace("www.","",$link);
				$pos=strpos($link, "/");
				$link=trim(substr($link,0,$pos));
				
				if($this->website==$link){
					$domain=$this->website;
					echo "<li><h1>Result was found in Page: $c and Record: $j</h1></li>";
					echo "<div>Congrats, We searched google's top 10 pages for <b>\"".$this->keyword."</b>\", we found your domain <b>\"$domain\"</b> listed on page: $c at $j place </div>";echo "</ul></ul>";
					exit;
				}
				else{
					echo "<li>Result not found on Page: $c and Record: $j</li>";
				}				
			}
			echo "</ul></ul>";
			$c++;
			$this->updateUrl($this->keyword, $i);
		}
		echo "Crawled through all 10 pages.";			
		
		if($this->page==false){
			$domain=$this->website;
			$keyword=$this->keyword;
			echo "<div>Sorry, We searched google's top 10 pages for <b>\"$keyword\"</b>, but was unable to find your domain <b>\"$domain\"</b> listed anywhere. </div>";
		}
		else {
			$page=$this->page;
			$records=$this->records;
			$domain=$this->website;
			$keyword=$this->keyword;
			echo "<div>Congrats, We searched google's top 10 pages for <b>\"$keyword\"</b>, we found your domain <b>\"$domain\"</b> listed on page: $page at $record place </div>";
		}
	}
	
	/**
	 * Function to get records as an array.
	 *
	 * @access private
	 * @param string $url
	 *
	 * @return array
	 */
	private function getRecordsAsArray($url){
		$matches=array();
		$pattern='/<div class="s"(.*)\<cite\>(.*)\<\/cite\>/Uis';
		$html=$this->getCodeViaFopen($url);
		preg_match_all($pattern, $html, $matches, PREG_SET_ORDER);
		return $matches;
	}
	
	/**
	 * Function to update the google search query.
	 *
	 * @access private
	 * @param string $keyword
	 * @param string $start
	 *
	 * @return string
	 */
	private function updateUrl($keyword, $start){
		$this->start=$this->start+$start;	
		$keyword=trim($keyword);
		$keyword=urlencode($keyword);
		return "http://www.google.com/search?start=".$this->start."&q=$keyword";
	}

/**
	 * Function to get HTML code from remote url
	 *
	 * @access private
	 * @param string $url
	 *
	 * @return string
	 */
	private function getCodeViaFopen($url){
		$returnStr="";
		$fp=fopen($url, "r") or die("ERROR: Invalid search URL");
		while (!feof($fp)) {
			$returnStr.=fgetc($fp);
		}
		fclose($fp);
		return $returnStr;
	}
}

//echo $report_date = date ("Y-m-d", strtotime("-1 day"));
		 $report_date = date ("Y-m-d");
		//exit;		
		$phpKeywordAnalyser = new PhpKeywordAnalyser();		
		$where              = '';
		$group_by           = 'seo_keyword.ref_client_id';
		$order_by           = 'client.client_name ASC';
		$res_seo_client = getRecords('seo_keyword', $group_by, $order_by);
		
		
								
		if(isset($res_seo_client) && !empty($res_seo_client)){
			foreach($res_seo_client as $key => $val){
				
				$res_website = getDetails('client_website','ref_client_id',$val->ref_client_id);
				$res_keyword = getDetails('seo_keyword','ref_client_id',$val->ref_client_id);
				
				$website_url = '';
				if(isset($res_website) && !empty($res_website)){
					$website_url = $res_website[0]->website_url;
				}
				
				// delete Old Record exist in the same Date
				mysql_query("DELETE FROM seo_keyword_report WHERE seo_keyword_report_date = '".$report_date."' AND ref_client_id = '".$val->ref_client_id."'");
				if(isset($res_keyword) && !empty($res_keyword)){
					foreach($res_keyword as $k => $v){
						if(!empty($website_url) && !empty($v->seo_keyword_name)){
							$phpKeywordAnalyser = new PhpKeywordAnalyser();		
							$position = $phpKeywordAnalyser->initSpider($v->seo_keyword_name, $website_url);
							$sql  = "INSERT INTO seo_keyword_report SET seo_keyword_report_date = '".$report_date."' ,ref_seo_keyword_id = '".$v->seo_keyword_id."' ,ref_client_id = '".$val->ref_client_id."' ,seo_keyword_position = '".$position."',ref_user_id = 1,added_date = '".date('Y-m-d H:i:s')."'";
							$query = mysql_query($sql) or die('Query failed.');
						}
					}
				}
				
			}
		}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: cron_update_google_ranking.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation