No announcement yet.

paid subs, email list

  • Filter
  • Time
  • Show
Clear All
new posts

  • paid subs, email list

    im sure someone must have asked it before, but is there an easy way of generating an email list for users who have paid subscription expiring between 2 dates.

    i have over 1000 members who have paid subs, and i want to email only the ones who are due to expire in the next month, to offer them a discount.

    i cant find anything in the manual, and even a sql query would help, but i dont know where to query it (tables, fields).


  • #2
    If it's any help, this is the query from the includes/cron/subscriptions.php file that determines who is to get the reminders:

    SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate, user.username,, user.languageid
            FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)
            WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
                AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "
                AND status = 1
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...


    • #3
      i did run this, but got an error, my tables are VB_ then the table name, but the error was a syntax error, not an uknown table/column.

      any other thoughts



      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.