Page 1 of 1

[vQmod] - Auto-approve Review Ratings Greater than x (15/2x)

Posted: Wed Feb 01, 2012 6:04 am
by Qphoria
Working with 1.5.x and 2.x
This script lets reviews with ratings greater than your defined value be auto-approved.
By default it is set to auto-approve ratings of 4 or 5 but you can set it for 1, 2, 3, 4, or 5

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Wed Feb 01, 2012 10:59 am
by merry
Wow, Qphoria, cool script and what a time-saver! Brilliant.

Merry

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Wed Feb 01, 2012 4:17 pm
by opencartArab
+1

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Wed Feb 01, 2012 10:23 pm
by marcelwoo
I love Qphoria :clown:

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Sat Feb 11, 2012 6:21 pm
by donyeh
Great mod!

Thanks for sharing Qphoria. :)

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Mon Aug 20, 2012 5:26 am
by jarek79
Qphoria you are a GOD!!!

Thanks

Jerry

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Tue Aug 28, 2012 12:59 pm
by bmbg
How would I go about having different messages displayed based on star rating?

For example, auto-approved (3, 4, 5) ratings would display a message such as "Thank you, your review has been submitted."

And non-auto-approved (1,2) could display "Sorry you were not satisfied blah blah blah"

Re: [vQmod] - Auto-approve Review Ratings Greater than x

Posted: Sun Oct 11, 2015 8:22 pm
by panthere
Hello

For opencart 2 support you must edit the search line in xml, like bellow

Before

Code: Select all

<search position="after"><![CDATA[
			$this->db->query("INSERT INTO " . DB_PREFIX . "review
            ]]></search>
After (opencart 2 support)

Code: Select all

<search position="after"><![CDATA[
				$this->db->query("INSERT INTO " . DB_PREFIX . "review SET author = '" . $this->db->escape($data['name']) . "', customer_id = '" . (int)$this->customer->getId() . "', product_id = '" . (int)$product_id . "', text = '" . $this->db->escape($data['text']) . "', rating = '" . (int)$data['rating'] . "', date_added = NOW()");
            ]]></search>
Thanks Qphoria

Re: [vQmod] - Auto-approve Review Ratings Greater than x (15/2x)

Posted: Fri Dec 28, 2018 3:09 pm
by sanpanthera
Hi ,

I am a newbie and I find difficulty to work with vQmod. My opencart version is 3.x .
@Qphoria: Could you please provide OCMod file for the same.

Re: [vQmod] - Auto-approve Review Ratings Greater than x (15/2x)

Posted: Tue Jan 01, 2019 5:13 pm
by xxvirusxx
@sanpanthera

I made ocmod