PDA

View Full Version : Hide unnotified comments



kwiznoz
09-02-2005, 08:37 AM
Is there a way in oscmax 2 to hide the comments using this mod?

http://www.oscommerce.com/community/contributions,2874/category,all/search,notes

I tried to install it but it seems that the query it is calling is not in account_history_info.php...?

We just want to blind all comments that were not selected as "notify customer" to customer's viewing.

jpf
09-03-2005, 10:51 AM
Note: OSCMAX has BTS installed which MOVES alot of code to a template system.

If you did a search for "$statuses_query" (part of the string to be replaced) you would have fond this file:

account_history_info.tpl.php

and look about on line 153 you would have found the line to be modified
Replace:
$statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added");
with:
$statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.customer_notified = '1' and osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added");


Should work just fine.

kwiznoz
09-08-2005, 03:22 PM
I was able to fix it, thank you! One would think this would be a regular part of oscommerce or oscmax, if you do not select the box to Notify customer of any notes inputed, by default, it should not make the notes available to the customer online for reading...

That should be added to the next release IMO! Thanks again!