phpBB.de

Code: Alles auswählen

<?php
$abfragegruppe = "SELECT * FROM phpbb_user_group WHERE group_id = '11'";

$abfrageuser = mysql_query($abfragegruppe);
while($row = mysql_fetch_object($abfrageuser))
   {
   $abfrageusername = "SELECT * FROM phpbb_user WHERE id ='$abfragegruppe'";

$listuser = mysql_query($abfrageusername);

while($row = mysql_fetch_object($listuser))
   {
   echo "$row->username <br>";
   }

   }
?>

Code: Alles auswählen

SELECT u.user_id, u.username, ...
FROM phpbb_user_group ug
JOIN phpbb_users u ON (ug.user_id = u.user_id)
WHERE ug.group_id=123
ORDER BY u.username ASC

Code: Alles auswählen

define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

include($phpbb_root_path . 'memberlist.' . $phpEx , 'mode=group&g=');