<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php
echo ADDING_TITLE;
?>
#<?php
echo $oID;
?>
</td>
<td class="pageHeading" align="right"><?php
echo oos_draw_separator('trans.gif', 1, HEADING_IMAGE_HEIGHT);
?>
</td>
<td class="pageHeading" align="right"><?php
echo '<a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('action'))) . '">' . oos_image_swap_button('back', 'back_off.gif', IMAGE_BACK) . '</a>';
?>
</td>
</tr>
</table></td>
</tr>
<?php
//$result = $dbconn->Execute("SELECT products_name, p.products_id, cd.categories_name, ptc.categories_id FROM " . $oostable['products'] . " p LEFT JOIN " . $oostable['products_description'] . " pd ON pd.products_id=p.products_id LEFT JOIN " . $oostable['products_to_categories'] . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . $oostable['categories_description'] . " cd ON cd.categories_id=ptc.categories_id LEFT JOIN " . $oostable['categories_description'] . " x ON x.categories_name=cd.categories_name ORDER BY categories_id");
$result = $dbconn->Execute("SELECT products_name, p.products_id, cd.categories_name, ptc.categories_id FROM " . $oostable['products'] . " p LEFT JOIN " . $oostable['products_description'] . " pd ON pd.products_id=p.products_id LEFT JOIN " . $oostable['products_to_categories'] . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . $oostable['categories_description'] . " cd ON cd.categories_id=ptc.categories_id ORDER BY categories_id");
while ($row = $result->fields) {
extract($row, EXTR_PREFIX_ALL, "db");
$ProductList[$db_categories_id][$db_products_id] = $db_products_name;
$CategoryList[$db_categories_id] = $db_categories_name;
$LastCategory = $db_categories_name;
// Move that ADOdb pointer!
$contents = array();
switch ($action) {
case 'slave_products':
$heading[] = array('text' => '<b>' . oos_get_products_name($pInfo->products_id, $_SESSION['language_id']) . '</b>');
$contents = array('form' => oos_draw_form('new_slave_product', $aFilename['categories'], 'action=new_slave_product&categories=' . $categories . '&pID=' . $pInfo->products_id, 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => '<br />' . TEXT_ADD_SLAVE_PRODUCT . '<br />' . oos_draw_input_field('slave_product_id', '', 'size="10"'));
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('save', 'save_off.gif', IMAGE_SAVE) . ' <a href="' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&pID=' . $pInfo->products_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_CURRENT_SLAVE_PRODUCTS);
$slave_table_result = $dbconn->Execute("SELECT p2m.master_id, p2m.slave_id FROM " . $oostable['products_to_master'] . " p2m WHERE master_id = '" . $pInfo->products_id . "'");
while ($slave_table = $slave_table_result->fields) {
$slave_products_result = $dbconn->Execute("SELECT p.products_id, p.products_slave_visible, pd.products_name FROM " . $oostable['products'] . " p , " . $oostable['products_description'] . " pd WHERE p.products_id = pd.products_id AND p.products_id = '" . $slave_table['slave_id'] . "' AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY pd.products_name LIMIT 1");
$slave_products = $slave_products_result->fields;
if ($slave_products['products_slave_visible'] == 1) {
$contents[] = array('text' => ' ' . $slave_products['products_name'] . ' ' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action', 'pID')) . 'slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_delete') . '">' . oos_image(OOS_IMAGES . 'delete_slave_off.gif', 'Delete Slave') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action')) . 'visible=0&slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_visible') . '">' . oos_image(OOS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_RED_LIGHT) . '</a>');
} else {
$contents[] = array('text' => ' ' . $slave_products['products_name'] . ' ' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action', 'pID')) . 'slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_delete') . '">' . oos_image(OOS_IMAGES . 'delete_slave_off.gif', 'Delete Slave') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action')) . 'visible=1&slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_visible') . '">' . oos_image(OOS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_GREEN_LIGHT) . '</a>');
}
// Move that ADOdb pointer!
$slave_table_result->MoveNext();
}
break;
case 'new_category':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_CATEGORY . '</b>');
$contents = array('form' => oos_draw_form('newcategory', $aFilename['categories'], 'action=insert_category&categories=' . $categories, 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => TEXT_NEW_CATEGORY_INTRO);
$category_inputs_string = '';
$languages = oos_get_languages();
for ($i = 0, $n = count($languages); $i < $n; $i++) {
$category_inputs_string .= '<br />' . oos_image(OOS_SHOP_IMAGES . 'flags/' . $languages[$i]['iso_639_2'] . '.gif', $languages[$i]['name']) . ' ' . oos_draw_input_field('categories_name[' . $languages[$i]['id'] . ']');
}
$contents[] = array('text' => '<br />' . TEXT_CATEGORIES_NAME . $category_inputs_string);
File: gv_admin.php,v 1.2.2.1 2003/04/18 21:13:51 wilt
----------------------------------------------------------------------
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2002 - 2003 osCommerce
Gift Voucher System v1.0
Copyright (c) 2001,2002 Ian C Wilson
http://www.phesis.org
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- gv_admin //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_GV_ADMIN, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=gv_admin'));
if ($_SESSION['selected_box'] == 'gv_admin') {
$contents[] = array('text' => oos_admin_files_boxes('coupon_admin', BOX_COUPON_ADMIN) . oos_admin_files_boxes('gv_queue', BOX_GV_ADMIN_QUEUE) . oos_admin_files_boxes('gv_mail', BOX_GV_ADMIN_MAIL) . oos_admin_files_boxes('gv_sent', BOX_GV_ADMIN_SENT));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- gv_admin_eof //-->
Copyright (c) 2003 - 2007 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
File: customers.php,v 1.15 2002/03/16 00:20:11 hpdl
----------------------------------------------------------------------
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- customers //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_CUSTOMERS, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=customers'));
if ($_SESSION['selected_box'] == 'customers' || $menu_dhtml == true) {
$contents[] = array('text' => oos_admin_files_boxes('customers', BOX_CUSTOMERS_CUSTOMERS) . oos_admin_files_boxes('orders', BOX_CUSTOMERS_ORDERS) . oos_admin_files_boxes('customers_points', BOX_CUSTOMERS_POINTS) . oos_admin_files_boxes('customers_points_pending', BOX_CUSTOMERS_POINTS_PENDING) . oos_admin_files_boxes('export_stampit', BOX_CUSTOMERS_EXPORT_STAMPIT) . oos_admin_files_boxes('customers_status', BOX_LOCALIZATION_CUSTOMERS_STATUS) . oos_admin_files_boxes('orders_status', BOX_LOCALIZATION_ORDERS_STATUS) . oos_admin_files_boxes('campaigns', BOX_CAMPAIGNS) . oos_admin_files_boxes('manual_loging', BOX_ADMIN_LOGIN));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- customers_eof //-->
$featuredtable = $oostable['featured'];
$productstable = $oostable['products'];
$featured_result = $dbconn->Execute("SELECT p.products_id FROM $productstable p, $featuredtable f WHERE f.products_id = p.products_id");
while ($featured = $featured_result->fields) {
$featured_array[] = $featured['products_id'];
// Move that ADOdb pointer!
$featured_result->MoveNext();
}
// Close result set
$featured_result->Close();
}
?>
<tr><form name="new_feature" <?php echo 'action="' . oos_href_link_admin($aFilename['featured'], oos_get_all_get_params(array('action', 'info', 'fID')) . 'action=' . $form_action, 'NONSSL') . '"'; ?> method="post">
<?php
if ($form_action == 'update') {
echo oos_draw_hidden_field('featured_id', $_GET['fID']);
} elseif (isset($_GET['pID']) ) {
echo oos_draw_hidden_field('products_id', $sInfo->products_id);
}
?>
<td><br /><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo TEXT_FEATURED_PRODUCT; ?> </td>
<td class="main"><?php echo ($sInfo->products_name) ? $sInfo->products_name : oos_draw_products_pull_down('products_id', 'style="font-size:10px"', $featured_array); echo oos_draw_hidden_field('products_price', $sInfo->products_price); ?></td>
</tr>
<tr>
<td class="main"><?php echo TEXT_FEATURED_EXPIRES_DATE; ?> </td>
<td class="main"><?php echo oos_draw_input_field('day', substr($sInfo->expires_date, 8, 2), 'size="2" maxlength="2" class="cal-TextBox"') . oos_draw_input_field('month', substr($sInfo->expires_date, 5, 2), 'size="2" maxlength="2" class="cal-TextBox"') . oos_draw_input_field('year', substr($sInfo->expires_date, 0, 4), 'size="4" maxlength="4" class="cal-TextBox"'); ?><a class="so-BtnLink" href="javascript:calClick();return false;" onMouseOver="calSwapImg('BTN_date', 'img_Date_OVER',true);" onMouseOut="calSwapImg('BTN_date', 'img_Date_UP',true);" onClick="calSwapImg('BTN_date', 'img_Date_DOWN');showCalendar('new_feature','dteWhen','BTN_date');return false;"><?php echo oos_image(OOS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"'); ?></a></td>
http://www.oos-shop.de/
Copyright (c) 2003 - 2009 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- content //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_CONTENT, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=content'));
if ($_SESSION['selected_box'] == 'content') {
$contents[] = array('text' => oos_admin_files_boxes('content_block', BOX_CONTENT_BLOCK) . oos_admin_files_boxes('content_page_type', BOX_CONTENT_PAGE_TYPE));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- content_eof //-->
$cc_result_raw = "SELECT\n coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,\n coupon_expire_date, uses_per_user, uses_per_coupon, restrict_to_products,\n restrict_to_categories, date_created,date_modified\n FROM\n " . $oostable['coupons'] . "\n WHERE\n coupon_type != 'G'";
}
$cc_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_result_raw, $cc_result_numrows);
$cc_result = $dbconn->Execute($cc_result_raw);
while ($cc_list = $cc_result->fields) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
if ((!isset($_GET['cID']) || isset($_GET['cID']) && $_GET['cID'] == $cc_list['coupon_id']) && !isset($cInfo)) {
$cInfo = new objectInfo($cc_list);
}
if (isset($cInfo) && is_object($cInfo) && $cc_list['coupon_id'] == $cInfo->coupon_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['coupon_admin'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->coupon_id . '&action=edit') . '\'">' . "\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['coupon_admin'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cc_list['coupon_id']) . '\'">' . "\n";
}
$coupon_description_result = $dbconn->Execute("SELECT coupon_name\n FROM " . $oostable['coupons_description'] . "\n WHERE coupon_id = '" . $cc_list['coupon_id'] . "'\n AND coupon_languages_id = '" . intval($_SESSION['language_id']) . "'");
$coupon_desc = $coupon_description_result->fields;
?>
<td class="dataTableContent"><?php
echo $coupon_desc['coupon_name'];
?>
</td>
<td class="dataTableContent" align="center">
<?php
if ($cc_list['coupon_type'] == 'P') {
echo $cc_list['coupon_amount'] . '%';
} elseif ($cc_list['coupon_type'] == 'S') {
echo TEXT_FREE_SHIPPING;
} else {
$coupon_gv_queuetable = $oostable['coupon_gv_queue'];
$gv_result_raw = "SELECT c.customers_firstname, c.customers_lastname, gv.unique_id,
gv.date_created, gv.amount, gv.order_id
FROM $customerstable c,
$coupon_gv_queuetable gv
WHERE (gv.customer_id = c.customers_id AND gv.release_flag = 'N')";
$gv_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $gv_result_raw, $gv_result_numrows);
$gv_result = $dbconn->Execute($gv_result_raw);
while ($gv_list = $gv_result->fields) {
if ((!isset($_GET['gid']) || (isset($_GET['gid']) && ($_GET['gid'] == $gv_list['unique_id']))) && !isset($gInfo)) {
$gInfo = new objectInfo($gv_list);
}
if (isset($gInfo) && is_object($gInfo) && ($gv_list['unique_id'] == $gInfo->unique_id) ) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin('gv_queue.php', oos_get_all_get_params(array('gid', 'action')) . 'gid=' . $gInfo->unique_id . '&action=edit') . '\'">' . "\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('gv_queue.php', oos_get_all_get_params(array('gid', 'action')) . 'gid=' . $gv_list['unique_id']) . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php echo $gv_list['customers_firstname'] . ' ' . $gv_list['customers_lastname']; ?></td>
<td class="dataTableContent" align="center"><?php echo $gv_list['order_id']; ?></td>
<td class="dataTableContent" align="right"><?php echo $currencies->format($gv_list['amount']); ?></td>
<td class="dataTableContent" align="right"><?php echo oos_datetime_short($gv_list['date_created']); ?></td>
<td class="dataTableContent" align="right"><?php if (isset($gInfo) && is_object($gInfo) && ($gv_list['unique_id'] == $gInfo->unique_id) ) { echo oos_image(OOS_IMAGES . 'icon_arrow_right.gif'); } else { echo '<a href="' . oos_href_link_admin($aFilename['gv_queue'], 'page=' . $_GET['page'] . '&gid=' . $gv_list['unique_id']) . '">' . oos_image(OOS_IMAGES . 'icon_information.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>
</tr>
<?php
// Move that ADOdb pointer!
$gv_result->MoveNext();
}
?>
<tr>
<td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2">
Copyright (c) 2003 - 2007 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
File: taxes.php,v 1.16 2002/03/16 00:20:11 hpdl
----------------------------------------------------------------------
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- taxes //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_LOCATION_AND_TAXES, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=taxes'));
if ($_SESSION['selected_box'] == 'taxes' || $menu_dhtml == true) {
$contents[] = array('text' => oos_admin_files_boxes('countries', BOX_TAXES_COUNTRIES) . oos_admin_files_boxes('zones', BOX_TAXES_ZONES) . oos_admin_files_boxes('geo_zones', BOX_TAXES_GEO_ZONES) . oos_admin_files_boxes('tax_classes', BOX_TAXES_TAX_CLASSES) . oos_admin_files_boxes('tax_rates', BOX_TAXES_TAX_RATES));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- taxes_eof //-->
</tr>
<?php
$whos_onlinetable = $oostable['whos_online'];
$sql = "SELECT customer_id, full_name, ip_address, time_entry,
time_last_click, last_page_url, session_id
FROM $whos_onlinetable";
$whos_online_result = $dbconn->Execute($sql);
while ($whos_online = $whos_online_result->fields) {
$time_online = (time() - $whos_online['time_entry']);
if ((!isset($_GET['info']) || (isset($_GET['info']) && ($_GET['info'] == $whos_online['session_id']))) && !isset($info)) {
$info = $whos_online['session_id'];
}
if ($whos_online['session_id'] == $info) {
echo ' <tr class="dataTableRowSelected">' . "\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['whos_online'], oos_get_all_get_params(array('info', 'action')) . 'info=' . $whos_online['session_id'], 'NONSSL') . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php echo gmdate('H:i:s', $time_online); ?></td>
<td class="dataTableContent" align="center"><?php echo $whos_online['customer_id']; ?></td>
<td class="dataTableContent"><?php echo $whos_online['full_name']; ?></td>
<td class="dataTableContent" align="center"><?php echo $whos_online['ip_address']; ?></td>
<td class="dataTableContent"><?php echo date('H:i:s', $whos_online['time_entry']); ?></td>
<td class="dataTableContent" align="center"><?php echo date('H:i:s', $whos_online['time_last_click']); ?></td>
<td class="dataTableContent"><?php if (preg_match('/^(.*)' . oos_session_name() . '=[a-f,0-9]+[&]*(.*)/', $whos_online['last_page_url'], $array)) { echo $array[1] . $array[2]; } else { echo $whos_online['last_page_url']; } ?> </td>
</tr>
<?php
// Move that ADOdb pointer!
$whos_online_result->MoveNext();
}
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
include 'includes/languages/' . $_SESSION['language'] . '/configuration_group.php';
?>
<!-- configuration //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_CONFIGURATION, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=configuration'));
if ($_SESSION['selected_box'] == 'configuration') {
$cfg_groups = '';
$configuration_groups_result = $dbconn->Execute("SELECT configuration_group_id as cgID FROM " . $oostable['configuration_group'] . " where visible = '1' ORDER BY sort_order");
while ($configuration_groups = $configuration_groups_result->fields) {
$cfg_groups .= '<a href="' . oos_href_link_admin($aFilename['configuration'], 'gID=' . $configuration_groups['cgID'], 'NONSSL') . '" class="menuBoxContentLink">' . constant(strtoupper($configuration_groups['cgID'] . '_TITLE')) . '</a><br />';
// Move that ADOdb pointer!
$configuration_groups_result->MoveNext();
}
$contents[] = array('text' => $cfg_groups);
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
Copyright (c) 2003 - 2009 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
File: localization.php,v 1.15 2002/03/16 00:20:11 hpdl
----------------------------------------------------------------------
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- localization //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_LOCALIZATION, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=localization'));
if ($_SESSION['selected_box'] == 'localization') {
$contents[] = array('text' => oos_admin_files_boxes('currencies', BOX_LOCALIZATION_CURRENCIES) . oos_admin_files_boxes('languages', BOX_LOCALIZATION_LANGUAGES));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- localization_eof //-->
<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">
<tr>
<td class="smallText" valign="top"><?php echo $products_split->display_count($products_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo $products_split->display_links($products_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action'))); ?></td>
</tr>
</table></td>
</tr>
</table>
<?php
}
?>
<!-- body_text_eof //-->
</td>
</tr>
</table>
<!-- body_eof //-->
<?php require 'includes/oos_footer.php'; ?>
<br />
http://www.oos-shop.de/
Copyright (c) 2003 - 2007 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- newsfeed //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_NEWSFEED, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=newsfeed'));
if ($_SESSION['selected_box'] == 'newsfeed' || $menu_dhtml == true) {
$contents[] = array('text' => oos_admin_files_boxes('newsfeed_manager', BOX_NEWSFEED_MANAGER) . oos_admin_files_boxes('newsfeed_categories', BOX_NEWSFEED_CATEGORIES));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- newsfeed_eof //-->
$specials_array = array();
$productstable = $oostable['products'];
$specialstable = $oostable['specials'];
$specials_result = $dbconn->Execute("SELECT p.products_id FROM $productstable p, $specialstable s WHERE s.products_id = p.products_id");
while ($specials = $specials_result->fields) {
$specials_array[] = $specials['products_id'];
// Move that ADOdb pointer!
$specials_result->MoveNext();
}
// Close result set
$specials_result->Close();
}
?>
<tr><form name="new_special" <?php echo 'action="' . oos_href_link_admin($aFilename['specials'], oos_get_all_get_params(array('action', 'info', 'sID')) . 'action=' . $form_action, 'NONSSL') . '"'; ?> method="post"><?php if ($form_action == 'update') echo oos_draw_hidden_field('specials_id', $_GET['sID']); ?>
<td><br /><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php echo TEXT_SPECIALS_PRODUCT; echo ($sInfo->products_name) ? "" : '('.TEXT_TAX_INFO.')'; ?> </td>
<?php
$in_price = $sInfo->products_price;
$in_new_price = $sInfo->specials_new_products_price;
if (OOS_PRICE_IS_BRUTTO == '1'){
$in_price_netto = round($in_price,TAX_DECIMAL_PLACES);
$in_new_price_netto = round($in_new_price,TAX_DECIMAL_PLACES);
$tax_ratestable = $oostable['tax_rates'];
$tax_result = $dbconn->Execute("SELECT tax_rate FROM $tax_ratestable WHERE tax_class_id = '" . $sInfo->products_tax_class_id . "' ");
$tax = $tax_result->fields;
$in_price = ($in_price*($tax[tax_rate]+100)/100);
$in_new_price = ($in_new_price*($tax[tax_rate]+100)/100);
$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">
<tr>
<td class="smallText" valign="top"><?php
echo $products_split->display_count($products_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
?>
</td>
<td class="smallText" align="right"><?php
echo $products_split->display_links($products_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], oos_get_all_get_params(array('page', 'info', 'x', 'y', 'cID', 'action')));
?>
</td>
</tr>
</table></td>
</tr>
</table>
<?php
}
?>
<!-- body_text_eof //-->
</td>
</tr>
</table>
<!-- body_eof //-->
// (when creating a new featured product)
$featured_array = array();
$featuredtable = $oostable['featured'];
$productstable = $oostable['products'];
$featured_result = $dbconn->Execute("SELECT p.products_id FROM {$productstable} p, {$featuredtable} f WHERE f.products_id = p.products_id");
while ($featured = $featured_result->fields) {
$featured_array[] = $featured['products_id'];
// Move that ADOdb pointer!
$featured_result->MoveNext();
}
// Close result set
$featured_result->Close();
}
?>
<tr><form name="new_feature" <?php
echo 'action="' . oos_href_link_admin($aFilename['featured'], oos_get_all_get_params(array('action', 'info', 'fID')) . 'action=' . $form_action, 'NONSSL') . '"';
?>
method="post">
<?php
if ($form_action == 'update') {
echo oos_draw_hidden_field('featured_id', $_GET['fID']);
} elseif (isset($_GET['pID'])) {
echo oos_draw_hidden_field('products_id', $sInfo->products_id);
}
?>
<td><br /><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><?php
echo TEXT_FEATURED_PRODUCT;
?>
</td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($action) {
case 'confirm':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_NEWSFEED . '</b>');
$contents = array('form' => oos_draw_form('newsfeed_manager', $aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO . '<br /><br /><b>' . $nmInfo->newsfeed_manager_firstname . ' ' . $nmInfo->newsfeed_manager_lastname . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($nmInfo) && is_object($nmInfo)) {
$heading[] = array('text' => '<b>' . $nmInfo->newsfeed_manager_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id . '&action=confirm') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_URL . ' ' . $nmInfo->newsfeed_manager_link);
$contents[] = array('text' => '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($nmInfo->newsfeed_manager_date_added));
$contents[] = array('text' => '<br />' . TEXT_LAST_MODIFIED . ' ' . oos_date_short($nmInfo->newsfeed_manager_last_modified));
$contents[] = array('text' => '<br />' . TEXT_CACHE_TIME . ' ' . $nmInfo->newsfeed_manager_refresh);
}
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>
default:
$customer_status = oos_get_customers_status ($cID);
$cs_id = $customer_status['customers_status'];
$cs_name = $customer_status['customers_status_name'];
$cs_image = $customer_status['customers_status_image'];
$cs_discount = $customer_status['customers_status_discount'];
$cs_ot_discount_flag = $customer_status['customers_status_ot_discount_flag'];
$cs_ot_discount = $customer_status['customers_status_ot_discount'];
$cs_qty_discounts = $customer_status['customers_status_qty_discounts'];
$cs_payment = $customer_status['customers_status_payment'];
if (isset($cInfo) && is_object($cInfo)) {
$heading[] = array('text' => '<b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=confirm') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a> <a href="' . oos_href_link_admin($aFilename['orders'], 'cID=' . $cInfo->customers_id) . '">' . oos_image_swap_button('orders', 'orders_off.gif', IMAGE_ORDERS) . '</a> <a href="' . oos_href_link_admin($aFilename['mail'], 'selected_box=tools&customer=' . $cInfo->customers_email_address) . '">' . oos_image_swap_button('email', 'email_off.gif', IMAGE_EMAIL) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_catalog_link($aCatalogPage['wishlist'], 'wlid=' . $cInfo->customers_wishlist_link_id) . '">' . oos_image_swap_button('wishlist', 'wishlist_off.gif', IMAGE_WISHLIST) . '</a> <a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=editstatus') . '">' . oos_image_swap_button('status', 'status_off.gif', IMAGE_STATUS) . '</a>');
$manual_infotable = $oostable['manual_info'];
$sql = "SELECT man_info_id, man_key, status
FROM $manual_infotable
WHERE man_info_id = '1'";
$login_result = $dbconn->Execute($sql);
$login = $login_result->fields;
if ($login['status'] != '0') {
$contents[] = array('align' => 'center', 'text' => oos_draw_login_form('login', $aCatalogPage['login_admin'], 'action=login_admin', 'POST', 'target=_blank') . oos_draw_hidden_field('verif_key', $login['man_key']) . oos_draw_hidden_field('email_address', $cInfo->customers_email_address) . oos_image_swap_submits('login', 'login_off.gif', IMAGE_LOGIN) . '</form>');
}
$contents[] = array('text' => '<br />' . oos_customers_payment($customer_status['customers_status_payment']));
$contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_CREATED . ' ' . oos_date_short($cInfo->date_account_created));
$contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_LAST_MODIFIED . ' ' . oos_date_short($cInfo->date_account_last_modified));
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_LAST_LOGON . ' ' . oos_date_short($cInfo->date_last_logon));
$contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_LOGONS . ' ' . $cInfo->number_of_logons);
Copyright (c) 2003 - 2009 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
File: administrator.php,v 1.20 2002/03/16 00:20:11 hpdl
----------------------------------------------------------------------
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- catalog //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_ADMINISTRATOR, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=administrator'));
if ($_SESSION['selected_box'] == 'administrator') {
$contents[] = array('text' => oos_admin_files_boxes('admin_members', BOX_ADMINISTRATOR_MEMBERS) . oos_admin_files_boxes('admin_files', BOX_ADMINISTRATOR_BOXES));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- catalog_eof //-->
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- tickets //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_TICKET,
'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=ticket'));
if ($_SESSION['selected_box'] == 'ticket') {
$contents[] = array('text' => oos_admin_files_boxes('ticket_view', BOX_TICKET_VIEW) .
oos_admin_files_boxes('ticket_reply', BOX_TEXT_REPLY) .
oos_admin_files_boxes('ticket_admin', BOX_TEXT_ADMIN) .
oos_admin_files_boxes('ticket_department', BOX_TEXT_DEPARTMENT) .
oos_admin_files_boxes('ticket_status', BOX_TEXT_STATUS) .
oos_admin_files_boxes('ticket_priority', BOX_TEXT_PRIORITY));
}
$box = new box;
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($action) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>');
$contents = array('form' => oos_draw_form('orders', $aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br /><br /><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($oInfo) && is_object($oInfo)) {
$heading[] = array('text' => '<b>[' . $oInfo->orders_id . '] ' . oos_datetime_short($oInfo->date_purchased) . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['invoice'], 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . oos_image_swap_button('invoice', 'invoice_off.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . oos_href_link_admin($aFilename['packingslip'], 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . oos_image_swap_button('packingslip', 'packingslip_off.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_DATE_ORDER_CREATED . ' ' . oos_date_short($oInfo->date_purchased));
if (oos_is_not_null($oInfo->last_modified)) {
$contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . oos_date_short($oInfo->last_modified));
}
$contents[] = array('text' => '<br />' . TEXT_INFO_PAYMENT_METHOD . ' ' . $oInfo->payment_method);
}
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";
}
<?php
/* ----------------------------------------------------------------------
$Id$
OOS [OSIS Online Shop]
http://www.oos-shop.de/
Copyright (c) 2003 - 2009 by the OOS Development Team.
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
?>
<!-- plugins //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_PLUGINS, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=plugins'));
if ($_SESSION['selected_box'] == 'plugins') {
$contents[] = array('text' => '<a href="' . oos_href_link_admin($aFilename['plugins'], '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_PLUGINS_EVENT . '</a>');
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- plugins_eof //-->
$contents = array('form' => oos_draw_form('new_slave_product', $aFilename['categories'], 'action=new_slave_product&categories=' . $categories . '&pID=' . $pInfo->products_id, 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => '<br />' . TEXT_ADD_SLAVE_PRODUCT . '<br />' . oos_draw_input_field('slave_product_id', '', 'size="10"'));
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('save', 'save_off.gif', IMAGE_SAVE) . ' <a href="' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&pID=' . $pInfo->products_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_CURRENT_SLAVE_PRODUCTS);
$slave_table_result = $dbconn->Execute("SELECT p2m.master_id, p2m.slave_id FROM " . $oostable['products_to_master'] . " p2m WHERE master_id = '" . $pInfo->products_id . "'");
while ($slave_table = $slave_table_result->fields){
$slave_products_result = $dbconn->Execute("SELECT p.products_id, p.products_slave_visible, pd.products_name FROM " . $oostable['products'] . " p , " . $oostable['products_description'] . " pd WHERE p.products_id = pd.products_id AND p.products_id = '" . $slave_table['slave_id'] . "' AND pd.products_languages_id = '" . intval($_SESSION['language_id']) . "' ORDER BY pd.products_name LIMIT 1");
$slave_products = $slave_products_result->fields;
if($slave_products['products_slave_visible'] == 1){
$contents[] = array('text' => ' ' . $slave_products['products_name'] . ' ' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action', 'pID')) . 'slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_delete') . '">' . oos_image(OOS_IMAGES . 'delete_slave_off.gif', 'Delete Slave') . '</a>'.
'<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action')) . 'visible=0&slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_visible') . '">'.
oos_image(OOS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_RED_LIGHT) . '</a>');
} else {
$contents[] = array('text' => ' ' . $slave_products['products_name'] . ' ' . '<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action', 'pID')) . 'slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_delete') . '">' . oos_image(OOS_IMAGES . 'delete_slave_off.gif', 'Delete Slave') . '</a>'.
'<a href="' . oos_href_link_admin($aFilename['categories'], oos_get_all_get_params(array('action')) . 'visible=1&slave_id=' . $slave_table['slave_id'] . '&master_id=' . $pInfo->products_id . '&action=slave_visible') . '">'.
oos_image(OOS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_GREEN_LIGHT) . '</a>');
}
// Move that ADOdb pointer!
$slave_table_result->MoveNext();
}
break;
case 'new_category':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_CATEGORY . '</b>');
$contents = array('form' => oos_draw_form('newcategory', $aFilename['categories'], 'action=insert_category&categories=' . $categories, 'post', 'enctype="multipart/form-data"'));
$contents[] = array('text' => TEXT_NEW_CATEGORY_INTRO);
$category_inputs_string = '';
$languages = oos_get_languages();
