Pages to Table

Developer

Nicholas Cheek

3rd Party (Free)

Open Software License 3.0

Download v1.0.1

EE Version Support

  • ExpressionEngine 2

Compatibility

If an item is crossed out, it might be untested, not applicable or incompatible. Contact the developer to be sure.

  • Updater
  • Multi Site Manager
  • Stand Alone Entry Form
  • Low Variables
  • Content Elements
  • Better Workflow
  • Matrix
  • Grid
  • Webservice
  • Publisher

Requirements

  • jQuery for the Control Panel

Add-On Type(s)

Extension

Tags

Takes your serialized and encoded pages URI and combines the page id and page title in a seperate table to make that information easier to use. This extends the Pages and Structure Module.

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.

Download Pages to Table

EE Support Downloads Add-On Version Release Date
Not Specified Download 1.0.1 Aug 22, 2013

Hooks Used

If the add-on is an extension, and ties into ExpressionEngine's core files, it will use ExpressionEngine hooks. We are listing any hooks the add-on uses for developers to have an easier time locating other add-ons that they can reference for their own work.

  1. entry_submission_end

This entry was created August 22, 2013, 1:05 pm.
This entry was last updated August 22, 2013, 1:50 pm.

Disclaimer: Information about ExpressionEngine add-ons is provided as a service to you, the user, and every member of the ExpressionEngine community. devot:ee is not responsible if you hose, mangle, wreck, or otherwise destroy your EE website by installing an add-on that you found out about at this site, regardless of its rating, Favorites status, commercial or free status, or general popularity. Caveat EEmptor!

Returns: devot:ee has a 30-day return policy on all commercial add-ons sold through devot-ee.com. If you need to return an add-on, do not go to the developer or the developer's site, but rather visit our returns page at https://devot-ee.com/returns to initiate your return. If you have questions, email support@devot-ee.com.

There are no reviews for this add-on yet.

What are you waiting for? Rate it and review it!