The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Prune users that are absuing the forum for backlinking.
Looks like I have thousands of users on my forum that have a link in their signature and never have even posted once, they are using the backlinks from the member list. Is there a creative way to delete all these slackers?
|
#2
|
|||
|
|||
What I ended up doing is creating a new usergroup and running a few SQL statements to put all users with 0 posts and url in signature or visitor messages into that group and then just using the built in prune users tool to wipe them out:
Code:
UPDATE user SET usergroupid=14 WHERE posts = 0 and lastactivity < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 MONTH)) and userid = ANY (SELECT userid FROM `usertextfield` WHERE `signature` LIKE'%url%') Code:
UPDATE user SET usergroupid=14 WHERE posts = 0 and lastactivity < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 MONTH)) and userid = ANY (SELECT userid FROM `visitormessage` WHERE `pagetext` LIKE'%url%') |
Благодарность от: | ||
BirdOPrey5 |
#3
|
|||
|
|||
I also realized that some of these users were pretty creative and using the homepage field in their profile to get backlinks and actually post a reply somewhere with easy questions like "how come the link is not working, I cannot download", their signature would have something and so would their profile with the link to their garbage.
Here is a SQL query that finds these parasites: Code:
update `user` set usergroupid=14 WHERE `lastactivity` - `joindate` < 86400 and `homepage` > "" and `homepage` != "http://" and posts = 0; I've deleted about 20,000 accounts from my forum just by running these queries. I also disabled BB URL in Signature and Visitor messages and disabled memberlist and leaving visitor messages to one self. |
#4
|
|||
|
|||
So guess what? I disabled members list and I figured that is all I'll need to do. Nope, these SEO backlink scammers are still creating profiles. Took me a little while to figure out why, but they are doing it because of the calendar. Calendar has all the birthdays for all the members, so they usernames can be clicked on and they have their profiles with the URLs. I've again deleted 13,000 fake accounts using the above methods.
I strongly advise that people start removing these accounts, they are nothing but scummy people that charge legitimate website owners to "optimize" their search engine rankings by posting these messages. Us, forum owners should fight to stop this junk from clogging up our own forums. Further this hurts our own search engine results as it makes the entire forum seem like a backlinking site to the entire world. |
#5
|
||||
|
||||
Thanks for the update - it sounds like there are a ton of bot registrations on your site. You should consider installing some kind of spam prevention system, especially one that tracks the time it takes for the register page for to be filled out and/or bad behavior.
|
#6
|
||||
|
||||
Try the odd I described in this post, http://ozzmodz.com/showthread.php/50...g-Spam-Is-Over
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|