Re: [Extension release] URL Checker For Posts And Signatures

The latest, I believe - 0.4.0.

It does say this:

DELETED    122.174.181.133    http://www.ekgtechnicianclasses.com    2010-09-02    sig

But I still had to manually delete the user.

27 (edited by TomeOne 2010-09-02 15:20)

Re: [Extension release] URL Checker For Posts And Signatures

It could be that the jerk re-registered, though. He only had the URL in the website part of his profile's contact info.

Would be useful if the table showed the person's username instead of replacing it with "DELETED."

28

Re: [Extension release] URL Checker For Posts And Signatures

TomeOne wrote:

He only had the URL in the website part of his profile's contact info.

True, forgot about controlling website in user's info. I should add it in 0.5

TomeOne wrote:

Would be useful if the table showed the person's username instead of replacing it with "DELETED."

I'll think about that smile)

Eraversum - scifi browser-based online webgame

29

Re: [Extension release] URL Checker For Posts And Signatures

But I can confirm the signatures is working perfectly. Just noticed a user registering, googled username, saw that on other page he puts link to "example.com" - checked the list to see if I had that URL on it. I did.  2 minutes later I checked back, user gone big_smile Went to admin panel and saw info about deleted.... love it when it works. Just need more URLs and a realtime query possibility...

30

Re: [Extension release] URL Checker For Posts And Signatures

I've added all the spam data to a new table called 'spamurls'
with this code;
[code=sql]
CREATE TABLE `spamurls` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(150) NOT NULL default '',
  `keyword` varchar(100) NOT NULL default '',
  `position` varchar(4) NOT NULL default '',
  `type` varchar(25) NOT NULL default '',
  `date` date NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM
[/code]

big_smile Now the question is, how do I most effiencently check that table (instead of using the .csv) ?

31

Re: [Extension release] URL Checker For Posts And Signatures

@Grez:
In the extension, why aren't we using normal string functions to cut everything out of the url tags till we reach http ( so we don't lose the spammers using backslashes ? and shouldn't the function be in double quote instead of single quote?

then we could use
[code=php]
$beginnhttp=strpos($url,"http");
$url=substr($url,$beginnhttp);
[/code]
I was told big_smile

32

Re: [Extension release] URL Checker For Posts And Signatures

KeyDog wrote:

why aren't we using normal string functions to cut everything out of the url tags till we reach http

Because I was lazy to implement it... big_smile (It's planned for next version wink)

Eraversum - scifi browser-based online webgame

33

Re: [Extension release] URL Checker For Posts And Signatures

Ok good to know;

also worth noting;
- remember that if a link has no http:// strpos will return FALSE, which permits us to insert http://  so the old pattern works again
- to standardise caps with str_tolower

don't know if that will help you...

34

Re: [Extension release] URL Checker For Posts And Signatures

Small bug: Just noticed it shows more than 25 last entries. Here for example over 35! Good news: It's working well!

Another issue that needs adressing;

If I catch a spammer using URL   
badurl.com/bad

then ban
badurl.com

it doesn't catch anything if they use  badurl.com/2bad  (example)

35

Re: [Extension release] URL Checker For Posts And Signatures

New version

URL Checker v 0.5

New killer feature
- from now on we cross-check urls with KeyDog's db and not .csv file => you'll always have latest possible version smile

BTW since we're checking url with other website, the url check is now only when you hit "send" (not preview). As well there's 3s limit for loading url (=> when KeyDog's website is off-line your forum won't stop working) smile

KeyDog wrote:

Small bug: Just noticed it shows more than 25 last entries.

Fixed

KeyDog wrote:

If I catch a spammer using URL   
badurl.com/bad

then ban
badurl.com

Actually I'd rather not do that... We would increase the chance of catching "wrong" url, and I guess people wouldn't be happy if they'd get deleted, cause of that big_smile

Eraversum - scifi browser-based online webgame

36

Re: [Extension release] URL Checker For Posts And Signatures

Very nice indeed. Installed here and working smile

Grez wrote:

Actually I'd rather not do that... We would increase the chance of catching "wrong" url, and I guess people wouldn't be happy if they'd get deleted, cause of that big_smile

It's just that often they'll spam using   thesite.com/    thesite.com/link1     but then start another campaign where they use   thesite.com/2ndlink
so I only add if I'm sure that particular domain is spammy.
Domains like youtube, etc wouldn't get added that way.... so that chances are EXTREMELY small you'd delete user  (especially as users get a  warning before sending)


The bigger issue looking forward is that '\url\'  can be  used....
but thanks to you we've made a big step forward today....  big_smile

NOTE: It's important that anyone that is using this and gets spammers posting links which are not in my db - send me those incl. the url tags... so they can be added quickly....

37

Re: [Extension release] URL Checker For Posts And Signatures

@Grez

  • It might be useful for prevention effort, if an email (php inbuilt forum email function?) could be generated that is sent to the project with email, username and ip everytime a user is deleted

I say that because a user here was just auto-nuked but I don't know what email or username he'd used...  what are your thoughts?

38

Re: [Extension release] URL Checker For Posts And Signatures

I uninstalled this extension and now I receive this error when I open my administration page:

The error occurred on line 46 in C:\forum\admin\index.php(227) : eval()'d code

Database reported: Table 'atc_forum_db.url_spam' doesn't exist (Errno: 1146).

Any thoughts on how to fix it?

39

Re: [Extension release] URL Checker For Posts And Signatures

@Huuuze: That's strange - unistalling extension should erase all code from your db - try to clear cache or install / unistall extension again  neutral

Eraversum - scifi browser-based online webgame

40

Re: [Extension release] URL Checker For Posts And Signatures

Make sure you don't have the mixed extension installed with url checker and sfs in one...

41 (edited by Huuuze 2010-10-05 10:38)

Re: [Extension release] URL Checker For Posts And Signatures

Grez wrote:

@Huuuze: That's strange - unistalling extension should erase all code from your db - try to clear cache or install / unistall extension again  neutral

@Grez I also had the original anti-spam app installed.  Could that have caused the problem?

42

Re: [Extension release] URL Checker For Posts And Signatures

@Huuze You mean that one by KeyDog? As I'm thinking about it, yes (if you have it still installed) - the best solution would imo be to unistall all current SFS.com antibots and URL Checkers (and that one KeyDog's mix) and install fresh ones again. Here's latest version of URL Checker and SFS.com Antispam wink

Eraversum - scifi browser-based online webgame

43

Re: [Extension release] URL Checker For Posts And Signatures

I wonder if it would be good to have the extension show a line of code at the bottom of the index page....

Number of Spammers Auto-Nuked This [Week/Month]: XX

The more people are aware that "bad url" posting will lead to deletion / nuking - the better big_smile

PS: I think this forum auto-nuked 8 new spam users in JUNE .... of a total of 60-90 spam posts... The more people use this extension and report URLs to me, the higher the auto-nuking ration will be big_smile hopefully....

44

Re: [Extension release] URL Checker For Posts And Signatures

Just tested this extension on PunBB 1.4.1.

Seems to be working.
If anyone else can confirm?

Code here:
http://pastebin.com/3gE5w1Fu