/* $Header$ */ #include #include #include #include #include #include ##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); ## ingres sms ## range of u is users while (e = get_next_entry(in)) { process_entry(e); if (wait) { printf("Next"); fflush(stdout); gets(buf); } } ## exit 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; ## 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; 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 */ ## repeat retrieve (id = u.users_id, class = u.mit_year, oaddr = u.office_addr, ## ophone = u.office_phone, dept = u.mit_dept, status = u.#status) ## where u.#last = @last and u.#first = @first and u.mit_id = @sid if (id == 0) { ## repeat retrieve (id = u.users_id, class = u.mit_year, ## oaddr = u.office_addr, ophone = u.office_phone, ## dept = u.mit_dept, status = u.#status) ## where u.#last = @last and u.#first = @first and u.mit_id = @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); ## repeat replace u (mit_year = @class, #status = @status, ## modtime = "now", modby = WHO, modwith = PROG) ## where u.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); ## repeat replace u (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 = date("now"), mit_id = @sid) ## where u.users_id = @id } else { ## repeat replace u (xname = @name, xdept = @rdept, xtitle = @rtitle, ## xaddress = @raddr, xphone1 = @rhphone, xphone2 = @rophone, ## xmodtime = date("now"), mit_id = @sid) ## where u.users_id = @id } ##} newuser(e) struct entry *e; ##{ char *from, *to; ## int id, uid, st; ## char *last, *first, *class, *middle, login[9], *sid, fullname[65]; ## char oaddr[81], ophone[17], dept[128], *name, *title, phone2[17]; ## char *rdept, *rhphone, *rophone; 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; ## append users (#login = login, users_id = id, #uid = uid, shell = "/bin/csh", ## #last = last, #first = first, #middle = middle, status = st, ## #mit_id = sid, #mit_year = class, ## modtime = "now", modby = WHO, modwith = PROG, ## #fullname = fullname, office_addr = oaddr, ## office_phone = ophone, #mit_dept = dept, ## fmodtime = "now", fmodby = WHO, fmodwith = PROG, ## potype = "NONE", ## xname = name, xdept = rdept, xtitle = title, ## xaddress = oaddr, xphone1 = rhphone, xphone2 = rophone, ## xmodtime = date("now")) ##} set_next_object_id(object, limit) char *object; int limit; ##{ ## char *name; ## int rowcount, exists, value; name = object; ## begin transaction ## repeat retrieve (value = values.#value) where values.#name = @name ## inquire_equel(rowcount = "rowcount") if (rowcount != 1) { ## abort return(0); } ## retrieve (exists = any(users.name where users.name = value)) ## inquire_equel(rowcount = "rowcount") if (rowcount != 1) { ## abort return(0); } while (exists) { value++; if (limit && value > MAX_ID_VALUE) value = MIN_ID_VALUE; ## retrieve (exists = any(users.name where users.name = value)) } ## repeat replace values (#value = @value) where values.#name = @name ## end transaction return(value); ##}