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":"';
if ($_GET['venue']=='only'){$query_select="SELECT DISTINCT venue,latitude,longitude FROM `".$prefix."jem_venues`
WHERE latitude<>0 AND longitude<>0 AND published=1";}else{$query_select="SELECT DISTINCT e.title,e.dates,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 e.dates>='".date('Y-m-d')."' AND v.latitude<>0 AND v.longitude<>0";}
foreach($pdo->query($query_select) as $LieuxEtEvenements){
$i++;$custompin='';
$pin='#pin'.$i.'{('.$LieuxEtEvenements[latitude].','.$LieuxEtEvenements[longitude].'),'.$custompin.',{#pin'.$i.',click}};';
if ($_GET['venue']=='only'){$popups=''.$LieuxEtEvenements[venue].'
';}else{$popups=''.date("j M Y",strtotime($LieuxEtEvenements[dates])).' : '.$LieuxEtEvenements[title].'
'.$LieuxEtEvenements[venue].'
';}
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;//echo '--'.$PinLatitude[$key+1]['increment'].'
';
$PinLatitude[$key+1]['popup'].=$popups;//echo '--'.$PinLatitude[$key+1]['popup'].'
';
}
$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 `module`='mod_osmod' AND id=".$id.";") 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.'
';//.$ajoutParam;
$query=$pdo->prepare("UPDATE ".$prefix."modules SET params=:params WHERE `module`='mod_osmod' AND id=".$id.";");
$query->execute(array('params'=>$NewParamsModule));
print_r($latitude);
} else {
print 'configuration.php file of Joomla not found.';
} // if (file_exists('configuration.php'))
?>