Kaelon
07-26-2005, 06:27 PM
The "display order" (configurable via AdminCP > vBa CMPS > Edit Pages) is meaningless because the query does not sort by any field (so, it is sorted by relative position of entry in the database). To correct...
In forum/modules/navigation.php, find:
$getpages = $db->query_read("SELECT pageid, title, name, parentid, userperms FROM " . TABLE_PREFIX . "adv_pages WHERE active = 1");
REPLACE WITH:
$getpages = $db->query_read("SELECT pageid, title, name, parentid, userperms FROM " . TABLE_PREFIX . "adv_pages WHERE active = 1 ORDER BY displayorder");
In forum/modules/navigation.php, find:
$getpages = $db->query_read("SELECT pageid, title, name, parentid, userperms FROM " . TABLE_PREFIX . "adv_pages WHERE active = 1");
REPLACE WITH:
$getpages = $db->query_read("SELECT pageid, title, name, parentid, userperms FROM " . TABLE_PREFIX . "adv_pages WHERE active = 1 ORDER BY displayorder");