insert.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 100 行

PHP
100
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_sms1.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $PIECES = explode (',', $TO_ID);
  $PIECES_COUNT = sizeof ($PIECES);
  if (($PIECES[($PIECES_COUNT - 1)] == ''))
  {
    --$PIECES_COUNT;
  }
  for ($I = 0; ($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))
      {
        continue;
      }
      else
      {
        ($TO_USER .= ($USER_ID1.','));
        continue;
      }
    }
  }
  $PIECES = explode (',', $PRIV_ID);
  $PIECES_COUNT = sizeof ($PIECES);
  if (($PIECES[($PIECES_COUNT - 1)] == ''))
  {
    --$PIECES_COUNT;
  }
  for ($I = 0; ($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))
      {
        continue;
      }
      else
      {
        ($TO_USER .= ($USER_ID1.','));
        continue;
      }
    }
  }
  $PIECES = explode (',', $TO_ID3);
  $PIECES_COUNT = sizeof ($PIECES);
  if (($PIECES[($PIECES_COUNT - 1)] == ''))
  {
    --$PIECES_COUNT;
  }
  for ($I = 0; ($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))
      {
        continue;
      }
      else
      {
        ($TO_USER .= ($USER_ID1.','));
        continue;
      }
    }
  }
  $query = (((((((((((((((((''.'insert into BBS_BOARD(BOARD_NAME,DEPT_ID,ANONYMITY_YN,WELCOME_TEXT,BOARD_HOSTER,BOARD_NO,PRIV_ID,USER_ID) values (\'').$BOARD_NAME).'\',\'').$TO_ID).'\',\'').$ANONYMITY_YN).'\',\'').$WELCOME_TEXT).'\',\'').$COPY_TO_ID).'\',\'').$BOARD_NO).'\',\'').$PRIV_ID).'\',\'').$TO_ID3).'\')');
  exequery ($connection, $query);
  $ROW_ID = mysql_insert_id ();
  if (($SMS_REMIND == 'on'))
  {
    send_sms ('', $LOGIN_USER_ID, $TO_USER, 18, ($BOARD_NAME.'内部讨论区欢迎您的光临!'), $REMIND_URL);
  }
  if (($SMS2_REMIND == 'on'))
  {
    send_mobile_sms_user ('', $LOGIN_USER_ID, $TO_USER, ($BOARD_NAME.'内部讨论区欢迎您的光临!'), 18);
  }
  header ('location: index.php');
  echo '
</body>
</html>';
?>

⌨️ 快捷键说明

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