<?php
$db_server = "xxxx";
$db_name = "xxxx";
$db_user = "xxxx";
$db_passwort = "xxxx";
?>
<font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><b>Last 10 Members</b>
<br>
<?PHP
$db = @MYSQL_CONNECT($db_server,$db_user,$db_passwort);
$result = mysql_db_query("db_name","SELECT title,url,jointime,id,active FROM ats_members WHERE active='1'ORDER BY jointime DESC LIMIT 10");
while($satir = mysql_fetch_object($result))
{
echo "<a href=\"out.php?id=$satir->id\"target=\"_blank\">$satir->title</a> <br>";
}
?>
<br>
<b>Top 10 Hits In</b>
<br>
<?php
$result = mysql_db_query("db_name","SELECT title,url,active,id,unq_in_today FROM ats_members,ats_stats WHERE id = id2 AND active='1'AND unq_in_today >0 ORDER BY unq_in_today DESC LIMIT 10");
while($satir = mysql_fetch_object($result))
if(unq_in_today > 0) ;
else
{
echo
"$satir->unq_in_today <a href=\"out.php?id=$satir->id\"target=\"_blank\">$satir->title</a><br>";
}
?>
<br>
<b>Top 10 Hits Out</b>
<br>
<?php
$result = mysql_db_query("db_name","SELECT title,url,active,id,unq_out_today FROM ats_members,ats_stats WHERE id = id2 AND active='1' AND unq_out_today >0 ORDER BY unq_out_today DESC LIMIT 20");
while($satir = mysql_fetch_object($result))
if(unq_out_today > 0) ;
else
{
echo
"$satir->unq_out_today <a href=\"out.php?id=$satir->id\" target=\"_blank\">$satir->title</a><br>";
}
?>
<br>
<b>Total Sites:</b>
<b>
<?PHP
$db_select = @MYSQL_SELECT_DB($db_name);
$result = mysql_query("SELECT * FROM ats_members WHERE active=1");
$menge = mysql_num_rows($result);
echo
$menge;
?>
</b>
<br>
<b>Members wait for approve:</b>
<b>
<?PHP
$db_select = @MYSQL_SELECT_DB($db_name);
$result = mysql_query("SELECT * FROM ats_members WHERE active=0");
$menge = mysql_num_rows($result); echo $menge;
?>