public function index($permalink = null)
 {
     $event = self::load_event($permalink);
     $event_id = mysql_real_escape_string($event->id);
     $service_discounts = DiscountItem::find_all("discount_items.item_class = 'Service' AND services.event_id = '{$event_id}'", 'services.id ASC');
     $this->assign("event", $event);
     $this->assign("services", $event->services());
     $this->assign("service_discounts", $service_discounts);
     $this->title = "Events :: {$event->name} :: Services";
     $this->render("service/index.tpl");
 }
 public function show($permalink = null)
 {
     $event = self::load_event($permalink);
     $event_id = mysql_real_escape_string($event->id);
     $ticket_discounts = DiscountItem::find_all("discount_items.item_class = 'EventTicket' AND event_tickets.event_id = '{$event_id}'", 'event_tickets.id ASC');
     $this->assign("event", $event);
     $this->assign("tickets", $event->tickets());
     $this->assign("ticket_discounts", $ticket_discounts);
     $this->title = "Events :: " . $event->name;
     $this->render("event/show.tpl");
 }
 public function tickets($reload = false)
 {
     if (!$this->tickets_cache or $reload) {
         $id = mysql_real_escape_string($this->id);
         $this->tickets_cache = DiscountItem::find_all("discount_codes.id = '{$id}' AND discount_items.item_class = 'EventTicket'");
     }
     return $this->tickets_cache;
 }