Package fix contains functions for repairing the database data.

Package htm3 is a sub-package of the model package that should only be used by the html3 handler.

Package querymod provides the query mod expressions for the file database.

ByForApproval returns all of the file records that are waiting to be marked for approval.

CategoryByteSum sums the byte file sizes for all the files that match the named category.

CategoryCount counts the files that match the named category.

ClassificationCount counts the files that match the named category and platform.

Counts returns the total numbers of artifact records.

One retrieves a single file record from the database using the record key.

DemozooExists returns true if the file record exists in the database using a Demozoo production ID.

HashExists returns true if the file record exists in the database using a SHA-384 hexadecimal hash.

HashFind returns the obfuscated ID of the file record in the database that was matched using a SHA-384 hexadecimal hash.

InsertDemozoo inserts a new file record into the database using a Demozoo production ID.

InsertPouet inserts a new file record into the database using a Pouet production ID.

InsertUpload inserts a new file record into the database using a URL values map.

JsDosBinary returns the program executable to run in the js-dos emulator.

JsDosCommand returns the program executable or commands to run in the js-dos emulator.

JsDosConfig creates a js-dos .ini configuration for the emulator.

NewV7 generates a new UUID version 7, if that fails then it will fallback to version 1.

One retrieves a single file record from the database using the record key.

OneByUUID returns the record associated with the UUID key.

OneDemozoo retrieves the ID or key of a single file record from the database using a Demozoo production ID.

OneEditByKey retrieves a single file record from the database using the obfuscated record key.

OneFile retrieves a single file record from the database using the record key.

OneFileByKey retrieves a single file record from the database using the obfuscated record key.

OnePouet retrieves the ID or key of a single file record from the database using a Pouet production ID.

PlatformByteSum sums the byte filesizes for all the files that match the category name.

PlatformCount counts the files that match the named platform.

PouetExists returns true if the file record exists in the database using a Pouet production ID.

ReleaserByteSum sums the byte file sizes for all the files that match the group name.

SHA384Exists returns true if the file record exists in the database using a SHA-384 hash.

Update16Colors updates the WebID16colors column value with val.

UpdateBoolFrom updates the column bool from value with val.

UpdateClassification updates the classification of a file in the database.

UpdateComment updates the Comment column value with val.

UpdateCreatorAudio updates the CreditAudio column with val.

UpdateCreatorIll updates the CreditIllustration column with val.

UpdateCreatorProg updates the CreditProgram column with val.

UpdateCreators updates the text, illustration, program, and audio credit columns with the values provided.

UpdateCreatorText updates the CreditText column with val.

UpdateDateIssued updates the date issued year, month and day columns with the values provided.

UpdateDemozoo updates the WebIDDemozoo column with val.

UpdateEmulateBroken updates the column dosee_broken with val.

UpdateEmulateEMS updates the column dosee_no_ems with val.

UpdateEmulateUMB updates the column dosee_no_umb with val.

UpdateEmulateXMS updates the column dosee_no_xms with val.

UpdateFilename updates the Filename column with val.

UpdateGitHub updates the WebIDGithub column with val.

UpdateInt64From updates the column int64 from value with val.

UpdateLinks updates the youtube, 16colors, relations, sites, demozoo, and pouet columns with the values provided.

UpdateMagic updates the file magictype (magic number) column with the magic value provided.

UpdateOffline updates the record to be offline and inaccessible to the public.

UpdateOnline updates the record to be online and public.

UpdatePlatform updates the Platform column value with val.

UpdatePouet updates the WebIDPouet column with val.

UpdateRelations updates the ListRelations column value with val.

UpdateReleasers updates the releasers values with val.

UpdateSites updates the ListLinks column with val.

UpdateStringFrom updates the column string from value with val.

UpdateTag updates the Section column with val.

UpdateTitle updates the RecordTitle column with val.

UpdateVirusTotal updates the FileSecurityAlertURL value with val.

UpdateYMD updates the date issued year, month and day columns with the values provided.

UpdateYouTube updates the WebIDYoutube column value with val.

UUID returns a slice of all the UUIDs in the database.

UUIDExists returns true if the file record exists in the database using a UUID.

Validate checks the artifact record for any missing or invalid values that should prevent it from being published and public.

ValidD returns a valid day or a null value.

ValidDateIssue returns a valid year, month and day or a null value.

ValidFilename returns a valid filename or a null value.

ValidFilesize returns a valid file size or an error.

ValidIntegrity confirms the integrity as a valid SHA-384 hexadecimal hash or returns a null value.

ValidLastMod returns a valid last modified time or a null value.

ValidM returns a valid month or a null value.

ValidMagic returns a valid media type or a null value.

ValidPlatform returns a valid platform or a null value.

ValidReleasers returns two valid releaser group strings or null values.

ValidSceners returns a valid sceners string or a null value.

ValidSection returns a valid section or a null value.

ValidString returns a valid string or a null value.

ValidTitle returns a valid title or a null value.

ValidY returns a valid year or a null value.

ValidYouTube returns true if the string is a valid YouTube video ID.

Alphabetical orders by the releaser name.

ClauseNoSoftDel is the clause to exclude soft deleted records.

ClauseOldDate orders the records by oldest date first.

Sanity is to check the maximum permitted production ID.

EpochYear is the epoch year for the website, ie.

From is the name of the table containing records of files.

LongFilename is the maximum length of a filename.

Maximum number of files to return per query.

Oldest orders by the year of the first artifact.

Prolific orders by the total artifact count.

ShortLimit is the maximum length of a short string.

Advert is a the model for the for sale.

Announcement is a the model for the public and community announcements.

Ansi is a the model for the ANSI formatted text and art files.

AnsiBBS is a the model for the BBS advertisements created in ANSI text.

AnsiBrand is a the model for the brand logos created in ANSI text.

AnsiFTP is a the model for the FTP advertisements created in ANSI text.

AnsiNfo is a the model for the NFO files created in ANSI text.

AnsiPack is a the model for the ANSI file packs.

Artifacts contain statistics for every artifact.

BBS is a the model for the Bulletin Board System files.

BBSImage is a the model for the Bulletin Board System image files.

BBSText is a the model for the Bulletin Board System text files.

BBStro is a the model for the Bulletin Board System intro files.

Database is a the model for the database releases.

Demoscene is a the model for the demoscene releases.

Drama is the model for community drama.

FileUpload is a struct that contains the values needed to update an existing file record after a new file has been uploaded to the server.

FTP is a the model for the FTP files.

Hack is a the model for the game hacks.

HowTo is a the model for the guides and how-tos.

HTML is a the model for the HTML and markdown files.

Image is a the model for the images.

ImagePack is a the model for the image file packs.

Installer contain statistics for releases that could be considered installers.

Intro contain statistics for releases that could be considered intros or cracktros.

IntroMsDos contain statistics for releases that could be considered DOS intros or cracktros.

IntroWindows contain statistics for releases that could be considered Windows intros or cracktros.

Java is a the model for the Java operating system.

JobAdvert is a the model for group job advertisements.

Linux is a the model for the Linux operating system.

Macos is a the model for the Macintosh operating system.

Magazine is a the model for the magazine files.

MsDos is a the model for the MS-DOS operating system.

MsDosPack is a the model for the DOS file packs.

Music is a the model for the music.

NewsArticle is a the model for mainstream news articles.

Nfo is a the model for the NFO files.

NfoTool is a the model for the NFO tools.

PDF is a the model for the documents in PDF format.

Proof is a the model for the file proofs.

Releaser is a collective, group or individual, that releases files.

ReleaserName is a releaser name.

Script is a the model for the script and interpreted languages.

Standard is a the model for community standards.

Summary counts the total number files, file sizes and the earliest and latest years.

Takedown is a the model for the bust and takedowns.

Text is a the model for the text files.

TextAmiga is a the model for the text files for the Amiga operating system.

TextApple2 is a the model for the text files for the Apple II operating system.

TextAtariST is a the model for the text files for the Atari ST operating system.

TextPack is a the model for the text file packs.

Tool is a the model for the computer tools.

TrialCrackme is a the model for group job trial crackme releases.

Video is a the model for the videos.

Windows is a the model for the Windows operating system.

WindowsPack is a the model for the Windows file packs.

OrderBy is the sorting order for ALL the releasers.

ReleaserNames is a distinct data list of releasers.

Releasers is a collection of releasers.

Scener is a collective, group or individual, that releases files.

Sceners is a collection of sceners.

StatFunc is a function that updates the summary statistics.