Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - PHP Nuke
Author Message
silicastorm
New Member
New Member


Joined: Jan 15, 2010
Posts: 22
Location: Abu Dhabi, UAE

PostPosted: Mon Jan 25, 2010 8:02 pm Reply with quote

Well I am under a daily SPAM attack from Russia/Latvia/Ukraine/etc; with everything from viagra to porn.

The PITA is taking each "Registered User" Forum posting and entering the (dozens daily) IP into Sentinal "Block IP" menu. (All Forums require a registered user.

Now the good folks at Stop Forum Spam - Only registered users can see links on this board! Get registered or login! have provided a csv file with thousands of predetermined IPs to Block.

How do I take this file and upload into nuke_nsnst_blocked_ips table?

Currently using:
PHP Nuke 8.0 with Sentinal 2.6.01.
$gfx_chk = 4;
4: Both, users login and new users registration only

Regards,

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
sixonetonoffun
Spouse Contemplates Divorce


Joined: Jan 02, 2003
Posts: 2496

PostPosted: Mon Jan 25, 2010 9:01 pm Reply with quote

I would do it at the server level if its such a huge file.

I believe this issue is because of a $global missing in PHPNuke proper but can't recall where.

But phpMyAdmin should be able to import the file if you would rather but back up first!
 
View user's profile Send private message
silicastorm
PostPosted: Mon Jan 25, 2010 9:17 pm Reply with quote

Ok, Yes I was assuming the upload would be at server with phpmyadmin,,, but I have no idea how to configure the upload as per the format of the csv file


Replace table data with file
Ignore duplicate rows
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Column names


When I attempt I recieved the following error:

Error
Invalid field count in CSV input on line 1.
 
slackervaara
Worker
Worker


Joined: Aug 26, 2007
Posts: 236

PostPosted: Tue Jan 26, 2010 12:16 am Reply with quote

I use bbantispam or Advanced Textual Confirmation since three years ago and it has stopped all spam in PHP-Nuke including forum (guests are allowed to post). To stop all types of spam put the installation code in config.php.
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
sixonetonoffun
PostPosted: Tue Jan 26, 2010 12:55 am Reply with quote

PM your email and I'll send you the sql to import the IPs.
Then let me know if there are any problems.
You did back up?
Wink
 
silicastorm
PostPosted: Tue Jan 26, 2010 3:10 am Reply with quote

Back up is complete,,, and sent you the PM of email address..

thanks so much!
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9453
Location: Arizona

PostPosted: Tue Jan 26, 2010 6:29 am Reply with quote

You can ban complete countries using NukeSentinel(tm) I thought. There have also been some examples here on how to how to also do it with .htaccess. I believe the example given was for Turkey.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
silicastorm
PostPosted: Tue Jan 26, 2010 10:34 am Reply with quote

sixonetonoffun,

Fantastic!

Upload with no errors.... +32000 banned IP addresses now in Nuke Setinal 2.6.01

I will check out the bbantispam next....

Cheers to all and next time it will be the Raven Nuke I will upgrade with,,,




~
 
sixonetonoffun
PostPosted: Mon Jul 12, 2010 4:26 am Reply with quote

silicastorm

You might want to (if you haven't) Only registered users can see links on this board! Get registered or login! it reads the IPs from csv files. The author provides monthly updates and is a mod at Only registered users can see links on this board! Get registered or login!

I'd really like to see something like this added to NukeSentinel since these ban lists are not in a nuked friendly format. The wrapper should be able to save tons of resources on a large site.
 
sixonetonoffun
PostPosted: Mon Jul 19, 2010 2:17 pm Reply with quote

Just a note ZB BLOCK has released an update 0.4.7b 07/13/10 "Panther" Release Only registered users can see links on this board! Get registered or login!
 
montego
PostPosted: Wed Jul 21, 2010 8:47 pm Reply with quote

Nice. BTW, you might want to get RavenNuke on their list... Wink
 
sixonetonoffun
PostPosted: Fri Jul 23, 2010 1:54 am Reply with quote

I submitted a "Testimonial" with brief install instructions. We'll just have to see if its approved.
 
sixonetonoffun
PostPosted: Sun Jul 25, 2010 11:27 pm Reply with quote

Update: Post was approved and added to the compatability list.
See: Only registered users can see links on this board! Get registered or login!
 
montego
PostPosted: Sat Aug 07, 2010 8:00 am Reply with quote

Very nice. Thanks Six!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Security - PHP Nuke

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©