function user_badges_get_product_list in User Badges 5

Get list of all ecommerce products

1 call to user_badges_get_product_list()

user_badges_products_page in ./user_badges.module

File

./user_badges.module, line 928

@brief User Badges module file

Code

function user_badges_get_product_list() {
  $products = array();
  $sql = db_query('SELECT p.*, n.title FROM {ec_product} p INNER JOIN {node} n ON p.nid = n.nid ORDER BY sku');
  while ($row = db_fetch_object($sql)) {
    $products[$row->nid] = $row;
  }
  return $products;
}