/** * 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()); }