Add bugfix for bug#84: quote TXT and HINFO records properly

Added tag release_2.1.0 for changeset 0345d21f21b0

Added tag release_2.1.1 for changeset 963d62dc1c80

Added tag release_2.1.2 for changeset 1e24ee6c41e5

Adding tailor state file to help updates from upstream

[feladat @ 308] Bugfix: when not all data was entered correctly when creating a new user, an error was displayed, but the user still was created. Bugfix: A possible privilege escalation has been reported by Pim Rupert. This has also been adressed.

[feladat @ 307] Minor bug fix: bg.shiny@gmail.com reported that cyrillic characters where not supported. Applied the patch which was supplied. This closes #93.

[feladat @ 303] Added preliminary support for SPF (other than in TXT) and SSHFP records. Valdiation for these types will be added in near future. As requested in #89.

[feladat @ 302] Applied the patches supplied in #82 and #85. Also quoted some additional values before they are send to the database.

[feladat @ 300] Bugfix: When no zones are available in current listing, it isn't possible to switch to an other listing. Fixed this by displaying the character selection in this case. Closes: #81. Bug reported by Tom Hutchison.

[feladat @ 299] Fixed a number of undefined errors warnings. Updated a number variable names for consistency. Update PHP syntax for consistency.

[feladat @ 298] Bugfix: The GRANT statement for PostgreSQL is not correct. Modified the code to give the correct GRANT statement based on the tables in database-structure.inc.php. Reported by grin. Closes: #78.

[feladat @ 297] Bugfix: removed the multirow insert syntax, which is only supported in PostgreSQL 8.2 and higher. Reported and patch by grin. This closes ticket:79.

[feladat @ 296] Fixed a number of errors for undefined variables.

[feladat @ 294] Update of SRV record validation. Now checks for a maximum number of characters of content field and allows dash in first label of content field. Closes #45.

[feladat @ 293] Added isset() check for commits.

[feladat @ 292] Fixed a number of undefined variable errors in PHP. Fixed an omission in r291.

[feladat @ 291] Bugfix. A user without the privilige to change the permission templates for users couldn't change user properties. Closes: #80.

[feladat @ 290] Fixed a couple of warnings on undefined variables and array indexes. Closes: #71.

[feladat @ 289] Bugfix: In postgres an empty string ("") was is not automatically casted to 0. Because of this the use of integer is forced in the $db->quote() function. This fixes ticket:40.

[feladat @ 288] Fixed GRANT statement installer to give working example, even if web interface and database are on different server. Closes #67.

[feladat @ 287] Changed default zone type when adding new master zones (from master to native).

[feladat @ 286] Bugfix: Modified the link to the Poweradmin installation in step 7 from 'index.php' to '../index.php'. This closes ticket:68.

[feladat @ 285] Fixed an invalid function call. Reported by Chet Nichols. Closes #55.

[feladat @ 284] Validation of an emailaddress now uses new hostname validation function as well. Issue reported by Alessandro Bono. Closes: #60.

[feladat @ 282] Bugfix. Unable to add a new slave due to wrong validation of user input. Reported by Adhisimon. Closes #58.

[feladat @ 281] Fixed a bug that was introduced by bugfix (...) in r277.

[feladat @ 280] Fixed a small and non-critical bug when validating SOA records. An error messages was shown, validation or process wasn't influenced.

[feladat @ 279] Fixed a bug causing return of wrong seasrch results when searching for zones the user does own. Reported by Adhisimon. Closes: #56.

[feladat @ 278] Added user configurable option to show serial of zone in zone listing. Closes: #53.

[feladat @ 277] Changed legacy function name for hostname validation to new code. Bug reported by Adhisimon. Closes: #55.

[feladat @ 276] Bugfix: Used the $_SESSION['userid'] instead of $userid. Patch supplied by adhisimon. This closes #54.

[feladat @ 275] Fixed the two URL's in the CHANGELOG and README file.

[feladat @ 273] Renamed error ERR_DNS_MX_NS_TO_CNAME to more generic ERR_DNS_NON_ALIAS_TARGET. See also r270.

[feladat @ 272] Removed an unused error definition.

[feladat @ 271] Password of Poweradmin administrator is now asked (and used) during installation procedure, avoiding the need of using a default password.

[feladat @ 270] Added validation for SRV records. Closes #45. Updated validation for TXT records to allow for DKIM. Closes #49. Renamed is_valid_mx_or_ns_target function to more generic name is_valid_non_alias_target.

[feladat @ 269] Minor layout bug: Made sure the table row was closed before starting a new one.

[feladat @ 268] Added two missing exclamation marks in IP address verification function. Closes #52.

[feladat @ 267] Fixing the previous bugfix. Should really close #51. Additionaly, allow for IPv6 master if zone is a new slave zone.

[feladat @ 266] Fixed legacy function calls to functions for validating IPv4 and IPv6 addresses. Closes: #51.

[feladat @ 265] Fixed a bug in the installer. This closes #50.

[feladat @ 264] Fixing typo in MX validation check.

[feladat @ 263] Fixed create user example for PgSQL to have create a new user with a password.

[feladat @ 262] Re-ordering of some of the questions in the installer script. The user is now presented the exact commands to create the Poweradmin database user, instead of giving a mock-up.

[feladat @ 261] Changed suggested configuration code to not use the PGP shorttags for better compatibility.

[feladat @ 260] Fixing another typo in Dutch translation.

[feladat @ 259] Fixing typo in Dutch translation.

[feladat @ 258] Fixing small bug in on-screen print of suggested configuration.

[feladat @ 257] Added translation of installation script. User now may choose between english or dutch installation procedure.

[feladat @ 256] The local configuration file is now written by the installer if the file is writeable to the webserver. If it is not, the user must create the file himself. Fixed a small typo.

[feladat @ 255] Fixed a missing variable definition in the installer.

[feladat @ 254] Allow the use of SRV records, allthough there is no validation of this type (yet). Requested by Philipp Hellmich.

[feladat @ 253] Added a small explanation of the supported regular expression for the search field. This closes ticket:38 and ticket:47.

[feladat @ 252] Added the possibility to select whether MySQL or PostgreSQL should be used. Depending on the choice, a different instruction is displayed in step 3. Also fixed a minor typo.

[feladat @ 251] Fixed a small problem in the database scheme that is created by the install procedure.

[feladat @ 250] Added a check for the existence of the install/ direcory. If it exists, present the user with an error message.

[feladat @ 249] Added a small check to make sure a nice message is shown if the users does not have view access to any zone (in list_zones.php).

[feladat @ 248] Added basic installation procedure. This closes ticket:10.

[feladat @ 247] If the user was listing the details of a zone that did not exist, all kinds of error messages were given. Now we first determine if the ID is valid and if not, immediately return the correct error message.

[feladat @ 246] Improvement of DNS validation code. See also [wiki:Documentation documentation on standards]. Closes ticket:6, trailing dot not allowed in content field (it is now stripped automagically as PowerDNS doesnt want it). Closes ticket:40, error shown if priority field was empty and record type was not MX (prio field is now ignored if record type is not MX).

[feladat @ 245] Bugfix: When a record is deleted from the search screen, an error was displayed. This closes ticket:43.

[feladat @ 244] Improved SOA record validation.

[feladat @ 243] Added inclusion of 'config-me.inc.php' to get the defaults.

[feladat @ 242] Changed configuration file and variables. See [wiki:Documentation/ConfigurationFile documentation] for more information on new setup.

[feladat @ 241] Bugfix: Only save the modified record when there is no error in the record. Bug reported by Techwolf in ticket:39

[feladat @ 240] Bugfix: when a zone has no records (eg a incorrect slave) it was not possible to delete this zone. Modified the query to fetch the records of the zone with a LEFT OUTER JOIN so there still will be a result when an empty zone is selected. This closes ticket:25. Bugfix: Made the query compatible with pgsql

[feladat @ 239] Bugfix. Adding a new master zone without using the template caused creation of malformed SOA record.

[feladat @ 238] Fixed a typo. Reported in ticket:39.

[feladat @ 235] Removed svn:executable for a number of files. This closes ticket:36.

[feladat @ 234] Bugfix. If the number of zones a user has access to was exactly the maximum number of rows to be show according to the configuration, only a small number was actually shown. Parch by Techwolf. This closes ticket:29.

[feladat @ 233] Bugfix. Added missing count of number of supermasters. Was removed somewhere between revisions r125 and r181 in r182. Bug found by Techwolf. This closes ticket:35.

[feladat @ 232] Removed left-over debug statement.

[feladat @ 231] Input for edit_record function in edit_record.php was array with incorrect fields. Fixed. This closes ticket:32.

[feladat @ 230] Fixed a lot of notices which where shown when php was running in E_ALL instead of E_ALL & ~E_NOTICE Bugfix: In the index.php the Add supermaster wasn't displayed due to a wrong parameter in the check.

[feladat @ 229] Changed URL's to Poweradmin website in footer of PHP pages.

[feladat @ 228] Updated the README with a pointer to the website.

[feladat @ 226] Added a check for a number of database related settings in the configuration. If not set, the interface now will return a clean error message. This closes ticket:28.

[feladat @ 225] Removed left-over debug statement from r224.

[feladat @ 224] The is_valid_soa function now ignores multiple spaces inbetween the fields and replaces them with a single space upon updating the record in the database (instead of returning an error). If user provided 8 fields or more, 8th and further fields are ignored. This closes ticket:24.

[feladat @ 223] Bugfix. No domain id was provided when entering 'edit record' page from a search query. Changed code so 'edit record' does not rely on domain id provided by user but determines it from the record id that is about to be changed. This closes ticket:31.

[feladat @ 222] Changed case of Poweradmin's name (a is now lowercase).

[feladat @ 221] Applied the database-structure as supplied by Techwolf to make the insert queries work in PostgreSQL versions before 8.2. This closes ticket:27

[feladat @ 220] Update of 'edit user' window and i18n related files. All text in 'edit user' window is now translatable.

[feladat @ 219] Description of permission rights are now translated as well. This closes ticket:26.

[feladat @ 218] Little modification to speed up the zone listing in pgSQL.

[feladat @ 215] Removed wrong svn property on search.php.

[feladat @ 213] Modified the inserts in the pgsql db structure to make sure no duplicate key errors are shown when a new records is created. Also moved the Ueber_user permision item upfront, to make sure it is created with id 1 so the permission template can be created correctly. Added an additional query to check what the ID is of the ueber_user, as it set hardcoded to 53 in the query.

[feladat @ 212] Minor change to Dutch translation.

[feladat @ 211] Update of template translation file. Update of Dutch translation. Update and cleanup of some user interface text.

[feladat @ 210] Lots of minor updates to user interface text.

[feladat @ 209] Modified some of the INSERT queries to make them compatible with pgSQL

[feladat @ 208] When in the zone listing letters are shown (too many zones to show on a single screen), the start letter is clickable only if there are any zones starting with that letter. If the users asks for a start letter that has no zones (because of bugs like the one fixed in r207 or because user manipulates URL in browser), a PHP error was shown. Code now verifies number of zones now first.

[feladat @ 207] Bugfix. The letters shown just above the list of zones was showing clickable letters, even if there were no zones starting with such a letter.

[feladat @ 206] Added database structure for PostgreSQL and fixed some queries to be compatible with PostgreSQL. Bugfix in delete_supermaster.php

[feladat @ 205] Bugfix. A user with with at least view access could change user details, including the assigned permission template, for which he did have rights. Reported by Maarten te Paske.

[feladat @ 204] Bugfix. Even if one did have the 'add supermasters' right, the menu option wasn't shown. Reported by Maarten te Paske.

[feladat @ 203] Changed field type for password entry field in 'edit user' window from text to password. Now password is no longer shown in plain tekst.

[feladat @ 202] Changed field type for password entry field in 'add user' window from text to password. Now password is no longer shown in plain tekst.

[feladat @ 201] Fixed a typo in the description of 'supermaster_edit' permission.

[feladat @ 200] When loading SQL database structure user 'administrator' has all possible permissions enabled, both ueberuser and others. This may bring confusion, especially those that didn't read the documentation. Now only 'user_is_ueberuser' is enabled, all other disabled. No functional changes. Suggested by Maarten te Paske.

[feladat @ 199] Changed layout of links to additional menu options in user management windows. Suggestion by Maarten te Paske.

[feladat @ 198] Bugfix. User was unable to delete a record from a zone due to a number of errors in de code.

[feladat @ 197] Bugfix for name field validation. Now done right. I hope.

[feladat @ 196] Another update to name field checking.

[feladat @ 195] Extended name field validation.

[feladat @ 194] Bugfix. Unable to add record without specifying a name (which is common for @ records).

[feladat @ 193] Removal of left-over debug statement in add domain function.

[feladat @ 192] Second half of r189 commit.

[feladat @ 191] Bugfix. Syntax problem in debug_print function.

[feladat @ 190] Changed 'print debug' function a tiny bit.

[feladat @ 189] Added functionality for deletion of permission templates. Simplified function for getting permission template details.

[feladat @ 188] Improved error checking of delete_domain function. The ticket:25 has been opened, this is still a problem.

[feladat @ 187] Bugfix. Corrected field order of insert of new zones.

[feladat @ 186] Bugfix. Due to a typo in an if statement it was impossible to add new slave zones.

[feladat @ 185] Added functionality to add a new permission template. It was lacking support for that important feature until now. :)

[feladat @ 184] Fixed a typo in a description of one of the permission items.

[feladat @ 183] Bugfix. When changing the username of an existing user, an sql error was shown due to bad quoting of a variable.

[feladat @ 182] Merged r125:181 of branches/rewrite-user-management into trunk. This incorporates the [wiki:ProposalUserPermissionManagement a new user and permission management system] and closes ticket:22. Be aware, this database structure has changed, this version is incompatible with previous versions.

[feladat @ 159] Bugfix for ticket:16: A minor glitch in the query caused partially owned records not to be shown.

[feladat @ 158] Bugfix for ticket:18: Minor modification in the CSS to make sure no data is displayed on top of other data. Also a little modification to make sure the sub-owners (if there are any) are displayed above the record form, instead of next to it.

[feladat @ 156] Made a lot of small changes to allow PHP to run with error_reporting E_ALL without giving notices. Most functions have been checked but some situations might give a notice.

[feladat @ 127] Bugfix for ticket:5 : Modified the query which searches zones to also find empty zones by adding a LEFT JOIN.

[feladat @ 124] Minor bugfix. If number of zones exceeded maximum row amount and the '0-9' was selected to be shown, the '0-9' was not rendered in bold, where in all other cases the selected letter is shown in bold.

[feladat @ 123] Reverting to changeset:121. Problems that were fixed in changeset:122 were local problems only.

[feladat @ 122] Fixing a number of 'division by zero' errors introduced changeset:121. Changed from constant to a normal variable. May need to be reviewed in a future cleanup.

[feladat @ 121] Moved the constants down, so the ROWAMOUNT can be defined in the config.inc.php file. This to solve ticket:20. Fixed a bug which was introduced in r112. The used arguments in the setLimit function where in the wrong order.

[feladat @ 120] Fixed a bug reported by Techwolf. When editing or deleting an user the user was redirected to a non existing page. This probably happened when BASE_URL and/or BASE_PATH was set wrong in the config.inc.php.

[feladat @ 119] Modified install.php to have the same footer as the rest of the files.

[feladat @ 118] Removed the requirement of enabeling the PHP setting short_open_tag by changing all short open tags (<?) to the 'normal' tags (<?php).

[feladat @ 117] Fixed a bug reported by Balazs Petrikovics. i18n doesn't work correctly on FreeBSD.

[feladat @ 116] Fixed a bug reported by Techwolf. Adding a new user reloaded a non-existing page on success.

[feladat @ 115] Fixed a missing slash in a html tag in list_zones.php.

[feladat @ 114] Patch for ticket 19. Because of the use of the quote function, empty strings where converted to NULL as MDB2_PORTABILITY_EMPTY_TO_NULL is set by default. This problem also applied to the active state of an user.

[feladat @ 113] Password field in users.php is now set to type 'password' instead of 'text'. When typing password '*' are shown instead of the password.

[feladat @ 112] Added better support of the PEAR:MDB2 package by using the setLimit() function instead of adding a LIMIT to the query itself and by using the quote() function to quote all parameters. Added an error when no valid email address was given when creating or modifying a user.

[feladat @ 111] Cleaning up docs/.

[feladat @ 110] Removed two echo's used for debugging.

[feladat @ 109] Fixed ticket:7 (allow regular expression in zone and record search).

[feladat @ 108] Modified the SQL statements for PostgreSQL as the tables are created with wrong definitions.

[feladat @ 107] Fixing ticket:17 (zone listing and count in user management screen incomplete).

[feladat @ 106] Cleared unmaintained changelog in docs/ and added reference to website.

[feladat @ 105] Correcting included file in users.inc.php.

[feladat @ 104] Created function to delete sub-owner from record.

[feladat @ 103] Created function to add a so-called sub-owner to a record.

[feladat @ 102] Fixed the queries so both MySQL and PostgreSQL are supported. The 'REGEXP' queries are currently fixed with a workaround.

[feladat @ 101] Fixing wrong test commit.

[feladat @ 100] Test, please ignore

[feladat @ 99] Update of docs/README file with a new description and download instructions. Fixed a typo as well.

[feladat @ 98] Fixed a missing gettext reference in the title of the change password page.

[feladat @ 97] Removed superflucious includes of inc/i18n.inc.php.

[feladat @ 96] Changed list of credits to an online version.

[feladat @ 95] Minor changes to increase inconsistency.

[feladat @ 94] Second half of previous commit. :)

[feladat @ 93] Change of license, from QPL to GPL. Added a copyright, disclaimer and license pointer to all PHP files. Added the LICENSE file, with a copy of the GPLv3.

[feladat @ 92] Fix for ticket #3. Patch supplied by Peter Beernink. Added i18n.

[feladat @ 91] Fixing some language issues. Translations not working due to wrong file names, see r89 as well. Fixing two broken references in menu and list_zones.php.

[feladat @ 90] Fixing #1 ("password of user is shown in plain text when edited by admin").

[feladat @ 89] Fix documentation on i18n.

[feladat @ 88] Bugfix. When viewing the details of a slave zone, an error was shown if the ip addresses of it's master nameserver was set (instead of showing the error if there was none set. Reported: Maarten te Paske.

[feladat @ 87] Bugfix. With user level 5 or 10 and lots of zones without an owner, like slave zones that are inserted by a supermaster, the "list all zones" view was broken (not all zones shown, but "show page" and "show letters" were missing as well). Function zone_count matches zones and domains table, but users with level 5 or 10 are allowed to see zones without an entry in the zones table as well.

[feladat @ 86] Fixed a typo in the credits. Sorry Koert.

[feladat @ 85] The type of zone wasn't show to users with access level 1. If a user with access level 1 did have access to a slave zone the user did not see the IP of the master nameserver of that zone. Now the user will the IP address (readonly and only if one is set). Bugfix. If no master IP for a slave zone is given, a warning is shown regardless of the userlevel. Bugfix. Both the "add record" and "edit record" buttons in the "edit zone" screen is no longer available for users with level 1 for domains of type "slave". Bug report by Antonio Prado. Some PHP and HTML cleanup (removing of empty tags and unnecessary repeatings of calls to a single function).

[feladat @ 84] Bugfix. The function zone_count() now also counts zones an owner has only partial access to, not just those zones the owner has full access to. This fixes just the count, the zones a user has partial access to are not (yet!) shown in the "list zones" page. Bugfix. In the zone listing the "edit" button is now show for users with access level 1. Untill now they were presented an overview of the zones they could change, but there was no link for them to actually edit the zone. Bugfix. Some of the buttons in the "edit zone" interface that are of no use to a user with access level 1 have been hidden. Bugfix. Make sure a user with access level 1 with only partial access to a zone cannot add new records to that zone. Only the zone owner should be able to add new record. Bugfix. If a user with access level 1 edits a record in a zone he has only partial access to, an error was shown because of call to a non- existing function in the PEAR:MDB2. This bug was most likely introduced while migrating from PEAR:DB to PEAR:MDB2. Bugfix. A user with access level 1 was able to delete all records of a zone he has only partial access to. Some additional checks have been added. Bugfix. If a user with accees level 1 has partial access to one or more zones starting with a certain character, but did not own at least one entire zone starting with the same character, the character wasn't clickable in the "list zone" page. Interface. If no record or zone id is given for delete_record.php or delete_domain.php, don't just die but echo a nice message. The i18n files have not yet been updated to reflect this change. Interface. If no master IP is given in delete_supermaster.php, don't just die but echo a nice message. The i18n files have not yet been updated to reflect this change. [All fixes by Peter Beernink.]

[feladat @ 83] Bugfix: the list_zones.php wasn't listing zones correctly if a zone didn't have an owner. Bugfix: the list_supermasters.php never listed more then one supermaster, even if there were more. Both bugs were reported by Jasper van Erven Dorens.

[feladat @ 82] Fixed a bug in add_zone_master.php.

[feladat @ 81] Bugfix. If the number of zones exceeded the "max row limit" and a "starting letter" with no zones was requested in list_zones.php it would show no zones while incorrectly stating "showing 1 out of N zones".

[feladat @ 80] Re-added link to credits (was removed by accident as well).

[feladat @ 79] Bugfix. The link to the pages that should list zones starting with a number was incorrect (only reproducable if number of records to be shown was larger than the limit of the number of rows on a page).

[feladat @ 78] Removed version information in footer. Doesn't work. Isn't global.

[feladat @ 77] Bugfix. Function zone_count() was accidently omitted.

[feladat @ 76] Changed some of the functions that are used for the listing of (all) zones. Instead of getting all zones from the database, it now only requests exactlty what it needs. Considerable perfomance improvement.

[feladat @ 75] Updated changelog file with quick and dirty updated.

[feladat @ 74] Added missing record_owners SQL table creation during install. Fix by John Morris.

[feladat @ 73] All owners (not sub-owners though) of the zone are now shown when listing a zone. Added a new function to retrieve owners of zone by id without fetching all other zone details, which should improve perfomance. Both fixes by Peter Beernink.

[feladat @ 72] After a user had logged out, the menu bar was still shown until a reloading the login screen. [Fix: Peter Beernink]

[feladat @ 71] Improved printing of revision information in footer.

[feladat @ 70] Changed default TTL from 3600 to 86400. Changed max number of records on a single screen from 500 to 50. Added print of version number to footer.

[feladat @ 69] Changed some left-over "domains" to "zones" in web interface.

[feladat @ 68] Updated some of the SQL queries to gain major performance improvements when listing all slave and master zones.

[feladat @ 67] Fixed small layout bug in list_zones.php.

[feladat @ 66] Removed unneeded variable in validate_input function call.

[feladat @ 65] Updated credits page.

[feladat @ 64] Updated credits page.

[feladat @ 63] Bugfix. The number of arguments for the function validate_input() in record.inc.php and dns.inc.php was different, causing a variables to be validated incorrectly.

[feladat @ 62] Bugfix. In list_zones.php with no domains created, get_domains will return -1, count() will not be 0, as all_doms contains one element. Similar problem in existed in list_supermasters.php.

[feladat @ 61] Updated changelog.

[feladat @ 60] Merged 1.4.0 changes r23:59 into trunk.

[feladat @ 28] Fixed a bug in dns.inc.php ($recordid missing from input on validate_input function).

[feladat @ 25] Added some additional help to docs for i18n is not working.

[feladat @ 24] Fixed small typo.

[feladat @ 22] - Fixed bug in install.php (was still using sequence stuff). - Changed alignment of columns in user listing in users.php.

[feladat @ 20] - Merged branches/1.3.0 changes r12:19 into the trunk.

[feladat @ 8] - Removal of left-over backup file.

[feladat @ 7] - Fixed last major part of translation.

[feladat @ 6] - Fixed bug in record.inc.php, search did never give matching domains. - Some modifications to Dutch translation.

[feladat @ 5] - Second half of translation framework. - Several small typo's in code fixed. - Removed comments on a todo in leveldescription(), already done. - Replaced dal.inc.php with DB.php from package DB-1.7.6 from pear.php.net to fix problems using poweradmin 1.2.7-patched with php5/pear. The DB package has already been superseded by MDB2, but that version is incompatible with current code.

[feladat @ 4] General update translation.

[feladat @ 3] First set of changes to provide translation framework.

[feladat @ 2] Creation of initial working branch.

Tailor preparing to convert repo by adding .hgignore