insert.php

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

PHP
80
字号
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/utility_sms1.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";
$PIECES = explode( ",", $TO_ID );
$PIECES_COUNT = sizeof( $PIECES );
if ( $PIECES[$PIECES_COUNT - 1] == "" )
{
	--$PIECES_COUNT;
}
$I = 0;
for ( ;	$I < $PIECES_COUNT;	++$I	)
{
	$query = "select * from USER where DEPT_ID='".$PIECES[$I]."'";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$USER_ID1 = $ROW['USER_ID'];
		if ( !( $LOGIN_USER_ID == $USER_ID1 ) )
		{
			$TO_USER .= $USER_ID1.",";
		}
	}
}
$PIECES = explode( ",", $PRIV_ID );
$PIECES_COUNT = sizeof( $PIECES );
if ( $PIECES[$PIECES_COUNT - 1] == "" )
{
	--$PIECES_COUNT;
}
$I = 0;
for ( ;	$I < $PIECES_COUNT;	++$I	)
{
	$query = "select * from USER where USER_PRIV='".$PIECES[$I]."'";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$USER_ID1 = $ROW['USER_ID'];
		if ( !( $LOGIN_USER_ID == $USER_ID1 ) )
		{
			$TO_USER .= $USER_ID1.",";
		}
	}
}
$PIECES = explode( ",", $TO_ID3 );
$PIECES_COUNT = sizeof( $PIECES );
if ( $PIECES[$PIECES_COUNT - 1] == "" )
{
	--$PIECES_COUNT;
}
$I = 0;
for ( ;	$I < $PIECES_COUNT;	++$I	)
{
	$query = "select * from USER where USER_ID='".$PIECES[$I]."'";
	$cursor = exequery( $connection, $query );
	while ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$USER_ID1 = $ROW['USER_ID'];
		if ( !( $LOGIN_USER_ID == $USER_ID1 ) )
		{
			$TO_USER .= $USER_ID1.",";
		}
	}
}
if ( $SMS_REMIND == "on" )
{
	send_sms( "", $LOGIN_USER_ID, $TO_USER, 18, $BOARD_NAME."内部讨论区欢迎您的光临!" );
}
if ( $SMS2_REMIND == "on" )
{
	send_mobile_sms_user( "", $LOGIN_USER_ID, $TO_USER, $BOARD_NAME."内部讨论区欢迎您的光临!", 18 );
}
$query = "insert into BBS_BOARD(BOARD_NAME,DEPT_ID,ANONYMITY_YN,ANONYMITY_FLAG,WELCOME_TEXT,BOARD_HOSTER,BOARD_NO,PRIV_ID,USER_ID,POST_TIME,TYPE_ID,FILTER_TEXT) values ('".$BOARD_NAME."','{$TO_ID}','{$ANONYMITY_YN}','{$ANONYMITY_FLAG}','{$WELCOME_TEXT}','{$COPY_TO_ID}','{$BOARD_NO}','{$PRIV_ID}','{$TO_ID3}','{$POST_TIME}','{$TYPE_ID}','{$FILTER_TEXT}')";
exequery( $connection, $query );
header( "location: index.php" );
echo "\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

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