Snippets
Groepslid
Ga naar de functie setup in session.php.
Neem het volgende scriptje op meteen na de regel global
- Snippets: Selecteer alles
$sql = 'SELECT group_name
FROM tbl_groups
INNER JOIN tbl_user_group on tbl_user_group.group_id = tbl_groups.group_id
INNER JOIN tbl_users on tbl_users.user_id = tbl_user_group.user_id
WHERE tbl_users.user_id = ' . $this->data['user_id'] . '
ORDER BY tbl_groups.group_name';
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$user_access[] = $row['group_name'];
}
$this-
>data['user_lid'] =
(in_array('Leden',
$user_access)) ?
1 : 0;
12130 maal bekeken