$products_name_query = vam_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $reviews['products_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'");
$products_name = vam_db_fetch_array($products_name_query);
$reviews_average_query = vam_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . $reviews['products_id'] . "'");
$reviews_average = vam_db_fetch_array($reviews_average_query);
$review_info = vam_array_merge($reviews_text, $reviews_average, $products_name);
$rInfo_array = vam_array_merge($reviews, $review_info, $products_image);
$rInfo = new objectInfo($rInfo_array);
}
if (is_object($rInfo) && $reviews['reviews_id'] == $rInfo->reviews_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . vam_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=preview') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . vam_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id']) . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php
echo '<a href="' . vam_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id'] . '&action=preview') . '">' . vam_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . vam_get_products_name($reviews['products_id']);
?>
</td>
<td class="dataTableContent" align="right"><?php
echo vam_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/img/stars_' . $reviews['reviews_rating'] . '.gif');
?>
</td>
<td class="dataTableContent" align="right"><?php
echo vam_date_short($reviews['date_added']);
?>
</td>
<td class="dataTableContent" align="center">
<?php
if ($reviews['marked'] == 1) {
echo '<img src="images/icon_status_green.gif" border="0" alt="Enabled" title="Enabled" width="10" height="10"/>';
echo '<a class="disable" href="javascript:void(0);" data_id="' . $reviews['reviews_id'] . '"><img src="images/icon_status_red_light.gif" border="0" alt="Disable" title="Disable" width="10" height="10"/><a>';
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id . '&action=edit_category') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/edit.png', '', '12', '12') . ' ' . BUTTON_EDIT . '</span></a>');
//Insert new Element Actions
$contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INSERT_ELEMENT . '</div>');
if (!$_GET['search']) {
$contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_category') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/categories.png', '', '12', '12') . ' ' . BUTTON_NEW_CATEGORIES . '</span></a></td></tr><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_product') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/products.png', '', '12', '12') . ' ' . BUTTON_NEW_PRODUCTS . '</span></a></td></tr></table>');
}
//Informations
$contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INFORMATIONS . '</div>');
$contents[] = array('text' => '<div style="padding-left: 50px;">' . TEXT_DATE_ADDED . ' ' . vam_date_short($cInfo->date_added) . '</div>');
if (vam_not_null($cInfo->last_modified)) {
$contents[] = array('text' => '<div style="padding-left: 50px;">' . TEXT_LAST_MODIFIED . ' ' . vam_date_short($cInfo->last_modified) . '</div>');
}
$contents[] = array('align' => 'center', 'text' => '<div style="padding: 10px;">' . vam_info_image_c($cInfo->categories_image, $cInfo->categories_name, 100, 100) . '</div><div style="padding-bottom: 10px;">' . $cInfo->categories_image . '</div>');
} elseif (is_object($pInfo)) {
// product info box contents
$heading[] = array('align' => 'center', 'text' => '<b>' . vam_get_products_name($pInfo->products_id, $_SESSION['languages_id']) . '</b>');
//Multi Element Actions
$contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%;">' . TEXT_MARKED_ELEMENTS . '</div>');
$contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center">' . '<span class="button"><button type="submit" value="' . BUTTON_DELETE . '" name="multi_delete">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</button></span>' . '</td></tr><tr><td>' . '<span class="button"><button type="submit" value="' . BUTTON_MOVE . '" name="multi_move">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/move.png', '', '12', '12') . ' ' . BUTTON_MOVE . '</button></span>' . '</td></tr><tr><td align="center">' . '<span class="button"><button type="submit" value="' . BUTTON_COPY . '" name="multi_copy">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/copy.png', '', '12', '12') . ' ' . BUTTON_COPY . '</button></span>' . '</td></tr></table>');
$contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><span class="button"><button type="submit" name="multi_status_on" value="' . BUTTON_STATUS_ON . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/submit.png', '', '12', '12') . ' ' . BUTTON_STATUS_ON . '</button></span></td></tr><tr><td align="center"><span class="button"><button type="submit" name="multi_status_off" value="' . BUTTON_STATUS_OFF . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_STATUS_OFF . '</button></span></td></tr></table>');
$contents[] = array('text' => '</form>');
//Single Product Actions
$contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_ACTIVE_ELEMENT . '</div>');
$contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&pID=' . $pInfo->products_id . '&action=new_product') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/edit.png', '', '12', '12') . ' ' . BUTTON_EDIT . '</span></a></td></tr><tr><td align="center"><form action="' . FILENAME_NEW_ATTRIBUTES . '" name="edit_attributes" method="post"><input type="hidden" name="action" value="edit"><input type="hidden" name="current_product_id" value="' . $pInfo->products_id . '"><input type="hidden" name="cpath" value="' . $cPath . '"><span class="button"><button type="submit" value="' . BUTTON_EDIT_ATTRIBUTES . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/add.png', '', '12', '12') . ' ' . BUTTON_EDIT_ATTRIBUTES . '</button></span></form></td></tr><tr><td align="center" style="text-align: center;"><form action="' . FILENAME_CATEGORIES . '" name="edit_crossselling" method="GET"><input type="hidden" name="action" value="edit_crossselling"><input type="hidden" name="current_product_id" value="' . $pInfo->products_id . '"><input type="hidden" name="cpath" value="' . $cPath . '"><span class="button"><button type="submit" value="' . BUTTON_EDIT_CROSS_SELLING . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/add.png', '', '12', '12') . ' ' . BUTTON_EDIT_CROSS_SELLING . '</button></span></form></td></tr></table>');
//Insert new Element Actions
$contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INSERT_ELEMENT . '</div>');
if (!$_GET['search']) {
$contents[] = array('align' => 'center', 'text' => '<table border=0><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_category') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/categories.png', '', '12', '12') . ' ' . BUTTON_NEW_CATEGORIES . '</span></a></td></tr><tr><td align="center"><a class="button" href="' . vam_href_link(FILENAME_CATEGORIES, vam_get_all_get_params(array('cPath', 'action', 'pID', 'cID')) . 'cPath=' . $cPath . '&action=new_product') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/products.png', '', '12', '12') . ' ' . BUTTON_NEW_PRODUCTS . '</span></a></td></tr></table>');
}
//Informations
$contents[] = array('align' => 'center', 'text' => '<div style="padding-top: 5px; font-weight: bold; width: 90%; margin-top: 5px;">' . TEXT_INFORMATIONS . '</div>');
<td class="dataTableHeadingContent" width="40%"><?php echo PIN_HEADING_PRODUCT; ?></td>
<td class="dataTableHeadingContent" width="40%"><?php echo PIN_HEADING_NUMBEROF; ?></td>
<td class="dataTableHeadingContent" width="20%"><?php echo PIN_HEADING_ACTION; ?></td>
</tr>
<?php
$query_str = "SELECT pp.products_id, p.products_quantity AS pcount, count(*) AS all_pin FROM ".TABLE_PRODUCTS_PINS." pp, " . TABLE_PRODUCTS . " p where pp.products_id = p.products_id GROUP BY pp.products_id";
//echo($query_str);
$pins_query=vam_db_query($query_str);
$odd_even = 1;
while($pin_res=vam_db_fetch_array($pins_query)) {
$row_class = ( ($odd_even % 2) == 0 ) ? 'dataTableRowSelected' : 'dataTableRow';
?>
<tr class="<?php echo $row_class?>">
<td class="dataTableContent">
<?php echo vam_get_products_name($pin_res['products_id']);?></td>
<td class="dataTableContent"><?php echo $pin_res['pcount'].' / ' . $pin_res['all_pin']?></td>
<td class="dataTableContent"><a href="<?php echo vam_href_link(FILENAME_PIN_LOADER, 'action=edit&products_id='.$pin_res['products_id'], 'SSL');?>"><?php echo PIN_ACTION_EDIT?></a></td>
</tr>
<?
$odd_even++;
}
/*
$pins_query=vam_db_query("SELECT products_id, COUNT(*) AS pcount FROM ".TABLE_PRODUCTS_PINS." GROUP BY products_id");
while($pin_res=vam_db_fetch_array($pins_query)) {
echo '<tr class="dataTableRow"><td class="dataTableContent">'.vam_get_products_name($pin_res['products_id']).'</td><td class="dataTableContent">'.$pin_res['pcount'].'</td></tr>';
} */
?>
</table>
<?php
for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
?>
<div id="tab<?php
echo $i;
?>
">
<table border="0">
<tr>
<td valign="top" class="main"><?php
echo TEXT_PRODUCTS_NAME;
?>
</td>
<td valign="top" class="main"><?php
echo vam_draw_input_field('products_name[' . $languages[$i]['id'] . ']', $products_name[$languages[$i]['id']] ? stripslashes($products_name[$languages[$i]['id']]) : vam_get_products_name($pInfo->products_id, $languages[$i]['id']), 'size=60');
?>
</td>
</tr>
<tr>
<td valign="top" class="main"><?php
echo TEXT_PRODUCTS_URL;
?>
</td>
<td valign="top" class="main"><?php
echo vam_draw_input_field('products_url[' . $languages[$i]['id'] . ']', $products_url[$languages[$i]['id']] ? stripslashes($products_url[$languages[$i]['id']]) : vam_get_products_url($pInfo->products_id, $languages[$i]['id']), 'size=60') . ' <small>' . TEXT_PRODUCTS_URL_WITHOUT_HTTP . '</small>';
?>
</td>
</tr>
<tr>
<td valign="top" class="main"><?php
