/**
* Method to store the venue
*
* @access public
* @return id
* @since 0.9
*/
function store($data, $file)
{
$app =& JFactory::getApplication();
$user =& JFactory::getUser();
$elsettings =& ELHelper::config();
$tzoffset = $app->getCfg('offset');
$row =& JTable::getInstance('eventlist_venues', '');
//bind it to the table
if (!$row->bind($data)) {
JError::raiseError(500, $this->_db->stderr());
return false;
}
//Are we saving from an item edit?
if ($row->id) {
//check if user is allowed to edit venues
$allowedtoeditvenue = ELUser::editaccess($elsettings->venueowner, $row->created_by, $elsettings->venueeditrec, $elsettings->venueedit);
if ($allowedtoeditvenue == 0) {
$row->checkin();
$app->enqueueMessage(JText::_('NO ACCESS'));
return false;
}
$row->modified = gmdate('Y-m-d H:i:s');
$row->modified_by = $user->get('id');
//Is editor the owner of the venue
//This extra Check is needed to make it possible
//that the venue is published after an edit from an owner
if ($elsettings->venueowner == 1 && $row->created_by == $user->get('id')) {
$owneredit = 1;
} else {
$owneredit = 0;
}
} else {
//check if user is allowed to submit new venues
$delloclink = ELUser::validate_user($elsettings->locdelrec, $elsettings->deliverlocsyes);
if ($delloclink == 0) {
$app->enqueueMessage(JText::_('NO ACCESS'));
return false;
}
//get IP, time and userid
$row->created = gmdate('Y-m-d H:i:s');
$row->author_ip = $elsettings->storeip ? getenv('REMOTE_ADDR') : 'DISABLED';
$row->created_by = $user->get('id');
//set owneredit to false
$owneredit = 0;
}
//Image upload
//If image upload is required we will stop here if no file was attached
if (empty($file['name']) && $elsettings->imageenabled == 2) {
$this->setError(JText::_('IMAGE EMPTY'));
return false;
}
if (($elsettings->imageenabled == 2 || $elsettings->imageenabled == 1) && !empty($file['name'])) {
jimport('joomla.filesystem.file');
$base_Dir = JPATH_SITE . '/images/eventlist/venues/';
//check the image
$check = ELImage::check($file, $elsettings);
if ($check === false) {
$app->redirect($_SERVER['HTTP_REFERER']);
}
//sanitize the image filename
$filename = ELImage::sanitize($base_Dir, $file['name']);
$filepath = $base_Dir . $filename;
if (!JFile::upload($file['tmp_name'], $filepath)) {
$this->setError(JText::_('UPLOAD FAILED'));
return false;
} else {
$row->locimage = $filename;
}
} else {
//keep image if edited and left blank
$row->locimage = $row->curimage;
}
//end image upload if
//Check description
$editoruser = ELUser::editoruser();
if (!$editoruser) {
//check description --> wipe out code
$row->locdescription = strip_tags($row->locdescription, '<br><br/>');
//convert the linux \n (Mac \r, Win \r\n) to <br /> linebreaks
$row->locdescription = str_replace(array("\r\n", "\r", "\n"), "<br />", $row->locdescription);
//cut too long words
$row->locdescription = wordwrap($row->locdescription, 75, " ", 1);
//check length
$length = JString::strlen($row->locdescription);
if ($length > $elsettings->datdesclimit) {
// if required shorten it
$row->locdescription = JString::substr($row->locdescription, 0, $elsettings->datdesclimit);
//if shortened add ...
$row->locdescription = $row->locdescription . '...';
}
}
//Autopublish
//check if the user has the required rank for autopublish
$autopublloc = ELUser::validate_user($elsettings->locpubrec, $elsettings->autopublocate);
//Check if user is the owner of the venue
//If yes enable autopublish
if ($autopublloc || $owneredit) {
$row->published = 1;
} else {
$row->published = 0;
}
$row->version++;
//Make sure the data is valid
if (!$row->check($elsettings)) {
$this->setError($row->getError());
return false;
}
//store it in the db
if (!$row->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//update item order
$row->reorder();
return $row->id;
}
/**
* Method to store the venue
*
* @access public
* @return id
* @since 0.9
*/
function store($data, $file)
{
global $mainframe;
jimport('joomla.utilities.date');
$user =& JFactory::getUser();
$elsettings = ELHelper::config();
//Get mailinformation
$SiteName = $mainframe->getCfg('sitename');
$MailFrom = $mainframe->getCfg('mailfrom');
$FromName = $mainframe->getCfg('fromname');
$tzoffset = $mainframe->getCfg('offset');
$row =& JTable::getInstance('eventlist_venues', '');
//bind it to the table
if (!$row->bind($data)) {
JError::raiseError(500, $this->_db->stderr());
return false;
}
//Are we saving from an item edit?
if ($row->id) {
$owner = ELUser::isOwner($row->id, 'venues');
//check if user is allowed to edit venues
$allowedtoeditvenue = ELUser::editaccess($elsettings->venueowner, $owner, $elsettings->venueeditrec, $elsettings->venueedit);
if ($allowedtoeditvenue == 0) {
$row->checkin();
$mainframe->enqueueMessage(JText::_('NO ACCESS'));
return false;
}
$date = new JDate($row->modified, $tzoffset);
$row->modified = $date->toMySQL();
$row->modified_by = $user->get('id');
//Is editor the owner of the venue
//This extra Check is needed to make it possible
//that the venue is published after an edit from an owner
if ($elsettings->venueowner == 1 && $owner == $user->get('id')) {
$owneredit = 1;
} else {
$owneredit = 0;
}
} else {
//check if user is allowed to submit new venues
$delloclink = ELUser::validate_user($elsettings->locdelrec, $elsettings->deliverlocsyes);
if ($delloclink == 0) {
$mainframe->enqueueMessage(JText::_('NO ACCESS'));
return false;
}
//get IP, time and userid
$date = new JDate($row->created, $tzoffset);
$row->created = $date->toMySQL();
$row->author_ip = $elsettings->storeip ? getenv('REMOTE_ADDR') : 'DISABLED';
$row->created_by = $user->get('id');
//set owneredit to false
$owneredit = 0;
}
//Image upload
//If image upload is required we will stop here if no file was attached
if (empty($file['name']) && $elsettings->imageenabled == 2) {
$this->setError(JText::_('IMAGE EMPTY'));
return false;
}
if (($elsettings->imageenabled == 2 || $elsettings->imageenabled == 1) && !empty($file['name'])) {
jimport('joomla.filesystem.file');
$base_Dir = JPATH_SITE . '/images/eventlist/venues/';
//check the image
$check = ELImage::check($file, $elsettings);
if ($check === false) {
$mainframe->redirect($_SERVER['HTTP_REFERER']);
}
//sanitize the image filename
$filename = ELImage::sanitize($base_Dir, $file['name']);
$filepath = $base_Dir . $filename;
if (!JFile::upload($file['tmp_name'], $filepath)) {
$this->setError(JText::_('UPLOAD FAILED'));
return false;
} else {
$row->locimage = $filename;
}
} else {
//keep image if edited and left blank
$row->locimage = $row->curimage;
}
//end image upload if
//Check description
$editoruser = ELUser::editoruser();
if (!$editoruser) {
//check datdescription --> wipe out code
$row->locdescription = strip_tags($row->locdescription, '<br />');
//convert the linux \n (Mac \r, Win \r\n) to <br /> linebreaks
$row->locdescription = str_replace(array("\r\n", "\r", "\n"), "<br />", $row->locdescription);
//cut too long words
$row->locdescription = wordwrap($row->locdescription, 75, " ", 1);
//check length
$length = JString::strlen($row->locdescription);
if ($length > $elsettings->datdesclimit) {
// if required shorten it
$row->locdescription = JString::substr($row->locdescription, 0, $elsettings->datdesclimit);
//if shortened add ...
$row->locdescription = $row->locdescription . '...';
}
}
$row->venue = trim(JFilterOutput::ampReplace($row->venue));
//Autopublish
//check if the user has the required rank for autopublish
$autopublloc = ELUser::validate_user($elsettings->locpubrec, $elsettings->autopublocate);
//Check if user is the owner of the venue
//If yes enable autopublish
if ($autopublloc || $owneredit) {
$row->published = 1;
} else {
$row->published = 0;
}
//Make sure the data is valid
if (!$row->check($elsettings)) {
$this->setError($row->getError());
return false;
}
//is this an edited venue or not?
//after store we allways have an id
$edited = $row->id ? $row->id : false;
//store it in the db
if (!$row->store()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
jimport('joomla.utilities.mail');
$link = JURI::base() . JRoute::_('index.php?view=details&id=' . $row->id, false);
//create mail
if ($elsettings->mailinform == 2 || $elsettings->mailinform == 3) {
$mail = JFactory::getMailer();
$state = $row->published ? JText::sprintf('MAIL VENUE PUBLISHED', $link) : JText::_('MAIL VENUE UNPUBLISHED');
if ($edited) {
$modified_ip = getenv('REMOTE_ADDR');
$edited = JHTML::Date($row->modified, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('MAIL EDIT VENUE', $user->name, $user->username, $user->email, $modified_ip, $edited, $row->venue, $row->url, $row->street, $row->plz, $row->city, $row->country, $row->locdescription, $state);
$mail->setSubject($SiteName . JText::_('EDIT VENUE MAIL'));
} else {
$created = JHTML::Date($row->modified, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('MAIL NEW VENUE', $user->name, $user->username, $user->email, $row->author_ip, $created, $row->venue, $row->url, $row->street, $row->plz, $row->city, $row->country, $row->locdescription, $state);
$mail->setSubject($SiteName . JText::_('NEW VENUE MAIL'));
}
$receivers = explode(',', trim($elsettings->mailinformrec));
$mail->addRecipient($receivers);
$mail->setSender(array($MailFrom, $FromName));
$mail->setBody($mailbody);
$sent = $mail->Send();
}
//create the mail for the user
if ($elsettings->mailinformuser == 2 || $elsettings->mailinformuser == 3) {
$usermail = JFactory::getMailer();
$state = $row->published ? JText::sprintf('USER MAIL VENUE PUBLISHED', $link) : JText::_('USER MAIL VENUE UNPUBLISHED');
if ($edited) {
$edited = JHTML::Date($row->modified, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('USER MAIL EDIT VENUE', $user->name, $user->username, $edited, $row->venue, $row->url, $row->street, $row->plz, $row->city, $row->country, $row->locdescription, $state);
$usermail->setSubject($SiteName . JText::_('EDIT USER VENUE MAIL'));
} else {
$created = JHTML::Date($row->modified, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('USER MAIL NEW VENUE', $user->name, $user->username, $created, $row->venue, $row->url, $row->street, $row->plz, $row->city, $row->country, $row->locdescription, $state);
$usermail->setSubject($SiteName . JText::_('NEW USER VENUE MAIL'));
}
$usermail->addRecipient($user->email);
$usermail->setSender(array($MailFrom, $FromName));
$usermail->setBody($mailbody);
$sent = $usermail->Send();
}
//update item order
$row->reorder();
return $row->id;
}
/**
* Method to store the event
*
* @access public
* @return id
* @since 0.9
*/
function store($data, $file)
{
global $mainframe;
$user =& JFactory::getUser();
$elsettings =& ELHelper::config();
//Get mailinformation
$SiteName = $mainframe->getCfg('sitename');
$MailFrom = $mainframe->getCfg('mailfrom');
$FromName = $mainframe->getCfg('fromname');
$tzoffset = $mainframe->getCfg('offset');
$row =& JTable::getInstance('eventlist_events', '');
//Sanitize
$data['datdescription'] = JRequest::getVar('datdescription', '', 'post', 'string', JREQUEST_ALLOWRAW);
//include the metatags
$data['meta_description'] = addslashes(htmlspecialchars(trim($elsettings->meta_description)));
if (strlen($data['meta_description']) > 255) {
$data['meta_description'] = substr($data['meta_description'], 0, 254);
}
$data['meta_keywords'] = addslashes(htmlspecialchars(trim($elsettings->meta_keywords)));
if (strlen($data['meta_keywords']) > 200) {
$data['meta_keywords'] = substr($data['meta_keywords'], 0, 199);
}
$curimage = JRequest::getVar('curimage', '', 'post', 'string');
//bind it to the table
if (!$row->bind($data)) {
JError::raiseError(500, $this->_db->stderr());
return false;
}
//Are we saving from an item edit?
if ($row->id) {
//check if user is allowed to edit events
$editaccess = ELUser::editaccess($elsettings->eventowner, $row->created_by, $elsettings->eventeditrec, $elsettings->eventedit);
$maintainer = ELUser::ismaintainer();
if ($maintainer || $editaccess) {
$allowedtoeditevent = 1;
}
if ($allowedtoeditevent == 0) {
JError::raiseError(403, JText::_('NO ACCESS'));
}
$row->modified = gmdate('Y-m-d H:i:s');
$row->modified_by = $user->get('id');
/*
* Is editor the owner of the event
* This extra Check is needed to make it possible
* that the venue is published after an edit from an owner
*/
if ($elsettings->venueowner == 1 && $row->created_by == $user->get('id')) {
$owneredit = 1;
} else {
$owneredit = 0;
}
} else {
//check if user is allowed to submit new events
$maintainer = ELUser::ismaintainer();
$genaccess = ELUser::validate_user($elsettings->evdelrec, $elsettings->delivereventsyes);
if ($maintainer || $genaccess) {
$dellink = 1;
}
if ($dellink == 0) {
JError::raiseError(403, JText::_('NO ACCESS'));
}
//get IP, time and userid
$row->created = gmdate('Y-m-d H:i:s');
$row->author_ip = $elsettings->storeip ? getenv('REMOTE_ADDR') : 'DISABLED';
$row->created_by = $user->get('id');
//Set owneredit to false
$owneredit = 0;
}
/*
* Autopublish
* check if the user has the required rank for autopublish
*/
$autopubev = ELUser::validate_user($elsettings->evpubrec, $elsettings->autopubl);
if ($autopubev || $owneredit) {
$row->published = 1;
} else {
$row->published = 0;
}
//Image upload
//If image upload is required we will stop here if no file was attached
if (empty($file['name']) && $elsettings->imageenabled == 2) {
$this->setError(JText::_('IMAGE EMPTY'));
return false;
}
if (($elsettings->imageenabled == 2 || $elsettings->imageenabled == 1) && !empty($file['name'])) {
jimport('joomla.filesystem.file');
$base_Dir = JPATH_SITE . '/images/eventlist/events/';
//check the image
$check = ELImage::check($file, $elsettings);
if ($check === false) {
$mainframe->redirect($_SERVER['HTTP_REFERER']);
}
//sanitize the image filename
$filename = ELImage::sanitize($base_Dir, $file['name']);
$filepath = $base_Dir . $filename;
if (!JFile::upload($file['tmp_name'], $filepath)) {
$this->setError(JText::_('UPLOAD FAILED'));
return false;
} else {
$row->datimage = $filename;
}
} else {
//keep image if edited and left blank
$row->datimage = $curimage;
}
//end image if
$editoruser = ELUser::editoruser();
if (!$editoruser) {
//check datdescription --> wipe out code
$row->datdescription = strip_tags($row->datdescription, '<br><br/>');
//convert the linux \n (Mac \r, Win \r\n) to <br /> linebreaks
$row->datdescription = str_replace(array("\r\n", "\r", "\n"), "<br />", $row->datdescription);
// cut too long words
$row->datdescription = wordwrap($row->datdescription, 75, ' ', 1);
//check length
$length = JString::strlen($row->datdescription);
if ($length > $elsettings->datdesclimit) {
//too long then shorten datdescription
$row->datdescription = JString::substr($row->datdescription, 0, $elsettings->datdesclimit);
//add ...
$row->datdescription = $row->datdescription . '...';
}
}
$row->title = trim(JFilterOutput::ampReplace($row->title));
//set registration regarding the el settings
switch ($elsettings->showfroregistra) {
case 0:
$row->registra = 0;
break;
case 1:
$row->registra = 1;
break;
case 2:
$row->registra = $row->registra;
break;
}
switch ($elsettings->showfrounregistra) {
case 0:
$row->unregistra = 0;
break;
case 1:
$row->unregistra = 1;
break;
case 2:
if ($elsettings->showfroregistra >= 1) {
$row->unregistra = $row->unregistra;
} else {
$row->unregistra = 0;
}
break;
}
//Make sure the table is valid
if (!$row->check($elsettings)) {
$this->setError($row->getError());
return false;
}
//is this an edited event or not?
//after store we allways have an id
$edited = $row->id ? $row->id : false;
//store it in the db
if (!$row->store(true)) {
JError::raiseError(500, $this->_db->stderr());
return false;
}
$this->_db->setQuery('SELECT * FROM #__eventlist_venues WHERE id = ' . (int) $row->locid);
$rowloc = $this->_db->loadObject();
jimport('joomla.utilities.mail');
$link = JURI::base() . JRoute::_('index.php?view=details&id=' . $row->id, false);
//create the mail for the site owner
if ($elsettings->mailinform == 1 || $elsettings->mailinform == 3) {
$mail = JFactory::getMailer();
$state = $row->published ? JText::sprintf('MAIL EVENT PUBLISHED', $link) : JText::_('MAIL EVENT UNPUBLISHED');
if ($edited) {
$modified_ip = getenv('REMOTE_ADDR');
$edited = JHTML::Date($row->modified, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('MAIL EDIT EVENT', $user->name, $user->username, $user->email, $modified_ip, $edited, $row->title, $row->dates, $row->times, $rowloc->venue, $rowloc->city, $row->datdescription, $state);
$mail->setSubject($SiteName . JText::_('EDIT EVENT MAIL'));
} else {
$created = JHTML::Date($row->created, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('MAIL NEW EVENT', $user->name, $user->username, $user->email, $row->author_ip, $created, $row->title, $row->dates, $row->times, $rowloc->venue, $rowloc->city, $row->datdescription, $state);
$mail->setSubject($SiteName . JText::_('NEW EVENT MAIL'));
}
$receivers = explode(',', trim($elsettings->mailinformrec));
$mail->addRecipient($receivers);
$mail->setSender(array($MailFrom, $FromName));
$mail->setBody($mailbody);
$sent = $mail->Send();
}
//mail end
//create the mail for the user
if ($elsettings->mailinformuser == 1 || $elsettings->mailinformuser == 3) {
$usermail = JFactory::getMailer();
$state = $row->published ? JText::sprintf('USER MAIL EVENT PUBLISHED', $link) : JText::_('USER MAIL EVENT UNPUBLISHED');
if ($edited) {
$edited = JHTML::Date($row->modified, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('USER MAIL EDIT EVENT', $user->name, $user->username, $edited, $row->title, $row->dates, $row->times, $rowloc->venue, $rowloc->city, $row->datdescription, $state);
$usermail->setSubject($SiteName . JText::_('EDIT USER EVENT MAIL'));
} else {
$created = JHTML::Date($row->created, JText::_('DATE_FORMAT_LC2'));
$mailbody = JText::sprintf('USER MAIL NEW EVENT', $user->name, $user->username, $created, $row->title, $row->dates, $row->times, $rowloc->venue, $rowloc->city, $row->datdescription, $state);
$usermail->setSubject($SiteName . JText::_('NEW USER EVENT MAIL'));
}
$usermail->addRecipient($user->email);
$usermail->setSender(array($MailFrom, $FromName));
$usermail->setBody($mailbody);
$sent = $usermail->Send();
}
return $row->id;
}
/**
* Method to store the event
*
* @access public
* @return id
* @since 0.9
*/
function store($data, $file)
{
$app =& JFactory::getApplication();
$user =& JFactory::getUser();
$elsettings =& ELHelper::config();
$cats = JRequest::getVar('cid', array(), 'post', 'array');
$row =& JTable::getInstance('eventlist_events', '');
//Sanitize
$data['datdescription'] = JRequest::getVar('datdescription', '', 'post', 'string', JREQUEST_ALLOWRAW);
//include the metatags
if (strlen($data['meta_description']) > 255) {
$data['meta_description'] = substr($data['meta_description'], 0, 254);
}
if (strlen($data['meta_keywords']) > 200) {
$data['meta_keywords'] = substr($data['meta_keywords'], 0, 199);
}
$curimage = JRequest::getVar('curimage', '', 'post', 'string');
//bind it to the table
if (!$row->bind($data)) {
JError::raiseError(500, $this->_db->stderr());
return false;
}
//get values from time selectlist and concatenate them accordingly
$starthours = JRequest::getCmd('starthours');
$startminutes = JRequest::getCmd('startminutes');
$endhours = JRequest::getCmd('endhours');
$endminutes = JRequest::getCmd('endminutes');
$row->times = $starthours . ':' . $startminutes;
$row->endtimes = $endhours . ':' . $endminutes;
//Are we saving from an item edit?
if ($row->id) {
//check if user is allowed to edit events
$editaccess = ELUser::editaccess($elsettings->eventowner, $row->created_by, $elsettings->eventeditrec, $elsettings->eventedit);
$maintainer = ELUser::ismaintainer();
if ($maintainer || $editaccess) {
$allowedtoeditevent = 1;
}
if ($allowedtoeditevent == 0) {
JError::raiseError(403, JText::_('NO ACCESS'));
}
$row->modified = gmdate('Y-m-d H:i:s');
$row->modified_by = $user->get('id');
/*
* Is editor the owner of the event
* This extra Check is needed to make it possible
* that the venue is published after an edit from an owner
*/
if ($elsettings->venueowner == 1 && $row->created_by == $user->get('id')) {
$owneredit = 1;
} else {
$owneredit = 0;
}
} else {
//check if user is allowed to submit new events
$maintainer = ELUser::ismaintainer();
$genaccess = ELUser::validate_user($elsettings->evdelrec, $elsettings->delivereventsyes);
if (!($maintainer || $genaccess)) {
JError::raiseError(403, JText::_('NO ACCESS'));
}
//get IP, time and userid
$row->created = gmdate('Y-m-d H:i:s');
$row->author_ip = $elsettings->storeip ? getenv('REMOTE_ADDR') : 'DISABLED';
$row->created_by = $user->get('id');
//Set owneredit to false
$owneredit = 0;
}
/*
* Autopublish
* check if the user has the required rank for autopublish
*/
$autopubev = ELUser::validate_user($elsettings->evpubrec, $elsettings->autopubl);
if ($autopubev || $owneredit) {
$row->published = 1;
} else {
$row->published = 0;
}
//Image upload
//If image upload is required we will stop here if no file was attached
if (empty($file['name']) && $elsettings->imageenabled == 2) {
$this->setError(JText::_('IMAGE EMPTY'));
return false;
}
if (($elsettings->imageenabled == 2 || $elsettings->imageenabled == 1) && !empty($file['name'])) {
jimport('joomla.filesystem.file');
$base_Dir = JPATH_SITE . '/images/eventlist/events/';
//check the image
$check = ELImage::check($file, $elsettings);
if ($check === false) {
$app->redirect($_SERVER['HTTP_REFERER']);
}
//sanitize the image filename
$filename = ELImage::sanitize($base_Dir, $file['name']);
$filepath = $base_Dir . $filename;
if (!JFile::upload($file['tmp_name'], $filepath)) {
$this->setError(JText::_('UPLOAD FAILED'));
return false;
} else {
$row->datimage = $filename;
}
} else {
//keep image if edited and left blank
$row->datimage = $curimage;
}
//end image if
$editoruser = ELUser::editoruser();
if (!$editoruser) {
//check datdescription --> wipe out code
$row->datdescription = strip_tags($row->datdescription, '<br><br/>');
//convert the linux \n (Mac \r, Win \r\n) to <br /> linebreaks
$row->datdescription = str_replace(array("\r\n", "\r", "\n"), "<br />", $row->datdescription);
// cut too long words
$row->datdescription = wordwrap($row->datdescription, 75, ' ', 1);
//check length
$length = JString::strlen($row->datdescription);
if ($length > $elsettings->datdesclimit) {
//too long then shorten datdescription
$row->datdescription = JString::substr($row->datdescription, 0, $elsettings->datdesclimit);
//add ...
$row->datdescription = $row->datdescription . '...';
}
}
//set registration regarding the el settings
switch ($elsettings->showfroregistra) {
case 0:
$row->registra = 0;
break;
case 1:
$row->registra = 1;
break;
case 2:
$row->registra = $row->registra;
break;
}
switch ($elsettings->showfrounregistra) {
case 0:
$row->unregistra = 0;
break;
case 1:
$row->unregistra = 1;
break;
case 2:
if ($elsettings->showfroregistra >= 1) {
$row->unregistra = $row->unregistra;
} else {
$row->unregistra = 0;
}
break;
}
//Make sure the table is valid
if (!$row->check($elsettings)) {
$this->setError($row->getError());
return false;
}
$row->version++;
//store it in the db
if (!$row->store(true)) {
JError::raiseError(500, $this->_db->stderr());
return false;
}
//store cat relation
$query = 'DELETE FROM #__eventlist_cats_event_relations WHERE itemid = ' . $row->id;
$this->_db->setQuery($query);
$this->_db->query();
foreach ($cats as $cat) {
$query = 'INSERT INTO #__eventlist_cats_event_relations (`catid`, `itemid`) VALUES(' . $cat . ',' . $row->id . ')';
$this->_db->setQuery($query);
$this->_db->query();
}
return $row->id;
}
/**
* Creates the output for the details view
*
* @since 0.9
*/
function display($tpl = null)
{
$app =& JFactory::getApplication();
$document =& JFactory::getDocument();
$user =& JFactory::getUser();
$dispatcher =& JDispatcher::getInstance();
$elsettings =& ELHelper::config();
$row =& $this->get('Details');
$categories =& $this->get('Categories');
$registers =& $this->get('Registers');
$regcheck =& $this->get('Usercheck');
//get menu information
$menu =& JSite::getMenu();
$item = $menu->getActive();
$params =& $app->getParams('com_eventlist');
//Check if the id exists
if ($row->did == 0) {
return JError::raiseError(404, JText::sprintf('Event #%d not found', $row->did));
}
//Check if user has access to the details
if ($elsettings->showdetails == 0) {
return JError::raiseError(403, JText::_('NO ACCESS'));
}
$cid = JRequest::getInt('cid', 0);
//add css file
$document->addStyleSheet($this->baseurl . '/components/com_eventlist/assets/css/eventlist.css');
$document->addCustomTag('<!--[if IE]><style type="text/css">.floattext{zoom:1;}, * html #eventlist dd { height: 1%; }</style><![endif]-->');
//Print
$pop = JRequest::getBool('pop');
$params->def('page_title', JText::_('DETAILS'));
if ($pop) {
$params->set('popup', 1);
}
$print_link = JRoute::_('index.php?view=details&cid=' . $cid . '&id=' . $row->slug . '&pop=1&tmpl=component');
//pathway
$cats = new eventlist_cats($cid);
$parents = $cats->getParentlist();
$pathway =& $app->getPathWay();
$pathway->setItemName(1, $item->name);
foreach ($parents as $parent) {
$pathway->addItem($this->escape($parent->catname), JRoute::_('index.php?view=categoryevents&id=' . $parent->categoryslug));
}
$pathway->addItem($this->escape($row->title), JRoute::_('index.php?view=details&cid=' . $cid . '&id=' . $row->slug));
//Get images
$dimage = ELImage::flyercreator($row->datimage, 'event');
$limage = ELImage::flyercreator($row->locimage);
//Check user if he can edit
$allowedtoeditevent = ELUser::editaccess($elsettings->eventowner, $row->created_by, $elsettings->eventeditrec, $elsettings->eventedit);
$allowedtoeditvenue = ELUser::editaccess($elsettings->venueowner, $row->venueowner, $elsettings->venueeditrec, $elsettings->venueedit);
//Timecheck for registration
$jetzt = date("Y-m-d");
$now = strtotime($jetzt);
$date = strtotime($row->dates);
$timecheck = $now - $date;
//let's build the registration handling
$formhandler = 0;
//is the user allready registered at the event
if ($regcheck) {
$formhandler = 3;
} else {
//no, he isn't
$formhandler = 4;
}
//check if it is too late to register and overwrite $formhandler
if ($timecheck > 0) {
$formhandler = 1;
}
//is the user registered at joomla and overwrite $formhandler if not
if (!$user->get('id')) {
$formhandler = 2;
}
if ($formhandler >= 3) {
$js = "function check(checkbox, senden) {\n\t\t\t\tif(checkbox.checked==true){\n\t\t\t\t\tsenden.disabled = false;\n\t\t\t\t} else {\n\t\t\t\t\tsenden.disabled = true;\n\t\t\t\t}}";
$document->addScriptDeclaration($js);
}
//Generate Eventdescription
if (!$row->datdescription == '' || !$row->datdescription == '<br />') {
//Execute Plugins
$row->text = $row->datdescription;
JPluginHelper::importPlugin('content');
$results = $dispatcher->trigger('onPrepareContent', array(&$row, &$params, 0));
$row->datdescription = $row->text;
}
//Generate Venuedescription
if (!$row->locdescription == '' || !$row->locdescription == '<br />') {
//execute plugins
$row->text = $row->locdescription;
JPluginHelper::importPlugin('content');
$results = $dispatcher->trigger('onPrepareContent', array(&$row, &$params, 0));
$row->locdescription = $row->text;
}
// generate Metatags
$meta_keywords_content = "";
if (!empty($row->meta_keywords)) {
$keywords = explode(",", $row->meta_keywords);
foreach ($keywords as $keyword) {
if ($meta_keywords_content != "") {
$meta_keywords_content .= ", ";
}
if (preg_match("/[\\/[\\/]/", $keyword)) {
$keyword = trim(str_replace("[", "", str_replace("]", "", $keyword)));
$buffer = $this->keyword_switcher($keyword, $row, $categories, $elsettings->formattime, $elsettings->formatdate);
if ($buffer != "") {
$meta_keywords_content .= $buffer;
} else {
$meta_keywords_content = substr($meta_keywords_content, 0, strlen($meta_keywords_content) - 2);
// remove the comma and the white space
}
} else {
$meta_keywords_content .= $keyword;
}
}
}
if (!empty($row->meta_description)) {
$description = explode("[", $row->meta_description);
$description_content = "";
foreach ($description as $desc) {
$keyword = substr($desc, 0, strpos($desc, "]", 0));
if ($keyword != "") {
$description_content .= $this->keyword_switcher($keyword, $row, $categories, $elsettings->formattime, $elsettings->formatdate);
$description_content .= substr($desc, strpos($desc, "]", 0) + 1);
} else {
$description_content .= $desc;
}
}
} else {
$description_content = "";
}
//set page title and meta stuff
$document->setTitle($row->title);
$document->setMetadata('keywords', $meta_keywords_content);
$document->setDescription(strip_tags($description_content));
//build the url
if (!empty($row->url) && strtolower(substr($row->url, 0, 7)) != "http://") {
$row->url = 'http://' . $row->url;
}
//create flag
if ($row->country) {
$row->countryimg = ELOutput::getFlag($row->country);
}
// load dispatcher for plugins
JPluginHelper::importPlugin('eventlist');
$row->pluginevent = new stdClass();
$results = $dispatcher->trigger('onEventDetailsEnd', array($row->did, $this->escape($row->title)));
$row->pluginevent->onEventDetailsEnd = trim(implode("\n", $results));
//assign vars to jview
$this->assignRef('row', $row);
$this->assignRef('categories', $categories);
$this->assignRef('params', $params);
$this->assignRef('allowedtoeditevent', $allowedtoeditevent);
$this->assignRef('allowedtoeditvenue', $allowedtoeditvenue);
$this->assignRef('dimage', $dimage);
$this->assignRef('limage', $limage);
$this->assignRef('print_link', $print_link);
$this->assignRef('registers', $registers);
$this->assignRef('formhandler', $formhandler);
$this->assignRef('elsettings', $elsettings);
$this->assignRef('item', $item);
$this->assignRef('user', $user);
$this->assignRef('dispatcher', $dispatcher);
parent::display($tpl);
}
/**
* Creates the Venueevents View
*
* @since 0.9
*/
function display($tpl = null)
{
$app =& JFactory::getApplication();
//initialize variables
$document =& JFactory::getDocument();
$menu =& JSite::getMenu();
$elsettings =& ELHelper::config();
$item = $menu->getActive();
$params =& $app->getParams('com_eventlist');
$uri =& JFactory::getURI();
//add css file
$document->addStyleSheet($this->baseurl . '/components/com_eventlist/assets/css/eventlist.css');
$document->addCustomTag('<!--[if IE]><style type="text/css">.floattext{zoom:1;}, * html #eventlist dd { height: 1%; }</style><![endif]-->');
// Request variables
$limitstart = JRequest::getInt('limitstart');
$limit = $app->getUserStateFromRequest('com_eventlist.venueevents.limit', 'limit', $params->def('display_num', 0), 'int');
$pop = JRequest::getBool('pop');
$task = JRequest::getWord('task');
//get data from model
$rows =& $this->get('Data');
$venue =& $this->get('Venue');
$total =& $this->get('Total');
//does the venue exist?
if ($venue->id == 0) {
return JError::raiseError(404, JText::sprintf('Venue #%d not found', $venue->id));
}
//are events available?
if (!$rows) {
$noevents = 1;
} else {
$noevents = 0;
}
// Add needed scripts if the lightbox effect is enabled
if ($elsettings->lightbox == 1) {
JHTML::_('behavior.modal');
}
//Get image
$limage = ELImage::flyercreator($venue->locimage);
//add alternate feed link
$link = 'index.php?option=com_eventlist&view=venueevents&format=feed&id=' . $venue->id;
$attribs = array('type' => 'application/rss+xml', 'title' => 'RSS 2.0');
$document->addHeadLink(JRoute::_($link . '&type=rss'), 'alternate', 'rel', $attribs);
$attribs = array('type' => 'application/atom+xml', 'title' => 'Atom 1.0');
$document->addHeadLink(JRoute::_($link . '&type=atom'), 'alternate', 'rel', $attribs);
//pathway
$pathway =& $app->getPathWay();
$pathway->setItemName(1, $item->name);
//create the pathway
if ($task == 'archive') {
$pathway->addItem(JText::_('ARCHIVE') . ' - ' . $venue->venue, JRoute::_('index.php?option=com_eventlist&view=venueevents&task=archive&id=' . $venue->slug));
$link = JRoute::_('index.php?option=com_eventlist&view=venueevents&id=' . $venue->slug . '&task=archive');
$print_link = JRoute::_('index.php?option=com_eventlist&view=venueevents&id=' . $venue->slug . '&task=archive&pop=1&tmpl=component');
$pagetitle = $venue->venue . ' - ' . JText::_('ARCHIVE');
} else {
$pathway->addItem($venue->venue, JRoute::_('index.php?option=com_eventlist&view=venueevents&id=' . $venue->slug));
$link = JRoute::_('index.php?option=com_eventlist&view=venueevents&id=' . $venue->slug);
$print_link = JRoute::_('index.php?option=com_eventlist&view=venueevents&id=' . $venue->slug . '&pop=1&tmpl=component');
$pagetitle = $venue->venue;
}
//set Page title
$app->setPageTitle($pagetitle);
$app->addMetaTag('title', $pagetitle);
$document->setMetadata('keywords', $venue->meta_keywords);
$document->setDescription(strip_tags($venue->meta_description));
//Printfunction
$params->def('print', !$app->getCfg('hidePrint'));
$params->def('icons', $app->getCfg('icons'));
if ($pop) {
$params->set('popup', 1);
}
//Check if the user has access to the form
$maintainer = ELUser::ismaintainer();
$genaccess = ELUser::validate_user($elsettings->evdelrec, $elsettings->delivereventsyes);
if ($maintainer || $genaccess) {
$dellink = 1;
}
//Generate Venuedescription
if (!$venue->locdescription == '' || !$venue->locdescription == '<br />') {
//execute plugins
$venue->text = $venue->locdescription;
$venue->title = $venue->venue;
JPluginHelper::importPlugin('content');
$results = $app->triggerEvent('onPrepareContent', array(&$venue, &$params, 0));
$venuedescription = $venue->text;
}
$allowedtoeditvenue = ELUser::editaccess($elsettings->venueowner, $venue->created, $elsettings->venueeditrec, $elsettings->venueedit);
//build the url
if (!empty($venue->url) && strtolower(substr($venue->url, 0, 7)) != "http://") {
$venue->url = 'http://' . $venue->url;
}
//prepare the url for output
if (strlen(htmlspecialchars($venue->url, ENT_QUOTES)) > 35) {
$venue->urlclean = substr(htmlspecialchars($venue->url, ENT_QUOTES), 0, 35) . '...';
} else {
$venue->urlclean = htmlspecialchars($venue->url, ENT_QUOTES);
}
//create flag
if ($venue->country) {
$venue->countryimg = ELOutput::getFlag($venue->country);
}
// Create the pagination object
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
//create select lists
$lists = $this->_buildSortLists($elsettings);
$this->assign('lists', $lists);
$this->assign('action', $uri->toString());
$this->assignRef('rows', $rows);
$this->assignRef('noevents', $noevents);
$this->assignRef('venue', $venue);
$this->assignRef('print_link', $print_link);
$this->assignRef('params', $params);
$this->assignRef('dellink', $dellink);
$this->assignRef('limage', $limage);
$this->assignRef('venuedescription', $venuedescription);
$this->assignRef('pageNav', $pageNav);
$this->assignRef('elsettings', $elsettings);
$this->assignRef('item', $item);
$this->assignRef('pagetitle', $pagetitle);
$this->assignRef('task', $task);
$this->assignRef('allowedtoeditvenue', $allowedtoeditvenue);
parent::display($tpl);
}
/**
* Creates the output for the details view
*
* @since 0.9
*/
function display($tpl = null)
{
global $mainframe;
$document =& JFactory::getDocument();
$user =& JFactory::getUser();
$elsettings = ELHelper::config();
$row =& $this->get('Details');
$registers =& $this->get('Registers');
$regcheck =& $this->get('Usercheck');
//cleanup events
ELHelper::cleanevents($elsettings->lastupdate);
//get menu information
$menu =& JSite::getMenu();
$item = $menu->getActive();
$params =& $mainframe->getParams('com_eventlist');
//Check if the id exists
if ($row->did == 0) {
return JError::raiseError(404, JText::sprintf('Event #%d not found', $row->did));
}
//Check if user has access to the details
if ($elsettings->showdetails == 0) {
return JError::raiseError(403, JText::_('NO ACCESS'));
}
//add css file
$document->addStyleSheet($this->baseurl . '/components/com_eventlist/assets/css/eventlist.css');
$document->addCustomTag('<!--[if IE]><style type="text/css">.floattext{zoom:1;}, * html #eventlist dd { height: 1%; }</style><![endif]-->');
//Print
$pop = JRequest::getBool('pop');
$params->def('page_title', JText::_('DETAILS'));
if ($pop) {
$params->set('popup', 1);
}
$print_link = JRoute::_('index.php?view=details&id=' . $row->slug . '&pop=1&tmpl=component');
//pathway
$pathway =& $mainframe->getPathWay();
$pathway->addItem(JText::_('DETAILS') . ' - ' . $row->title, JRoute::_('index.php?view=details&id=' . $row->slug));
//Get images
$dimage = ELImage::flyercreator($row->datimage, $elsettings, 'event');
$limage = ELImage::flyercreator($row->locimage, $elsettings);
//Check user if he can edit
$allowedtoeditevent = ELUser::editaccess($elsettings->eventowner, $row->created_by, $elsettings->eventeditrec, $elsettings->eventedit);
$allowedtoeditvenue = ELUser::editaccess($elsettings->venueowner, $row->venueowner, $elsettings->venueeditrec, $elsettings->venueedit);
//Generate Date
$date = strftime($elsettings->formatdate, strtotime($row->dates));
if ($row->times) {
$time = strftime($elsettings->formattime, strtotime($row->times));
}
if (!$row->enddates) {
$displaydate = $date . '<br />';
} else {
$enddate = strftime($elsettings->formatdate, strtotime($row->enddates));
$displaydate = $date . ' - ' . $enddate . '<br />';
}
//Generate Time
if ($elsettings->showtimedetails == 1 && $row->times) {
$starttime = $time . ' ' . $elsettings->timename;
if ($row->endtimes) {
$endtime = strftime($elsettings->formattime, strtotime($row->endtimes));
$endtime = ' - ' . $endtime . ' ' . $elsettings->timename;
$displaytime = $starttime . $endtime;
} else {
$displaytime = $starttime;
}
}
//Timecheck for registration
$jetzt = date("Y-m-d");
$now = strtotime($jetzt);
$date = strtotime($row->dates);
$timecheck = $now - $date;
//let's build the registration handling
$formhandler = 0;
//is the user allready registered at the event
if ($regcheck) {
$formhandler = 3;
} else {
//no, he isn't
$formhandler = 4;
}
//check if it is too late to register and overwrite $formhandler
if ($timecheck > 0) {
$formhandler = 1;
}
//is the user registered at joomla and overwrite $formhandler if not
if (!$user->get('id')) {
$formhandler = 2;
}
//Generate Eventdescription
if ($row->datdescription == '' || $row->datdescription == '<br />') {
$eventdescription = JText::_('NO DESCRIPTION');
} else {
//Execute Plugins
$row->text = $row->datdescription;
//$row->title = $row->title;
JPluginHelper::importPlugin('content');
$results = $mainframe->triggerEvent('onPrepareContent', array(&$row, &$params, 0));
$eventdescription = $row->text;
}
//Generate Venuedescription
if (empty($row->locdescription)) {
$venuedescription = JText::_('NO DESCRIPTION');
} else {
//execute plugins
$row->text = $row->locdescription;
//$row->title = $row->venue;
JPluginHelper::importPlugin('content');
$results = $mainframe->triggerEvent('onPrepareContent', array(&$row, &$params, 0));
$venuedescription = $row->text;
}
// generate Metatags
$meta_keywords_content = "";
if (!empty($row->meta_keywords)) {
$keywords = explode(",", $row->meta_keywords);
foreach ($keywords as $keyword) {
if ($meta_keywords_content != "") {
$meta_keywords_content .= ", ";
}
if (ereg("[/[/]", $keyword)) {
$keyword = trim(str_replace("[", "", str_replace("]", "", $keyword)));
$meta_keywords_content .= $this->keyword_switcher($keyword, $row, $elsettings->formattime, $elsettings->formatdate);
} else {
$meta_keywords_content .= $keyword;
}
}
}
if (!empty($row->meta_description)) {
$description = explode("[", $row->meta_description);
$description_content = "";
foreach ($description as $desc) {
$keyword = substr($desc, 0, strpos($desc, "]", 0));
if ($keyword != "") {
$description_content .= $this->keyword_switcher($keyword, $row, $elsettings->formattime, $elsettings->formatdate);
$description_content .= substr($desc, strpos($desc, "]", 0) + 1);
} else {
$description_content .= $desc;
}
}
} else {
$description_content = "";
}
//set page title and meta stuff
$document->setTitle($item->name . ' - ' . $row->title);
$document->setMetadata('keywords', $meta_keywords_content);
$document->setDescription(strip_tags($description_content));
//build the url
if (!empty($row->url) && strtolower(substr($row->url, 0, 7)) != "http://") {
$row->url = 'http://' . $row->url;
}
//create flag
if ($row->country) {
$row->countryimg = ELOutput::getFlag($row->country);
}
//assign vars to jview
$this->assignRef('row', $row);
$this->assignRef('params', $params);
$this->assignRef('allowedtoeditevent', $allowedtoeditevent);
$this->assignRef('allowedtoeditvenue', $allowedtoeditvenue);
$this->assignRef('dimage', $dimage);
$this->assignRef('limage', $limage);
$this->assignRef('displaytime', $displaytime);
$this->assignRef('displaydate', $displaydate);
$this->assignRef('print_link', $print_link);
$this->assignRef('eventdescription', $eventdescription);
$this->assignRef('venuedescription', $venuedescription);
$this->assignRef('registers', $registers);
$this->assignRef('formhandler', $formhandler);
$this->assignRef('elsettings', $elsettings);
$this->assignRef('item', $item);
parent::display($tpl);
}