Search by signature?

The place for discussions and decisions about the forum

Search by signature?

Postby RGB » Sun Feb 12, 2012 2:46 pm

On the Forum ACP I can search users by their user name, e-mail address, ICQ... but I cannot find a way to search users "by signature". The idea is to search for signatures with the "url" or "http" tag to spot spammers more quickly, without going one by one. Is this possible?
Thanks!
There are two types of people: those who believe that there are two types of people and those who do not.

openSUSE Leap with KDE Plasma / LibO
User avatar
RGB
 
Posts: 1454
Joined: Mon Oct 08, 2007 1:34 am

Re: Search by signature?

Postby acknak » Sun Feb 12, 2012 5:14 pm

I'm not sure, but as I understand, Terry was making such queries by direct SQL commands on the raw tables; if he had to use that approach, my guess is that there's no easier method.

But I could certainly be wrong...
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Search by signature?

Postby RGB » Sun Feb 12, 2012 5:43 pm

acknak wrote:I'm not sure, but as I understand, Terry was making such queries by direct SQL commands on the raw tables; if he had to use that approach, my guess is that there's no easier method.

That was my guess too. Problem is that members list page to not show signatures either... oh, well.
There are two types of people: those who believe that there are two types of people and those who do not.

openSUSE Leap with KDE Plasma / LibO
User avatar
RGB
 
Posts: 1454
Joined: Mon Oct 08, 2007 1:34 am

Re: Search by signature?

Postby TerryE » Thu Feb 16, 2012 2:18 pm

If you go into the Members View you can order by website and location, but not by signature. As acknak says, you need to do this by a MySQL query -- but this is really the subject of a wider topic.
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
TerryE
Volunteer
 
Posts: 1402
Joined: Sat Oct 06, 2007 10:13 pm
Location: UK

Re: Search by signature?

Postby DrewJensen » Thu Feb 16, 2012 7:44 pm

Can I interject something here - It seems to me that the hunt for spammers is getting a bit out of hand.

There is the obvious stuff, great - but this idea that everyone referencing another site is a spammer is just not correct.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Search by signature?

Postby Hagar Delest » Thu Feb 16, 2012 10:31 pm

Then check the links in the website field! See this query. Almost 100% of the links are coupled with a link in the signature pointing to commercial sites. From the beginning of this year, I change the location field to 'Spam link removed', and there is a bunch of such users. Most of them don't post at all, that's why they get unnoticed.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Search by signature?

Postby floris v » Thu Feb 16, 2012 10:36 pm

You can sort users by website and that looks promising.
AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4137
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Search by signature?

Postby Hagar Delest » Thu Feb 16, 2012 11:03 pm

Yes but since there are some valid links, it's easier to have a look at the latest members at each visit, the links are very visible (few in the list in fact).
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28543
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Forum Governance

Who is online

Users browsing this forum: No registered users and 3 guests