3 * This program will change UIDs on users who are not active so that
12 #include <moira_site.h>
14 #define MAX_ID_VALUE 31999
15 #define MIN_ID_VALUE 101
25 struct save_queue *sq;
26 int found, status, wait, i;
33 for (i = 1; i < argc; i++) {
34 if (!strcmp(argv[i], "-w"))
36 else if (!strcmp(argv[i], "-D"))
37 setenv("ING_SET", "set printqry");
39 fprintf(stderr, "Usage: %s [-w] [-D]\n", argv[0]);
43 ## range of u is users
48 ## retrieve (id = u.users_id)
49 ## where u.#uid >= 32000 and (u.status = 0 or u.status = 4) {
54 printf("Found %d users to change.\n", found);
56 while (sq_get_data(sq, &id)) {
57 uid = set_next_object_id("uid", 1);
58 ## replace u (#uid = uid) where u.users_id = id
70 set_next_object_id(object, limit)
75 ## int rowcount, exists, value;
79 ## repeat retrieve (value = values.#value) where values.#name = @name
80 ## inquire_equel(rowcount = "rowcount")
86 ## retrieve (exists = any(users.name where users.name = value))
87 ## inquire_equel(rowcount = "rowcount")
94 if (limit && value > MAX_ID_VALUE)
96 ## retrieve (exists = any(users.name where users.name = value))
99 ## repeat replace values (#value = @value) where values.#name = @name