Summary:	phpMyAdmin - web-based MySQL administration
Summary(pl):	phpMyAdmin - administracja bazami MySQL przez WWW
Name:		phpMyAdmin
#%define		_rc	rc2
Version:	2.5.5
Release:	1
License:	GPL v2
Group:		Applications/Databases/Interfaces
Source0:	http://dl.sourceforge.net/phpmyadmin/%{name}-%{version}.tar.bz2
# Source0-md5:	b790e9f10f9e0d8406d2684e7ad6a9df
Source1:	%{name}.conf
Patch0:		%{name}-config.patch
URL:		http://www.phpmyadmin.net/
BuildRequires:	rpm-php-pearprov
#Requires:	mysql
Requires(postun):	perl
Requires:	php-mysql
Requires:	php-pcre
Requires:	php
Requires:	webserver
BuildArch:	noarch
BuildRoot:	%{tmpdir}/%{name}-%{version}-root-%(id -u -n)

%define		_myadmindir	%{_datadir}/%{name}
%define		_sysconfdir	/etc/%{name}

%description
phpMyAdmin can administer a whole MySQL-server (needs a super-user)
but also a single database. To accomplish the latter you'll need a
properly set up MySQL-user who can read/write only the desired
database. It's up to you to look up the appropiate part in the MySQL
manual. Currently phpMyAdmin can:
  - create and drop databases
  - create, copy, drop and alter tables
  - delete, edit and add fields
  - execute any SQL-statement, even batch-queries
  - manage keys on fields
  - load text files into tables
  - create (*) and read dumps of tables
  - export (*) and import data to CSV values
  - administer multiple servers and single databases
  - communicate in more than 20 different languages

%description -l pl
phpMyAdmin potrafi zarządzać całymi bazami MySQL (potrzebne
uprawnienia super-user'a) jak i pojedynczymi bazami danych. Będziesz
potrzebował użytkownika, który ma prawa zapisu/odczytu tylko tych baz,
którymi chcesz administrować (zajrzyj do odpowiedniej części manual'a
MySQL). Aktualnie phpMyAdmin potrafi:
  - tworzyć i usuwać bazy
  - create, copy, drop oraz alter na tabelach
  - dodawać, usuwać i edytować pola
  - wykonywać dowolne zapytania SQL
  - zarządzać kluczami na rekordach
  - wczytywać tekst z plików do tabel
  - obsługiwać ponad 20 języków
  - zarządzać wieloma serwerami i pojedyńczymi bazami danych
  - eksportować i importować dane do wartości CSV
  - tworzyć i czytać zrzuty tabel

%prep
%setup -q
%patch -p1

%install
rm -rf $RPM_BUILD_ROOT
install -d $RPM_BUILD_ROOT%{_myadmindir}/{css,lang,images,libraries/{auth,export}} \
	$RPM_BUILD_ROOT{%{_sysconfdir},/etc/httpd}

install *.php *.html *.css $RPM_BUILD_ROOT%{_myadmindir}
install images/*.{gif,png} $RPM_BUILD_ROOT%{_myadmindir}/images
install lang/*.php $RPM_BUILD_ROOT%{_myadmindir}/lang
install css/* $RPM_BUILD_ROOT%{_myadmindir}/css
install libraries/*.{js,php} $RPM_BUILD_ROOT%{_myadmindir}/libraries
install libraries/auth/*.php $RPM_BUILD_ROOT%{_myadmindir}/libraries/auth
install libraries/export/*.php $RPM_BUILD_ROOT%{_myadmindir}/libraries/export

install config.inc.php $RPM_BUILD_ROOT%{_sysconfdir}
ln -sf %{_sysconfdir}/config.inc.php $RPM_BUILD_ROOT%{_myadmindir}/config.inc.php

install %SOURCE1 $RPM_BUILD_ROOT/etc/httpd/%{name}.conf

%clean
rm -rf $RPM_BUILD_ROOT

%post
if [ -f /etc/httpd/httpd.conf ] && ! grep -q "^Include.*phpMyAdmin.conf" /etc/httpd/httpd.conf; then
        echo "Include /etc/httpd/phpMyAdmin.conf" >> /etc/httpd/httpd.conf
fi
if [ -f /var/lock/subsys/httpd ]; then
	/usr/sbin/apachectl restart 1>&2
fi

%preun
if [ "$1" = "0" ]; then
	umask 027
	grep -v "^Include.*phpMyAdmin.conf" /etc/httpd/httpd.conf > \
                /etc/httpd/httpd.conf.tmp
        mv -f /etc/httpd/httpd.conf.tmp /etc/httpd/httpd.conf
	if [ -f /var/lock/subsys/httpd ]; then
		/usr/sbin/apachectl restart 1>&2
	fi
fi

%triggerpostun -- phpMyAdmin <= 2.5.3-2
if [ -f /home/services/httpd/html/myadmin/config.inc.php.rpmsave ]; then
	mv -f /home/services/httpd/html/myadmin/config.inc.php.rpmsave /etc/phpMyAdmin/config.inc.php
else
    if [ -f /home/httpd/html/myadmin/config.inc.php.rpmsave ]; then
	mv -f /home/httpd/html/myadmin/config.inc.php.rpmsave /etc/phpMyAdmin/config.inc.php
    fi
fi
for i in `grep -lr "/home/\(services/\)*httpd/html/myadmin" /etc/httpd/*`; do
	cp $i $i.backup
	%{__perl} -pi -e "s#/home/httpd/html/myadmin#%{_myadmindir}#g" $i
	%{__perl} -pi -e "s#/home/services/httpd/html/myadmin#%{_myadmindir}#g" $i
	echo "File changed by trigger: $i (backup: $i.backup)"
done
if [ -f /var/lock/subsys/httpd ]; then
	/usr/sbin/apachectl restart 1>&2
fi

%files
%defattr(644,root,root,755)
%doc Documentation.* CREDITS ChangeLog INSTALL README TODO translators.html
%dir %{_sysconfdir}
%attr(640,root,http) %config(noreplace) %verify(not size mtime md5) %{_sysconfdir}/*
%config(noreplace) %verify(not size mtime md5) /etc/httpd/%{name}.conf
%dir %{_myadmindir}
%{_myadmindir}/css
%{_myadmindir}/images
%{_myadmindir}/lang
%{_myadmindir}/libraries
%{_myadmindir}/*.css
%{_myadmindir}/*.html
%{_myadmindir}/*.php