Warning: include_once(C:/Inetpub/vhosts/dermatina100.gr/httpdocs/wp-content/plugins/wp-super-cache/wp-cache-phase1.php): Failed to open stream: No such file or directory in C:\Inetpub\vhosts\dermatina100.gr\httpdocs\wp-content\advanced-cache.php on line 22

Warning: include_once(): Failed opening 'C:/Inetpub/vhosts/dermatina100.gr/httpdocs/wp-content/plugins/wp-super-cache/wp-cache-phase1.php' for inclusion (include_path='.;.\includes;.\pear') in C:\Inetpub\vhosts\dermatina100.gr\httpdocs\wp-content\advanced-cache.php on line 22

SHELL BYPASS VERSION

Current Path: C: / Inetpub / vhosts / dermatina100.gr / httpdocs / Fres /

Editing: FresProducts.php

<?php
////Step2: Send list of recomended products to FresProducts WS to get only published products and get their details

//error_reporting(E_ALL);
//ini_set("display_errors", 1);
function xmlentities($string) {
    return str_replace(array("&", "<", ">", "\"", "'"),
        array("&amp;", "&lt;", "&gt;", "&quot;", "&apos;"), $string);
}

function getDiscountPrice($discountID, $price){
	if ($discountID==7) 
		return $price*0.7; //discount 30%
	else if ($discountID==8) 
		return $price*0.5; //discount 50%
	else if ($discountID==9) 
		return $price*0.8; //discount 20%
	else return $price; 
}

$dbhost = 'localhost';
$dbuser = 'derma3dba';
$dbpass = 'c@retta!';
$eshop_url = 'https://www.dermatina100.gr';
$dbname = 'derma2020db';

$manufacturer ='Leather 100';
$shipping='5.00';
$free_shipping = 40.00;
$conn = mysqli_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

function getCategoryDiscountID($ProductID,$con)
{

$sql = "SELECT virtuemart_calc_id as calcID FROM jos2_virtuemart_calc_categories 
				where virtuemart_category_id in (
				select virtuemart_category_id
				from jos2_virtuemart_product_categories
				where virtuemart_product_id = ".$ProductID.")";
	$result = mysqli_query($con,"SET NAMES utf8");
	$result = mysqli_query($con,$sql) or die ( mysqli_error($con) );
	$res = 0;
	while ($line = mysqli_fetch_assoc($result)) {
		$res = $line["calcID"];
		//if ($res != "0")		
		  // break;
	}
	return $res;
}

function getCategoriesPath($catid,$con) {
	$sql = "select cc.category_parent_id as id ,cgr.category_name as catname from  
	jos2_virtuemart_category_categories cc,
	jos2_virtuemart_categories_el_gr cgr 
	where  cc.category_child_id = cgr.virtuemart_category_id 
	and cgr.virtuemart_category_id = ".$catid;
	$result = mysqli_query($con,"SET NAMES utf8");
	$result = mysqli_query($con,$sql) or die ( mysqli_error($con) );
	while ($line = mysqli_fetch_assoc($result)) {
		$res = $line["catname"];
		if ($line["id"] != "193") //id of the root category in order to exclude its name
			$res = getCategoriesPath($line["id"],$con)." &gt; ".$res;
		break;
	}
	return $res;

}

function getProductFullImage($prodid,$con){
	    $sql = "select medias.file_url  AS fullimage 
			from jos2_virtuemart_products prod, jos2_virtuemart_medias medias,jos2_virtuemart_product_medias pr_medias 
			where medias.virtuemart_media_id = pr_medias.virtuemart_media_id
			and pr_medias.virtuemart_product_id = prod.virtuemart_product_id
			and prod.virtuemart_product_id = ".$prodid." 
			order by pr_medias.ordering ";
		$result = mysqli_query($con,"SET NAMES utf8");
	    $result = mysqli_query($con,$sql) or die ( mysqli_error($con) );
		//$res = array();
		$i=0;
		while ($line = mysqli_fetch_assoc($result)) {
			$res[$i] = $line["fullimage"];
			$i++;
		}
		return $res;

}

function getProductSizesold($prodid,$con){
	    $sql = "SELECT f.customfield_value as pSize  
                FROM jos2_virtuemart_customs c, jos2_virtuemart_product_customfields f 
                where c.virtuemart_custom_id = f.virtuemart_custom_id and (f.virtuemart_custom_id = 33 or f.virtuemart_custom_id = 37) 
                and f.virtuemart_product_id =" .$prodid;

$result = mysqli_query("SET NAMES utf8");
	    $result = mysqli_query($con,$sql) or die ( mysqli_error($con) );
		$res = "";
		while ($line = mysqli_fetch_assoc($result)) {
			$res .= $line["pSize"].",";			
		}
		return rtrim($res, ",");

}

function getProductSizes($prodid,$con){
	    $sql = "SELECT customfield_value FROM jos2_virtuemart_product_customfields
					where virtuemart_custom_id = 44 and virtuemart_product_id = " .$prodid;

$result = mysqli_query($con,"SET NAMES utf8");
	    $result = mysqli_query($con,$sql) or die ( mysqli_error($con) );
		$res = "";
		while ($line = mysqli_fetch_assoc($result)) {
			if (is_numeric($line["customfield_value"]))
				$res .= "EU ".$line["customfield_value"].",";	
			else
				$res .= $line["customfield_value"].",";			
		}
		return rtrim($res, ",");

}

function getProductColor($prodid,$con){
	    $sql = "SELECT customfield_value FROM jos2_virtuemart_product_customfields
					where virtuemart_custom_id = 46 and virtuemart_product_id = " .$prodid;

$result = mysqli_query($con,"SET NAMES utf8");
	    $result = mysqli_query($con,$sql) or die ( mysqli_error($con) );
		$res = "";
		while ($line = mysqli_fetch_assoc($result)) {
		
				$res .= $line["customfield_value"];			
		}
		return $res;

}

function getProductSizesWithAddedValueOLD($prodid,&$addedprice, &$addedPriceSizes,$con ){
	    $sql = "SELECT f.customfield_value as pSize, f.customfield_price as addedPrice      
                FROM jos2_virtuemart_customs c, jos2_virtuemart_product_customfields f 
                where c.virtuemart_custom_id = f.virtuemart_custom_id and (f.virtuemart_custom_id = 33 or f.virtuemart_custom_id = 37) 
                and f.virtuemart_product_id =" .$prodid;
		//$conn = mysqli_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
		$result = mysqli_query($con ,"SET NAMES utf8");
	    $result = mysqli_query($con ,$sql) or die ( mysqli_error($con ) );
		$res = "";
		while ($line = mysqli_fetch_assoc($result)) {
			if (($line["addedPrice"] == null) || ($line["addedPrice"] ==0))
			   $res .= $line["pSize"].",";
		   else
		   {
			    $addedPriceSizes .= $line["pSize"].","; 
				$addedprice = $line["addedPrice"];
		   }
		}
		$addedPriceSizes = rtrim($addedPriceSizes, ","); 
		return rtrim($res, ",");

}

if(isset($_GET["ProductsList"])){ 
	mysqli_select_db($conn ,$dbname);
	// No discount 
	$sql = "SELECT prod.virtuemart_product_id  AS product_id, 
		   p.product_name AS product_name,
		   c.virtuemart_category_id AS category_id, 
		   prod.product_sku AS product_sku,
		   ca.category_name AS category_name, 
		   medias.file_url  AS fullimage,
		   medias.file_url_thumb AS thumbimage, 
		   p.product_desc As description,
		   price.product_price As pr_price,
		   prod.product_availability as availability,
		   price.product_discount_id as discountID
	FROM jos2_virtuemart_products_el_gr p, 
	jos2_virtuemart_product_categories c, 
	jos2_virtuemart_categories_el_gr ca, 
	jos2_virtuemart_product_prices price,
	jos2_virtuemart_products prod,
	jos2_virtuemart_medias medias,
	jos2_virtuemart_product_medias pr_medias
	where prod.virtuemart_product_id = p.virtuemart_product_id 
	and prod.virtuemart_product_id  = c.virtuemart_product_id
	and c.virtuemart_category_id = ca.virtuemart_category_id
	and price.virtuemart_product_id = prod.virtuemart_product_id 
	and medias.virtuemart_media_id = pr_medias.virtuemart_media_id
	and pr_medias.virtuemart_product_id = prod.virtuemart_product_id
	and prod.product_parent_id=0
	and prod.published = 1
	and c.virtuemart_category_id<>250 and price.virtuemart_shoppergroup_id <> 3  and price.virtuemart_shoppergroup_id <> 8 "; // Russian Market 
	$sql .= " and prod.virtuemart_product_id in (".$_GET["ProductsList"].") ";

$result = mysqli_query($conn ,"SET NAMES utf8");
	$result = mysqli_query($conn ,$sql) or die ( mysqli_error($conn ) );
	$myD = getdate();
	$jsonResp = '{"Products": [';
	
	$previous_id = "";
	$count=0;
	while ($line = mysqli_fetch_assoc($result) ) {
		if ($previous_id !=$line['product_id']){
			$addedprice = 0;
			
			$prodSizes = getProductSizes($line['product_id'],$conn);
			$prodColor = getProductColor($line['product_id'],$conn);
			$previous_id =$line['product_id'];
			$count++;
			$jsonResp .= '{"ID":"'.$line['product_id'].'",'; // ProductID 
			$jsonResp .= '"Name":"' . xmlentities($line['product_name']) . '",'; // ProductName 
			$jsonResp .= '"URL":"'.$eshop_url.'/index.php?option=com_virtuemart&view=productdetails&virtuemart_category_id='; // URL			
			$jsonResp .= $line['category_id']."&virtuemart_product_id=".$line['product_id'].'",';
			if ($line['discountID']!='0') // Price
				$jsonResp .= '"Price":"'.getDiscountPrice($line['discountID'], $line['pr_price']).'",';
			else {
				$CategoryDiscountID = getCategoryDiscountID($line['product_id'],$conn);
				$jsonResp .= '"Price":"'.getDiscountPrice($CategoryDiscountID, $line['pr_price']).'",';
			
			}
			$fullimage = getProductFullImage($line['product_id'],$conn); // Image
			$jsonResp .=  '"Image":"'.$eshop_url."/".$fullimage[0]. '"';
			$jsonResp .=  '},';
			
		}

}
	$jsonResp = rtrim($jsonResp, ",");
	$jsonResp .= ']}';
	echo $jsonResp;
	
}

[ BATAL ]

Name	Size	Perm	Action
[ .. ] KE ATAS
FresAPI.log.txt	378594 B	666	[Edit] \| [Del] \|
FresAPI.php	1665 B	666	[Edit] \| [Del] \|
FresFeedOnProductSelect.log.txt	4378 B	666	[Edit] \| [Del] \|
FresFeedOnProductSelect.php	1481 B	666	[Edit] \| [Del] \|
FresFeedOnProductShow.log.txt	27049 B	666	[Edit] \| [Del] \|
FresFeedOnProductShow.php	2291 B	666	[Edit] \| [Del] \|
FresProducts.php	8627 B	666	[Edit] \| [Del] \|
FresRecomend.log.txt	19797017 B	666	[Edit] \| [Del] \|
FresRecomend.php	1679 B	666	[Edit] \| [Del] \|
FresVMAPI.php	8726 B	666	[Edit] \| [Del] \|
LiveProductFeed.php	7345 B	666	[Edit] \| [Del] \|
ProductSizes.php	1416 B	666	[Edit] \| [Del] \|
SimilarColors.php	2133 B	666	[Edit] \| [Del] \|
fres.php	2019 B	666	[Edit] \| [Del] \|

      Terminal CMD (Multi-Bypass):

      $