post.php

mv 具体不是很清楚

<?php
require_once("global.php");

$max_upload = ini_get('upload_max_filesize');

/**
*postnew=>新发表,mod=>修改
**/
if($action=="postnew"||$action=="mod")
{

	//图片目录转移
	move_attachment($userdb[uid],tempdir($postdb[picurl]),"mv/$postdb[fid]");
	if(file_exists(PHP168_PATH."$webdb[updir]/mv/$postdb[fid]/".basename($postdb[picurl]))){
		$postdb[picurl]="mv/$postdb[fid]/".basename($postdb[picurl]);
	}

	//目录转移
	move_attachment($userdb[uid],tempdir($postdb[videourl]),"mv/$postdb[fid]");
	if(file_exists(PHP168_PATH."$webdb[updir]/mv/$postdb[fid]/".basename($postdb[videourl]))){
		$postdb[videourl]="mv/$postdb[fid]/".basename($postdb[videourl]);
	}

	if($jobs=="usehtml")
	{
		$postdb[ishtml]=1;
	}
	if($action=="mod")
	{
		$rs=$db->get_one(" SELECT picurl FROM `{$pre}mv_video` WHERE id='$id' ");
	}
	/*缩略图处理*/
	if($postdb[picurl]&&$postdb[picurl]!=$rs[picurl])
	{
		if( $webdb[if_gdimg] )
		{
			$smallpic="$postdb[picurl]";
			$Newpicpath=PHP168_PATH."$webdb[updir]/$smallpic";
			gdpic(PHP168_PATH."$webdb[updir]/$postdb[picurl]",$Newpicpath,200,150);
			if( file_exists($Newpicpath) )
			{
				$postdb[picurl]="$smallpic";
			}
		}
	}
	$postdb[content]=filtrate($postdb[content]);
	//过滤不健康的字
	$postdb[content]=replace_bad_word($postdb[content]);
	$postdb[title]=replace_bad_word($postdb[title]);
	$postdb[author]=replace_bad_word($postdb[author]);
}
/**
*
**/
if($job=="postnew")
{
	$fonttype=$rsdb[fonttype]==1?" checked ":"";
	$yz=" checked ";
	if($rsdb["list"]>$timestamp)
	{
		$top=" checked ";
	}
	if($rsdb["levels"])
	{
		$levels=" checked ";
	}
	if($rsdb["target"])
	{
		$target=" checked ";
	}
	$sort_fid=$Guidedb->Select("{$pre}mv_sort","postdb[fid]",$rsdb[fid]);
	$sort_fid=str_replace("<select name='postdb[fid]'","<select id='fid' name='postdb[fid]'",$sort_fid);
	unset($keywords);
	$query=$db->query("SELECT * FROM {$pre}keyword ORDER BY list DESC ");
	while($rs=$db->fetch_array($query)){
		$keywords.="<option value='$rs[keywords]' >$rs[keywords]</option>";
	}
	if($rsdb[ishtml]==1&&$jobs!='nousehtml')
	{
		$jobs="usehtml";
		$rsdb[content]=str_replace("'","",$rsdb[content]);
	}
	$rsdb[posttime]=date("Y-m-d H:i:s",$timestamp);
	$rsdb[auto]=' checked ';
	//$rsdb[begintime]&&$rsdb[begintime]=date("Y-m-d H:i:s",$rsdb[begintime]);
	//$rsdb[endtime]&&$rsdb[endtime]=date("Y-m-d H:i:s",$rsdb[endtime]);
	require("head.php");
	require("template/post/post.htm");
	require("foot.php");
}
/**
*
**/
elseif($action=="postnew")
{
	@extract($db->get_one(" SELECT name AS fname FROM {$pre}mv_sort WHERE fid='$postdb[fid]' "));
	/*置顶处理*/
	$postdb['list']=$postdb[top]?$timestamp*1.3:$timestamp;
	$postdb[keywords]&&$postdb[keywords]=str_Replace("　"," ",$postdb[keywords]);
	if($postdb[keywords]&&$addkeyword)
	{
		$detail=explode(' ',$postdb[keywords]);
		foreach($detail AS $key=>$value){
			if( $value&&!$db->get_one("SELECT * FROM {$pre}keyword WHERE keywords='$value' ") ){
				$db->query("INSERT INTO `{$pre}keyword` (`keywords` , `list` ) VALUES ('$value', '$timestamp')");
			}
		}
	}
	//$postdb[posttime]=preg_replace("/([\d]+)-([\d]+)-([\d]+) ([\d]+):([\d]+):([\d]+)/eis","@mktime(\\4,\\5, \\6, \\2, \\3, \\1)",$postdb[posttime]);
	//$postdb[begintime]&&$postdb[begintime]=preg_replace("/([\d]+)-([\d]+)-([\d]+) ([\d]+):([\d]+):([\d]+)/eis","@mktime(\\4,\\5, \\6, \\2, \\3, \\1)",$postdb[begintime]);
	//$postdb[endtime]&&$postdb[endtime]=preg_replace("/([\d]+)-([\d]+)-([\d]+) ([\d]+):([\d]+):([\d]+)/eis","@mktime(\\4,\\5, \\6, \\2, \\3, \\1)",$postdb[endtime]);
	if($postdb[picurl]){
		$postdb[ispic]=1;
	}
	$db->query("
	INSERT INTO `{$pre}mv_video` ( `title` , `albumid` , `fid` , `fname` , `info` , `hits` , `comments` , `posttime` , `list` , `uid` , `username` , `titlecolor` , `fonttype` , `picurl` , `ispic` , `yz` , `yzer` , `yztime` , `levels` , `levelstime` , `keywords` , `jumpurl` , `iframeurl` , `style` , `head_tpl` , `main_tpl` , `foot_tpl` , `target` , `ishtml` , `ip` , `lastfid` , `money` , `passwd` , `editer` , `edittime` , `begintime` , `endtime` , `content` , `videourl`,`playtype` ) 
	VALUES (
	'$postdb[title]','$postdb[albumid]','$postdb[fid]','$fname','$postdb[info]','$postdb[hits]','$postdb[comments]','$timestamp','$postdb[list]','$userdb[uid]','$userdb[username]','$postdb[titlecolor]','$postdb[fonttype]','$postdb[picurl]','$postdb[ispic]','$postdb[yz]','$postdb[yzer]','$postdb[yztime]','$postdb[levels]','$postdb[levelstime]','$postdb[keywords]','$postdb[jumpurl]','$postdb[iframeurl]','$postdb[style]','$postdb[head_tpl]','$postdb[main_tpl]','$postdb[foot_tpl]','$postdb[target]','$postdb[ishtml]','$postdb[ip]','$postdb[lastfid]','$postdb[money]','$postdb[passwd]','$postdb[editer]','$postdb[edittime]','$postdb[begintime]','$postdb[endtime]','$postdb[content]','$postdb[videourl]','$postdb[playtype]'
	)
	");
	$rs=$db->get_one("SELECT id,fid FROM {$pre}mv_video ORDER BY id DESC LIMIT 1 ");
	

	refreshto("?lfj=$lfj&job=postnew&fid=$postdb[fid]","<CENTER>[<A HREF='?lfj=$lfj&job=postnew&fid=$postdb[fid]'>继续发表</A>] [<A HREF='list.php?lfj=$lfj&job=list&fid=$postdb[fid]'>返回视频列表</A>] [<A HREF='../bencandy.php?fid=$rs[fid]&id=$rs[id]' target=_blank>查看</A>]</CENTER>",9);
}
/**
*修改 
**/
elseif($job=="mod")
{
	$rsdb=$db->get_one("SELECT * FROM `{$pre}mv_video` WHERE id='$id'");
	$fonttype=$rsdb[fonttype]==1?" checked ":"";
	$yz=$rsdb[yz]==1?" checked ":"";
	if($rsdb["list"]>$timestamp)
	{
		$top=" checked ";
	}
	if($rsdb["levels"])
	{
		$levels=" checked ";
	}
	if($rsdb["target"])
	{
		$target=" checked ";
	}
	$sort_fid=$Guidedb->Select("{$pre}mv_sort","postdb[fid]",$rsdb[fid]);
	$sort_fid=str_replace("<select name='postdb[fid]'","<select id='fid' name='postdb[fid]'",$sort_fid);
	unset($keywords);
	$query=$db->query("SELECT * FROM {$pre}keyword ORDER BY list DESC ");
	while($rs=$db->fetch_array($query)){
		$keywords.="<option value='$rs[keywords]' >$rs[keywords]</option>";
	}
	if($rsdb[ishtml]==1&&$jobs!='nousehtml')
	{
		$jobs="usehtml";
		$rsdb[content]=str_replace("'","",$rsdb[content]);
	}
	$rsdb[posttime]=date("Y-m-d H:i:s",$rsdb[posttime]);
	$rsdb[begintime]&&$rsdb[begintime]=date("Y-m-d H:i:s",$rsdb[begintime]);
	$rsdb[endtime]&&$rsdb[endtime]=date("Y-m-d H:i:s",$rsdb[endtime]);
	
	if(!$rsdb[playtype]){
		$rsdb[auto]=' checked ';
	}else{
		$rsdb[$rsdb[playtype]]=' checked ';
	}
	require("head.php");
	require("template/post/post.htm");
	require("foot.php");
}

/**
*处理修改 
**/
elseif($action=="mod")
{
	$rsdb=$db->get_one("SELECT * FROM `{$pre}mv_video` WHERE id='$id'");
	$postdb[keywords]&&$postdb[keywords]=str_Replace("　"," ",$postdb[keywords]);
	if($postdb[keywords]&&$addkeyword)
	{
		$detail=explode(' ',$postdb[keywords]);
		foreach($detail AS $key=>$value){
			if( $value&&!$db->get_one("SELECT * FROM {$pre}keyword WHERE keywords='$value' ") ){
				$db->query("INSERT INTO `{$pre}keyword` (`keywords` , `list` ) VALUES ('$value', '$timestamp')");
			}
		}
	}
	@extract($db->get_one(" SELECT name AS fname FROM {$pre}mv_sort WHERE fid='$postdb[fid]' "));
	$postdb[fname]=$fname;
	if( $rsdb[levels]&&$postdb[levels] )
	{
		$postdb[levels]=$rsdb[levels];	//处理其他级别2,3,4...以防出错
	}
	if($postdb[top])
	{
		$postdb['list']=($rsdb['list']>$timestamp)?$rsdb['list']:$timestamp*1.3;
	}
	else
	{
		$postdb['list']=($rsdb['list']>$timestamp)?$timestamp:$rsdb['list'];
	}
	//$postdb[posttime]=preg_replace("/([\d]+)-([\d]+)-([\d]+) ([\d]+):([\d]+):([\d]+)/eis","@mktime(\\4,\\5, \\6, \\2, \\3, \\1)",$postdb[posttime]);
	//$postdb[begintime]&&$postdb[begintime]=preg_replace("/([\d]+)-([\d]+)-([\d]+) ([\d]+):([\d]+):([\d]+)/eis","@mktime(\\4,\\5, \\6, \\2, \\3, \\1)",$postdb[begintime]);
	//$postdb[endtime]&&$postdb[endtime]=preg_replace("/([\d]+)-([\d]+)-([\d]+) ([\d]+):([\d]+):([\d]+)/eis","@mktime(\\4,\\5, \\6, \\2, \\3, \\1)",$postdb[endtime]);
	if($postdb[picurl]){
		$postdb[ispic]=1;
	}
	$db->query("UPDATE `{$pre}mv_video` SET title='$postdb[title]',fid='$postdb[fid]',fname='$postdb[fname]',info='$postdb[info]',comments='$postdb[comments]',list='$postdb[list]',titlecolor='$postdb[titlecolor]',fonttype='$postdb[fonttype]',picurl='$postdb[picurl]',ispic='$postdb[ispic]',yz='$postdb[yz]',yzer='$postdb[yzer]',yztime='$postdb[yztime]',levels='$postdb[levels]',levelstime='$postdb[levelstime]',keywords='$postdb[keywords]',jumpurl='$postdb[jumpurl]',iframeurl='$postdb[iframeurl]',style='$postdb[style]',head_tpl='$postdb[head_tpl]',main_tpl='$postdb[main_tpl]',foot_tpl='$postdb[foot_tpl]',target='$postdb[target]',ishtml='$postdb[ishtml]',ip='$onlineip',lastfid='$postdb[lastfid]',money='$postdb[money]',passwd='$postdb[passwd]',editer='$postdb[editer]',edittime='$postdb[edittime]',begintime='$postdb[begintime]',endtime='$postdb[endtime]',content='$postdb[content]',videourl='$postdb[videourl]',playtype='$postdb[playtype]' WHERE id='$id' ");

	refreshto("$FROMURL","<CENTER>[<A HREF='?lfj=$lfj&job=postnew&fid=$postdb[fid]'>继续发表</A>] [<A HREF='list.php?lfj=$lfj&job=list&fid=$postdb[fid]'>返回视频列表</A>] [<A HREF='../bencandy.php?fid=$rsdb[fid]&id=$rsdb[id]' target=_blank>查看</A>]</CENTER>",9);
}
?>