Move all SQL into DNSDB.pm

[Kris Deugau]

(In [225]) /trunk

Move some SQL into DNSDB.pm (see #1):
fill_rectypes is now getTypelist, and updated for reverse zones
and the custom DNS record types
Also apply a couple of small nitpick fixes in formatting and spelling

[Kris Deugau]

(In [237]) /trunk

Checkpoint - almost finished updating domain list code to handle
reverse zones as well (see #26).
Still needs some UI polish in the template (flags to convert
"domain" to "reverse zone"), and possibly bringing some of the
HTML::Template-feeding bits for the actual list back out of the
DNSDB.pm sub after pushing the SQL in there (see #1).

[Kris Deugau]

(In [279]) /trunk

Moving login SQL into DNSDB.pm complete. See #1
Checkpoint, moving logging into DNSDB.pm. See #1, #35.

Still requires a bit of commented-old-code cleanup

[Kris Deugau]

Note that ticket #35 is effectively part of this ticket as well, since it is targeted at getting calls to a non-DNSDB.pm sub that does direct SQL pulled back into DNSDB.pm.

[Kris Deugau]

(In [311]) /trunk

Move SQL for SOA update to DNSDB.pm (see #1)
Clean up support for reverse zones (see #26)
Move action logging for SOA updates to DNSDB.pm (see #35)

Includes log/info message consistency cleanups, dropping stale
commented code, dropping if(0)'ed code, tweaks to fillsoa() to
retain user changes on errors, updates to getSOA() for consistency,
removal of a stale form input

[Kris Deugau]

(In [313]) /trunk

Convert SQL for bulk change choice page to existing calls to
DNSDB.pm. See #1.

[Kris Deugau]

(In [314]) /trunk

Move SQL for "Manage groups" to DNSDB.pm. See #1
Extend new group list sub to return a revzone count. See #26

[Kris Deugau]

(In [323]) /trunk

Moved some more SQL out of dns.cgi (see #1). Added pagination
and sorting to the log display while I was at it.

[Kris Deugau]

(In [325]) /trunk

Move SQL from user list code into DNSDB.pm. See #1

[Kris Deugau]

(In [326]) /trunk

Move SQL for clone-this-user dropdown into DNSDB.pm. See #1

[Kris Deugau]

(In [327]) /trunk

Rewrite fill_grouplist() sub to not do direct SQL calls. Steal
the algorithm from fill_grouptree and adapt to present an
indented, grouped-by-parent list of groups. See #1.

Tweak getChildren() to sort its results for more consistent behaviours;
may add a flag later to choose the sort field

[Kris Deugau]

Resolving with release of v1.2. Utility scripts like compact-recs.pl, tiny-import.pl or vega-import.pl can't really do their job via the API in DNSDB.pm; they need to manipulate things at a lower level.