<?PHP
error_reporting(7);

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

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

$templatesused = '';
include("./global.php");

/*
if (!$permissions['candownload']) {
  $message = "您沒有下載的權限，請和管理人員聯系詢問!";
  eval("dooutput(\"".gettemplate("standardalert")."\");");
  exit;
}
*/

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

// ############################### 查看 ###############################
if ($action=="show") {
  if ($id=="") {
    $message = "請選擇歌曲!";
    eval("dooutput(\"".gettemplate("standardalert")."\");");
    exit;

  } else {
    $lyric = $DB_site->query_first("SELECT * 
                                    FROM ".$table["lyric"]."
                                    WHERE musicid=".$id." AND visible=1 
                                    ORDER BY LENGTH(lyric) DESC");

    if ($lyric!=0) {
      $musicinfo=getmusicinfo($lyric["musicid"]);
      if ($lyric["userid"]>0) {
        $userinfo=getuserinfo($lyric["userid"]);
      } else {
        $userinfo[username] = "訪客";
      }
      eval("dooutput(\"".gettemplate("lyric")."\");");
    } else {
      $action = "post";
    }
  }
}

// ############################### 提交 ###############################
if ($action=="post") {
  eval("dooutput(\"".gettemplate("lyric_postnew")."\");");
}

// ############################### 提交確認 ###############################
if ($HTTP_POST_VARS['action']=="dopost") {
  if ($HTTP_POST_VARS['musicid']=="") {
    $message = "請選擇歌曲!";
    eval("dooutput(\"".gettemplate("standardalert")."\");");
    exit;

  } else {
    if (getmusicinfo(intval($HTTP_POST_VARS['musicid']))!=0) {
      if (strlen(trim($lyric))>40) {
        $DB_site->query("INSERT INTO ".$table["lyric"]." 
                         (lyricid,userid,musicid,visible,dateline,lyric) VALUES 
                         (NULL,'$bbuserinfo[userid]','".intval($HTTP_POST_VARS[musicid])."','0','$ourtimenow','".addslashes(text2html($lyric))."')");
        if ($DB_site->insert_id()!=0) {
          $message = "歌詞添加成功，請等待管理員認證!";
          eval("dooutput(\"".gettemplate("standardalert")."\");");
        } else {
          $message = "歌詞添加失敗，可能發生了問題，請稍候再試!";
          eval("dooutput(\"".gettemplate("standardalert")."\");");
        }
      } else {
        $message = "歌詞添加成功，請等待管理員認證! ;)";
        eval("dooutput(\"".gettemplate("standardalert")."\");");
      }
    } else {
      $message = "歌曲不存在,可能已被刪除,請重新刷新頁面!";
      eval("dooutput(\"".gettemplate("standardalert")."\");");
      exit;

    }
  }
}

?>