X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Ffeatureduserssection.php;h=1b0718a05f5a8462592bafcb56f84399ae038808;hb=a45cdae0831ad036a85ac4f5f815c771e137e1c5;hp=aed94b1a555e845b36c7fd23513fd90b0a9756cc;hpb=bab3e1b8586f42bc1f0a5f96b6990d67c6b74446;p=quix0rs-gnu-social.git diff --git a/lib/featureduserssection.php b/lib/featureduserssection.php index aed94b1a55..1b0718a05f 100644 --- a/lib/featureduserssection.php +++ b/lib/featureduserssection.php @@ -1,6 +1,6 @@ . * * @category Widget - * @package Laconica - * @author Evan Prodromou - * @copyright 2009 Control Yourself, Inc. + * @package StatusNet + * @author Evan Prodromou + * @copyright 2009 StatusNet, Inc. * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html GNU Affero General Public License version 3.0 - * @link http://laconi.ca/ + * @link http://status.net/ */ -if (!defined('LACONICA')) { +if (!defined('STATUSNET') && !defined('LACONICA')) { exit(1); } @@ -35,14 +35,22 @@ if (!defined('LACONICA')) { * Section for featured users * * @category Widget - * @package Laconica - * @author Evan Prodromou + * @package StatusNet + * @author Evan Prodromou * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html GNU Affero General Public License version 3.0 - * @link http://laconi.ca/ + * @link http://status.net/ */ - class FeaturedUsersSection extends ProfileSection { + function show() + { + $featured_nicks = common_config('nickname', 'featured'); + if (empty($featured_nicks)) { + return; + } + parent::show(); + } + function getProfiles() { $featured_nicks = common_config('nickname', 'featured'); @@ -57,9 +65,14 @@ class FeaturedUsersSection extends ProfileSection $quoted[] = "'$nick'"; } + $table = "user"; + if(common_config('db','quote_identifiers')) { + $table = '"' . $table . '"'; + } + $qry = 'SELECT profile.* ' . - 'FROM profile JOIN user on profile.id = user.id ' . - 'WHERE user.nickname in (' . implode(',', $quoted) . ') ' . + 'FROM profile JOIN '. $table .' on profile.id = '. $table .'.id ' . + 'WHERE '. $table .'.nickname in (' . implode(',', $quoted) . ') ' . 'ORDER BY profile.created DESC '; $limit = PROFILES_PER_SECTION + 1; @@ -79,6 +92,7 @@ class FeaturedUsersSection extends ProfileSection function title() { + // TRANS: Title for featured users section. return _('Featured users'); }