function ALU_editItem($id, $option) { $db =& JFactory::GetDbo(); $cid = mosGetParam($_POST, 'cid', mosGetParam($_GET, 'cid', array(0))); if (!is_array($cid)) { $cid = array(0); } $group_id = intval($cid[0]); if (!$group_id) { $group_id = mosGetParam($_REQUEST, 'filt_groups'); } $redirect = mosGetParam($_REQUEST, 'page'); $id = mosGetParam($_REQUEST, 'cid', array(0)); $rows_groups = array(); $row->user_id = 0; if ($id[0]) { $one_elem = explode('_', $id[0]); $X = isset($one_elem[0]) ? intval($one_elem[0]) : 0; $Y = isset($one_elem[1]) ? intval($one_elem[1]) : 0; if ($X && $Y) { $query = "SELECT a.*,b.* FROM #__lms_user_assign_groups as a, #__users as b WHERE a.user_id = {$X} AND a.group_id = {$Y} AND b.id = a.user_id"; $db->setQuery($query); $row = $db->LoadObject(); $group_id = $row->group_id; $query = "SELECT b.ug_name FROM #__lms_user_assign_groups as a, #__lms_usergroups as b WHERE a.user_id = {$X} AND a.group_id = b.id ORDER BY b.ug_name"; $db->setQuery($query); $rows_groups = $db->LoadObjectList(); } } $lists = array(); $query = "SELECT id as value, ug_name as text FROM #__lms_usergroups WHERE course_id = 0 AND parent_id = 0 ORDER by ug_name"; $db->setQuery($query); $ug_names = $db->loadObjectList(); $list_ug_names = array(); $list_ug_names[] = mosHTML::makeOption('0', _JLMS_USERS_SLCT_USR_GR_); $list_ug_names = array_merge($list_ug_names, $ug_names); $lists['ug_names'] = mosHTML::selectList($list_ug_names, 'group_id', 'class="text_area" size="1" style="width:266px"', 'value', 'text', $group_id); $query = "SELECT a.id as value, a.name as text FROM #__users AS a, #__lms_users AS b WHERE a.id = b.user_id ORDER BY name"; $db->SetQuery($query); $list_users = array(); $list_users[] = mosHTML::makeOption('0', _JLMS_USERS_NAME_); $pr = $db->loadObjectList(); $list_users = array_merge($list_users, $pr); $lists['users_names'] = mosHTML::selectList($list_users, 'user_id', 'class="text_area" style="width:266px" size="1"', 'value', 'text', $row->user_id); ALU_html::editItem($row, $lists, $option, $redirect, $rows_groups); }