Joovili v.2 – най-готините потребители!

Автор: SuCcEsS

Този код поставете в главната страница!

<table width="217" border="0" cellpadding="4" cellspacing="0">
<tr>
<td class="titles" width="110">Момчета</td>
<td width="1" class="text">
</td>
<td class="titles" width="110">Момичета</td>
</tr>
<tr>
<td class="text" width="110" align="center">
<?php


$show = $site_settings['joovili_show_users'];

$get_Musers = mysql_query("SELECT * FROM joovili_users WHERE profile_picture = '1' AND basic_gender = 'Male'
ORDER BY profile_views DESC LIMIT 1");

$number = 0;

while ($got_Musers = mysql_fetch_array($get_Musers)) {

$get_Mpictures = mysql_query("SELECT * FROM joovili_pictures
WHERE picture_type = '1'
AND picture_status = '1'
AND picture_username = '".$got_Musers['username']."'
LIMIT 1");

while ($got_Mpictures = mysql_fetch_array($get_Mpictures)){

$what_to_show = ' '.$got_Mpictures['picture_username'].' '.get_age($got_Musers['birth_day'],$got_Musers['birth_month'],$got_Musers['birth_year']) . ', '.' from '.$got_Musers['basic_country'].'';

?>
<a href="<?php echo $got_Mpictures['picture_username'];?>" title='<?php echo $what_to_show;?>'">
<img src="include/images.inc.php?picture=../<?php echo $got_Mpictures['picture_path'];?>" border="0" class="picture_borders" width="80" height="80" /></a>
</td>
<td class="text" width="1">
</td>
<td class="text" width="98" align="center">
<?php


$show = $site_settings['joovili_show_users'];

$get_lusers = mysql_query("SELECT * FROM joovili_users WHERE profile_picture = '1' AND basic_gender = 'Female'
ORDER BY profile_views DESC LIMIT 1");

$number = 0;

while ($got_lusers = mysql_fetch_array($get_lusers)) {

$get_lpictures = mysql_query("SELECT * FROM joovili_pictures
WHERE picture_type = '1'
AND picture_status = '1'
AND picture_username = '".$got_lusers['username']."'
LIMIT 1");

while ($got_lpictures = mysql_fetch_array($get_lpictures)){

$what_to_show = ' '.$got_lpictures['picture_username'].' '.get_age($got_lusers['birth_day'],$got_lusers['birth_month'],$got_lusers['birth_year']) . ', '.' from '.$got_lusers['basic_country'].'';

?>
<a href="<?php echo $got_lpictures['picture_username'];?>" title='<?php echo $what_to_show;?>'">
<img src="include/images.inc.php?picture=../<?php echo $got_lpictures['picture_path'];?>" border="0" class="picture_borders" width="80" height="80" /></a>
<?PHP }
}
}
}
?>
</td>
</tr>
</table>