Jump to content

Add comments


Recommended Posts

if you add table:

CREATE TABLE ".$prefix."store_comments (

name varchar(100) NOT NULL,

product varchar(60) NOT NULL default '',

stars tinyint(1) DEFAULT '0' NOT NULL,

status tinyint(1) DEFAULT '0' NOT NULL,

comments text NOT NULL,

id int(60) NOT NULL auto_increment,

PRIMARY KEY (id))

... then You must change -> ".prefix."

Example I use prefix shp_ and this table name is shp_store_comments and I insert to database command line:

CREATE TABLE shp_store_comments (

name varchar(100) NOT NULL,

product varchar(60) NOT NULL default '',

stars tinyint(1) DEFAULT '0' NOT NULL,

status tinyint(1) DEFAULT '0' NOT NULL,

comments text NOT NULL,

id int(60) NOT NULL auto_increment,

PRIMARY KEY (id))

Brgrds,

Joker

Link to comment
Share on other sites

  • 1 month later...

Hi!

installed this mod, it worked but after a while it shows this error message:

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/goosfrab/public_html/addcomment.php:1) in /home/goosfrab/public_html/addcomment.php on line 10

Any clue?

Tkx

Pardon__Me

EDIT: weird... now it doesn't... just deleted a space from the begining of line 1...

Edited by Pardon__Me
Link to comment
Share on other sites

  • 1 month later...

link not working for download

i have older version of this fantastic mod but i cant change any comments from not public to public and yes i have the instock mod installed?

ne ideas?

Link to comment
Share on other sites

You can download it in here phorum and find download below first comment!

First you must update your mod because I corrected meny mistakes and added some updates. If you still will be problems, then post them to here.

Brgrds,

Joker

Link to comment
Share on other sites

  • 2 weeks later...
Guest twisted

I had someone ask me to install this for them today.

This is the first time I have seen this mod [or at least, jokers version of it], and I am prompted to say one thing....

This mod, without a doubt and beyond question, has THE BEST installation intructions I have EVER seen........bar NONE!

Totally complete, totally organised, 100% thorough!

Kudos, joker!

OK.......i'm done.

Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
Guest fernyburn

Hi

Ok this is a totally thicko question - but im not a programmer

I am getting a parse error

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in /home/sunshine/public_html/shop/view_product.php on line 250

the line is this one

/// add comments //////////////////////////////// 

$sql_select = mysql_query( "select * from ".$prefix."store_comments where product='$product' and status='1' order by id asc");

this is copied direct from the file

can you help fix it ??

Link to comment
Share on other sites

could u post a bit more of the code pls say 20 lines either side of the problem 1 pls so i can compare it to mine

Link to comment
Share on other sites

  • 2 weeks later...

Hi Joker,

i´m total lama in PHP, pls help me B).

I use this mod. Its great, but the stars are direct after the name of product.

I want to give it under the name of product.

Can you help me pls?

Thx

Link to comment
Share on other sites

Guest Powdercoatingworld

I added this mod today , and i dont see it on my site at all ....any ideas ?

Link to comment
Share on other sites

Hi Joker,

can you help me pls, i have two ideas how to do this script better.

1. Is possible show the time in comment?

2. In admin menu i want to see last comments up and old commetns down.

Now is old comments up and new comments down.

Can you help me pls?

Thx a lot

Link to comment
Share on other sites

im still at a loss with this 1 joker all works well except when i go to click change comment.

customer can add comment

comment saved in database

shows up in admin as new comment - not public

if i force status of comment to 1 it shows in product page

problem i have is whenever i click on ghange comment be it new or public i just get blank screen saying

Public comments Version 1.2 by Joker

Back to comments without saving!

ne ideas only difference i can c is i using v3 addmin menu

so links are like this

<li><a href="<?echo"$site_url/admin/comments.php?value=0";?>" class="txtLink">New comments</a></li>

<li><a href="<?echo"$site_url/admin/comments.php?value=1";?>" class="txtLink">Public comments</a></li>

cant c wot problem can be can u?

Link to comment
Share on other sites

Guest Joker

I newer test it with version 3, but with version 1 and 2, but I think that it should work with verion 3 too.

Link to comment
Share on other sites

im still at a loss with this 1 joker all works well except when i go to click change comment.

customer can add comment

comment saved in database

shows up in admin as new comment - not public

if i force status of comment to 1 it shows in product page

problem i have is whenever i click on ghange comment be it new or public i just get blank screen saying

Public comments Version 1.2 by Joker

Back to comments without saving!

ne ideas only difference i can c is i using v3 addmin menu

so links are like this

<li><a href="<?echo"$site_url/admin/comments.php?value=0";?>" class="txtLink">New comments</a></li>

<li><a href="<?echo"$site_url/admin/comments.php?value=1";?>" class="txtLink">Public comments</a></li>

cant c wot problem can be can u?

I use CC3 admin menu too and in my nav.php i have this:

<ul><span class="navTitle"><?echo$la_nav_comments;?></span>

<li><a href="<?echo"$site_url/admin/comments.php?value=0";?>" class="txtLink"><?echo$la_nav_comments_new;?></a></li>

<li><a href="<?echo"$site_url/admin/comments.php?value=1";?>" class="txtLink"><?echo$la_nav_comments_public;?></a></li>

Try to use it

Link to comment
Share on other sites

×
×
  • Create New...