diff -r f937ccc6c144 -r 8642f1fb6499 hdalab/taginfo.php --- a/hdalab/taginfo.php Fri Feb 24 18:38:00 2012 +0100 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,63 +0,0 @@ - $label); - -$label = pg_escape_string($label); - -$rq = pg_query("SELECT id FROM hdabo_tag WHERE label ILIKE '$label'"); -$ids = array(); -while($ligne = pg_fetch_row($rq)) { - $ids[] = $ligne[0]; -} - -pg_free_result($rq); - -$sql = "SELECT COUNT(DISTINCT datasheet_id) FROM hdabo_taggedsheet V WHERE tag_id IN (" . join(",", $ids) . ") AND EXISTS (SELECT * FROM hdabo_datasheet W WHERE V.datasheet_id = W.id AND W.validated=TRUE)"; - -$rq = pg_query($sql); - -if ($ligne = pg_fetch_row($rq)) { - $resobj["content_count"] = $ligne[0]; -} - -$sql = "SELECT MAX(dbpedia_uri), MAX(wikipedia_url) FROM hdabo_tag WHERE id IN (" . join(",", $ids) . ")"; - -$rq = pg_query($sql); - -if ($ligne = pg_fetch_row($rq)) { - $resobj["dbpedia_uri"] = $ligne[0]; - $resobj["wikipedia_url"] = $ligne[1]; -} - -pg_free_result($rq); - -if (isset($resobj["dbpedia_uri"]) and $resobj["dbpedia_uri"]) { - $uri = $resobj["dbpedia_uri"]; - $sql = "SELECT abstract, label, thumbnail FROM dbpedia_fields WHERE dbpedia_uri = '$uri'"; - $rq = pg_query($sql); - if ($ligne = pg_fetch_row($rq)) { - $resobj["abstract"] = $ligne[0]; - $resobj["dbpedia_label"] = $ligne[1]; - $resobj["thumbnail"] = $ligne[2]; - } - - pg_free_result($rq); -} -/* -$sql = "SELECT * FROM hdaviz_simple_tag_links WHERE subject ILIKE '$label' OR object ILIKE '$label'"; -$rq = pg_query($sql); - -$resobj["links"] = pg_fetch_all($rq); -pg_free_result($rq); -*/ -echo json_encode($resobj); - -?> \ No newline at end of file