Hele header0.php:
<?
require_once('database.php');
$filtyper = array(
'ace' => 'Pakket i ACE-format',
'exe' => 'Program',
'mov' => 'Filmklip i Apple QuickTime format',
'mp3' => 'Lyd i MP3-format',
'mpeg' => 'Filmklip i MPEG format',
'mpg' => 'Filmklip i MPEG format',
'ra' => 'Lyd i RealAudio format',
'ram' => 'Multimedieklip i RealMedia format',
'rar' => 'Pakket i RAR-format',
'zip' => 'Pakket i ZIP-format',
);
function getFileDisplay($id, $extended=false) {
global $filtyper;
$id = (int) $id;
$sql = "SELECT id, category, title, subtitle, description, filesize, url, UNIX_TIMESTAMP(timestamp) AS timestamp, rating, asin, text, attention, producent FROM dlc_files WHERE id=$id";
$result = mysql_query($sql);
$file = mysql_fetch_array($result);
if (!$file) return false;
$html = '<div class="filedisplay">
<br>
<div class="left"><br><br>
';
$buyurl = '';
$imgurl = '/images/category/boxshot/'.$file['category'];
if (strlen($file['asin'])) {
$buyurl = '
http://www.Amazon.co.uk/exec/obidos/ASIN/'.$file['asin'].'/downloadcentra03'; $imgurl = '
http://images-eu.amazon.com/images/P/'.$file['asin'].'.02.MZZZZZZZ.jpg'; }
if (
is_file('images/boxshot/'.$id.'.jpg')
|| is_file('images/boxshot/'.$id.'.gif')
|| is_file('images/boxshot/'.$id.'.png')
)
$imgurl = '/images/boxshot/'.$id.'.gif';
if (strlen($buyurl))
$html .= '<a href="'.$buyurl.'" target="_blank">';
$html .= '<img src="'.$imgurl.'" />';
if (strlen($buyurl))
$html .= '</a>';
$html .= '<br />';
if (false && $buyurl)
$html .= '<a href="'.$buyurl.'">Bestil Online</a>';
$html .= '</div>
<div class="right">
<div class="title"> <table height="30" width="260" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#7F505F" summary="">
<tr velign="top">
<td velign="top">'.htmlspecialchars($file['title']).' '.htmlspecialchars($file['subtitle']).'
</td></tr></table></div>
<br><br>
<p>';
if ($file['rating']!==null && $file['rating'] >= 0 && $file['rating'] <= 5) {
$html .= '<img src="/images/stars-blue-'.$file['rating'].'-0.gif" width="55" height="12" alt="Rating: '.$file['rating'].' ud af 5 stjerner!" /><br />
';
} else {
$html .= '<img src="/images/notrated.gif" alt="Ingen rating" /><br />
';
}
$html .= '<strong>'.htmlspecialchars($file['description']).'</strong>';
if (true || $extended) $html .= ' '.htmlspecialchars($file['text']);
$html .= '</p>
<p>';
$html .= '<a href="/download.php?fileid='.$id.'"><img src="/images/downloadicon.png" alt="" /></a> <a href="/download.php?fileid='.$id.'">Download</a>
';
if (!$extended)
$html .= '<a href="/file/.php?fileid='.$id.'"><img src="/images/infoicon.png" alt="" /></a> <a href="/file.php?fileid='.$id.'">Mere info</a>
';
if (strlen($buyurl)) {
$html .= '<a href="'.$buyurl.'"><img src="/images/shoppingicon.png" alt="" /></a> <a href="'.$buyurl.'" target="_blank">Køb</a>
';
}
$html .= '</p>';
$html .= '</div>
<div class="extra"><br>
';
if ($extended) {
$html .= '<table>
<tr><td>Opdateret: </td><td>'.date('j/n Y', $file['timestamp']).'</td></tr>
<tr><td>Størrelse: </td><td>';
if ($file['filesize']>0) {
$html .= round($file['filesize']/1048576.0, 2).' MB';
} else {
$html .= 'Ukendt';
}
$html .= '</td></tr>
<tr><td>Producent: </td><td>'.htmlspecialchars($file['producent']).'</td></tr>
<tr><td>Type: </td><td>';
// Kig om urlen slutter med et punktum og ét eller flere tegn, som enten er bogstaver, tal eller "_"
preg_match('/\.([a-zA-Z0-9_]+)$/', $file['url'], $match);
// Gem denne slutning i $type
$type = @$match[1];
// Tjek om den type er defineret
if (isset($filtyper[$type])) {
$html .= htmlspecialchars($filtyper[$type]);
} elseif($type===null){
$html .= 'Ukendt';
} else {
$html .= 'Ukendt ('.$type.')';
}
$html .= '</td></tr>
</table>
';
}
if ($extended && strlen($file['attention'])) {
$html .= '<p class="attention">'.htmlspecialchars($file['attention']).'</p>
';
}
$html .='</div>
</div>
';
return $html;
}
?>
</html>