<?php
// defines if this script requires to be logged in
define( "PRIVATE", false );
require_once('./lib/inc-common.php');
require_once(FS_PATH."/etc/locale/".LANG_PACK."/inc-tr-info.php");
ensure_defined_REQUEST('do');
$lyrics = '';
$license = '';
$sql = " SELECT tr.id, tr.name, tr.ar_id, ar.name "
. " , tr.al_id, al.name, tr.ge_id, ge.name "
. " , tr.size, tr.time, tr.track_number "
. " , tr.bit_rate, tr.sample_rate, tr.kind "
. " , tr.location, tr.dl_cnt "
. " , tr.img_src, ar.img_src, al.img_src "
. " , tr.comments, tr.lyrics "
. " , tr.year, tr.date, tr.mtime, tr.license "
. " FROM netjuke_tracks tr, netjuke_artists ar "
. " , netjuke_albums al, netjuke_genres ge "
. " WHERE tr.id = " . abs($_REQUEST['id'])
. " AND tr.ar_id = ar.id"
. " AND tr.al_id = al.id"
. " AND tr.ge_id = ge.id";
$dbrs = $dbconn->Execute($sql);
if ($dbrs->RecordCount() != 1) {
javascript("alert('".TRINFO_NOID."'); self.close();");
}
$time = myTimeFormat($dbrs->fields[9]);
$file_size = myFilesizeFormat($dbrs->fields[8]);
$file_name = split("/",$dbrs->fields[14]);
$tr_img = check_image($dbrs->fields[16]);
$ar_img = check_image($dbrs->fields[17]);
$al_img = check_image($dbrs->fields[18]);
if (strlen($dbrs->fields[19]) > 0) {
$comments = true;
} else {
$comments = false;
$comments_lnk = '';
}
if (strlen($dbrs->fields[20]) > 0) {
$lyrics = true;
} else {
$lyrics = false;
$lyrics_lnk = '';
}
if (strlen($dbrs->fields[24]) > 0) {
$license = true;
} else {
$license = false;
$license_lnk = '';
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo LANG_CHARSET ?>">
<TITLE><?php echo TRINFO_HEADER ?>: <?php echo format_for_display($dbrs->fields[1])?></TITLE>
<style type="text/css">
<?php require_once(FS_PATH."/lib/inc-css.php"); ?>
</style>
</HEAD>
<BODY BGCOLOR='#<?php echo $NETJUKE_SESSION_VARS["bgcolor"]?>' TEXT='#<?php echo $NETJUKE_SESSION_VARS["text"]?>' LINK='#<?php echo $NETJUKE_SESSION_VARS["link"]?>' ALINK='#<?php echo $NETJUKE_SESSION_VARS["alink"]?>' VLINK='#<?php echo $NETJUKE_SESSION_VARS["vlink"]?>' ONLOAD='self.focus();'>
<a name="PageTop"></a>
<div align=center>
<table width='100%' border=0 cellspacing=1 cellpadding=3 class='border'>
<tr>
<td align=left class="header" colspan=2><b><?php echo TRINFO_HEADER ?></b></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content"><?php echo TRINFO_FORM_TR ?></td>
<td width="70%" align=left valign=top class="content"><?php echo format_for_display($dbrs->fields[1])?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content"><?php echo TRINFO_FORM_AR ?></td>
<td width="70%" align=left valign=top class="content"><?php echo format_for_display($dbrs->fields[3])?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_AL ?></td>
<td width="70%" align=left valign=top class="content"><?php echo format_for_display($dbrs->fields[5])?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_GE ?></td>
<td width="70%" align=left valign=top class="content"><?php echo format_for_display($dbrs->fields[7])?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_YE ?></td>
<td width="70%" align=left valign=top class="content"><?php echo format_for_display($dbrs->fields[21])?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_TI ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $time?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_TN ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[10]?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_BR ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[11]?> kbps</td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_SR ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[12]?> kHz</td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_FK ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[13]?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_FS ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $file_size?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_DA ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[22]?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_LM ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[23]?></td>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_FN ?></td>
<?php if ($NETJUKE_SESSION_VARS["gr_id"] == 1) { ?>
<td width="70%" align=left valign=top class="content"><?php echo MUSIC_DIR . '/' . format_for_display(rawurldecode($dbrs->fields[14])) ?></td>
<?php } else { ?>
<td width="70%" align=left valign=top class="content"><?php echo format_for_display(rawurldecode($file_name[count($file_name) - 1]))?></td>
<?php } ?>
</tr>
<tr>
<td width="30%" align=right valign=top class="content" nowrap><?php echo TRINFO_FORM_LC ?></td>
<td width="70%" align=left valign=top class="content"><?php echo $dbrs->fields[15]?></td>
</tr>
</table>
<?php
if (ENABLE_XML == 't') {
$button = buildButton (WEB_PATH."/xml.php?do=show.tracks&id=".$dbrs->fields[0], COMMON_XML_HELP, 'xml');
echo "<br><center>".$button."</center>";
}
?>
<?php if ( ($comments == true) || ($lyrics == true) || ($license == true) ) { ?>
<br>
<table width='100%' border=0 cellspacing=1 cellpadding=3 class="border">
<tr>
<?php if ($comments == true) { ?>
<td width="" align="center" class="content">
<a href="<?php echo WEB_PATH.'/text-view.php?type=comments&id='.$dbrs->fields[0]; ?>" target="NetJukeComments" onClick="window.open('','NetJukeComments','width=400,height=575,top=0,left=520,menubar=no,scrollbars=yes,resizable=yes');" title="<?php echo TRINFO_FORM_CM; ?>"><b><?php echo TRINFO_FORM_CM ?></b></a><br>
</td>
<?php } ?>
<?php if ($lyrics == true) { ?>
<td width="" align="center" class="content">
<a href="<?php echo WEB_PATH.'/text-view.php?type=lyrics&id='.$dbrs->fields[0]; ?>" target="NetJukeLyrics" onClick="window.open('','NetJukeLyrics','width=400,height=575,top=25,left=545,menubar=no,scrollbars=yes,resizable=yes');" title="<?php echo TRINFO_FORM_LY; ?>"><b><?php echo TRINFO_FORM_LY ?></b></a><br>
</td>
<?php } ?>
<?php if ($license == true) { ?>
<td width="" align="center" class="content">
<a href="<?php echo WEB_PATH.'/text-view.php?type=license&id='.$dbrs->fields[0]; ?>" target="NetJukeLicense" onClick="window.open('','NetJukeLicense','width=400,height=575,top=25,left=545,menubar=no,scrollbars=yes,resizable=yes');" title="<?php echo TRINFO_FORM_LI; ?>"><b><?php echo TRINFO_FORM_LI ?></b></a><br>
</td>
<?php } ?>
</tr>
</table>
<?php } ?>
<?php if ( (strlen($tr_img) > 0) || (strlen($ar_img) > 0) || (strlen($al_img) > 0) ) { ?>
<br>
<table width='100%' border=0 cellspacing=1 cellpadding=3 class="border">
<tr>
<?php if (strlen($tr_img) > 0) { ?>
<td width="" align="center" class="content">
<a href="<?php echo $tr_img ?>" target="NetJukeImage" onClick="window.open('','NetJukeImage','width=550,height=550,top=50,left=50,menubar=no,scrollbars=yes,resizable=yes');" title="<?php echo format_for_display($dbrs->fields[1]) ?>"><img src="<?php echo $tr_img ?>" alt="<?php echo format_for_display($dbrs->fields[1]) ?>" width="100" height="100" hspace="5" vspace="2" border="1"></a><br><?php echo TRINFO_IMG_TR ?>
</td>
<?php } ?>
<?php if (strlen($ar_img) > 0) { ?>
<td width="" align="center" class="content">
<a href="<?php echo $ar_img ?>" target="NetJukeImage" onClick="window.open('','NetJukeImage','width=550,height=550,top=50,left=50,menubar=no,scrollbars=yes,resizable=yes');" title="<?php echo format_for_display($dbrs->fields[3]) ?>"><img src="<?php echo $ar_img ?>" alt="<?php echo format_for_display($dbrs->fields[3]) ?>" width="100" height="100" hspace="5" vspace="2" border="1"></a><br><?php echo TRINFO_IMG_AR ?>
</td>
<?php } ?>
<?php if (strlen($al_img) > 0) { ?>
<td width="" align="center" class="content">
<a href="<?php echo $al_img ?>" target="NetJukeImage" onClick="window.open('','NetJukeImage','width=550,height=550,top=50,left=50,menubar=no,scrollbars=yes,resizable=yes');" title="<?php echo format_for_display($dbrs->fields[5]) ?>"><img src="<?php echo $al_img ?>" alt="<?php echo format_for_display($dbrs->fields[5]) ?>" width="100" height="100" hspace="5" vspace="2" border="1"></a><br><?php echo TRINFO_IMG_AL ?>
</td>
<?php } ?>
</tr>
</table>
<?php } ?>
<br>
<table width='100%' border=0 cellspacing=1 cellpadding=3 class="border">
<tr>
<td width="" align="center" class="content"><a href="<?php echo WEB_PATH.'/play.php?do=play&val='.$_REQUEST['id']?>" title="<?php echo TRINFO_PLAY_HELP ?>"><b><?php echo TRINFO_PLAY ?></b></a></td>
<?php if (($NETJUKE_SESSION_VARS["gr_id"] < 3) && ($_REQUEST['do'] != 'edit')) { ?>
<td width="" align="center" class="content"><a href="<?php echo WEB_PATH?>/admin/tr-edit.php?do=edit&tr_id=<?php echo $_REQUEST['id']?>" title="<?php echo TRINFO_EDIT_HELP ?>"><b><?php echo TRINFO_EDIT ?></b></a></td>
<?php } ?>
<td width="" align="center" class="content"><a href="javascript:window.close();" title="<?php echo TRINFO_CLOSEWIN_HELP ?>"><b><?php echo TRINFO_CLOSEWIN ?></b></a></td>
</tr>
</table>
<div>
</BODY>
</HTML>