[moira.git] / regtape / employee.dc

/* $Header$
 */

#include <stdio.h>
#include <strings.h>
#include <ctype.h>
#include <sys/time.h>
#include <moira.h>
#include <moira_site.h>
EXEC SQL INCLUDE sqlca;


#define WHO 11859		/* root */
#define PROG "emp-tape"

#define MAX_ID_VALUE	31999
#define MIN_ID_VALUE	101

/* File format is:

0-8	id number
9-38	name
39-62	office address
63-74	phone1
75-86	phone2
87-106	dept
107-156	title
157-186	username
187-241	host

*/

#define LOC_ID 0
#define LOC_NAME 9
#define LOC_OFFICE 39
#define LOC_PHONE 63
#define LOC_PHONE2 75
#define LOC_DEPT 87
#define LOC_TITLE 107
#define LOC_USERNAME 157
#define LOC_HOST 187

#define LEN_ID 9
#define LEN_NAME 30
#define LEN_OFFICE 24
#define LEN_PHONE 12
#define LEN_PHONE2 12
#define LEN_DEPT 20
#define LEN_TITLE 50
#define LEN_USERNAME 30
#define LEN_HOST 55


struct entry {
    char *name;
    char *last;
    char *first;
    char *middle;
    char *title;
    char *class;
    char *id;
    char *eid;
    char *dept;
    char *address;
    char *phone;
    char *phone2;
    char *email;
};


char *whoami;
int newfinger = 0;

#define sqlfail() (sqlca.sqlcode && sqlca.sqlcode != 100)
#define SQL_DUPLICATE -40100
#define SQL_DEADLOCK -49900


main(argc, argv)
int argc;
char **argv;
{
    FILE *in;
    struct entry *e, *get_next_entry();
    int i, wait = 0;
    char buf[BUFSIZ], *file = NULL;

    whoami = rindex(argv[0], '/');
    if (whoami)
      whoami++;
    else
      whoami = argv[0];

    for (i = 1; i < argc; i++) {
	if (!strcmp(argv[i], "-w"))
	  wait++;
	else if (!strcmp(argv[i], "-D"))
	  setenv("ING_SET", "set printqry");
	else if (!strcmp(argv[i], "-n"))
	  newfinger++;
	else if (file != NULL)
	  fprintf(stderr, "Usage: %s [-w] [-D] [-n] inputfile\n", whoami);
	else
	  file = argv[i];
    }

    in = fopen(file, "r");
    if (in == NULL) {
	fprintf(stderr, "Unable to open %s for input\n", file);
	exit(1);
    }

    setlinebuf(stdout);
    setlinebuf(stderr);
    initialize_sms_error_table();

    EXEC SQL CONNECT moira;
    if (sqlca.sqlcode != 0) {
	com_err(whoami, 0, "ingres error %d opening database", sqlca.sqlcode);
	exit(1);
    }

    while (e = get_next_entry(in)) {
    again:
	process_entry(e);
	EXEC SQL COMMIT WORK;
	if (sqlca.sqlcode != 0) {
            if (sqlca.sqlcode == SQL_DEADLOCK) {
                com_err(whoami, MR_DEADLOCK, "commiting work");
                goto again;
            } else {
                com_err(whoami, 0, "ingres error %d committing work", sqlca.sqlcode);
                exit(1);
            }
	}
	if (wait) {
	    printf("Next");
	    fflush(stdout);
	    gets(buf);
	}
    }

    exit(0);
}


char *substr(buf, key)
char *buf;
char *key;
{
    int l;

    for (l = strlen(key); *buf; buf++)
      if (!strncmp(buf, key, l))
	return(buf);
    return(NULL);
}


struct entry *get_next_entry(in)
FILE *in;
{
    static struct entry e;
    static char buf[BUFSIZ], mid[16], eid[16], email[256];
    static char name[LEN_NAME+1], sname[LEN_NAME+1], id[LEN_ID+1];
    static char office[LEN_OFFICE+1], phone[LEN_PHONE+1], phone2[LEN_PHONE2+1];
    static char dept[LEN_DEPT+1], title[LEN_TITLE+1], username[LEN_USERNAME+1];
    static char host[LEN_HOST+1];
    int ends_sr, ends_jr, ends_iii, ends_iv, ends_ii, ends_v;
    char *p;

    if (fgets(buf, sizeof(buf), in) == NULL)
      return((struct entry *)NULL);

    strncpy(id, &buf[LOC_ID], LEN_ID); id[LEN_ID] = 0;
    strncpy(name, &buf[LOC_NAME], LEN_NAME); name[LEN_NAME] = 0;
    strncpy(office, &buf[LOC_OFFICE], LEN_OFFICE); office[LEN_OFFICE] = 0;
    strncpy(phone, &buf[LOC_PHONE], LEN_PHONE); phone[LEN_PHONE] = 0;
    strncpy(phone2, &buf[LOC_PHONE2], LEN_PHONE2); phone2[LEN_PHONE2] = 0;
    strncpy(dept, &buf[LOC_DEPT], LEN_DEPT); dept[LEN_DEPT] = 0;
    strncpy(title, &buf[LOC_TITLE], LEN_TITLE); title[LEN_TITLE] = 0;
    strncpy(username, &buf[LOC_USERNAME], LEN_USERNAME); username[LEN_USERNAME] = 0;
    strncpy(host, &buf[LOC_HOST], LEN_HOST); host[LEN_HOST] = 0;

    strcpy(sname, name);
    e.name = strtrim(sname);
    p = index(name, ',');
    if (p)
      *p = 0;
    e.last = strtrim(name);
    if (p) {
	p++;
	while (isspace(*p))
	  p++;
	e.first = p;
	if (p = index(e.first, ' ')) {
	    *p = 0;
	    e.first = strtrim(e.first);
	    e.middle = strtrim(p + 1);
	} else {
	    e.first = strtrim(e.first);
	    e.middle = "";
	}
    } else {
	e.first = "";
	e.middle = "";
    }
    ends_sr = ends_jr = ends_iii = ends_iv = ends_ii = ends_v = 0;
    LookForSt(e.last);
    LookForO(e.last);
    LookForJrAndIII(e.last, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
		    &ends_ii, &ends_v);
    LookForJrAndIII(e.first, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
		    &ends_ii, &ends_v);
    FixCase(e.last);
    FixCase(e.first);
    FixCase(e.middle);

    e.id = id;
    e.eid = eid;
    EncryptID(e.eid, e.id, e.first, e.last);

    e.address = strtrim(office);
    e.phone = strtrim(phone);
    e.phone2 = strtrim(phone2);
    e.dept = strtrim(dept);
    e.title = strtrim(title);

    e.class = "MITS";
    if (substr(e.title, "PROF") || substr(e.title, "LECTURE"))
      e.class = "FACULTY";

    strcpy(email, strtrim(username));
    if (host[0] == '@')
      strncat(email, strtrim(host));
    e.email = email;

    return(&e);
}


process_entry(e)
struct entry *e;
{
    int changed, nochange, encrypted;
    char buf[BUFSIZ], *from, *to;
    EXEC SQL BEGIN DECLARE SECTION;
    char *first, *last, *middle, *eid, *sid, *name, *title, *phone2, *rdept, *rtitle;
    char *raddr, *rhphone, *rophone, *prog;
    char class[9], oaddr[25], ophone[17], dept[128], dfirst[17], dlast[17], dmiddle[17];
    int id, status, who;
    EXEC SQL END DECLARE SECTION;

    /* Don't process Lincoln Labs */
    if (!strncmp(e->address, "LL", 2))
      return;

    who = WHO;
    prog = PROG;
    first = e->first;
    if (strlen(first) > 16)
      first[16] = 0;
    last = e->last;
    if (strlen(last) > 16)
      last[16] = 0;
    middle = e->middle;
    eid = e->eid;
    sid = e->id;
    id = 0;
    encrypted = 0;

    /* Get user info */
    EXEC SQL SELECT users_id, first, last, middle, type, office_addr, office_phone, department, status
      INTO :id, :dfirst, :dlast, :dmiddle, :class, :oaddr, :ophone, :dept, :status
      FROM users
      WHERE clearid = :sid;
    if (sqlfail()) {
	if (sqlca.sqlcode == SQL_DUPLICATE) {
	    com_err(whoami, 0, "duplicate ID number %s on user %s %s", sid, first, last);
	    return;
        } else if (sqlca.sqlcode == SQL_DEADLOCK) {
            com_err(whoami, MR_DEADLOCK, "looking up user %s", sid);
            EXEC SQL ROLLBACK;
            return process_entry(e);
	} else
	  sqlexit();
    }
    if (id == 0) {
	EXEC SQL SELECT users_id, first, last, middle, type, office_addr, office_phone, department, status
	  INTO :id, :dfirst, :dlast, :dmiddle, :class, :oaddr, :ophone, :dept, :status
	  FROM users
	  WHERE last = :last and first = :first and clearid = :eid;
        if (sqlfail()) {
            if (sqlca.sqlcode == SQL_DEADLOCK) {
                com_err(whoami, MR_DEADLOCK, "looking up user %s", sid);
                EXEC SQL ROLLBACK;
                return process_entry(e);
            } else if (sqlca.sqlcode != SQL_DUPLICATE)
              sqlexit();
        }
	encrypted++;
	if (id == 0) {
	    newuser(e);
	    return;
	}
    }

    /* Update class/state if necessary.  (Exclude several spacial cases.) */
    if (strcmp(e->class, strtrim(class)) &&
	strcmp(class, "STAFF") && strcmp(class, "SIPBMEM") &&
	strcmp(class, "KNIGHT")) {
	com_err(whoami, 0, "updating class for %s %s from %s to %s",
		first, last, class, e->class);
	if (status == US_NOT_ALLOWED)
	  status = US_NO_LOGIN_YET;
	if (status == US_ENROLL_NOT_ALLOWED)
	  status = US_ENROLLED;
	strcpy(class, e->class);
	EXEC SQL UPDATE users
	  SET type = :class, status = :status, modtime = 'now',
		modby = :who, modwith = :prog
	  WHERE users_id = :id;
	if (sqlca.sqlcode != 0) {
            if (sqlca.sqlcode == SQL_DEADLOCK) {
                com_err(whoami, MR_DEADLOCK, "updating user");
		return;
            } else {
                com_err(whoami, 0, "ingres error %d updating user", sqlca.sqlcode);
                exit(1);
	    }
	}
    }

    /* Update name if necessary */
    if (strcmp(first, strtrim(dfirst)) ||
	strcmp(last, strtrim(dlast)) ||
	strcmp(middle, strtrim(dmiddle))) {
	com_err(whoami, 0, "updating real name for %s %s", first, last);
	EXEC SQL UPDATE users
	  SET first = :first, last = :last, middle = :middle,
	  	modby = :who, modwith = :prog, modtime = 'now'
	  WHERE users_id = :id;
	if (sqlca.sqlcode != 0) {
            if (sqlca.sqlcode == SQL_DEADLOCK) {
                com_err(whoami, MR_DEADLOCK, "updating name");
		return;
            } else {
                com_err(whoami, 0, "ingres error %d updating name", sqlca.sqlcode);
                exit(1);
            }
	}
    }

    changed = nochange = 0;
    if (encrypted) changed++;
    strcpy(buf, e->address);
    while (to = index(buf, ','))
      *to = ';';
    while (to = index(buf, ':'))
      *to = ';';
    if (newfinger) {
	if (oaddr[0] == ' ' && buf[0]) {
	    strncpy(oaddr, buf, 16);
	    oaddr[16] = 0;
	    changed++;
	} else if (strncmp(strtrim(oaddr), buf, 15))
	  nochange++;
    } else {
	if (strncmp(strtrim(oaddr), buf, 15))
	  changed++;
	strncpy(oaddr, buf, 16);
	oaddr[16] = 0;
    }
    from = e->phone;
    to = buf;
    while (*from) {
	if (isdigit(*from))
	  *to++ = *from;
	from++;
    }
    *to = 0;
    if (newfinger) {
	if (ophone[0] == ' ') {
	    strncpy(ophone, buf, 16);
	    ophone[16] = 0;
	} else if (strncmp(strtrim(ophone), buf, 11))
	  nochange++;
    } else {
	if (strncmp(strtrim(ophone), buf, 11))
	  changed++;
	strncpy(ophone, buf, 16);
	ophone[16] = 0;
    }
    FixCase(e->dept);
    FixCase(e->title);
    if (newfinger) {
	if (dept[0] == ' ') {
	    strncpy(dept, e->dept, 12);
	    dept[12] = 0;
	} else if (strncmp(strtrim(dept), e->dept, 11))
	  nochange++;
    } else {
	if (strncmp(strtrim(dept), e->dept, 11))
	  changed++;
	strncpy(dept, e->dept, 12);
	dept[12] = 0;
    }
    sid = e->id;
    name = e->name;
    rdept = e->dept;
    rtitle = e->title;
    raddr = e->address;
    rhphone = e->phone;
    rophone = e->phone2;
    if (changed) {
	com_err(whoami, 0, "updating finger for %s %s", first, last);
	EXEC SQL REPEATED UPDATE users
	  SET office_addr = :oaddr, office_phone = :ophone, department = :dept,
	    fmodtime = 'now', fmodby = :who, fmodwith = :prog,
	    xname = :name, xdept = :rdept, xtitle = :rtitle,
	    xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
	    xmodtime = 'now', clearid = :sid
	  WHERE users_id = :id;
	if (sqlca.sqlcode != 0) {
            if (sqlca.sqlcode == SQL_DEADLOCK) {
                com_err(whoami, MR_DEADLOCK, "updating user %s", sid);
                EXEC SQL ROLLBACK;
                return process_entry(e);
            } else {
                com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
                exit(1);
            }
	}
    } else {
	EXEC SQL REPEATED UPDATE users
	  SET xname = :name, xdept = :rdept, xtitle = :rtitle,
	    xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
	    xmodtime = 'now', clearid = :sid
	  WHERE users_id = :id;
	if (sqlca.sqlcode != 0) {
            if (sqlca.sqlcode == SQL_DEADLOCK) {
                com_err(whoami, MR_DEADLOCK, "updating user %s", sid);
                EXEC SQL ROLLBACK;
                return process_entry(e);
            } else {
                com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
                exit(1);
            }
	}
    }
}


newuser(e)
struct entry *e;
{
    char *from, *to;
    EXEC SQL BEGIN DECLARE SECTION;
    int id, uid, st, who;
    char *last, *first, *class, *middle, login[9], *sid, fullname[65], *prog;
    char oaddr[81], ophone[17], dept[128], *name, *title, phone2[17];
    char *rdept, *rhphone, *rophone;
    EXEC SQL END DECLARE SECTION;

    who = WHO;
    prog = PROG;
    strncpy(oaddr, e->address, 16);
    oaddr[16] = 0;
    while (to = index(oaddr, ','))
      *to = ';';
    while (to = index(oaddr, ':'))
      *to = ';';
    from = e->phone;
    to = ophone;
    while (*from) {
	if (isdigit(*from))
	  *to++ = *from;
	from++;
    }
    *to = 0;
    FixCase(e->dept);
    strncpy(dept, e->dept, 12);
    dept[12] = 0;
    
    id = set_next_users_id(0);
    uid = set_next_uid(1);
    sprintf(login, "#%d", uid);
    last = e->last;
    first = e->first;
    middle = e->middle;
    class = e->class;
    if (*middle)
      sprintf(fullname, "%s %s %s", first, middle, last);
    else
      sprintf(fullname, "%s %s", first, last);
    st = US_NO_LOGIN_YET;

    sid = e->id;
    name = e->name;
    rdept = e->dept;
    title = e->title;
    rhphone = e->phone;
    rophone = e->phone2;

    EXEC SQL REPEATED INSERT INTO users
      (login, users_id, uid, shell, last, first, middle, status,
       clearid, type, modtime, modby, modwith, fullname, office_addr,
       office_phone, department, fmodtime, fmodby, fmodwith,
       potype, xname, xdept, xtitle, xaddress, xphone1, xphone2, xmodtime)
      VALUES (:login, :id, :uid, '/bin/athena/tcsh', :last, :first,
	      :middle, :st, :sid, :class, 'now', :who, :prog,
	      :fullname, :oaddr, :ophone, :dept, 'now', :who, :prog,
	      'NONE', :name, :rdept, :title, :oaddr, :rhphone,
	      :rophone, 'now');
    if (sqlca.sqlcode != 0) {
	if (sqlca.sqlcode == SQL_DEADLOCK) {
	    com_err(whoami, MR_DEADLOCK, "adding user");
	} else {
	    com_err(whoami, 0, "ingres error %d adding user", sqlca.sqlcode);
	    exit(1);
	}
    } else
      com_err(whoami, 0, "adding user %s %s", e->first, e->last);
}


set_next_users_id(limit)
    int limit;
{
    EXEC SQL BEGIN DECLARE SECTION;
    int rowcount, flag, value, retval;
    EXEC SQL END DECLARE SECTION;

    EXEC SQL REPEATED SELECT value INTO :value FROM numvalues 
      WHERE name = 'users_id';
    if (sqlfail()) sqlexit();
    if (sqlca.sqlerrd[2] != 1) {
	EXEC SQL ROLLBACK;
	com_err(whoami, MR_INTERNAL, "values table inconsistancy");
	exit(1);
    }

    flag = 0;
    EXEC SQL REPEATED SELECT users_id INTO :flag FROM users
      WHERE users_id = :value;
    if (sqlfail()) sqlexit();
    if (sqlca.sqlerrd[2] == 0)
      flag = 0;
    while (flag) {
	value++;
	if (limit && value > MAX_ID_VALUE)
	    value = MIN_ID_VALUE;
	flag = 0;
	EXEC SQL REPEATED SELECT users_id INTO :flag FROM users 
	  WHERE users_id = :value;
	if (sqlfail()) sqlexit();
	if (sqlca.sqlerrd[2] == 0)
	  flag = 0;
    }

    retval = value++;
    if (limit && value > MAX_ID_VALUE)
      value = MIN_ID_VALUE;
    EXEC SQL REPEATED UPDATE numvalues SET value = :value
      WHERE name = 'users_id';
    if (sqlca.sqlcode != 0) {
	com_err(whoami, 0, "ingres error %d assigning ID", sqlca.sqlcode);
	exit(1);
    }
    return(retval);
}

set_next_uid(limit)
    int limit;
{
    EXEC SQL BEGIN DECLARE SECTION;
    int rowcount, flag, value, retval;
    EXEC SQL END DECLARE SECTION;

    EXEC SQL REPEATED SELECT value INTO :value FROM numvalues 
      WHERE name = 'uid';
    if (sqlfail()) sqlexit();
    if (sqlca.sqlerrd[2] != 1) {
	EXEC SQL ROLLBACK;
	com_err(whoami, MR_INTERNAL, "values table inconsistancy");
	exit(1);
    }

    flag = 0;
    EXEC SQL REPEATED SELECT uid INTO :flag FROM users WHERE uid = :value;
    if (sqlfail()) sqlexit();
    if (sqlca.sqlerrd[2] == 0)
      flag = 0;
    while (flag) {
	value++;
	if (limit && value > MAX_ID_VALUE)
	    value = MIN_ID_VALUE;
	flag = 0;
	EXEC SQL REPEATED SELECT uid INTO :flag FROM users WHERE uid = :value;
	if (sqlfail()) sqlexit();
	if (sqlca.sqlerrd[2] == 0)
	  flag = 0;
    }

    retval = value++;
    if (limit && value > MAX_ID_VALUE)
      value = MIN_ID_VALUE;
    EXEC SQL REPEATED UPDATE numvalues SET value = :value WHERE name = 'uid';
    if (sqlca.sqlcode != 0) {
	com_err(whoami, 0, "ingres error %d assigning ID", sqlca.sqlcode);
	exit(1);
    }
    return(retval);
}


sqlexit()
{
    if (sqlca.sqlcode == SQL_DEADLOCK)
      com_err(whoami, MR_DEADLOCK, "unrecoverable ingres error %d",
              sqlca.sqlcode);
    else
      com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
    EXEC SQL ROLLBACK WORK;
    exit(1);
}
Commit	Line	Data
469f80df	1	/* $Header$
	2	*/
	3
	4	#include <stdio.h>
	5	#include <strings.h>
	6	#include <ctype.h>
	7	#include <sys/time.h>
932028de	8	#include <moira.h>
932028de	9	#include <moira_site.h>
02cd9ede	10	EXEC SQL INCLUDE sqlca;
469f80df	11
469f80df	12
02cd9ede	13	#define WHO 11859 /* root */
02cd9ede	14	#define PROG "emp-tape"
469f80df	15
397e9044	16	#define MAX_ID_VALUE 31999
469f80df	17	#define MIN_ID_VALUE 101
	18
	19	/* File format is:
	20
	21	0-8 id number
	22	9-38 name
	23	39-62 office address
	24	63-74 phone1
	25	75-86 phone2
	26	87-106 dept
	27	107-156 title
	28	157-186 username
	29	187-241 host
	30
	31	*/
	32
	33	#define LOC_ID 0
	34	#define LOC_NAME 9
	35	#define LOC_OFFICE 39
	36	#define LOC_PHONE 63
	37	#define LOC_PHONE2 75
	38	#define LOC_DEPT 87
	39	#define LOC_TITLE 107
	40	#define LOC_USERNAME 157
	41	#define LOC_HOST 187
	42
	43	#define LEN_ID 9
a6e9fead	44	#define LEN_NAME 30
a6e9fead	45	#define LEN_OFFICE 24
469f80df	46	#define LEN_PHONE 12
469f80df	47	#define LEN_PHONE2 12
a6e9fead	48	#define LEN_DEPT 20
	49	#define LEN_TITLE 50
	50	#define LEN_USERNAME 30
469f80df	51	#define LEN_HOST 55
	52
	53
	54	struct entry {
a6e9fead	55	char *name;
469f80df	56	char *last;
	57	char *first;
	58	char *middle;
	59	char *title;
	60	char *class;
	61	char *id;
	62	char *eid;
	63	char *dept;
	64	char *address;
	65	char *phone;
a6e9fead	66	char *phone2;
469f80df	67	char *email;
	68	};
	69
	70
	71	char *whoami;
	72	int newfinger = 0;
	73
3e77c6a3	74	#define sqlfail() (sqlca.sqlcode && sqlca.sqlcode != 100)
3e77c6a3	75	#define SQL_DUPLICATE -40100
6f1556b3	76	#define SQL_DEADLOCK -49900
3e77c6a3	77
469f80df	78
	79	main(argc, argv)
	80	int argc;
	81	char **argv;
02cd9ede	82	{
469f80df	83	FILE *in;
	84	struct entry e, get_next_entry();
	85	int i, wait = 0;
	86	char buf[BUFSIZ], *file = NULL;
	87
	88	whoami = rindex(argv[0], '/');
	89	if (whoami)
	90	whoami++;
	91	else
	92	whoami = argv[0];
	93
	94	for (i = 1; i < argc; i++) {
	95	if (!strcmp(argv[i], "-w"))
	96	wait++;
	97	else if (!strcmp(argv[i], "-D"))
	98	setenv("ING_SET", "set printqry");
	99	else if (!strcmp(argv[i], "-n"))
	100	newfinger++;
	101	else if (file != NULL)
325821e4	102	fprintf(stderr, "Usage: %s [-w] [-D] [-n] inputfile\n", whoami);
469f80df	103	else
	104	file = argv[i];
	105	}
	106
	107	in = fopen(file, "r");
	108	if (in == NULL) {
	109	fprintf(stderr, "Unable to open %s for input\n", file);
	110	exit(1);
	111	}
	112
325821e4	113	setlinebuf(stdout);
325821e4	114	setlinebuf(stderr);
2168fb4b	115	initialize_sms_error_table();
325821e4	116
02cd9ede	117	EXEC SQL CONNECT moira;
3e77c6a3	118	if (sqlca.sqlcode != 0) {
e33f9f21	119	com_err(whoami, 0, "ingres error %d opening database", sqlca.sqlcode);
3e77c6a3	120	exit(1);
3e77c6a3	121	}
469f80df	122
469f80df	123	while (e = get_next_entry(in)) {
9b2c129e	124	again:
469f80df	125	process_entry(e);
3e77c6a3	126	EXEC SQL COMMIT WORK;
3e77c6a3	127	if (sqlca.sqlcode != 0) {
6f1556b3	128	if (sqlca.sqlcode == SQL_DEADLOCK) {
	129	com_err(whoami, MR_DEADLOCK, "commiting work");
	130	goto again;
	131	} else {
e33f9f21	132	com_err(whoami, 0, "ingres error %d committing work", sqlca.sqlcode);
6f1556b3	133	exit(1);
6f1556b3	134	}
3e77c6a3	135	}
469f80df	136	if (wait) {
	137	printf("Next");
	138	fflush(stdout);
	139	gets(buf);
	140	}
	141	}
	142
469f80df	143	exit(0);
02cd9ede	144	}
469f80df	145
	146
	147	char *substr(buf, key)
	148	char *buf;
	149	char *key;
	150	{
	151	int l;
	152
	153	for (l = strlen(key); *buf; buf++)
	154	if (!strncmp(buf, key, l))
	155	return(buf);
	156	return(NULL);
	157	}
	158
	159
	160	struct entry *get_next_entry(in)
	161	FILE *in;
	162	{
	163	static struct entry e;
a6e9fead	164	static char buf[BUFSIZ], mid[16], eid[16], email[256];
	165	static char name[LEN_NAME+1], sname[LEN_NAME+1], id[LEN_ID+1];
	166	static char office[LEN_OFFICE+1], phone[LEN_PHONE+1], phone2[LEN_PHONE2+1];
	167	static char dept[LEN_DEPT+1], title[LEN_TITLE+1], username[LEN_USERNAME+1];
	168	static char host[LEN_HOST+1];
039f9637	169	int ends_sr, ends_jr, ends_iii, ends_iv, ends_ii, ends_v;
469f80df	170	char *p;
469f80df	171
4763be9c	172	if (fgets(buf, sizeof(buf), in) == NULL)
4763be9c	173	return((struct entry *)NULL);
a6e9fead	174
	175	strncpy(id, &buf[LOC_ID], LEN_ID); id[LEN_ID] = 0;
	176	strncpy(name, &buf[LOC_NAME], LEN_NAME); name[LEN_NAME] = 0;
	177	strncpy(office, &buf[LOC_OFFICE], LEN_OFFICE); office[LEN_OFFICE] = 0;
	178	strncpy(phone, &buf[LOC_PHONE], LEN_PHONE); phone[LEN_PHONE] = 0;
	179	strncpy(phone2, &buf[LOC_PHONE2], LEN_PHONE2); phone2[LEN_PHONE2] = 0;
	180	strncpy(dept, &buf[LOC_DEPT], LEN_DEPT); dept[LEN_DEPT] = 0;
	181	strncpy(title, &buf[LOC_TITLE], LEN_TITLE); title[LEN_TITLE] = 0;
	182	strncpy(username, &buf[LOC_USERNAME], LEN_USERNAME); username[LEN_USERNAME] = 0;
	183	strncpy(host, &buf[LOC_HOST], LEN_HOST); host[LEN_HOST] = 0;
	184
	185	strcpy(sname, name);
	186	e.name = strtrim(sname);
	187	p = index(name, ',');
469f80df	188	if (p)
469f80df	189	*p = 0;
a6e9fead	190	e.last = strtrim(name);
469f80df	191	if (p) {
a6e9fead	192	p++;
	193	while (isspace(*p))
	194	p++;
	195	e.first = p;
469f80df	196	if (p = index(e.first, ' ')) {
469f80df	197	*p = 0;
a6e9fead	198	e.first = strtrim(e.first);
469f80df	199	e.middle = strtrim(p + 1);
a6e9fead	200	} else {
	201	e.first = strtrim(e.first);
	202	e.middle = "";
	203	}
	204	} else {
	205	e.first = "";
	206	e.middle = "";
	207	}
039f9637	208	ends_sr = ends_jr = ends_iii = ends_iv = ends_ii = ends_v = 0;
469f80df	209	LookForSt(e.last);
469f80df	210	LookForO(e.last);
039f9637	211	LookForJrAndIII(e.last, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
	212	&ends_ii, &ends_v);
	213	LookForJrAndIII(e.first, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
	214	&ends_ii, &ends_v);
469f80df	215	FixCase(e.last);
	216	FixCase(e.first);
	217	FixCase(e.middle);
	218
a6e9fead	219	e.id = id;
469f80df	220	e.eid = eid;
	221	EncryptID(e.eid, e.id, e.first, e.last);
	222
a6e9fead	223	e.address = strtrim(office);
	224	e.phone = strtrim(phone);
	225	e.phone2 = strtrim(phone2);
	226	e.dept = strtrim(dept);
	227	e.title = strtrim(title);
469f80df	228
469f80df	229	e.class = "MITS";
41dd7d99	230	if (substr(e.title, "PROF") \|\| substr(e.title, "LECTURE"))
469f80df	231	e.class = "FACULTY";
469f80df	232
a6e9fead	233	strcpy(email, strtrim(username));
	234	if (host[0] == '@')
	235	strncat(email, strtrim(host));
	236	e.email = email;
469f80df	237
	238	return(&e);
	239	}
	240
	241
	242	process_entry(e)
	243	struct entry *e;
02cd9ede	244	{
3e77c6a3	245	int changed, nochange, encrypted;
469f80df	246	char buf[BUFSIZ], from, to;
02cd9ede	247	EXEC SQL BEGIN DECLARE SECTION;
3e77c6a3	248	char first, last, middle, eid, sid, name, title, phone2, rdept, rtitle;
	249	char raddr, rhphone, rophone, prog;
	250	char class[9], oaddr[25], ophone[17], dept[128], dfirst[17], dlast[17], dmiddle[17];
	251	int id, status, who;
02cd9ede	252	EXEC SQL END DECLARE SECTION;
469f80df	253
41dd7d99	254	/* Don't process Lincoln Labs */
	255	if (!strncmp(e->address, "LL", 2))
	256	return;
	257
3e77c6a3	258	who = WHO;
3e77c6a3	259	prog = PROG;
469f80df	260	first = e->first;
9e4455c2	261	if (strlen(first) > 16)
9e4455c2	262	first[16] = 0;
469f80df	263	last = e->last;
9e4455c2	264	if (strlen(last) > 16)
9e4455c2	265	last[16] = 0;
3e77c6a3	266	middle = e->middle;
469f80df	267	eid = e->eid;
325821e4	268	sid = e->id;
469f80df	269	id = 0;
3e77c6a3	270	encrypted = 0;
325821e4	271
325821e4	272	/* Get user info */
3e77c6a3	273	EXEC SQL SELECT users_id, first, last, middle, type, office_addr, office_phone, department, status
3e77c6a3	274	INTO :id, :dfirst, :dlast, :dmiddle, :class, :oaddr, :ophone, :dept, :status
02cd9ede	275	FROM users
3e77c6a3	276	WHERE clearid = :sid;
	277	if (sqlfail()) {
	278	if (sqlca.sqlcode == SQL_DUPLICATE) {
	279	com_err(whoami, 0, "duplicate ID number %s on user %s %s", sid, first, last);
	280	return;
6f1556b3	281	} else if (sqlca.sqlcode == SQL_DEADLOCK) {
	282	com_err(whoami, MR_DEADLOCK, "looking up user %s", sid);
	283	EXEC SQL ROLLBACK;
	284	return process_entry(e);
3e77c6a3	285	} else
	286	sqlexit();
	287	}
469f80df	288	if (id == 0) {
3e77c6a3	289	EXEC SQL SELECT users_id, first, last, middle, type, office_addr, office_phone, department, status
3e77c6a3	290	INTO :id, :dfirst, :dlast, :dmiddle, :class, :oaddr, :ophone, :dept, :status
02cd9ede	291	FROM users
02cd9ede	292	WHERE last = :last and first = :first and clearid = :eid;
6f1556b3	293	if (sqlfail()) {
	294	if (sqlca.sqlcode == SQL_DEADLOCK) {
	295	com_err(whoami, MR_DEADLOCK, "looking up user %s", sid);
	296	EXEC SQL ROLLBACK;
	297	return process_entry(e);
	298	} else if (sqlca.sqlcode != SQL_DUPLICATE)
	299	sqlexit();
	300	}
3e77c6a3	301	encrypted++;
325821e4	302	if (id == 0) {
	303	newuser(e);
	304	return;
	305	}
469f80df	306	}
325821e4	307
2168fb4b	308	/* Update class/state if necessary. (Exclude several spacial cases.) */
e1695a1c	309	if (strcmp(e->class, strtrim(class)) &&
2168fb4b	310	strcmp(class, "STAFF") && strcmp(class, "SIPBMEM") &&
2168fb4b	311	strcmp(class, "KNIGHT")) {
469f80df	312	com_err(whoami, 0, "updating class for %s %s from %s to %s",
469f80df	313	first, last, class, e->class);
2168fb4b	314	if (status == US_NOT_ALLOWED)
a6e9fead	315	status = US_NO_LOGIN_YET;
2168fb4b	316	if (status == US_ENROLL_NOT_ALLOWED)
a6e9fead	317	status = US_ENROLLED;
469f80df	318	strcpy(class, e->class);
02cd9ede	319	EXEC SQL UPDATE users
02cd9ede	320	SET type = :class, status = :status, modtime = 'now',
3e77c6a3	321	modby = :who, modwith = :prog
02cd9ede	322	WHERE users_id = :id;
3e77c6a3	323	if (sqlca.sqlcode != 0) {
e33f9f21	324	if (sqlca.sqlcode == SQL_DEADLOCK) {
	325	com_err(whoami, MR_DEADLOCK, "updating user");
	326	return;
	327	} else {
	328	com_err(whoami, 0, "ingres error %d updating user", sqlca.sqlcode);
	329	exit(1);
	330	}
3e77c6a3	331	}
	332	}
	333
	334	/* Update name if necessary */
	335	if (strcmp(first, strtrim(dfirst)) \|\|
	336	strcmp(last, strtrim(dlast)) \|\|
	337	strcmp(middle, strtrim(dmiddle))) {
	338	com_err(whoami, 0, "updating real name for %s %s", first, last);
	339	EXEC SQL UPDATE users
	340	SET first = :first, last = :last, middle = :middle,
	341	modby = :who, modwith = :prog, modtime = 'now'
	342	WHERE users_id = :id;
	343	if (sqlca.sqlcode != 0) {
e33f9f21	344	if (sqlca.sqlcode == SQL_DEADLOCK) {
	345	com_err(whoami, MR_DEADLOCK, "updating name");
	346	return;
	347	} else {
	348	com_err(whoami, 0, "ingres error %d updating name", sqlca.sqlcode);
	349	exit(1);
	350	}
3e77c6a3	351	}
469f80df	352	}
325821e4	353
469f80df	354	changed = nochange = 0;
3e77c6a3	355	if (encrypted) changed++;
469f80df	356	strcpy(buf, e->address);
	357	while (to = index(buf, ','))
	358	*to = ';';
	359	while (to = index(buf, ':'))
	360	*to = ';';
	361	if (newfinger) {
a6e9fead	362	if (oaddr[0] == ' ' && buf[0]) {
469f80df	363	strncpy(oaddr, buf, 16);
	364	oaddr[16] = 0;
	365	changed++;
6eb764c5	366	} else if (strncmp(strtrim(oaddr), buf, 15))
469f80df	367	nochange++;
	368	} else {
	369	if (strncmp(strtrim(oaddr), buf, 15))
	370	changed++;
	371	strncpy(oaddr, buf, 16);
	372	oaddr[16] = 0;
	373	}
	374	from = e->phone;
	375	to = buf;
	376	while (*from) {
	377	if (isdigit(*from))
	378	to++ = from;
	379	from++;
	380	}
	381	*to = 0;
	382	if (newfinger) {
	383	if (ophone[0] == ' ') {
	384	strncpy(ophone, buf, 16);
	385	ophone[16] = 0;
6eb764c5	386	} else if (strncmp(strtrim(ophone), buf, 11))
469f80df	387	nochange++;
	388	} else {
	389	if (strncmp(strtrim(ophone), buf, 11))
	390	changed++;
	391	strncpy(ophone, buf, 16);
	392	ophone[16] = 0;
	393	}
	394	FixCase(e->dept);
a6e9fead	395	FixCase(e->title);
469f80df	396	if (newfinger) {
	397	if (dept[0] == ' ') {
	398	strncpy(dept, e->dept, 12);
	399	dept[12] = 0;
6eb764c5	400	} else if (strncmp(strtrim(dept), e->dept, 11))
469f80df	401	nochange++;
	402	} else {
	403	if (strncmp(strtrim(dept), e->dept, 11))
	404	changed++;
	405	strncpy(dept, e->dept, 12);
	406	dept[12] = 0;
	407	}
325821e4	408	sid = e->id;
	409	name = e->name;
	410	rdept = e->dept;
	411	rtitle = e->title;
	412	raddr = e->address;
	413	rhphone = e->phone;
	414	rophone = e->phone2;
469f80df	415	if (changed) {
469f80df	416	com_err(whoami, 0, "updating finger for %s %s", first, last);
02cd9ede	417	EXEC SQL REPEATED UPDATE users
3e77c6a3	418	SET office_addr = :oaddr, office_phone = :ophone, department = :dept,
3e77c6a3	419	fmodtime = 'now', fmodby = :who, fmodwith = :prog,
02cd9ede	420	xname = :name, xdept = :rdept, xtitle = :rtitle,
02cd9ede	421	xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
3e77c6a3	422	xmodtime = 'now', clearid = :sid
02cd9ede	423	WHERE users_id = :id;
3e77c6a3	424	if (sqlca.sqlcode != 0) {
6f1556b3	425	if (sqlca.sqlcode == SQL_DEADLOCK) {
	426	com_err(whoami, MR_DEADLOCK, "updating user %s", sid);
	427	EXEC SQL ROLLBACK;
	428	return process_entry(e);
	429	} else {
	430	com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
	431	exit(1);
	432	}
3e77c6a3	433	}
325821e4	434	} else {
02cd9ede	435	EXEC SQL REPEATED UPDATE users
	436	SET xname = :name, xdept = :rdept, xtitle = :rtitle,
	437	xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
3e77c6a3	438	xmodtime = 'now', clearid = :sid
02cd9ede	439	WHERE users_id = :id;
3e77c6a3	440	if (sqlca.sqlcode != 0) {
6f1556b3	441	if (sqlca.sqlcode == SQL_DEADLOCK) {
	442	com_err(whoami, MR_DEADLOCK, "updating user %s", sid);
	443	EXEC SQL ROLLBACK;
	444	return process_entry(e);
	445	} else {
	446	com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
	447	exit(1);
	448	}
3e77c6a3	449	}
a6e9fead	450	}
02cd9ede	451	}
469f80df	452
	453
	454	newuser(e)
	455	struct entry *e;
02cd9ede	456	{
469f80df	457	char from, to;
02cd9ede	458	EXEC SQL BEGIN DECLARE SECTION;
	459	int id, uid, st, who;
	460	char last, first, class, middle, login[9], sid, fullname[65], prog;
	461	char oaddr[81], ophone[17], dept[128], name, title, phone2[17];
	462	char rdept, rhphone, *rophone;
	463	EXEC SQL END DECLARE SECTION;
	464
	465	who = WHO;
	466	prog = PROG;
469f80df	467	strncpy(oaddr, e->address, 16);
a6e9fead	468	oaddr[16] = 0;
469f80df	469	while (to = index(oaddr, ','))
	470	*to = ';';
	471	while (to = index(oaddr, ':'))
	472	*to = ';';
	473	from = e->phone;
	474	to = ophone;
	475	while (*from) {
	476	if (isdigit(*from))
	477	to++ = from;
	478	from++;
	479	}
	480	*to = 0;
a6e9fead	481	FixCase(e->dept);
469f80df	482	strncpy(dept, e->dept, 12);
a6e9fead	483	dept[12] = 0;
469f80df	484
3e77c6a3	485	id = set_next_users_id(0);
3e77c6a3	486	uid = set_next_uid(1);
469f80df	487	sprintf(login, "#%d", uid);
	488	last = e->last;
	489	first = e->first;
	490	middle = e->middle;
469f80df	491	class = e->class;
	492	if (*middle)
	493	sprintf(fullname, "%s %s %s", first, middle, last);
	494	else
	495	sprintf(fullname, "%s %s", first, last);
2168fb4b	496	st = US_NO_LOGIN_YET;
325821e4	497
	498	sid = e->id;
	499	name = e->name;
	500	rdept = e->dept;
	501	title = e->title;
	502	rhphone = e->phone;
	503	rophone = e->phone2;
	504
3e77c6a3	505	EXEC SQL REPEATED INSERT INTO users
02cd9ede	506	(login, users_id, uid, shell, last, first, middle, status,
	507	clearid, type, modtime, modby, modwith, fullname, office_addr,
	508	office_phone, department, fmodtime, fmodby, fmodwith,
	509	potype, xname, xdept, xtitle, xaddress, xphone1, xphone2, xmodtime)
2168fb4b	510	VALUES (:login, :id, :uid, '/bin/athena/tcsh', :last, :first,
	511	:middle, :st, :sid, :class, 'now', :who, :prog,
	512	:fullname, :oaddr, :ophone, :dept, 'now', :who, :prog,
	513	'NONE', :name, :rdept, :title, :oaddr, :rhphone,
	514	:rophone, 'now');
3e77c6a3	515	if (sqlca.sqlcode != 0) {
e33f9f21	516	if (sqlca.sqlcode == SQL_DEADLOCK) {
	517	com_err(whoami, MR_DEADLOCK, "adding user");
	518	} else {
	519	com_err(whoami, 0, "ingres error %d adding user", sqlca.sqlcode);
	520	exit(1);
	521	}
3e77c6a3	522	} else
3e77c6a3	523	com_err(whoami, 0, "adding user %s %s", e->first, e->last);
02cd9ede	524	}
469f80df	525
469f80df	526
3e77c6a3	527	set_next_users_id(limit)
27736587	528	int limit;
02cd9ede	529	{
02cd9ede	530	EXEC SQL BEGIN DECLARE SECTION;
3e77c6a3	531	int rowcount, flag, value, retval;
	532	EXEC SQL END DECLARE SECTION;
	533
	534	EXEC SQL REPEATED SELECT value INTO :value FROM numvalues
	535	WHERE name = 'users_id';
	536	if (sqlfail()) sqlexit();
	537	if (sqlca.sqlerrd[2] != 1) {
	538	EXEC SQL ROLLBACK;
	539	com_err(whoami, MR_INTERNAL, "values table inconsistancy");
	540	exit(1);
	541	}
	542
	543	flag = 0;
	544	EXEC SQL REPEATED SELECT users_id INTO :flag FROM users
	545	WHERE users_id = :value;
	546	if (sqlfail()) sqlexit();
	547	if (sqlca.sqlerrd[2] == 0)
	548	flag = 0;
	549	while (flag) {
	550	value++;
	551	if (limit && value > MAX_ID_VALUE)
	552	value = MIN_ID_VALUE;
	553	flag = 0;
	554	EXEC SQL REPEATED SELECT users_id INTO :flag FROM users
	555	WHERE users_id = :value;
	556	if (sqlfail()) sqlexit();
	557	if (sqlca.sqlerrd[2] == 0)
	558	flag = 0;
	559	}
	560
	561	retval = value++;
	562	if (limit && value > MAX_ID_VALUE)
	563	value = MIN_ID_VALUE;
	564	EXEC SQL REPEATED UPDATE numvalues SET value = :value
	565	WHERE name = 'users_id';
	566	if (sqlca.sqlcode != 0) {
e33f9f21	567	com_err(whoami, 0, "ingres error %d assigning ID", sqlca.sqlcode);
9b2c129e	568	exit(1);
3e77c6a3	569	}
	570	return(retval);
	571	}
	572
	573	set_next_uid(limit)
	574	int limit;
	575	{
	576	EXEC SQL BEGIN DECLARE SECTION;
	577	int rowcount, flag, value, retval;
02cd9ede	578	EXEC SQL END DECLARE SECTION;
469f80df	579
3e77c6a3	580	EXEC SQL REPEATED SELECT value INTO :value FROM numvalues
	581	WHERE name = 'uid';
	582	if (sqlfail()) sqlexit();
02cd9ede	583	if (sqlca.sqlerrd[2] != 1) {
	584	EXEC SQL ROLLBACK;
	585	com_err(whoami, MR_INTERNAL, "values table inconsistancy");
	586	exit(1);
469f80df	587	}
469f80df	588
02cd9ede	589	flag = 0;
3e77c6a3	590	EXEC SQL REPEATED SELECT uid INTO :flag FROM users WHERE uid = :value;
3e77c6a3	591	if (sqlfail()) sqlexit();
02cd9ede	592	if (sqlca.sqlerrd[2] == 0)
	593	flag = 0;
	594	while (flag) {
469f80df	595	value++;
27736587	596	if (limit && value > MAX_ID_VALUE)
469f80df	597	value = MIN_ID_VALUE;
02cd9ede	598	flag = 0;
3e77c6a3	599	EXEC SQL REPEATED SELECT uid INTO :flag FROM users WHERE uid = :value;
3e77c6a3	600	if (sqlfail()) sqlexit();
02cd9ede	601	if (sqlca.sqlerrd[2] == 0)
02cd9ede	602	flag = 0;
469f80df	603	}
469f80df	604
3e77c6a3	605	retval = value++;
02cd9ede	606	if (limit && value > MAX_ID_VALUE)
02cd9ede	607	value = MIN_ID_VALUE;
3e77c6a3	608	EXEC SQL REPEATED UPDATE numvalues SET value = :value WHERE name = 'uid';
3e77c6a3	609	if (sqlca.sqlcode != 0) {
e33f9f21	610	com_err(whoami, 0, "ingres error %d assigning ID", sqlca.sqlcode);
3e77c6a3	611	exit(1);
	612	}
	613	return(retval);
	614	}
	615
	616
	617	sqlexit()
	618	{
6f1556b3	619	if (sqlca.sqlcode == SQL_DEADLOCK)
	620	com_err(whoami, MR_DEADLOCK, "unrecoverable ingres error %d",
	621	sqlca.sqlcode);
	622	else
	623	com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
3e77c6a3	624	EXEC SQL ROLLBACK WORK;
3e77c6a3	625	exit(1);
02cd9ede	626	}