3 replies to this topic

[Peper]

I'm busy altering product reviews to product questions
Everything is already converted from catalog to admin to view, add, delete and so on

Need some help on this though to get answer_text working with the following
database => question_description table and then => questions_id languages_id questions_text answer_text
Like reviews, the product id is tied to the questions id

product_questions.php (product_reviews.php)

$questions_query_raw = "select r.questions_id, left(rd.questions_text, 180) as questions_text, r.date_added, r.customers_name from " . TABLE_QUESTIONS . " r, " . TABLE_QUESTIONS_DESCRIPTION . " rd where r.products_id = '" . (int)$product_info['products_id'] . "' and r.questions_id = rd.questions_id and rd.languages_id = '" . (int)$languages_id . "' order by r.questions_id desc";
  $questions_split = new splitPageResults($questions_query_raw, MAX_DISPLAY_NEW_QUESTIONS);

then further down I have
<td valign="top" class="main"><?php echo 'Q. ' . tep_break_string(tep_output_string_protected($questions['questions_text']), 60, '-<br>') . ((strlen($questions['questions_text']) >= 100) ? '..' : '') . '<br><br><i>';
?>
<?php echo 'A. ' . tep_break_string(tep_output_string_protected($questions_description['answer_text']), 60, '-<br>') . ((strlen($questions_descriptions['answer_text']) >= 100) ? '..' : '');
?>
As you can see, I tried to output the answer for the question
Any help in the right direction please

[Peper]

Ok, everything sorted

If someone need addon,l will put it up. - v2.2 RC2a

Basicly taken reviews and made a question section out of this.
Customer must be logged in to ask, no html possible.
Admin will receive email once a question is posted
Admin can answer, edit and delete questions

I attached screen shots.

Attached Files

•  catalog.jpg   86.44K   4 downloads
•  admin.jpg   72.79K   4 downloads

[Peper]

Need some tiny bit of help as I cannot find anything on this.

In admin, is there any way to notify a customer their review has been updated - taken customer e-mail from database, product_id and review_id?
A tick box on this or something similar to select notify customer

Any help would be appreciated

[mumme]

Peper, on 13 September 2011, 13:37, said:

Need some tiny bit of help as I cannot find anything on this.

In admin, is there any way to notify a customer their review has been updated - taken customer e-mail from database, product_id and review_id?
A tick box on this or something similar to select notify customer

Any help would be appreciated

Hi Peper,

On a new site Im trying to do something similar.
I just spent a couple of hours on hotscripts.com to see if I could find a ticket / helpdesk system to intergreat to Oscommerce but I couldnt find any.
Did a google search and found your post here. Maybye your system is somehting we can work on.

How far have you got?

I want to have a "ask a questions" function on every products and also show erlier questions and answers on the product_info page.
When somebody sends a question one of the administratior should get an email, he will log in to the admin-tool, answer the question.
Then the question and answer will be published on the site, and the costumer should get a email like: Hi xxx, your questions is answerd, please visist www.xxxxx.com/product_info.php to see the answer".

Please let me know how far you have got and if there is something we can work togheter on..