$reviews = $reviews_result->fields; $pInfo_array = array_merge($products, $reviews); $pInfo = new objectInfo($pInfo_array); } if (isset($pInfo) && is_object($pInfo) && $products['products_id'] == $pInfo->products_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['products'], 'categories=' . $categories . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&pID=' . $products['products_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . oos_href_link_admin($aFilename['products'], 'categories=' . $categories . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . oos_image(OOS_IMAGES . 'icons/preview.gif', ICON_PREVIEW) . '</a> ' . '#' . $products['products_id'] . ' ' . $products['products_name']; ?> </td> <td class="dataTableContent"><?php echo oos_get_manufacturers_name($products['products_id']); ?> </td> <td class="dataTableContent" align="center"> access </td> <td class="dataTableContent" align="center"> <?php /* if (STOCK_CHECK == '1') { switch ($products['products_status']) { case '0': echo oos_image(OOS_IMAGES . 'icon_status_red.gif', $image_icon_status_array[0]['text'], 10, 10); break; case '1': echo oos_image(OOS_IMAGES . 'icon_status_blue.gif', $image_icon_status_array[1]['text'], 10, 10); break;
if ((!isset($_GET['pID']) && !isset($_GET['cID']) || (isset($_GET['pID']) && ($_GET['pID'] == $products['products_id']))) && !isset($pInfo) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) { // find out the rating average from customer reviews $reviews_result = $dbconn->Execute("SELECT (avg(reviews_rating) / 5 * 100) as average_rating FROM " . $oostable['reviews'] . " WHERE products_id = '" . $products['products_id'] . "'"); $reviews = $reviews_result->fields; $pInfo_array = array_merge($products, $reviews); $pInfo = new objectInfo($pInfo_array); } if (isset($pInfo) && is_object($pInfo) && ($products['products_id'] == $pInfo->products_id) ) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['products'], 'categories=' . $categories . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&pID=' . $products['products_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . oos_href_link_admin($aFilename['products'], 'categories=' . $categories . '&pID=' . $products['products_id'] . '&action=new_product_preview&read=only') . '">' . oos_image(OOS_IMAGES . 'icons/preview.gif', ICON_PREVIEW) . '</a> ' . '#' . $products['products_id'] . ' ' . $products['products_name']; ?></td> <td class="dataTableContent"><?php echo oos_get_manufacturers_name($products['products_id']) ?></td> <td class="dataTableContent" align="center"> access </td> <td class="dataTableContent" align="center"> <?php /* if (STOCK_CHECK == '1') { switch ($products['products_status']) { case '0': echo oos_image(OOS_IMAGES . 'icon_status_red.gif', $image_icon_status_array[0]['text'], 10, 10); break; case '1': echo oos_image(OOS_IMAGES . 'icon_status_blue.gif', $image_icon_status_array[1]['text'], 10, 10); break; case '2':