⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 check_capacity.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");

$query = "SELECT * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
   $FOLDER_CAPACITY=$ROW["FOLDER_CAPACITY"];

function tree_size($SORT_ID_TMP)
{
  $connection=OpenConnection();
  $query="select * from FILE_CONTENT where SORT_ID=$SORT_ID_TMP";
  $cursor=exequery($connection,$query);

  $SORT_SIZE=0;
  while($ROW=mysql_fetch_array($cursor))
  {
    $SUBJECT=$ROW["SUBJECT"];
    $CONTENT=$ROW["CONTENT"];
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];

    $SORT_SIZE+=strlen($CONTENT)+strlen($SUBJECT);
    //--- 计算附件大小 ---
    $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
    $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

    $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
    for($I=0;$I<$ARRAY_COUNT-1;$I++)
    {
       $SORT_SIZE+=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
    }
  }

  //-- 递归计算子目录 --
  $query="select * from FILE_SORT where SORT_PARENT=$SORT_ID_TMP";
  $cursor=exequery($connection,$query);
  while($ROW=mysql_fetch_array($cursor))
  {
     $SORT_ID_TMP=$ROW["SORT_ID"];
     $SORT_SIZE+=tree_size($SORT_ID_TMP);
  }

  return $SORT_SIZE;
}

function tree_size_root()
{
  global $LOGIN_USER_ID;
  $connection=OpenConnection();
  $query="select * from FILE_CONTENT where SORT_ID=0 AND USER_ID='$LOGIN_USER_ID'";
  $cursor=exequery($connection,$query);

  $SORT_SIZE=0;
  while($ROW=mysql_fetch_array($cursor))
  {
    $SUBJECT=$ROW["SUBJECT"];
    $CONTENT=$ROW["CONTENT"];
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];

    $SORT_SIZE+=strlen($CONTENT)+strlen($SUBJECT);
    //--- 计算附件大小 ---
    $ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
    $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);

    $ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
    for($I=0;$I<$ARRAY_COUNT-1;$I++)
    {
       $SORT_SIZE+=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
    }
  }
  return $SORT_SIZE;
}


if($FOLDER_CAPACITY!=0)
{
   $USER_ID=$LOGIN_USER_ID;

   $CONTENT_COUNT=0;

   $query="select * from FILE_SORT where SORT_TYPE=4 and USER_ID='$USER_ID' and SORT_PARENT=0";
   $cursor=exequery($connection,$query);
   $SORT_SIZE=0;
   while($ROW=mysql_fetch_array($cursor))
   {
       $SORT_ID_TMP=$ROW["SORT_ID"];
       $SORT_SIZE+=tree_size($SORT_ID_TMP);
   }

   $SORT_SIZE+=tree_size_root();

   if($SORT_SIZE>$FOLDER_CAPACITY*1024*1024)
   {
      echo "<body class=\"bodycolor\" topmargin=\"5\"><br>";
      Message("警告","您的个人文件柜已超过容量限制($FOLDER_CAPACITY MB)，请清除您的无用文件！");
?>
<br>
<div align="center">
 <input type="button"  value="返回" class="BigButton" onClick="location='../folder.php?SORT_ID=<?=$SORT_ID?>&FILE_SORT=<?=$FILE_SORT?>';">
</div>
<?
      exit;
   }
}
?>

⌨️ 快捷键说明

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