<#Database Testing Results#>

Using the settings in the form above ... {if $db_errors and !$allow_next} Errors below will not allow installation to continue. {/if}

{if $dbtest.connected}

Connection to the database server was successful on '{$dbhost|escape}'!

{if $dbtest.min_ver}

Database server is {$dbtest.type|escape} v{$dbtest.db_ver}. (minimum required {$min_db_version})

{else}

Your {$dbtest.type|escape} database version is too low. v{$dbtest.db_ver} is less than the minimum of v{$min_db_version}

{/if} {else}

I was not able to connect to your database server.

Make sure the host and port are correct. {if $dbhost == '127.0.0.1'} Try using 'localhost' for the host instead of 127.0.0.1. {/if} {if !empty($dbport)} Try leaving the port empty to use the default. {/if}

Make sure your username and password are correct. {if !empty($dbpass)}Are you sure your user even needs a password? Try leaving it blank.{/if}

{/if} {if $dbtest.connected} {if $dbtest.created}

I created the database '{$dbname|escape}' successfully!

{elseif $dbtest.exists}

I am able to use the existing database '{$dbname|escape}'.

{else}

I was not able to create the database '{$dbname|escape}'.

{/if} {if $dbtest.selected} {if !$dbtest.charset}

Default charset for DB '{$dbname|escape}' is not UTF8 (current: {$dbtest.charset_str|escape}) and might cause problems.

If the database is not using utf8 character set you might encounter problems with players that have non-ascii names. If you want to re-create the database you can do so in the next step of the installation.

{/if}

CREATE privilege is {if !$dbtest.tbl_create}not{/if} OK

SELECT privilege is {if !$dbtest.tbl_select}not{/if} OK

INSERT privilege is {if !$dbtest.tbl_insert}not{/if} OK

UPDATE privilege is {if !$dbtest.tbl_update}not{/if} OK

DELETE privilege is {if !$dbtest.tbl_delete}not{/if} OK

{if !$dbtest.tbl_drop}

DROP privilege is not OK

Not being able to drop a table is not required unless you attempt to reset the player stats from the ACP at a later date.

Note: A test table was created '{$dbtest.table}' for these tests and could not be deleted. You should manually delete this table with another mysql user if possible.

{else}

DROP privilege is OK

{/if} {/if} {/if} {if $db_errors}

<#Database Errors#>

The errors below should help indicate why any tests above failed.

{/if} {if $db_queries}

<#Database Queries Performed#> (Show)

For the curious, the following DB queries were performed to determine if your DB/user is setup properly.

{/if} {if $allow_next}

<#Database Setup Confirmed!#>

Your database settings have been verified! Click "Next" to continue!

{/if}