[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_plugins/pm/pm_func.php,v $
  14  |     $Revision: 1.2 $
  15  |     $Date: 2005/12/14 19:28:52 $
  16  |     $Author: sweetas $
  17  +----------------------------------------------------------------------------+
  18  */
  19  if (!defined('e107_INIT')) { exit; }
  20  
  21  function pm_getInfo($which = "inbox")
  22  {
  23      static $pm_info;
  24      global $sql, $pref, $pm_prefs;
  25      if('clear' == $which)
  26      {
  27          unset($pm_info['inbox']);
  28          unset($pm_info['outbox']);
  29      }
  30      if('inbox' == $which)
  31      {
  32          $qry = "SELECT count(pm.pm_id) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM #private_msg as pm WHERE pm.pm_to = ".USERID." AND pm.pm_read_del = 0";
  33      }
  34      else
  35      {
  36          $qry = "SELECT count(pm.pm_from) AS total, SUM(pm.pm_size)/1024 size, SUM(pm.pm_read = 0) as unread FROM #private_msg as pm WHERE pm.pm_from = ".USERID." AND pm.pm_sent_del = 0";
  37      }
  38      if(!isset($pm_info[$which]['total']))
  39      {
  40          $sql->db_Select_gen($qry);
  41          $pm_info[$which] = $sql->db_Fetch();
  42          if($which == 'inbox' && $pm_prefs['animate'] == 1 || $pm_prefs['popup'] == 1)
  43          {
  44              if($new = $sql->db_Count("private_msg", "(*)", "WHERE pm_sent > '.USERLV.' AND pm_read = 0 AND pm_to = '".USERID."' AND pm_read_del != 1"))
  45              {
  46                  $pm_info['inbox']['new'] = $new;
  47              }
  48          }
  49      }
  50      if(!isset($pm_info[$which]['limit']))
  51      {
  52          if($pref['pm_limits'] > 0)
  53          {
  54              if($pref['pm_limits'] == 1)
  55              {
  56                  $qry = "SELECT MAX(gen_user_id) AS inbox_limit, MAX(gen_ip) as outbox_limit FROM #generic WHERE gen_type='pm_limit' AND gen_datestamp IN (".USERCLASS_LIST.")";
  57              }
  58              else
  59              {
  60                  $qry = "SELECT MAX(gen_intdata) AS inbox_limit, MAX(gen_chardata) as outbox_limit FROM #generic WHERE gen_type='pm_limit' AND gen_datestamp IN (".USERCLASS_LIST.")";
  61              }
  62              if($sql->db_Select_gen($qry))
  63              {
  64                  $row = $sql->db_Fetch();
  65                  $pm_info['inbox']['limit'] =  $row['inbox_limit'];
  66                  $pm_info['outbox']['limit'] =  $row['outbox_limit'];
  67              }
  68              $pm_info['inbox']['limit_val'] = ($pref['pm_limits'] == 1 ? $pm_info['inbox']['total'] : $pm_info['inbox']['size']);
  69              if(!$pm_info['inbox']['limit'] || !$pm_info['inbox']['limit_val'])
  70              {
  71                  $pm_info['inbox']['filled'] = 0;
  72              }
  73              else
  74              {
  75                  $pm_info['inbox']['filled'] = number_format($pm_info['inbox']['limit_val']/$pm_info['inbox']['limit'] * 100, 2);
  76              }
  77              $pm_info['outbox']['limit_val'] = ($pref['pm_limits'] == 1 ? $pm_info['outbox']['total'] : $pm_info['outbox']['size']);
  78              if(!$pm_info['outbox']['limit'] || !$pm_info['outbox']['limit_val'])
  79              {
  80                  $pm_info['outbox']['filled'] = 0;
  81              }
  82              else
  83              {
  84                  $pm_info['outbox']['filled'] = number_format($pm_info['outbox']['limit_val']/$pm_info['outbox']['limit'] * 100, 2);
  85              }
  86          }
  87          else
  88          {
  89              $pm_info['inbox']['limit'] = "";
  90              $pm_info['outbox']['limit'] = "";
  91              $pm_info['inbox']['filled'] = "";
  92              $pm_info['outbox']['filled'] = "";
  93          }
  94      }
  95      return $pm_info;
  96  }
  97  ?>