diff options
author | 2008-11-28 06:09:45 +0000 | |
---|---|---|
committer | 2008-11-28 06:09:45 +0000 | |
commit | e0949aa0adfdfee4f78733277ff43d850ef3582e (patch) | |
tree | 49685833ea28c0a6522933520ba526ffdb0cb77f /services/tag2tagservice.php | |
parent | 96dfa82af5d9fd27b87eeef0ba877b022845e240 (diff) | |
download | scuttle-e0949aa0adfdfee4f78733277ff43d850ef3582e.tar.gz scuttle-e0949aa0adfdfee4f78733277ff43d850ef3582e.zip |
New Feature: possibility to import a structure of hierarchical tags from a file
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@179 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'services/tag2tagservice.php')
-rw-r--r-- | services/tag2tagservice.php | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/services/tag2tagservice.php b/services/tag2tagservice.php index 8c97606..4cce66d 100644 --- a/services/tag2tagservice.php +++ b/services/tag2tagservice.php @@ -16,11 +16,16 @@ class Tag2TagService { } function addLinkedTags($tag1, $tag2, $relationType, $uId) { + $tagservice =& ServiceFactory::getServiceInstance('TagService'); + $tag1 = $tagservice->normalize($tag1); + $tag2 = $tagservice->normalize($tag2); + if($tag1 == $tag2 || strlen($tag1) == 0 || strlen($tag2) == 0 || ($relationType != ">" && $relationType != "=") || ($this->existsLinkedTags($tag1, $tag2, $relationType, $uId))) { return false; } + $values = array('tag1' => $tag1, 'tag2' => $tag2, 'relationType'=> $relationType, 'uId'=> $uId); $query = 'INSERT INTO '. $this->getTableName() .' '. $this->db->sql_build_array('INSERT', $values); //die($query); @@ -214,11 +219,17 @@ class Tag2TagService { function existsLinkedTags($tag1, $tag2, $relationType, $uId) { + + //$tag1 = mysql_real_escape_string($tag1); + //$tag2 = mysql_real_escape_string($tag2); + $query = "SELECT tag1, tag2, relationType, uId FROM `". $this->getTableName() ."`"; $query.= " WHERE tag1 = '" .$tag1 ."'"; $query.= " AND tag2 = '".$tag2."'"; $query.= " AND relationType = '". $relationType ."'"; $query.= " AND uId = '".$uId."'"; + + //echo($query."<br>\n"); return $this->db->sql_numrows($this->db->sql_query($query)) > 0; } |