From 7ba9adba43c6cba93bfb8c866d74c4b6396ba7f5 Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Mon, 22 Aug 2005 22:26:26 +0000
Subject: [PATCH] Remove sid related queries.

---
 server/queries2.c | 159 ----------------------------------------------
 1 file changed, 159 deletions(-)

diff --git a/server/queries2.c b/server/queries2.c
index 538a3c65..6a682fbe 100644
--- a/server/queries2.c
+++ b/server/queries2.c
@@ -3486,80 +3486,6 @@ static struct validate _sdl_validate =
   _sdl_followup,
 };
 
-static char *gusl_fields[] = {
-  "login", "domain_sid", 
-  "login", "sid", "created",
-};
-
-static struct validate gusl_validate =
-{
-  VOuser0,
-  1,
-  NULL,
-  NULL,
-  0,
-  0,
-  0,
-  0,
-  0,
-};
-
-static char *glsn_fields[] = {
-  "name", "domain_sid",
-  "name", "sid", "created",
-};
-
-static struct validate glsn_validate = 
-{
-  VOlist0,
-  1,
-  NULL,
-  NULL,
-  0,
-  0,
-  0,
-  0,
-  0,
-};
-
-static char *ausl_fields[] = {
-  "login", "sid",
-};
-
-static struct validate ausl_validate =
-{
-  VOuser0,
-  1,
-  "sid",
-  "users_id = %d AND sid = '%s'",
-  2,
-  0,
-  0,
-  0,
-  0,
-};
-
-static char *alsn_fields[] = {
-  "name", "sid",
-};
-
-static struct validate alsn_validate =
-{
-  VOlist0,
-  1,
-  "sid",
-  "list_id = %d AND sid = '%s'",
-  2,
-  0,
-  0,
-  0,
-  0,
-};
-
-static char *gdds_fields[] = {
-  "sid",
-};
-
 static char *gcon7_fields[] = {
   "name",
   "name", "description", "location", "contact",
@@ -7428,91 +7354,6 @@ struct query Queries[] = {
     &_sdl_validate,
   },
 
-  {
-    /* Q_GUSL - GET_USER_SIDS_BY_LOGIN, v4 */
-    "get_user_sids_by_login",
-    "gusl",
-    4,
-    RETRIEVE,
-    "s",
-    USERSIDS_TABLE,
-    "u.login, us.sid, TO_CHAR(us.created, 'YYYY-MM-DD HH24:MI:SS') FROM users u, usersids us",
-    gusl_fields,
-    3,
-    "us.users_id = %d AND u.users_id = us.users_id AND SUBSTR(us.sid, 1, LENGTH(us.sid)-8) = '%s'",
-    2,
-    NULL,
-    &gusl_validate,
-  },
-
-  {
-    /* Q_AUSL - ADD_USER_SID_BY_LOGIN, v4 */
-    "add_user_sid_by_login",
-    "ausl",
-    4,
-    APPEND,
-    "s",
-    USERSIDS_TABLE,
-    "INTO usersids (users_id, sid) VALUES (%d, '%s')",
-    ausl_fields,
-    2,
-    NULL,
-    0,
-    NULL,
-    &ausl_validate,
-  },
-  
-  {
-    /* Q_GLSN - GET_LIST_SIDS_BY_NAME, v4 */
-    "get_list_sids_by_name",
-    "glsn",
-    4,
-    RETRIEVE,
-    "s",
-    LISTSIDS_TABLE,
-    "l.name, ls.sid, TO_CHAR(ls.created, 'YYYY-MM-DD HH24:MI:SS') FROM list l, listsids ls",
-    glsn_fields,
-    3,
-    "ls.list_id = %d AND l.list_id = ls.list_id AND SUBSTR(ls.sid, 1, LENGTH(ls.sid)-8) = '%s'",
-    2,
-    NULL,
-    &glsn_validate,
-  },
-
-  {
-    /* Q_ALSN - ADD_LIST_SID_BY_NAME, v4 */
-    "add_list_sid_by_name",
-    "alsn",
-    4,
-    APPEND,
-    "s",
-    LISTSIDS_TABLE,
-    "INTO listsids (list_id, sid) VALUES (%d, '%s')",
-    alsn_fields,
-    2,
-    NULL,
-    0,
-    NULL,
-    &alsn_validate,
-  },
-
-  {
-    /* Q_GDDS - GET_DISTINCT_DOMAIN_SIDS, v4 */
-    "get_distinct_domain_sids",
-    "gdds",
-    4,
-    RETRIEVE,
-    "s",
-    USERSIDS_TABLE,
-    "DISTINCT SUBSTR(sid, 1, LENGTH(sid)-8) FROM usersids",
-    gdds_fields,
-    1,
-    NULL,
-    0,
-    NULL,
-    NULL,
-  },
-
   {
     /* Q_GCON - GET_CONTAINER, v7 */
     "get_container",
-- 
2.45.1