osCommerce / oscommerce2

////

// Return true if the category has subcategories

// TABLES: categories

  function tep_has_category_subcategories($category_id) {

    $OSCOM_Db = Registry::get('Db');

    $Qcheck = $OSCOM_Db->prepare('select categories_id from :table_categories where parent_id = :parent_id limit 1');

    $Qcheck->bindInt(':parent_id', $category_id);

    $Qcheck->execute();

    return ($Qcheck->fetch() !== false);

  }

////

// Returns the address_format_id for the given country

////

// Check if product has attributes

  function tep_has_product_attributes($products_id) {

    $OSCOM_Db = Registry::get('Db');

    $Qattributes = $OSCOM_Db->prepare('select products_id from :table_products_attributes where products_id = :products_id limit 1');

    $Qattributes->bindInt(':products_id', $products_id);

    $Qattributes->execute();

    return $Qattributes->fetch() !== false;

  }

  function tep_count_modules($modules = '') {

    $count = 0;

////

// Checks to see if the currency code exists as a currency

// TABLES: currencies

  function tep_currency_exists($code) {

    $OSCOM_Db = Registry::get('Db');

    $Qcurrency = $OSCOM_Db->prepare('select code from :table_currencies where code = :code limit 1');

    $Qcurrency->bindValue(':code', $code);

    $Qcurrency->execute();

    if ($Qcurrency->fetch() !== false) {

      return $Qcurrency->value('code');

    }

    return false;

  }

////

// Parse and secure the cPath parameter values