chamilo / chamilo-lms

                    WHERE default_user_id = user.user_id ";

        }

        if (isset($_GET['keyword'])) {

            $keyword = Database::escape_string(trim($_GET['keyword']));

            $sql .= " AND (user.username LIKE '%".$keyword."%' OR default_event_type LIKE '%".$keyword."%' OR default_value_type LIKE '%".$keyword."%' OR default_value LIKE '%".$keyword."%') ";

        }

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

        $obj = Database::fetch_object($res);

                   WHERE track_default.default_user_id = user.user_id ";

        }

        if (isset($_GET['keyword'])) {

            $keyword = Database::escape_string(trim($_GET['keyword']));

            $sql .= " AND (user.username LIKE '%".$keyword."%' OR

                        default_event_type LIKE '%".$keyword."%' OR

                        default_value_type LIKE '%".$keyword."%' OR

                        default_value LIKE '%".$keyword."%') ";

        }

        if (!empty($column) && !empty($direction)) {

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

    		$condition_user = " WHERE user.user_id = $user_ids ";

    	}

    	if (!empty($_GET['user_keyword'])) {

    		$keyword = trim(Database::escape_string($_GET['user_keyword']));

    		$condition_user .=  " AND (

                user.firstname LIKE '%".$keyword."%' OR

                user.lastname LIKE '%".$keyword."%'  OR

                user.username LIKE '%".$keyword."%'  OR

                user.email LIKE '%".$keyword."%'

             ) ";

    	}

        $url_table = null;

        $url_condition = null;