Nederlandstalige phpBB Support
https://www.phpbb.nl/forums/
Voor een overzicht van het aantal posts van één persoon in de verschillende subforums:SELECT f.forum_name AS 'Forum', u.username AS 'Gebruikersnaam', COUNT(p.post_id) AS 'Posts'
FROM phpbb_posts p, phpbb_users u, phpbb_forums f
WHERE p.poster_id = u.user_id
AND p.forum_id = f.forum_id
AND f.forum_name LIKE '%forum naam%'
GROUP BY p.poster_id
ORDER BY 'Posts' DESC;
SELECT f.forum_name AS 'Forum', u.username AS 'Gebruikersnaam', COUNT(p.post_id) AS 'Posts'
FROM phpbb_posts p, phpbb_users u, phpbb_forums f
WHERE p.poster_id = u.user_id
AND p.forum_id = f.forum_id
AND u.username LIKE '%gebruikers naam%'
GROUP BY f.forum_id
ORDER BY 'Posts' DESC;
mosymuis schreef:Dat zijn SQL query's, die draai je in phpMyAdmin.
Dacht ik al 
