musiclist.php

1、上传所有文件至服务器目录。 2、使用 MYSQL 管理工具

<?PHP
error_reporting(7);

if ($HTTP_GET_VARS['HTTP_POST_VARS']['action'] == $HTTP_POST_VARS['action']) {
  unset($HTTP_POST_VARS['action']);
}
$HTTP_POST_VARS['action'] = trim($HTTP_POST_VARS['action']);

if ($HTTP_POST_VARS['action']) {
	$action = $HTTP_POST_VARS['action'];
} else if ($HTTP_GET_VARS['action']) {
	$action = $HTTP_GET_VARS['action'];
}

if ($HTTP_GET_VARS['HTTP_POST_VARS']['albumid'] == $HTTP_POST_VARS['albumid']) {
  unset($HTTP_POST_VARS['albumid']);
}
$HTTP_POST_VARS['albumid'] = intval(trim($HTTP_POST_VARS['albumid']));

unset($albumid);
if ($HTTP_POST_VARS['albumid']) {
	$albumid = intval($HTTP_POST_VARS['albumid']);
} else if ($HTTP_GET_VARS['albumid']) {
	$albumid = intval($HTTP_GET_VARS['albumid']);
}

$realalbumid = $albumid;
if ((!isset($action) or $action=="")) {
  $action="show";
}

$templatesused = '';

// ############################### 专辑歌曲列表 ###############################
if ($action=="show") {
  if ($albumid!="") {
    $templatesused = 'musiclist_album,musiclist_album_lists,musiclist_album_lists_header,musiclist_album_lists_footer';
    $templatesused .= ',musiclist_album_lists_listen,standardalert,musiclist_album_nolist';
    include("./global.php");
    $albumid = $realalbumid;
    $albums = $DB_site->query("SELECT * 
                               FROM ".$table["special"]."
                               WHERE SpecialID=".$albumid);

    if (($DB_site->num_rows($albums))==0) {
      $message = "选择的专辑不存在, 可能已被管理人员删除, 请重新选择其它专辑!";
      eval("dooutput(\"".gettemplate("standardalert")."\");");
      exit;
    } else {
      $DB_site->query("UPDATE ".$table["special"]." 
                       SET Hits=Hits+1 
                       WHERE SpecialID=".$albumid);

      $album = $DB_site->fetch_array($albums);
      $DB_site->free_result($albums);
      $sclassid = $album['SClassID'];
      $sclassname = $album['SClassName'];
      $nclassid = $album['NClassID'];
      $nclassname = $album['NClassName'];
      $name = $album['Name'];
      $header = "<title>".$webtitle."--".$nclassname."--".$name."</title>".$header;
      $language = $album['Language'];
      $company = $album['Company'];
      $photourl = $album['PhotoPath'];
      $intro = $album['Intro'];
      $times = $album['PublishTime'];
      $musics = $DB_site->query("SELECT * 
                                 FROM ".$table["musiclist"]."
                                 WHERE SpecialID=".$albumid);

      if ($music=$DB_site->fetch_array($musics)) {
        $num = 1;
        $firstcolor = $recmdMusicFirstColorOne;
        $secondcolor = $recmdMusicFirstColorTwo;
        $musicid = $music['ID'];
        $musicname = $music['MusicName'];
        $hits = $music['Hits'];
        if ($music['FileName']!="") {
          eval("\$listenlink = \"".gettemplate('musiclist_album_lists_listen')."\";");
        } else {
          $listenlink = "暂无";
        }
        eval("\$albummusics = \"".gettemplate('musiclist_album_lists_header')."\";");
        eval("\$albummusics .= \"".gettemplate('musiclist_album_lists')."\";");

        while ($music=$DB_site->fetch_array($musics)) {
          $num++;
          if (($num%2)==0) {
            $firstcolor = $recmdMusicSecondColorOne;
            $secondcolor = $recmdMusicSecondColorTwo;
          } else {
            $firstcolor = $recmdMusicFirstColorOne;
            $secondcolor = $recmdMusicFirstColorTwo;
          }
          $musicid = $music['ID'];
          $musicname = $music['MusicName'];
          $hits = $music['Hits'];
          if ($music['FileName']!="") {
            eval("\$listenlink = \"".gettemplate('musiclist_album_lists_listen')."\";");
          } else {
            $listenlink = "暂无";
          }
          eval("\$albummusics .= \"".gettemplate('musiclist_album_lists')."\";");
        }
        eval("\$albummusics .= \"".gettemplate('musiclist_album_lists_footer')."\";");
      } else {
        eval("\$albummusics = \"".gettemplate('musiclist_album_nolist')."\";");
      }
      $DB_site->free_result($musics);
      eval("dooutput(\"".gettemplate("musiclist_album")."\");");
    }
  } else {
    $templatesused = 'standardalert';
    include("./global.php");
    $message = "错误的操作, 没有选择专辑, 请重新选择专辑!";
    eval("dooutput(\"".gettemplate("standardalert")."\");");
    exit;
  }

}

// ############################### 全部歌曲列表 ###############################
if ($action=="list") {
  if ($HTTP_GET_VARS['HTTP_POST_VARS']['page'] == $HTTP_POST_VARS['page']) {
    unset($HTTP_POST_VARS['page']);
  }
  $HTTP_POST_VARS['page'] = trim($HTTP_POST_VARS['page']);

  unset($curpage);
  if ($HTTP_POST_VARS['page']) {
    $curpage = intval($HTTP_POST_VARS['page']);
  } else if ($HTTP_GET_VARS['page']) {
    $curpage = intval($HTTP_GET_VARS['page']);
  }

  if ((!isset($curpage) or $curpage=="")) {
    $curpage = 1;
  }

  $templatesused = 'musiclist_page,musiclist_page_firstpage,musiclist_page_prevlink,musiclist_page_nextlink';
  $templatesused .= ',musiclist_page_lastpage,standardalert,musiclist_lists_header,musiclist_lists_footer';
  include("./global.php");

  $musicscount = $DB_site->query_first("SELECT COUNT(*) AS musics FROM ".$table["musiclist"]);

  $limitlower = ($curpage-1)*$numOfListMusicPage+1;
  $musics = $DB_site->query("SELECT * 
                             FROM ".$table["musiclist"]."
                             LIMIT ".($limitlower-1).",".$numOfListMusicPage);

  if ($music=$DB_site->fetch_array($musics)) {
    $num = 1;
    $musicid = $music['ID'];
    $musicname = $music['MusicName'];
    $hits = $music['Hits'];
    if ($music['FileName']!="") {
      eval("\$listenlink = \"".gettemplate('musiclist_lists_listen')."\";");
    } else {
      $listenlink = "暂无";
    }
    eval("\$listmusics = \"".gettemplate('musiclist_lists_header')."\";");
    eval("\$listmusics .= \"".gettemplate('musiclist_lists')."\";");

    while ($music=$DB_site->fetch_array($musics)) {
      $num++;
      $musicid = $music['ID'];
      $musicname = $music['MusicName'];
      $hits = $music['Hits'];
      if ($music['FileName']!="") {
        eval("\$listenlink = \"".gettemplate('musiclist_lists_listen')."\";");
      } else {
        $listenlink = "暂无";
      }
      eval("\$listmusics .= \"".gettemplate('musiclist_lists')."\";");
    }
    eval("\$listmusics .= \"".gettemplate('musiclist_lists_footer')."\";");
  } else {
    eval("\$listmusics .= \"".gettemplate('musiclist_nolist')."\";");
  }
  $DB_site->free_result($musics);

  $pages = getMusicListPage($musicscount['musics']);
  eval("dooutput(\"".gettemplate("musiclist")."\");");

}

// ############################### 推荐歌曲列表 ###############################
if ($action=="recmd") {

  $templatesused = 'musiclist_recmd,musiclist_album_lists,musiclist_album_lists_header,musiclist_album_lists_footer';
  $templatesused .= ',musiclist_album_lists_listen,standardalert,musiclist_album_nolist';
  include("./global.php");

  $musics = $DB_site->query("SELECT * 
                             FROM ".$table["musiclist"]."
                             WHERE IsGood=1 
                             ORDER BY ID DESC 
                             LIMIT 25");

  if ($music=$DB_site->fetch_array($musics)) {
    $num = 1;
    $firstcolor = $recmdMusicFirstColorOne;
    $secondcolor = $recmdMusicFirstColorTwo;
    $musicid = $music['ID'];
    $musicname = $music['MusicName'];
    $hits = $music['Hits'];
    if ($music['FileName']!="") {
      eval("\$listenlink = \"".gettemplate('musiclist_album_lists_listen')."\";");
    } else {
      $listenlink = "暂无";
    }
    eval("\$recmdmusics = \"".gettemplate('musiclist_album_lists_header')."\";");
    eval("\$recmdmusics .= \"".gettemplate('musiclist_album_lists')."\";");

    while ($music=$DB_site->fetch_array($musics)) {
      $num++;
      if (($num%2)==0) {
        $firstcolor = $recmdMusicSecondColorOne;
        $secondcolor = $recmdMusicSecondColorTwo;
      } else {
        $firstcolor = $recmdMusicFirstColorOne;
        $secondcolor = $recmdMusicFirstColorTwo;
      }
      $musicid = $music['ID'];
      $musicname = $music['MusicName'];
      $hits = $music['Hits'];
      if ($music['FileName']!="") {
        eval("\$listenlink = \"".gettemplate('musiclist_album_lists_listen')."\";");
      } else {
        $listenlink = "暂无";
      }
      eval("\$recmdmusics .= \"".gettemplate('musiclist_album_lists')."\";");
    }
    eval("\$recmdmusics .= \"".gettemplate('musiclist_album_lists_footer')."\";");
  } else {
    eval("\$recmdmusics = \"".gettemplate('musiclist_album_nolist')."\";");
  }
  $DB_site->free_result($musics);
  eval("dooutput(\"".gettemplate("musiclist_recmd")."\");");

}
?>