PDA

View Full Version : Page Editor



michael_s
07-19-2007, 01:13 PM
The page box in the catalog is not displaying in the sort order. To fix this open includes/boxes/pages.php

line 7:
$page_query = tep_db_query("select pd.pages_title, pd.pages_body, p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order from " . TABLE_PAGES . " p, " . TABLE_PAGES_DESCRIPTION . " pd where p.pages_id = pd.pages_id and p.pages_status = '1' and pd.language_id = '" . (int)$languages_id . "' ");

replace it with:
$page_query = tep_db_query("select pd.pages_title, pd.pages_body, p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order from " . TABLE_PAGES . " p, " . TABLE_PAGES_DESCRIPTION . " pd where p.pages_id = pd.pages_id and p.pages_status = '1' and pd.language_id = '" . (int)$languages_id . "' order by p.sort_order");

Done!

Package is the same as above.

More... (http://www.oscommerce.com/community/contributions,2841)