[Upcase-project-cvs] UpCase/lib uc_sql-mysql.inc,1.4,1.5

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

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

Modified Files:
	uc_sql-mysql.inc 
Log Message:
added requests for groups, sessions and packages handling


Index: uc_sql-mysql.inc
===================================================================
RCS file: /cvsroot/upcase-project/UpCase/lib/uc_sql-mysql.inc,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** uc_sql-mysql.inc	8 Aug 2002 13:54:39 -0000	1.4
--- uc_sql-mysql.inc	12 Nov 2002 11:10:01 -0000	1.5
***************
*** 10,13 ****
--- 10,16 ----
  $ucsql_groupget = "SELECT * FROM $groups_tbl WHERE groupname='%s'";
  $ucsql_allgroups = "SELECT * FROM $groups_tbl";
+ $ucsql_primarygroup = "SELECT $groups_tbl.gid FROM $users_tbl, $groups_tbl"
+ 				. " WHERE $groups_tbl.groupname='%s'"
+ 				. " AND $users_tbl.groupid = $groups_tbl.gid";
  
  
***************
*** 42,45 ****
--- 45,49 ----
  $ucsql_memberadd = "INSERT INTO $members_tbl (gid, uid) VALUES ('%s', '%s')";
  $ucsql_memberdel = "DELETE FROM $members_tbl WHERE gid = '%s' AND uid = '%s'";
+ $ucsql_memgrpdel = "DELETE FROM $members_tbl WHERE gid = '%s'";
  $ucsql_memberrm = "DELETE FROM $members_tbl WHERE uid='%s'";
  
***************
*** 70,75 ****
--- 74,93 ----
  $ucsql_sessionlogin = "UPDATE $session_tbl SET logged_in = 1, uid = '%s'"
  					. " WHERE sessid = '%s'";
+ $ucsql_sessionlogout = "UPDATE $session_tbl SET logged_in = 0, uid = NULL"
+ 					. " WHERE sessid = '%s'";
  $ucsql_sessionsetip = "UPDATE $session_tbl SET ip = '%s'"
  					. " WHERE sessid = '%s'";
+ $ucsql_sessioncreate = "INSERT INTO $session_tbl (sessid) values ('%s')";
+ $ucsql_sessiondestroy = "DELETE FROM $session_tbl WHERE sessid='%s'";
+ 
+ // INSTALLER
+ $installer_tbl = $ucConfig->tblPrefix . $ucConfig->dbTables["installer"];
+ $ucsql_packagestatus = "SELECT * FROM $installer_tbl WHERE pkgname = '%s'";
+ $ucsql_packageregister = "INSERT INTO $installer_tbl"
+ 					. " (pkgname, pkgversion, pkgpath, tblprefix)"
+ 					. " VALUES ('%s', '%s', '%s', '%s')";
+ $ucsql_packageinstcomp = "UPDATE $installer_tbl SET installed = '1'"
+ 					. " WHERE pkgname = '%s' AND pkgversion = '%s'"
+ 					. " AND pkgpath = '%s' AND tblprefix = '%s'";
  
  ?>