Hallo!
Habe versucht all_products einzubauen.
Funktioniert aber nicht da ein Fehler kommt:
Code
1054 - Unknown column 'p.manufacturers_id' in 'on clause'select distinct p.products_id, p.products_fsk18, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p, categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name ASC[XT SQL Error]Ich denke dass es an der DB Abfrage liegt, da ich mich aber nicht gut auskenne hier mal die all_products.php
PHP
<?php
/* -----------------------------------------------------------------------------------------
$Id: all_products.php,v 1.00 2004/06/21 20:00:00 Sascha Exp $
Alle Produkte - Contribution for XT-Commerce http://www.xt-commerce.com
by Sascha Neurath - http://www.gebaeudereiniger-einkauf.de - http://www.reinigungsbedarf24.de
Copyright (c) 2004 Sascha Neurath - http://www.gebaeudereiniger-einkauf.de - http://www.reinigungsbedarf24.de
---------------------------------------------------------------------------------------*/
include( 'includes/application_top.php');
$smarty = new Smarty;
require(DIR_FS_CATALOG .'templates/'.CURRENT_TEMPLATE. '/source/boxes.php');
$breadcrumb->add(NAVBAR_TITLE_ALL_PRODUCTS, xtc_href_link(FILENAME_ALL_PRODUCTS));
require(DIR_WS_INCLUDES . 'header.php');
$all_products_array = array();
$fsk_lock='';
if ($_SESSION['customers_status']['customers_fsk18_display']=='0') {
$fsk_lock=' and p.products_fsk18!=1';
}
if (GROUP_CHECK=='true') {
$group_check="and p.group_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";
}
$all_products_query_raw = "select distinct
p.products_id,
p.products_fsk18,
pd.products_name,
p.products_image,
p.products_price,
p.products_tax_class_id,
p.products_date_added,
m.manufacturers_name
from " . TABLE_PRODUCTS . " p,
" . TABLE_CATEGORIES . " c,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
<B> left join " . TABLE_MANUFACTURERS . " m
on p.manufacturers_id = m.manufacturers_id</b>
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd
on p.products_id = pd.products_id ".$fsk_lock."
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
where c.categories_status=1
and p.products_id = p2c.products_id
and c.categories_id = p2c.categories_id
and products_status = '1'
".$group_check."
order
by
pd.products_name ASC";
$all_products_split = new splitPageResults($all_products_query_raw, $_GET['page'], 100,'p.products_id');
if (($all_products_split->number_of_rows > 0)) {
$smarty->assign('NAVIGATION_BAR','
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText">'.$all_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS).'</td>
<td align="right" class="smallText">'.TEXT_RESULT_PAGE . ' ' . $all_products_split->display_links(MAX_DISPLAY_PAGE_LINKS, xtc_get_all_get_params(array('page', 'info', 'x', 'y'))).'</td>
</tr>
</table>
');
}
$module_content='';
if ($all_products_split->number_of_rows > 0) {
$all_products_query = xtc_db_query($all_products_split->sql_query);
while ($all_products = xtc_db_fetch_array($all_products_query)) {
if (xtc_not_null($all_products['specials_new_products_price'])) {
$products_price = xtc_get_products_price($all_products['products_id'], $price_special=1, $quantity=1);
} else {
$products_price = xtc_get_products_price($all_products['products_id'], $price_special=1, $quantity=1);
}
$all_products['products_name'] = xtc_get_products_name($all_products['products_id']);
$module_content[]=array(
'PRODUCTS_NAME' => $all_products['products_name'],
'PRODUCTS_PRICE' => xtc_get_products_price($all_products['products_id'],$price_special=1,$quantity=1),
'PRODUCTS_LINK' => xtc_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $all_products['products_id']));
}
} else {
$smarty->assign('ERROR',TEXT_NO_NEW_PRODUCTS);
}
$smarty->assign('language', $_SESSION['language']);
$smarty->caching = 0;
$smarty->assign('module_content',$module_content);
$main_content=$smarty->fetch(CURRENT_TEMPLATE . '/module/all_products.html');
$smarty->assign('main_content',$main_content);
$smarty->assign('language', $_SESSION['language']);
$smarty->caching = 0;
$smarty->display(CURRENT_TEMPLATE . '/index.html');
?>