Update of /cvsroot/upcase-project/UpCase/lib
In directory sc8-pr-cvs1:/tmp/cvs-serv23843
Modified Files:
uc_sql-mysql.inc
Log Message:
added queries to handle package manifest and variables stored in th db
Index: uc_sql-mysql.inc
===================================================================
RCS file: /cvsroot/upcase-project/UpCase/lib/uc_sql-mysql.inc,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** uc_sql-mysql.inc 28 Nov 2002 14:23:24 -0000 1.9
--- uc_sql-mysql.inc 4 Dec 2002 09:00:44 -0000 1.10
***************
*** 91,94 ****
--- 91,95 ----
// INSTALLER
$installer_tbl = $ucConfig->tblPrefix . $ucConfig->dbTables["installer"];
+ $files_tbl = $ucConfig->tblPrefix . $ucConfig->dbTables["files"];
$ucsql_packagestatus = "SELECT * FROM $installer_tbl WHERE pkgname = '%s'"
. " AND pkgversion LIKE '%s'"
***************
*** 97,106 ****
. " AND pkgversion LIKE '%s' AND pkgpath LIKE '%s'"
. " AND tblprefix LIKE '%s' AND installed LIKE '%s'";
$ucsql_packageregister = "INSERT INTO $installer_tbl"
. " (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'"
--- 98,107 ----
. " AND pkgversion LIKE '%s' AND pkgpath LIKE '%s'"
. " AND tblprefix LIKE '%s' AND installed LIKE '%s'";
+ $ucsql_getpackagebyid = "SELECT * FROM $installer_tbl WHERE appid = '%s'";
$ucsql_packageregister = "INSERT INTO $installer_tbl"
. " (pkgname, pkgversion, pkgpath, tblprefix)"
. " VALUES ('%s', '%s', '%s', '%s')";
$ucsql_packageunregister = "DELETE FROM $installer_tbl"
! . " WHERE appid = '%s'";
$ucsql_packageinstcomp = "UPDATE $installer_tbl SET installed = '1'"
. " WHERE pkgname = '%s' AND pkgversion = '%s'"
***************
*** 108,111 ****
$ucsql_packageinstalled = "SELECT * FROM $installer_tbl"
. " WHERE pkgname LIKE '%s' AND installed = '1'";
!
?>
--- 109,120 ----
$ucsql_packageinstalled = "SELECT * FROM $installer_tbl"
. " WHERE pkgname LIKE '%s' AND installed = '1'";
! $ucsql_packagemanifest = "INSERT INTO $files_tbl"
! . " (appid, type, filename, checksum, mtime, mode) VALUES ";
! $ucsql_rmmanifest = "DELETE FROM $files_tbl WHERE appid = '%s'";
! $ucsql_getfiles = "SELECT * FROM $files_tbl WHERE appid = '%s'"
! . " ORDER BY filename DESC";
!
! $vars_tbl = $ucConfig->tblPrefix . $ucConfig->dbTables["vars"];
! $ucsql_getvars = "SELECT VALUE FROM $vars_tbl WHERE name = '%s'";
! $ucsql_setvars = "UPDATE $vars_tbl SET value = '%s' WHERE name = '%s'";
?>
|
