Version |
Version 0.9.6002 dev |
|
include("config.php");
if (isset($_GET['player']))
{
$id = $_GET["player"];
mysqli_connect($dbserver,$username,$password);
@mysqli_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tbl_Players WHERE vc15_Name='$id' AND bit_Approved=1";
$query2="SELECT H.vc15_Tag, H.bit_Active
FROM tbl_Players AS P, tbl_SquadHistory AS H
WHERE P.int_PlayerID = H.int_PlayerID AND P.vc15_Name='$id' AND H.bit_Approved=1
ORDER BY H.bit_Active DESC";
$result=mysqli_query($query);
$result2=mysqli_query($query2);
$num=mysqli_num_rows($result);
$num2=mysqli_num_rows($result2);
mysqli_close();
echo " Player information |
---|
";
$i=0;
while ($i < $num) {
$name=mysqli_result($result,$i,"vc15_Name");
$email=str_replace("@",":at:",mysqli_result($result,$i,"vc50_Email"));
$aim=mysqli_result($result,$i,"vc25_AIM");
echo "name: $name ";
echo "email: $email ";
echo "aim: $aim ";
echo " ";
echo "Squads";
echo "";
$j=0;
while ($j < $num2) {
$active = mysqli_result($result2,$j,"bit_Active");
$tag = mysqli_result($result2,$j,"vc15_Tag");
$Tag=htmlspecialchars($tag);
$Tag2=str_replace("+","%2B",$Tag);
if ($active==1) echo "$Tag | ";
else echo "$Tag (inactive/former member) | ";
$j++;
}
echo " ";
$i++;
}
echo(" | ");
echo "Back to player list";
}
else
{
//echo "all players";
mysqli_connect($dbserver,$username,$password);
@mysqli_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tbl_Players WHERE bit_Approved = 1 ORDER BY vc15_Name";
$result=mysqli_query($query);
$num=mysqli_num_rows($result);
mysqli_close();
echo " Players in SquadBase |
---|
";
$i=0;
while ($i < $num) {
$name=mysqli_result($result,$i,"vc15_Name");
//$email=mysqli_result($result,$i,"vc50_Email");
//$aim=mysqli_result($result,$i,"vc25_AIM");
echo "$name ";
//echo "email: $email ";
//echo "aim: $aim ";
//echo " ";
/*echo "Squads";
echo "";
$j=0;
while ($j < $num2) {
$active = mysqli_result($result2,$j,"bit_Active");
$squad = mysqli_result($result2,$j,"vc15_Tag");
$Squad = htmlspecialchars($squad);
if ($active==1) echo "$Squad | ";
else echo "$Squad (inactive/former member) | ";
$j++;
}
echo " ";
*/
$i++;
} echo(" | ");
}
?>
|