";
$i=0; //default first row which is zero
echo "
";
$tag=mysqli_result($result,$i,"vc15_Tag");
$Tag=htmlspecialchars($tag);
$name=mysqli_result($result,$i,"vc50_Name");
$founded=mysqli_result($result,$i,"dt_Found");
$sqactive=mysqli_result($result,$i,"bit_Active");
$surl=mysqli_result($result,$i,"vc100_URL");
$win=mysqli_result($result4,$i,"win");
$loss=mysqli_result($result4,$i,"loss");
$tie=mysqli_result($result4,$i,"tie");
echo "tag: | $Tag |
";
echo "name: | $name |
";
echo "founded: | $founded
|
";
echo "url: | $surl
|
";
echo "record: | W $win - L $loss - T $tie
|
";
echo "status: | ";
if ($sqactive==1) echo "Active ";
else echo "Inactive or desolved
|
";
//echo "
";
echo "Members";
echo "";
for ($j=0; $j < $num2; $j++) {
$active = mysqli_result($result2,$j,"bit_Active");
$player = mysqli_result($result2,$j,"vc15_Name");
if ($active==1) echo "$player | ";
else echo "$player (inactive/former member) | ";
}
echo " |
";
echo "Match History ";
echo "";
for ($x=0; $x<$num3; $x++) {
$matchdate=mysqli_result($result3,$x,"dt_Date");
$matchid=mysqli_result($result3,$x,"int_MatchID");
echo "$matchdate
| ";
}
echo " ";
echo " |
";
echo "
";
}
else
{
mysqli_connect($dbserver,$username,$password);
@mysqli_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tbl_Squads AS S WHERE S.vc15_Tag <> 'None' AND S.bit_Approved <> 0 ORDER BY S.bit_Active DESC";
//HAVING COUNT(P.int_PlayerID = H.int_PlayerID) FROM (tbl_Players AS P, tbl_SquadHistory AS H) <> 0
$result=mysqli_query($query);
$num=mysqli_num_rows($result);
mysqli_close();
echo "
Squad Information |
";
//$i=0;
echo "
";
echo "Tag | Squad Name | ";
for ($i=0; $i < $num; $i++)
{
$tag=mysqli_result($result,$i,"vc15_Tag");
$Tag=htmlspecialchars($tag);
$Tag2=str_replace("+","%2B",$Tag);
$name=mysqli_result($result,$i,"vc50_Name");
//$leader=mysqli_result($result,$i,"dt_Found");
$active=mysqli_result($result,$i,"bit_Active");
//$win=mysqli_result($result4,$i,"win");
//$loss=mysqli_result($result4,$i,"loss");
//$tie=mysqli_result($result4,$i,"tie");
if ($active==1) echo "$Tag | $name |
";
else echo "$Tag | $name (inactive) |
";
}
echo "
";
echo "
Back to all squads";
}
?>
Site design by Afrow UK & Fafner. Site code by !nFy & Dirk