hi thank you for your help
i now have this in my eventmarkers.php :
<?php
/*
* @component com_geommunity3js
* @copyright Copyright (C) 2010-2014 Adrien ROUSSEL Nordmograph.com
* @license GNU/GPL Version 3
* @Website :
www.nordmograph.com/extensions
*/
defined('_JEXEC') or die('Restricted access');
jimport('joomla.application.component.modelitem');
class Geommunity3jsModelEventmarkers extends JModelLegacy
{
protected $markers;
public function getEventmarkers()
{
$db = JFactory::getDBO();
$user = JFactory::getUser();
$jinput = JFactory::getApplication()->input;
$mapid = $jinput->get('mapid');
$a = $swLat = $jinput->get('swLat');
$b = $swLng = $jinput->get('swLng');
$c = $neLat = $jinput->get('neLat');
$d = $neLng = $jinput->get('neLng');
$condition1 = $a < $c ? "latitude BETWEEN $a AND $c":"latitude BETWEEN $c AND $a";
$condition2 = $b < $d ? "longitude BETWEEN $b AND $d":"longitude BETWEEN $d AND $b";
$q ="SELECT id , title , latitude , longitude
FROM #__community_events
WHERE published='1' AND enddate>=NOW()
AND ( $condition1 ) AND ( $condition2 ) ";
$db->setQuery($q);
$markers = $db->loadObjectList();
return $markers;
}
}
But the same problem...