Make forum moderators to hide/delete spams from forums when nop team is not around

Posted: August 16, 2018 at 6:54 AM Quote #210610
It has been happening quite often that spam accounts are created and spam topics are posted.
While nopCommerce team does its best to remove them asap, there are times when they are not around and the posts remain there till the time it's removed.

I think some members of the forum (may be MVPs or somebody you trust) should be made forum moderators. They can at the very least have capability to hide posts till it's approved/deleted by nopCommerce member.

Hope that makes sense.
This post/answer is useful
2
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
nopCommerce enthusiasts since 3.10
nopCommerce themes & plugins available @ https://www.roastedbytes.com
Posted: August 17, 2018 at 4:30 AM Quote #210664
Hi Anshul,

Thanks for suggestion! We'll definitely consider this option
This post/answer is useful
2
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Interested in the dedicated Premium support services provided by core developers? Please visit http://www.nopcommerce.com/supportservices.aspx

Regards,
Andrei Mazulnitsyn
Posted: October 15, 2018 at 7:20 AM Quote #213188
Let me know if you need any help from my side. The real posts are hiding somewhere behind the bunch of spam posts. It really irritates to see those spammy posts covering half of active discussions.

Regards,
Anshul
This post/answer is useful
2
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
nopCommerce enthusiasts since 3.10
nopCommerce themes & plugins available @ https://www.roastedbytes.com
Posted: June 15, 2019 at 7:47 PM Quote #237977
Spam topics posted here in the nopCommerce forums are really getting out of control.  

I thought there was a more recent topic about it, where I even posted a SQL trigger workaround that I use for preventing spam in the Contact Us page of my nop sites, but a Google search for my SQL does not find it?  Was that topic removed?  That simple workaround can prevent a lot of spam.  (You can also include a search for exact same topic title posted in short period of time.)
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Posted: June 16, 2019 at 3:01 AM Quote #237998
I still thing you could apply some rules as detailed by me here - Of course it wont totally stop them but they will definietly be slowed up a bit

https://www.nopcommerce.com/boards/t/52425/forums-need-a-little-work.aspx?p=2
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.SelectSystems.com.au
Select Systems International is a computer systems technology solution developer and integration service provider.
Posted: June 16, 2019 at 10:00 AM Quote #238009
Yidna wrote:
I still thing you could apply some rules as detailed by me here ...

Yes, some of those rules are fine, but requires a lot of dev.  Although it's a hack, a trigger can be done in several minutes.

E.g. posting my code again

CREATE TABLE [dbo].[SpamPhrase](
  [Id] [int] IDENTITY(1,1) NOT NULL,
  Phrase [nvarchar](50) NOT NULL,  
PRIMARY KEY CLUSTERED
(
  [Id] ASC
))

CREATE TRIGGER QueuedEmailSpamBlocker
ON [dbo].QueuedEmail
FOR INSERT
AS
BEGIN
    SET NOCOUNT ON

    if exists ( select 1
                  from inserted i
                  join SpamPhrase s on i.Body like '%'+s.Phrase+'%'
                 where i.Subject like '%Contact us%'
              )
        rollback transaction
END

insert into [SpamPhrase](Phrase) values ('some spammy phrase')
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2019
Learn more