public function save_parents($child_version_id = 0, $array = array(), $start_seconds = array(), $end_seconds = array(), $start_line_nums = array(), $end_line_nums = array(), $points = array()) { // Insert new relationships $j = 0; foreach ($array as $version_urn) { if (isURN($version_urn)) { $parent_version_id = $this->version_urn_to_version_id($version_urn); } if (empty($parent_version_id)) { continue; } $_start_seconds = isset($start_seconds[$j]) ? $start_seconds[$j] : 0; $_end_seconds = isset($end_seconds[$j]) ? $end_seconds[$j] : 0; $_start_line_num = isset($start_line_nums[$j]) ? $start_line_nums[$j] : 0; $_end_line_num = isset($end_line_nums[$j]) ? $end_line_nums[$j] : 0; $_points = isset($points[$j]) ? $points[$j] : ''; $data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'start_seconds' => $_start_seconds, 'end_seconds' => $_end_seconds, 'start_line_num' => $_start_line_num, 'end_line_num' => $_end_line_num, 'points' => $_points); $this->db->insert($this->annotations_table, $data); if (mysql_errno() != 0) { echo 'MySQL ERROR: ' . mysql_error() . "\n"; } $j++; } return true; }
public function save_parents($child_version_id, $array = array()) { $array = array_unique($array); // Establish new connections foreach ($array as $version_urn) { if (isURN($version_urn)) { $parent_version_id = $this->version_urn_to_version_id($version_urn); } if (empty($parent_version_id)) { continue; } $data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id); $this->db->insert($this->tags_table, $data); } return true; }
public function save_parents($child_version_id, $array = array()) { $array = array_unique($array); // Delete previous connections $this->db->select('*'); $this->db->from($this->tags_table); $this->db->where('child_version_id', $child_version_id); $query = $this->db->get(); $result = $query->result(); // Establish new connections foreach ($array as $version_urn) { if (isURN($version_urn)) { $parent_version_id = $this->version_urn_to_version_id($version_urn); } if (empty($parent_version_id)) { continue; } $data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id); $this->db->insert($this->tags_table, $data); } return true; }
public function save_children($parent_version_id = 0, $array = array(), $reference_array = array()) { if (empty($parent_version_id)) { throw new Exception('Inalid parent version ID'); } if (empty($array)) { return; } for ($i = 0; $i < count($array); $i++) { if (isURN($array[$i])) { $child_version_id = $this->page_urn_to_content_id($array[$i]); } if (empty($child_version_id)) { continue; } $reference_text = isset($reference_array[$i]) ? trim($reference_array[$i]) : ''; $this->db->select('*'); $this->db->from($this->references_table); $this->db->where('parent_version_id', $parent_version_id); $this->db->where('child_version_id', $child_version_id); $query = $this->db->get(); if ($query->num_rows > 0) { continue; } $data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'reference_text' => $reference_text); $this->db->insert($this->references_table, $data); } }
public function save_parents($child_version_id = 0, $array = array(), $sort_numbers = 0) { if (count($array) == 0) { return; } // Insert new relationships $count = 0; foreach ($array as $version_urn) { if (isURN($version_urn)) { $parent_version_id = $this->version_urn_to_version_id($version_urn); } if (empty($parent_version_id)) { continue; } $sort_number = @(int) $sort_numbers[$count]; $data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'sort_number' => $sort_number); $done = $this->db->insert($this->paths_table, $data); if (mysql_errno() != 0) { echo 'MySQL ERROR: ' . mysql_error() . "\n"; } $count++; } return true; }
public function save_parents($child_version_id, $array = array(), $paragraph_num_array = array(), $created_array = array()) { $array = array_unique($array); // Establish new connections $j = 0; foreach ($array as $version_urn) { if (isURN($version_urn)) { $parent_version_id = $this->version_urn_to_version_id($version_urn); } if (empty($parent_version_id)) { continue; } $paragraph_num = (int) $paragraph_num_array[$j]; $created = $created_array[$j]; if (empty($created)) { $created = date('c'); } $data = array('parent_version_id' => $parent_version_id, 'child_version_id' => $child_version_id, 'paragraph_num' => $paragraph_num, 'datetime' => $created); $this->db->insert($this->replies_table, $data); $j++; } return true; }