devot:eeDevoted to ExpressionEngine

Pages to Tables

Pages to Tables takes the custom uri’s that you create with the pages module and places them in to their own database for easier access.

You simply query the table to get the information you need:

$query = $this->EE->db->query(“SELECT * FROM exp_ptt_site_pages”);

The pages module encodes and serializes the pages information which seems to complicate some things, so to make it easier to work with, we came up with this solution.  The way the data is store originally is like similar to this:

YToxOntpOjE7YTozOntzOjQ6InVyaXMiO2E6NTk2OntpOjIwO3M6MTE6Ii9lbXBsb3ltZW50IjtpOjIxO3M6MjM6Ii9lbXBsb3ltZW50L2FwcGxpY2F0aW9uIjtpOjIyO3M6MTc6Ii9jdXJyZW50LXN0dWRlbnRzIjtpOjIzO3M6MTQ6Ii9mYWN1bHR5LXN0YWZmIjtpOjM1O3M6Mjg6Ii9mYWN1bHR5LXN0YWZmL2NlbnRyYWwtc3RvcmUiO2k6MzY7czozODoiL2ZhY3VsdHktc3RhZmYvY2VudHJhbC1zdG9yZS9yZWNlaXZpbmciO2k6Mzc7czo0NToiL2ZhY3VsdHktc3RhZmYvY2VudHJhbC1zdG9yZS9zdXJwbHVzLXByb3BlcnR5IjtpOjM4O3M6NDI6Ii9mYWN1bHR5LXN0YWZmL2NlbnRyYWwtc3RvcmUvaW52b2ljZS1hdWRpdCI7aTozOTtzOjM5OiIvZmFjdWx0eS1zdGFmZi9jZW50cmFsLXN0b3JlL3B1cmNoYXNpbmciO2k6NDA7czo0MDoiL2ZhY3VsdHktc3RhZmYvY2VudHJhb

Which translates to:

Array
(
    [1] => Array
        (
            [uris] => Array
                (
                    [20] => /employment
                    [21] => /employment/application
                    [22] => /current-students
                    [23] => /faculty-staff
                    [35] => /faculty-staff/central-store
                    [36] => /faculty-staff/central-store/receiving
                    [37] => /faculty-staff/central-store/surplus-property
                    [38] => /faculty-staff/central-store/invoice-audit
                    [39] => /faculty-staff/central-store/purchasing

All this extension does is make it easier to get the data you would like from a database instead of a serialized and encoded array.

Installation

Upload the pages_to_tables folder to your expressionengine third_party folder.  After it’s uploaded, browse to your extensions directory and click ‘enable’.

Details

Hooks used: entry_submission_end

After every entry and update, the table is erased and rewritten.  This works with the pages module and structure, I haven’t tried anything else.