Untitled



<?php include("includes/header1.inc"); ?>
<title>Syndicate Jailers - Members</title>
<?php include("includes/header2.inc"); ?>

<body>
<?php include("includes/header3.inc"); ?>
                    <div class="main_news_con">
                    	    <div class="main_news_post">
                        	<div class="main_news_post_img">
                            	<img src="images/news_post_img.jpg" alt="" />
                            </div>
                            <div class="main_news_post_text_con">
                            	<div class="main_news_post_text_details">
                                	<div class="main_news_post_text_title">
                                    	<a href="#">sJ Member List</a></div>
                                    <div class="main_news_post_text_date">
                                    	</div>
                                    <div class="main_news_post_text_comments">
                                    	Posted by Alex</div>
                                    <div class="clr"></div>
                                </div>
                                <div class="main_news_post_text">
                                	<p>
                                        <br />
                                       <?php
$tag=$_GET['tag'];
$loc="localhost";
$username="sj";
$password="FUCKING BLEEP";
$database="sj_xbl";
$link = mysql_connect($loc,$username,$password);
mysql_connect($loc,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM members WHERE tag='$tag'";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
mysql_close();

$i=0;
$tag=mysql_result($result,$i,"tag");
$email=mysql_result($result,$i,"email");
$points=mysql_result($result,$i,"points");
$referral=mysql_result($result,$i,"referral");
$age=mysql_result($result,$i,"age");
$rank=mysql_result($result,$i,"rank");
$active=mysql_result($result,$i,"active");

if ($active == 0) {
$status = '<font color="yellow">Pending</font>';
}
elseif ($active == 1) {
$status = '<font color="green">Active</font>';
}
elseif ($active == 2) {
$status = '<font color="red">Suspended</font>';
}

echo "GamerTag: $tag <br />
Email: $email <br />
GamerPoints: $points <br />
Age: $age <br />
Rank: $rank <br />
Status: $status<br />
";
?> </p>
                                </div>
                            </div>
                            <div class="clr"></div>
                        </div>
                    </div>
                </div>
               <?php include("includes/sidebar.inc"); ?>
                </div>
                <div class="clr"></div>
            </div>

                <?php include("includes/footer.inc"); ?>
                <div class="clr"></div>
            </div>
        </div>
    </div>
</div>
</body>
</html>