Announcement

Collapse
No announcement yet.

sql needed

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • sql needed

    If someone could give me the SQL for the following I would be grateful...

    1. Find all users who've not logged in for 365 days and move them to a specific group.

    2. Unsubscribe users in a specific group from email notifications.

    3a. Find all users registered to a specific timezone.

    3b. Find all users registered to a specific timezone and move them to a specific group.

    Thanks...

    hugh
    Please vote for my enhancement requests: 1, 2, 3 and 4...

  • #2
    1. AdminCP -> Users -> Prune / Move Members

    Don't have an answer ready for the other questions, please let us know if you still need those.
    Want to take your board beyond the standard vBulletin features?
    Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

    Comment

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