<?php
function displayhafta() {
    global $maxmostpopular;
    $result = mysql_query("SELECT title, icon, rating, iconlocation, fileid, timesplayed FROM files WHERE status = '1' ORDER BY rand() DESC LIMIT 4 ");
    if (mysql_num_rows($result)) 
    {
        echo '<table width="100%"><tr>';
        while($row = mysql_fetch_array($result)) 
        {
            $mpfiletitle = $row['title'];
            $mpfileicon = $row['icon'];
            $mpfilerating = $row['rating'];
            $mpiconlocation = $row['iconlocation'];

            $mpfileid = $row['fileid'];
            $mptimesplayed = number_format($row['timesplayed']);
            if ($mpiconlocation == '4') 
            {
                $mpimageurl = $siteurl."/files/image/".$mpfileicon;
            } else {
                $mpimageurl = $mpfileicon;
            }
?>
            
            <td align="center"><br />
            <b><?php echo $mpfiletitle; ?></b><br /> 
            <a href = "<?php echo fileurl($mpfileid,$mpfiletitle); ?>" target="_self">
            <img src="<?php echo $mpimageurl; ?>" width="70" height="50" title="<?php echo $mpfiletitle; ?>" alt="<?php echo $mpfiletitle; ?>" border="2" bordercolor="orange"></a><br />
            <?php echo $mptimesplayed; ?> kez oyandı. Puanı : <?php echo $mpfilerating; ?></td>
    <?php
        }
        echo '</tr></table>';
    } else {
        echo "Oyun Bulunamadı";
    }

}

?>