phpBB.de

<?php
$download_dir = "media/";

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_DOWNLOADS);
init_userprefs($userdata);
//
// End session management
//

$sql = "SELECT file_name, free, extern, cat FROM " . DOWNLOADS_TABLE . " WHERE id = '$id'";
$result = mysql_query($sql);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

{
$sql_cat = "SELECT path FROM " . DL_CAT_TABLE . " WHERE id = ".$row['cat']."";
$result_cat = mysql_query($sql_cat);
$data = mysql_fetch_array($result_cat, MYSQL_ASSOC);
$file_path = $data['path'];
$file_name = $row['file_name'];
$file_size = ($row['extern']==1 ) ? '' : filesize($download_dir .$file_path.$file_name);
$file_free = $row['free'];
$file_extern = $row['extern'];
}

$user_id = $userdata['user_id'];

$sql = "SELECT user_traffic FROM " . USERS_TABLE . " WHERE user_id = '$user_id'";
$result = mysql_query($sql);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

{
$user_traffic = $row[user_traffic];
}

if ( $file_free == "1" OR $file_extern == "1")
{
$query_klicks = "UPDATE " . DOWNLOADS_TABLE . " SET klicks=klicks+1 WHERE id = '$id'";
$result_klicks = mysql_query($query_klicks);
}

if ( $userdata['session_logged_in'] AND $user_traffic > $file_size AND $file_free == "0" AND $file_free == "0" AND $file_extern == "0")
{
$query_traffic = "UPDATE " . USERS_TABLE . " SET user_traffic=user_traffic-" . $file_size . " WHERE user_id = '$user_id'";
$query_klicks = "UPDATE " . DOWNLOADS_TABLE . " SET klicks=klicks+1 WHERE id = '$id'";
$result_traffic = mysql_query($query_traffic);
$result_klicks = mysql_query($query_klicks);
}

if ( $file_extern == "1" )
{
Header("Location: $file_name");
}

if ( $file_free == "1" OR ( $userdata['session_logged_in'] AND $user_traffic > $file_size) )
{
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"$file_name\"");
readfile($download_dir . "" . $file_path . "/" . $file_name);
}

?>