public function getEventById($event_id) { $lng = isset($_SESSION['System']['lng']) ? $_SESSION['System']['lng'] : 'nl'; $db = Zend_Registry::get('db'); $select = $db->select()->from(array('e' => 'Event'), array('*'))->join(array('t' => 'EventTsl'), 'e.event_id = t.event_id', array('language', 'title', 'description', 'mail_remember', 'mail_confirmation'))->where('e.event_id = ?', (int) $event_id)->where('t.language = ?', $lng); $results = $db->fetchAll($select); if (!$results) { return false; } $result = $results[0]; $date = explode(' ', $result['datetime_event']); $event = new SxCms_Event(); $event->setId((int) $result['event_id'])->setLanguage($result['language'])->setTitle($result['title'])->setDescription($result['description'])->setDateEvent($date[0])->setTimeEvent($date[1])->setLocation($result['location'])->setMailRemember($result['mail_remember'])->setMailConfirmation($result['mail_confirmation'])->setSubscriptionAllow($result['subscription_allow'])->setSubscriptionMax($result['subscription_max'])->setNotifyEmail($result['notify_email'])->setDateStart($result['date_start'])->setDateEnd($result['date_end'])->setRememberDays($result['remember_days'])->setConfirmationLink($result['confirmation_link'])->setValidateIntern($result['validate_intern']); $proxy = new SxCms_Event_Field_DataMapper(); $proxy->getFieldByEvent($event); return $event; }