Changeset 4272 for OpenPNE/trunk/webapp/lib/db/commu.php

Timestamp:

Oct 3, 2007, 8:02:58 PM (13 years ago)

Author:

ogawa

Message:

#1348:MySQL4.0以前の環境で管理画面のメンバーリストに誰も表示されない

File:

• OpenPNE/trunk/webapp/lib/db/commu.php (modified) (3 diffs)

OpenPNE/trunk/webapp/lib/db/commu.php

@@ -1710 +1710 @@
     $select = 'SELECT c_commu.*';
 
-    $where = ' WHERE true';
+    $wheres = array();
     $params = array();
     if ($c_commu_category_id) {
-        $where .= ' AND c_commu.c_commu_category_id = ?';
+        $wheres[] = 'c_commu.c_commu_category_id = ?';
         $params[] = $c_commu_category_id;
     }
@@ -1721 +1721 @@
             $word = check_search_word($word);
 
-            $where .= ' AND (c_commu.name LIKE ? OR c_commu.info LIKE ?)';
+            $wheres[] = '(c_commu.name LIKE ? OR c_commu.info LIKE ?)';
             $params[] = '%'.$word.'%';
             $params[] = '%'.$word.'%';
         }
+    }
+    if ($wheres) {
+        $where = ' WHERE ' . implode(' AND ', $wheres);
+    } else {
+        $where = '';
     }
 
@@ -1799 +1804 @@
     $sql = 'SELECT * FROM c_commu';
 
-    $where = ' WHERE true';
+    $wheres = array();
     $params = array();
     if ($search_word) {
-        $where .= ' AND (name LIKE ? OR info LIKE ?)';
+        $wheres[] = '(name LIKE ? OR info LIKE ?)';
         $params[] = '%'.$search_word.'%';
         $params[] = '%'.$search_word.'%';
     }
     if ($c_commu_category_id != 'all' && $c_commu_category_id) {
-        $where .= ' AND c_commu_category_id = ?';
+        $wheres[] = 'c_commu_category_id = ?';
         $params[] = intval($c_commu_category_id);
+    }
+    if ($wheres) {
+        $where = ' WHERE ' . implode(' AND ', $wheres);
+    } else {
+        $where = '';
     }