X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Ffeatureduserssection.php;h=4b9238d471c5775d4f3c8b4bd2c47b2166400724;hb=6658e2a2ee9517bebd59cf69d7483e6eda691b4e;hp=aed94b1a555e845b36c7fd23513fd90b0a9756cc;hpb=14e3a2ffb602b157b74085188c9bfda41f79b9e8;p=quix0rs-gnu-social.git diff --git a/lib/featureduserssection.php b/lib/featureduserssection.php index aed94b1a55..4b9238d471 100644 --- a/lib/featureduserssection.php +++ b/lib/featureduserssection.php @@ -57,9 +57,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;