本文整理匯總了PHP中JCommentsFactory::getDbo方法的典型用法代碼示例。如果您正苦於以下問題：PHP JCommentsFactory::getDbo方法的具體用法？PHP JCommentsFactory::getDbo怎麽用？PHP JCommentsFactory::getDbo使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類JCommentsFactory的用法示例。
在下文中一共展示了JCommentsFactory::getDbo方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getUserGroups
public static function getUserGroups()
{
static $groups = array();
if (!count($groups)) {
if (JCOMMENTS_JVERSION == '1.0') {
$db = JCommentsFactory::getDbo();
$db->setQuery('SELECT a.name, a.name AS text, a.group_id as id, COUNT(DISTINCT b.group_id) AS level' . ' FROM #__core_acl_aro_groups AS a' . ' LEFT JOIN `#__core_acl_aro_groups` AS b ON a.lft > b.lft AND a.rgt < b.rgt' . ' WHERE a.name NOT IN ("ROOT", "USERS", "Public Backend")' . ' GROUP BY a.group_id' . ' ORDER BY a.lft ASC');
$groups = $db->loadObjectList();
// for backward compatibility
self::updateUserGroups($groups);
} else {
if (JCOMMENTS_JVERSION == '1.5') {
$db = JFactory::getDbo();
$db->setQuery('SELECT a.name, a.name AS text, a.id, COUNT(DISTINCT b.id) AS level' . ' FROM #__core_acl_aro_groups AS a' . ' LEFT JOIN `#__core_acl_aro_groups` AS b ON a.lft > b.lft AND a.rgt < b.rgt' . ' WHERE a.name NOT IN ("ROOT", "USERS", "Public Backend")' . ' GROUP BY a.id' . ' ORDER BY a.lft ASC');
$groups = $db->loadObjectList();
// for backward compatibility
self::updateUserGroups($groups);
} else {
if (JCOMMENTS_JVERSION == '1.7') {
$db = JFactory::getDbo();
$db->setQuery('SELECT CASE WHEN a.id = 1 THEN \'Public\' ELSE a.title END AS name, a.title AS text, a.id, COUNT(DISTINCT b.id) AS level' . ' FROM #__usergroups AS a' . ' LEFT JOIN `#__usergroups` AS b ON a.lft > b.lft AND a.rgt < b.rgt' . ' GROUP BY a.id' . ' ORDER BY a.lft ASC');
$groups = $db->loadObjectList();
}
}
}
}
return $groups;
}