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 sigBut I still had to manually delete the user.
27 2010-09-02 15:20 (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."
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 
)
Eraversum - scifi browser-based online webgame
- KeyDog
- Global Moderator
- Offline
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 
Went to admin panel and saw info about deleted.... love it when it works. Just need more URLs and a realtime query possibility...
- KeyDog
- Global Moderator
- Offline
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]
Now the question is, how do I most effiencently check that table (instead of using the .csv) ?
- KeyDog
- Global Moderator
- Offline
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
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... (It's planned for next version 
)
Eraversum - scifi browser-based online webgame
- KeyDog
- Global Moderator
- Offline
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...
- KeyDog
- Global Moderator
- Offline
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)
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
http://keydogbb.info/url_spam.php?url=h … xample.com
Returns "Y" or "N"
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)
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/badthen 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
Eraversum - scifi browser-based online webgame
- KeyDog
- Global Moderator
- Offline
Re: [Extension release] URL Checker For Posts And Signatures
Very nice indeed. Installed here and working
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
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....
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....
- KeyDog
- Global Moderator
- Offline
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?
- Huuuze
- Member
- Offline
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?
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 
Eraversum - scifi browser-based online webgame
- KeyDog
- Global Moderator
- Offline
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 2010-10-05 10:37 (edited by Huuuze 2010-10-05 10:38)
- Huuuze
- Member
- Offline
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
@Grez I also had the original anti-spam app installed. Could that have caused the problem?
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
Eraversum - scifi browser-based online webgame
- KeyDog
- Global Moderator
- Offline
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
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 hopefully....
- KeyDog
- Global Moderator
- Offline
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