osCommerce / oscommerce2

////

// Return a product's name

// TABLES: products

  function tep_get_products_name($product_id, $language = '') {

    global $languages_id;

    if (empty($language)) $language = $languages_id;

    $product_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language . "'");

    $product = tep_db_fetch_array($product_query);

    return $product['products_name'];

  }

////

// Return a product's special price (returns nothing if there is no offer)

  // Description : Function to retrieve the state/province code (as in FL for Florida etc)

  //

  ////////////////////////////////////////////////////////////////////////////////////////////////

  function tep_get_zone_code($country, $zone, $def_state) {

    $state_prov_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and zone_id = '" . (int)$zone . "'");

    if (!tep_db_num_rows($state_prov_query)) {

      $state_prov_code = $def_state;

    }

    else {

      $state_prov_values = tep_db_fetch_array($state_prov_query);

      $state_prov_code = $state_prov_values['zone_code'];

    }

    return $state_prov_code;

  }

  function tep_get_uprid($prid, $params) {

    $uprid = $prid;

    return $category['categories_name'];

  }

  function tep_get_orders_status_name($orders_status_id, $language_id = '') {

    global $languages_id;

    if (!$language_id) $language_id = $languages_id;

    $orders_status_query = tep_db_query("select orders_status_name from " . TABLE_ORDERS_STATUS . " where orders_status_id = '" . (int)$orders_status_id . "' and language_id = '" . (int)$language_id . "'");

    $orders_status = tep_db_fetch_array($orders_status_query);

    return $orders_status['orders_status_name'];

  }

  function tep_get_orders_status() {

    global $languages_id;

    return $orders_status_array;

  }

  function tep_get_products_name($product_id, $language_id = 0) {

    global $languages_id;

    if ($language_id == 0) $language_id = $languages_id;

    $product_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");

    $product = tep_db_fetch_array($product_query);

    return $product['products_name'];

  }

  function tep_get_products_description($product_id, $language_id) {

    $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");