Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#1476 closed Bug/Fehler (fixed)

Content Manager Products Fix und Verbesserung

Reported by: flth@… Owned by: somebody
Priority: normal Milestone: modified-shop-2.0.5.0
Component: Admin Version: 2.0.4.0

Description

In der content_manager_products.php wirden der Artikelcontent überhaupt nicht sortiert. Daher mein Vorschlag:

löschen:

$products_id_query=xtc_db_query("SELECT DISTINCT
                                                   pc.products_id,
                                                   pd.products_name
                                              FROM ".TABLE_PRODUCTS_CONTENT." pc,
                                                   ".TABLE_PRODUCTS_DESCRIPTION." pd
                                             WHERE pd.products_id=pc.products_id
                                               AND pd.language_id='".(int)$_SESSION['languages_id']."'");

ersetzen mit:


 $products_id_query=xtc_db_query("SELECT DISTINCT
                                                   pc.products_id,
                                                   pd.products_name
                                              FROM ".TABLE_PRODUCTS_CONTENT." pc,
                                                   ".TABLE_PRODUCTS_DESCRIPTION." pd
                                             WHERE pd.products_id=pc.products_id
                                               AND pd.language_id='".(int)$_SESSION['languages_id']."'
                                                 ORDER BY products_name");

Außerdem wird in Zeile 65 (vor der Änderung) der $_GET Parameter überhaupt nicht geprüft. Sollte zumindest

(int)$_GET['pID']

sein. Besser wäre es auf PHP filter_input() zu gehen allgemein.

Attachments (0)

Change History (2)

comment:1 Changed 2 years ago by GTB

  • Resolution set to fixed
  • Status changed from new to closed

In 11280:

fix #1476

comment:2 Changed 2 years ago by Tomcraft

  • Milestone changed from modified-shop-2.0.4.1 to modified-shop-2.0.5.0

Add Comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.