vb.org Archive

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)

weave 05-04-2012 04:31 PM

Quote:

Originally Posted by KittyWireless (Post 2325831)
plus when we click on a thread, and go under Moderator Options, the "Spam-O-Matic" option is not longer listed.....

I am not having that issue, but am doing some testing to see if I have the first issue you listed.

Nope, all works like I think it should.

Spam-O-Matic has performed the following actions:
Selected users were removed
33 posts were removed permanently
5 PMs were removed

I confirmed in the logs and in the fourm that what I asked it to do, was in fact done.

ForceHSS 05-04-2012 07:00 PM

Quote:

Originally Posted by SteveLV702 (Post 2326225)
lucky you I can't even get installed when I attempt to upload/install the xml file I get a mysql error :'(

post error

Syxguns 05-04-2012 07:28 PM

SteveLV702.
Try this, it was posted a few pages back.

Quote:

Originally Posted by Syxguns (Post 2312347)
shadowbreed,
Are you still having the same issue? I was and after a little research I found that if you are running MySQL 5.5 it does not recognize the ?Type=MyIsam:? . It was valid for for older versions. Let me show you how I corrected the problem.

Edit: Looking back I see that your problem is not the same as mine was. This will not help you.



Edit: #2
For anyone that has a Database error that looks like the following example this is how I corrected it.

Code:

Error Code..

Database error in vBulletin 4.1.7:

Invalid SQL:
CREATE TABLE IF NOT EXISTS `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

Code:

$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'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; ');

 
$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(

                          `date` DATETIME NOT NULL,
                          `field` VARCHAR(20) NOT NULL,
                          `is_spambot` INT NOT NULL,
                          `data` VARCHAR(255) NOT NULL
                            ) TYPE=MyISAM; ');

 

$db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_stats`(

                          `denied` INT NOT NULL DEFAULT "0",
                          `banned` INT NOT NULL DEFAULT "0",
                          `moderated` INT NOT NULL DEFAULT "0",
                          `s_sfs` INT NOT NULL DEFAULT "0",
                          `s_akismet` INT NOT NULL DEFAULT "0",
                          `removed` INT NOT NULL DEFAULT "0"
                          ) TYPE=MyISAM; ');

Each item marked in red needs to be removed from the XML file. Leave the rest of the statement including the semi-colons. It is located 3 times so be sure to remove the test in red. The line should look like this:

Code:

) ; ');
That may get it working for you. It worked for me when I made the change. Good Luck!


WDS 05-06-2012 11:18 AM

Hello, I'm trying to register a friend from my pc and i get this message:

Registration denied, this forum runs an active policy of not allowing spammers. Please contact us via the "Contact Us" page link if you believe this is in error

to that is?

ForceHSS 05-06-2012 03:51 PM

Quote:

Originally Posted by WDS (Post 2326695)
Hello, I'm trying to register a friend from my pc and i get this message:

Registration denied, this forum runs an active policy of not allowing spammers. Please contact us via the "Contact Us" page link if you believe this is in error

to that is?

disable username

Gripi 05-08-2012 06:40 AM

hi..

is it possible to make the Statistic only show to admin / moderator only?

i'm sure that i only need to put an if condition in the plugin manager -> Stats render, and before this:

PHP Code:

if (($vbulletin->options['glowhostspamomatic_stat_show_denied'] == 1) || ($vbulletin->options['glowhostspamomatic_stat_show_banned'] == 1)) 

could someone please help

thanks

The Rocketeer 05-09-2012 01:01 AM

any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?

ForceHSS 05-09-2012 01:29 AM

Quote:

Originally Posted by The Rocketeer (Post 2327502)
any better alternate to this mod? i uninstalled it but getting tons of blog spam. anyway to perhaps use both human verification question and captcha?

why not disable blog for normal users

Skyrider 05-10-2012 05:01 AM

Is there anyway I can submit users through their profile if they haven't post anything?

Crotan 05-10-2012 05:03 AM

Quote:

Originally Posted by FF|Skyrider (Post 2327896)
Is there anyway I can submit users through their profile if they haven't post anything?

Don't think so, the whole point of submitting a spammer, is that there is a submitted spam post/evidence with their user info.


All times are GMT. The time now is 09:11 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04378 seconds
  • Memory Usage 1,765KB
  • 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
  • (3)bbcode_code_printable
  • (1)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)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