Jump to content

Recommended Posts

This PrestaShop home page comments module has been recently developed by FMM "FMEModules" which is used to showoff latest customer's reviews, comments and rating with date and image in a stylish block on your home page. The actual purpose of this extension is to grow customer's confidence and trust on your products.

This PrestaShop home page reviews module is developed to increase customer's trust level on your services. This add-on delivers inspiring and useful way to your web store visitors; therefore, each customer's review or comment with be shown in a separate frame with picture and date.

In the back-end section of this PrestaShop Home Reviews module the website owner can set custom title of the block and he can enable or disable rating easily.
 

We do not reply under this thread. For any query submit your ticket at http://support.fmemodules.com/

 

ScreenShots

 

a.jpg

 

 

b.jpg

 

 

c.jpg

 

 

d.jpg

fmmhomecomments.zip

Edited by alastairbrian

Share this post


Link to post
Share on other sites

Hello,

I bought some modules from your site, and all modules are perfect!

I have one question. I like this module for displaying home page comments and reviews. BUT i also need reviews module for product page...

Do you have any free opinion to integrate with this home page comments?

Regards / www.computers.rs

Share this post


Link to post
Share on other sites

dear sir,

 

I got this error when installing your module:

 

[PrestaShopDatabaseException]

Db->executeS() must be used only with select, show, explain or describe queries
at line 488 in file classes/db/Db.php

482. 483. 		// This method must be used only with queries which display results484. 		if (!preg_match('#^\s*\(?\s*(select|show|explain|describe|desc)\s#i', $sql))485. 		{486. 			if (defined('_PS_MODE_DEV_') && _PS_MODE_DEV_)487. 				throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');488. 			return $this->execute($sql, $use_cache);489. 		}490. 491. 		$this->result = false;492. 		$this->last_query = $sql;

I'm using v1.6.0.8

how to fix it?

Share this post


Link to post
Share on other sites

Hello

 

See the forum rules please : http://www.prestashop.com/forums/topic/256751-read-first-forum-rules-and-best-practices/

 

External links
In forums other than "Paid Modules, Themes and Job Offers", links to a site offering paying products are prohibited.
In the “Paid modules, job offers and paid services" forum, any link must point precisely to the relevant product page.

 

In the forum free module must attached to topic

 

Thank you

Share this post


Link to post
Share on other sites

Hi man ,

 

i got this Module 2 day ago , Added it to my site , well , first it seems ok ! added on bottom of page , and had a message saying there is no Comment avilable !

 

but when some of my customers did comment on my products in past days , instead of showing them , only the message about no comment avilable gone ! but no Review or comment is being shown , any idea ?

 

Tyvm for this module either how :D

 

i would buy ur Product review Modul maybe , but i already bought it along in a bundle , with the Theme i bought for my site , it had them all inside of it .

 

 

I don't know if i am allowed to post a link of it here or not , but since my shop is not for sell to forigens and it's unluckily someone from my country come here in this topic , i put the link here :

 

www.Gamers-Shop.net

 

( the last block : آخرین نظرات مشتریان is ur module )

 

Tyvm :D

Edited by Pedram

Share this post


Link to post
Share on other sites

Hi @pintus thank you for using our module.

 

This module only shows comments on home page. If you want to show comments on other CMS pages then you can use our Facebook comment module which will help you. Thank You

Edited by alastairbrian

Share this post


Link to post
Share on other sites

I do not need the form facebok..mi really like the form that you condiviso..solo that I would like displayed in a page where I post only those reviews ... because I do not really like to see all the home ... I would only change its position :) 

Share this post


Link to post
Share on other sites

Hi  I tested this module and it work fine , show comments from ID 1 to...(number which I decided)

But ID 1 is the oldest  comment not fresh/last

How to display comments from the last ID backward?

Share this post


Link to post
Share on other sites

 

......1 with the following response:Hello, Thank you for touching base about our Free Prestashop Module. We support all our module however our free modules come under the paid supp= ort at $35/hour.......

 

 

hahahahah what a cr*p

Share this post


Link to post
Share on other sites

@hatak, as mentioned, it is not possible to provide deep support for free modules.  You are free to tweak and test, but in case you need customization, you can request a quote. You can also contact our live chat, support on our site regarding customization.

 

I hope you do understand.

 

Many Thanks, 

Share this post


Link to post
Share on other sites

Hi,

 

module is really nice. But it doesn`t show the latest reviews but the oldest. What to do to change it?

 

Share this post


Link to post
Share on other sites
Hi,

 

Thank you for your free Prestashop HOME COMMENTS module.

 

I tried to install this module on a shop built with Prestashop 1.5.6.0.

 

Unfortunately, I got the here below error message :

 

Strict Standards: Non-static method homeBlock::insertTitle() should not be called statically, assuming $this from incompatible context in ../modules/fmmhomecomments/fmmhomecomments.php on line 48

 

Db->executeS() must be used only with select, show, explain or describe queries

at line 476 in file classes/db/Db.php

 

Would you have any suggestion to solve the matter ?

 

Thank you in advance for any reply.

 

Kind Regards,

 

Patrick

Share this post


Link to post
Share on other sites

Hello,

 

I installed this module on my home page and I am really glad of it. I wonder if it`s possible to launch this module at the same time to other page. I mean I would like to have dedicated page with reviews and also have a 4 reviews on home page. Do You have any solution?

 

Thank You in advance for response!

Share this post


Link to post
Share on other sites

Hi @Glorfi,

 

Hope you doing great. :)

 

First of all thank you for using our module :)

 

This "PrestaShop home comments module" only shows reviews on home page. However, if you want to show reviews on a dedicated page of your web store then you can use our pro module which can show testimonials in a separate page in an elegant view. Here is the demo link of the module: http://advtestimonials.bestprestashopmodules.net/module/advancetestimonials/Testimonials 

 

This module shows review with images and customers can directly submit from their account which admin can approve from back office. Here is the module link: www.fmemodules.com/en/35-advance-testimonials.html

 

Have a nice day.

Share this post


Link to post
Share on other sites

[PrestaShopDatabaseException]

Db->executeS() must be used only with select, show, explain or describe queries

at line 616 in file classes/db/Db.php

611.

612.         // This method must be used only with queries which display results

613.         if (!preg_match('#^\s*\(?\s*(select|show|explain|describe|desc)\s#i', $sql))

614.         {

615.             if (defined('_PS_MODE_DEV_') && _PS_MODE_DEV_)

616.                 throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');

617.             return $this->execute($sql, $use_cache);

618.         }

619.

620.         $this->result = $this->query($sql);

621.

Share this post


Link to post
Share on other sites

[PrestaShopDatabaseException]

Db->executeS() must be used only with select, show, explain or describe queries

at line 616 in file classes/db/Db.php

611.

612.         // This method must be used only with queries which display results

613.         if (!preg_match('#^\s*\(?\s*(select|show|explain|describe|desc)\s#i', $sql))

614.         {

615.             if (defined('_PS_MODE_DEV_') && _PS_MODE_DEV_)

616.                 throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');

617.             return $this->execute($sql, $use_cache);

618.         }

619.

620.         $this->result = $this->query($sql);

621.

 

Hi

in/models/homeBlock.php

replace

if (Db::getInstance()->executeS($sql))

by 

if (Db::getInstance()->execute($sql))

lines 17, 28 et 63

because Db->executeS() must be used only with select, show, explain or describe queries and not for action queries as insert, delete or update

Edited by Eolia

Share this post


Link to post
Share on other sites

Hi,

 

Thanks for fast answer, everithings good but now i see this on my website top Strict Standards: Non-static method homeBlock::getTitle() should not be called statically, assuming $this from incompatible context in/home/pigumas/domains/pigumas.lt/public_html/modules/fmmhomecomments/fmmhomecomments.php on line 163 .

Share this post


Link to post
Share on other sites

Hi,

 

Thanks for fast answer, everithings good but now i see this on my website top Strict Standards: Non-static method homeBlock::getTitle() should not be called statically, assuming $this from incompatible context in/home/pigumas/domains/pigumas.lt/public_html/modules/fmmhomecomments/fmmhomecomments.php on line 163 .

lol this module is a joke :)

 

replace in the same file all non static functions as:

<?php
/***************************************************************
 * FME homeComment Model.
 * Welcome to FME.
 * Glad to see you.
 ***************************************************************
 */

class homeBlock extends ObjectModel
{
	public static function insertTitle($Id,$Title)
		{	
			
			$sql = 'INSERT INTO `'._DB_PREFIX_.'configuration_lang` (`id_configuration`, `value`)
				VALUES('.(int)$Id.', "'.pSQL($Title).'")';
			
			if (Db::getInstance()->execute($sql))
			    return Db::getInstance()->Insert_ID();
			
		}

	public static function deleteTitle($Id)
		{	
			
			$sql = 'DELETE FROM `'._DB_PREFIX_.'configuration_lang`
				WHERE `id_configuration` ='.(int)$Id;
				
			if (Db::getInstance()->execute($sql))
			    return Db::getInstance()->Insert_ID();
			
		}

	public static function getTitle()
		{
			$sql = 'SELECT `id_lang`,`value`
					FROM `'._DB_PREFIX_.'configuration_lang`
					WHERE `id_configuration` ='.(int)327;
			

			$mytitle = Db::getInstance()->executeS($sql);
			
			if(is_array($mytitle))	
			{	
				foreach($mytitle as $title)
					{
						$Title = $result[(int)$title['id_lang']]['value'] = $title['value'];

					}

			}	

			return $Title;
		
		}

	public static function updateTitle($Title)
		{
	
			$sql = 'UPDATE `'._DB_PREFIX_.'configuration_lang`
					SET `value` = "'.pSQL($Title).'"
					WHERE `id_configuration` = 327';

			if (Db::getInstance()->execute($sql))
			    return Db::getInstance()->Insert_ID();

		}

	public static function getAll($id_lang)
	{

		$sql = 'SELECT pc.*,pl.*, im.*
				FROM `'._DB_PREFIX_.'product_comment` pc  
				LEFT JOIN `'._DB_PREFIX_.'product_lang` pl 
					ON pc.id_product = pl.id_product
				INNER JOIN `'._DB_PREFIX_.'image` im 
					ON pc.id_product = im.id_product
				WHERE pl.`id_product` = pc.`id_product`
			 	AND pl.`id_lang`='.(int)$id_lang.'
			 	GROUP BY pc.id_product_comment';		

			$id_image = Db::getInstance()->executeS($sql);

		return $id_image;

	}
}

?>
Edited by Eolia

Share this post


Link to post
Share on other sites

Hi! Thanks for sharing this good module. 

But i have some bug. On my PS 1.6.0.14 comments shows up from first to last.

I want latest comments are shown first.

And i cant hide name and title don't shows, whatever i do with settings.

Stars i can still control.

Can someone help how to fix this?

Share this post


Link to post
Share on other sites

Hi aromatik,

 

Thank for appreciating our module. :)

 

Please check PM

 

Thanks, but you send me to the paid support...

But i think someone can solve my problem here!

 

My question is still open:

 

 

 

Hi! Thanks for sharing this good module. 

But i have some bug. On my PS 1.6.0.14 comments shows up from first to last.

I want latest comments are shown first.

And i cant hide name and title don't shows, whatever i do with settings.

Stars i can still control.

Can someone help how to fix this?

 

Edited by Aromatik

Share this post


Link to post
Share on other sites

the solution for make it works properly is so:

 

To see the coments ordered by the last date go to:

public_html/modules/fmmhomecomments/models/homeblock.php

 

and in:

$sql = 'SELECT pc.*,pl.*, im.*
				FROM `'._DB_PREFIX_.'product_comment` pc  
				LEFT JOIN `'._DB_PREFIX_.'product_lang` pl 
					ON pc.id_product = pl.id_product
				INNER JOIN `'._DB_PREFIX_.'image` im 
					ON pc.id_product = im.id_product
				WHERE pl.`id_product` = pc.`id_product`
			 	AND pl.`id_lang`='.(int)$id_lang.'
			 	GROUP BY pc.id_product_comment';		

			$id_image = Db::getInstance()->executeS($sql);

		return $id_image;

replace:

GROUP BY pc.id_product_comment';		

for:

GROUP BY pc.id_product_comment DESC';		

or:

GROUP BY pc.date_add DESC';		

Share this post


Link to post
Share on other sites

Hi i use presta 1.6.1.1, I installed this module, and write a comment on a product,  by yotpo and facebook comment plugin tools,

the comment doesn't show on home page,  the place says "Currently there are no Comments."....

 

how can I solve this problem.. thanks!

Share this post


Link to post
Share on other sites

Hello !

 

Old topic, but i need to talk about perf-killers...

 

Your $sql returns all the field for all the join. Why ?

Select * is a perf killer....

To do it correctly, you should write the select like that :

             SELECT pc.id_product,pc.content,pc.date_add,
                        pc.customer_name,pc.grade,pc.validate,
                        pl.link_rewrite,im.id_image

instead of 

SELECT pc.*,pl.*, im.*

And why put all the array in the tpl instead of adding a limit ? because of mysql which is not SQL92 compliance ?...

 

so this is my contribution.

Share this post


Link to post
Share on other sites

the full SQL for getAll function in the homeBlock.php :

public static function getAll($id_lang,$limite) {
        $sql = 'SELECT pc.id_product , pc.content , pc.date_add ,
                            pc.customer_name , pc.grade , pc.validate ,
                            pl.link_rewrite , im.id_image ,
                            CONCAT( cus.firstname,  " ", UPPER( SUBSTR( cus.lastname, 1, 1 ) ) ,  ".") AS name
                    FROM `'._DB_PREFIX_.'product_comment` pc  
                        LEFT JOIN `'._DB_PREFIX_.'product_lang` pl 
                            ON pc.id_product = pl.id_product
                        INNER JOIN `'._DB_PREFIX_.'image` im 
                            ON pc.id_product = im.id_product
                        LEFT JOIN `'._DB_PREFIX_.'customer` cus
                            ON cus.id_customer = pc.id_customer
                    WHERE pl.`id_product` = pc.`id_product`
                        AND pl.`id_lang`='.(int)$id_lang.'
                        AND pc.`validate` = 1
                        GROUP BY pc.date_add DESC
                    LIMIT 0, '.$limite ;
        $id_image = Db::getInstance()->executeS($sql);
        return $id_image;
    }

And the tpl with the limite :

 public function hookDisplayHome()
    {    

        $id_lang = $this->context->language->id;
        $id_shop = $this->context->shop->id;
        $myTitle = homeBlock::getTitle();
        $myFFMlimite = Configuration::get('FMM_Home_COMMENTS');
        
        $myData = homeBlock::getAll($id_lang,$myFFMlimite);

        $this->context->smarty->assign(array(
            'nbComments'  => Configuration::get('FMM_Home_COMMENTS'),
            'allow_cust'  => Configuration::get('SHOW_CUSTOMER_NAME'),
            'allow_stars' => Configuration::get('SHOW_STARS'),
            'allow_title' => Configuration::get('SHOW_COMMENT_TITLE'),
            'module_title'=> $myTitle,
            'cmt_data'    => $myData,
            ));

        return ($this->display(__FILE__, 'fmmhomecomments.tpl'));
    }

Share this post


Link to post
Share on other sites

This is awesome module, I like it, thanks fme team developer

Unfortunately not support slide to show every testimonial at home page, if has would be more awesome...hihi

 

Thank you so much

Share this post


Link to post
Share on other sites

Hello.

I installed it but I have this error:

 

Notice on line 52 en archivo /var/www/vhosts/modules/fmmhomecomments/models/homeBlock.php
[8] Undefined variable: Title

 

It has a solution?

Thanks.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×