/** * Saves blog post in db * @access public */ public function save() { Logger::log("Enter: CNBlogPost::save"); Logger::log("Calling: CNContent::save"); parent::save(); Logger::log("Exit: CNBlogPost::save"); return; }
/** * Saves Video in database * @access public */ public function save() { Logger::log("Enter: Video::save"); Logger::log("Calling: Content::save"); if ($this->content_id) { parent::save(); // if no permission is set then it is Nobody by default $this->file_perm = empty($this->file_perm) ? NONE : $this->file_perm; $sql = "UPDATE {videos} SET video_perm = ? WHERE content_id = ?"; $data = array($this->file_perm, $this->content_id); $res = Dal::query($sql, $data); if ($this->file_name) { $sql = "UPDATE {videos} SET video_file = ? WHERE content_id = ?"; $data = array($this->file_name, $this->content_id); $res = Dal::query($sql, $data); } } else { $this->display_on = 0; parent::save(); if (!$this->file_perm) { $this->file_perm = 0; } $sql = "INSERT INTO {videos} (content_id, video_file, video_perm) VALUES (?, ?, ?)"; $data = array($this->content_id, $this->file_name, $this->file_perm); $res = Dal::query($sql, $data); } Logger::log("Exit: Video::save"); return $this->content_id; }
/** * Saves Question in database * @access public */ public function save() { Logger::log("Enter: Question::save"); Logger::log("Calling: Content::save"); $this->created = time(); $this->changed = time(); $this->display_on = 0; $this->trackbacks = NULL; $id = parent::save(); $this->update_question($id); Logger::log("Exit: Question::save"); return $this->content_id; }
public function save() { Logger::log("Enter: Event::save"); // check for complete info if (empty($this->event_title)) { Logger::log(" Throwing exception REQUIRED_PARAMETERS_MISSING | Message: event_title is empty", LOGGER_ERROR); throw new CNException(REQUIRED_PARAMETERS_MISSING, 'Please supply an Event Title.'); } $this->title = $this->event_title; if (empty($this->start_time)) { Logger::log(" Throwing exception REQUIRED_PARAMETERS_MISSING | Message: start_time is empty", LOGGER_ERROR); throw new CNException(REQUIRED_PARAMETERS_MISSING, 'Please specify the Start Time.'); } if (empty($this->end_time)) { Logger::log(" Throwing exception REQUIRED_PARAMETERS_MISSING | Message: end_time is empty", LOGGER_ERROR); throw new CNException(REQUIRED_PARAMETERS_MISSING, 'Please specify the End Time.'); } // serialize event_data for storage $event_data = ""; if (!empty($this->event_data)) { $event_data = serialize($this->event_data); } // make end_time sane (can only be same or after start_time) if (strtotime($this->end_time) <= strtotime($this->start_time)) { $this->end_time = $this->start_time; } $this->author_id = $this->user_id; $this->body = $this->event_data['description']; // are we creating a new one? if (!$this->event_id) { /* if (empty($this->content_id)) { Logger::log(" Throwing exception REQUIRED_PARAMETERS_MISSING | Message: content_id is empty", LOGGER_ERROR); throw new CNException(REQUIRED_PARAMETERS_MISSING, 'Content id is missing.'); } */ // do we have a real User set as owner? if (!User::user_exist((int) $this->user_id)) { Logger::log(" Throwing exception USER_NOT_FOUND | Message: User does not exist", LOGGER_ERROR); throw new CNException(USER_NOT_FOUND, 'User does not exist.'); } // save a Content parent::save(); $sql = "INSERT INTO events \n (content_id, user_id, event_title, start_time, end_time, event_data) \n VALUES (?, ?, ?, ?, ?, ?)"; $data = array($this->content_id, $this->user_id, $this->event_title, $this->start_time, $this->end_time, $event_data); } else { // save as Content parent::save(); $sql = "UPDATE {events} SET " . "event_title = ?, start_time = ?, end_time = ?, event_data = ? " . "WHERE event_id = ?"; $data = array($this->event_title, $this->start_time, $this->end_time, $event_data, $this->event_id); } // write to DB try { Dal::query($sql, $data); if (!$this->event_id) { // newly created $this->event_id = Dal::insert_id(); } else { // update any existing EventAssociations EventAssociation::update_assocs_for_event($this); } // Finally - commit our changes to the DB Dal::commit(); } catch (CNException $e) { // roll back database operations and re-throw the exception Dal::rollback(); throw $e; } Logger::log("Exit: Event::save"); }
/** * Saves Image in database * @access public */ public function save() { Logger::log("Enter: Image::save_image"); Logger::log("Calling: Content::save"); //print '<pre>'; print_r($this); exit; if ($this->content_id) { parent::save(); // if no permission is set then it is Nobody by default $this->file_perm = empty($this->file_perm) ? NONE : $this->file_perm; $sql = "UPDATE {images} SET image_perm = ? WHERE content_id = ?"; $data = array($this->file_perm, $this->content_id); $res = Dal::query($sql, $data); if ($this->file_name) { $sql = "UPDATE {images} SET image_file = ? WHERE content_id = ?"; $data = array($this->file_name, $this->content_id); $res = Dal::query($sql, $data); } } else { $this->display_on = NULL; // carefull here this is NOT '0' parent::save(); if (!$this->file_perm) { $this->file_perm = 0; } $sql = "INSERT INTO {images} (content_id, image_file, image_perm) VALUES (?, ?, ?)"; $data = array($this->content_id, $this->file_name, $this->file_perm); $res = Dal::query($sql, $data); } //print '<pre>'; print_r($this); exit; Logger::log("Exit: Image::save_image"); return $this->content_id; }