Projekt

Allgemein

Profil

Revision 5

Unterschiede anzeigen:

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