public function __construct($database, $tag) { $this->db = $database; $sql = $this->db->prepare("SELECT tag, creation_date, creation_commit, modification_date, modification_commit, label, position FROM tags WHERE tag = :tag"); $sql->bindParam(":tag", $tag); if ($sql->execute()) { $this->tag = $sql->fetch(); } // phantom is actually a chapter if (isPhantom($this->tag["label"])) { $this->tag["type"] = "chapter"; } $sql = $this->db->prepare("SELECT tag, node_count, edge_count, total_edge_count, chapter_count, section_count, use_count, indirect_use_count FROM graphs WHERE tag = :tag"); $sql->bindParam(":tag", $tag); if ($sql->execute()) { $this->graphs = $sql->fetch(); } }
public function __construct($database, $tag) { $this->db = $database; $sql = $this->db->prepare("SELECT tag, creation_date, creation_commit, modification_date, modification_commit, label, position, type FROM tags WHERE tag = :tag"); $sql->bindParam(":tag", $tag); if ($sql->execute()) { $this->tag = $sql->fetch(); } $sql = $this->db->prepare("SELECT changes.tag, changes.hash, changes.file, changes.type, changes.begin, changes.end, changes.label, commits.time FROM changes, commits WHERE commits.hash = changes.hash AND tag = :tag"); $sql->bindParam(":tag", $tag); if ($sql->execute()) { $this->changes = $sql->fetchAll(); } // remove the ghost "change in proof" that occurs after tag assignment $index = -1; for ($i = 0; $i < sizeof($this->changes); $i++) { if ($this->changes[$i]["type"] == "tag") { $index = $i; } } if ($index != -1) { array_splice($this->changes, $index + 1, 1); } // phantom is actually a chapter if (isPhantom($this->tag["label"])) { $this->tag["type"] = "chapter"; } $sql = $this->db->prepare("SELECT tag, node_count, edge_count, total_edge_count, chapter_count, section_count, use_count, indirect_use_count FROM graphs WHERE tag = :tag"); $sql->bindParam(":tag", $tag); if ($sql->execute()) { $this->graphs = $sql->fetch(); } }
public function __construct($database, $tag) { $this->db = $database; $sql = $this->db->prepare("SELECT tag, name, position, reference, type, book_id, chapter_page, book_page, label, file, value, begin, end, slogan, history FROM tags WHERE tag = :tag"); $sql->bindParam(":tag", $tag); if ($sql->execute()) { $this->tag = $sql->fetch(); } // phantom is actually a chapter if (isPhantom($this->tag["label"])) { $this->tag["type"] = "chapter"; } }