/dports/mail/dbmail/dbmail-3.2.5/src/ |
H A D | dm_sievescript.c | 27 #define DBPFX db_params.pfx macro 38 …= db_stmt_prepare(c, "SELECT script FROM %ssievescripts WHERE owner_idnr = ? AND name = ?", DBPFX); in dm_sievescript_getbyname() 71 …= db_stmt_prepare(c, "SELECT name FROM %ssievescripts WHERE owner_idnr = ? AND active = 1", DBPFX); in dm_sievescript_isactive_byname() 116 …r = db_query(c,"SELECT name,active FROM %ssievescripts WHERE owner_idnr = %" PRIu64 "", DBPFX,user… in dm_sievescript_list() 147 … = db_stmt_prepare(c,"SELECT active FROM %ssievescripts WHERE owner_idnr = ? AND name = ?", DBPFX); in dm_sievescript_rename() 157 s = db_stmt_prepare(c, "DELETE FROM %ssievescripts WHERE owner_idnr = ? AND name = ?", DBPFX); in dm_sievescript_rename() 194 … db_stmt_prepare(c,"SELECT COUNT(*) FROM %ssievescripts WHERE owner_idnr = ? AND name = ?", DBPFX); in dm_sievescript_add() 203 s = db_stmt_prepare(c,"DELETE FROM %ssievescripts WHERE owner_idnr = ? AND name = ?", DBPFX); in dm_sievescript_add() 261 s = db_stmt_prepare(c,"UPDATE %ssievescripts SET active = 0 WHERE owner_idnr = ? ", DBPFX); in dm_sievescript_activate() 267 …db_stmt_prepare(c,"UPDATE %ssievescripts SET active = 1 WHERE owner_idnr = ? AND name = ?", DBPFX); in dm_sievescript_activate() [all …]
|
H A D | dm_db.c | 1276 DBPFX,DBPFX,DBPFX,user_idnr, MESSAGE_STATUS_DELETE); in dm_quota_rebuild_user() 1324 DBPFX,DBPFX,MESSAGE_STATUS_DELETE); in dm_quota_rebuild() 1433 "AND %smessages.message_idnr = %" PRIu64 "", DBPFX,DBPFX,DBPFX, in db_get_useridnr() 1434 DBPFX,DBPFX,DBPFX,message_idnr); in db_get_useridnr() 1622 "WHERE l.part_id IS NULL", DBPFX, DBPFX); in db_icheck_mimeparts() 2258 DBPFX, DBPFX, DBPFX); in mailboxes_by_regex() 2938 "AND p.internal_date > %s", DBPFX, DBPFX, DBPFX, DBPFX, DBPFX, in db_mailbox_has_message_id() 3041 DBPFX, *newmsg_idnr, DBPFX, msg_idnr); in db_copymsg() 3414 "AND %susers.user_idnr = %sacl.user_id",DBPFX,DBPFX,DBPFX, in db_acl_get_identifier() 3415 DBPFX,mboxid,DBPFX,DBPFX); in db_acl_get_identifier() [all …]
|
H A D | maintenance.c | 33 #define DBPFX db_params.pfx macro 368 r = db_query(c, "SELECT COUNT(*) FROM %spbsp WHERE since < %s", DBPFX, to_date_str); in db_count_iplog() 385 return db_update("DELETE FROM %spbsp WHERE since < %s", DBPFX, to_date_str); in db_cleanup_iplog() 399 r = db_query(c, "SELECT COUNT(*) FROM %sreplycache WHERE lastseen < %s", DBPFX, to_date_str); in db_count_replycache() 416 return db_update("DELETE FROM %sreplycache WHERE lastseen < %s", DBPFX, to_date_str); in db_cleanup_replycache() 426 …r = db_query(c, "SELECT COUNT(*) FROM %smessages WHERE status = %d", DBPFX, MESSAGE_STATUS_DELETE); in db_count_deleted() 446 return db_update("DELETE FROM %smessages WHERE status=%d", DBPFX, MESSAGE_STATUS_PURGE); in db_deleted_purge() 455 r = db_query(c, "SELECT COUNT(*) FROM %smessages WHERE status=%d", DBPFX, MESSAGE_STATUS_PURGE); in db_deleted_count() 1037 db_update("DELETE FROM %smessageblks WHERE physmessage_id = %d", DBPFX, id); in do_migrate() 1162 DBPFX, DBPFX, DBPFX, MESSAGE_STATUS_DELETE, expire); in do_erase_old() [all …]
|
H A D | dm_mailbox.c | 188 DBPFX, DBPFX, DBPFX); in _mimeparts_dump() 312 DBPFX, DBPFX, DBPFX, DBPFX, in dbmail_mailbox_orderedsubject() 350 DBPFX, DBPFX, DBPFX, DBPFX, in dbmail_mailbox_orderedsubject() 1122 "ORDER BY %smessage_idnr", DBPFX, DBPFX, s->table, in _do_sort() 1241 DBPFX, DBPFX, DBPFX, DBPFX, in mailbox_search() 1263 DBPFX, DBPFX, DBPFX, DBPFX, in mailbox_search() 1291 DBPFX, DBPFX, DBPFX, DBPFX, DBPFX, DBPFX, in mailbox_search() 1322 DBPFX, DBPFX, DBPFX, DBPFX, DBPFX, in mailbox_search() 1347 DBPFX, DBPFX, in mailbox_search() 1370 DBPFX, DBPFX, in mailbox_search() [all …]
|
H A D | dm_message.c | 28 #define DBPFX db_params.pfx macro 140 " AND a.id<>b.id AND b.id=?", DBPFX); in blob_exists() 390 frag, p_string_str(n), DBPFX, DBPFX, DBPFX); in _mime_retrieve() 1034 …snprintf(query, DEF_QUERYSIZE-1, query_template, frag, DBPFX, DBPFX, dbmail_message_get_physid(sel… in _retrieve() 1120 DBPFX, size, rfcsize, self->id)) in _update_message() 1124 DBPFX, MESSAGE_STATUS_NEW, self->msg_idnr)) in _update_message() 1218 DBPFX, &to_date_str, frag); in insert_physmessage() 1221 DBPFX, &to_date_str, frag); in insert_physmessage() 1225 DBPFX, db_get_sql(SQL_CURRENT_TIMESTAMP), frag); in insert_physmessage() 1449 db_get_sql(SQL_IGNORE), DBPFX, frag); in _header_name_get_id() [all …]
|
H A D | dm_mailboxstate.c | 34 #define DBPFX db_params.pfx macro 102 DBPFX, DBPFX, in state_load_messages() 220 DBPFX, DBPFX, in state_load_messages() 880 DBPFX); in db_getmailbox_permission() 904 DBPFX, DBPFX); in db_getmailbox_info() 991 DBPFX, MESSAGE_STATUS_DELETE); in db_getmailbox_count() 1022 DBPFX); in db_getmailbox_count() 1041 DBPFX, DBPFX, MESSAGE_STATUS_DELETE); in db_getmailbox_keywords() 1056 DBPFX); in db_getmailbox_seq() 1178 DBPFX); in MailboxState_hasPermission() [all …]
|
H A D | export.c | 34 #define DBPFX db_params.pfx macro 261 …if (delete_after_dump) db_update("UPDATE %smailboxes SET seq=seq+1 WHERE mailbox_idnr=%d",DBPFX,ma… in do_export()
|
H A D | clientbase.c | 32 #define DBPFX db_params.pfx macro 512 " VALUES (?, ?, %s, %s, ?, ?, ?, ?, ?) %s", DBPFX, now, now, frag); in ci_authlog_init() 543 "WHERE id=?", DBPFX, now); in ci_authlog_close()
|
H A D | dm_imapsession.c | 38 #define DBPFX db_params.pfx macro 802 DBPFX, in _fetch_headers() 843 DBPFX, DBPFX, DBPFX, DBPFX, in _fetch_headers() 1048 DBPFX, DBPFX, in _fetch_envelopes() 1808 …if (db_exec(self->c, "UPDATE %smessages SET status=%d WHERE message_idnr=%" PRIu64 " ", DBPFX, MES… in _do_expunge()
|
H A D | pop3.c | 96 #define DBPFX db_params.pfx macro 123 "ORDER BY msg.message_idnr ASC",DBPFX,DBPFX, in db_createsession()
|
H A D | imapcommands.c | 36 #define DBPFX db_params.pfx macro 946 …db_exec(c, "UPDATE %smessages SET status=%d WHERE mailbox_idnr = %" PRIu64 "", DBPFX, MESSAGE_STAT… in _ic_delete_enter() 947 …db_exec(c, "UPDATE %smailboxes SET no_select = 1 WHERE mailbox_idnr = %" PRIu64 "", DBPFX, mailbox… in _ic_delete_enter()
|
/dports/mail/dbmail/dbmail-3.2.5/src/modules/ |
H A D | authsql.c | 31 #define DBPFX db_params.pfx macro 65 r = db_query(c, "SELECT userid FROM %susers ORDER BY userid",DBPFX); in auth_get_known_users() 84 r = db_query(c,"SELECT alias FROM %saliases ORDER BY alias",DBPFX); in auth_get_known_aliases() 170 DBPFX); in user_get_deliver_to() 372 r = db_query(c, "SELECT passwd FROM %susers WHERE user_idnr = %" PRIu64 "", DBPFX, user_idnr); in auth_md5_validate() 419 r = db_query(c, "SELECT userid FROM %susers WHERE user_idnr = %" PRIu64 "", DBPFX, user_idnr); in auth_get_userid() 437 r = db_query(c, "SELECT userid FROM %susers WHERE user_idnr = %" PRIu64 "", DBPFX, user_idnr); in auth_check_userid() 458 "AND client_idnr = ?",DBPFX); in auth_addalias() 518 "AND client_idnr = ? ",DBPFX); in auth_addalias_ext() 529 "AND lower(deliver_to) = lower(?) ",DBPFX); in auth_addalias_ext() [all …]
|
/dports/mail/dbmail/dbmail-3.2.5/test/ |
H A D | check_dbmail_imapd.c | 43 #define DBPFX db_params.pfx macro 806 g_string_printf(q,"select id from %sphysmessage order by id desc limit 1", DBPFX); 816 g_string_printf(q,"select message_idnr from %smessages order by message_idnr desc limit 1", DBPFX);
|
H A D | check_dbmail_message.c | 953 #define DBPFX db_params.pfx macro 964 DBPFX, physid); in test_db_get_subject()
|
H A D | check_dbmail_mailbox.c | 42 #define DBPFX db_params.pfx macro
|