struct timeval now;
EXEC SQL BEGIN DECLARE SECTION;
char login[9], sig[257], id[17], kname[257];
- int timestamp, cutoff;
+ int timestamp;
struct { char login[12];
char id[12];
char sig[256];
outf = NULL;
}
- /* the cutoff time is 14 days before now */
- gettimeofday(&now, NULL);
- cutoff = now.tv_sec - 14 * 24 * 60 * 60;
-
/* The following is declarative, not executed,
* and so is dependent on where it is in the file,
* not in the order of execution of statements.
SELECT u.login, u.clearid, u.signature, u.sigdate, s.string
FROM users u, strings s
WHERE u.status = 1 and u.sigwho = s.string_id and u.sigwho != 0
- and u.secure <= :cutoff and u.secure != 0;
+ and u.secure != 0;
EXEC SQL OPEN x;
while (1) {
EXEC SQL FETCH x INTO :login, :id, :sig, :timestamp, :kname;