The "/sqlar" page:

URLs:

/zip/[VERSION/]NAME.zip
/sqlar/[VERSION/]NAME.sqlar

Generate a ZIP Archive or an SQL Archive for the check-in specified by VERSION. The archive is called NAME.zip or NAME.sqlar and has a top-level directory called NAME.

The optional VERSION element defaults to the name of the main branch (usually "trunk") per the r= rules below. All of the following URLs are equivalent:

/zip/release/xyz.zip
/zip?r=release&name=xyz.zip
/zip/xyz.zip?r=release
/zip?name=release/xyz.zip

Query parameters:

name=[CKIN/]NAME
The optional CKIN component of the name= parameter identifies the check-in from which the archive is constructed. If CKIN is omitted and there is no r= query parameter, then use the name of the main branch (usually "trunk"). NAME is the name of the download file. The top-level directory in the generated archive is called by NAME with the file extension removed.

r=TAG
TAG identifies the check-in that is turned into an SQL or ZIP archive. The default value is the name of the main branch (usually "trunk"). If r= is omitted and if the name= query parameter contains one "/" character then the of part the name= value before the / becomes the TAG and the part of the name= value after the / is the download filename. If no check-in is specified by either name= or r=, then the name of the main branch (usually "trunk") is used.

in=PATTERN
Only include files that match the comma-separated list of GLOB patterns in PATTERN, as with ex=

ex=PATTERN
Omit any file that match PATTERN. PATTERN is a comma-separated list of GLOB patterns, where each pattern can optionally be quoted using ".." or '..'. Any file matching both ex= and in= is excluded.

Robot Defenses:

If "zip" appears in the robot-restrict setting, then robots are not allowed to access this page. Suspected robots will be presented with a captcha.
If "zipX" appears in the robot-restrict setting, then robots are restricted in the same way as with "zip", but with exceptions. If the check-in for which an archive is requested is a leaf check-in and if the robot-zip-leaf setting is true, then the request is allowed. Or if the check-in has a tag that matches any of the GLOB patterns on the list in the robot-zip-tag setting, then the request is allowed. Otherwise, the usual robot defenses are activated.