EXEC SQL DECLARE csr102 CURSOR FOR
SELECT users_id, login, last, first, status, potype, pop_id, box_id,
- modby, fmodby, pmodby, comments, sigwho FROM users
+ imap_id, modby, fmodby, pmodby, comments, sigwho FROM users
ORDER BY users_id;
EXEC SQL OPEN csr102;
while (1)
char login[USERS_LOGIN_SIZE], nbuf[USERS_FIRST_SIZE + USERS_LAST_SIZE];
char last[USERS_LAST_SIZE], first[USERS_FIRST_SIZE];
char potype[USERS_POTYPE_SIZE];
- int users_id, status, pop_id, box_id, modby, fmodby, pmodby;
+ int users_id, status, pop_id, box_id, imap_id, modby, fmodby, pmodby;
int comments, sigwho;
EXEC SQL END DECLARE SECTION;
EXEC SQL FETCH csr102 INTO :users_id, :login, :last, :first,
- :status, :potype, :pop_id, :box_id, :modby, :fmodby, :pmodby,
- :comments, :sigwho;
+ :status, :potype, :pop_id, :box_id, :imap_id, :modby, :fmodby,
+ :pmodby, :comments, :sigwho;
if (sqlca.sqlcode)
break;
/* If potype is SMTP, box_id is a string_id for the strings tbl */
u->pobox_id = box_id;
break;
+ case 'I':
+ u->pobox_id = imap_id;
+ break;
default:
u->pobox_id = 0;
}