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

Timestamp:

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

Author:

ogawa

Message:

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

File:

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

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

@@ -241 +241 @@
     $page_size = intval($page_size);
 
-    $where = " WHERE true";
+    $wheres = array();
     $params = array();
 
@@ -247 +247 @@
         if ($value) {
             if ($key == 'image') {
-                $where .= " AND image_filename <> ''";
+                $wheres[] = "image_filename <> ''";
             } else {
-                $where .= " AND ". db_escapeIdentifier($key) ." = ?";
+                $wheres[] = db_escapeIdentifier($key) . ' = ?';
                 $params[] = $value;
                 if ($key == 'birth_year') {
-                    $where .= " AND public_flag_birth_year = 'public'";
+                    $wheres[] = "public_flag_birth_year = 'public'";
                 }
             }
@@ -259 +259 @@
     foreach ($cond_like as $key => $value) {
         if ($value) {
-            $where .= " AND " . db_escapeIdentifier($key) . " LIKE ?";
-            $params[] = '%'.$value.'%';
+            $wheres[] = db_escapeIdentifier($key) . ' LIKE ?';
+            $params[] = '%' . $value . '%';
         }
+    }
+    if ($wheres) {
+        $where = ' WHERE ' . implode(' AND ', $wheres);
+    } else {
+        $where = '';
     }