Snippets-logo-small
  • TYPO3 Typoscript
  • TYPO3 TSConfig
  • TYPO3 Install Tool
  • TYPO3 allg
  • Git
  • Javascript - JQuery
  • Unix
  • css
  • regular expressions
  • php
  • SQL
  • Ruby on Rails
  • Einrichtung
  • directmail
  • Allgemeine Layout-Anpassungen

directmail

  • bounce emails finden 

    1
    2
    
    # mid ist die id des newsletters
    SELECT email FROM sys_dmail_maillog WHERE return_code <> 0 AND mid = 95 AND return_code != 551;
    by stefan
  • bounce emails finden und in isbdb löschen 

    1
    2
    3
    
    # mid ist die id des newsletters
    
    UPDATE `tx_isbdb_persons` SET tx_isbdb_persons.email ='' WHERE email LIKE '%@%' and EXISTS ( SELECT email FROM sys_dmail_maillog WHERE return_code <> 0 AND mid = 95 AND return_code != 551 and sys_dmail_maillog.email = tx_isbdb_persons.email) 
    by stefan
This site is made by tan3