Pagalbos! Include siunciamiause muzika

[Dj-zuikis123]

Sveiki, taigi pasidariau include siunčiamiausia muzika ir kaškodėl man kaškas netaip.
Kai ateina svečias jam rodo kad neranda tokios mysql lentelės ar ko ten...
O kai prisijungiu viskas gerai rodo ta siunčiamiausu muzika ir t.t

Kai neprisijunges :


Kai prisijunges :


Kame bėda nepagaunu.

Siunciamiausa muzika.php

 

<?php

require_once "maincore.php";
require_once THEMES."templates/header.php";

opentable("SiunĨiamiausia muzika");
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE ".groupaccess('download_cat_access')." ORDER BY download_count DESC LIMIT 0,80");
if (dbrows($result) != 0) {
echo "<div id='boxover'><table width='100%' cellpadding='0' cellspacing='0' align='left'>\n";
echo"<tr>

<td style='padding:3px;'><b>Pavadinimas:</b></td>
<td style='padding:3px;'><b>Įvertinimas:</b></td>
<td style='padding:3px;'>Įdėjo:</td>
<td style='padding:3px;'>Data:</td>
<td style='padding:3px;'>Parsisiuntimai:</td>

</tr>";
$n=0;
	while($data = dbarray($result)) {
	$n++;
					$user_down = dbarray(dbquery("SELECT user_id,user_name FROM ".DB_USERS." WHERE user_id='".$data['download_user']."' LIMIT 1"));
					$author = trimlink($user_down['user_name'], 8);
             	  	$wynik = dbquery("SELECT SUM(rating_vote) FROM ".DB_RATINGS." WHERE rating_type='F' AND rating_item_id='".$data['download_id']."'");
                	$info = dbresult($wynik,0);
              	 	$num_rating = dbcount("(rating_vote)", DB_RATINGS, "rating_type='F' AND rating_item_id='".$data['download_id']."'");
              		$wyn_rating = ($num_rating ? $info / $num_rating : 0);
echo"<tr bgcolor='#ffffff' onmouseover=\"this.style.background='#f6f6f6';\" onmouseout=\"this.style.background='#ffffff';\">";	
$cat = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'")); 
					$itemsubject = trimlink($data['download_title'], 36);
					
							$dow = @mysql_query("SELECT COUNT(rating_datestamp) as kiekbalsavo, AVG(rating_vote) as vidurkis from ".DB_RATINGS." WHERE rating_item_id='".$data['download_id']."'");

while ($q = @mysql_fetch_array($dow))
{
$vidurkis = round($q['vidurkis'], 2);
$kiekbalsavo = $q['kiekbalsavo'];
}
	
					
					echo"<td style='padding:3px;' width='325'>";
					echo"<b>$n</b>. <a href='downloads.php?cat_id=".$_GET['cat_id']."&did=".$data['download_id']."'>$itemsubject</a><br />\n";
					echo"</td><td style='padding:3px;' width='100'><b>$vidurkis</b> (<b>$kiekbalsavo</b> bals.)";
					echo"</td><td style='padding:3px;' width='60'><a href='".BASEDIR."narys/".$user_down['user_id']."/".$user_down['user_name']."'>".$author."</a></td>";
					echo"<td width='80'>".showdate("%Y.%m.%d", $data['download_datestamp'])."</td>";
					echo"<td align='center'>".$data['download_count']."</td>";
			
echo"</tr>";
}
echo"</table></div>";	
} else {
	echo "<center>".$locale['PD_004']."</center>\n";
}
closetable();

require_once THEMES."templates/footer.php";
?>