<?php
   include ('config.php');
   $con = mysql_connect("$server","$username","$password");
   if (!$con)
   {
       die('Could not connect: ' . mysql_error());
   }
   mysql_select_db("$database", $con);

   $sql = mysql_query("SELECT * FROM ava_games WHERE id=".$_GET['id']."");
   while($row = mysql_fetch_array($sql)){
       echo '<strong>'.$_GET['mess'].'</strong><br>';
       if ($row['import'] == 1) {
           echo '<object width="'.$row['width'].'" height="'.$row['height'].'">
<param name="movie" value="'.$site_url.'/games/'.$row['url'].'.swf">
<embed src="'.$site_url.'/games/'.$row['url'].'.swf" width="'.$row['width'].'" height="'.$row['height'].'">
</embed>
</object>';
       }
       else {echo '<object width="'.$row['width'].'" height="'.$row['height'].'">
<param name="movie" value="'.$row['url'].'">
<embed src="'.$row['url'].'" width="'.$row['width'].'" height="'.$row['height'].'">
</embed>
</object>';}
       echo '<div class="style3" id=itemheader>OYUN HAKKINDA BİLGİLER</div>';
       if ($adsense == 1) {
           include ('adsense/banner.php');}
           echo '<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td width="47.5%"><b><div align=left><u>OYUNUN ADI:</u></b><br>'.$row['name'].'</div><br><b><div align=left><u>OYUN BİLGİSİ:</u></b><br>'.$row['description'].'</div><div align=left><br><br>' ;
           if ($row['import'] == 1) {
               echo '<a href="'.$site_url.'/includes/full_screen.php?url='.$site_url.'/games/'.$row['url'].'.swf&id='.$_GET['id'].'"><img src="'.$site_url.'/images/full_screen2.PNG" width="100" height="18" /></a>';}
               else {echo '<a href="'.$site_url.'/includes/full_screen.php?url='.$row['url'].'&id='.$_GET['id'].'"><img src="'.$site_url.'/images/full_screen2.PNG" width="100" height="18" /></a>';}
               echo'<br><a href="'.$site_url.'/index.php?task=sendtofriend&id='.$row['id'].'"><img src="'.$site_url.'/images/taf2.PNG" width="100" height="18" /></a></div></td>
    <td>';
               $sqla = mysql_query("SELECT * FROM ava_games WHERE published=1 ORDER BY rand() LIMIT 3");
   }
   echo '<table border="0" width="98%">
   <tr width="47.5%"><b><div align=left>&nbsp;</b>';
   while($row = mysql_fetch_array($sqla)){
       if (strlen($row['description']) > 60) {
           $description = substr($row['description'], 0, 60)."...";}
           else {
               $description = $row['description'];
           }
           if (strlen($row['name']) > 23) {
               $name = substr($row['name'], 0, 23)."...";}
               else {
                   $name = $row['name'];
               }
               $abcd= $row['name'];
               $abcd = str_replace (" ", "-", $abcd);
               if ($seo_on == 0) {$url = ''.$site_url.'/index.php?task=view&id='.$row['id'].'';}
               else {$url = ''.$site_url.'/view/'.$row['id'].'/'.$abcd.'.htm';}
               echo '<div align=right>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="back">
  <tr>
    <td class="td3" width="1%"><div align="center"><a href="'.$url.'">';
               if ($row['import'] == 1) {
                   echo '<img src="'.$site_url.'/games/images/'.$row['url'].'.png" width="'.$image_width.'" height="'.$image_height.'" alt="" />';}else {echo '<img src="'.$row['image'].'" width="'.$image_width.'" height="'.$image_height.'" alt="" />';}
                   echo '</a></div></td>
    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td class="td1">&nbsp;<a href="'.$url.'">'.$name.'</a></td>
        </tr>
      <tr>
        <td width="70%" valign="top" class="td5">'.$description.'</td>';
                   $link = $row['id'];
                   $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM ava_comments WHERE link_id='$link'"),0);
                   echo ' <tr>
        <td class="td2">Times Played: '.$row['hits'].' </td>
        </tr>  
    </table></td>
  </tr>
  </tr>
</table><div><br>'; }
                   echo '</tr>';
                   echo '</td>
  </tr>
</table>';
                   if ($adsense == 1) {
                       include ('adsense/banner.php');}
                       echo '<br><br>';
 ?>