[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * counter.php

   4   *

   5   * @package general

   6   * @copyright Copyright 2003-2006 Zen Cart Development Team

   7   * @copyright Portions Copyright 2003 osCommerce

   8   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   9   * @version $Id: counter.php 3194 2006-03-15 23:17:53Z wilt $

  10   * @private

  11   */
  12  if (!defined('IS_ADMIN_FLAG')) {
  13    die('Illegal Access');
  14  }
  15  if (isset($_SESSION['session_counter']) && $_SESSION['session_counter'] == true) {
  16    $session_counter = 0;
  17  } else {
  18    $session_counter = 1;
  19    $_SESSION['session_counter'] = true;
  20  }
  21  $date_now = date('Ymd');
  22  $counter_query = "select startdate, counter, session_counter from " . TABLE_COUNTER_HISTORY . " where startdate='" . $date_now . "'";
  23  $counter = $db->Execute($counter_query);
  24  if ($counter->RecordCount() <= 0) {
  25    $date_now = date('Ymd');
  26    $sql = "insert into " . TABLE_COUNTER_HISTORY . " (startdate, counter, session_counter) values ('" . $date_now . "', '1', '1')";
  27    $db->Execute($sql);
  28    $counter_startdate = $date_now;
  29    $counter_now = 1;
  30  } else {
  31    $counter_startdate = $counter->fields['startdate'];
  32    $counter_now = ($counter->fields['counter'] + 1);
  33    $session_counter_now = ($counter->fields['session_counter'] + $session_counter);
  34    $sql = "update " . TABLE_COUNTER_HISTORY . " set counter = '" . $counter_now . "', session_counter ='" . $session_counter_now . "' where startdate='" . $date_now . "'";
  35    $db->Execute($sql);
  36  }
  37  
  38  $counter_query = "select startdate, counter from " . TABLE_COUNTER;
  39  $counter = $db->Execute($counter_query);
  40  if ($counter->RecordCount() <= 0) {
  41    $date_now = date('Ymd');
  42    $sql = "insert into " . TABLE_COUNTER . " (startdate, counter) values ('" . $date_now . "', '1')";
  43    $db->Execute($sql);
  44    $counter_startdate = $date_now;
  45    $counter_now = 1;
  46  } else {
  47    $counter_startdate = $counter->fields['startdate'];
  48    $counter_now = ($counter->fields['counter'] + 1);
  49    $sql = "update " . TABLE_COUNTER . " set counter = '" . $counter_now . "'";
  50    $db->Execute($sql);
  51  }
  52  
  53  $counter_startdate_formatted = strftime(DATE_FORMAT_LONG, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4)));
  54  ?>