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))