This is a discussion on Reviews in Article Info (Article Manager) within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; When you have installed the Review Aproval System you can also use it for this contribution. The aprroval didn't ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| When you have installed the Review Aproval System you can also use it for this contribution. The aprroval didn't work good with mne OSC. Maybe you also have the same problem..then replace this peace of code: On Line 14 Find: ===================== $reviews_query = tep_db_query("select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.reviews_read, r.date_added, r.customers_name from " . TABLE_ARTICLE_REVIEWS . " r, " . TABLE_ARTICLE_REVIEWS_DESCRIPTION . " rd where r.articles_id = '" . (int)$article_info['articles_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' order by r.reviews_id desc"); AND REPLACE WITH: ===================== $reviews_query = tep_db_query("select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.reviews_read, r.date_added, r.customers_name from " . TABLE_ARTICLE_REVIEWS . " r, " . TABLE_ARTICLE_REVIEWS_DESCRIPTION . " rd where r.approved = 1 and r.articles_id = '" . (int)$article_info['articles_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' order by r.reviews_id desc"); More...
__________________ Michael Sasek osCMax Developer osCMax Templates - Hundreds of premium quality templates. New designs every month! xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host. |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Article Manager v1.0 | michael_s | New osCommerce Contributions | 0 | 09-12-2007 03:24 PM |
| Article Manager v1.0 | michael_s | New osCommerce Contributions | 0 | 07-20-2007 07:28 AM |
| Article Manager v1.0 | michael_s | New osCommerce Contributions | 0 | 06-20-2007 12:22 PM |
| Reviews in Article Info (Article Manager) | michael_s | New osCommerce Contributions | 0 | 05-10-2007 02:00 PM |
| MS2-Max & article manager | Anonymous | osCMax v1.7 Discussion | 0 | 03-23-2004 01:57 PM |