[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;