vb.org Archive - Anti-Spam Options - [GlowHost] Spam-O-Matic

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Anti-Spam Options - [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam (https://vborg.vbsupport.ru/showthread.php?t=248042)

Quote:

Originally Posted by BigAl205 (Post 2171186)

You could cheat ;)
There's another program that allows an admin to log in as another user. You could log in as the spammer, make a post, and then report it. :D

Probably don't want to do that if your settings are set to send the IP address of the spammer to SFS otherwise you will end up banning yourself from registration on forums that run this mod.

Hello,
I've setup a brand new forum and just downloaded this as the first plugin/mod on the forum.
When installing/uploading the plugin xml file I get the following error.

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/usr/home/tmp/php8rXcz1) is not within the allowed path(s): (/home/jappleton/:/tmp:/var/tmp:/usr/local/lib/php/) in [path]/includes/adminfunctions.php on line 2449

No idea what's wrong or what it means. Your help would be greatly appreciated.

Thanks.

Quote:

Database error in vBulletin 4.0.7:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `vbulletin_glowhostspamomatic_log`(
`date` DATETIME NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`username` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
`is_blocked` TINYINT NOT NULL DEFAULT "0",
`user_hash` VARCHAR(50) NOT NULL,
`user_id` INT NOT NULL
) TYPE=MyISAM;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 10
Error Number : 1064

I noticed there's an extra semi-colon at TYPE=MyISAM, but when I checked the product-glowhostspamomatic.xml out, there's only one semi-colon, not two as this error shows.

Any ideas what could be the problem? =/

Quote:

Originally Posted by ComoEstaEso-com (Post 2171139)

Hello!
This Product rocks!!
Very happy with it.
We did a small donation to StopForumSpam.com and Akismet :)

Quick question:
Is there a way to submit spammer's info/data to the spam databases (StopForumSpam) without the spammer having posted?
I ask, because we have gotten three spammers that have registered, haven't posted on the forums, yet their signatures are spam.
Instead of just deleting them, maybe it would be cool to "delete and submit".

Thank you for this awesome mod!! :)

you can submit spammers by building a form todo it in your admincp here's an example

PHP Code:


		
			
if($_REQUEST['do'] == 'submitspam')
 {
  $vbulletin->input->clean_array_gpc('r',array(
   'username'    => TYPE_STR,
   'email'       => TYPE_STR,
   'ip_addr'     => TYPE_STR,
   'api_key'     => TYPE_STR,
   'evidence'    => TYPE_STR
  ));
  print_form_header('glowhostspamomatic','dosubmitspam');
  print_input_row('username','username','',1,30);
  print_input_row('email','email','',1,30);
  print_input_row('ip adress','ip_addr','',1,30);
  print_input_row('apikey','api_key',$vbulletin->options['glowhostspamomatic_apikey'],1,30);
  print_textarea_row('evidence','evidence','',20,50,1,1);
  print_submit_row('submit',0);
 }

allright almost there now to submit the form to SFS database you have two options

1) PHP with cURL support
2) PHP with sockets support

PHP Code:


		
			
if($_POST['do'] == 'dosubmitspam')
 {
  $vbulletin->input->clean_array_gpc('p', array(
   'username'       => TYPE_STR,
   'email'          => TYPE_STR,
   'ip_addr'        => TYPE_STR,
   'api_key'        => TYPE_STR,
   'evidence'       => TYPE_STR
  ));
  $cURL = curl_init();
  curl_setopt($cURL,CURLOPT_URL,"http://www.stopforumspam.com/add.php");
  curl_setopt($cURL,CURLOPT_POST, 1);
  curl_setopt($cURL,CURLOPT_POSTFIELDS,"username=" . $vbulletin->GPC['username'] . "&ip_addr=" . $vbulletin->GPC['ip_addr'] . "&email=" . $vbulletin->GPC['email'] . "&api_key=" . $vbulletin->GPC['api_key'] . "&evidence=" . $vbulletin->GPC['evidence'] . "");
  curl_setopt($cURL,CURLOPT_USERAGENT,"vBulletin cURL spam submitter");
  curl_exec($cURL);
  if(curl_errno($cURL))
  {
    die(print_r(curl_error($cURL))); 
  }
  else
  {
   print_stop_message('spammer_reported_succes'); //this is a phrase
  }
  curl_close($cURL);//do not forget this

PHP through sockets

PHP Code:


		
			
function PostSpam($spamdata)
{
      $sock = fsockopen("www.stopforumspam.com",80);
      fputs($sock, "POST /add.php HTTP/1.1\n" );
      fputs($sock, "Host: www.stopforumspam.com\n" );
      fputs($sock, "Content-type: application/x-www-form-urlencoded\n" );
      fputs($sock, "Content-length: ".strlen($spamdata)."\n" );
      fputs($sock, "Connection: close\n\n" );
      fputs($sock,$spamdata);
      fclose($sock);
}

with this you need to check the http response either 200(success) or 403(forbidden) usage is the same as the cURL postfields above

PHP Code:


		
			
PostSpam(postfields_here)

i added this to the spamomatic log to check if your host supports either cURL or sockets call

PHP Code:


		
			
phpinfo();

Quote:

Originally Posted by tightjeansforum (Post 2171227)

You will need to check with your host on that. it seems like a possible misconfiguration in PHP.

Quote:

Originally Posted by Quarantine (Post 2171401)

Hi there,

I've previously used your 1.2.x version but stopped it for a while, and now I found out that you've released a 2.x version.

I made sure to remove that /forum/includes/xml/bitfield_glowhostspamomatic.xml file, and then tried to install it by importing product-glowhostspamomatic.xml into "Products".

I immediately see a database error message:

I noticed there's an extra semi-colon at TYPE=MyISAM, but when I checked the product-glowhostspamomatic.xml out, there's only one semi-colon, not two as this error shows.

Any ideas what could be the problem? =/

Did you use the product manager to first remove the old version? It needs to be removed from there before installing the new version.

Quote:

Originally Posted by GlowHost.com (Post 2171516)

Did you use the product manager to first remove the old version? It needs to be removed from there before installing the new version.

Hi there,

Sorry I forgot to mention this, but yes I did uninstall the old version first via the Product Manager, which is why I'm quite puzzled about the error too.

We just spent an hour trying to figure out why a new user's thread was automatically moderated. It turned out he used a link to a pic of himself in it. My point is that this mod is working EXACTLY as it should. Great job! ;)

Quote:

Originally Posted by Quarantine (Post 2171799)

Hi there,

Sorry I forgot to mention this, but yes I did uninstall the old version first via the Product Manager, which is why I'm quite puzzled about the error too.

I am not really sure why you would be having those problems. You might re-install the original mod. Then try to uninstall it again using product manager, then remove the bitfield file. Then install the latest and see how it goes.

Quote:

Originally Posted by GlowHost.com (Post 2171210)

Probably don't want to do that if your settings are set to send the IP address of the spammer to SFS otherwise you will end up banning yourself from registration on forums that run this mod.

Oops...good point. I didn't think about the IP aspect.:o

Sorry I am late to the party.

I installed this on a 3.8.1 board and it works.

My question is, I think something is missing
Here is what my threads all show.
https://vborg.vbsupport.ru/external/2011/03/27.png

Anyway to change it and add it to the drop down box?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03383 seconds Memory Usage 1,792KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: