Changeset 3604 for trunk/components/Textcube.Data.Category.php

Timestamp:

07/05/07 17:26:31 (3 years ago)

Author:

inureyes

Message:

#428

• '그거' 했습니다. 묵념.
• variable $owner, Table field 'owner' is deprecated.

Files:

• trunk/components/Textcube.Data.Category.php (modified) (7 diffs)

trunk/components/Textcube.Data.Category.php

@@ -23 +23 @@
     /*@polymorphous(numeric $id, $fields, $sort)@*/
     function open($filter = true, $fields = '*', $sort = 'priority') {
-        global $database, $owner;
+        global $database;
         if (is_numeric($filter)) {
             $filter = 'AND id = ' . $filter;
@@ -35 +35 @@
             $sort = 'ORDER BY ' . $sort;
         $this->close();
-        $this->_result = mysql_query("SELECT $fields FROM {$database['prefix']}Categories WHERE owner = $owner $filter $sort");
+        $this->_result = mysql_query("SELECT $fields FROM {$database['prefix']}Categories WHERE blogid = ".getBlogId()." $filter $sort");
         if ($this->_result)
             $this->_count = mysql_num_rows($this->_result);
@@ -54 +54 @@
         if ($this->_result && ($row = mysql_fetch_assoc($this->_result))) {
             foreach ($row as $name => $value) {
-                if ($name == 'owner')
+                if ($name == 'blogid')
                     continue;
                 switch ($name) {
@@ -72 +72 @@
     
     function add() {
-        global $database, $owner;
+        global $database;
         if($this->id != 0) $this->id = null;
         if (isset($this->parent) && !is_numeric($this->parent))
@@ -81 +81 @@
         
         $query = new TableQuery($database['prefix'] . 'Categories');
-        $query->setQualifier('owner', $owner);
+        $query->setQualifier('blogid', getBlogId());
         if (isset($this->parent)) {
             if (($parentLabel = Category::getLabel($this->parent)) === null)
@@ -117 +117 @@
 
     function getNextCategoryId($id = 0) {
-        global $database, $owner;
-        $maxId = DBQuery::queryCell("SELECT MAX(id) FROM {$database['prefix']}Categories WHERE owner = $owner"); 
+        global $database;
+        $maxId = DBQuery::queryCell("SELECT MAX(id) FROM {$database['prefix']}Categories WHERE blogid = ".getBlogId()); 
         if($id==0)
             return $maxId + 1;
@@ -144 +144 @@
     /*@static@*/
     function doesExist($id) {
-        global $database, $owner;
+        global $database;
         if (!Validator::number($id, 0))
             return false;
         if ($id == 0) return true; // not specified case
-        return DBQuery::queryExistence("SELECT id FROM {$database['prefix']}Categories WHERE owner = $owner AND id = $id");
+        return DBQuery::queryExistence("SELECT id FROM {$database['prefix']}Categories WHERE blogid = ".getBlogId()." AND id = $id");
     }
     
     /*@static@*/
     function getId($label) {
-        global $database, $owner;
+        global $database;
         if (empty($label))
             return null;
-        return DBQuery::queryCell("SELECT id FROM {$database['prefix']}Categories WHERE owner = $owner AND label = '" . mysql_tt_escape_string($label) . "'");
+        return DBQuery::queryCell("SELECT id FROM {$database['prefix']}Categories WHERE blogid = ".getBlogId()." AND label = '" . mysql_tt_escape_string($label) . "'");
     }
     
     /*@static@*/
     function getLabel($id) {
-        global $database, $owner;
+        global $database;
         if (!Validator::number($id, 1))
             return null;
-        return DBQuery::queryCell("SELECT label FROM {$database['prefix']}Categories WHERE owner = $owner AND id = $id");
+        return DBQuery::queryCell("SELECT label FROM {$database['prefix']}Categories WHERE blogid = ".getBlogId()." AND id = $id");
     }
 
     /*@static@*/
     function getParent($id) {
-        global $database, $owner;
+        global $database;
         if (!Validator::number($id, 1))
             return null;
-        return DBQuery::queryCell("SELECT parent FROM {$database['prefix']}Categories WHERE owner = $owner AND id = $id");
+        return DBQuery::queryCell("SELECT parent FROM {$database['prefix']}Categories WHERE blogid = ".getBlogId()." AND id = $id");
     }