public function commentsAction() { $request = $this->getRequest(); $event_id = $request->getRequest('filter_id'); $event_info = Model_Events::getEvent($event_id); if (!$event_info) { $this->redirect($this->getRequest()->getBaseUrl() . $this->getRequest()->getModule() . '/events/'); } $this->view->comments = Model_Events::getComments(array('filter_event_id' => $event_id, 'sort' => 'ASC', 'order' => 'events_comments.comment_id')); }
public static function delete($event_id) { $db = JO_Db::getDefaultAdapter(); $event_info = self::getEvent($event_id); if (!$event_info) { return false; } if ($event_info['store'] == 's3') { self::deleteImagesAmazon($event_info['image']); } else { $model_image = new Helper_Images(); $model_image->deleteImages($event_info['image']); } $comments = Model_Events::getComments(array('filter_event_id' => $event_id)); if ($comments) { foreach ($comments as $comment) { $db->delete('events_comments', array('comment_id = ?' => $comment['comment_id'])); $db->delete('events_reports_comments', array('comment_id = ?' => $comment['comment_id'])); } } $del = $db->delete('events', array('event_id = ?' => $event_id)); if (!$del) { return false; } else { $db->delete('events_likes', array('event_id = ?' => $event_id)); $db->delete('events_reports', array('event_id = ?' => $event_id)); $db->delete('events_following', array('event_id = ?' => $event_id)); $db->delete('users_history', array('pin_id = ?' => $event_id)); self::deleteCache($event_info); return true; } }