Configuration Directive List
PrevNext

SQLUserWhereClause

Name

SQLUserWhereClause -- Configure a WHERE clause for every user query<

Synopsis

SQLUserWhereClause [ where-clause]

Default

None

Context

server config, <Global>, <VirtualHost>

Module

mod_sql

Compatibility

1.2.5rc1 and later

Description

The directive is used to configure a WHERE clause that is added to every user query. The WHERE clause must contain all relevant punctuation, and must not contain a leading "and".

Starting with ProFTPD 1.3.1rc1 the SQLUserWhereClause also supports the variables supported by SQLNamedQuery except for the "%{n}" variable

See also

SQLNamedQuery

Examples

As an example of a possible use for this directive, imagine if your user table included a "LoginAllowed" field:

  SQLUserWhereClause "LoginAllowed = 'true'"

would be appended to every user-related query as the string:

  " WHERE (LoginAllowed = 'true')"

PrevHomeNext
SQLUserInfoUp StoreUniquePrefix