<?php
include("head.php");
    $sql = "select * from reviews order by date desc limit 50";
    $query=mysql_query($sql);
if (mysql_num_rows($query)){
    while($row = mysql_fetch_array($query))
  {
      $usid=$row['uid'];
      $lx=$row['lx'];
      $album=str_replace("\*", "'",$row['album']);
      $wiki=cut_str(str_replace("\*", "'",$row['wiki']),400);
      $wiki=str_replace("\n","<br>",htmlspecialchars($wiki));
      $bt=str_replace("\*", "'",$row['bt']);
      $genre=str_replace("\*", "'",$row['genre']);
      $artist=str_replace("\*", "'",$row['artist']);
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=$artist.' · '.$album;
}
if (!empty($row['pic'])){
    $tp='<span class="image left"><img src="'.$row['pic'].'?param=180y180" alt="" /></span>';
}else{
    $tp='';
}
if ($av1=='?imageView2/2/w/300/h/300'){
    $av1='http://p1.music.126.net/-GO4Yc6uCOI6W7LmanCAfQ==/1402976840630445.jpg?param=100y100/';
}
      $ltnr=$ltnr.'
							<article class="post">
								<header>
									<div class="title">
										<h2><a href="r.php?id='.$row['id'].'">'.$bt.'</a></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><a href="r.php?id='.$row['id'].'" class="image featured"></a>'.$tp.'
								'.$wiki.'
								
</p>
								<footer>
									<ul class="actions">
										
									</ul>
									<ul class="stats">
										<li><a href="r.php?id='.$row['id'].'" class="button large">完整阅读</a></li>
									</ul>
								</footer>
							</article>
                      
                  ';
  }
}
    $sql = "select * from reviews ORDER BY RAND() limit 10";
    $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>
                      
                  ';
  }
}
function cut_str($string, $sublen, $start = 0, $charset = 'UTF-8')
{
if($charset == 'UTF-8')
{
$pa = "/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|\xe0[\xa0-\xbf][\x80-\xbf]|[\xe1-\xef][\x80-\xbf][\x80-\xbf]|\xf0[\x90-\xbf][\x80-\xbf][\x80-\xbf]|[\xf1-\xf7][\x80-\xbf][\x80-\xbf][\x80-\xbf]/";
preg_match_all($pa, $string, $t_string);
if(count($t_string[0]) - $start > $sublen) return join('', array_slice($t_string[0], $start, $sublen))."...";
return join('', array_slice($t_string[0], $start, $sublen));
}
else
{
$start = $start*2;
$sublen = $sublen*2;
$strlen = strlen($string);
$tmpstr = '';
for($i=0; $i< $strlen; $i++)
{
if($i>=$start && $i< ($start+$sublen))
{
if(ord(substr($string, $i, 1))>129)
{
$tmpstr.= substr($string, $i, 2);
}
else
{
$tmpstr.= substr($string, $i, 1);
}
}
if(ord(substr($string, $i, 1))>129) $i++;
}
if(strlen($tmpstr)< $strlen ) $tmpstr.= "...";
return $tmpstr;
}
}
?>
<title>乐评 - Music Track</title>

				<!-- Main -->
					<div id="main">

<?php echo $ltnr; ?>

						<!-- Pagination 
							<ul class="actions pagination">
								<li><a href="" class="disabled button large previous">Previous Page</a></li>
								<li><a href="#" class="button large next">Next Page</a></li>
							</ul>
-->
					</div>

				<!-- Sidebar -->
					<section id="sidebar">

						<!-- Intro -->
							<section id="intro">
								<header>
									<h2>Music VIEWS</h2>
								</header>
							</section>
							
						<!-- Posts List -->
							<section>
								<ul class="posts">
<?php echo $tjnr; ?>
								</ul>
							</section>


					</section>

			</div>

		<!-- 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>

	</body>
</html>