list.php

mv 具体不是很清楚

<?php
require_once("global.php");
$linkdb=array(
			"全部视频"=>"?job=list",
			"已审核的视频"=>"?job=list&type=yz&fid=$fid",
			"未审核的视频"=>"?job=list&type=unyz&fid=$fid",
			"推荐视频"=>"?job=list&type=levels&fid=$fid",
			);

$fid=intval($fid);

if($job=="list")
{
	$SQL=" 1 ";
	if($fid>0){
		$SQL.=" AND fid=$fid ";
	}
	
	if($type=="yz"){
		$SQL.=" AND yz=1 ";
	}
	elseif($type=="unyz"){
		$SQL.=" AND yz=0 ";
	}
	elseif($type=="levels"){
		$SQL.=" AND levels=1 ";
	}
	elseif($type=="unlevels"){
		$SQL.=" AND levels=0 ";
	}
	elseif($type=="pic"){
		$SQL.=" AND ispic=1 ";
	}
	elseif($type=="my"){
		$SQL.=" AND uid='$userdb[uid]' ";
	}
	elseif($type=="title"){
		$SQL.=" AND binary title LIKE '%$keyword%' ";
	}
	elseif($type=="id"){
		$SQL.=" AND id='$keyword' ";
	}
	elseif($type=="content"){
		$SQL.=" AND binary content LIKE '%$keyword%' ";
	}
	elseif($type=="username"){
		$SQL.=" AND binary username LIKE '%$keyword%' ";
	}

	$rows=50;
	if($page<1){
		$page=1;
	}
	$min=($page-1)*$rows;
	$order="list";
	$desc="DESC";
	$showpage=getpage("{$pre}mv_video","WHERE $SQL","?lfj=$lfj&job=list&fid=$fid&type=$type&keyword=".urlencode($keyword),$rows,"");
	$sort_fid=$Guidedb->Select("{$pre}mv_sort","fid",$fid,"?lfj=$lfj&job=list");
	$query=$db->query("SELECT * FROM {$pre}mv_video WHERE $SQL ORDER BY $order $desc LIMIT $min,$rows");
	while($rs=$db->fetch_array($query))
	{
		if(!$rs[yz]){
			$rs[ischeck]="<A HREF='?lfj=$lfj&action=work&id=$rs[id]&jobs=yz' style='color:black;'>未审核</A>";
		}else{
			$rs[ischeck]="<A HREF='?lfj=$lfj&action=work&id=$rs[id]&jobs=unyz' style='color:blue;'>已审核</A>";
		}
		if($rs[levels]==1){
			$rs[iscom]="<A HREF='?lfj=$lfj&action=work&id=$rs[id]&jobs=com&levels=0' style='color:red;'>已推荐</A>";
		}else{
			$rs[iscom]="<A HREF='?lfj=$lfj&action=work&id=$rs[id]&jobs=com&levels=1' style=''>未推荐</A>";
		}

		$rs[title2]=urlencode($rs[title]);
		$rs[posttime]=date("Y-m-d H:i:s",$rs[posttime]);
		$listdb[$rs[id]]=$rs;
	}
	require("head.php");
	require("template/post/list.htm");
	require("foot.php");
}
elseif($job=="work")
{
	if(!$listdb){
		showmsg("请选择一个软件");
	}
	if($jobs=="move"){
		$sort_fid=$Guidedb->Select("{$pre}mv_sort","fid");
	}
	require("head.php");
	require("template/post/work.htm");
	require("foot.php");
}
elseif($action=="work")
{
	if(!$listdb&&!$id){
		showmsg("请选择一个软件");
	}
	elseif(is_array($listdb))
	{
		foreach($listdb AS $key=>$value){
			dowork($key,$jobs);
		}
	}
	elseif($id){
		dowork($id,$jobs);
	}
	$url=$fromurl?$fromurl:$FROMURL;
	refreshto($url,"操作成功",0);
}


function dowork($id,$job){
	global $db,$pre,$timestamp,$userdb;
	$rsdb=$db->get_one("SELECT * FROM {$pre}mv_video WHERE id='$id' ");
	if($job=="delete")
	{
		/*
		global $forcedel;
		if($forcedel==1)
		{
			$db->query("DELETE FROM {$pre}mv_video WHERE id='$id' ");
		}
		else
		{
			$db->query("UPDATE {$pre}mv_video SET fid=0,fname='',lastfid='$rsdb[fid]' WHERE id='$id' ");
		}
		*/

		//删除附件
		//delete_attachment($rsdb[uid],$rsdb[content]);

		$rsdb[picurl]=tempdir($rsdb[picurl]);
		delete_attachment($rsdb[uid],$rsdb[picurl]);

		$rsdb[flashurl]=tempdir($rsdb[flashurl]);
		delete_attachment($rsdb[uid],$rsdb[flashurl]);
		
		//处理多附件.比如 r.rar@@名称\r\nfeeer.rar@@名称r

		$detail=explode("\r\n",$rsdb[downloadurl]);
		foreach( $detail AS $key=>$value){
			list($url,$name)=explode("@@",$value);
			$url=tempdir($url);
			//delete_attachment($rsdb[uid],$url);
		}

		$db->query("DELETE FROM {$pre}mv_video WHERE id='$id' ");
		
	}
	elseif($job=="move")
	{
		global $fid;
		if($fid){
			$rs=$db->get_one("SELECT name FROM {$pre}mv_sort WHERE fid='$fid'");
			$db->query("UPDATE {$pre}mv_video SET fid='$fid',fname='$rs[name]',lastfid='$rsdb[fid]' WHERE id='$id' ");
		}
	}
	elseif($job=="color")
	{
		global $color;
		$db->query("UPDATE {$pre}mv_video SET titlecolor='$color' WHERE id='$id' ");
	}
	elseif($job=="yz")
	{
		$db->query("UPDATE {$pre}mv_video SET yz='1',yzer='$userdb[username]',yztime='$timestamp' WHERE id='$id' ");
	}
	elseif($job=="unyz")
	{
		$db->query("UPDATE {$pre}mv_video SET yz='0',yzer='$userdb[username]',yztime='$timestamp' WHERE id='$id' ");
	}
	elseif($job=="com")
	{
		global $levels;
		if($levels==1){
			$SQL=",yz=1";
		}
		$db->query("UPDATE {$pre}mv_video SET levels='$levels',levelstime='$timestamp'$SQL WHERE id='$id' ");
	}
	elseif($job=="unyz")
	{
		$db->query("UPDATE {$pre}mv_video SET levels='0',levelstime='0' WHERE id='$id' ");
	}
	elseif($job=="top")
	{
		global $toptime;
		$db->query("UPDATE {$pre}mv_video SET list=list+'$toptime' WHERE id='$id' ");
	}
	elseif($job=="untop")
	{
		$db->query("UPDATE {$pre}mv_video SET list='$timestamp' WHERE id='$id' ");
	}
	elseif($job=="front")
	{
		global $topid;
		if($topid)
		{
			$rs=$db->get_one("SELECT list FROM {$pre}mv_video WHERE id='$topid' ");
			$list=$rs["list"]+1;
			$db->query("UPDATE {$pre}mv_video SET list='$list' WHERE id='$id' ");
		}
		else
		{
			$db->query("UPDATE {$pre}mv_video SET list='$timestamp' WHERE id='$id' ");
		}
	}
	elseif($job=="bottom")
	{
		global $bottomid;
		if($bottomid)
		{
			$rs=$db->get_one("SELECT list FROM {$pre}mv_video WHERE id='$bottomid' ");
			$list=$rs["list"]-1;
			$db->query("UPDATE {$pre}mv_video SET list='$list' WHERE id='$id' ");
		}
		else
		{
			$db->query("UPDATE {$pre}mv_video SET list='0' WHERE id='$id' ");
		}
	}
}
?>