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);
}
