#2 admin.php(0.9.10) fix for Postgres 7.3.3

[James B Crocker]

admin.php was not working 100% for postgres.

All of the problems were with Postgres 7.3.3 and
admin.php(0.9.10).

There were issues with the extended fields added to the
soa and rr tables. (active, xfer). Issues with inserts and
updates. Issues with some selects for field information
from the soa, rr, ptr tables.

I've modified the admin.php to work properly with
postgres 7.3.3. Additionaly I've tweaked how the active
fields are presented in the soa browser and the ptr.

It appears that throughout the documentation that the
extended field 'active' would accept values other than
Y/N. However, admin.php and the C source for the
mydnsexport and others appears to rely on Y/N values.

Would suggest that the docs be changed to reflect the
dependency.

To apply the patch:
patch <pathtoyouradmin.php>/admin.php < diff_admin.php

NOTE: I have NOT regression tested this patch with
MySQL as the backend RDBMS.

[James B Crocker]

DIFF PATCH for admin.php

[Howard Wilkinson]

Logged In: YES
user_id=655834
Originator: NO

This looks like it has gone away as a problem in Mydns-ng can you check against 1.2.7 when it is released shortly and make sure that you do not need this included.