Configuration Directive List
PrevNext

SQLGroupWhereClause

Name

SQLGroupWhereClause -- Configure a WHERE clause for every group query

Synopsis

SQLGroupWhereClause [ where-clause]

Default

off

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 group query. The WHERE clause must contain all relevant punctuation, and must not contain a leading "and".

Starting with ProFTPD 1.3.1rc1 the SQLGroupWhereClause 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 group table included a "LoginAllowed" field:

  SQLGroupWhereClause "LoginAllowed = 'true'"

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

  " WHERE (LoginAllowed = 'true')"

PrevHomeNext
SQLGroupInfoUp SQLHomedirOnDemand