include INFUSIONS."gr_teamlist/infusion_db.php";

if (file_exists(INFUSIONS."gr_teamlist/locale/".LOCALESET."index.php")) {

	include INFUSIONS."gr_teamlist/locale/".LOCALESET."index.php";

} else {

	include INFUSIONS."gr_teamlist/locale/German/index.php";

}



add_to_title($locale['global_200'].$locale['grtl102']);



$result = dbquery("SELECT * FROM ".DB_GR_TEAMLIST_GROUP." ORDER BY tlg_position");

if (dbrows($result) != 0) {

while ($tl_group = dbarray($result)) {

	echo "<div align='center'><br />";

	$result2 = dbquery("SELECT * FROM ".DB_GR_TEAMLIST_USERS." WHERE tlu_groups='".$tl_group['tlg_id']."' ORDER BY tlu_position");

	if (dbrows($result2) != 2)  {

		if (dbrows($result2) > 2)  {

			$table_s = 1;

			echo "<table class='tbl-border' width='100%' align='center' cellpadding='0' cellspacing='0'>\n<tr>\n<td align='right' width='50%' class='tbl'>\n</td>\n<td width='50%' class='tbl'>\n</td>\n</tr>\n<tr>\n";

			$counter = 0; $columns = 2;

		} else {

			echo "<br />";

			$table_s = 0;

		}

		while ($tl_users = dbarray($result2)) {

			if ($table_s == 1) { if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";

			$align = $counter % $columns ? "left" : "right";

			echo "<td align='$align' width='50%' class='tbl'>";

			}

			if ($tl_users['tlu_userid'] != 0) {

				$result3 = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='".$tl_users['tlu_userid']."'");

				$tl_users2 = dbarray($result3);

			}

			if ($tl_users['tlu_pic'] != "" && file_exists(INFUSIONS."gr_teamlist/images/team/".$tl_users['tlu_pic'])) {

				$user_avatar = INFUSIONS."gr_teamlist/images/team/".$tl_users['tlu_pic'];

			} elseif ($tl_users2['user_avatar'] != "" && file_exists(IMAGES."avatars/".$tl_users2['user_avatar'])) {

				$user_avatar = IMAGES."avatars/".$tl_users2['user_avatar'];

			} else {

				$user_avatar = IMAGES."avatars/nopic.gif";

			}

			echo "<table width='272' class='tbl-border' cellspacing='0' cellpadding='0'>

	    <tr>

	    	<td colspan='3' class='tbl1' align='center'><strong>";

	      if ($tl_users['tlu_status'] == 1) {

	      	echo "<img border='0' src='".INFUSIONS."gr_teamlist/images/aktiv.gif' alt='Aktiv' width='9' height='12' /> ";

	      } else {

	      	echo "<img border='0' src='".INFUSIONS."gr_teamlist/images/inaktiv.gif' alt='Inaktiv' width='9' height='12' /> ";

	      }

	      if ($tl_users['tlu_userid'] != 0) {

	      	echo "<a href='".BASEDIR."profile.php?lookup=".$tl_users['tlu_userid']."'>".$tl_users2['user_name']."</a> (".$tl_users['tlu_abteil'].")</strong>";

	      } else {

	      	echo $locale['grtl200']." (".$tl_users['tlu_abteil'].")</strong>";

	      }

	    echo "</td>

	    </tr>

	    <tr>

	    	<td rowspan='3' width='70' class='tbl2'><img border='0' src='".$user_avatar."' alt='".$tl_users2['user_name']."' width='70' height='70' /></td>

	      <td align='right' class='tbl1' width='30'>".$locale['grtl201']."</td>

	      <td align='left' class='tbl2' width='150'>".$tl_users['tlu_rname']."</td>

	    </tr>

	    <tr>

	    	<td align='right' class='tbl1'>".$locale['grtl202']."</td>

	    	<td align='left' class='tbl2'>";

	      if (array_key_exists("user_birthdate", $tl_users2) && $tl_users2['user_birthdate'] != "0000-00-00" && $tl_users['tlu_userid'] != 0) {

					$user_birthdate = explode("-", $tl_users2['user_birthdate']);

					echo TL_ALTER(number_format($user_birthdate['2']),number_format($user_birthdate['1']),$user_birthdate['0']);

				}	else {

					echo $locale['grtl203'];

				}

	      echo "</td>

			</tr>

			<tr>

			<td align='right' class='tbl1'>".$locale['grtl204']."</td>

			<td align='left' class='tbl2'>";

		  	if (array_key_exists("user_location", $tl_users2) && $tl_users2['user_location'] != "" && $tl_users['tlu_userid'] != 0) {

		    	echo $tl_users2['user_location'];

		    } else {

		    	echo $locale['grtl203'];

		    }

		    echo"</td>