📄 insert.php
字号:
<?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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -