How to make moderation system in MySql? (For showing or not showing articles)

[ilya Kraft]

Hello,

I am working on one interesting project. And I came over the following problem. I have form where users write articles and they than go into mysql database. I then want to display all articles on my website. The problem is that there are many spammers out there, so I need effective moderation system. So How can I make something effective and easy to use?
For example: I have bunch of articles in database and I look over them and choose ones that I want to display on my Homepage. So how to do that? How to have Moderation System?

Thank you and please Ask questions if you don't understand what I mean, because I really need to get this working as it is one of most important functions for my website.

[nathj]

Ok, the simple solution is for the table to contains a flag such as publish which is a tinyint and defaults to 0

When you receive an article you can check it and if it is good set the falg to 1. If you do not want to publish it leave it as 0.

Then in the code that displays the articles add where publish=1 to the clause.

You could also have a dispaly page which shows all articles to the moderators of your site and provides a checkbox to set this flag. But that is the a discussion on users and persmissions etc.

Hope this is enough to get you started.

If you get stuck with any specific post back and be sure to provide code snippets
Cheers
nathj

[ilya Kraft]

Hi,

thank you for reply, this looks promising ))) Ok as far as I understood I will create additional field in my articles table with following options:

name: publish
type: enumu "1", "0"
Deafult: 0

right?
than I will have php condition like if publish=1 than display article else if show nothing, correct?

thnx ))) only asking this to make sure that I understood you right ))

[nathj]

Pretty close but I would make the field in the table a tinyInt not an enum. You only have 2 states and so a tinyInt works really well and makes for simpler code than an enum.

Cheers
Nathan

[ilya Kraft]

Hi,

ohh why did I put enemu in ;D I was about to write tynyint. Ok i tried it out but something is not right. For values in the field do I put "0","1" ?

[nathj]

Hi,

TinyInt is a sort of integer so the values you need are 0 (not published) and 1 (publishe) no quotes needed as this is a numeric value.

Cheers
nathj

[ilya Kraft]

Hi tried it out, I think I did not enter it right in MySQL, I set it up to smallint then for lenght/values I put 1,0 and then I put default to 0 am I right? what is the right way to enter information in field?

[nathj]

Hi,

sorry for the delay in replying - I've been on holiday.

If you set the field as tinyint you can manually set the values in the table as o for not published and 1 for published.

If you want to set it through the web front end then I suggest a checkbox is the control to use. If the checkbox is checked then set the value to 1 if it is unchecked set the value to 0.

I wuold suggest getting the manual version working so you are familiar with the datatype first.

What have you got so far? Is there a code snippet you are stuck with that you would like me to look at?

Cheers
nathj

[ilya Kraft]

Hi,

thnx for great help ))) No I don't have full code yet, but I have things going good now ))) The bit I was stuck with was that I putted '0','1' for values, but I needed 0,1 I'll try to finish this moderation system this weekend ))) so If I have problems I'll ask you if you are not busy or something )))

Thank You )))

[lingtalfi]

I use this: https://raw.githubusercontent.com/li...ion-system.jpg