Custom Queries

With custom queries you can alter the DNS record database output in the client area.

Setup

To setup custom queries create a new file in the SoluteDNS installation directory called:

custom_query.php

In this newly created file you can define custom queries which are added to the database query.

For example:

define("QUERY_CLIENT_RECORDS", "AND content NOT LIKE '%TEMPLATE%'");

Above custom query will display all records in a zone unless the word TEMPLATE is mentioned in the content field.

The following custom query rules can be defined:

QUERY_CLIENT_RECORDS
QUERY_CLIENT_TEMPLATE

This option requires knowledge about MySQL database queries. Be careful as this can easily break the preformed database query. Always start with AND instead of WHERE.