<?
error_reporting(7);

$templatesused='home,home_link';
$templatesused.=',home_newalbum,home_newalbum_lists,home_newalbum_changeline';
$templatesused.=',home_newalbum_right,home_newalbum_right_lists';
$templatesused.=',home_recmdalbum,home_recmdalbum_lists';
$templatesused.=',home_recmdmusic,home_recmdmusic_lists';

require('./global.php');

//######################## 最新專輯 中 #####################################
$albums = $DB_site->query("SELECT SpecialID,Name,PhotoPath,NClassName,NClassID,PublishTime,Language 
                           FROM ".$table["special"]."
                           ORDER BY Specialid DESC
                           LIMIT ".intval($maxNumNewAlbum));

if ($album=$DB_site->fetch_array($albums)) {
  $num = 1;
  $id = $album['SpecialID'];
  $name = $album['Name'];
  $photourl = $album['PhotoPath'];
  $singer = stripenglishname($album['NClassName']);
  $singerid = $album['NClassID'];
  $language = $album['Language'];
  $times = $album['PublishTime'];
  eval("\$newalbums = \"".gettemplate('home_newalbum_lists')."\";");

  while ($album=$DB_site->fetch_array($albums)) {
    $num++;
    $id = $album['SpecialID'];
    $name = $album['Name'];
    $photourl = $album['PhotoPath'];
    $singer = stripenglishname($album['NClassName']);
    $singerid = $album['NClassID'];
    $language = $album['Language'];
    $times = $album['PublishTime'];
    eval("\$newalbums .= \"".gettemplate('home_newalbum_lists')."\";");
    if (($num%2)==0) {
      eval("\$newalbums .= \"".gettemplate("home_newalbum_changeline")."\";");
    }
  }
}
$DB_site->free_result($albums);
eval("\$newalbum = \"".gettemplate('home_newalbum')."\";");

//######################## 最新專輯 右 #####################################
$albums = $DB_site->query("SELECT SpecialID,Name,PhotoPath,NClassName,NClassID,PublishTime,Language 
                           FROM ".$table["special"]."
                           ORDER BY Specialid DESC
                           LIMIT ".intval($maxNumNewAlbum).",".intval($maxNumNewAlbum2));

unset($newalbums);
if ($album=$DB_site->fetch_array($albums)) {
  $id = $album['SpecialID'];
  $name = $album['Name'];
  $photourl = $album['PhotoPath'];
  $singer = stripenglishname($album['NClassName']);
  $singerid = $album['NClassID'];
  $language = $album['Language'];
  $times = $album['PublishTime'];
  eval("\$newalbums = \"".gettemplate('home_newalbum_right_lists')."\";");

  while ($album=$DB_site->fetch_array($albums)) {
    $id = $album['SpecialID'];
    $name = $album['Name'];
    $photourl = $album['PhotoPath'];
    $singer = stripenglishname($album['NClassName']);
    $singerid = $album['NClassID'];
    $language = $album['Language'];
    $times = $album['PublishTime'];
    eval("\$newalbums .= \"".gettemplate('home_newalbum_right_lists')."\";");
  }
}
$DB_site->free_result($albums);
eval("\$newalbumright = \"".gettemplate('home_newalbum_right')."\";");

//######################## 推薦專輯 #############################
$albums = $DB_site->query("SELECT SpecialID,Name,PhotoPath,NClassName,Intro,NClassID,PublishTime,Language 
                           FROM ".$table["special"]."
                           WHERE IsGood=1
                           ORDER BY Specialid DESC
                           LIMIT ".intval($maxNumRecmdAlbum));

if ($album=$DB_site->fetch_array($albums)) {
  $id = $album['SpecialID'];
  $name = $album['Name'];
  $photourl = $album['PhotoPath'];
  $intro = getfirststr($album['Intro'],$lengthRecmdAlbumIntro);
  $singer = stripenglishname($album['NClassName']);
  $singerid = $album['NClassID'];
  $language = $album['Language'];
  $times = $album['PublishTime'];
  eval("\$recmdalbums = \"".gettemplate('home_recmdalbum_lists')."\";");

  while ($album=$DB_site->fetch_array($albums)) {
    $id = $album['SpecialID'];
    $name = $album['Name'];
    $photourl = $album['PhotoPath'];
    $intro = getfirststr($album['Intro'],$lengthRecmdAlbumIntro);
    $singer = stripenglishname($album['NClassName']);
    $singerid = $album['NClassID'];
    $language = $album['Language'];
    $times = $album['PublishTime'];
    eval("\$recmdalbums .= \"".gettemplate('home_recmdalbum_lists')."\";");
  }
}
$DB_site->free_result($albums);
eval("\$recmdalbum = \"".gettemplate('home_recmdalbum')."\";");

//######################### 推薦歌曲 #################################
$musics = $DB_site->query("SELECT ID,Singer,SClassID,NClassID,MusicName 
                           FROM ".$table["musiclist"]."
                           WHERE IsGood=1
                           ORDER BY ID DESC
                           LIMIT ".intval($maxNumRecmdMusic));

if ($music=$DB_site->fetch_array($musics)) {
  $num = 1;
  $firstcolor = $recmdMusicFirstColorOne;
  $secondcolor = $recmdMusicFirstColorTwo;
  $id = $music['ID'];
  $musicname = $music['MusicName'];
  $sclassid = $music['SClassID'];
  $nclassid = $music['NClassID'];
  $singer = stripenglishname($music['Singer']);
  eval("\$recmdmusics = \"".gettemplate('home_recmdmusic_lists')."\";");

  while ($music=$DB_site->fetch_array($musics)) {
    $num++;
    if (($num%2)==0) {
      $firstcolor = $recmdMusicSecondColorOne;
      $secondcolor = $recmdMusicSecondColorTwo;
    } else {
      $firstcolor = $recmdMusicFirstColorOne;
      $secondcolor = $recmdMusicFirstColorTwo;
    }
    $id = $music['ID'];
    $musicname = $music['MusicName'];
    $sclassid = $music['SClassID'];
    $nclassid = $music['NClassID'];
    $singer = stripenglishname($music['Singer']);
    eval("\$recmdmusics .= \"".gettemplate('home_recmdmusic_lists')."\";");
  }
}
$DB_site->free_result($musics);
eval("\$recmdmusic = \"".gettemplate('home_recmdmusic')."\";");

//######################### 友情鏈接 ###############################
eval("\$link = \"".gettemplate('home_link')."\";");

//######################### 站點信息 ###############################
$a_singers=$DB_site->query_first("SELECT COUNT(*) AS num FROM ".$table["nclass"]);
$num_singer=$a_singers["num"];
$a_albums=$DB_site->query_first("SELECT COUNT(*) AS num FROM ".$table["special"]);
$num_album=$a_albums["num"];
$a_musics=$DB_site->query_first("SELECT COUNT(*) AS num FROM ".$table["musiclist"]);
$num_music=$a_musics["num"];
$datecut=time()-$cookietimeout;
$a_onlineusers1=$DB_site->query_first("SELECT COUNT(*) AS num FROM ".$table["session"]." WHERE userid=0 AND lastactivity>$datecut");
$a_onlineusers2=$DB_site->query_first("SELECT COUNT(DISTINCT userid) AS num FROM ".$table["session"]." WHERE userid>0 AND lastactivity>$datecut");
$num_onlineuser=$a_onlineusers1["num"]+$a_onlineusers2["num"];

eval("\$webstate = \"".gettemplate('home_state')."\";");

//######################### 輸出 ###################################
eval("dooutput(\"".gettemplate('home')."\");");

?>