function showUser($id) { $database = JFactory::getDBO(); /* $database->setQuery("SELECT u.id as myid, config_name, us.username, ug.title, u.location, u.jgroup FROM #__joomla_flash_uploader f, #__joomla_flash_uploader_user u left outer join #__users us on u.user=us.id left outer join #__usergroups ug on u.jgroup=ug.id where u.profile=f.id ORDER BY u.profile,username,ug.title"); $rows = $database->loadObjectList(); $backendgroups = JFUHelper::getBackendGroups($rows, JFUHelper::getUserGroups()); // now we insert an admin profile for all backend groups foreach ($backendgroups AS $groups) { $rowuser = new joomla_flash_uploader_user($database); $rowuser->profile = 1; $rowuser->jgroup = $groups->value; $rowuser->location = 'admin'; $rowuser->store(); } */ if (checkAccess($database, 'core.edit.state') && checkAccess($database, 'core.admin')) { // all mappings $query = "SELECT u.id as myid, concat(config_name, ' (id:', f.id ,')') as config_name, us.username, ug.title, u.location, u.jgroup FROM #__joomla_flash_uploader f, #__joomla_flash_uploader_user u left outer join #__users us on u.user=us.id left outer join #__usergroups ug on u.jgroup=ug.id where u.profile=f.id ORDER BY u.location,u.profile,username,ug.title"; $database->setQuery($query); $rows = $database->loadObjectList(); // check if mappings are still vaild and if not they are removed. foreach ($rows as $row) { if ($row->username == null && $row->title == null) { $database->setQuery("DELETE FROM #__joomla_flash_uploader_user WHERE id IN ({$row->myid})"); $database->query(); } } // reload $database->setQuery($query); $rows = $database->loadObjectList(); // now I create the dropdowns for users and for profiles! $database->setQuery("SELECT * FROM #__users u order by username"); $users = $database->loadObjectList(); $num_users = count($users); if ($num_users > 10) { $num_users = 10; } $data['users'] = JHTML::_('select.genericlist', $users, 'user[]', 'size="' . $num_users . '" multiple="multiple" ', 'id', 'username', 0); // $database->setQuery("SELECT * FROM #__joomla_flash_uploader WHERE id != 1 AND gid!='' "); $database->setQuery("SELECT id, concat(config_name, ' (id:', id ,')') as config_name, gid FROM #__joomla_flash_uploader WHERE id != 1 AND gid!='' "); $profiles = $database->loadObjectList(); $last_profile = 0; if (isset($_SESSION['LAST_PROFILE'])) { $last_profile = $_SESSION['LAST_PROFILE']; } if (count($profiles) != 0) { $data['profiles'] = JHTML::_('select.genericlist', $profiles, 'profile', 'size="1"', 'id', 'config_name', $last_profile) . '<div style="clear:both"></div><p>' . JText::_('U_AVAILABLE_LIST') . '.</p>'; $data['profilesgroup'] = JHTML::_('select.genericlist', $profiles, 'profilegroup', 'size="1"', 'id', 'config_name', $last_profile) . '<div style="clear:both"></div><p>' . JText::_('U_AVAILABLE_LIST') . '.</p>'; $data['showAdd'] = true; } else { $data['profiles'] = $data['profilesgroup'] = '<div class="message fade">' . JText::_('U_NO_PROFILE') . '.</div>'; $data['showAdd'] = false; } $database->setQuery("SELECT id, concat(config_name, ' (id:', id ,')') as config_name, gid FROM #__joomla_flash_uploader"); $profiles = $database->loadObjectList(); $data['allprofiles'] = JHTML::_('select.genericlist', $profiles, 'allprofile', 'size="1"', 'id', 'config_name', $last_profile) . '<div style="clear:both"></div><p>' . JText::_('U_AVAILABLE_LIST_ALL_PROFILES') . '.</p>'; $data['groups'] = JFUHelper::getUserGroups(); $data['backendgroups'] = JFUHelper::getBackendGroups($rows, $data['groups']); $data['showAddAdmin'] = count($data['backendgroups']) > 0; HTML_joomla_flash_uploader::listUsers($rows, $data); } else { HTML_joomla_flash_uploader::errorRights(); } }