Vergleich admin/modules/user/groups.php - 1.4.9 - 1.4.10

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*

 * $Id: groups.php 4324 2009-03-05 21:23:18Z Tikitiki $

 * $Id: groups.php 4417 2009-08-08 05:58:58Z RyanGordon $

 */

// Array of usergroup permission fields and their default values.

 */

// Array of usergroup permission fields and their default values.

Zeile 1189Zeile 1189
				SELECT g.gid, COUNT(u.uid) AS users
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."usergroups g ON (','|| u.additionalgroups|| ',' LIKE '%,'|| g.gid|| ',%')

				SELECT g.gid, COUNT(u.uid) AS users
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."usergroups g ON (','|| u.additionalgroups|| ',' LIKE '%,'|| g.gid|| ',%')

				WHERE g.gid != '0' AND g.gid != NULL GROUP BY g.gid

				WHERE g.gid != '0' AND g.gid is not NULL GROUP BY g.gid

			");
break;
default:

			");
break;
default:

Zeile 1197Zeile 1197
				SELECT g.gid, COUNT(u.uid) AS users
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."usergroups g ON (CONCAT(',', u.additionalgroups, ',') LIKE CONCAT('%,', g.gid, ',%'))

				SELECT g.gid, COUNT(u.uid) AS users
FROM ".TABLE_PREFIX."users u
LEFT JOIN ".TABLE_PREFIX."usergroups g ON (CONCAT(',', u.additionalgroups, ',') LIKE CONCAT('%,', g.gid, ',%'))

				WHERE g.gid != '0' AND g.gid != NULL GROUP BY g.gid

				WHERE g.gid != '0' AND g.gid is not NULL GROUP BY g.gid

			");
}
while($groupcount = $db->fetch_array($query))

			");
}
while($groupcount = $db->fetch_array($query))