vb.org Archive
Page 166 of 350 « First 66116156164165 166 167168176216266 Last »
Show 40 post(s) from this thread on one page

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)

shadowbreed 03-25-2012 10:40 PM
Quote:
Originally Posted by ForceHSS (Post 2312682)
So what mysql version did you have
5.5.21-cll

ForceHSS 03-26-2012 12:37 AM
Quote:
Originally Posted by shadowbreed (Post 2313283)
5.5.21-cll
you should not have a problem with that version with this program
so this is what you had before so what do you have now

BryanLong 04-02-2012 09:52 PM
Question about Akismet:
Seems to be that Users which are found with too much URL-Count automatically gets posted to Akismet. Seems that I have to find a suitable URL-Count.

In this testing time: Will there be any possibility to report "false-positives", so that the User will not be blocked by Akismet again?

Best regards,
Bryan

hqlman 04-02-2012 11:54 PM
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!

Works perfectly, thanks a lot :)

Dave234 04-03-2012 02:26 AM
Can someone please help me to install this on my vbulletin 4 site?

I am stuck on steps 2.2 and 2.3

These are the instructions:

/************************** 2. INSTALLATION ****************************/

2.1 IF UPGRADING FROM SPAM-O-MATIC VERSION 1:
Make sure to remove the following file before installing version 2
/forum/includes/xml/bitfield_glowhostspamomatic.xml

2.2. Upload content of the upload folder into you forum root folder

*

2.3. Import product-glowhostspamomatic.xml into products (Located
at
AdminCP -> Plugin System -> Manage Products -> Add/Import Product)

/************************** 3. SETTINGS ********************************/

3.1. You can edit plug-in options at: AdminCP -> Settings -> Options ->

GlowHost - Spam-O-Matic

3.2. You can edit plug-in messages at: AdminCP -> Languages & Phrases ->

Phrase Manager -> Search Variable Name for 'glowhostspamomatic'

/************************** 4. ACTIONS *********************************/

4.1.
A) Located @ Edit user profile
B) If you have you API keys (set in settings) -
you will be able
to submit user details to StopForumSpam.com and Akismet databases simply
Delete a post as spam and ban the user to submit them if you have these
options enabled.

4.2. Get API key for Akismet
and enter it in settings. After this edit
your usergroups and you will
see the option to "Filter posts with Akismet".
Only check groups with
untrusted users (i.e. Unregistered / Not Logged In,
Registered Users).

Syxguns 04-03-2012 02:47 AM
@Dave234,
You have already removed the previous XML file? The next step requires FTP access to your server. Just change the name of your upload folder to the name of your forums folder. Drop the upload folder after the name is changed into the primary folder that holds your forums folder.

Primary Directory - drop it here
Forum folder

Someone else should not be granted access to your server!

Dave234 04-03-2012 03:00 AM
I never downloaded the first Spam-O-Matic, so I doubt it's in there. Unless it came with vbulletin?

I have FTP access.

What is the name of my forums folder? I have so many folders. Is it the "Includes" folder? That has a folder in it called "XML" which has other items in it.

However my "install" folder also has a folder called "includes". But that one does not have an "XML" folder in it.

This stuff is so confusing.

And I'm worried about trying anything because I don't want to ruin my vbulletin.

I know I should back it up, but vbulletin apparently got rid of the "Backup Database" button in the admincp. I have no idea how to back up the vbulletin. Can you explain it to me, as if you were explaining it to a 2-year-old? Because that's really my level of understanding with this.

Stryker412 04-03-2012 03:11 AM
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?

Syxguns 04-03-2012 03:50 AM
1 Attachment(s)
@Dave234,

The folders you are naming are withing the primary forum directory. Your structure should look similar to this one that I kind of made up!! I figured a picture might help. Notice the following:

1) The top folder is the primary folder that holds the forums and or other items that you may have like shopping carts and so forth.

2) The second folder is the vB folder for your forums. It may not be called forum, mine is not, but that folder is where all of vB resides.

3) All the folders under the second folder are vB folders for the forum. You may have some mods on your forum and they will show up as well.

So by telling you to rename the Upload folder to the name of your forum folder you would be looking at the second one in the picture. However, you will drop the folder onto the 1st folder. The first folder is the ROOT of the forum.

Hope that helps.

Backups of the Database are generally done through PHPMyAdmin: https://www.vbulletin.com/docs/html/...myadmin_backup

Syxguns 04-03-2012 03:59 AM
Quote:
Originally Posted by Stryker412 (Post 2316255)
Can someone offer advice on how to handle this? I have spammers registering and posting blogs but not on the forums. How can I ban them and have their blogs deleted?
Styker412,
This is handled through permissions. Do not allow guest to post, and do not allow new members to post on blogs until they reach a desired number of posts on the forum. Or you can set it so that all new members posts are moderated before they are displayed.

Now Spam-O-Matic will remove a lot of stuff for you, but you have to make other preventative measures against problems like that. I don't allow guest to post, leave guest messages, leave messages on blogs, and new members I have set to have a minimum of 5 moderated posts before they become a registered user. Then they have a lot more freedom.


All times are GMT. The time now is 02:00 AM.
Page 166 of 350 « First 66116156164165 166 167168176216266 Last »
Show 40 post(s) from this thread on one page

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.03050 seconds
  • Memory Usage 1,768KB
  • 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
  • (4)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