<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."downloads.php";

if (isset($download_id) && !isNum($download_id)) fallback("index.php");

if (isset($download_id)) {
	$res = 0;
	if ($data = dbarray(dbquery("SELECT download_url,download_cat FROM ".$db_prefix."downloads WHERE download_id='$download_id'"))) {
		$cdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'"));
		if (checkgroup($cdata['download_cat_access'])) {
			$res = 1;
			$result = dbquery("UPDATE ".$db_prefix."downloads SET download_count=download_count+1 WHERE download_id='$download_id'");
			redirect($data['download_url']);
		}
	}
	if ($res == 0) redirect("downloads.php");
}



if (isset($d_id)) {
include INCLUDES."comments_include.php";
//$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='$d_id'");


				$result = dbquery("SELECT td.*, tu.user_id,user_name FROM ".$db_prefix."downloads td
				LEFT JOIN ".$db_prefix."users tu ON tu.user_id=td.download_author
				WHERE td.download_id='$d_id'");

				
				while ($data = dbarray($result)) {
					$id = $data['download_cat'];
					if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
						$new = " <span class='small'>".$locale['410']."</span>";
					} else {
						$new = "";
					}
					
					$time = $data['download_datestamp'];
					$laikas = showdate( "%y.%m.%d", $time);
					$cat = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'")); 
					
					echo "<table style='width:450px' align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
					echo "<tr>
<td colspan='5' class='forum-caption'>
					<table border='0' cellpadding='0' cellspacing='0' style='width:450px' align='center'>
<tr>";
echo "<tr><td align='left' class='tbl'><i>".$cat['download_cat_name']."</i>";

							echo "<tr><td style='width:450px' align='center' class='tbl'><b>".$data['download_title']."</b></td></tr>\n";
		
		echo"<tr><td align='center' style='padding-top: 6px; padding-bttom:6px;'>";
		
		//echo'<embed height="20" border="0" width="350" style="margin-top: 6px; margin-bttom:6px;" wmode="transparent" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="mp3player" quality="high" menu="false" src="http://www.specmusic.net/mediaplayer.swf?backcolor=0xf7af21&frontcolor=71af00&lightcolor=71af00&file='.$data['download_url'].'&type=flv" allowscriptaccess="never"/>';
		
		if(preg_match('/zippyshare/i' , $data['download_url'])){
		echo zip($data['download_url']);
		} else { echo"Nera perklausos nuorodos"; }
		
		echo"</td></tr>";

		echo "</table></tr></td></tr>\n";
				
					 echo "<tr>\n
					<td colspan='5' class='tbl1'></td>\n</tr>\n";
					echo "<tr>\n";		
					echo "<td width='30%' class='tbl2'><b>Prid&#279;tas:</b> $laikas </td>\n";
					
					
					
				echo"	<td width='30%' class='tbl1'><b>Atsisiunt&#279;:</b> ".$data['download_count']."</td>\n<td width='80' height='18' bgcolor='#71af00' style='white-space:nowrap;padding: 0em 0.5em 0em 0.5em;'><div align='center'><span style='display: none'></span><a href='".FUSION_SELF."?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' target='_blank' style='color:#ffffff;' title='Atsisi&#371;sti fail&#261;'><b>Si&#371;stis</b></a></td></tr><tr>";

					echo "</table>\n";
		echo "<table width='70%' cellpadding='0' cellspacing='1' align='center'>\n";
					echo "<tr>
<td colspan='5' class='forum-caption'>
					<table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%' align='center'>
<tr>";

		echo "</table></tr></td></tr>";

					
					 echo "<table style='width:450px' align='center' class='tbl-border' cellspacing='1' cellpadding='0'>";	
					echo "<tr><td class='tbl2' style='width:80px;'>Nuoroda</td>";
					echo "<td class='tbl1' width='450px'><input type='text' value='".$settings['siteurl']."muzika-".seoname($data['download_title'])."-".$data['download_id']."' class='textbox' style='font-size:11px;width:350px' onClick='javascript:this.select();'/></td></tr>\n";
					echo "<tr><td class='tbl2' style='width:80px;'>BB Kodas</td>";
					echo "<td class='tbl1' width='450px'><input type='text' value='[url=".$settings['siteurl']."muzika-".seoname($data['download_title'])."-".$data['download_id']."]".$data['download_title']."[/url]' class='textbox' style='font-size:11px;width:350px' onClick='javascript:this.select();' /></td></tr>\n";
					echo "<tr><td class='tbl2' style='width:80px;'>HTML Kodas</td>";
					echo "<td class='tbl1' width='450px'><input type='text' value='<a href=\"".$settings['siteurl']."muzika-".seoname($data['download_title'])."-".$data['download_id']."\">".$data['download_title']."</a>' class='textbox' style='font-size:11px;width:350px' onClick='javascript:this.select();' /></td></tr>\n";
					echo "</table><br>";
echo "<table width='450px' align='center' class='tbl-border' cellspacing='1' cellpadding='0'>\n";						
echo "</table>";					
						
							  if (iADMIN && (iUSER_RIGHTS != "" || iUSER_RIGHTS != "SD")) {
		echo "<table width='100%' cellspacing='1' cellpadding='0' border='0' class='small'>";
	        echo "</table>\n";
	        } 
					 
					if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
				}
				
				
showcomments("D","downloads","download_id",$d_id,FUSION_SELF."?d_id=$d_id");


} else {



if (!isset($cat_id)) {
	
	$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
	$rows = dbrows($result);
	if ($rows != 0) {
		$counter = 0; $columns = 2;
		echo "<table class='tbl-border' style='margin-top: 5px;' cellpadding='0' cellspacing='1' width='100%' align='center'>";
		
		echo "<tr>
</td>
</tr>";
		
		while ($data = dbarray($result)) {
			
			$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
			echo "<tr>

			<td class='tbl2' >» 
			<a href='".BASEDIR."muzika-".$data['download_cat_id']."-".seoname($data['download_cat_name'])."' title='Muzikos: ".$num."'>".$data['download_cat_name']." </a>
</td>";
			
		}
echo "
</td>
</tr>
</table>";
		
		$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,10");
		
if (dbrows($result)) {

echo "<table class='tbl-border' style='margin-top: 10px;' border='0' cellpadding='0' cellspacing='1' width='100%'>
<tr>
		<td class='forum-caption' style='white-space: nowrap;'>» 10 Naujausiu siuntiniu</td>
		<td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Data</td>

		<td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Siuntimai</td>
</tr>";
while ($data = dbarray($result)) {

$cat = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'")); 
$time = $data['download_datestamp'];
$laikas = showdate( "%y.%m.%d", $time);
$itemsubject = trimlink($data['download_title'], 55);
echo "<tr>
			<td class='tbl1'><img src='".THEME."images/bullet.gif' alt='' border='0'> <a href='".BASEDIR."muzika-".seoname($data['download_title'])."-".$data['download_id']."'  title='Daina: ".$data['download_title']." <br>Stilius: ".$cat['download_cat_name']."'>$itemsubject</a></td>

			<td class='tbl1' align='center'>$laikas</td>

			<td class='tbl1' align='center'>".$data['download_count']."</td>

</tr>";
}
echo "</table>";
}
		

	} else {
		echo "<center><br>\n".$locale['430']."<br><br>\n</center>\n";
	}

} else {
	$res = 0;
	if (!isNum($cat_id)) fallback(FUSION_SELF);
	$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'");
	if (dbrows($result) != 0) {
		$cdata = dbarray($result);
		if (checkgroup($cdata['download_cat_access'])) {
			$res = 1;
			
			$rows = dbcount("(*)", "downloads", "download_cat='$cat_id'");
			if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
			if ($rows != 0) {
				$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='$cat_id' ORDER BY ".$cdata['download_cat_sorting']." LIMIT $rowstart,15");
			
				$catdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'"));
				$count = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads WHERE download_cat='$cat_id'"), 0);
				echo "
				<table class='tbl-border' cellpadding='0' cellspacing='1' width='100%'>
<tr>
			</a></td>
			<td class='tbl1' valign='top'><span><a class='small' href='downloads.php'>Siuntiniai</a> » <b>".$catdata['download_cat_name']."</b></span>
			".$catdata['download_cat_description']." - Dain¸ kategorijoje: <span class='small2'>$count</span></td>
</tr>

</table>

<table cellpadding='0' cellspacing='0' width='100%'><tbody><tr>
<td height='8'>
</td>
</tr>
</tbody></table>";
			if (isset($pranesimas) && $_GET['pranesimas'] == "pasalintas") {
echo "<script language='JavaScript'>alert(\"&#208;i daina pa&#240;alinta i&#240; j&#251;s¸ topo\");</script>"; }
if (isset($pranesimas) && $_GET['pranesimas'] == "pridetas") {
echo "<script language='JavaScript'>alert(\"J&#251;s s&#235;kmingai prid&#235;jote &#240;i&#224; dain&#224; &#225; savo top¸ s&#224;ra&#240;&#224;\");</script>"; }
if (isset($pranesimas) && $_GET['pranesimas'] == "pilnas") {
echo "<script language='JavaScript'>alert(\"J&#251;s¸ s&#224;ra&#240;as jau pilnas\");</script>"; }	
				
				
				$numrows = dbrows($result); $i = 1;
				while ($data = dbarray($result)) {
				$id = $data['download_id'];
					if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
						$new = " <span class='small'>".$locale['410']."</span>";
					} else {
						$new = "";
					}
					$time = $data['download_datestamp'];
					$laikas = showdate( "%d.%m.%y", $time);
					echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
					echo "<tr>
<td colspan='5' class='forum-caption'>
					<table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
					

					<td align='center'><a class='small' href='".BASEDIR."muzika-".seoname($data['download_title'])."-".$data['download_id']."'  title=\"".$data['download_title']."\"><b>".$data['download_title']."</b></a> </td>
					</tr></table></td>
</tr>\n";
					echo "<tr>\n";
					echo"<tr><td align='center' style='padding-top: 3px; padding-bttom:3px;'>";
		
		//echo'<embed height="20" border="0" width="350" style="margin-top: 6px; margin-bttom:6px;" wmode="transparent" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="mp3player" quality="high" menu="false" src="http://www.specmusic.net/mediaplayer.swf?backcolor=0xf7af21&frontcolor=71af00&lightcolor=71af00&file='.$data['download_url'].'&type=flv" allowscriptaccess="never"/>';
		
		if(preg_match('/zippyshare/i' , $data['download_url'])){
		echo zip($data['download_url']);
		} else { echo"Nera perklausos nuorodos"; }

		echo"</td></tr>";
					
				
					
						
					echo "<td width='40%' class='tbl2'><b>Komentarai:</b> $komentarai</td><td width='30%' class='tbl1'><b>".$locale['415']."</b> ".$data['download_count']."</td>
					<td class='tbl1' rowspan='1' colspan='1' align='right' valign='bottom' width='1%'>
					<a href='".BASEDIR."muzika-".seoname($data['download_title'])."-".$data['download_id']."' title='&#222;i&#251;r&#235;ti failo komentarus'><img src='images/comments.png' alt='Komentuoti' border='0'></a><br>
					</td>\n</tr>\n<tr>\n\n";
					echo "</tr>\n";
					echo "</table>\n";
					
					if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
				}
			
				if ($rows > 15) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,15,$rows,3,FUSION_SELF."?cat_id=$cat_id&")."\n</div>\n";
			} else {
				echo "<font color='#bababa' class='small'><center>N&#235;ra prid&#235;t¸ dain¸ parsisiuntimui.</center></font>";
			
			}
		}
	}
	if ($res == 0) redirect(FUSION_SELF);
}
if (isset($_GET['veiksmas']) && $_GET['veiksmas'] == "pasalinti") {
$resultas = dbquery("DELETE FROM ".$db_prefix."nario_topas WHERE music_id='$dainos_id' AND user_id='".$userdata['user_id']."'");
redirect(FUSION_SELF."?cat_id=$cat_id&pranesimas=pasalintas");
}
if (isset($_GET['veiksmas']) && $_GET['veiksmas'] == "prideti" && dbcount("(music_id)", "nario_topas", "user_id='".$userdata['user_id']."'") < 31)  {
$result = dbquery("INSERT INTO ".$db_prefix."nario_topas (music_id, user_id, nuo_kada) VALUES ('$dainos_id', '".$userdata['user_id']."', '".time()."')");
		if($result) redirect(FUSION_SELF."?cat_id=$cat_id&pranesimas=pridetas");
}
if (isset($_GET['veiksmas']) && $_GET['veiksmas'] == "prideti" && dbcount("(music_id)", "nario_topas", "user_id='".$userdata['user_id']."'") > 30) {	redirect(FUSION_SELF."?cat_id=$cat_id&pranesimas=pilnas"); }
}




require_once "side_right.php";
require_once "footer.php";
?>