'.$mod_strings['LBL_DELETE_GROUP'].'

'.$mod_strings['LBL_DELETE_GROUPNAME'].' '.htmlentities($delete_group_name,ENT_QUOTES,$default_charset).' '.$mod_strings['LBL_TRANSFER_GROUP'].' '; global $adb; $sql = "select groupid,groupname from vtiger_groups"; $result = $adb->pquery($sql, array()); $num_groups = $adb->num_rows($result); $sql1 = "select * from vtiger_users where deleted=0"; $result1= $adb->pquery($sql1, array()); $num_users = $adb->num_rows($result1); $output.= ' User'; if($num_groups > 1) { $output .= ' Group'; } $output .= ''; $output .= ''; for($i=0;$i<$num_users;$i++) { $user_id=$adb->query_result($result1,$i,"id"); $output.=''. getFullNameFromQResult($result1, $i, 'Users').''; } $output .=''; if($num_groups > 1) { $output .= ''; $output.=''; $temprow = $adb->fetch_array($result); do { $group_name= htmlentities($temprow["groupname"],ENT_QUOTES,$default_charset); $group_id=$temprow["groupid"]; if($delete_group_id != $group_id) { if(strlen($group_name)>20) { $group_name=substr($group_name,0,20)."..."; } $output.=''.$group_name.''; } }while($temprow = $adb->fetch_array($result)); $output.=''; } $output.='

'; echo $output; ?>