<?php
include("head.php");
session_start();
$xid=$_SESSION['userid'];
$id=$_GET['id'];
    $sql = "select * from reviews where id='$id'";
    $query=mysql_query($sql);
if (mysql_num_rows($query)){
    while($row = mysql_fetch_array($query))
  {
      $usid=$row['uid'];
      $lx=$row['lx'];
      $lx5=$row['lx'];
      $uid=$row['uid'];
      $album1=$row['album'];
      $album=str_replace("\*", "'",$row['album']);
      $pic=$row['pic'];
      $wiki=str_replace("\*", "'",$row['wiki']);
      $wiki=str_replace("\n","<br>",htmlspecialchars($wiki));
      $bt=str_replace("\*", "'",$row['bt']);
      $label=str_replace("\*", "'",$row['label']);
      $artist1=$row['artist'];
      $artist=str_replace("\*", "'",$row['artist']);
      $genre=str_replace("\*", "'",$row['genre']);
      $wzid=$row['id'];
switch ($lx)
{
case 0:
  $lx='专辑';
  break;  
case 1:
  $lx='单曲';
  break;
case 2:
  $lx='文章';
  break;
}
switch ($genre)
{
case 0:
  $genre='Electronical';
  break;  
case 1:
  $genre='Experiment';
  break;
case 2:
  $genre='Folk/Country';
  break;
case 3:
  $genre='Global';
  break;
case 4:
  $genre='Jazz';
  break;
case 5:
  $genre='Metal';
  break;
case 6:
  $genre='Pop/R&B';
  break;
case 7:
  $genre='Rap/Hip-Hop';
  break;
case 8:
  $genre='Rock';
  break;
}
      $sql5 = "select * from t_user WHERE id ='$usid'";
    $query5=mysql_query($sql5);
if (mysql_num_rows($query5)){
    while($row5 = mysql_fetch_array($query5))
  {
      $usm=$row5['username'];
      $av1=$row5['av']."?imageView2/2/w/300/h/300";;
  }
}
if (empty($bt)){
    $bt=htmlspecialchars($artist).' · '.htmlspecialchars($album);
}
if ($av1=='?imageView2/2/w/300/h/300'){
    $av1='http://p1.music.126.net/-GO4Yc6uCOI6W7LmanCAfQ==/1402976840630445.jpg?param=100y100/';
}
  $sql = "SELECT * FROM  `hotreviews` 
WHERE  `bid` LIKE  '".$id."'";
  $result=mysql_query($sql); 
  $count1 = mysql_num_rows($result);
  	if ($xid<>$uid){
date_default_timezone_set('PRC');
$time=date("Y-m-d H:i:s");
if (empty($xid)){
    $xid='0';
}
	$sql="INSERT INTO hotreviews (bid,date1,uid) VALUES ('$id','$time','$xid')";
    $query=mysql_query($sql);
}else{
    $scnr='<li><a href="http://musictrack.cn/user/bj.php?ff=15&id='.$wzid.'" id="zf"/>删除</li>';
}
      $ltnr=$ltnr.'
							<article class="post">
								<header>
									<div class="title">
										<h2>'.$bt.'</h2>
										<p><b>'.$row['fs'].'</b> | '.$lx.' |'.$album.' · '.$artist.' · '.$genre.'</p>
									</div>
									<div class="meta">
										<time class="published" datetime="2015-11-01">'.substr($row['date'],0,10).'</time>
										<a href="#" class="author"><span class="name">'.$usm.'</span><img src="'.$av1.'" alt="" /></a>
									</div>
								</header>
								<p>
								'.$wiki.'
								
</p>
								<footer>
									<ul class="stats">
										<li>阅读量： '.$count1.'</li>
										'.$scnr.'
									</ul>

								</footer>
							</article>
                      
                  ';
  }
}
switch ($lx5)
{
case 2:
    $sql = "select * from reviews ORDER BY RAND() limit 5";
    $query=mysql_query($sql);
if (mysql_num_rows($query)){
    while($row = mysql_fetch_array($query))
  {
      $usid=$row['uid'];
      $bt5=str_replace("\*", "'",$row['bt']);
      $album=str_replace("\*", "'",$row['album']);
      $artist=str_replace("\*", "'",$row['artist']);
      $sql5 = "select * from t_user WHERE id ='$usid'";
    $query5=mysql_query($sql5);
if (mysql_num_rows($query5)){
    while($row5 = mysql_fetch_array($query5))
  {
      $usm5=$row5['username'];
      $av1=$row5['av']."?imageView2/2/w/300/h/300";;
  }
}
if (empty($bt5)){
    $bt5=$artist.' · '.$album;
}
if ($av1=='?imageView2/2/w/300/h/300'){
    $av1='http://p1.music.126.net/-GO4Yc6uCOI6W7LmanCAfQ==/1402976840630445.jpg?param=300y300/';
}
      $tjnr=$tjnr.'
									<li>
										<article>
											<header>
												<a href="r.php?id='.$row['id'].'">
												<h3>'.$bt5.'</h3>
												'.$usm5.' · '.$row['fs'].'</a>
											</header>
												<a href="r.php?id='.$row['id'].'" class="image"><img src="'.$av1.'" alt="" /></a>
										</article>
									</li>
                      
                  ';
  }
}
    $xxx="<h2>文章</h2>";
    break;
default:
    $sql = "select avg(fs) as fs_avg from reviews where artist='$artist1' and album='$album1' and lx='$lx5' limit 1";
    $query=mysql_query($sql);
if (mysql_num_rows($query)){
    while($row = mysql_fetch_array($query))
  {
      $pjf=round($row['fs_avg']);
  }
}
switch ($score)
{
case $score<=40:
$c1="color='#FF0000'";
break;
case $score<=60:
$c1="color='#FFCC33'";
break;
case $score>=80:
$c1="color='#33CC66'";
break;
}
$pj="<font $c1>$pjf</font>";
    $sql = "select * from reviews where artist='$artist1' and album='$album1' ORDER BY RAND()  limit 5";
    $query=mysql_query($sql);
if (mysql_num_rows($query)){
    while($row = mysql_fetch_array($query))
  {
      $usid=$row['uid'];
      $bt5=str_replace("\*", "'",$row['bt']);
      $album=str_replace("\*", "'",$row['album']);
      $artist=str_replace("\*", "'",$row['artist']);
      $sql5 = "select * from t_user WHERE id ='$usid'";
    $query5=mysql_query($sql5);
if (mysql_num_rows($query5)){
    while($row5 = mysql_fetch_array($query5))
  {
      $usm5=$row5['username'];
  }
}
if (empty($bt5)){
    $bt5=$artist.' · '.$album;
}
if ($av1=='?imageView2/2/w/300/h/300'){
    $av1='http://p1.music.126.net/-GO4Yc6uCOI6W7LmanCAfQ==/1402976840630445.jpg?param=300y300/';
}
      $tjnr=$tjnr.'
									<li>
										<article>
											<header>
												<a href="r.php?id='.$row['id'].'">
												<h3>'.$bt5.'</h3>
												'.$usm5.' · '.$row['fs'].'</a>
											</header>
												<a href="r.php?id='.$row['id'].'" class="image"><img src="'.$av1.'" alt="" /></a>
										</article>
									</li>
                      
                  ';
  }
}
    $xxx="<h3>MT评分：$pj</h3>
									<h3>$album</h3>
									<h4>$artist</h4>";
}
echo "<title>$bt - Music Track</title>";
?>
					<div id="main">

						<!-- Post -->
<?php  echo $ltnr; ?>

					</div>

<section id="sidebar">

						<!-- Intro -->
							<section id="intro">
								<header>
								    <center><?php echo '<img src="'.$pic.'?param=150y150" alt="" />' ?>
								    <br>
                                        <?php echo $xxx ?>
									</center>
								</header>
							</section>
							<section>
							   <center><h3>相关乐评</h3></center>
							   <br>
								<ul class="posts">
                                    <?php echo $tjnr ?>
								</ul>
							</section>
					</section>

		<!-- Scripts -->
		
			<script src="assets/js/jquery.min.js"></script>
			<script src="assets/js/browser.min.js"></script>
			<script src="assets/js/breakpoints.min.js"></script>
			<script src="assets/js/util.js"></script>
			<script src="assets/js/main.js"></script>
			<script type='text/javascript' src='http://musictrack.cn/user/assets/js/jquery-2.1.1.min.js'></script>
    <script type="text/javascript" src="http://musictrack.cn/user/assets/js/iziModal.min.js"></script>
    <script type="text/javascript">
    $(function(){
    	$(document).on("click", "#zf", function (event) {
    		event.preventDefault();
    		$("#zf-modal").iziModal("open", event);
    	});
    	
    	$("#zf-modal").iziModal({
    		iframe: true,
    		iframeHeight: 400,
    	});
    });
    </script>
	</body>
</html>