<?php
$dbhost = 'localhost';
$dbuser = 'godcraft_xen';
$dbpass = 'xxxxxxxxx';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'godcraft_xen';
mysql_select_db($dbname);
$q = mysql_query('SELECT u.username as username, up.user_upgrade_id as group_id
FROM xf_user u, xf_user_upgrade_active up
WHERE up.user_id = u.user_id
AND (up.user_upgrade_id = 3 OR up.user_upgrade_id = 4 OR up.user_upgrade_id = 5)
ORDER BY u.username asc') or die(mysql_error());
$q2 = mysql_query("SELECT u.username AS username FROM xf_user u, xf_user_upgrade_active up WHERE  up.user_id =  u.user_id AND up.user_upgrade_id = 2 AND u.username = ".$name."") or die(mysql_error());

while($row2 = mysql_fetch_array($q2)
{
  $name = strtolower($row2['username']);
  $names .= "&nbsp;&nbsp;&nbsp;&nbsp;$name:<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;group:<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;permissions:<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- stargate.world.pvpworld<br />";
}
while($row = mysql_fetch_array($q))
{
$name = strtolower($row['username']);
$group_id = $row['group_id'];
if($group_id == 3) $group = "VIP1";
else if($group_id == 4) $group = "VIP2";
else if($group_id == 5) $group = "VIP3";
if($group){
	$names .= "&nbsp;&nbsp;&nbsp;&nbsp;$name:<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;group: $group<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;permissions:<br />";
	if(mysql_num_rows($q2) > 0){
		$names .= "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- stargate.world.pvpworld<br />";
	}
}

echo $names;
?>