[Upcase-project-cvs] UpCase/lib uc_sql-mysql.inc,1.6,1.7

[<jhe...@us...>]

Update of /cvsroot/upcase-project/UpCase/lib
In directory sc8-pr-cvs1:/tmp/cvs-serv18251

Modified Files:
	uc_sql-mysql.inc 
Log Message:
query to unregister a package, query to get list of fully installed packages


Index: uc_sql-mysql.inc
===================================================================
RCS file: /cvsroot/upcase-project/UpCase/lib/uc_sql-mysql.inc,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** uc_sql-mysql.inc	20 Nov 2002 12:53:35 -0000	1.6
--- uc_sql-mysql.inc	20 Nov 2002 15:57:15 -0000	1.7
***************
*** 89,95 ****
--- 89,100 ----
  					. " (pkgname, pkgversion, pkgpath, tblprefix)"
  					. " VALUES ('%s', '%s', '%s', '%s')";
+ $ucsql_packageunregister = "DELETE FROM $installer_tbl"
+ 					. " WHERE pkgname = '%s' AND  pkgversion = '%s'"
+ 					. " AND pkgpath = '%s' AND  tblprefix = '%s'";
  $ucsql_packageinstcomp = "UPDATE $installer_tbl SET installed = '1'"
  					. " WHERE pkgname = '%s' AND pkgversion = '%s'"
  					. " AND pkgpath = '%s' AND tblprefix = '%s'";
+ $ucsql_packageinstalled = "SELECT * FROM $installer_tbl"
+ 					. " WHERE pkgname LIKE '%s' AND installed = '1'";
  
  ?>