/**
* Constructeur de bbCodeObject
*
* @param array $params Param�tres
*
* @return void
* */
function __construct($params = array())
{
parent::__construct();
if (!in_array('noPEAR', $params)) {
$config = parse_ini_file('BBCodeParser.ini', true);
$pear = new PEAR();
$options = $pear->getStaticProperty('HTML_BBCodeParser', '_options');
$options = $config['HTML_BBCodeParser'];
$this->parserBB = new HTML_BBCodeParser2($options);
}
}
function __construct($connexion = '')
{
parent::__construct();
//
$this->limitSqlDebut = 0;
$this->nbEnregistrementsParPage = 0;
}
function __construct($connexion = '')
{
parent::__construct();
$this->fields = array();
$this->elementsFormulaireMultiPage = array();
$this->identifiantObject = self::$instancesObject;
self::$instancesObject++;
}
function __construct()
{
parent::__construct();
echo "\n\t\t<form action='descImages.php' method='post' enctype='multipart/form-data'>\n\t\t\t<input type='submit' name='submit' value='go'>\n\n\t\t</form>";
if (isset($this->variablesPost['submit']) || isset($this->variablesPost['Suivant'])) {
$this->doMoulinette();
}
}
function __construct()
{
parent::__construct();
//$this->connex = $this->connexionBdd;
$connect0 = mysql_connect("localhost", "archiv2", "fd89ind") or die("probleme connexion0");
$connect = mysql_connect("localhost", "archiv2", "fd89ind", true) or die("probleme connexion");
mysql_select_db("ARCHI_V2", $connect0) or die("select db archiv2");
mysql_select_db("archi_old", $connect) or die("select db archiold");
$this->connectOLD = $connect;
$this->connectNEW = $connect0;
}
function __construct($params = array())
{
parent::__construct();
if (isset($params['idPopup'])) {
$this->idPopup = $params['idPopup'];
} else {
$this->idPopup = 'popupDefaultId';
}
if (isset($params['urlImageAideIllustration'])) {
$this->urlImageIllustration = $params['urlImageAideIllustration'];
} else {
$this->urlImageIllustration = "images/aide.jpg";
}
}
ini_set('max_execution_time', 0);
require 'PEAR.php';
require 'HTML/BBCodeParser.php';
//include('/home/pia/archiv2/includes/framework/config.class.php');
$borneMin = "NOW()";
$borneMax = "SUBDATE(NOW(), INTERVAL 7 DAY)";
//$borneMin = "SUBDATE(NOW(),INTERVAL 7 DAY)";
//$borneMax = "SUBDATE(NOW(), INTERVAL 14 DAY)";
// include('/home/pia/archiv2/includes/framework/config.class.php');
require __DIR__ . '/../includes/framework/config.class.php';
// include_once('/home/pia/archiv2/modules/archi/includes/archiAdresse.class.php');
require_once __DIR__ . '/../modules/archi/includes/archiAdresse.class.php';
// include_once('/home/pia/archiv2/modules/archi/includes/archiEvenement.class.php');
require_once __DIR__ . '/../modules/archi/includes/archiEvenement.class.php';
require_once __DIR__ . '/../modules/archi/includes/archiPersonne.class.php';
$config = new ArchiConfig();
// on recherche que les adresses un evenement est associe
$reqNouvellesAdressesDeLaSemaine = "\n SELECT ha1.idAdresse as idAdresse, count(ee.idEvenementAssocie),ha1.date as date, v.nom as nomVille, ae.idEvenement as idEvenementGroupeAdresse\n FROM historiqueAdresse ha2, historiqueAdresse ha1\n\n LEFT JOIN _adresseEvenement ae ON ae.idAdresse = ha1.idAdresse\n LEFT JOIN _evenementEvenement ee ON ee.idEvenement = ae.idEvenement\n LEFT JOIN historiqueEvenement he ON he.idEvenement = ae.idEvenement\n\n\n LEFT JOIN rue r ON r.idRue = ha1.idRue\n LEFT JOIN sousQuartier sq ON sq.idSousQuartier = IF(ha1.idRue='0' and ha1.idSousQuartier!='0' ,ha1.idSousQuartier ,r.idSousQuartier )\n LEFT JOIN quartier q ON q.idQuartier = IF(ha1.idRue='0' and ha1.idSousQuartier='0' and ha1.idQuartier!='0' ,ha1.idQuartier ,sq.idQuartier )\n LEFT JOIN ville v ON v.idVille = IF(ha1.idRue='0' and ha1.idSousQuartier='0' and ha1.idQuartier='0' and ha1.idVille!='0' ,ha1.idVille ,q.idVille )\n LEFT JOIN pays p ON p.idPays = IF(ha1.idRue='0' and ha1.idSousQuartier='0' and ha1.idQuartier='0' and ha1.idVille='0' and ha1.idPays!='0' ,ha1.idPays ,v.idPays )\n\n\n WHERE ha2.idAdresse = ha1.idAdresse\n\n\n AND he.dateCreationEvenement < {$borneMin}\n AND he.dateCreationEvenement >= {$borneMax}\n GROUP BY ha1.idAdresse,ee.idEvenement, ha1.idHistoriqueAdresse\n HAVING ha1.idHistoriqueAdresse = max(ha2.idHistoriqueAdresse) and count(ee.idEvenementAssocie)>0\n ORDER BY nomVille,date\n ";
$resNouvellesAdressesDeLaSemaine = $config->connexionBdd->requete($reqNouvellesAdressesDeLaSemaine);
$a = new archiAdresse();
$e = new archiEvenement();
$arrayAdresses = array();
$arrayListeAdresses = array();
// contient la liste des adresses pour ne pas afficher la meme adresse dans la liste des adresse modifiees
$arrayGroupeEvenements = array();
while ($fetchNouvellesAdresses = mysql_fetch_assoc($resNouvellesAdressesDeLaSemaine)) {
$arrayListeAdresses[] = $fetchNouvellesAdresses['idAdresse'];
//$resEvenementGroupeAdresse = $a->getIdEvenementGroupeAdresseFromAdresse($fetchNouvellesAdresses['idAdresse']);
//$idEvenementGroupeAdresse = mysql_fetch_assoc($resEvenementGroupeAdresse);
if (!in_array($fetchNouvellesAdresses['idEvenementGroupeAdresse'], $arrayGroupeEvenements)) {
$arrayGroupeEvenements[] = $fetchNouvellesAdresses['idEvenementGroupeAdresse'];
function __construct($identifiantUniqueMenu = "0")
{
parent::__construct();
$this->listeElems = array();
$this->identifiantUniqueMenu = $identifiantUniqueMenu;
}
public function __construct($idEvenement = null)
{
$this->idEvenement = $idEvenement;
parent::__construct();
}
}
}
}
$htmlHeader = ob_get_contents();
ob_end_clean();
if (!isset($_GET['noHTMLHeaderFooter'])) {
if (!isset($_GET["noHeaderNoFooter"]) && !isset($_POST["noHeaderNoFooter"])) {
if (ArchiConfig::getJsFooter() != '') {
$footerJS = ArchiConfig::getJsFooter();
}
include 'modules/footer/index.php';
$footerAndHeader['footer'] = $footer;
} else {
$footerJS = "";
if (ArchiConfig::getJsFooter() != '') {
$footerJS = ArchiConfig::getJsFooter();
}
if (!isset($config->isSiteLocal) || $config->isSiteLocal == false) {
$analyticsJSvar = "<script type='text/javascript' src='js/analytics.js'></script>";
}
$footerAndHeader['footer'] = "</body>\n </html>";
}
}
$t = new Template('modules/archi/templates/general/');
$t->set_filenames(array('template' => 'template.tpl'));
$ajaxObj = new ajaxObject();
$t->assign_vars(array('ajaxFunctions' => $ajaxObj->getAjaxFunctions(), 'headerJS' => $headerJS, 'analyticsJS' => $analyticsJSvar, 'htmlHeader' => $htmlHeader, 'htmlModule' => $htmlModule, 'content' => ''));
$t->assign_vars($footerAndHeader);
ob_start();
$t->pparse('template');
$page = ob_get_contents();
function __construct($params = array())
{
parent::__construct();
}
<?php
//session_start();
include "includes/framework/config.class.php";
$config = new ArchiConfig();
$idImage = $_GET['idImage'];
$idEvenementGroupeAdresse = $_GET['idEvenementGroupeAdresse'];
$idAdresseCourante = $_GET['idAdresseCourante'];
$idHistoriqueImage = $_GET['idHistorique'];
$dateUpload = $_GET['date'];
$sqlWhere = "";
if ($idAdresseCourante != 0 && $idAdresseCourante != '') {
//$sqlWhere .= " AND idAdresse='$idAdresseCourante' ";
}
$erreur = false;
if ($idEvenementGroupeAdresse != 0 && $idEvenementGroupeAdresse != '' && $idImage != 0 && $idImage != '') {
// recuperation de la zone concernée de l'image sur laquelle on va effectuer le zoom
// en principe si on fait un appel a ce fichier pour afficher le zoom , c'est que le test sur la zone a ete effectué , et la zone existe bien
$req = "\n\tSELECT coordonneesZoneImage, largeurBaseZoneImage, longueurBaseZoneImage\n\tFROM _adresseImage ai\n\tWHERE idImage = '" . $idImage . "'\n\tAND idEvenementGroupeAdresse = '" . $idEvenementGroupeAdresse . "'\n\tAND vueSur='1'\n\t{$sqlWhere}\n\t";
$res = $config->connexionBdd->requete($req);
if (mysql_num_rows($res) > 0) {
$fetch = mysql_fetch_assoc($res);
$originalSizes = getimagesize($config->getCheminPhysiqueImage("originaux") . $dateUpload . "/" . $idHistoriqueImage . ".jpg");
$originalWidth = $originalSizes[0];
$originalHeight = $originalSizes[1];
$originalPhysique = $config->getCheminPhysiqueImage("originaux") . $dateUpload . "/" . $idHistoriqueImage . ".jpg";
$largeurBase = $fetch['largeurBaseZoneImage'];
$longueurBase = $fetch['longueurBaseZoneImage'];
$rapport = $originalHeight / $longueurBase;
list($x1, $y1, $x2, $y2) = explode(",", $fetch['coordonneesZoneImage']);
$largeurZone = abs($x2 - $x1);
/**
* Constructeur de la classe GoogleMap
*
* @param array $params Paramètres
*
* @return void
* */
function __construct($params = array())
{
$this->noDisplayZoomSelectionSquare = false;
$this->noDisplayZoomSlider = false;
$this->zoomType = '';
$this->noDisplayEchelle = false;
$this->noDisplayMapTypeButtons = false;
parent::__construct();
if (isset($params['googleMapNameId']) && $params['googleMapNameId'] != '') {
$this->googleMapNameId = $params['googleMapNameId'];
} else {
$this->googleMapNameId = 'divMap';
}
if (isset($params['mapType']) && $params['mapType'] != '') {
$this->mapType = $params['mapType'];
} else {
$this->mapType = '';
}
if (isset($params['height']) && $params['height'] != '') {
$this->googleMapHeight = $params['height'];
} else {
$this->googleMapHeight = '300';
}
if (isset($params['divStyle']) && $params['divStyle'] != '') {
$this->divStyle = $params['divStyle'];
} else {
$this->divStyle = '';
}
if (isset($params['width']) && $params['width'] != '') {
$this->googleMapWidth = $params['width'];
} else {
$this->googleMapWidth = '500';
}
if (isset($params['setOnClickType']) && $params['setOnClickType'] != '') {
$this->markerOnClickType = $params['setOnClickType'];
} else {
$this->markerOnClickType = 'link';
}
if (isset($params['setTimeOutPaquets']) && $params['setTimeOutPaquets'] != '') {
$this->setTimeOutPaquets = $params['setTimeOutPaquets'];
} else {
$this->setTimeOutPaquets = 5000;
}
if (isset($params['debugMode']) && $params['debugMode'] == true) {
$this->debugMode = true;
} else {
$this->debugMode = false;
}
if (isset($params['zoom']) && $params['zoom'] != '') {
$this->googleMapZoom = $params['zoom'];
} else {
$this->googleMapZoom = 10;
}
if (isset($params['noDisplayZoomSelectionSquare']) && $params['noDisplayZoomSelectionSquare'] == true) {
$this->noDisplayZoomSelectionSquare = true;
}
if (isset($params['noDisplayZoomSlider']) && $params['noDisplayZoomSlider'] == true) {
$this->noDisplayZoomSlider = true;
}
if (isset($params['noDisplayEchelle']) && $params['noDisplayEchelle'] == true) {
$this->noDisplayEchelle = true;
}
if (isset($params['noDisplayMapTypeButtons']) && $params['noDisplayMapTypeButtons'] == true) {
$this->noDisplayMapTypeButtons = true;
}
if (isset($params['zoomType']) && $params['zoomType'] != '') {
$this->zoomType = $params['zoomType'];
}
if (isset($params['centerLong']) && isset($params['centerLat'])) {
$this->centerLong = $params['centerLong'];
$this->centerLat = $params['centerLat'];
} else {
$this->centerLong = "7.7400";
// on centre sur strasbourg par defaut
$this->centerLat = "48.585000";
}
$this->googleMapKeyProperty = $params['googleMapKey'];
$this->coordonnees = array();
}
* @link http://archi-wiki.org/
* */
mb_internal_encoding("UTF-8");
mb_regex_encoding("UTF-8");
ini_set('max_execution_time', 0);
require_once 'PEAR.php';
require_once 'HTML/BBCodeParser.php';
//include('/home/pia/archiv2/includes/framework/config.class.php');
//$borneMin = "NOW()";
//$borneMax = "SUBDATE(NOW(), INTERVAL 7 DAY)";
//$borneMin = "SUBDATE(NOW(), INTERVAL 7 DAY)";
//$borneMax = "SUBDATE(NOW(), INTERVAL 14 DAY)";
require_once __DIR__ . '/../includes/framework/config.class.php';
require_once __DIR__ . '/../modules/archi/includes/archiAdresse.class.php';
require_once __DIR__ . '/../modules/archi/includes/archiEvenement.class.php';
$config = new ArchiConfig();
$d = new dateObject();
$mail = new mailObject();
$idPeriode = "";
if (isset($argv[1]) && $argv[1] != '' || isset($_GET['idPeriode']) && $_GET['idPeriode'] != '') {
if (isset($argv[1]) && $argv[1] != '' && $argv[1] != '0' && $argv[1] != '1') {
$idPeriode = trim($argv[1]);
}
if (isset($_GET['idPeriode']) && $_GET['idPeriode'] != '' && $_GET['idPeriode'] != '0' && $_GET['idPeriode'] != '1') {
$idPeriode = $_GET['idPeriode'];
}
// recuperation des mails
// on envoi aussi au personnes qui ont une periode immediate 0 ou 1, car s'ils y a des messages regroupés en attente pour eux , ca veut dire qu'ils on changé la periode entre temps (cela sert de purge)
$req = "\n SELECT m.idMail as idMail, m.dateHeure as dateHeure, m.idUtilisateur as idUtilisateur, m.contenu as contenu, m.idTypeMailRegroupement as idTypeMailRegroupement\n FROM mailsEnvoiMailsRegroupes m\n LEFT JOIN utilisateur u ON u.idUtilisateur = m.idUtilisateur\n WHERE\n (u.idPeriodeEnvoiMailsRegroupes = '" . $idPeriode . "'\n OR u.idPeriodeEnvoiMailsRegroupes='1'\n OR u.idPeriodeEnvoiMailsRegroupes='0')\n\n ORDER BY m.dateHeure DESC\n ";
//AND u.idUtilisateur='30'
$res = $config->connexionBdd->requete($req);
/**
* Constructeur de mailObject
*
* @param string $connexion Connexion
*
* @return void
* */
function __construct($connexion = '')
{
parent::__construct();
//
}
function __construct()
{
parent::__construct();
$this->repertoire = $this->cheminPhysique . '/cache/';
$this->fichierCourant = 'default';
}
/**
* Constructeur de archiAuthentification
*
* @return void
* */
function __construct()
{
parent::__construct();
$this->login = "";
$this->motDePasse = "";
}
function __construct()
{
parent::__construct();
$this->tabImages = array();
}
/**
* Valide les commentaires grace à un identifiant unique
*
* PHP Version 5.3.3
*
* @category Script
* @package ArchiWiki
* @author Pierre Rudloff <*****@*****.**>
* @license GNU GPL v3 https://www.gnu.org/licenses/gpl.html
* @link http://archi-wiki.org/
* */
require_once __DIR__ . '/../includes/framework/config.class.php';
require_once __DIR__ . '/../modules/archi/includes/archiUtilisateur.class.php';
require_once __DIR__ . '/../modules/archi/includes/archiAdresse.class.php';
require_once __DIR__ . '/../modules/archi/includes/archiAuthentification.class.php';
$config = new ArchiConfig();
$req = "UPDATE commentaires SET CommentaireValide=1 WHERE uniqid='" . mysql_real_escape_string($_GET['uniqid']) . "';";
$res = $config->connexionBdd->requete($req);
$req = "SELECT nom, prenom, email, commentaire, idEvenementGroupeAdresse FROM commentaires WHERE uniqid='" . mysql_real_escape_string($_GET['uniqid']) . "';";
$res = $config->connexionBdd->requete($req);
$fetch = mysql_fetch_assoc($res);
if ($fetch) {
$u = new archiUtilisateur();
$a = new archiAdresse();
$idAdresse = $a->getIdAdresseFromIdEvenementGroupeAdresse($fetch['idEvenementGroupeAdresse']);
$intituleAdresse = $a->getIntituleAdresseFrom($idAdresse, 'idAdresse');
$message = "Un utilisateur a ajouté un commentaire sur archiV2 : <br>";
$message .= "nom ou pseudo : " . strip_tags($fetch['nom']) . "<br>";
$message .= "prenom : " . strip_tags($fetch['prenom']) . "<br>";
$message .= "email : " . strip_tags($fetch['email']) . "<br>";
$message .= "commentaire : " . stripslashes(strip_tags($fetch['commentaire'])) . "<br>";
function __construct()
{
parent::__construct();
$this->connexion = $this->connexionBdd;
}
function __construct()
{
parent::__construct();
$this->microTime = 0;
}
/**
* Constructeur d'ArchiAccueil
*
* @return void
* */
function __construct()
{
parent::__construct();
}
function __construct()
{
$auth = new archiAuthentification();
$this->userId = $auth->getIdUtilisateur();
parent::__construct();
}
* Charge le template de l'en-tête
*
* PHP Version 5.3.3
*
* @category General
* @package ArchiWiki
* @author Pierre Rudloff <*****@*****.**>
* @license GNU GPL v3 https://www.gnu.org/licenses/gpl.html
* @link http://archi-wiki.org/
*
* */
$t = new Template('modules/header/templates/');
$t->set_filenames(array('header' => 'header.tpl'));
$authentification = new archiAuthentification();
$recherche = new archiRecherche();
$config = new ArchiConfig();
$adresse = new archiAdresse();
$evenement = new archiEvenement();
$image = new archiImage();
$ajax = new ajaxObject();
$calque = new calqueObject();
$string = new stringObject();
$utilisateur = new archiUtilisateur();
$session = new objetSession();
$i = new imageObject();
if (!isset($jsHeader)) {
// variables récupérée de chaque fonction des classes du site permettant de mettre du javascript recupéré , dans le header , plutot qu'en plein milieu de la page ou dans le bas de page s'il faut qu'il soit executé a la fin
$jsHeader = "";
}
if (!isset($jsFooter)) {
$jsFooter = "";
/**
* Constructeyr d'ArchiStatic
*
* @return void
* */
function __construct()
{
$this->arrayUrlVersion = array(array('url' => $this->creerUrl('', 'quiSommesNousArchiStrasbourg', array()), 'label' => "2012 - Qui Sommes nous Archi-Strasbourg"), array('url' => $this->creerUrl('', 'quiSommesNousCreationAssociation', array()), 'label' => "2011 - Qui Sommes nous création association"), array('url' => $this->creerUrl('', 'quiSommesNousContributeurs', array()), 'label' => "2010 - Qui Sommes nous avec les contributeurs"), array('url' => $this->creerUrl('', 'quiSommesNousLaurent', array()), 'label' => "2009 - Qui Sommes nous avec Laurent Dorer"));
parent::__construct();
}
/**
* Paramètres du site
*
* PHP Version 5.3.3
*
* @category General
* @package ArchiWiki
* @author Pierre Rudloff <*****@*****.**>
* @license GNU GPL v3 https://www.gnu.org/licenses/gpl.html
* @link http://archi-wiki.org/
*
* */
header("Content-Type: application/rss+xml");
require_once "includes/framework/config.class.php";
require_once "includes/framework/localization.php";
$config = new ArchiConfig();
echo "<?xml version='1.0' encoding='utf-8'?>" . PHP_EOL;
?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
<?php
$adresse = new archiAdresse();
$last = $adresse->getDerniersEvenementsParCategorie(5);
//print_r($last);
//dernieresAdresses, constructions, demolitions, actualites, culture, vues
$type = isset($_GET["type"]) ? $_GET["type"] : "actualites";
echo "<atom:link href='" . $config->getUrlRacine() . "rss.php?type=" . $type . "' rel='self' type='application/rss+xml' />";
switch ($type) {
case "dernieresAdresses":
$feedDesc = _("Nouvelles adresses");
break;
function __construct($idImage = null)
{
$this->idImage = $idImage;
parent::__construct();
}
