chamilo / chamilo-lms

        $courseId = api_get_course_int_id($courseCode);

        $userId = intval($userId);

        $line = null;

    	if (substr($view,3,1) == '1') {

    		$new_view = substr_replace($view,'0',3,1);

    		$title[1]=get_lang('LinksDetails');

    		$sql = "SELECT cl.title, cl.url

                        FROM $TABLETRACK_LINKS AS sl, $TABLECOURSE_LINKS AS cl

                        WHERE sl.links_link_id = cl.id

                            AND sl.c_id = $courseId

                            AND sl.links_user_id = $userId

                        GROUP BY cl.title, cl.url";

    		$results = StatsUtils::getManyResults2Col($sql);

    		$title_line= get_lang('LinksTitleLinkColumn')."\n";

    		if (is_array($results)) {

    			for ($j = 0 ; $j < count($results) ; $j++) {

    				$line .= $results[$j][0]."\n";

    			}

    		} else {

    			$line=get_lang('NoResult');

    		}

    	} else {

    		$new_view = substr_replace($view,'1',3,1);

    	}

    	return array($title_line, $line);

    }

    	$downloads_table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DOWNLOADS);

    	if (substr($view,4,1) == '1') {

    		$new_view = substr_replace($view,'0',4,1);

    		$title[1]= get_lang('DocumentsDetails');

    		$sql = "SELECT down_doc_path

                        FROM $downloads_table

                        WHERE c_id = $courseId

                            AND down_user_id = $user_id

                            AND down_session_id = $session_id

                        GROUP BY down_doc_path";

    		$results = StatsUtils::getManyResults1Col($sql);

    		$title_line = get_lang('DocumentsTitleDocumentColumn')."\n";

            $line = null;

    		if (is_array($results)) {

    			for ($j = 0 ; $j < count($results) ; $j++) {

    				$line .= $results[$j]."\n";

    			}

    		} else {

    			$line = get_lang('NoResult');

    		}

    	} else {

    		$new_view = substr_replace($view,'1',4,1);

    	}

    	return array($title_line, $line);

    }