public function subscriptions() { global $db; expHistory::set('manageable', $this->params); // make sure we have what we need. if (empty($this->params['key'])) { expQueue::flashAndFlow('error', 'The security key for account was not supplied.'); } if (empty($this->params['id'])) { expQueue::flashAndFlow('error', 'The subscriber id for account was not supplied.'); } // verify the id/key pair $sub = new subscribers($this->params['id']); if (empty($sub->id)) { expQueue::flashAndFlow('error', 'We could not find any subscriptions matching the ID and Key you provided.'); } // get this users subscriptions $subscriptions = $db->selectColumn('expeAlerts_subscribers', 'expeAlerts_id', 'subscribers_id=' . $sub->id); // get a list of all available E-Alerts $ealerts = new expeAlerts(); assign_to_template(array('subscriber' => $sub, 'subscriptions' => $subscriptions, 'ealerts' => $ealerts->find('all'))); }