<?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());
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 />
				";
				$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 = "dorkinator"') or die(mysql_error());
				if(mysql_num_rows($q2)>0) $names .= "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- stargate.world.pvpworld<br />"
}

echo $names;
?>