Minahito
minah****@users*****
2005年 12月 25日 (日) 16:10:19 JST
Index: xoops2jp/html/kernel/member.php
diff -u xoops2jp/html/kernel/member.php:1.2.8.3 xoops2jp/html/kernel/member.php:1.2.8.4
--- xoops2jp/html/kernel/member.php:1.2.8.3 Sun Dec 25 16:01:27 2005
+++ xoops2jp/html/kernel/member.php Sun Dec 25 16:10:19 2005
@@ -1,5 +1,5 @@
<?php
-// $Id: member.php,v 1.2.8.3 2005/12/25 07:01:27 minahito Exp $
+// $Id: member.php,v 1.2.8.4 2005/12/25 07:10:19 minahito Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
@@ -437,7 +437,7 @@
$usersTable = $this->_mHandler->db->prefix('users');
$linkTable = $this->_mHandler->db->prefix('groups_users_link');
- $sql = "SELECT count(u.*) FROM ${usersTable} u LEFT JOIN ${linkTable} g ON u.uid=g.uid," .
+ $sql = "SELECT count(*) FROM ${usersTable} u LEFT JOIN ${linkTable} g ON u.uid=g.uid," .
"${usersTable} u2 LEFT JOIN ${linkTable} g2 ON u2.uid=g2.uid AND g2.groupid=${groupid} " .
"WHERE (g.groupid != ${groupid} OR g.groupid IS NULL) " .
"AND (g2.groupid = ${groupid} OR g2.groupid IS NULL) " .