chamilo / chamilo-lms

    $direction = in_array(strtolower($direction), array('desc', 'asc')) ? $direction : 'desc';

    $column = Database::escape_string($column);

    if ($getCount) {

        $result = Database::query($sql);

        $result = Database::fetch_array($result);

        return $result['count'];

    }

    $sql .= " ORDER BY $column $direction";

    $sql .= " LIMIT $start, $limit";

        if ($getSql) {

            return $sql;

        }

        if ($getCount) {

            $result = Database::query($sql);

            $row = Database::fetch_array($result);

            return $row['count'];

        }

        $orderBy = null;

        if ($getOnlyUserId == false) {

		            src.session_id IN ($sessionsSQL)

		            $keywordCondition

		        ";

        if ($getCount) {

            $result = Database::query($sql);

            $row = Database::fetch_array($result,'ASSOC');

            return $row['count'];

        }

        if (isset($from) && isset($limit)) {

            $from = intval($from);

            $sql .= $limitCondition;

        }

        if ($getCount) {

            $result = Database::query($sql);

            $row = Database::fetch_array($result);

            return $row['total'];

        }

        $result = Database::query($sql);

        $html = null;