lyric.php

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

<?php
error_reporting(7);

require("./global.php");

cpheader();

if ($getperms[canadminmusiclyric]!=1) {
  echo "<p>您的权限不够!</p>\n";
  exit;
}

// ##################################### 认证 #####################################
if ($action=="moderate") {

  if ($limitstart=="") {
    $limitstart=0;
  } else {
    $limitstart--;
  }
  if ($limitnumber=="") {
    $limitnumber=200;
  }

  $countlyrics=$DB_site->query_first("SELECT COUNT(*) AS lyrics FROM ".$table["lyric"]." WHERE visible=0");

  if ($countlyrics['lyrics']>0) {
    $lyrics=$DB_site->query("SELECT * 
                             FROM ".$table["lyric"]." 
                             WHERE visible=0 ORDER BY musicid LIMIT $limitstart,$limitnumber");

    $limitfinish=$limitstart+$limitnumber;

    echo "<p>显示总共 $countlyrics[lyrics] 条记录中的 ".($limitstart+1)." 到 ".iif($limitfinish>$countlyrics[lyrics],$countlyrics[lyrics],$limitfinish)." 条 . </p>";
    doformheader("lyric","domoderate");
    maketableheader("等待验证的歌词");

    while ($lyric=$DB_site->fetch_array($lyrics)) {
  
      $music=$DB_site->query_first("SELECT MusicName,Singer FROM ".$table["musiclist"]." WHERE ID='$lyric[musicid]'");
      if ($lyric[userid]!=0)
        $user=$DB_site->query_first("SELECT userid,username FROM ".$table["user"]." WHERE userid='$lyric[userid]'");

      if ($lyric[userid]!=0) {
        makelabelcode("<b>发表人:</b>","<a href=\"user.php?s=$session[sessionhash]&action=edit&userid=$user[userid]\">$user[username]</a>");
      } else {
        makelabelcode("<b>发表人:</b>","访客");
      }
      makelabelcode("<b>歌名:</b>","$music[MusicName]");
      makelabelcode("<b>歌手:</b>","$music[Singer]");
      maketextareacode("歌词:","lyric[$lyric[lyricid]]",$lyric[lyric],4,50);
      makeyesnocode("验证:","validatelyric[$lyric[lyricid]]",0);
      makeyesnocode("删除:","deletelyric[$lyric[lyricid]]",0);
      maketableheader("&nbsp;","",0);
      $done=1;
    }
    restarttable();

    if ($done) {
      doformfooter();
    }
  } else {
    maketableheader("没有需要审查的!");
  }
}

// ################################### 通过认证 ###################################
if ($HTTP_POST_VARS['action']=="domoderate") {

  if (is_array($validatelyric)) {
    while (list($key,$val)=each($validatelyric)) {
      if ($deletelyric[$key]) {
        //delete lyric
        $DB_site->query("DELETE FROM ".$table["lyric"]." WHERE lyricid='$key'");
        echo "<p>已删除歌词: $key</p>\n";
      } else {
        if ($val) {
          // do queries
          // not htmlspecialchars();
          $DB_site->query("UPDATE ".$table["lyric"]." SET visible='$val',lyric='".addslashes(text2html($lyric[$key]))."' WHERE lyricid='$key'");
          echo "<p>已验证主题: $key</p>\n";
        }
      }
    }
  }

  echo "<p>歌词已经成功审查.</p>";

}

cpfooter();

?>