albumlist.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']['artid'] == $HTTP_POST_VARS['artid']) {
  unset($HTTP_POST_VARS['artid']);
}
$HTTP_POST_VARS['artid'] = intval(trim($HTTP_POST_VARS['artid']));

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

if ((!isset($action) or $action=="")) {
  $action="list";
}

$templatesused = '';

// ############################### 最新专辑列表 ###############################
if ($action=="new") {
  $templatesused = 'albumlist_new,albumlist_new_lists';
  include("./global.php");
  $albums = $DB_site->query("SELECT * 
                             FROM ".$table["special"]."
                             ORDER BY Specialid DESC
                             LIMIT ".intval($maxNumNewAlbumList));

  $albumnum = $DB_site->num_rows($albums);
  if ($album=$DB_site->fetch_array($albums)) {
    $num = 1;
    $backcolor = $recmdMusicSecondColorTwo;
    $id = $album['SpecialID'];
    $artid = $album['NClassID'];
    $art = $album['NClassName'];
    $hits = $album['Hits'];
    $times = $album['PublishTime'];
    $name = $album['Name'];
    $photourl = $album['PhotoPath'];
    $language = $album['Language'];
    eval("\$newalbums = \"".gettemplate('albumlist_new_lists')."\";");

    while ($album=$DB_site->fetch_array($albums)) {
      $num++;
      if (($num%2)==0) {
        $backcolor = $recmdMusicSecondColorOne;
      } else {
        $backcolor = $recmdMusicSecondColorTwo;
      }
      $id = $album['SpecialID'];
      $artid = $album['NClassID'];
      $art = $album['NClassName'];
      $hits = $album['Hits'];
      $times = $album['PublishTime'];
      $name = $album['Name'];
      $photourl = $album['PhotoPath'];
      $language = $album['Language'];
      eval("\$newalbums .= \"".gettemplate('albumlist_new_lists')."\";");
    }
  } else {
    eval("\$newalbums = \"".gettemplate('albumlist_new_nolist')."\";");
  }
  $DB_site->free_result($albums);
  eval("dooutput(\"".gettemplate("albumlist_new")."\");");

}

// ############################### 推荐列表 ###############################
if ($action=="recmd") {
  $templatesused = 'albumlist_recmd,albumlist_recmd_lists';
  include("./global.php");
  $albums = $DB_site->query("SELECT * 
                             FROM ".$table["special"]."
                             WHERE IsGood=1
                             ORDER BY Specialid DESC
                             LIMIT ".intval($maxNumRecmdAlbumList));

  $albumnum = $DB_site->num_rows($albums);
  if ($album=$DB_site->fetch_array($albums)) {
    $id = $album['SpecialID'];
    $artid = $album['NClassID'];
    $art = $album['NClassName'];
    $hits = $album['Hits'];
    $times = $album['PublishTime'];
    $name = $album['Name'];
    $photourl = $album['PhotoPath'];
    $language = $album['Language'];
    eval("\$recmdalbums = \"".gettemplate('albumlist_recmd_lists')."\";");

    while ($album=$DB_site->fetch_array($albums)) {
      $id = $album['SpecialID'];
      $artid = $album['NClassID'];
      $art = $album['NClassName'];
      $hits = $album['Hits'];
      $times = $album['PublishTime'];
      $name = $album['Name'];
      $photourl = $album['PhotoPath'];
      $language = $album['Language'];
      eval("\$recmdalbums .= \"".gettemplate('albumlist_recmd_lists')."\";");
    }
  } else {
    eval("\$recmdalbums = \"".gettemplate('albumlist_recmd_nolist')."\";");
  }
  $DB_site->free_result($albums);
  eval("dooutput(\"".gettemplate("albumlist_recmd")."\");");

}

// ############################### 专辑列表 ###############################
if ($action=="list") {
  $templatesused = 'albumlist_art,albumlist_art_lists,albumlist,albumlist_lists';
  include("./global.php");
  unset($query);
  if ($artid=="") {
    $query = "";
  } else {
    $query = "WHERE NClassID=".$artid;
  }
  $albums = $DB_site->query("SELECT * 
                             FROM ".$table["special"]."
                             ".$query."
                             ORDER BY Specialid DESC
                             LIMIT ".intval($maxNumAlbumList));

  unset($templatename);
  if ($artid=="") {
    $templatename = "albumlist";
  } else {
    $templatename = "albumlist_art";
  }
  $albumnum = $DB_site->num_rows($albums);
  if ($album=$DB_site->fetch_array($albums)) {
    $id = $album['SpecialID'];
    $artid = $album['NClassID'];
    $art = $album['NClassName'];
    $hits = $album['Hits'];
    $times = $album['PublishTime'];
    $name = $album['Name'];
    $photourl = $album['PhotoPath'];
    $sclassname = $album['SClassName'];
    $sclassid = $album['SClassID'];
    $language = $album['Language'];
    eval("\$listalbums = \"".gettemplate($templatename."_lists")."\";");

    while ($album=$DB_site->fetch_array($albums)) {
      $id = $album['SpecialID'];
      $artid = $album['NClassID'];
      $art = $album['NClassName'];
      $hits = $album['Hits'];
      $times = $album['PublishTime'];
      $name = $album['Name'];
      $photourl = $album['PhotoPath'];
      $sclassname = $album['SClassName'];
      $sclassid = $album['SClassID'];
      $language = $album['Language'];
      eval("\$listalbums .= \"".gettemplate($templatename."_lists")."\";");
    }
  } else {
    eval("\$listalbums = \"".gettemplate($templatename."_nolist")."\";");
  }
  $DB_site->free_result($albums);
  eval("dooutput(\"".gettemplate($templatename)."\");");

}
?>