[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  // Base class for Referer business persistence abstraction.
  20  //
  21  
  22  
  23  if (defined("_BD_REFERERMYSQL")) return;
  24  define("_BD_REFERERMYSQL", "1");
  25  
  26  require_once dirname(__FILE__)."/../referer.php";
  27  
  28  /**
  29   * BD_referer_mysql is an implementation for MySQL of BD_referer business class.
  30   * @package    BD_mysql
  31   * @author     Erwan Le Bescond <elebescond@clever-age.com>
  32   * @author     Maciek Borowka <mborowka@clever-age.com>
  33   * @access    public
  34   */
  35  class BD_referer_mysql extends BD_referer {
  36  
  37      // {{{ addRefererTemp($log_ip, $log_referer, $referer_md5, $log_type, $log_id_num)
  38  
  39      function addRefererTemp($log_ip, $log_referer, $referer_md5, $log_type, $log_id_num) {
  40          @mysql_connect($this->_dbParameters->getDbHost(), $this->_dbParameters->getDbUser(), $this->_dbParameters->getDbPass());
  41          @mysql_select_db($this->_dbParameters->getDbName());
  42  
  43          $querySelect = 'SELECT ip, referer_md5, type_referer, id_objet FROM '.$GLOBALS['table_prefix']
  44              .'_referers_temp WHERE ip=\'' . $log_ip . '\' AND referer_md5=\'' . $referer_md5 . '\' AND type_referer=\''.$log_type.'\' AND id_objet=' . $log_id_num;
  45  
  46          $queryInsert = 'INSERT INTO '.$GLOBALS['table_prefix'].
  47              '_referers_temp (ip, referer, referer_md5, type_referer, id_objet) VALUES (\''.
  48                  $log_ip.'\', \''.$log_referer.'\', \''.$referer_md5.'\', \''.$log_type.'\', '.$log_id_num.
  49              ')';
  50  
  51          if (@($result = mysql_query($querySelect)))
  52          {
  53              if (mysql_num_rows($result) == 0)
  54              {
  55                  if (@($result = mysql_query($queryInsert)))
  56                  {
  57                      return true;
  58                  }
  59              }
  60          }
  61  
  62          return false;
  63      }
  64  
  65      // }}}
  66  
  67  }
  68  ?>
  69  
  70  
  71