delete_all0.php

来自「极限网络智能办公系统 - Office Automation 2008 官方10」· PHP 代码 · 共 111 行

PHP
111
字号
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $SEND_TIME_MIN != "" )
{
	$TIME_OK = is_date( $SEND_TIME_MIN );
	if ( !$TIME_OK )
	{
		message( "错误", "\"发布日期\"的格式不对,应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$SEND_TIME_MIN .= " 00:00:00";
}
if ( $SEND_TIME_MAX != "" )
{
	$TIME_OK = is_date( $SEND_TIME_MAX );
	if ( !$TIME_OK )
	{
		message( "错误", "\"发布日期\"的格式不对,应形如 ".$CUR_DATE );
		button_back( );
		exit( );
	}
	$SEND_TIME_MAX .= " 23:59:59";
}
$CONDITION_STR = "";
if ( $SUBJECT != "" )
{
	$CONDITION_STR .= " and SUBJECT like '%".$SUBJECT."%'";
}
if ( $CONTENT != "" )
{
	$CONDITION_STR .= " and CONTENT like '%".$CONTENT."%'";
}
if ( $SEND_TIME_MIN != "" )
{
	$CONDITION_STR .= " and NEWS_TIME>='".$SEND_TIME_MIN."'";
}
if ( $SEND_TIME_MAX != "" )
{
	$CONDITION_STR .= " and NEWS_TIME<='".$SEND_TIME_MAX."'";
}
if ( $CLICK_COUNT_MIN != "" )
{
	$CONDITION_STR .= " and CLICK_COUNT>=".$CLICK_COUNT_MIN;
}
if ( $CLICK_COUNT_MAX != "" )
{
	$CONDITION_STR .= " and CLICK_COUNT<=".$CLICK_COUNT_MAX;
}
if ( $FORMAT != "" )
{
	$CONDITION_STR .= " and FORMAT='".$FORMAT."'";
}
if ( $TYPE_ID != "" )
{
	$CONDITION_STR .= " and TYPE_ID='".$TYPE_ID."'";
}
if ( $PUBLISH != "" )
{
	$CONDITION_STR .= " and PUBLISH='".$PUBLISH."'";
}
if ( $LOGIN_USER_PRIV == "1" )
{
	$query = "SELECT NEWS_ID,ATTACHMENT_ID,ATTACHMENT_NAME from NEWS where 1=1";
}
else
{
	$query = "SELECT NEWS_ID,ATTACHMENT_ID,ATTACHMENT_NAME from NEWS where PROVIDER='".$LOGIN_USER_ID."'";
}
$query .= $CONDITION_STR." order by NEWS_TIME desc";
$cursor = exequery( $connection, $query );
$NEWS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$NEWS_ID = $ROW['NEWS_ID'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	if ( $ATTACHMENT_NAME != "" )
	{
		$ATTACHMENT_ID_ARRAY = explode( ",", $ATTACHMENT_ID );
		$ATTACHMENT_NAME_ARRAY = explode( "*", $ATTACHMENT_NAME );
		$ARRAY_COUNT = sizeof( $ATTACHMENT_ID_ARRAY );
		$I = 0;
		for ( ;	$I < $ARRAY_COUNT;	++$I	)
		{
			if ( $ATTACHMENT_ID_ARRAY[$I] == "" )
			{
				break;
			}
			if ( $ATTACHMENT_NAME_ARRAY[$I] != "" )
			{
				delete_attach( $ATTACHMENT_ID_ARRAY[$I], $ATTACHMENT_NAME_ARRAY[$I] );
			}
		}
	}
	$query1 = "delete from NEWS where NEWS_ID=".$NEWS_ID;
	exequery( $connection, $query1 );
	$query1 = "delete from NEWS_COMMENT where NEWS_ID=".$NEWS_ID;
	exequery( $connection, $query1 );
	++$NEWS_COUNT;
}
message( "", "共删除".$NEWS_COUNT."条新闻" );
button_back( );
exit( );
?>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?