Announcement

Collapse
No announcement yet.

Remove All With A Certain Email Type

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

  • Lats
    replied
    Glad it worked for you

    Leave a comment:


  • volarium
    replied
    Thank you so much for the quick response, this worked like a charm!

    Leave a comment:


  • Lats
    replied
    Try this...
    Code:
    UPDATE
        user
    LEFT JOIN
        userfield
    ON
        user.userid = userfield.userid 
    SET 
        usergroupid = 10
    WHERE 
        userfield.field6 LIKE '%html%'

    Leave a comment:


  • volarium
    replied
    Can anyone provide guidance on how to apply this query to a custom profile field? Here is what I have:
    Code:
     
     
    UPDATE user
    SET usergroupid = 10
    WHERE $bbuserinfo[field6] LIKE '%html%'
    This gives me a SQL syntax error.
    Thanks in advance.

    Leave a comment:


  • Trevor Hannant
    replied
    Originally posted by ximcix View Post
    Excellent.
    thanks for that tip Jake

    If only this could be accomplished via "Search For Users" using the email field then the results could be pruned, it would make life so much easier.
    Pop it in the Suggestions forum....

    Leave a comment:


  • ximcix
    replied
    Excellent.
    thanks for that tip Jake

    If only this could be accomplished via "Search For Users" using the email field then the results could be pruned, it would make life so much easier.

    Leave a comment:


  • Jake Bunce
    replied
    Change X to the usergroupid of the destination group which you will later prune.

    Leave a comment:


  • deep_blue
    replied
    hi

    when i am running this query in SQL, it is saying

    An error occurred while attempting to execute your query. The following information was returned.
    error number: 1054
    error desc: Unknown column 'X' in 'field list'

    Leave a comment:


  • Jake Bunce
    replied
    I recommend you run a query to put those users into a new group, then prune by group. Use this query:

    Code:
    UPDATE user
    SET usergroupid = X
    WHERE email LIKE '%@spam.com%'
    Where X is the usergroupid of the new group. Now prune by group:

    Admin CP -> Users -> Prune / Move Users

    Leave a comment:


  • gobbly2100
    started a topic Remove All With A Certain Email Type

    Remove All With A Certain Email Type

    Is it possible to remove all users with a certain kind of email address, For example remove everyone who has an email such as @spam.com ?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X