[Koha-cvs] koha/C4/Circulation Fines.pm

[Chris Cormack]

CVSROOT:        /sources/koha
Module name:    koha
Changes by:     Chris Cormack <rangi>   06/07/12 09:15:27

Modified files:
        C4/Circulation : Fines.pm 

Log message:
        Fixing bad sql

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Circulation/Fines.pm?cvsroot=koha&r1=1.13&r2=1.14

Patches:
Index: Fines.pm
===================================================================
RCS file: /sources/koha/koha/C4/Circulation/Fines.pm,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -b -r1.13 -r1.14
--- Fines.pm    7 Jun 2006 01:32:06 -0000       1.13
+++ Fines.pm    12 Jul 2006 09:15:26 -0000      1.14
@@ -1,6 +1,6 @@
 package C4::Circulation::Fines;
 
-# $Id: Fines.pm,v 1.13 2006/06/07 01:32:06 rangi Exp $
+# $Id: Fines.pm,v 1.14 2006/07/12 09:15:26 rangi Exp $
 
 # Copyright 2000-2002 Katipo Communications
 #
@@ -155,11 +155,12 @@
     # categoryitem table.
 
     my $sth = $dbh->prepare(
-"Select * from items,biblioitems,itemtypes,issuingrules where 
items.itemnumber=?
-  and items.biblioitemnumber=biblioitems.biblioitemnumber and
-  biblioitems.itemtype=itemtypes.itemtype and
-  categoryitem.itemtype=itemtypes.itemtype and
-  categoryitem.categorycode=? and (items.itemlost <> 1 or items.itemlost is 
NULL)"
+"SELECT * FROM items,biblioitems,itemtypes,issuingrules
+  WHERE items.itemnumber=?
+  AND items.biblioitemnumber=biblioitems.biblioitemnumber 
+  AND biblioitems.itemtype=itemtypes.itemtype 
+  AND issuingrules.itemtype=itemtypes.itemtype 
+  AND issuingrules.categorycode=? AND  (items.itemlost <> 1 OR items.itemlost 
is NULL)"
     );
 
     #  print $query;