<?php
/* --------------------------------------------------------------
xtc_get_attributes_model.inc.php 2022-08-04
Gambio GmbH
http://www.gambio.de
Copyright (c) 2022 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
--------------------------------------------------------------
based on:
(c) 2003 nextcommerce (xtc_get_attributes_model.inc.php,v 1.1 2003/08/19); www.nextcommerce.org
(c) 2003 XT-Commerce - community made shopping http://www.xt-commerce.com ($Id: xtc_get_attributes_model.inc.php 899 2005-04-29 02:40:57Z hhgag $)
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
function xtc_get_attributes_model($product_id, $attribute_name,$options_name,$language='')
{
if ($language=='') $language=$_SESSION['languages_id'];
$options_value_id_query=xtc_db_query("SELECT
pa.attributes_model
FROM
".TABLE_PRODUCTS_ATTRIBUTES." pa
Inner Join ".TABLE_PRODUCTS_OPTIONS." po ON po.products_options_id = pa.options_id
Inner Join ".TABLE_PRODUCTS_OPTIONS_VALUES." pov ON pa.options_values_id = pov.products_options_values_id
WHERE
pa.products_id = '".(int)$product_id."' AND
po.language_id = '".(int)$language."' AND
po.products_options_name = '". xtc_db_input($options_name)."' AND
pov.language_id = '".(int)$language."' AND
pov.products_options_values_name = '".xtc_db_input($attribute_name)."'");
$options_attr_data = xtc_db_fetch_array($options_value_id_query);
return ($options_attr_data['attributes_model'] ?? '');
}
?>