--- piwi-0.8+20041206.orig/Functions/db.pl
+++ piwi-0.8+20041206/Functions/db.pl
@@ -173,7 +173,7 @@
 
   if ($db_table_type{$Tables[$#Tables]} =~ m/\.(\d)$/)
   {
-    $Statement.=" AND parent_type='".substr($Tables[$#Tables-$1],0,1)."'";
+    $Statement.=" AND parent_type='".uc(substr($Tables[$#Tables-$1],0,1))."'";
   }
 
   if ($db_table_type{$Tables[$#Tables]} =~ m/^3/)
--- piwi-0.8+20041206.orig/debian/README.Debian
+++ piwi-0.8+20041206/debian/README.Debian
@@ -0,0 +1,16 @@
+piwi for Debian
+---------------
+
+ To connect to the prelude database, you should edit the file
+ /etc/piwi/config.pl
+
+ You should add 
+ Include /etc/piwi/httpd.conf
+ at the end of your apache httpd.conf file
+ and create a link from /var/www/piwi to /usr/share/piwi or edit the
+ /etc/piwi/httpd.conf in consequence
+
+ A debconf version should follow, but maybe not in sarge...
+
+
+ -- Mickael Profeta <profeta@debian.org>, Mon,  9 Feb 2004 21:26:21 +0100
--- piwi-0.8+20041206.orig/debian/changelog
+++ piwi-0.8+20041206/debian/changelog
@@ -0,0 +1,51 @@
+piwi (0.8+20041206-3ubuntu1) zesty; urgency=medium
+
+  * debian/compat: Bump to 10.
+  * debian/control:
+    - Build-depend on debhelper (>= 10).
+    - Depend on ${misc:Depends}.
+  * debian/rules:
+    - Use dh_prep instead of dh_clean -k.
+    - Add recommended build-arch and build-indep targets.
+
+ -- Logan Rosen <logan@ubuntu.com>  Sat, 24 Dec 2016 20:38:29 -0500
+
+piwi (0.8+20041206-3) unstable; urgency=low
+
+  * apply patch in report Bug#282609 
+
+ -- Mickael Profeta <profeta@debian.org>  Wed,  2 Mar 2005 13:55:42 +0100
+
+piwi (0.8+20041206-2) unstable; urgency=low
+
+  * fix error in debian/rules (closes: #294831)
+
+ -- Mickael Profeta <profeta@debian.org>  Sat, 12 Feb 2005 09:17:15 +0100
+
+piwi (0.8+20041206-1) unstable; urgency=low
+
+  * New upstream release
+  * fix permission of /etc/piwi/config.pl
+
+ -- Mickael Profeta <profeta@debian.org>  Wed,  9 Feb 2005 11:55:25 +0100
+
+piwi (0.8-3) unstable; urgency=low
+
+  * Move generated directory to /var/cache, so that /usr can be read only
+  * really fix permission (was remove by dh_fixperms...) 
+
+ -- Mickael Profeta <profeta@debian.org>  Fri,  9 Jul 2004 22:53:52 +0200
+
+piwi (0.8-2) unstable; urgency=low
+
+  * fix permission on generated directory
+  * add config.pl to conffiles
+
+ -- Mickael Profeta <profeta@debian.org>  Wed,  7 Apr 2004 16:45:53 +0200
+
+piwi (0.8-1) unstable; urgency=low
+
+  * Initial Release. (closes: #232534)
+
+ -- Mickael Profeta <profeta@debian.org>  Mon,  9 Feb 2004 21:26:21 +0100
+
--- piwi-0.8+20041206.orig/debian/compat
+++ piwi-0.8+20041206/debian/compat
@@ -0,0 +1 @@
+10
--- piwi-0.8+20041206.orig/debian/control
+++ piwi-0.8+20041206/debian/control
@@ -0,0 +1,20 @@
+Source: piwi
+Section: admin
+Priority: optional
+Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
+XSBC-Original-Maintainer: Mickael Profeta <profeta@debian.org>
+Build-Depends: debhelper (>= 10)
+Standards-Version: 3.6.1.0
+
+Package: piwi
+Architecture: all
+Depends: ${misc:Depends}, ${perl:Depends}, apache | apache-ssl | apache-perl | httpd, mysql-client | postgresql-client, libapache-dbi-perl, libdbd-mysql-perl| libdbd-pg-perl, libdate-calc-perl
+Suggests:  libgd-gd2-perl, geoip-bin
+Description: P(erl|relude) IDS Web Interface - A frontend to your Prelude database
+ Providing a complete web front-end for the Prelude-Intrusion Detection System
+  with features like :
+    - Alert listing, sorting, masking
+    - Alert details
+    - Source centric view
+    - Alert-type centric view
+    - Source informations (IP, MAC, OS via NMAP, known open services)
--- piwi-0.8+20041206.orig/debian/copyright
+++ piwi-0.8+20041206/debian/copyright
@@ -0,0 +1,26 @@
+This package was debianized by Mickael Profeta <profeta@debian.org> on
+Mon,  9 Feb 2004 21:26:21 +0100.
+
+It was downloaded from http://prelude-ids.org
+
+Upstream Author: Stephane LOEUILLET
+
+Copyright 2003, 2004 Stephane LOEUILLET
+
+  This program is free software; you can redistribute it and/or modify
+  it under the terms of the GNU General Public License as published by
+  the Free Software Foundation; either version 2 of the License, or
+  (at your option) any later version.   
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License with
+  the Debian GNU/Linux distribution in file /usr/share/common-licenses/GPL;
+  if not, write to the Free Software Foundation, Inc., 59 Temple Place,
+  Suite 330, Boston, MA  02111-1307  USA
+
+ On Debian systems, the complete text of the GNU General Public
+ License, version 2, can be found in /usr/share/common-licenses/GPL-2.
--- piwi-0.8+20041206.orig/debian/dirs
+++ piwi-0.8+20041206/debian/dirs
@@ -0,0 +1,3 @@
+usr/share/piwi
+var/cache/piwi
+etc/piwi
--- piwi-0.8+20041206.orig/debian/docs
+++ piwi-0.8+20041206/debian/docs
@@ -0,0 +1,4 @@
+Docs/BUGS.txt
+Docs/CREDITS.txt
+Docs/TODO.txt
+Docs/*mat.txt
--- piwi-0.8+20041206.orig/debian/httpd.conf
+++ piwi-0.8+20041206/debian/httpd.conf
@@ -0,0 +1,8 @@
+     <Directory "/var/www/piwi/">
+       Options ExecCGI
+       AddHandler cgi-script .pl
+     </Directory>
+
+DirectoryIndex index.pl
+PerlModule Apache::DBI
+
--- piwi-0.8+20041206.orig/debian/install
+++ piwi-0.8+20041206/debian/install
@@ -0,0 +1,12 @@
+Classes/* usr/share/piwi/Classes
+Functions/* usr/share/piwi/Functions
+Profiles/* /etc/piwi/Profiles
+Templates/* usr/share/piwi/Templates
+crontab/*  usr/share/piwi/crontab
+extra/* usr/share/piwi/extra
+generated/*  var/cache/piwi/generated
+images/* usr/share/piwi/images
+test/* usr/share/piwi/test
+*.pl usr/share/piwi
+*.css usr/share/piwi
+*.*ml usr/share/piwi/
--- piwi-0.8+20041206.orig/debian/links
+++ piwi-0.8+20041206/debian/links
@@ -0,0 +1,3 @@
+etc/piwi/config.pl usr/share/piwi/Functions/config.pl
+etc/piwi/Profiles usr/share/piwi/Profiles
+var/cache/piwi/generated usr/share/piwi/generated
--- piwi-0.8+20041206.orig/debian/rules
+++ piwi-0.8+20041206/debian/rules
@@ -0,0 +1,100 @@
+#!/usr/bin/make -f
+# -*- makefile -*-
+# Sample debian/rules that uses debhelper.
+# GNU copyright 1997 to 1999 by Joey Hess.
+
+# Uncomment this to turn on verbose mode.
+#export DH_VERBOSE=1
+
+
+
+
+CFLAGS = -Wall -g
+
+ifneq (,$(findstring noopt,$(DEB_BUILD_OPTIONS)))
+	CFLAGS += -O0
+else
+	CFLAGS += -O2
+endif
+ifeq (,$(findstring nostrip,$(DEB_BUILD_OPTIONS)))
+	INSTALL_PROGRAM += -s
+endif
+
+configure: configure-stamp
+configure-stamp:
+	dh_testdir
+	# Add here commands to configure the package.
+
+	touch configure-stamp
+
+
+build: build-arch build-indep
+build-arch: build-stamp
+build-indep: build-stamp
+
+build-stamp: configure-stamp 
+	dh_testdir
+
+	# Add here commands to compile the package.
+#	$(MAKE)
+	#/usr/bin/docbook-to-man debian/piwi.sgml > piwi.1
+
+	touch build-stamp
+
+clean:
+	dh_testdir
+	dh_testroot
+	rm -f build-stamp configure-stamp
+
+	# Add here commands to clean up after the build process.
+#	-$(MAKE) clean
+
+	dh_clean 
+
+install: build
+	dh_testdir
+	dh_testroot
+	dh_prep
+	dh_installdirs
+	dh_install 
+
+	install -m644 debian/httpd.conf $(CURDIR)/debian/piwi/etc/piwi/
+
+	chown -R www-data:www-data $(CURDIR)/debian/piwi/var/cache/piwi/generated
+	mv $(CURDIR)/debian/piwi/usr/share/piwi/Functions/config.pl \
+	      $(CURDIR)/debian/piwi/etc/piwi
+# Build architecture-independent files here.
+binary-indep: build install
+	dh_testdir
+	dh_testroot
+	dh_installchangelogs Docs/CHANGES.txt
+	dh_installdocs 
+	dh_installexamples
+#	dh_install
+#	dh_installmenu
+#	dh_installdebconf	
+#	dh_installlogrotate
+#	dh_installemacsen
+#	dh_installpam
+#	dh_installmime
+#	dh_installinit
+#	dh_installcron
+#	dh_installinfo
+#	dh_installman
+	dh_link 
+	chmod 600 $(CURDIR)/debian/piwi/etc/piwi/config.pl
+#	dh_link  usr/share/piwi/Profiles etc/piwi/Profiles
+#	dh_strip
+	dh_compress
+	dh_fixperms -Xetc/piwi/config.pl
+	dh_perl
+#	dh_python
+#	dh_makeshlibs
+	dh_installdeb
+#	dh_shlibdeps
+	dh_gencontrol
+	dh_md5sums
+	dh_builddeb
+
+binary: binary-indep 
+.PHONY: build clean binary-indep binary-arch binary install configure
