They are store in exp_sites in the site_pages column, in a base64 encoded serialized array:
$this->EE->db->select('site_pages')
->where('site_id', $this->EE->config->item('site_id');
$query = $this->EE->db->get('sites');
$site_pages = unserialize(base64_decode($query->row('site_pages')));
print_r($site_pages);Array
(
[uris] => Array
(
[207] => /my/pages/uri/
)
[templates] => Array
(
[207] => 2
)
)Thanks, Rob and Erik.
What I’m attempting to do is this: Given that I have the ‘page_uri’ (only), I need to grab the contents of a particular field displayed on this page and then output it in a template.
Either of you know how I might get the ‘entry_id’ of a page whose ‘page_uri’ I have? With that, I could find the field’s contents.
TIA
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.