am: 15. Mai 2013, 13:22:32
Hallo,
Hab bei mir eine Hersteller sortierung eingebaut.
Datenbank backup nicht vergessen!!
Im Datenbank ausführen
ALTER TABLE manufacturers ADD manufacturers_sort varchar(64)
admin/manufacturers.php
nach ca. Zeile 22
$manufacturers_id = xtc_db_prepare_input($_GET['mID']);
$manufacturers_name = xtc_db_prepare_input($_POST['manufacturers_name']);
einfügen
$manufacturers_sort = xtc_db_prepare_input($_POST['manufacturers_sort']);
nach ca. Zeile 27
$sql_data_array = array('manufacturers_name' => $manufacturers_name); einfügen
$sql_data_array = array('manufacturers_sort' => $manufacturers_sort); ca. Zeile 152
$manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
ändern in
$manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified, manufacturers_sort from " . TABLE_MANUFACTURERS . " order by manufacturers_sort ASC";
vor der Zeile ca. 217
$contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_URL
. $manufacturer_inputs_string); einfügen
//SORT $contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_SORT
. '<br />' . xtc_draw_input_field
('manufacturers_sort', $mInfo->manufacturers_sort)); vor der Zeile ca. 235
$contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_URL
. $manufacturer_inputs_string); einfügen
//SORT $contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_SORT
. '<br />' . xtc_draw_input_field
('manufacturers_sort', $mInfo->manufacturers_sort)); vor der Zeile ca. 235
$contents[] = array('align' => 'center', 'text' => '<br />' . xtc_button
(BUTTON_DELETE
) . ' ' . xtc_button_link
(BUTTON_CANCEL
, xtc_href_link
(FILENAME_MANUFACTURERS
, 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id))); einfügen
//SORT $contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_SORT
. '<br />' . xtc_draw_input_field
('manufacturers_sort', $mInfo->manufacturers_sort)); Hoffe hab nichts vergessen
Ach ja getestet in v1.06
Linkback: https://www.modified-shop.org/forum/index.php?topic=26186.0