[Sommaire] [Imprimer]

   1  <?php
   2  /*****************************************************
   3  * This file is part of Agora, web based content management system.
   4  *
   5  * Agora is free software; you can redistribute it and/or modify
   6  * it under the terms of the GNU General Public License as published by
   7  * the Free Software Foundation; version 2 of the License.
   8  *
   9  * Agora is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details (file "COPYING").
  13  *
  14  * Copyright © Arnaud Martin, Antoine Pitrou et Philippe Rivière.
  15  * List of authors detailed in "copyright_fr.html" file.
  16  * E-mail : agora@sig.premier-ministre.gouv.fr
  17  * Web site : http://www.agora.gouv.fr
  18  *****************************************************/
  19  if (defined("_BD_VISITEMYSQL")) return;
  20  define("_BD_VISITEMYSQL", "1");
  21  
  22  require_once dirname(__FILE__)."/../visite.php";
  23  
  24  /**
  25   * BD_visite_mysql is an fast implementation for MySQL of BD_visite business class.
  26   * @package    BD_mysql
  27   * @author     Erwan Le Bescond <elebescond@clever-age.com>
  28   * @author     Maciek Borowka <mborowka@clever-age.com>
  29   * @access    public
  30   */
  31  class BD_visite_mysql extends BD_visite {
  32  
  33      // {{{ addVisiteTemp($log_ip, $log_type, $log_id_num)
  34  
  35      function addVisiteTemp($log_ip, $log_type, $log_id_num) {
  36          @mysql_connect($this->_dbParameters->getDbHost(), $this->_dbParameters->getDbUser(), $this->_dbParameters->getDbPass());
  37          @mysql_select_db($this->_dbParameters->getDbName());
  38  
  39          $querySelect = "SELECT ip FROM ".$GLOBALS['table_prefix'].
  40              "_visites_temp WHERE ip='$log_ip' AND type='$log_type' AND id_objet=$log_id_num";
  41  
  42          $maDate = new Date();
  43  
  44          $queryInsert = 'INSERT INTO '.$GLOBALS['table_prefix'].'_visites_temp (ip, type, id_objet, maj) VALUES '.
  45                            "('$log_ip', '$log_type', $log_id_num,'".$maDate->getDate(DATE_FORMAT_ISO)."')";
  46  
  47          if (@($result = mysql_query($querySelect)))
  48          {
  49              if (mysql_num_rows($result) == 0)
  50              {
  51                  if (@($result = mysql_query($queryInsert)))
  52                  {
  53                      return true;
  54                  }
  55              }
  56          }
  57  
  58          return false;
  59      }
  60  
  61      // }}}
  62  }
  63  ?>
  64  
  65  
  66