Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
download.php	2.49 KB	-rwxr-xr-x	2023-04-13 09:15
index.php	132 B	-rwxr-xr-x	2021-01-31 22:48
pr.php	1.19 KB	-rwxr-xr-x	2021-01-31 22:48
product.php	2.1 KB	-rwxr-xr-x	2021-01-31 22:51
product_OLD.php	2.48 KB	-rwxr-xr-x	2023-04-13 09:15
product_customer_price.php	964 B	-rwxr-xr-x	2021-01-31 22:51
product_virtual.php	3.85 KB	-rwxr-xr-x	2021-01-31 22:48
product_visibility.php	3.17 KB	-rwxr-xr-x	2021-01-31 22:48

Rename

<?php
if(isset($_GET)) {
    $ref = null;
    $dolapikey = null;
    
    if(isset($_GET['ref'])) {
        $ref = $_GET['ref'];
    }
    if(isset($_GET['DOLAPIKEY'])) {
        $dolapikey = $_GET['DOLAPIKEY'];
    }
        if($dolapikey == null) {
        echo 'no_credentials';
        return;
    }
    if($ref == null) {
        echo 'no_ref';
        return;
    }

if (strpos($ref, '0') === 0) {
        $newref=$ref;        
    }else{
        $newref=str_pad($ref, 8, "0", STR_PAD_LEFT);
    }

$db = new PDO("mysql:host=localhost; dbname=asiafood_v12.0.4", "lamp", "Vo4nMSdkSAah");
    //$query = "SELECT * FROM llx_ecm_files WHERE filepath = 'produit/".$newref."' and gen_or_uploaded='uploaded' order by `rowid` DESC";
    $query = "SELECT * FROM llx_ecm_files WHERE filepath = 'produit/".$newref."' and (`filename` like '%jpg' or `filename` like '%jpeg' or `filename` like '%png')";
    $stmt = $db->query($query);
    $ecmFiles = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $picFile = $ecmFiles[0];
    if($picFile['filename']){
        $original_file = $newref."/".$picFile['filename'];
        $file_name='../../documents/produit/'.$original_file;
        //echo $file_name;
        header('content-type: image/jpg');
        readfile($file_name);
    }else{
        $query2 = "SELECT * FROM llx_ecm_files WHERE filepath = 'produit/".$ref."' and (`filename` like '%jpg' or `filename` like '%jpeg' or `filename` like '%png')";
        $stmt2 = $db->query($query2);
        $ecmFiles2 = $stmt2->fetchAll(PDO::FETCH_ASSOC);
        $picFile2 = $ecmFiles2[0];
        $original_file2 = $ref."/".$picFile2['filename'];
        $file_name2='../../documents/produit/'.$original_file2;
        //echo $file_name2;
        header('content-type: image/jpg');
        readfile($file_name2);
    }

//UPDATE `llx_ecm_files` SET `gen_or_uploaded` = 'uploaded' WHERE `llx_ecm_files`.`gen_or_uploaded` is null and `llx_ecm_files`.`filepath` like 'produit/%' and `llx_ecm_files`.`filename` like '%.jpg' or `llx_ecm_files`.`filename` like '%.jpeg' or `llx_ecm_files`.`filename` like '%.png'
}