<?php
//programmé pour fonctionner avec OsModul : https://github.com/Schlumpf/osmodul/wiki/How-to-use
   if (file_exists('configuration.php')) {
      require_once('configuration.php');
      $config = new JConfig();$prefix=$config->dbprefix;try {
    $strConnection = 'mysql:host='.$config->host.';dbname='.$config->db;
    $arrExtraParam= array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
    $pdo = new PDO($strConnection, $config->user, $config->password, $arrExtraParam);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e) {
    $msg = 'ERREUR PDO dans ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage();
    die($msg);
}$latitude=Array();$pin='"pins":"';$popups='","popups":"';
foreach($pdo->query("SELECT DISTINCT v.venue,v.latitude,v.longitude FROM `".$prefix."jem_events` as e
LEFT JOIN ".$prefix."jem_venues as v ON e.locid = v.id
WHERE v.latitude<>0 AND v.longitude<>0") as $LieuxEtEvenements){
	
	$i++;$custompin='';
	$pin='#pin'.$i.'{('.$LieuxEtEvenements[latitude].','.$LieuxEtEvenements[longitude].'),'.$custompin.',{#pin'.$i.',click}};';
	//$popups='<p>'.date("j. M Y",strtotime($LieuxEtEvenements[dates])).' : <b>'.$LieuxEtEvenements[title].'</b><br />'.$LieuxEtEvenements[venue].'</p>';
	$popups='<p>'.$LieuxEtEvenements[venue].'</p>';

	if(!in_array($LieuxEtEvenements[latitude],$latitude)){$PinLatitudeTemp=array('latitude'=>$LieuxEtEvenements[latitude],'increment'=>1,'pin'=>$pin,'popup'=>'#pin'.$i.'{'.$popups);$PinLatitude[$i]=$PinLatitudeTemp;
		}else{
			$key=array_search($LieuxEtEvenements[latitude], array_column($PinLatitude, 'latitude'));
			$PinLatitude[$key+1]['increment']+=1;
			$PinLatitude[$key+1]['popup'].=$popups;
}
	$latitude[]=$LieuxEtEvenements[latitude];$longitude[]=$LieuxEtEvenements[longitude];
}
$pin='"pins":"';$popups='';
foreach($PinLatitude as $value){
	foreach($value as $key=>$valuetemp){
		if($key=='pin')$pin.=$valuetemp;
		if($key=='popup')$popups.=$valuetemp.'};';
	}
}
$popups=str_replace('"','\"',$popups);
$popups='","popups":"'.$popups;
$ajoutParam=str_replace("'","\u2019",$pin.$popups);/*
$ajoutParam=str_replace("’","\u2019",$ajoutParam);
$ajoutParam=str_replace("ê","\u00ea",$ajoutParam);
$ajoutParam=str_replace("â","\u00e2",$ajoutParam);
$ajoutParam=str_replace("é","\u00e9",$ajoutParam);
$ajoutParam=str_replace("/","\/",$ajoutParam);
//$ajoutParam=str_replace("","",$ajoutParam);
//$ajoutParam=str_replace("","",$ajoutParam);
//$ajoutParam=str_replace("","",$ajoutParam);/**/
foreach($pdo->query("SELECT id,params FROM `".$prefix."modules` WHERE `title`='OSModul' AND id=162;") as $paramsModule){
	$NewParamsModule=$paramsModule[params];
	$start=strpos($NewParamsModule,'"pins"');
	$end=strpos($NewParamsModule,'","moduleclass_sfx"');
	$len=$end-$start;
	//$ajoutParam.='","custompins":"'.$custompins;
	$NewParamsModule=substr_replace($NewParamsModule,$ajoutParam,$start,$len);
}
echo $NewParamsModule.'<br><br>';//.$ajoutParam;
$query=$pdo->prepare("UPDATE ".$prefix."modules SET params=:params WHERE id=162;");
$query->execute(array('params'=>$NewParamsModule));
//print_r($latitude);
   } else {

      print 'configuration.php file of Joomla not found.';

   } // if (file_exists('configuration.php'))
?>