Home
last modified time | relevance | path

Searched refs:DBPFX (Results 1 – 15 of 15) sorted by relevance

/dports/mail/dbmail/dbmail-3.2.5/src/
H A Ddm_sievescript.c27 #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 Ddm_db.c1276 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 Dmaintenance.c33 #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 Ddm_mailbox.c188 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 Ddm_message.c28 #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 Ddm_mailboxstate.c34 #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 Dexport.c34 #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 Dclientbase.c32 #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 Ddm_imapsession.c38 #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 Dpop3.c96 #define DBPFX db_params.pfx macro
123 "ORDER BY msg.message_idnr ASC",DBPFX,DBPFX, in db_createsession()
H A Dimapcommands.c36 #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 Dauthsql.c31 #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 Dcheck_dbmail_imapd.c43 #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 Dcheck_dbmail_message.c953 #define DBPFX db_params.pfx macro
964 DBPFX, physid); in test_db_get_subject()
H A Dcheck_dbmail_mailbox.c42 #define DBPFX db_params.pfx macro