# Module parameter for database access.

## `db_url` (String)

URL to the database containing the data.

Default value is &defaultrodb;.

### Set `db_url` parameter

    ...
    modparam("userblacklist", "db_url", "dbdriver://username:password@dbhost/dbname")
    ...

## `userblacklist_table` (String)

Name of the userblacklist table for the userblacklist module.

Default value is userblacklist.

### Set `userblacklist_table` parameter

    ...
    modparam("userblacklist", "userblacklist_table", "userblacklist")
    ...

## `userblacklist_id_col` (string)

unique ID

### Set `userblacklist_id_col` parameter

    ...
    modparam("userblacklist", "userblacklist_id_col", "id")
    ...

## `userblacklist_username_col` (string)

The user that is used for the blacklist lookup.

### Set `userblacklist_username_col` parameter

    ...
    modparam("userblacklist", "userblacklist_username_col", "username")
    ...

## `userblacklist_domain_col` (string)

The domain that is used for the blacklist lookup.

### Set `userblacklist_domain_col` parameter

    ...
    modparam("userblacklist", "userblacklist_domain_col", "domain")
    ...

## `userblacklist_prefix_col` (string)

The prefix that is matched for the blacklist.

### Set `userblacklist_prefix_col` parameter

    ...
    modparam("userblacklist", "userblacklist_prefix_col", "prefix")
    ...

## `userblacklist_whitelist_col` (string)

Specify if this a blacklist (0) or a whitelist (1) entry.

### Set `userblacklist_whitelist_col` parameter

    ...
    modparam("userblacklist", "userblacklist_whitelist_col", "whitelist")
    ...

## `globalblacklist_table` (String)

Name of the globalblacklist table for the userblacklist module. Please note that this table is used when the check_blacklist function is called with no parameters.

Default value is globalblacklist.

### Set `globalblacklist_table` parameter

    ...
    modparam("userblacklist", "globalblacklist_table", "globalblacklist")
    ...

## `globalblacklist_id_col` (string)

unique ID

### Set `globalblacklist_id_col` parameter

    ...
    modparam("userblacklist", "globalblacklist_id_col", "id")
    ...

## `globalblacklist_prefix_col` (string)

The prefix that is matched for the blacklist.

### Set `globalblacklist_prefix_col` parameter

    ...
    modparam("userblacklist", "globalblacklist_prefix_col", "prefix")
    ...

## `globalblacklist_whitelist_col` (string)

Specify if this a blacklist (0) or a whitelist (1) entry.

### Set `globalblacklist_whitelist_col` parameter

    ...
    modparam("userblacklist", "globalblacklist_whitelist_col", "whitelist")
    ...

## `globalblacklist_description_col` (string)

A comment for the entry.

### Set `globalblacklist_description_col` parameter

    ...
    modparam("userblacklist", "globalblacklist_description_col", "description")
    ...