diff options
author | mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-02-16 10:30:35 +0000 |
---|---|---|
committer | mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-02-16 10:30:35 +0000 |
commit | 0a7fb9da2e5aa6906dbbc64254bb0375c75820f0 (patch) | |
tree | 042233014e756ffc8edd9d55a4b41552820d7f7c | |
parent | edddedaa94ffdd3b8899a00797d4f709e37ff277 (diff) | |
download | semanticscuttle-0a7fb9da2e5aa6906dbbc64254bb0375c75820f0.tar.gz semanticscuttle-0a7fb9da2e5aa6906dbbc64254bb0375c75820f0.tar.bz2 |
Bug fix: correct bug into description of tag
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@278 b3834d28-1941-0410-a4f8-b48e95affb8f
-rw-r--r-- | services/tagservice.php | 21 |
1 files changed, 19 insertions, 2 deletions
diff --git a/services/tagservice.php b/services/tagservice.php index 02f5c2b..fc44a99 100644 --- a/services/tagservice.php +++ b/services/tagservice.php @@ -32,6 +32,24 @@ class TagService { return array('tDescription'=>''); } } + + function existsDescription($tag, $uId) { + $query = 'SELECT tag, uId, tDescription'; + $query.= ' FROM '.$this->getTableName(); + $query.= ' WHERE tag = "'.$tag.'"'; + $query.= ' AND uId = "'.$uId.'"'; + + if (!($dbresult = & $this->db->sql_query($query))) { + message_die(GENERAL_ERROR, 'Could not get tag description', '', __LINE__, __FILE__, $query, $this->db); + return false; + } + + if ($row =& $this->db->sql_fetchrow($dbresult)) { + return true; + } else { + return false; + } + } function getAllDescriptions($tag) { $query = 'SELECT tag, uId, tDescription'; @@ -47,8 +65,7 @@ class TagService { } function updateDescription($tag, $uId, $desc) { - $objectTag = $this->getDescription($tag, $uId); - if(count($objectTag)>0 ) { + if($this->existsDescription($tag, $uId)) { $query = 'UPDATE '.$this->getTableName(); $query.= ' SET tDescription="'.$this->db->sql_escape($desc).'"'; $query.= ' WHERE tag="'.$tag.'" AND uId="'.$uId.'"'; |