Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
/*
3 
 * getUsers()
4 
 * holt alle User für diese Site aus der Accesstabelle
5 
 */
6 
	function getUsers()
7 
	{
8 
		global $localhost_dbh, $site;
9 
 
10 
		$query="
11 
				SELECT
12 
					ID,
13 
					user as username
14 
				FROM
15 
					content_management.Access
16 
				WHERE
17 
					ID > 0
18 
				AND
19 
					user like '%@$site'
20 
				ORDER BY user
21 
			";
22 
/*
23 
		$query="
24 
				SELECT
25 
					ID,
26 
					user as username
27 
				FROM
28 
					content_management.Access
29 
				WHERE
30 
					user = 'admin'
31 
				OR
32 
					user like '%@$site'
33 
				ORDER BY user
34 
			";
35 
*/
36 
		$result = mysql_query ($query, $localhost_dbh) or die (mysql_errno().": ".mysql_error());
37 
 
38 
		$buffer=array();
39 
		while ($zeile = mysql_fetch_assoc($result))
40 
		{
41 
			$buffer[$zeile[ID]] = $zeile[username];
42 
		}
43 
 
44 
		return $buffer;
45 
	}
46 
?>