in the page builder in admin panel pages are not alphabetical

When you are editing pages in the builder section of the admin panel, the pages are not listed in alpha order, this makes it easier for ME to find them.

 

in the file inc/classes/BxDolPageViewAdmin.php

around line 416 find

function getPages() {

$sPagesQuery = "SELECT `Name`, `Title` FROM `{$this -> sDBTable}_pages` ORDER BY `Order`";

 

CHANGE THE $sPagesQuery TO READ

 

$sPagesQuery = "SELECT `Name`, `Title` FROM `{$this -> sDBTable}_pages` ORDER BY `Title` ASC";

Now where you click the pages select, they are in alpha order!
http://www.mytikibar.com
Quote · 9 Oct 2011

Thank you for making it easier

Quote · 9 Oct 2011

Thanks for sharing

...........................................
Quote · 10 Oct 2011

This doesn't work in 7.0.9 does anyone know how to fix this?

Quote · 23 Apr 2012

 verified as working:

This doesn't work in 7.0.9 does anyone know how to fix this?

 707-Dolphin Ascending Page Builder Ordrer

Pre-Asc-Hack Provided by DosDawg

 

Post ASC Hack on page builders title order

707-asc-hack.png · 11.3K · 285 views
pre-asc-hack.png · 10.7K · 284 views
post-asc-hack.png · 11.1K · 263 views
When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 23 Apr 2012

 good work steve, you posted this hack nearly a year ago, and its still working. 

When you are editing pages in the builder section of the admin panel, the pages are not listed in alpha order, this makes it easier for ME to find them.

 

in the file inc/classes/BxDolPageViewAdmin.php

around line 416 find

function getPages() {

$sPagesQuery = "SELECT `Name`, `Title` FROM `{$this -> sDBTable}_pages` ORDER BY `Order`";

 

CHANGE THE $sPagesQuery TO READ

 

$sPagesQuery = "SELECT `Name`, `Title` FROM `{$this -> sDBTable}_pages` ORDER BY `Title` ASC";

Now where you click the pages select, they are in alpha order!

 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 23 Apr 2012

Sometimes I do good things with dolphin.  LOL!

http://www.mytikibar.com
Quote · 24 Apr 2012

Do you think it would be safe to edit the  Title  column in sys_page_compose_pages ?

Some of the titles are ambiguous... for example, I have a title simply stating "Search" when it should be "Docs Search" (for the document module).

http://pkforum.dolphinhelp.com
Quote · 24 Apr 2012

Okay I tried this again and yes it does work.

Quote · 7 May 2012

Would something similar be applicable to displaying Groups?

The newest->oldest is weird.

Alpha makes better sense.

Of course, the best would be drag-drop arrange, but...

Quote · 25 Jun 2012

I have actually gone thru quite of a bit of the database stuff and add the ORDER BY parameter to a LOT of things.

I've even gone so far as to order your friends list in the mail application by alpha.

One of the things I've been playing with is sorting by avatar 1st, then alpha.

Or even sorting by last visit alpha per visit date.

I am just a logical orderly person and need things in an order to make sense. 

Just run down any code that reads from the database and make sure you modify the ORDER BY.

http://www.mytikibar.com
Quote · 25 Jun 2012

Thanks Steve.. it is avery helpful hack :-)

I tried doing an Ordering for the Inactive and Sample items, but it didn't quite work out ....

 function loadInactiveBlocks() {
  //get inactive blocks and samples
  $sQueryInactive = "
   SELECT
    `ID`,
    `Caption`
   FROM `{$this -> oParent -> sDBTable}`
   WHERE
    `Page` = '{$this -> sName_db}' AND
    `Column` = 0
    ORDER BY 'Caption'
  ";
  
  $sQuerySamples = "
   SELECT
    `ID`,
    `Caption`
   FROM `{$this -> oParent -> sDBTable}`
   WHERE
    `Func` = 'Sample'
    ORDER BY 'Caption'
  ";

 

the Navigation Menu area in the Admin gets very cluttered and takes a while for one to search through the Items.... and the same in the Page Blocks too..

Any modfications you have done in these areas ? If so, pls share... Much Thanks :-)

"May the Power of the Open-Source be with You" - The Jedi
Quote · 5 Aug 2012

Works perfectly for 7.1.2 - thanks again for posting a solution.

Quote · 3 Jun 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.