Mercurial > hg > extraction-interface
diff classes/basemodel.php @ 97:c1bb174a22f3 extractapp
Topic synchronization with LGServices. Adaption for moving table from Gazetteer to LGService.
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Tue, 16 Feb 2016 15:07:43 +0100 |
parents | f1f849d31272 |
children |
line wrap: on
line diff
--- a/classes/basemodel.php Mon Nov 23 16:24:57 2015 +0100 +++ b/classes/basemodel.php Tue Feb 16 15:07:43 2016 +0100 @@ -86,14 +86,15 @@ } protected function GetWordlist() { - $query = sprintf("SELECT * FROM `wordlist` WHERE `systemName`='%s' ORDER BY `name` ASC", $this->systemNAME); + $query = sprintf("SELECT * FROM `Wordlist` ORDER BY `name` ASC"); $result = mysql_query($query); if (!$result){ - return json_encode("Failed during selecting wordlist table.");; + return json_encode("Failed during selecting Wordlist table.");; } return $result; } + /* protected function GetSectionsById($section_id) { $query = sprintf("SELECT * FROM `sections_index` WHERE `id`=\"%s\"", $section_id); $result = mysql_query($query); @@ -103,16 +104,19 @@ } return $result; } + */ protected function GetTaglist() { - $query = sprintf("SELECT * FROM `taglist` WHERE `systemName`='%s' ORDER BY `tag` ASC", $this->systemNAME); + //$query = sprintf("SELECT * FROM `Taglist` WHERE `systemName`='%s' ORDER BY `tag` ASC", $this->systemNAME); + $query = sprintf("SELECT * FROM `Taglist` ORDER BY `tag` ASC"); $result = mysql_query($query); if (!$result) { - return json_encode("Failed during selecting taglist table."); + return json_encode("Failed during selecting Taglist table."); } return $result; } + /* protected function GetBooksById($bookId) { $query = sprintf("SELECT * FROM `books` WHERE id=\"%s\"", $bookId); $result = mysql_query($query); @@ -121,21 +125,33 @@ } return $result; } + */ + + protected function GetTagIdByTag($tag) { + $query = sprintf("SELECT * FROM `Taglist` WHERE `tag`='%s'", $tag); + $result = mysql_query($query); + if (!$result) { + return json_encode("Failed during selecting Taglist table."); + } + return $result["id"]; + } protected function GetTopicList() { - $query = sprintf("SELECT * FROM `topics`"); + //$query = sprintf("SELECT * FROM `topics`"); + $query = sprintf("SELECT * FROM `Topic`"); $result = mysql_query($query); if (!$result) { - return json_encode("Failed during selecting topics table."); + return json_encode("Failed during selecting Topic table."); } return $result; } protected function GetTopicById($topic_id) { - $query = sprintf("SELECT * FROM `topics` WHERE id=\"%s\"", $topic_id); + //$query = sprintf("SELECT * FROM `topics` WHERE id=\"%s\"", $topic_id); + $query = sprintf("SELECT * FROM `Topic` WHERE id=\"%s\"", $topic_id); $result = mysql_query($query); if (!$result) { - return json_encode("Failed during selecting topics table."); + return json_encode("Failed during selecting Topic table."); } return $result; }