Hat man auf einer Datenbank mehrere Shops (mit Prefix) bekommt man Probleme, da ein Teil von stock.php hardcodet ist:

find:
$q=tep_db_query($sql="select products_name,products_options_name as _option,products_attributes.options_id as _option_id,products_options_values_name as _value,products_attributes.options_values_id as _value_id from ".
"products_description, products_attributes,products_options,products_opti ons_values where ".
"products_attributes.products_id=products_descript ion.products_id and ".
"products_attributes.products_id=" . (int)$VARS['product_id'] . " and ".
"products_attributes.options_id=products_options.p roducts_options_id and ".
"products_attributes.options_values_id=products_op tions_values.products_options_values_id and ".
"products_description.language_id=" . (int)$languages_id . " and ".
"products_options_values.language_id=" . (int)$languages_id . " and products_options.products_options_track_stock=1 and ".
"products_options.language_id=" . (int)$languages_id . " order by products_attributes.options_id, products_attributes.options_values_id");
//list($product_name,$option_name,$option_id,$value, $value_id)


correct :
$q=tep_db_query($sql="select products_name,products_options_name as _option,".TABLE_PRODUCTS_ATTRIBUTES.".options_id as _option_id,products_options_values_name as _value,".TABLE_PRODUCTS_ATTRIBUTES.".options_value s_id as _value_id
from ".TABLE_PRODUCTS_DESCRIPTION.",". TABLE_PRODUCTS_ATTRIBUTES.",".TABLE_PRODUCTS_OPTIO NS.",".TABLE_PRODUCTS_OPTIONS_VALUES."
where ".TABLE_PRODUCTS_ATTRIBUTES.".products_id = ".TABLE_PRODUCTS_DESCRIPTION.".products_id
and ".TABLE_PRODUCTS_ATTRIBUTES.".products_id =" . (int)$VARS['product_id'] . "
and ".TABLE_PRODUCTS_ATTRIBUTES.".options_id = ".TABLE_PRODUCTS_OPTIONS.".products_options_id
and ".TABLE_PRODUCTS_ATTRIBUTES.".options_values_i d = ".TABLE_PRODUCTS_OPTIONS_VALUES.".products_options _values_id
and ".TABLE_PRODUCTS_DESCRIPTION.".language_id=" . (int)$languages_id . "
and ".TABLE_PRODUCTS_OPTIONS_VALUES.".language_id= " . (int)$languages_id . "
and ".TABLE_PRODUCTS_OPTIONS.".products_options_track_ stock=1
and ".TABLE_PRODUCTS_OPTIONS.".language_id=" . (int)$languages_id . "
order by ".TABLE_PRODUCTS_ATTRIBUTES.".options_id, ".TABLE_PRODUCTS_ATTRIBUTES.".options_values_i d");
//list($product_name,$option_name,$option_id,$value, $value_id)

More...