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')

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-54-g00ecf