Package msql creates connections to MySQL datastores.

Package psql creates connections to Postgres datastores.

Approve automatically checks and clears file records for live.

CheckID checks the syntax of the universal unique record id or MySQL auto-generated id.

CheckUUID checks the syntax of the universal unique record id.

Columns details the columns used by the table.

ConnDebug will connect to the database and return any errors.

Connect the database and handle any errors.

DateTime colours and formats a date and time string.

DemozooID looks up a Demozoo productions ID in the files table, and returns the ID of the first matched Defacto2 file record.

DeObfuscate a public facing, obfuscated file ID or file URL.

Distinct returns a unique list of values from the table column.

Execute Query and Args to update the database and returns the total number of changes.

FileUpdate returns true when named file is newer than the database time.

Fix any malformed section and platforms found in the database.

GetFile looks up val and returns the filename of the file record.

GetID looks up the val and returns a matching auto-increment ID of the file record.

GetKeys returns all the primary keys used by the files table.

IsDemozoo reports if a fetched demozoo file record is set to unapproved.

IsID reports whether string is an auto-generated record id.

IsUnApproved reports if a fetched file record is set to unapproved.

IsUUID reports whether string is a universal unique record id.

LastUpdate reports the time when the files database was last modified.

ObfuscateParam hides the param value using the method implemented in CFWheels obfuscateParam() helper.

StripChars removes incompatible characters used for groups and author names.

StripStart removes non-alphanumeric characters from the start of the string.

Tbls are the available tables in the database.

Total reports the number of records fetched by the supplied SQL query.

TrimSP removes duplicate spaces from a string.

Val returns the column value as either a string or "NULL".

Waiting returns the number of files requiring approval for public display.

Datetime MySQL format.

ExampleID is an invalid placeholder UUID, where x represents a digit.

Files records.

Groups names.

Netresources for online websites.

TestID is a generic UUID that can be used for unit tests.

UpdateID is a user id to use with the updatedby column.

Empty is used as a blank value for search maps.

Flags are command line arguments.

IDs are unique UUID values used by the database and filenames.

A database table.