Update to phpPgAdmin 5.0.2

Changes in 5.0.2
----------------

Some bug fixes.

* Fix a css typo & error in cappuccino theme
* Fix #3139003 "Autocomplete doesn't insert value", report and patch by Aleksander Machniak
* Fix bad inheritance between pg83 -> pg instead of pg83 -> pg84 in the database access classes. This bug was breaking some functionnalities with 8.3
* Fix a lot of nonstandard escaped string in the database access classes


Changes in 5.0.1
----------------

Minor bug fix and update version.

* Fix #3124417 "Wrong german translation", reported by schnoesel
* Fix (officialy) a bug where non-super user roles cannot check ownership on objects
* Add forgotten Galician language to the target "all" of lang/Makefile
* Update jQuery library to current stable 1.4.4
* remove useless date from the topbar informations.
  This was the only place that did PHP 5.3 complain about bad timezone configuration
  (a non-PPA related warning). As it was a totaly useless information, we decide to
  remove it.


Changes in 5.0
--------------

Features
* Support for PostgreSQL 8.4 and 9.0
* Support for database level collation for 8.4+
* Support for schema level export
* Add ability to alter schema ownership
* Clean up domain support and improve interface
* Add support for commenting on functions
* Allow user to rename role/users and set new passwords at the same time
* Greatly enhanced Full-Text-Search capabilities (ioguix, Loomis_K)
* Overhauled Selenium Test suite to support multiple database versions
* Optimized application graphics (Limo Driver)
* Support for Column Level Privileges
* Allow users to specify a template database at database creation time
* Support killing processes
* Add ability to create indexes concurrently
* Much better support of autovacuum configuration
* Add an admin page for table level
* Refactored autocompletion:
  * fix support for cross-schema objects
  * support multi-field FK
  * support for pagination of values in the auto-complete list
* Allow user to logicaly group their server under custom named node in the browser tree
* New themes (Cappuccino and Gotar) and a theme switcher on the introduction page
* Auto refresh Locks page
* Auto refresh Processes page
* Link in the bottom of the page to go to top of page
* Browsing on Foreign Keys (When browsing a table, clicking on a FK value, jump to the PK row)


Bugs
* Fix problems with query tracking on overly long queries
* Ensure pg_dump paths are valid
* Fix multiple bugs about quoting and escaping database objects names with special chars
* Fix multiple bugs in the browser tree
* Fix multiple bugs on the SQL and script file import form
* One security fix about code injection
* Don't allow inserting on a table without fields
* Some fix about commenting databases
* removed deprecated functions from PHP 5.3
* Lot of code cleanup
* Many other small minor bugs found on our way
* Fix the operator property page

Translations
* Czech (Marek Cernocky)
* Greek (Adamantios Diamantidis)
* Brazillian Portuguese (Fernando Wendt)
* Galician (Adri€n Chaves Fern€ndez)

Incompatabilities
* No longer support PHP < 5.0
* No longer support Postgres < 7.4

3 files changed, 25 insertions, 18 deletions

diff --git a/databases/phppgadmin/Makefile b/databases/phppgadmin/Makefile
index 72e180081cf..e5c0cb2cd40 100644
--- a/databases/phppgadmin/Makefile
+++ b/databases/phppgadmin/Makefile
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2009/01/13 14:40:40 roy Exp $
+# $NetBSD: Makefile,v 1.24 2011/02/08 23:09:17 asau Exp $
 
-DISTNAME=	phpPgAdmin-4.2.2
+DISTNAME=	phpPgAdmin-5.0.2
 PKGNAME=	${DISTNAME:S/PgAdmin/pgadmin/}
 CATEGORIES=	databases www
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE:=phppgadmin/}
@@ -30,6 +30,11 @@ CONF_FILES=	${EGDIR}/config.inc.php-dist ${PHPPGBASE}/conf/config.inc.php
 DOC_FILES=	CREDITS DEVELOPERS FAQ HISTORY INSTALL LICENSE TODO \
 		TRANSLATORS
 
+REPLACE_INTERPRETER+=	pkgsrc-php
+REPLACE.pkgsrc-php.old=	.*php
+REPLACE.pkgsrc-php.new=	${PREFIX}/bin/php
+REPLACE_FILES.pkgsrc-php=	build_tests.php
+
 do-configure:
 	${SED} -e "s#/usr/bin/pg#${PREFIX}/bin/pg#" \
 		${WRKSRC}/conf/config.inc.php-dist > \
diff --git a/databases/phppgadmin/PLIST b/databases/phppgadmin/PLIST
index e13d9c3b780..1e2675c159d 100644
--- a/databases/phppgadmin/PLIST
+++ b/databases/phppgadmin/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.13 2009/06/14 18:36:20 joerg Exp $
+@comment $NetBSD: PLIST,v 1.14 2011/02/08 23:09:17 asau Exp $
 share/doc/phppgadmin/CREDITS
 share/doc/phppgadmin/DEVELOPERS
 share/doc/phppgadmin/FAQ
@@ -9,11 +9,12 @@ share/doc/phppgadmin/TODO
 share/doc/phppgadmin/TRANSLATORS
 share/examples/phppgadmin/apache.conf
 share/examples/phppgadmin/config.inc.php-dist
-share/phppgadmin/aciur.js
+share/phppgadmin/admin.php
 share/phppgadmin/aggregates.php
+share/phppgadmin/ajax-ac-insert.php
 share/phppgadmin/all_db.php
-share/phppgadmin/autocomplete.php
 share/phppgadmin/browser.php
+share/phppgadmin/build_tests.php
 share/phppgadmin/casts.php
 share/phppgadmin/classes/ArrayRecordSet.php
 share/phppgadmin/classes/Gui.php
@@ -23,14 +24,12 @@ share/phppgadmin/classes/class.select.php
 share/phppgadmin/classes/database/ADODB_base.php
 share/phppgadmin/classes/database/Connection.php
 share/phppgadmin/classes/database/Postgres.php
-share/phppgadmin/classes/database/Postgres71.php
-share/phppgadmin/classes/database/Postgres72.php
-share/phppgadmin/classes/database/Postgres73.php
 share/phppgadmin/classes/database/Postgres74.php
 share/phppgadmin/classes/database/Postgres80.php
 share/phppgadmin/classes/database/Postgres81.php
 share/phppgadmin/classes/database/Postgres82.php
 share/phppgadmin/classes/database/Postgres83.php
+share/phppgadmin/classes/database/Postgres84.php
 share/phppgadmin/colproperties.php
 share/phppgadmin/constraints.php
 share/phppgadmin/conversions.php
@@ -45,15 +44,13 @@ share/phppgadmin/functions.js
 share/phppgadmin/functions.php
 share/phppgadmin/groups.php
 share/phppgadmin/help.php
-share/phppgadmin/help/PostgresDoc70.php
-share/phppgadmin/help/PostgresDoc71.php
-share/phppgadmin/help/PostgresDoc72.php
-share/phppgadmin/help/PostgresDoc73.php
 share/phppgadmin/help/PostgresDoc74.php
 share/phppgadmin/help/PostgresDoc80.php
 share/phppgadmin/help/PostgresDoc81.php
 share/phppgadmin/help/PostgresDoc82.php
 share/phppgadmin/help/PostgresDoc83.php
+share/phppgadmin/help/PostgresDoc84.php
+share/phppgadmin/help/PostgresDoc90.php
 share/phppgadmin/history.php
 share/phppgadmin/images/themes/default/AddArguments.png
 share/phppgadmin/images/themes/default/Admin.png
@@ -207,7 +204,9 @@ share/phppgadmin/lang/danish.php
 share/phppgadmin/lang/dutch.php
 share/phppgadmin/lang/english.php
 share/phppgadmin/lang/french.php
+share/phppgadmin/lang/galician.php
 share/phppgadmin/lang/german.php
+share/phppgadmin/lang/greek.php
 share/phppgadmin/lang/hebrew.php
 share/phppgadmin/lang/hungarian.php
 share/phppgadmin/lang/italian.php
@@ -228,7 +227,9 @@ share/phppgadmin/lang/recoded/danish.php
 share/phppgadmin/lang/recoded/dutch.php
 share/phppgadmin/lang/recoded/english.php
 share/phppgadmin/lang/recoded/french.php
+share/phppgadmin/lang/recoded/galician.php
 share/phppgadmin/lang/recoded/german.php
+share/phppgadmin/lang/recoded/greek.php
 share/phppgadmin/lang/recoded/hebrew.php
 share/phppgadmin/lang/recoded/hungarian.php
 share/phppgadmin/lang/recoded/italian.php
@@ -238,6 +239,7 @@ share/phppgadmin/lang/recoded/polish.php
 share/phppgadmin/lang/recoded/portuguese-br.php
 share/phppgadmin/lang/recoded/portuguese-pt.php
 share/phppgadmin/lang/recoded/romanian.php
+share/phppgadmin/lang/recoded/russian-utf8.php
 share/phppgadmin/lang/recoded/russian.php
 share/phppgadmin/lang/recoded/slovak.php
 share/phppgadmin/lang/recoded/spanish.php
@@ -245,6 +247,7 @@ share/phppgadmin/lang/recoded/swedish.php
 share/phppgadmin/lang/recoded/turkish.php
 share/phppgadmin/lang/recoded/ukrainian.php
 share/phppgadmin/lang/romanian.php
+share/phppgadmin/lang/russian-utf8.php
 share/phppgadmin/lang/russian.php
 share/phppgadmin/lang/slovak.php
 share/phppgadmin/lang/spanish.php
@@ -258,7 +261,6 @@ share/phppgadmin/libraries/adodb/adodb-datadict.inc.php
 share/phppgadmin/libraries/adodb/adodb-error.inc.php
 share/phppgadmin/libraries/adodb/adodb-iterator.inc.php
 share/phppgadmin/libraries/adodb/adodb-lib.inc.php
-share/phppgadmin/libraries/adodb/adodb-php4.inc.php
 share/phppgadmin/libraries/adodb/adodb-time.inc.php
 share/phppgadmin/libraries/adodb/adodb.inc.php
 share/phppgadmin/libraries/adodb/drivers/adodb-postgres.inc.php
@@ -305,5 +307,5 @@ share/phppgadmin/views.php
 share/phppgadmin/xloadtree/xloadtree2.js
 share/phppgadmin/xloadtree/xtree2.js
 @pkgdir share/phppgadmin/libraries/adodb/lang
-@pkgdir share/phppgadmin/classes/plugins
 @pkgdir share/phppgadmin/conf
+@pkgdir share/phppgadmin/classes/plugins
diff --git a/databases/phppgadmin/distinfo b/databases/phppgadmin/distinfo
index 6e6d6190be6..72ee9539133 100644
--- a/databases/phppgadmin/distinfo
+++ b/databases/phppgadmin/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.10 2009/01/13 14:40:40 roy Exp $
+$NetBSD: distinfo,v 1.11 2011/02/08 23:09:17 asau Exp $
 
-SHA1 (phpPgAdmin-4.2.2.tar.bz2) = 3a0b6fbed26d7faeb7a6a33525d021de941944cc
-RMD160 (phpPgAdmin-4.2.2.tar.bz2) = a41ce2278d09a2d791630b24db90edd0d3cc71d3
-Size (phpPgAdmin-4.2.2.tar.bz2) = 664619 bytes
+SHA1 (phpPgAdmin-5.0.2.tar.bz2) = 14fc59074e23ea57697ccd9c031936f853838bba
+RMD160 (phpPgAdmin-5.0.2.tar.bz2) = 13373330d2d118dff6243db49edc8ab3eef31ab8
+Size (phpPgAdmin-5.0.2.tar.bz2) = 776276 bytes