[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;


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);

    EXEC SQL CONNECT moira;

    while (e = get_next_entry(in)) {
	process_entry(e);
	EXEC SQL COMMIT;
	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 (!strcmp(e.dept, "PROJECT ATHENA"))
      e.class = "STAFF";
    else if (substr(e.title, "PROF") || substr(e.title, "LECTURE"))
      e.class = "FACULTY";
    else if (!strcmp(e.title, "VISITING SCIENTIST"))
      e.class = "VSCIENTI";

    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;
    char buf[BUFSIZ], *from, *to;
    EXEC SQL BEGIN DECLARE SECTION;
    char *first, *last, *eid, *sid, *name, *title, *phone2, *rdept, *rtitle;
    char *raddr, *rhphone, *rophone;
    char class[9], oaddr[25], ophone[17], dept[128];
    int id, status;
    EXEC SQL END DECLARE SECTION;

    first = e->first;
    if (strlen(first) > 16)
      first[16] = 0;
    last = e->last;
    if (strlen(last) > 16)
      last[16] = 0;
    eid = e->eid;
    sid = e->id;
    id = 0;

    /* Get user info */
    EXEC SQL SELECT users_id, mit_year, office_addr, office_phone, mit_dept, status
      INTO :id, :class, :oaddr, :ophone, :dept, :status
      FROM users
      WHERE last = :last and first = :first and clearid = :sid;
    if (id == 0) {
	EXEC SQL SELECT users_id, mit_year, office_addr, office_phone, mit_dept, status
	  INTO :id, :class, :oaddr, :ophone, :dept, :status
	  FROM users
	  WHERE last = :last and first = :first and clearid = :eid;
	if (id == 0) {
	    newuser(e);
	    return;
	}
    }

    if (strcmp(e->class, strtrim(class)) &&
	strcmp(class, "STAFF") && strcmp(class, "SIPB")) {
	com_err(whoami, 0, "updating class for %s %s from %s to %s",
		first, last, class, e->class);
	if (status == US_NOT_ALLOWED && !strcmp(e->class, "FACULTY"))
	  status = US_NO_LOGIN_YET;
	if (status == US_ENROLL_NOT_ALLOWED && !strcmp(e->class, "FACULTY"))
	  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;
    }

    changed = nochange = 0;
    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, mit_dept = :dept,
	    fmodtime = 'now', fmodby = WHO, fmodwith = PROG,
	    xname = :name, xdept = :rdept, xtitle = :rtitle,
	    xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
	    xmodtime = 'now', mit_id = :sid
	  WHERE users_id = :id;
    } else {
	EXEC SQL REPEATED UPDATE users
	  SET xname = :name, xdept = :rdept, xtitle = :rtitle,
	    xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
	    xmodtime = 'now', mit_id = :sid
	  WHERE users_id = :id;
    }
}


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_object_id("users_id", 0);
    uid = set_next_object_id("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_NOT_ALLOWED;
    if (!strcmp(e->class, "FACULTY") || !strcmp(e->class, "STAFF"))
      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 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/csh', :last, :first, :middle, :st,
	      :sid, :class, 'now', :who, :prog, :fullname, :oaddr, :ophone,
	      :dept, 'now', :who, :prog, 'NONE', :name, :rdept,
	      :title, :oaddr, :rhphone, :rophone, 'now');
}


set_next_object_id(object, limit)
    char *object;
    int limit;
{
    EXEC SQL BEGIN DECLARE SECTION;
    char *name;
    int rowcount, flag, value;
    EXEC SQL END DECLARE SECTION;

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

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

    value++;
    if (limit && value > MAX_ID_VALUE)
      value = MIN_ID_VALUE;
    EXEC SQL REPEATED UPDATE numvalues SET value = :value WHERE name = :name;
    return(value);
}
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
	74
	75	main(argc, argv)
	76	int argc;
	77	char **argv;
02cd9ede	78	{
469f80df	79	FILE *in;
	80	struct entry e, get_next_entry();
	81	int i, wait = 0;
	82	char buf[BUFSIZ], *file = NULL;
	83
	84	whoami = rindex(argv[0], '/');
	85	if (whoami)
	86	whoami++;
	87	else
	88	whoami = argv[0];
	89
	90	for (i = 1; i < argc; i++) {
	91	if (!strcmp(argv[i], "-w"))
	92	wait++;
	93	else if (!strcmp(argv[i], "-D"))
	94	setenv("ING_SET", "set printqry");
	95	else if (!strcmp(argv[i], "-n"))
	96	newfinger++;
	97	else if (file != NULL)
325821e4	98	fprintf(stderr, "Usage: %s [-w] [-D] [-n] inputfile\n", whoami);
469f80df	99	else
	100	file = argv[i];
	101	}
	102
	103	in = fopen(file, "r");
	104	if (in == NULL) {
	105	fprintf(stderr, "Unable to open %s for input\n", file);
	106	exit(1);
	107	}
	108
325821e4	109	setlinebuf(stdout);
	110	setlinebuf(stderr);
	111
02cd9ede	112	EXEC SQL CONNECT moira;
469f80df	113
	114	while (e = get_next_entry(in)) {
	115	process_entry(e);
02cd9ede	116	EXEC SQL COMMIT;
469f80df	117	if (wait) {
	118	printf("Next");
	119	fflush(stdout);
	120	gets(buf);
	121	}
	122	}
	123
469f80df	124	exit(0);
02cd9ede	125	}
469f80df	126
	127
	128	char *substr(buf, key)
	129	char *buf;
	130	char *key;
	131	{
	132	int l;
	133
	134	for (l = strlen(key); *buf; buf++)
	135	if (!strncmp(buf, key, l))
	136	return(buf);
	137	return(NULL);
	138	}
	139
	140
	141	struct entry *get_next_entry(in)
	142	FILE *in;
	143	{
	144	static struct entry e;
a6e9fead	145	static char buf[BUFSIZ], mid[16], eid[16], email[256];
	146	static char name[LEN_NAME+1], sname[LEN_NAME+1], id[LEN_ID+1];
	147	static char office[LEN_OFFICE+1], phone[LEN_PHONE+1], phone2[LEN_PHONE2+1];
	148	static char dept[LEN_DEPT+1], title[LEN_TITLE+1], username[LEN_USERNAME+1];
	149	static char host[LEN_HOST+1];
039f9637	150	int ends_sr, ends_jr, ends_iii, ends_iv, ends_ii, ends_v;
469f80df	151	char *p;
469f80df	152
4763be9c	153	if (fgets(buf, sizeof(buf), in) == NULL)
4763be9c	154	return((struct entry *)NULL);
a6e9fead	155
	156	strncpy(id, &buf[LOC_ID], LEN_ID); id[LEN_ID] = 0;
	157	strncpy(name, &buf[LOC_NAME], LEN_NAME); name[LEN_NAME] = 0;
	158	strncpy(office, &buf[LOC_OFFICE], LEN_OFFICE); office[LEN_OFFICE] = 0;
	159	strncpy(phone, &buf[LOC_PHONE], LEN_PHONE); phone[LEN_PHONE] = 0;
	160	strncpy(phone2, &buf[LOC_PHONE2], LEN_PHONE2); phone2[LEN_PHONE2] = 0;
	161	strncpy(dept, &buf[LOC_DEPT], LEN_DEPT); dept[LEN_DEPT] = 0;
	162	strncpy(title, &buf[LOC_TITLE], LEN_TITLE); title[LEN_TITLE] = 0;
	163	strncpy(username, &buf[LOC_USERNAME], LEN_USERNAME); username[LEN_USERNAME] = 0;
	164	strncpy(host, &buf[LOC_HOST], LEN_HOST); host[LEN_HOST] = 0;
	165
	166	strcpy(sname, name);
	167	e.name = strtrim(sname);
	168	p = index(name, ',');
469f80df	169	if (p)
469f80df	170	*p = 0;
a6e9fead	171	e.last = strtrim(name);
469f80df	172	if (p) {
a6e9fead	173	p++;
	174	while (isspace(*p))
	175	p++;
	176	e.first = p;
469f80df	177	if (p = index(e.first, ' ')) {
469f80df	178	*p = 0;
a6e9fead	179	e.first = strtrim(e.first);
469f80df	180	e.middle = strtrim(p + 1);
a6e9fead	181	} else {
	182	e.first = strtrim(e.first);
	183	e.middle = "";
	184	}
	185	} else {
	186	e.first = "";
	187	e.middle = "";
	188	}
039f9637	189	ends_sr = ends_jr = ends_iii = ends_iv = ends_ii = ends_v = 0;
469f80df	190	LookForSt(e.last);
469f80df	191	LookForO(e.last);
039f9637	192	LookForJrAndIII(e.last, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
	193	&ends_ii, &ends_v);
	194	LookForJrAndIII(e.first, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
	195	&ends_ii, &ends_v);
469f80df	196	FixCase(e.last);
	197	FixCase(e.first);
	198	FixCase(e.middle);
	199
a6e9fead	200	e.id = id;
469f80df	201	e.eid = eid;
	202	EncryptID(e.eid, e.id, e.first, e.last);
	203
a6e9fead	204	e.address = strtrim(office);
	205	e.phone = strtrim(phone);
	206	e.phone2 = strtrim(phone2);
	207	e.dept = strtrim(dept);
	208	e.title = strtrim(title);
469f80df	209
	210	e.class = "MITS";
	211	if (!strcmp(e.dept, "PROJECT ATHENA"))
	212	e.class = "STAFF";
e1695a1c	213	else if (substr(e.title, "PROF") \|\| substr(e.title, "LECTURE"))
469f80df	214	e.class = "FACULTY";
	215	else if (!strcmp(e.title, "VISITING SCIENTIST"))
	216	e.class = "VSCIENTI";
	217
a6e9fead	218	strcpy(email, strtrim(username));
	219	if (host[0] == '@')
	220	strncat(email, strtrim(host));
	221	e.email = email;
469f80df	222
	223	return(&e);
	224	}
	225
	226
	227	process_entry(e)
	228	struct entry *e;
02cd9ede	229	{
469f80df	230	int changed, nochange;
469f80df	231	char buf[BUFSIZ], from, to;
02cd9ede	232	EXEC SQL BEGIN DECLARE SECTION;
	233	char first, last, eid, sid, name, title, phone2, rdept, *rtitle;
	234	char raddr, rhphone, *rophone;
	235	char class[9], oaddr[25], ophone[17], dept[128];
	236	int id, status;
	237	EXEC SQL END DECLARE SECTION;
469f80df	238
469f80df	239	first = e->first;
9e4455c2	240	if (strlen(first) > 16)
9e4455c2	241	first[16] = 0;
469f80df	242	last = e->last;
9e4455c2	243	if (strlen(last) > 16)
9e4455c2	244	last[16] = 0;
469f80df	245	eid = e->eid;
325821e4	246	sid = e->id;
469f80df	247	id = 0;
325821e4	248
325821e4	249	/* Get user info */
02cd9ede	250	EXEC SQL SELECT users_id, mit_year, office_addr, office_phone, mit_dept, status
	251	INTO :id, :class, :oaddr, :ophone, :dept, :status
	252	FROM users
	253	WHERE last = :last and first = :first and clearid = :sid;
469f80df	254	if (id == 0) {
02cd9ede	255	EXEC SQL SELECT users_id, mit_year, office_addr, office_phone, mit_dept, status
	256	INTO :id, :class, :oaddr, :ophone, :dept, :status
	257	FROM users
	258	WHERE last = :last and first = :first and clearid = :eid;
325821e4	259	if (id == 0) {
	260	newuser(e);
	261	return;
	262	}
469f80df	263	}
325821e4	264
e1695a1c	265	if (strcmp(e->class, strtrim(class)) &&
e1695a1c	266	strcmp(class, "STAFF") && strcmp(class, "SIPB")) {
469f80df	267	com_err(whoami, 0, "updating class for %s %s from %s to %s",
469f80df	268	first, last, class, e->class);
a6e9fead	269	if (status == US_NOT_ALLOWED && !strcmp(e->class, "FACULTY"))
	270	status = US_NO_LOGIN_YET;
	271	if (status == US_ENROLL_NOT_ALLOWED && !strcmp(e->class, "FACULTY"))
	272	status = US_ENROLLED;
469f80df	273	strcpy(class, e->class);
02cd9ede	274	EXEC SQL UPDATE users
	275	SET type = :class, status = :status, modtime = 'now',
	276	modby = WHO, modwith = PROG
	277	WHERE users_id = :id;
469f80df	278	}
325821e4	279
469f80df	280	changed = nochange = 0;
	281	strcpy(buf, e->address);
	282	while (to = index(buf, ','))
	283	*to = ';';
	284	while (to = index(buf, ':'))
	285	*to = ';';
	286	if (newfinger) {
a6e9fead	287	if (oaddr[0] == ' ' && buf[0]) {
469f80df	288	strncpy(oaddr, buf, 16);
	289	oaddr[16] = 0;
	290	changed++;
6eb764c5	291	} else if (strncmp(strtrim(oaddr), buf, 15))
469f80df	292	nochange++;
	293	} else {
	294	if (strncmp(strtrim(oaddr), buf, 15))
	295	changed++;
	296	strncpy(oaddr, buf, 16);
	297	oaddr[16] = 0;
	298	}
	299	from = e->phone;
	300	to = buf;
	301	while (*from) {
	302	if (isdigit(*from))
	303	to++ = from;
	304	from++;
	305	}
	306	*to = 0;
	307	if (newfinger) {
	308	if (ophone[0] == ' ') {
	309	strncpy(ophone, buf, 16);
	310	ophone[16] = 0;
6eb764c5	311	} else if (strncmp(strtrim(ophone), buf, 11))
469f80df	312	nochange++;
	313	} else {
	314	if (strncmp(strtrim(ophone), buf, 11))
	315	changed++;
	316	strncpy(ophone, buf, 16);
	317	ophone[16] = 0;
	318	}
	319	FixCase(e->dept);
a6e9fead	320	FixCase(e->title);
469f80df	321	if (newfinger) {
	322	if (dept[0] == ' ') {
	323	strncpy(dept, e->dept, 12);
	324	dept[12] = 0;
6eb764c5	325	} else if (strncmp(strtrim(dept), e->dept, 11))
469f80df	326	nochange++;
	327	} else {
	328	if (strncmp(strtrim(dept), e->dept, 11))
	329	changed++;
	330	strncpy(dept, e->dept, 12);
	331	dept[12] = 0;
	332	}
325821e4	333	sid = e->id;
	334	name = e->name;
	335	rdept = e->dept;
	336	rtitle = e->title;
	337	raddr = e->address;
	338	rhphone = e->phone;
	339	rophone = e->phone2;
469f80df	340	if (changed) {
469f80df	341	com_err(whoami, 0, "updating finger for %s %s", first, last);
02cd9ede	342	EXEC SQL REPEATED UPDATE users
	343	SET office_addr = :oaddr, office_phone = :ophone, mit_dept = :dept,
	344	fmodtime = 'now', fmodby = WHO, fmodwith = PROG,
	345	xname = :name, xdept = :rdept, xtitle = :rtitle,
	346	xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
	347	xmodtime = 'now', mit_id = :sid
	348	WHERE users_id = :id;
325821e4	349	} else {
02cd9ede	350	EXEC SQL REPEATED UPDATE users
	351	SET xname = :name, xdept = :rdept, xtitle = :rtitle,
	352	xaddress = :raddr, xphone1 = :rhphone, xphone2 = :rophone,
	353	xmodtime = 'now', mit_id = :sid
	354	WHERE users_id = :id;
a6e9fead	355	}
02cd9ede	356	}
469f80df	357
	358
	359	newuser(e)
	360	struct entry *e;
02cd9ede	361	{
469f80df	362	char from, to;
02cd9ede	363	EXEC SQL BEGIN DECLARE SECTION;
	364	int id, uid, st, who;
	365	char last, first, class, middle, login[9], sid, fullname[65], prog;
	366	char oaddr[81], ophone[17], dept[128], name, title, phone2[17];
	367	char rdept, rhphone, *rophone;
	368	EXEC SQL END DECLARE SECTION;
	369
	370	who = WHO;
	371	prog = PROG;
469f80df	372	strncpy(oaddr, e->address, 16);
a6e9fead	373	oaddr[16] = 0;
469f80df	374	while (to = index(oaddr, ','))
	375	*to = ';';
	376	while (to = index(oaddr, ':'))
	377	*to = ';';
	378	from = e->phone;
	379	to = ophone;
	380	while (*from) {
	381	if (isdigit(*from))
	382	to++ = from;
	383	from++;
	384	}
	385	*to = 0;
a6e9fead	386	FixCase(e->dept);
469f80df	387	strncpy(dept, e->dept, 12);
a6e9fead	388	dept[12] = 0;
469f80df	389
27736587	390	id = set_next_object_id("users_id", 0);
27736587	391	uid = set_next_object_id("uid", 1);
469f80df	392	sprintf(login, "#%d", uid);
	393	last = e->last;
	394	first = e->first;
	395	middle = e->middle;
469f80df	396	class = e->class;
	397	if (*middle)
	398	sprintf(fullname, "%s %s %s", first, middle, last);
	399	else
	400	sprintf(fullname, "%s %s", first, last);
	401	st = US_NOT_ALLOWED;
e1695a1c	402	if (!strcmp(e->class, "FACULTY") \|\| !strcmp(e->class, "STAFF"))
469f80df	403	st = US_NO_LOGIN_YET;
325821e4	404
	405	sid = e->id;
	406	name = e->name;
	407	rdept = e->dept;
	408	title = e->title;
	409	rhphone = e->phone;
	410	rophone = e->phone2;
	411
02cd9ede	412	EXEC SQL INSERT INTO users
	413	(login, users_id, uid, shell, last, first, middle, status,
	414	clearid, type, modtime, modby, modwith, fullname, office_addr,
	415	office_phone, department, fmodtime, fmodby, fmodwith,
	416	potype, xname, xdept, xtitle, xaddress, xphone1, xphone2, xmodtime)
	417	VALUES (:login, :id, :uid, '/bin/csh', :last, :first, :middle, :st,
	418	:sid, :class, 'now', :who, :prog, :fullname, :oaddr, :ophone,
	419	:dept, 'now', :who, :prog, 'NONE', :name, :rdept,
	420	:title, :oaddr, :rhphone, :rophone, 'now');
	421	}
469f80df	422
469f80df	423
27736587	424	set_next_object_id(object, limit)
469f80df	425	char *object;
27736587	426	int limit;
02cd9ede	427	{
	428	EXEC SQL BEGIN DECLARE SECTION;
	429	char *name;
	430	int rowcount, flag, value;
	431	EXEC SQL END DECLARE SECTION;
469f80df	432
469f80df	433	name = object;
02cd9ede	434	EXEC SQL SELECT value INTO :value FROM numvalues WHERE name = :name;
	435	if (sqlca.sqlerrd[2] != 1) {
	436	EXEC SQL ROLLBACK;
	437	com_err(whoami, MR_INTERNAL, "values table inconsistancy");
	438	exit(1);
469f80df	439	}
469f80df	440
02cd9ede	441	flag = 0;
	442	EXEC SQL SELECT :name INTO :flag FROM users WHERE :name = :value;
	443	if (sqlca.sqlerrd[2] == 0)
	444	flag = 0;
	445	while (flag) {
469f80df	446	value++;
27736587	447	if (limit && value > MAX_ID_VALUE)
469f80df	448	value = MIN_ID_VALUE;
02cd9ede	449	flag = 0;
	450	EXEC SQL SELECT :name INTO :flag FROM users WHERE :name = :value;
	451	if (sqlca.sqlerrd[2] == 0)
	452	flag = 0;
469f80df	453	}
469f80df	454
02cd9ede	455	value++;
	456	if (limit && value > MAX_ID_VALUE)
	457	value = MIN_ID_VALUE;
	458	EXEC SQL REPEATED UPDATE numvalues SET value = :value WHERE name = :name;
469f80df	459	return(value);
02cd9ede	460	}