Announcement

Collapse
No announcement yet.

paid subs, email list

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    dalai
    Senior Member

  • dalai
    replied
    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

    Craig

    Leave a comment:

  • Trevor Hannant
    vBulletin Support

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

    Code:
    SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate, user.username, user.email, 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

    Leave a comment:

  • dalai
    Senior Member

  • dalai
    started a topic paid subs, email list

    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).

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