Deleting members from database with a specific email account

[georgec]

Thanks for the response. The problem is there are over 1000 members who are using the same email service (ie: @yahoo.com) and who are spammers that I wish to delete or ban quickly. There doesn't seem...

[georgec]

Hi:
I wish to delete all members that share a particular email account (ie: @yahoo.com). Am I correct I can simply go into phpmyadmin and run the following query:

delete from user where

...

[georgec]

Just a note that I had the exact same problem with Style Variable Editor returning errors and not saving the changes, and what Mark posted worked for me too. Thanks,

[georgec]

For future reference, truncating usercss seems to have fixed the problem for me. Running mysqlcheck now successfully goes through, and the profile pages are accessible again on the forums.

...

[georgec]

Thanks, before I try that though, just wondering, is running the command:

truncate usercss

also something that may work as Wayne posted a while ago?

[georgec]

Hi:
Thanks, but I've run Repair / Optimize Tables in the vBulletin CP a few times already, the results are the same as running mysqlcheck in SSH.

[georgec]

Hi:
I recently upgraded mysql from 4.x to 5.1, and ever since, viewing one's own profile page no longer works and generated a database error. I'm running 4.2.0 Patch Level 3. The error returned...

[georgec]

I just upgraded to vBulletin 4 a few days ago, and get the below mysql error periodically:

Database error in vBulletin 4.2.0:  Invalid SQL:  				SELECT tagsearch.tagid, tag.tagtext,

...

[georgec]

Hi:
Thanks for the reply. I'm uploading the xml file from my server (./includes/xml/product-vbblog.xml), with "overwrite" set to yes, and no errors are shown upon importing. Also just...

[georgec]

Hi:
I'm attempting to upgrade vBulletin Blog from version 2.01 to 2.04 (I'm running VB 3.8.1) following the instructions laid out here: https://www.vbulletin.com/docs/html?...ersion=3080160...

[georgec]

I'm also trying to track down spam that has purportedly been sent from my vBulletin software; can vBulletin confirm whether the above indeed is a loophole that may enable a spammer to rely spam through...

[georgec]

Thanks. In this case the two usernames appear identical though- I don't discern any special characters of spacing used in the duplicate username.

[georgec]

Hi:
As the admin my username on a forum (VB 3.8.1) I run is "ddadmin". I just noticed a new member with the exact same username sign up 2 weeks ago, and successfully so. Doing a search...

[georgec]

There seems to be conflicting info on this- in the readme.txt file, it says users with boards lesser than 3.8.4 need to make the jump to that version first, while in the vBulletin manual, it says:...

[georgec]

Hi:
I just installed vBlog, though the default frontpage layout differs from vBulletin's own blog frontpage. Is this because VB has customized the layout, or is it available as an prebuilt option...

[georgec]

Hi:
I've recently moved our forums to a different server. While the search engine friendly URL feature appears to be working in general, I'm noticing that those URLs with a "?" no longer...

[georgec]

Ah, so per my original question:



Is there no way for non supermods to be able to use the "delete spam" options as they are intended for- quickly removing all spam...

[georgec]

Hi:
Yep, I've checked, and all mods have:

Can Ban Users: enabled
Can Delete Posts: enabled
Can Mass-Prune Threads: enabled

However, mods for a specific category...

[georgec]

Hi:
Just a question- does the "Delete threads or posts as spam" option basically only work forum wide for supermods? I have mods for individual categories that complain that when they...

[georgec]

Hi:
Just wondering, inside vBulletin templates, is there a way to distinguish between a moderator for one forum category versus another using if statements? I'm looking to alter one of the templates...