- <?php
- defined('_JEXEC') or die('Restricted access');
- require(JModuleHelper::getLayoutPath('mod_cb_userlist'));
- function getUserList(){
- $db =& JFactory::getDBO();
- $query = "SELECT `title` "
- ." FROM `#__comprofiler_lists` "
- ." ORDER BY `listid` ASC";
- $db->setQuery($query);
- $UserList = $db->loadResult();
- return $UserList;
- }
- function getUserCount(){
- $db =& JFactory::getDBO();
- $query = "SELECT COUNT(*) "
- ." FROM `#__comprofiler` "
- ." WHERE `cb_myvalue` = ".$UserList."";
- $db->setQuery($query);
- $UserList = $db->loadResult();
- return $UserList;
- }?>