I just went through an exercise of removing the spam from the profile sections. Sneaky spammers putting links to really unrelated websites. Here is the query that i used

update auth_user set about = '' where reputation = 1 and about != '';

idea What if we disallow users to edit the "about" and "website" sections of their profile unless they have greater than 1 (or configurable) reputation.

Some alternative/supplementary ideas:other ideas, not really worth reading

(edit)

I just went through an exercise of removing the spam from the profile sections. Sneaky spammers putting links to really unrelated websites. Here is the query that i used

update auth_user set about = '' where reputation = 1 and about != '';

idea What if we disallow users to edit the "about" and "website" sections of their profile unless they have greater than 1 (or configurable) reputation.

Things that can have links like the personal website or profile description when edited could come to the attention of the admin.

At the moment, I do a regular manual check myself of the profile descriptions to see and ban people posting spam in there.

Banning a user could also delete all of their posts. But that is less of an issue right now.

update auth_user set about = '' where reputation = 1 and about != '';

Things that can have links like the personal website or profile description when edited could come to the attention of the admin.

At the moment, I do a regular manual check myself of the profile descriptions to see and ban people posting spam in there.

Banning a user could also delete all of their posts. But that is less of an issue right now.