]>
Commit | Line | Data |
---|---|---|
093c49c9 | 1 | /* $Header$ |
2 | */ | |
3 | ||
4 | #include <stdio.h> | |
9f5e5c05 | 5 | #include <string.h> |
093c49c9 | 6 | #include <ctype.h> |
7 | #include <sys/time.h> | |
932028de | 8 | #include <moira.h> |
9 | #include <moira_site.h> | |
8638fcf9 | 10 | EXEC SQL INCLUDE sqlca; |
093c49c9 | 11 | |
12 | ||
8638fcf9 | 13 | #define WHO 11859 /* root */ |
14 | #define PROG "stu-tape" | |
5e2b5b5f | 15 | |
397e9044 | 16 | #define MAX_ID_VALUE 31999 |
5e2b5b5f | 17 | #define MIN_ID_VALUE 101 |
18 | ||
093c49c9 | 19 | /* File format is: |
20 | ||
21 | 0-29 name | |
22 | 30-38 id number | |
23 | 50-54 school code | |
24 | 55-79 year | |
25 | 80-109 address | |
26 | 110-124 room | |
27 | 125-144 city | |
28 | 145-158 state | |
29 | 159-168 dorm phone | |
30 | 169-212 home address | |
31 | 213-232 home city | |
32 | 243-251 mit phone (?) | |
33 | */ | |
34 | ||
35 | #define LOC_NAME 0 | |
36 | #define LOC_ID 30 | |
37 | #define LOC_COURSE 50 | |
38 | #define LOC_YEAR 55 | |
39 | #define LOC_ADDRESS 80 | |
40 | #define LOC_DORM_ROOM 110 | |
41 | #define LOC_CITY 125 | |
42 | #define LOC_STATE 145 | |
c48e3c93 | 43 | #define LOC_DPHONE 155 |
e3c8ca24 | 44 | #define LOC_MPHONE 243 |
093c49c9 | 45 | |
e3c8ca24 | 46 | #define LEN_NAME 30 |
093c49c9 | 47 | #define LEN_ID 9 |
e3c8ca24 | 48 | #define LEN_COURSE 5 |
49 | #define LEN_YEAR 25 | |
50 | #define LEN_ADDRESS 30 | |
51 | #define LEN_DORM_ROOM 15 | |
52 | #define LEN_CITY 20 | |
c48e3c93 | 53 | #define LEN_STATE 10 |
54 | #define LEN_DPHONE 12 | |
55 | #define LEN_MPHONE 12 | |
093c49c9 | 56 | |
57 | struct entry { | |
e3c8ca24 | 58 | char *name; |
093c49c9 | 59 | char *last; |
60 | char *first; | |
61 | char *middle; | |
62 | char *title; | |
63 | char *id; | |
64 | char *eid; | |
65 | char *course; | |
66 | char *year; | |
67 | char *address; | |
68 | char *dorm; | |
69 | char *city; | |
70 | char *state; | |
71 | char *dphone; | |
72 | char *mphone; | |
73 | char *class; | |
093c49c9 | 74 | }; |
75 | ||
76 | ||
77 | char *whoami; | |
a97bc039 | 78 | int newfinger = 0; |
093c49c9 | 79 | |
bd22473a | 80 | #define SQL_DUPLICATE -2112 |
9f5e5c05 | 81 | #define sqlfail() (sqlca.sqlcode && sqlca.sqlcode != 1403) |
093c49c9 | 82 | |
83 | main(argc, argv) | |
84 | int argc; | |
85 | char **argv; | |
8638fcf9 | 86 | { |
093c49c9 | 87 | FILE *in; |
88 | struct entry *e, *get_next_entry(); | |
a97bc039 | 89 | int i, wait = 0; |
90 | char buf[BUFSIZ], *file = NULL; | |
9f5e5c05 | 91 | EXEC SQL BEGIN DECLARE SECTION; |
92 | char *db="moira"; | |
93 | EXEC SQL END DECLARE SECTION; | |
093c49c9 | 94 | |
9f5e5c05 | 95 | whoami = strrchr(argv[0], '/'); |
093c49c9 | 96 | if (whoami) |
97 | whoami++; | |
98 | else | |
99 | whoami = argv[0]; | |
100 | ||
9f5e5c05 | 101 | setvbuf(stdout, NULL, _IOLBF, BUFSIZ); |
102 | setvbuf(stderr, NULL, _IOLBF, BUFSIZ); | |
103 | ||
a97bc039 | 104 | for (i = 1; i < argc; i++) { |
105 | if (!strcmp(argv[i], "-w")) | |
106 | wait++; | |
107 | else if (!strcmp(argv[i], "-D")) | |
108 | setenv("ING_SET", "set printqry"); | |
109 | else if (!strcmp(argv[i], "-n")) | |
110 | newfinger++; | |
111 | else if (file != NULL) | |
dcd4e696 | 112 | fprintf(stderr, "Usage: %s [-w] [-D] [-n] inputfile\n", whoami); |
a97bc039 | 113 | else |
114 | file = argv[i]; | |
115 | } | |
093c49c9 | 116 | |
a97bc039 | 117 | in = fopen(file, "r"); |
093c49c9 | 118 | if (in == NULL) { |
a97bc039 | 119 | fprintf(stderr, "Unable to open %s for input\n", file); |
093c49c9 | 120 | exit(1); |
121 | } | |
122 | ||
e0806e36 | 123 | initialize_sms_error_table(); |
dcd4e696 | 124 | |
9f5e5c05 | 125 | EXEC SQL CONNECT :db IDENTIFIED BY :db; |
837b0ec6 | 126 | if (sqlca.sqlcode != 0) { |
9f5e5c05 | 127 | dbmserr("connecting", sqlca.sqlcode); |
837b0ec6 | 128 | exit(1); |
129 | } | |
5e2b5b5f | 130 | |
093c49c9 | 131 | while (e = get_next_entry(in)) { |
e2048305 | 132 | again: |
093c49c9 | 133 | process_entry(e); |
837b0ec6 | 134 | EXEC SQL COMMIT WORK; |
135 | if (sqlca.sqlcode != 0) { | |
9f5e5c05 | 136 | dbmserr("committing work", sqlca.sqlcode); |
137 | exit(1); | |
837b0ec6 | 138 | } |
093c49c9 | 139 | if (wait) { |
140 | printf("Next"); | |
141 | fflush(stdout); | |
142 | gets(buf); | |
143 | } | |
144 | } | |
145 | ||
093c49c9 | 146 | exit(0); |
8638fcf9 | 147 | } |
093c49c9 | 148 | |
149 | ||
150 | struct entry *get_next_entry(in) | |
151 | FILE *in; | |
152 | { | |
153 | static struct entry e; | |
154 | static char buf[BUFSIZ], eid[16], classbuf[10], titlebuf[12]; | |
e3c8ca24 | 155 | static char name[LEN_NAME+1], id[LEN_ID+1], course[LEN_COURSE+1]; |
156 | static char year[LEN_YEAR+1], address[LEN_ADDRESS+1]; | |
157 | static char dorm_room[LEN_DORM_ROOM+1], city[LEN_CITY+1]; | |
158 | static char state[LEN_STATE+1], dphone[LEN_DPHONE+1], mphone[LEN_MPHONE+1]; | |
159 | static char sname[LEN_NAME+1], title[128]; | |
160 | static int nyear = 0; | |
039f9637 | 161 | int ends_jr, ends_iii, ends_iv, ends_sr, ends_ii, ends_v; |
093c49c9 | 162 | char *p; |
163 | ||
e3c8ca24 | 164 | if (nyear == 0) { |
093c49c9 | 165 | struct tm *tm; |
166 | struct timeval tv; | |
167 | ||
168 | gettimeofday(&tv, NULL); | |
169 | tm = localtime(&tv.tv_sec); | |
e3c8ca24 | 170 | nyear = tm->tm_year; |
093c49c9 | 171 | if (tm->tm_mon > 5) |
e3c8ca24 | 172 | nyear++; |
093c49c9 | 173 | } |
174 | ||
22a6d0dc | 175 | if (fgets(buf, sizeof(buf), in) == NULL) |
176 | return((struct entry *)NULL); | |
e3c8ca24 | 177 | |
178 | strncpy(name, &buf[LOC_NAME], LEN_NAME); name[LEN_NAME] = 0; | |
179 | strncpy(id, &buf[LOC_ID], LEN_ID); id[LEN_ID] = 0; | |
180 | strncpy(course, &buf[LOC_COURSE], LEN_COURSE); course[LEN_COURSE] = 0; | |
181 | strncpy(year, &buf[LOC_YEAR], LEN_YEAR); year[LEN_YEAR] = 0; | |
182 | strncpy(address, &buf[LOC_ADDRESS], LEN_ADDRESS); address[LEN_ADDRESS] = 0; | |
183 | strncpy(dorm_room, &buf[LOC_DORM_ROOM], LEN_DORM_ROOM); dorm_room[LEN_DORM_ROOM] = 0; | |
184 | strncpy(city, &buf[LOC_CITY], LEN_CITY); city[LEN_CITY] = 0; | |
185 | strncpy(state, &buf[LOC_STATE], LEN_STATE); state[LEN_STATE] = 0; | |
186 | strncpy(dphone, &buf[LOC_DPHONE], LEN_DPHONE); dphone[LEN_DPHONE] = 0; | |
187 | strncpy(mphone, &buf[LOC_MPHONE], LEN_MPHONE); mphone[LEN_MPHONE] = 0; | |
188 | ||
189 | strcpy(sname, name); | |
190 | e.name = strtrim(sname); | |
9f5e5c05 | 191 | p = strchr(name, ','); |
093c49c9 | 192 | if (p) |
193 | *p = 0; | |
e3c8ca24 | 194 | e.last = strtrim(name); |
093c49c9 | 195 | if (p) { |
e3c8ca24 | 196 | p++; |
197 | while (isspace(*p)) | |
198 | p++; | |
199 | e.first = p; | |
9f5e5c05 | 200 | if (p = strchr(e.first, ' ')) { |
093c49c9 | 201 | *p = 0; |
e3c8ca24 | 202 | e.first = strtrim(e.first); |
093c49c9 | 203 | e.middle = strtrim(p + 1); |
6d6c60e6 | 204 | } else { |
205 | e.first = strtrim(e.first); | |
206 | e.middle = ""; | |
207 | } | |
e3c8ca24 | 208 | } else { |
209 | e.first = ""; | |
210 | e.middle = ""; | |
211 | } | |
039f9637 | 212 | ends_jr = ends_iii = ends_iv = ends_sr = ends_ii = ends_v = 0; |
093c49c9 | 213 | LookForSt(e.last); |
214 | LookForO(e.last); | |
039f9637 | 215 | LookForJrAndIII(e.last, &ends_sr, &ends_jr, &ends_iii, &ends_iv, |
216 | &ends_ii, &ends_v); | |
217 | LookForJrAndIII(e.first, &ends_sr, &ends_jr, &ends_iii, &ends_iv, | |
218 | &ends_ii, &ends_v); | |
093c49c9 | 219 | FixCase(e.last); |
220 | FixCase(e.first); | |
221 | FixCase(e.middle); | |
093c49c9 | 222 | |
e3c8ca24 | 223 | e.id = id; |
093c49c9 | 224 | e.id[LEN_ID] = 0; |
225 | e.eid = eid; | |
226 | EncryptID(e.eid, e.id, e.first, e.last); | |
227 | ||
e3c8ca24 | 228 | e.year = strtrim(year); |
229 | e.title = title; | |
230 | if (e.year[0] == 'G') { | |
231 | e.class = "G"; | |
232 | sprintf(title, "Grad Student"); | |
233 | } else { | |
093c49c9 | 234 | e.class = classbuf; |
e3c8ca24 | 235 | sprintf(classbuf, "%d", nyear + 4 - atoi(e.year) + 1900); |
236 | sprintf(title, "Undergrad (class of %s)", classbuf); | |
093c49c9 | 237 | } |
e3c8ca24 | 238 | |
239 | e.course = strtrim(course); | |
240 | e.address = strtrim(address); | |
241 | e.dorm = strtrim(dorm_room); | |
242 | e.city = strtrim(city); | |
243 | e.state = strtrim(state); | |
244 | e.dphone = strtrim(dphone); | |
245 | e.mphone = strtrim(mphone); | |
093c49c9 | 246 | return(&e); |
247 | } | |
248 | ||
249 | ||
093c49c9 | 250 | process_entry(e) |
251 | struct entry *e; | |
8638fcf9 | 252 | { |
c48e3c93 | 253 | int changed, nochange, encrypted; |
5e2b5b5f | 254 | char buf[BUFSIZ], *from, *to; |
8638fcf9 | 255 | EXEC SQL BEGIN DECLARE SECTION; |
ca64f2fb | 256 | char *first, *last, *middle, *eid, *title, *sid, *name, *rname, *rdept, *rtitle; |
837b0ec6 | 257 | char *rophone, *rhphone, *prog; |
8638fcf9 | 258 | char class[9], haddr[128], hphone[33], ophone[33], dept[33], raddr[128]; |
837b0ec6 | 259 | char dfirst[17], dlast[17], dmiddle[17]; |
260 | int id, status, who; | |
8638fcf9 | 261 | EXEC SQL END DECLARE SECTION; |
5e2b5b5f | 262 | |
837b0ec6 | 263 | who = WHO; |
264 | prog = PROG; | |
5e2b5b5f | 265 | first = e->first; |
9e4455c2 | 266 | if (strlen(first) > 16) |
267 | first[16] = 0; | |
5e2b5b5f | 268 | last = e->last; |
9e4455c2 | 269 | if (strlen(last) > 16) |
270 | last[16] = 0; | |
ca64f2fb | 271 | middle = e->middle; |
5e2b5b5f | 272 | eid = e->eid; |
c48e3c93 | 273 | sid = e->id; |
5e2b5b5f | 274 | id = 0; |
c48e3c93 | 275 | encrypted = 0; |
276 | ||
ca64f2fb | 277 | /* Get user info */ |
9f5e5c05 | 278 | EXEC SQL SELECT users_id, first, last, middle, type, home_addr, home_phone, office_phone, status, department |
837b0ec6 | 279 | INTO :id, :dfirst, :dlast, :dmiddle, :class, :haddr, :hphone, :ophone, :status, :dept |
8638fcf9 | 280 | FROM users |
837b0ec6 | 281 | WHERE clearid = :sid; |
282 | if (sqlfail()) { | |
283 | if (sqlca.sqlcode == SQL_DUPLICATE) { | |
284 | com_err(whoami, 0, "duplicate ID number %s on user %s %s", sid, first, last); | |
285 | return; | |
286 | } else | |
287 | sqlexit(); | |
288 | } | |
5e2b5b5f | 289 | if (id == 0) { |
9f5e5c05 | 290 | EXEC SQL SELECT users_id, first, last, middle, type, home_addr, home_phone, office_phone, status, department |
837b0ec6 | 291 | INTO :id, :dfirst, :dlast, :dmiddle, :class, :haddr, :hphone, :ophone, :status, :dept |
8638fcf9 | 292 | FROM users |
293 | WHERE last = :last and first = :first and clearid = :eid; | |
9f5e5c05 | 294 | if (sqlfail()) sqlexit(); |
c48e3c93 | 295 | encrypted++; |
296 | if (id == 0) { | |
297 | newuser(e); | |
298 | return; | |
299 | } | |
093c49c9 | 300 | } |
c48e3c93 | 301 | |
ca64f2fb | 302 | /* See if class changed: if it's different, and the value in the database |
a17eb042 | 303 | * is not STAFF or SIPBMEM, and the value from the tape is actually |
304 | * meaningful, then update the database. Since they were on the | |
ca64f2fb | 305 | * students tape, make the account usable. |
306 | */ | |
a262e022 | 307 | if (strcmp(e->class, strtrim(class)) && |
a17eb042 | 308 | strcmp(class, "STAFF") && strcmp(class, "SIPBMEM") && |
309 | e->year[0]) { | |
a97bc039 | 310 | com_err(whoami, 0, "updating class for user %s %s from %s to %s", |
311 | first, last, class, e->class); | |
e3c8ca24 | 312 | if (status == US_NOT_ALLOWED) status = US_NO_LOGIN_YET; |
313 | if (status == US_ENROLL_NOT_ALLOWED) status = US_ENROLLED; | |
5e2b5b5f | 314 | strcpy(class, e->class); |
9f5e5c05 | 315 | EXEC SQL UPDATE users |
316 | SET type = NVL(:class,CHR(0)), status = :status, modtime = SYSDATE, | |
837b0ec6 | 317 | modby = :who, modwith = :prog |
8638fcf9 | 318 | WHERE users_id = :id; |
837b0ec6 | 319 | if (sqlca.sqlcode != 0) { |
9f5e5c05 | 320 | dbmserr("updating class", sqlca.sqlcode); |
837b0ec6 | 321 | exit(1); |
322 | } | |
093c49c9 | 323 | } |
c48e3c93 | 324 | |
ca64f2fb | 325 | /* Update name if necessary */ |
326 | if (strcmp(first, strtrim(dfirst)) || | |
327 | strcmp(last, strtrim(dlast)) || | |
328 | strcmp(middle, strtrim(dmiddle))) { | |
329 | com_err(whoami, 0, "updating real name for %s %s", first, last); | |
330 | EXEC SQL UPDATE users | |
9f5e5c05 | 331 | SET first = NVL(:first,CHR(0)), last = NVL(:last,CHR(0)), |
332 | middle = NVL(:middle,CHR(0)), modby = :who, modwith = :prog, | |
333 | modtime = SYSDATE | |
ca64f2fb | 334 | WHERE users_id = :id; |
335 | if (sqlca.sqlcode != 0) { | |
9f5e5c05 | 336 | dbmserr("updating name", sqlca.sqlcode); |
ca64f2fb | 337 | exit(1); |
338 | } | |
339 | } | |
c48e3c93 | 340 | |
ca64f2fb | 341 | /* Deal with updating the finger info if necessary */ |
a97bc039 | 342 | changed = nochange = 0; |
837b0ec6 | 343 | if (encrypted) changed++; |
e3c8ca24 | 344 | strcpy(buf, e->address); |
093c49c9 | 345 | if (*e->dorm) { |
346 | strcat(buf, " "); | |
5e2b5b5f | 347 | strcat(buf, e->dorm); |
093c49c9 | 348 | } |
349 | if (*e->city) { | |
350 | strcat(buf, " "); | |
5e2b5b5f | 351 | strcat(buf, e->city); |
093c49c9 | 352 | } |
5e2b5b5f | 353 | FixCase(buf); |
093c49c9 | 354 | if (*e->state) { |
355 | strcat(buf, " "); | |
5e2b5b5f | 356 | strcat(buf, e->state); |
093c49c9 | 357 | } |
9f5e5c05 | 358 | while (to = strchr(buf, ',')) |
5e2b5b5f | 359 | *to = ';'; |
9f5e5c05 | 360 | while (to = strchr(buf, ':')) |
5e2b5b5f | 361 | *to = ';'; |
a97bc039 | 362 | if (newfinger) { |
363 | if (haddr[0] == ' ') { | |
364 | strncpy(haddr, buf, 80); | |
365 | haddr[80] = 0; | |
366 | changed++; | |
367 | } else if (strncmp(strtrim(haddr), buf, 80)) | |
368 | nochange++; | |
369 | } else { | |
370 | if (strncmp(strtrim(haddr), buf, 80)) | |
371 | changed++; | |
5e2b5b5f | 372 | strncpy(haddr, buf, 80); |
a97bc039 | 373 | haddr[80] = 0; |
093c49c9 | 374 | } |
375 | from = e->dphone; | |
376 | to = buf; | |
377 | while (*from) { | |
378 | if (isdigit(*from)) | |
379 | *to++ = *from; | |
380 | from++; | |
381 | } | |
382 | *to = 0; | |
a97bc039 | 383 | if (newfinger) { |
384 | if (hphone[0] == ' ') { | |
385 | strncpy(hphone, buf, 16); | |
386 | hphone[16] = 0; | |
387 | } else if (strncmp(strtrim(hphone), buf, 16)) | |
388 | nochange++; | |
389 | } else { | |
390 | if (strncmp(strtrim(hphone), buf, 16)) | |
391 | changed++; | |
5e2b5b5f | 392 | strncpy(hphone, buf, 16); |
a97bc039 | 393 | hphone[16] = 0; |
093c49c9 | 394 | } |
395 | from = e->mphone; | |
396 | to = buf; | |
397 | while (*from) { | |
398 | if (isdigit(*from)) | |
399 | *to++ = *from; | |
400 | from++; | |
401 | } | |
402 | *to = 0; | |
a97bc039 | 403 | if (newfinger) { |
404 | if (ophone[0] == ' ') { | |
405 | strncpy(ophone, buf, 12); | |
406 | ophone[12] = 0; | |
407 | } else if (strncmp(strtrim(ophone), buf, 12)) | |
408 | nochange++; | |
409 | } else { | |
410 | if (strncmp(strtrim(ophone), buf, 12)) | |
411 | changed++; | |
5e2b5b5f | 412 | strncpy(ophone, buf, 12); |
a97bc039 | 413 | ophone[12] = 0; |
093c49c9 | 414 | } |
e3c8ca24 | 415 | e->course = e->course; |
a97bc039 | 416 | if (newfinger) { |
417 | if (dept[0] == ' ') { | |
418 | strncpy(dept, e->course, 12); | |
419 | dept[12] = 0; | |
420 | } else if (strncmp(strtrim(dept), e->course, 11)) | |
421 | nochange++; | |
422 | } else { | |
423 | if (strncmp(strtrim(dept), e->course, 11)) | |
424 | changed++; | |
5e2b5b5f | 425 | strncpy(dept, e->course, 12); |
a97bc039 | 426 | dept[12] = 0; |
093c49c9 | 427 | } |
c48e3c93 | 428 | sid = e->id; |
429 | name = e->name; | |
430 | rdept = e->course; | |
431 | rtitle = e->title; | |
432 | rophone = e->mphone; | |
433 | rhphone = e->dphone; | |
434 | strcpy(raddr, e->address); | |
435 | if (*e->dorm) { | |
436 | strcat(raddr, " "); | |
437 | strcat(raddr, e->dorm); | |
438 | } | |
8638fcf9 | 439 | strcat(raddr, "|"); |
c48e3c93 | 440 | if (*e->city) { |
c48e3c93 | 441 | strcat(raddr, e->city); |
8638fcf9 | 442 | FixCase(raddr); |
443 | if (*e->state) { | |
444 | strcat(raddr, " "); | |
445 | if (isupper(e->state[0]) && isupper(e->state[1]) && | |
446 | isdigit(e->state[2]) && isdigit(e->state[3]) && | |
447 | isdigit(e->state[4]) && isdigit(e->state[5]) && | |
448 | isdigit(e->state[6])) { | |
449 | sprintf(buf, "%c%c %s", e->state[0],e->state[1], | |
450 | &(e->state[2])); | |
451 | strcat(raddr, buf); | |
452 | } else | |
453 | strcat(raddr, e->state); | |
454 | } | |
455 | } else { | |
456 | FixCase(raddr); | |
457 | strcat(raddr, "MIT INTERDEPARTMENTAL MAIL"); | |
c48e3c93 | 458 | } |
093c49c9 | 459 | if (changed) { |
5e2b5b5f | 460 | com_err(whoami, 0, "updating finger for %s %s", first, last); |
9f5e5c05 | 461 | EXEC SQL UPDATE users |
462 | SET home_addr = NVL(:haddr,CHR(0)), home_phone = NVL(:hphone,CHR(0)), | |
463 | office_phone = NVL(:ophone,CHR(0)), department = NVL(:dept,CHR(0)), | |
464 | fmodtime = SYSDATE, fmodby = :who, fmodwith = :prog, | |
465 | xname = NVL(:name,CHR(0)), xdept = NVL(:rdept,CHR(0)), | |
466 | xtitle = NVL(:rtitle,CHR(0)), xaddress = NVL(:raddr,CHR(0)), | |
467 | xphone1 = NVL(:rhphone,CHR(0)), xphone2 = NVL(:rophone,CHR(0)), | |
468 | xmodtime = SYSDATE, clearid = NVL(:sid,CHR(0)) | |
8638fcf9 | 469 | WHERE users_id = :id; |
837b0ec6 | 470 | if (sqlca.sqlcode != 0) { |
9f5e5c05 | 471 | dbmserr(NULL, sqlca.sqlcode); |
472 | exit(1); | |
837b0ec6 | 473 | } |
c48e3c93 | 474 | } else { |
9f5e5c05 | 475 | EXEC SQL UPDATE users |
476 | SET xname = NVL(:name,CHR(0)), xdept = NVL(:rdept,CHR(0)), | |
477 | xtitle = NVL(:rtitle,CHR(0)), xaddress = NVL(:raddr,CHR(0)), | |
478 | xphone1 = NVL(:rhphone,CHR(0)), xphone2 = NVL(:rophone,CHR(0)), | |
479 | xmodtime = SYSDATE, clearid = NVL(:sid,CHR(0)) | |
8638fcf9 | 480 | WHERE users_id = :id; |
837b0ec6 | 481 | if (sqlca.sqlcode != 0) { |
9f5e5c05 | 482 | dbmserr(NULL, sqlca.sqlcode); |
483 | exit(1); | |
837b0ec6 | 484 | } |
e3c8ca24 | 485 | } |
8638fcf9 | 486 | } |
093c49c9 | 487 | |
5e2b5b5f | 488 | |
489 | newuser(e) | |
093c49c9 | 490 | struct entry *e; |
8638fcf9 | 491 | { |
5e2b5b5f | 492 | char buf[512], *from, *to; |
8638fcf9 | 493 | EXEC SQL BEGIN DECLARE SECTION; |
494 | int id, uid, who; | |
495 | char *last, *first, *class, *middle, login[9], *sid, fullname[65], *prog; | |
496 | char haddr[81], hphone[17], ophone[13], dept[24], *title, raddr[81], *name; | |
497 | EXEC SQL END DECLARE SECTION; | |
498 | ||
499 | who = WHO; | |
500 | prog = PROG; | |
e3c8ca24 | 501 | strcpy(buf, e->address); |
5e2b5b5f | 502 | if (*e->dorm) { |
503 | strcat(buf, " "); | |
e3c8ca24 | 504 | strcat(buf, e->dorm); |
5e2b5b5f | 505 | } |
506 | if (*e->city) { | |
507 | strcat(buf, " "); | |
e3c8ca24 | 508 | strcat(buf, e->city); |
5e2b5b5f | 509 | } |
510 | if (*e->state) { | |
511 | strcat(buf, " "); | |
e3c8ca24 | 512 | strcat(buf, e->state); |
5e2b5b5f | 513 | } |
514 | strncpy(haddr, buf, 80); | |
515 | from = e->dphone; | |
516 | to = buf; | |
517 | while (*from) { | |
518 | if (isdigit(*from)) | |
519 | *to++ = *from; | |
520 | from++; | |
521 | } | |
522 | *to = 0; | |
523 | strncpy(hphone, buf, 16); | |
524 | from = e->mphone; | |
525 | to = buf; | |
526 | while (*from) { | |
527 | if (isdigit(*from)) | |
528 | *to++ = *from; | |
529 | from++; | |
530 | } | |
531 | *to = 0; | |
532 | strncpy(ophone, buf, 12); | |
5e2b5b5f | 533 | strncpy(dept, e->course, 12); |
5e2b5b5f | 534 | |
837b0ec6 | 535 | id = set_next_users_id(0); |
536 | uid = set_next_uid(1); | |
5e2b5b5f | 537 | sprintf(login, "#%d", uid); |
538 | last = e->last; | |
539 | first = e->first; | |
540 | middle = e->middle; | |
c48e3c93 | 541 | sid = e->id; |
5e2b5b5f | 542 | class = e->class; |
c48e3c93 | 543 | title = e->title; |
5e2b5b5f | 544 | if (*middle) |
545 | sprintf(fullname, "%s %s %s", first, middle, last); | |
546 | else | |
547 | sprintf(fullname, "%s %s", first, last); | |
8638fcf9 | 548 | name = e->name; |
549 | strcpy(raddr, e->address); | |
550 | if (*e->dorm) { | |
551 | strcat(raddr, " "); | |
552 | strcat(raddr, e->dorm); | |
553 | } | |
554 | strcat(raddr, "|"); | |
555 | if (*e->city) { | |
556 | strcat(raddr, e->city); | |
557 | FixCase(raddr); | |
558 | if (*e->state) { | |
559 | strcat(raddr, " "); | |
560 | if (isupper(e->state[0]) && isupper(e->state[1]) && | |
561 | isdigit(e->state[2]) && isdigit(e->state[3]) && | |
562 | isdigit(e->state[4]) && isdigit(e->state[5]) && | |
563 | isdigit(e->state[6])) { | |
564 | sprintf(buf, "%c%c %s", e->state[0],e->state[1], | |
565 | &(e->state[2])); | |
566 | strcat(raddr, buf); | |
567 | } else | |
568 | strcat(raddr, e->state); | |
569 | } | |
570 | } else { | |
571 | FixCase(raddr); | |
572 | strcat(raddr, "MIT INTERDEPARTMENTAL MAIL"); | |
573 | } | |
9f5e5c05 | 574 | EXEC SQL INSERT INTO users |
575 | (login, users_id, unix_uid, shell, last, first, middle, status, | |
8638fcf9 | 576 | clearid, type, modtime, modby, modwith, fullname, home_addr, |
577 | home_phone, office_phone, department, fmodtime, fmodby, fmodwith, | |
578 | potype, xname, xdept, xtitle, xaddress, xphone1, xphone2, xmodtime) | |
9f5e5c05 | 579 | VALUES (:login, :id, :uid, '/bin/athena/tcsh', NVL(:last,CHR(0)), |
580 | NVL(:first,CHR(0)), NVL(:middle,CHR(0)), 0, NVL(:sid,CHR(0)), | |
581 | NVL(:class,CHR(0)), SYSDATE, :who, :prog, NVL(:fullname,CHR(0)), | |
582 | NVL(:haddr,CHR(0)), NVL(:hphone,CHR(0)), NVL(:ophone,CHR(0)), | |
583 | NVL(:dept,CHR(0)), SYSDATE, :who, :prog, 'NONE', | |
584 | NVL(:name,CHR(0)), NVL(:dept,CHR(0)), NVL(:title,CHR(0)), | |
585 | NVL(:raddr,CHR(0)), NVL(:hphone,CHR(0)), NVL(:ophone,CHR(0)), | |
586 | SYSDATE); | |
837b0ec6 | 587 | if (sqlca.sqlcode != 0) { |
9f5e5c05 | 588 | dbmserr("adding user", sqlca.sqlcode); |
589 | exit(1); | |
837b0ec6 | 590 | } else |
591 | com_err(whoami, 0, "adding user %s %s", e->first, e->last); | |
8638fcf9 | 592 | } |
5e2b5b5f | 593 | |
594 | ||
837b0ec6 | 595 | |
596 | set_next_users_id(limit) | |
27736587 | 597 | int limit; |
8638fcf9 | 598 | { |
599 | EXEC SQL BEGIN DECLARE SECTION; | |
837b0ec6 | 600 | int rowcount, flag, value, retval; |
8638fcf9 | 601 | EXEC SQL END DECLARE SECTION; |
5e2b5b5f | 602 | |
9f5e5c05 | 603 | EXEC SQL SELECT value INTO :value FROM numvalues |
837b0ec6 | 604 | WHERE name = 'users_id'; |
605 | if (sqlfail()) sqlexit(); | |
8638fcf9 | 606 | if (sqlca.sqlerrd[2] != 1) { |
607 | EXEC SQL ROLLBACK; | |
608 | com_err(whoami, MR_INTERNAL, "values table inconsistancy"); | |
609 | exit(1); | |
093c49c9 | 610 | } |
5e2b5b5f | 611 | |
8638fcf9 | 612 | flag = 0; |
9f5e5c05 | 613 | EXEC SQL SELECT users_id INTO :flag FROM users |
837b0ec6 | 614 | WHERE users_id = :value; |
615 | if (sqlfail()) sqlexit(); | |
8638fcf9 | 616 | if (sqlca.sqlerrd[2] == 0) |
617 | flag = 0; | |
618 | while (flag) { | |
5e2b5b5f | 619 | value++; |
27736587 | 620 | if (limit && value > MAX_ID_VALUE) |
5e2b5b5f | 621 | value = MIN_ID_VALUE; |
8638fcf9 | 622 | flag = 0; |
9f5e5c05 | 623 | EXEC SQL SELECT users_id INTO :flag FROM users |
837b0ec6 | 624 | WHERE users_id = :value; |
625 | if (sqlfail()) sqlexit(); | |
8638fcf9 | 626 | if (sqlca.sqlerrd[2] == 0) |
627 | flag = 0; | |
5e2b5b5f | 628 | } |
629 | ||
837b0ec6 | 630 | retval = value++; |
8638fcf9 | 631 | if (limit && value > MAX_ID_VALUE) |
632 | value = MIN_ID_VALUE; | |
9f5e5c05 | 633 | EXEC SQL UPDATE numvalues SET value = :value |
837b0ec6 | 634 | WHERE name = 'users_id'; |
635 | if (sqlca.sqlcode != 0) { | |
9f5e5c05 | 636 | dbmserr("updating numvalues", sqlca.sqlcode); |
837b0ec6 | 637 | exit(1); |
638 | } | |
639 | return(retval); | |
640 | } | |
641 | ||
642 | set_next_uid(limit) | |
643 | int limit; | |
644 | { | |
645 | EXEC SQL BEGIN DECLARE SECTION; | |
646 | int rowcount, flag, value, retval; | |
647 | EXEC SQL END DECLARE SECTION; | |
648 | ||
9f5e5c05 | 649 | EXEC SQL SELECT value INTO :value FROM numvalues |
650 | WHERE name = 'unix_uid'; | |
837b0ec6 | 651 | if (sqlfail()) sqlexit(); |
652 | if (sqlca.sqlerrd[2] != 1) { | |
653 | EXEC SQL ROLLBACK; | |
654 | com_err(whoami, MR_INTERNAL, "values table inconsistancy"); | |
655 | exit(1); | |
656 | } | |
657 | ||
658 | flag = 0; | |
9f5e5c05 | 659 | EXEC SQL SELECT unix_uid INTO :flag FROM users WHERE unix_uid = :value; |
837b0ec6 | 660 | if (sqlfail()) sqlexit(); |
661 | if (sqlca.sqlerrd[2] == 0) | |
662 | flag = 0; | |
663 | while (flag) { | |
664 | value++; | |
665 | if (limit && value > MAX_ID_VALUE) | |
666 | value = MIN_ID_VALUE; | |
667 | flag = 0; | |
9f5e5c05 | 668 | EXEC SQL SELECT unix_uid INTO :flag FROM users WHERE unix_uid = :value; |
837b0ec6 | 669 | if (sqlfail()) sqlexit(); |
670 | if (sqlca.sqlerrd[2] == 0) | |
671 | flag = 0; | |
672 | } | |
673 | ||
674 | retval = value++; | |
675 | if (limit && value > MAX_ID_VALUE) | |
676 | value = MIN_ID_VALUE; | |
9f5e5c05 | 677 | EXEC SQL UPDATE numvalues SET value = :value WHERE name = 'unix_uid'; |
837b0ec6 | 678 | if (sqlca.sqlcode != 0) { |
9f5e5c05 | 679 | dbmserr("updating numvalues", sqlca.sqlcode); |
837b0ec6 | 680 | exit(1); |
681 | } | |
682 | return(retval); | |
683 | } | |
684 | ||
685 | ||
686 | sqlexit() | |
687 | { | |
9f5e5c05 | 688 | dbmserr(NULL, sqlca.sqlcode); |
837b0ec6 | 689 | EXEC SQL ROLLBACK WORK; |
690 | exit(1); | |
8638fcf9 | 691 | } |
9f5e5c05 | 692 | |
693 | dbmserr(char *where, int what) | |
694 | { | |
695 | char err_msg[256]; | |
696 | int bufsize=256, msglength=0; | |
697 | ||
698 | sqlglm(err_msg, &bufsize, &msglength); | |
699 | err_msg[msglength]=0; | |
700 | ||
701 | if(where) | |
702 | com_err(whoami, 0, "DBMS error %swhile %s", err_msg, where); | |
703 | else | |
704 | com_err(whoami, 0, "DBMS error %s", err_msg); | |
705 | } |