From 3b8662d86663e6d854111f6cf20a534354530739 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 11 Nov 2013 21:29:42 +0000 Subject: [PATCH] Set member name into the page title Update commented out code and update for the new member database so we can grab the member name and put that into the page title tags. --- Toolkit/Template/PageControllerAbstract.php | 25 +++++---------------- 1 file changed, 5 insertions(+), 20 deletions(-) diff --git a/Toolkit/Template/PageControllerAbstract.php b/Toolkit/Template/PageControllerAbstract.php index dd06879..384f0b0 100644 --- a/Toolkit/Template/PageControllerAbstract.php +++ b/Toolkit/Template/PageControllerAbstract.php @@ -75,33 +75,18 @@ abstract class Toolkit_Template_PageControllerAbstract $this->registry->catid ); $glmPage->fetchPage(); - /* - if (isset($_GET['member_id']) && is_numeric($_GET['member_id'])) { + if ($memberId = filter_var($_REQUEST['member_id'], FILTER_VALIDATE_INT)) { // get member name and put in title $sql = " SELECT member_name FROM member - WHERE member_id = {$_GET['member_id']}"; - if ($memData = $toolbox->DB->db_auto_get_data($sql)) { - $member_name = htmlentities(strip_tags($memData[0]['member_name'])); - $glmPage->title = $member_name.' - '.$glmPage->title; + WHERE member_id = {$memberId}"; + if ($memberName = $this->registry->dbh->query($sql)->fetchColumn()) { + $member_name = htmlentities(strip_tags($memberName)); + $glmPage->pageTitle = $member_name.' - '.$glmPage->pageTitle; } } - if ($catid == HOME_ID && !$_POST) { - $sql = " - SELECT * - FROM bus_category - WHERE featured = true"; - $dbh = Toolkit_Database::getInstance(); - foreach ($dbh->query($sql) as $row) { - $row['link'] = $toolbox->get_seo_url($row['id']); - $glmPage->features[] = $row; - } - } - $glmPage->hasHeadlines = !empty($glmPage->features); - */ - $glmPage->topScripts = Toolkit_Common::getScripts($GLOBALS['topScripts']); $glmPage->bottomScripts = Toolkit_Common::getScripts($GLOBALS['bottomScripts']); $glmPage->styles = Toolkit_Common::getStyleSheets(); -- 2.17.1