1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Silverpop Integration 0.0.3

This is an add-on allows you to integrate Silverpop

  1. Radi
    Compatible XF Versions:
    • 1.5
    Visible Branding:
    No
    Please submit any bugs or feature requests here: https://github.com/rvarbanov/XenForo-SilverpopIntegration/issues

    This is an add-on for XenForo that allows you to integrate Silverpop

    A mysql query that I used to export the xenforo user emails to use on Silverpop:

    SELECT u.user_id AS xf_user_id, u.username AS xf_username, u.email AS Email, IF(uo.receive_admin_email = 0, 'No', 'Yes') AS _newswire_subscription
    FROM xf_user u
    JOIN xf_user_option uo ON u.user_id = uo.user_id
    WHERE 1
    AND uo.receive_admin_email = 1
    AND u.user_state = 'valid'
    AND u.is_banned = 0
    AND u.email != ''

    LIMIT 0, 9999999999999
    THLove likes this.