chamilo / chamilo-lms

        $keywordCondition = null;

        if (!empty($keyword)) {

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

            $keywordCondition = " AND (name LIKE '%$keyword%' ) ";

            if (!empty($description)) {

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

                $keywordCondition = " AND (name LIKE '%$keyword%' OR description LIKE '%$description%' ) ";

            }

        }

        $tbl_session_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_SESSION);

        $access_url_id = api_get_current_access_url_id();

        }

        $keywordCondition = '';

        if (!empty($keyword)) {

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

            $keywordCondition = " AND (s.name LIKE '%$keyword%' ) ";

            if (!empty($description)) {

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

                $keywordCondition = " AND (s.name LIKE '%$keyword%' OR s.description LIKE '%$description%' ) ";

            }

        }

        $whereConditions .= $keywordCondition;

        $subQuery = $sessionQuery.$courseSessionQuery;