Hallo fivebytes
in den beiden ADD_SELECT_SEARCH query aus der 99_advanced_search_result.php ist das DB Feld von mir eingetragen worden, oder meinst Du an anderer Stelle?
//build query
$select_str = "SELECT ".ADD_SELECT_SEARCH."
p.products_id,
p.products_ean,
p.products_quantity,
p.products_availability_ext,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_heading_title,
pd.products_short_description,
pd.products_description,
IFNULL(s.specials_new_products_price, p.products_price) AS price ";
Sowie
$listing_sql = "SELECT ".ADD_SELECT_SEARCH."
p.products_id,
p.products_ean,
p.products_quantity,
p.products_availability_ext,
p.products_shippingtime,
p.products_model,
p.products_image,
p.products_price,
p.products_weight,
p.products_tax_class_id,
p.products_fsk18,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name,
pd.products_heading_title,
pd.products_short_description,
pd.products_description,
IFNULL(s.specials_new_products_price, p.products_price) AS price
Vielen Dank!
Felix
EDIT: Nachtrag, ich hab den {debug} für die Seite auch eingeschaltet, das Feld taucht in der Smarty abfrage auf, gibt jedoch "NULL" zurück obwohl in dem Fall defintiv eine "1" drin steht.
$module_content
Origin: "Smarty object"
Value
Array (1)
0 => Array (50)
PRODUCTS_MANUFACTURERS_MODEL => ""
PRODUCTS_BULK => "0.00"
PRODUCTS_ID => "15707"
PRODUCTS_EAN => "3279510808995"
PRODUCTS_QUANTITY => "0"
PRODUCTS_AVAILABILITY_EXT => null