Author: tille
Date: 2009-02-05 16:37:27 +0000 (Thu, 05 Feb 2009)
New Revision: 3084
Modified:
trunk/packages/mlstdbnet/trunk/debian/patches/20_curate_sql_fixes.patch
Log:
Part of the patch was just useless.
Modified:
trunk/packages/mlstdbnet/trunk/debian/patches/20_curate_sql_fixes.patch
===================================================================
--- trunk/packages/mlstdbnet/trunk/debian/patches/20_curate_sql_fixes.patch
2009-02-05 12:23:10 UTC (rev 3083)
+++ trunk/packages/mlstdbnet/trunk/debian/patches/20_curate_sql_fixes.patch
2009-02-05 16:37:27 UTC (rev 3084)
@@ -1,20 +1,10 @@
--- mlstdbnet_v2.0.0.orig/cgi-bin/curate.pl
+++ mlstdbnet_v2.0.0/cgi-bin/curate.pl
-@@ -842,7 +842,8 @@
- sub curator_name {
- my $username = $q->remote_user;
- if ($username) {
-- my $qry = "SELECT first_name, surname FROM users WHERE
user_name=?";
-+ # String needs quoting - at least in PostgreSQL 8.3
-+ my $qry = "SELECT first_name, surname FROM users WHERE
user_name='?'";
- my $sql = $db->prepare($qry) or die "cannot prepare";
- $sql->execute($username);
- my @name = $sql->fetchrow_array;
@@ -1286,6 +1287,8 @@
sub stExists {
my ($st) = @_;
-+ # In case of an empty database return 0
++ # In case of an empty $st string return 0
+ if ( ! $st ) { return 0 ; }
my ($num) = &runSimpleQuery("SELECT COUNT(*) FROM profiles WHERE
st=$st");
return $num;
_______________________________________________
debian-med-commit mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/debian-med-commit
