lyric.php

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

<?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;

    }
  }
}

?>