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