Was stimmt hier nicht?
function GenerateUserArrays($USER_ID)
{
GLOBAL $myCMS_GROUPS,$myCMS_USER,$myCMS_AREA;
$db = getDBObject();
// Userdaten aus der Datenbank....anhand der $PHP_AUTH_USER Variable
$myCMS_USER_sql = "SELECT user_id,login, pass,ip,dsc,fname,sname,street,zip,city,tel,fax,email,www,status,lastlogin FROM cms_users WHERE user_id=".$USER_ID;
$myCMS_USER_query = $db->Query($myCMS_USER_sql);
// Wenn User nicht gefunden
$db->ReadRow();
$myCMS_USER = $db->RowData;
$sql = "SELECT group_id FROM cms_users_groups WHERE user_id=".$myCMS_USER["user_id"];
$db->Query($sql);
while($db->ReadRow())
{
$myCMS_GROUPS["id"][] = $db->RowData["group_id"];
}
for($i=0;$i<count($myCMS_GROUPS["id"]);$i++)
{
$sql = "SELECT name FROM cms_groups WHERE group_id=".$myCMS_GROUPS["id"][$i];
$db->Query($sql);
while($db->ReadRow())
{
$myCMS_GROUPS["name"][$i] = $db->RowData["name"];
}
}
for($i=0;$i<count($myCMS_GROUPS["id"]);$i++)
{
$sql = "SELECT area_id FROM cms_groups_area WHERE group_id=".$myCMS_GROUPS["id"][$i];
$db->Query($sql);
while($db->ReadRow())
{
$myCMS_AREA["id"][] = $db->RowData["area_id"];
}
}
for($i=0;$i<count($myCMS_AREA["id"]);$i++)
{
$sql = "SELECT name FROM cms_area WHERE area_id=".$myCMS_AREA["id"][$i];
$db->Query($sql);
while($db->ReadRow())
{
$myCMS_AREA["name"][$i] = $db->RowData["name"];
}
}
// Doppelte Einträge aus den Arrays nehmen
$myCMS_AREA["id"] = uniqueArray($myCMS_AREA["id"]);
$myCMS_AREA["name"] = uniqueArray($myCMS_AREA["name"]);
$myCMS_GROUPS["id"] = uniqueArray($myCMS_GROUPS["id"]);
$myCMS_GROUPS["name"] = uniqueArray($myCMS_GROUPS["name"]);
return true;
}
[/php]