DBVerify query

DBVerify queries are created for clients that use Database passthrough. The DBVerify query attempts to query the database using the login and password provided when a user logs into Crash Magic. If Crash Magic does not have a Crash Magic account for the user or the query fails to access the database, the user will be denied access to Crash Magic.

An example query might be:

SELECT Crash.CrashID

FROM Crash

WHERE 1=0

The purpose of the query is not to retrieve data from the database, but to check that the user has access to the database. All DBVerify queries should have a where clause of 1=0 to ensure that no data is actually returned by the query.