[Upcase-project-cvs] UpCase/lib uc_sql-mysql.inc,1.9,1.10

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

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