$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('delete_image', '', true) . ' ' . TEXT_DELETE_IMAGE);
if ($mInfo->products_count > 0) {
$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('delete_products') . ' ' . TEXT_DELETE_PRODUCTS);
$contents[] = array('text' => '<br />' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $mInfo->products_count));
}
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($mInfo) && is_object($mInfo)) {
$heading[] = array('text' => '<b>' . $mInfo->manufacturers_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($mInfo->date_added));
if (oos_is_not_null($mInfo->last_modified)) {
$contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . oos_date_short($mInfo->last_modified));
}
$contents[] = array('text' => '<br />' . oos_info_image($mInfo->manufacturers_image, $mInfo->manufacturers_name));
$contents[] = array('text' => '<br />' . TEXT_PRODUCTS . ' ' . $mInfo->products_count);
}
break;
}
if (!empty($heading) && !empty($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
</table></td>
$contents = array();
switch ($action) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_FEATURED . '</b>');
$contents = array('form' => oos_draw_form('featured', $aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($sInfo) && is_object($sInfo)) {
$heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_ADDED . ' ' . oos_date_short($sInfo->featured_date_added));
$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . oos_date_short($sInfo->featured_last_modified));
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));
$contents[] = array('text' => '<br />' . TEXT_INFO_EXPIRES_DATE . ' <b>' . oos_date_short($sInfo->expires_date) . '</b>');
$contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . oos_date_short($sInfo->date_status_change));
}
break;
}
if (!empty($heading) && !empty($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
}
?>
</tr>
</table></td>
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_REVIEW . '</b>');
$contents = array('form' => oos_draw_form('reviews', $aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_REVIEW_INTRO);
$contents[] = array('text' => '<br /><b>' . $rInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($rInfo) && is_object($rInfo)) {
$heading[] = array('text' => '<b>' . $rInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_ADDED . ' ' . oos_date_short($rInfo->date_added));
if (oos_is_not_null($rInfo->last_modified)) {
$contents[] = array('text' => TEXT_INFO_LAST_MODIFIED . ' ' . oos_date_short($rInfo->last_modified));
}
$contents[] = array('text' => '<br />' . oos_info_image($rInfo->products_image, $rInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));
$contents[] = array('text' => '<br />' . TEXT_INFO_REVIEW_AUTHOR . ' ' . $rInfo->customers_name);
$contents[] = array('text' => TEXT_INFO_REVIEW_RATING . ' ' . oos_image(OOS_HTTP_SERVER . OOS_SHOP . OOS_IMAGES . 'stars_' . $rInfo->reviews_rating . '.gif'));
$contents[] = array('text' => TEXT_INFO_REVIEW_READ . ' ' . $rInfo->reviews_read);
$contents[] = array('text' => '<br />' . TEXT_INFO_REVIEW_SIZE . ' ' . $rInfo->reviews_text_size . ' bytes');
$contents[] = array('text' => '<br />' . TEXT_INFO_PRODUCTS_AVERAGE_RATING . ' ' . number_format($rInfo->average_rating, 2) . '%');
}
break;
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['information'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->information_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
}
break;
default:
if (isset($mInfo) && is_object($mInfo)) {
$heading[] = array('text' => '<b>' . $mInfo->information_name . '</b>');
if ($mInfo->information_id > 5) {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['information'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->information_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['information'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->information_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
} else {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['information'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->information_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a>');
}
$contents[] = array('text' => '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($mInfo->date_added));
if (oos_is_not_null($mInfo->last_modified)) {
$contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . oos_date_short($mInfo->last_modified));
}
$contents[] = array('text' => '<br />' . oos_info_image($mInfo->information_image, $mInfo->information_name));
}
break;
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
</table></td>
<!-- body_text_eof //-->
$featured_result = $dbconn->Execute($query);
if (!$featured_result->RecordCount()) {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['featured'], 'pID=' . $pInfo->products_id . '&action=new') . '">' . oos_image_swap_button('featured', 'featured_off.gif', IMAGE_FEATURED) . '</a>');
} else {
$featured = $featured_result->fields;
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['featured'], 'fID=' . $featured['featured_id'] . '&action=edit') . '">' . oos_image_swap_button('featured', 'featured_off.gif', IMAGE_FEATURED) . '</a>');
}
}
$contents[] = array('text' => '#' . $pInfo->products_id . ' ' . TEXT_CATEGORIES . ' ' . oos_get_categories_name($current_category_id) . '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($pInfo->products_date_added));
if (oos_is_not_null($pInfo->products_last_modified)) {
$contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . oos_date_short($pInfo->products_last_modified));
}
if (date('Y-m-d') < $pInfo->products_date_available) {
$contents[] = array('text' => TEXT_DATE_AVAILABLE . ' ' . oos_date_short($pInfo->products_date_available));
}
$contents[] = array('text' => '<br /><a href="' . oos_href_link_admin($aFilename['products'], 'categories=' . $categories . '&pID=' . $pInfo->products_id . '&action=new_product_preview&read=only') . '">' . oos_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br />' . $pInfo->products_image);
$oosPrice = $pInfo->products_price;
$oosPriceList = $pInfo->products_price_list;
if (OOS_PRICE_IS_BRUTTO == '1' && ($_GET['read'] == 'only' || $action != 'new_product_preview')) {
$oosPriceNetto = round($oosPrice, TAX_DECIMAL_PLACES);
$oosPriceListNetto = round($oosPriceList, TAX_DECIMAL_PLACES);
$tax_result = $dbconn->Execute("SELECT tax_rate FROM " . $oostable['tax_rates'] . " WHERE tax_class_id = '" . $pInfo->products_tax_class_id . "' ");
$tax = $tax_result->fields;
$oosPrice = $oosPrice * ($tax[tax_rate] + 100) / 100;
$oosPriceList = $oosPriceList * ($tax[tax_rate] + 100) / 100;
if (isset($specials) && is_array($specials)) {
$oosSpecialsPriceNetto = round($specials['specials_new_products_price'], TAX_DECIMAL_PLACES);
$oosSpecialsPrice = round($specials['specials_new_products_price'] * ($tax[tax_rate] + 100) / 100, TAX_DECIMAL_PLACES);
}
}
$oosPrice = round($oosPrice, TAX_DECIMAL_PLACES);
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('save', 'save_off.gif', IMAGE_SAVE) . ' <a href="' . oos_href_link_admin($aFilename['rss_conf'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsfeed_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_HEADING_DELETE_RSS . '</b>');
$contents = array('form' => oos_draw_form('newsfeed', $aFilename['rss_conf'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsfeed_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $nInfo->newsfeed_name . '</b>');
$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('delete_image', '', true) . ' ' . TEXT_DELETE_IMAGE);
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['rss_conf'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsfeed_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($nInfo) && is_object($nInfo)) {
$heading[] = array('text' => '<b>' . $nInfo->newsfeed_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['rss_conf'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsfeed_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['rss_conf'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsfeed_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br /><b>' . $nInfo->newsfeed_type . '</b>');
$contents[] = array('text' => '<br />' . oos_info_image($nInfo->newsfeed_image, $nInfo->newsfeed_name));
$newsfeed_inputs_name_string = '';
$newsfeed_inputs_title_string = '';
$newsfeed_inputs_description_string = '';
$languages = oos_get_languages();
for ($i = 0, $n = count($languages); $i < $n; $i++) {
$newsfeed_inputs_name_string .= '<br />' . oos_image(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' ' . oos_get_newsfeed_name($nInfo->newsfeed_id, $languages[$i]['id']);
$newsfeed_inputs_title_string .= '<br />' . oos_image(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' ' . oos_get_newsfeed_title($nInfo->newsfeed_id, $languages[$i]['id']);
$newsfeed_inputs_description_string .= '<br />' . oos_image(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' ' . oos_get_newsfeed_description($nInfo->newsfeed_id, $languages[$i]['id']);
}
$contents[] = array('text' => '<br />' . TEXT_RSS_NAME . $newsfeed_inputs_name_string);
$contents[] = array('text' => '<br />' . TEXT_RSS_TITLE . $newsfeed_inputs_title_string);
$contents[] = array('text' => '<br />' . TEXT_RSS_DESCRIPTION . $newsfeed_inputs_description_string);
$contents[] = array('text' => '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($nInfo->date_added));
if (oos_is_not_null($nInfo->last_modified)) {
$contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . oos_date_short($nInfo->last_modified));
$sort_order_drop_array[] = array('id' => $i, 'text' => $i);
}
$products_result = $dbconn->Execute($products_result_raw);
while ($products = $products_result->fields) {
?>
<tr bgcolor='#DFE4F4'>
<td class="dataTableContent" align="center"> <?php
echo $products['products_id'];
?>
</td>
<td class="dataTableContent" align="center"> <?php
echo $products['products_model'];
?>
</td>
<td class="dataTableContent" align="center"> <?php
echo oos_info_image($products_name['products_image'], $products_name['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);
?>
</td>
<td class="dataTableContent" align="center"> <?php
echo $products['products_name'];
?>
</td>
<td class="dataTableContent" align="center"> <?php
echo $currencies->format($products['products_price']);
?>
</td>
<td class="dataTableContent" align="center"> <?php
echo oos_draw_pull_down_menu($products['products_id'], $sort_order_drop_array, $products['sort_order']);
?>
</td>
</tr>
AND up.products_id = '" . $_GET['add_related_product_ID'] . "'
AND p.products_id = pd.products_id
AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "'
ORDER BY up.sort_order asc";
$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_result_raw, $products_result_numrows);
$sort_order_drop_array = array();
for ($i = 1; $i <= $products_result_numrows; $i++) {
$sort_order_drop_array[] = array('id' => $i, 'text' => $i);
}
$products_result = $dbconn->Execute($products_result_raw);
while ($products = $products_result->fields) {
?>
<tr bgcolor='#DFE4F4'>
<td class="dataTableContent" align="center"> <?php echo $products['products_id'];?> </td>
<td class="dataTableContent" align="center"> <?php echo $products['products_model'];?> </td>
<td class="dataTableContent" align="center"> <?php echo oos_info_image($products_name['products_image'], $products_name['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);?> </td>
<td class="dataTableContent" align="center"> <?php echo $products['products_name'];?> </td>
<td class="dataTableContent" align="center"> <?php echo $currencies->format($products['products_price']);?> </td>
<td class="dataTableContent" align="center"> <?php echo oos_draw_pull_down_menu($products['products_id'], $sort_order_drop_array, $products['sort_order']);?> </td>
</tr>
<?php
// Move that ADOdb pointer!
$products_result->MoveNext();
}
// Close result set
$products_result->Close();
?>
</table></form></td>
</tr>
<tr>
<td colspan="6"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="infoBoxContent">
