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'";
?>
|