From 0a7fb9da2e5aa6906dbbc64254bb0375c75820f0 Mon Sep 17 00:00:00 2001 From: mensonge Date: Mon, 16 Feb 2009 10:30:35 +0000 Subject: 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 --- services/tagservice.php | 21 +++++++++++++++++++-- 1 file changed, 19 insertions(+), 2 deletions(-) (limited to 'services/tagservice.php') 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.'"'; -- cgit v1.2.3