Remove dependency on MySQL/MariaDB CREATE PROCEDURE permission

[Deltik]

Problem

On Wednesday, 24 January 2018, @CaMer0n asked me:

Good morning! I was wondering if you would mind taking a look at this issue?

In e107_handlers/admin_ui.php is a method: getParentChildQry(). It uses custom MySQL functions to sort by parent/child fields of the table taking into account the 'order' field of the table.

I talked to one of the users about trying to do this is PHP alone to remove this need for mysql-function permissions. Here is his pull-request: #2929

Unfortunately, it didn't work correctly. The best test case is to use the vstore plugin and add some multi-level categories in the admin area.

If you don't have time, I completely understand - please feel no obligation. Just thought you might have the skills to solve this one.

The task is to port the custom MySQL/MariaDB functions getDepth() and getTreeSort() to pure PHP so that e107 will no longer be dependent on the CREATE PROCEDURE permission in MySQL/MariaDB.

Screenshot of Expected Behavior