Reviews question

[rookers]

Hello,

Does anyone here know what do I have to do in order for the reviews to appear on the site once they are submitted without having to approve them?

[FSGDAG]

I'm pretty sure all reviews need to be approved by either an admin or editor.. You really dont want uncensored reviews, do you?

[rookers]

Yes i know what you mean but I plan to use the review system for something else other than reviews, this is why I asked if someone knows a way to make them appear directly on the site without having an admin or editor approve them first.

[FSGDAG]

Well, unless you want to recode the way the review system works, I dont think thats going to help you

Maybe a better idea would be to tell us what your trying to accomplish and we can give you ideas on the best way to go about it

[Bruceper]

You could setup a cronjob to change the status to approved and let it run every minute or five minutes.

This includes a warning as well, unmonitored reviews can lead to spam

[rookers]

Hello,

Thank you. Is there anther way of doing this without setting up a cron job?

[mpdaddy]

Are you using IndexU 1.XX? If so, and you really want to allow reviews to be allowed without approving them first, you simply need to edit 1 file (I think).

Open the lib/link.class.php file and find this code (In mine it starts on line 3125):

        $query  = "insert into $this->review_table_name
        (link_id, username, subject, rating, review, date, status, name, email)
        values ($id,'$username','$rev_subject','$rev_rating','$rev_review',now(),0,'$rev_name','$rev_email')";
        $result = $dbConn->Execute($query);

And replace it with:

        $query  = "insert into $this->review_table_name
        (link_id, username, subject, rating, review, date, status, name, email)
        values ($id,'$username','$rev_subject','$rev_rating','$rev_review',now(),1,'$rev_name','$rev_email')";
        $result = $dbConn->Execute($query);

All I did was changed the 0 after now() to a 1. That should be all you need to do. I have not tested this, so you should test it accordingly.

If you are using version 5.4x, the code should be the same or similar and in the same file but the line number may be different.


Regards
Wayne

[Bruceper]

That should work, and I should have thought of that lol

[rookers]

Thank you guys. mpdaddy's solution worked like a charm!

Thanks!!