insert.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?php

include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
include_once( "inc/utility_sms1.php" );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $REPLY == "1" )
{
	$query = "update PROJ_FORUM set REPLY_CONT=REPLY_CONT+1,SUBMIT_TIME='".$CUR_TIME."' where MSG_ID={$MSG_ID}";
	exequery( $connection, $query );
}
if ( 1 < count( $_FILES ) )
{
	$ATTACHMENTS = upload( );
	$ATTACHMENT_ID = $ATTACHMENTS['ID'];
	$ATTACHMENT_NAME = $ATTACHMENTS['NAME'];
}
$ATTACHMENT_ID .= copy_sel_attach( $ATTACH_NAME, $ATTACH_DIR, $DISK_ID );
$ATTACHMENT_NAME .= $ATTACH_NAME;
if ( $REPLY == "1" )
{
	$PARENT = $MSG_ID;
}
else
{
	$PARENT = 0;
}
if ( $REPLY == 1 )
{
	$CONTENT = str_replace( " ", "&nbsp;", $CONTENT );
	$CONTENT = str_replace( "\n", "<br />", $CONTENT );
}
if ( $SUBJECT == "" )
{
	$SUBJECT = "无标题";
}
$query = "insert into PROJ_FORUM(PROJ_ID, USER_ID, SUBJECT, CONTENT, ATTACHMENT_ID, ATTACHMENT_NAME, SUBMIT_TIME, REPLY_CONT,PARENT,OLD_SUBMIT_TIME) values ( '".$PROJ_ID."', '{$LOGIN_USER_ID}', '{$SUBJECT}', '{$CONTENT}', '{$ATTACHMENT_ID}', '{$ATTACHMENT_NAME}', '{$CUR_TIME}', 0 ,'{$PARENT}','{$CUR_TIME}')";
exequery( $connection, $query );
$MSG_ID_NEW = mysql_insert_id( );
if ( $SMS_REMIND == "on" || $SMS2_REMIND == "on" )
{
	$query = "select PARA_VALUE from SYS_PARA where PARA_NAME='SMS_REMIND'";
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$PARA_VALUE = $ROW['PARA_VALUE'];
	}
	$SMS_REMIND1 = substr( $PARA_VALUE, 0, strpos( $PARA_VALUE, "|" ) );
	$SMS2_REMIND1 = substr( $PARA_VALUE, strpos( $PARA_VALUE, "|" ) + 1 );
	$REMIND_URL = "1:project/proj/forum/comment.php?PROJ_ID=".$PROJ_ID."&MSG_ID=".$MSG_ID_NEW."&PAGE_START=0";
	if ( $REPLY == "1" )
	{
		$query2 = "select USER_ID,SUBJECT from PROJ_FORUM where MSG_ID=".$MSG_ID;
		$cursor2 = exequery( $connection, $query2 );
		if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
		{
			$USER_ID = $ROW2['USER_ID'];
			$SUBJECT = $ROW2['SUBJECT'];
		}
		if ( $SMS_REMIND == "on" && $LOGIN_USER_ID != $USER_ID && find_id( $SMS_REMIND1, 42 ) )
		{
			send_sms( "", $LOGIN_USER_ID, $USER_ID, 18, $SUBJECT."得到回复，请查看！", $REMIND_URL );
		}
		if ( $SMS2_REMIND == "on" && $LOGIN_USER_ID != $USER_ID && find_id( $SMS2_REMIND1, 42 ) )
		{
			send_mobile_sms_user( "", $LOGIN_USER_ID, $USER_ID, $SUBJECT."得到回复，请查看！", 42 );
		}
	}
	else
	{
		$query = "SELECT PROJ_USER from PROJ_PROJECT where PROJ_ID='".$PROJ_ID."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$PROJ_USER = $ROW['PROJ_USER'];
			$PROJ_USER = str_replace( "|", "", $PROJ_USER );
			$query1 = "select USER_ID from USER where NOT_LOGIN!='1' AND FIND_IN_SET(USER_ID,'".$PROJ_USER."') AND USER_ID!='{$LOGIN_USER_ID}'";
			$cursor1 = exequery( $connection, $query1 );
			while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
			{
				$USER_ID_STR .= $ROW1['USER_ID'].",";
			}
		}
		if ( $SMS_REMIND == "on" )
		{
			send_sms( "", $LOGIN_USER_ID, $USER_ID_STR, 42, $LOGIN_USER_NAME."在项目讨论区发贴，主题为：".$SUBJECT, $REMIND_URL );
		}
		if ( $SMS2_REMIND == "on" )
		{
			send_mobile_sms_user( "", $LOGIN_USER_ID, $USER_ID_STR, $LOGIN_USER_NAME."在项目讨论区发贴，主题为：".$SUBJECT, 42 );
		}
	}
}
if ( $REPLY == "1" )
{
	header( "location: comment.php?PROJ_ID=".$PROJ_ID."&MSG_ID={$MSG_ID}&PAGE_START={$PAGE_START}&start={$start}" );
}
else
{
	header( "location: index.php?PROJ_ID=".$PROJ_ID."&PAGE_START={$PAGE_START}&start={$start}" );
}
?>