Revision 5
includes/extra/default/listing_sql/category_keywords.php | ||
---|---|---|
43 | 43 |
} |
44 | 44 |
if($where_str_cat != " ( "){ |
45 | 45 |
$where_str_cat = substr($where_str_cat, 0, strlen($where_str_cat)-3); |
46 |
$where_str_cat .= " ) "; |
|
47 |
$listing_sql_categories = "Select * from ".TABLE_CATEGORIES." c LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd on c.categories_id = cd.categories_id where $where_str_cat AND cd.language_id = '".(int)$_SESSION['languages_id']."'";
|
|
46 |
$where_str_cat .= " ) ";
|
|
47 |
$listing_sql_categories = "Select * from ".TABLE_CATEGORIES." c LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd on c.categories_id = cd.categories_id where $where_str_cat AND cd.language_id = '".(int)$_SESSION['languages_id']."' AND c.categories_status = '1' " .CATEGORIES_CONDITIONS_C;
|
|
48 | 48 |
$categories_query = xtc_db_query($listing_sql_categories); |
49 | 49 |
$categories_keyword_content = array(); |
50 | 50 |
$arr_categories_affected = array(); |
Auch abrufbar als: Unified diff