<?php
/* --------------------------------------------------------------
xtc_get_products_stock.inc.php 2012-09-21 gm
Gambio GmbH
http://www.gambio.de
Copyright (c) 2012 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
--------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(general.php,v 1.225 2003/05/29); www.oscommerce.com
(c) 2003 nextcommerce (xtc_get_products_stock.inc.php,v 1.3 2003/08/13); www.nextcommerce.org
(c) 2003 XT-Commerce - community made shopping http://www.xt-commerce.com ($Id: xtc_get_products_stock.inc.php 1009 2005-07-11 16:19:29Z mz $)
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
function xtc_get_products_stock($products_id)
{
$products_id = xtc_get_prid($products_id);
$c_products_id = (int)$products_id;
$t_stock = 0;
$t_sql = "SELECT products_quantity FROM " . TABLE_PRODUCTS . " p WHERE products_id = '" . $c_products_id . "'";
$t_result = xtc_db_query($t_sql);
if(xtc_db_num_rows($t_result) == 1)
{
$t_result_array = xtc_db_fetch_array($t_result);
$t_stock = (double)$t_result_array['products_quantity'];
}
return $t_stock;
}
?>