<?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') or die(mysql_error());
$excludedPeople = array("Sniper3","Sounas")
while($row2 = mysql_fetch_array($q2))
{

	$name = strtolower($row2['username']);
	$canWrite = 1;
	for ($i = 2; $i > 0; $i++) {
		if($name == $excludedPeople){
			$canWrite = 0;
			break;
		}
	}
	if($canWrite == 1){
		$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']);
	$canWrite = 1;
	for ($i = 2; $i > 0; $i++) {
		if($name == $excludedPeople){
			$canWrite = 0;
			break;
		}
	}
	if($canWrite == 1){
		$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 username = '$name' AND up.user_upgrade_id = 2") 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;
?>