Team credits

An open source project like Kunena requires the dedication and investment of personal time from various contributors. This version of Kunena Forum has been made possible by the following contributors :

Special thanks go to Beat and the CB Testing team, BoardBoss, madLyfe, infograf768 and Joomla! for significant contributions to Kunena. In addition many members of www.kunena.org have contributed and helped make this a more stable and bugfree version. Our thanks go out to all contributors of Kunena!

Language credits : English translation was made by Kunena Team with many suggestions and corrections from our community. We also like to give special thanks to all our translators, who have worked hard to localize Kunena to their own languages.

SELECTDISTINCT(user_id)
FROMaacgb2v5_usergroups as ug1
INNERJOINaacgb2v5_usergroupsAS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt
INNERJOINaacgb2v5_user_usergroup_mapAS m ON ug2.id=m.group_id
WHERE ug1.id IN (8)

SELECTDISTINCT(user_id)
FROMaacgb2v5_usergroups as ug1
INNERJOINaacgb2v5_usergroupsAS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt
INNERJOINaacgb2v5_user_usergroup_mapAS m ON ug2.id=m.group_id
WHERE ug1.id IN (7)

SELECT user_id, category_id, role FROMaacgb2v5_kunena_user_categoriesWHERE role IN (1,2)