[Free Plugin] Anti Spam & Protection System

[Aficionado]

you are right, but if i can find the concrete issue, maybe i can make it compatible to all versions of mysql and mariadb

https://community.centminmod.com/threads/mysql-5-5-vs-mysql-5-6-vs-mariadb-5-5-vs-mariadb-10-0-feature-compare.3456/

It seems that MariaDB 5.x is more towards Mysql 5.5 and MariaDB 10 more towards Mysql 5.6

[Liath]

got it
https://mariadb.com/kb/en/library/datetime/

I think it will work fine if you change the type datetime to timestamp

thx Syed


all they are using

• MySQL Version < 5.6.5
• MariaDB Version < 10.0.1

and facing this issue should change datetime to timestamp, i don't want to change it generally, to do not add other possible errors there

CREATE TABLE IF NOT EXISTS `/*TABLE_PREFIX*/t_spam_protection_ban_log` (
  ...
  `dt_date_banned` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  ...

[Syed]

all they are using MariaDB Version < 10.0.1 and facing this issue should change datetime to timestamp, i don't want to change it generally, to do not add other possible errors there

CREATE TABLE IF NOT EXISTS `/*TABLE_PREFIX*/t_spam_protection_ban_log` (
  ...
  `dt_date_banned` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  ...

I have changed the type datetime to timestamp and installed the plugin without any error, I don't think its a big deal as the affected fields are logs.
I will let you know if any unusual happens.

Regards

[Syed]

Hi,

Just for your kind information some people use item-send-friend.php for spamming.

Add a feature in your plugin to check email addresses and website urls in subject and message on this form.

Regards

[Liath]

Add a feature in your plugin to check email addresses and website urls in subject and message on this form.

it is added now, but without own settings. It is activated via contact mail settings.





If you want to add it manually, open ../spamprotection/index.php


change

Code: [Select]

if (!osc_is_admin_user_logged_in() && !OC_ADMIN && spam_prot::newInstance()->_get('sp_contact_activate') == '1') {
    $trusted = spam_prot::newInstance()->_isBadOrTrusted(osc_logged_user_id(), 'contacts', 'trusted');
    $bad = spam_prot::newInstance()->_isBadOrTrusted(osc_logged_user_id(), 'contacts', 'bad');   
   
    if ($bad) {
        osc_add_hook('item_contact_form', 'sp_block_baduser_contact');
       
    } elseif (!$trusted) {
        if (spam_prot::newInstance()->_get('sp_contact_honeypot') == '1') {
            osc_add_hook('item_contact_form', 'sp_contact_form');
        }
           
        osc_add_hook('hook_email_item_inquiry', 'sp_check_contact_item', 1);
        osc_add_hook('hook_email_contact_user', 'sp_check_contact_user', 1);
    }
}

to

Code: [Select]

if (!osc_is_admin_user_logged_in() && !OC_ADMIN && spam_prot::newInstance()->_get('sp_contact_activate') == '1') {
    $trusted = spam_prot::newInstance()->_isBadOrTrusted(osc_logged_user_id(), 'contacts', 'trusted');
    $bad = spam_prot::newInstance()->_isBadOrTrusted(osc_logged_user_id(), 'contacts', 'bad');   
   
    if ($bad) {
        osc_add_hook('contact_form', 'sp_block_baduser_contact');
        osc_add_hook('item_contact_form', 'sp_block_baduser_contact');
       
    } elseif (!$trusted) {
        if (spam_prot::newInstance()->_get('sp_contact_honeypot') == '1') {
            osc_add_hook('contact_form', 'sp_contact_form');
            osc_add_hook('item_contact_form', 'sp_contact_form');
        }
           
        osc_add_hook('hook_email_item_inquiry', 'sp_check_contact_item', 1);
        osc_add_hook('hook_email_contact_user', 'sp_check_contact_user', 1);
        osc_add_hook('post_item_send_friend_post', 'sp_check_contact_item', 1);
    }
}

[TangoX]

@Liath Any news on v1.7.5 Stable?

Thanks!

[Liath]

i need to fix two problems first

[bamser]

it's pretty easy

http://i.shotnes.com/a/25/sgjgwww4.u02_59c8f4b5d5827.png
..........
sorry did not finish reading
already dismantled the problem, but what is fraught with TIMESTAMP instead
DATETIME?

[Liath]

sorry did not finish reading
already dismantled the problem, but what is fraught with TIMESTAMP instead
DATETIME?

it depends on your MariaDB Version:

got it
https://mariadb.com/kb/en/library/datetime/

This is the complete solution
https://forums.osclass.org/plugins/(plugin)-spam-protection/msg155824/#msg155824

[Aficionado]

Liath hi,

You may look also at this please ? Not a major one, still it seems to trigger some firewall rules.

Thanks !!!

/oc-admin/index.php - DOCUMENT_ROOT variable in HTTP request - [POST:sp_files_directory = /home/website.com/]

[Liath]

thank you for this report, it is already fixed in my version

[Aficionado]

thank you for this report, it is already fixed in my version

What version is that ? 1.7.4 ?

[Liath]

1.7.5 not available now


want to fix all other issues first

[tito]

The last times i see ads marked as Spam in the listing list.
But there is no check spam.

If i check the ad there are no stopwords.

But it is a true spamad with links to other websites.

Is this the plugin who does it or is some extra power help me

[Aficionado]

The last times i see ads marked as Spam in the listing list.
But there is no check spam.

If i check the ad there are no stopwords.

But it is a true spamad with links to other websites.

Is this the plugin who does it or is some extra power help me

If there is NO Check Spam optiion then the Ad is NOT flagged by Liath's plugin. Manually flagged or by something else.