[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * metatags-editing functions

   4   *

   5   * @package admin

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

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

   8   * @version $Id: functions_metatags.php 2844 2006-01-13 06:46:29Z drbyte $

   9   * @no-docs

  10   */
  11  
  12  /**

  13   * product-specific meta tags

  14   */
  15    function zen_get_metatags_title($product_id, $language_id) {
  16      global $db;
  17      $product = $db->Execute("select metatags_title
  18                               from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . "
  19                               where products_id = '" . (int)$product_id . "'
  20                               and language_id = '" . (int)$language_id . "'");
  21  
  22      return $product->fields['metatags_title'];
  23    }
  24  
  25    function zen_get_metatags_keywords($product_id, $language_id) {
  26      global $db;
  27      $product = $db->Execute("select metatags_keywords
  28                               from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . "
  29                               where products_id = '" . (int)$product_id . "'
  30                               and language_id = '" . (int)$language_id . "'");
  31  
  32      return $product->fields['metatags_keywords'];
  33    }
  34  
  35    function zen_get_metatags_description($product_id, $language_id) {
  36      global $db;
  37      $product = $db->Execute("select metatags_description
  38                               from " . TABLE_META_TAGS_PRODUCTS_DESCRIPTION . "
  39                               where products_id = '" . (int)$product_id . "'
  40                               and language_id = '" . (int)$language_id . "'");
  41  
  42      return $product->fields['metatags_description'];
  43    }
  44  
  45  /**

  46   * Category-specific metatags

  47   */
  48    function zen_get_category_metatags_title($category_id, $language_id) {
  49      global $db;
  50      $category = $db->Execute("select metatags_title
  51                                from " . TABLE_METATAGS_CATEGORIES_DESCRIPTION . "
  52                                where categories_id = '" . (int)$category_id . "'
  53                                and language_id = '" . (int)$language_id . "'");
  54  
  55      return $category->fields['metatags_title'];
  56    }
  57  
  58    function zen_get_category_metatags_description($category_id, $language_id) {
  59      global $db;
  60      $category = $db->Execute("select metatags_description
  61                                from " . TABLE_METATAGS_CATEGORIES_DESCRIPTION . "
  62                                where categories_id = '" . (int)$category_id . "'
  63                                and language_id = '" . (int)$language_id . "'");
  64  
  65      return $category->fields['metatags_description'];
  66    }
  67  
  68    function zen_get_category_metatags_keywords($category_id, $language_id) {
  69      global $db;
  70      $category = $db->Execute("select metatags_keywords
  71                                from " . TABLE_METATAGS_CATEGORIES_DESCRIPTION . "
  72                                where categories_id = '" . (int)$category_id . "'
  73                                and language_id = '" . (int)$language_id . "'");
  74  
  75      return $category->fields['metatags_keywords'];
  76    }
  77  
  78  /**

  79   *

  80   */
  81   
  82  ?>