EXEC SQL INCLUDE sqlca;
extern char *whoami;
-char *malloc();
int inc_pid = 0;
int inc_running = 0;
FROM users u WHERE :qual;
beforec = 9;
} else if (!strcmp(table, "machine")) {
- EXEC SQL SELECT m.name, m.type INTO :barg0, :barg1 FROM machine m
+ EXEC SQL SELECT m.name, m.vendor INTO :barg0, :barg1 FROM machine m
WHERE :qual;
beforec = 2;
} else if (!strcmp(table, "cluster")) {
beforec = 10;
} else if (!strcmp(table, "members")) {
id = (int) argv[0];
- EXEC SQL SELECT CHAR(grouplist) INTO :barg3 FROM list
- WHERE list_id = :id;
+ EXEC SQL SELECT CHAR(active), CHAR(publicflg), CHAR(hidden),
+ CHAR(maillist), CHAR(grouplist), CHAR(gid)
+ INTO :barg3, :barg4, :barg5, :barg6, :barg7, :barg8
+ FROM list WHERE list_id = :id;
name = malloc(0);
id_to_name(id, "LIST", &name);
strcpy(barg0, name);
strcpy(barg1, argv[1]);
id = (int) argv[2];
+ beforec = 9;
if (!strcmp(barg1, "USER")) {
id_to_name(id, barg1, &name);
+ EXEC SQL SELECT CHAR(status) INTO :barg9 FROM users
+ WHERE users_id=:id;
+ beforec = 10;
} else if (!strcmp(barg1, "LIST")) {
id_to_name(id, barg1, &name);
} else if (!strcmp(barg1, "STRING")) {
}
strcpy(barg2, name);
free(name);
- beforec = 4;
} /* else
com_err(whoami, 0, "unknown table in incremental_before"); */
}
FROM users u WHERE :qual;
afterc = 9;
} else if (!strcmp(table, "machine")) {
- EXEC SQL SELECT m.name, m.type INTO :aarg0, :aarg1
+ EXEC SQL SELECT m.name, m.vendor INTO :aarg0, :aarg1
FROM machine m WHERE :qual;
afterc = 2;
} else if (!strcmp(table, "cluster")) {
strcpy(aarg0, "?");
strcpy(aarg1, argv[1]);
strcpy(aarg2, "?");
- sprintf(buffer, "%s and fs.filsys_id = q.filsys_id", qual);
+ sprintf(buffer, "%s and fs.filsys_id = q.filsys_id and q.type = '%s'",
+ qual, argv[1]);
qual = buffer;
EXEC SQL SELECT CHAR(q.quota), fs.name INTO :aarg3, :aarg4
FROM quota q, filesys fs WHERE :qual;
afterc = 10;
} else if (!strcmp(table, "members")) {
id = (int) argv[0];
- EXEC SQL SELECT CHAR(grouplist) INTO :aarg3 FROM list
- WHERE list_id = :id;
+ EXEC SQL SELECT CHAR(active), CHAR(publicflg), CHAR(hidden),
+ CHAR(maillist), CHAR(grouplist), CHAR(gid)
+ INTO :aarg3, :aarg4, :aarg5, :aarg6, :aarg7, :aarg8
+ FROM list WHERE list_id = :id;
name = malloc(0);
id_to_name(id, "LIST", &name);
strcpy(aarg0, name);
strcpy(aarg1, argv[1]);
id = (int) argv[2];
+ afterc = 9;
if (!strcmp(aarg1, "USER")) {
id_to_name(id, aarg1, &name);
+ EXEC SQL SELECT CHAR(status) INTO :aarg9 FROM users
+ WHERE users_id=:id;
+ afterc = 10;
} else if (!strcmp(aarg1, "LIST")) {
id_to_name(id, aarg1, &name);
} else if (!strcmp(aarg1, "STRING")) {
}
strcpy(aarg2, name);
free(name);
- afterc = 4;
} else if (!strcmp(table, "clear")) {
afterc = 0;
table = beforetable;