Example #1
0
 /**
  * Save a new event on database table "_events"
  * @param Event $event
  * @return Event
  */
 public function saveEvent(Event $event)
 {
     $sql = 'INSERT INTO gm_events
             (alias, description, allow_repetitions, reach_required_repetitions, id_each_badge, id_reach_badge, each_points, max_points, each_callback, reach_callback)
             VALUES
             (:alias, :description, :allow_repetitions, :reach_required_repetitions, :id_each_badge, :id_reach_badge, :each_points, :max_points, :each_callback, :reach_callback)';
     $params = array(':alias' => $event->getAlias(), ':description' => $event->getDescription(), ':allow_repetitions' => $event->getAllowRepetitions(), ':reach_required_repetitions' => $event->getRequiredRepetitions(), ':id_each_badge' => $event->getIdEachBadge(), ':id_reach_badge' => $event->getIdReachBadge(), ':each_points' => $event->getEachPoints(), ':max_points' => $event->getMaxPoints(), ':each_callback' => $event->getEachCallback(), ':reach_callback' => $event->getReachCallback());
     $this->execute($sql, $params);
     return $this->getEventById($this->lastInsertId());
 }