function confirm()
{
// Get database information
$dbconn =& oosDBGetConn();
$oostable =& oosDBGetTables();
$aFilename = oos_get_filename();
$mail_result1 = $dbconn->Execute("SELECT COUNT(*) AS total FROM " . $oostable['customers'] . " WHERE customers_newsletter = '1'");
$mail_result2 = $dbconn->Execute("SELECT COUNT(*) AS total FROM " . $oostable['maillist'] . " WHERE customers_newsletter = '1'");
$mail1 = $mail_result1->fields;
$mail2 = $mail_result2->fields;
$mail['total'] = $mail1['total'] + $mail2['total'];
$confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "\n" . ' <tr>' . "\n" . ' <td class="main"><font color="#ff0000"><b>' . sprintf(TEXT_COUNT_CUSTOMERS, $mail['total']) . '</b></font></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td>' . oos_draw_separator('trans.gif', '1', '10') . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="main"><b>' . $this->title . '</b></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td>' . oos_draw_separator('trans.gif', '1', '10') . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="main"><tt>' . nl2br($this->content) . '</tt></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td>' . oos_draw_separator('trans.gif', '1', '10') . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td align="right"><a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID'] . '&action=confirm_send') . '">' . oos_image_button('send_off.gif', IMAGE_SEND) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID']) . '">' . oos_image_button('cancel_off.gif', IMAGE_CANCEL) . '</a></td>' . "\n" . ' </tr>' . "\n" . '</table>';
return $confirm_string;
}
function oos_admin_files_boxes($filename, $sub_box_name)
{
$sub_boxes = '';
// Get database information
$dbconn =& oosDBGetConn();
$oostable =& oosDBGetTables();
$aFilename = oos_get_filename();
$admin_filestable = $oostable['admin_files'];
$query = "SELECT admin_files_name\n FROM {$admin_filestable}\n WHERE FIND_IN_SET( '" . $_SESSION['login_groups_id'] . "', admin_groups_id)\n AND admin_files_is_boxes = '0'\n AND admin_files_name = '" . $filename . "'";
$result =& $dbconn->Execute($query);
if ($result->RecordCount()) {
$sub_boxes = '<a href="' . oos_href_link_admin($aFilename[$filename]) . '" class="menuBoxContentLink">' . $sub_box_name . '</a><br />';
}
// Close result set
$result->Close();
return $sub_boxes;
}
<td colspan="3" class="smallText"><?php echo $system['uptime']; ?></td>
</tr>
<tr>
<td colspan="4"><?php echo oos_draw_separator('trans.gif', '1', '5'); ?></td>
</tr>
<tr>
<td class="smallText"><b><?php echo TITLE_SYSTEM; ?></b></td>
<td colspan="3" class="smallText"><?php echo php_uname(); ?></td>
</tr>
<tr>
<td class="smallText"><b><?php echo TITLE_HTTP_SERVER; ?></b></td>
<td colspan="3" class="smallText"><?php echo $system['HTTP_SERVER']; ?></td>
</tr>
<tr>
<td class="smallText"><b><?php echo TITLE_PHP_VERSION; ?></b></td>
<td colspan="3" class="smallText"><?php echo $system['php'] . ' (' . TITLE_ZEND_VERSION . ' ' . $system['zend'] . ') » » <a href="' . oos_href_link_admin($aFilename['php_info'], '', 'NONSSL') . '" target="_blank">' . TITLE_PHP_INFORMATION . '</a>'; ?></td>
</tr>
<tr>
<td class="smallText"><b>ADODB Version</b></td>
<td colspan="3" class="smallText"><?php echo $ADODB_vers; ?></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
</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']);
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
if (isset($pInfo) && is_object($pInfo)) {
$heading[] = array('text' => '<b>' . $pInfo->products_name . '</b>');
$categories = oos_get_product_path($pInfo->products_id);
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['categories'], 'pID=' . $pInfo->products_id . '&categories=' . $categories . '&action=new_product') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_EXPECTED . ' ' . oos_date_short($pInfo->products_date_available));
}
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>
<!-- body_text_eof //-->
</tr>
AND pd.products_languages_id = '" . intval($_SESSION['language_id']). "'
AND p.products_quantity <= p.products_reorder_level
GROUP BY pd.products_id
ORDER BY pd.products_name ASC";
$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_result_raw, $products_result_numrows);
$products_result = $dbconn->Execute($products_result_raw);
while ($products = $products_result->fields) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
?>
<tr class="datatableRow" onmouseover="this.className='datatableRowOver';this.style.cursor='hand'" onmouseout="this.className='datatableRow'" onclick="document.location.href='<?php echo oos_href_link_admin($aFilename['products'], 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . $aFilename['stats_products_viewed'] . '?page=' . $_GET['page'], 'NONSSL'); ?>'">
<td align="left" class="smallText"> <?php echo $rows; ?>. </td>
<td class="smallText"> <?php echo '<a href="' . oos_href_link_admin($aFilename['products'], 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . $aFilename['stats_low_stock'] . '?page=' . $_GET['page'], 'NONSSL') . '" class="blacklink">' . $products['products_name'] . '</a>'; ?> </td>
<td align="right" class="smallText"> <?php echo $products['products_quantity']; ?> </td>
</tr>
<?php
// Move that ADOdb pointer!
$products_result->MoveNext();
}
// Close result set
$products_result->Close();
?>
</table></td>
</tr>
<tr>
<td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
$sql1 = "SELECT c.customers_firstname, c.customers_lastname FROM {$customerstable} c WHERE c.customers_id = '" . $cid . "'";
$result1 = $dbconn->Execute($sql1);
$crec = $result1->fields;
// Query DB for the FIRST order that matches this customer ID and came after the abandoned cart
$orderstable = $oostable['orders'];
$orders_totaltable = $oostable['orders_total'];
$orders_statustable = $oostable['orders_status'];
$orders_sql = "SELECT o.orders_id, o.customers_id, o.date_purchased,\n s.orders_status_name, ot.text as order_total, ot.value\n FROM {$orderstable} o\n LEFT JOIN {$orders_totaltable} ot ON (o.orders_id = ot.orders_id),\n {$orders_statustable} s\n WHERE (o.customers_id = '" . (int) $cid . "'\n OR o.customers_email_address like '" . $crec['customers_email_address'] . "'\n OR o.customers_name like '" . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . "')\n AND o.orders_status > " . RCS_PENDING_SALE_STATUS . "\n AND o.orders_status = s.orders_status_id\n AND o.date_purchased >= '" . $inrec['recovercartsales_date_added'] . "'\n AND ot.class = 'ot_total'";
$orders_result = $dbconn->Execute($orders_sql);
$orders = $orders_result->fields;
// If we got a match, create the table entry to display the information
if (isset($orders) && !empty($orders)) {
$custknt++;
$total_recovered += $orders['value'];
$custknt % 2 ? $class = RCS_REPORT_EVEN_STYLE : ($class = RCS_REPORT_ODD_STYLE);
$custlist .= '<tr class="' . $class . '">' . '<td class="datatablecontent" align="right">' . $inrec['recovercartsales_id'] . '</td>' . '<td> </td>' . '<td class="datatablecontent" align="center">' . oos_date_order_stat($inrec['recovercartsales_date_added']) . '</td>' . '<td> </td>' . '<td class="datatablecontent"><a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $crec['customers_lastname'], 'NONSSL') . '">' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '</a></td>' . '<td class="datatablecontent">' . oos_date_short($orders['date_purchased']) . '</td>' . '<td class="datatablecontent" align="center">' . $orders['orders_status_name'] . '</td>' . '<td class="datatablecontent" align="right">' . strip_tags($orders['order_total']) . '</td>' . '<td> </td>' . '</tr>';
}
// Move that ADOdb pointer!
$result->MoveNext();
}
// Close result set
$result->Close();
$cline = "<tr><td height=\"15\" COLSPAN=8> </td></tr>" . "<tr>" . "<td align=right COLSPAN=3 class=main><b>" . TOTAL_RECORDS . "</b></td>" . "<td> </td>" . "<td align=left COLSPAN=5 class=main>" . $rc_cnt . "</td>" . "</tr>" . "<tr>" . "<td align=right COLSPAN=3 class=main><b>" . TOTAL_SALES . "</b></td>" . "<td> </td>" . "<td align=left COLSPAN=5 class=main>" . $custknt . TOTAL_SALES_EXPLANATION . " </td>" . "</tr>" . "<tr><td height=\"12\" COLSPAN=6> </td></tr>";
echo $cline;
?>
<tr class="dataTableHeadingRow"> <!-- Header -->
<td width="7%" class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_SCART_ID;
?>
</td>
<td width="1%" class="dataTableHeadingContent"> </td>
<?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 //-->
/* Re-Post all POST'ed variables */
reset($_POST);
while (list($key, $value) = each($_POST)) {
if (!is_array($_POST[$key])) {
echo oos_draw_hidden_field($key, htmlspecialchars(stripslashes($value)));
}
}
?>
<table border="0" width="100%" cellpadding="0" cellspacing="2">
<tr>
<td><?php
echo oos_image_swap_submits('back', 'back_off.gif', IMAGE_BACK, 'name="back"');
?>
</td>
<td align="right"><?php
echo '<a href="' . oos_href_link_admin($aFilename['gv_mail']) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a> ' . oos_image_swap_submits('send_mail', 'send_mail_off.gif', IMAGE_SEND_EMAIL);
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</form></tr>
<?php
} else {
?>
<tr><?php
echo oos_draw_form('mail', $aFilename['gv_mail'], 'action=preview');
?>
<td><table border="0" cellpadding="0" cellspacing="2">
<tr>
$contents = array();
switch ($action) {
case 'delete':
$heading[] = array('text' => '<b>' . $nInfo->title . '</b>');
$contents = array('form' => oos_draw_form('newsletters', $aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $nInfo->title . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID']) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($nInfo) && is_object($nInfo)) {
$heading[] = array('text' => '<b>' . $nInfo->title . '</b>');
if ($nInfo->locked > 0) {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=new') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . oos_image_swap_button('preview', 'preview_off.gif', IMAGE_PREVIEW) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=send') . '">' . oos_image_swap_button('send', 'send_off.gif', IMAGE_SEND) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=unlock') . '">' . oos_image_swap_button('unlock', 'unlock_off.gif', IMAGE_UNLOCK) . '</a>');
} else {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . oos_image_swap_button('preview', 'preview_off.gif', IMAGE_PREVIEW) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=lock') . '">' . oos_image_swap_button('lock', 'lock_off.gif', IMAGE_LOCK) . '</a>');
}
$contents[] = array('text' => '<br />' . TEXT_NEWSLETTER_DATE_ADDED . ' ' . oos_date_short($nInfo->date_added));
if ($nInfo->status == '1') {
$contents[] = array('text' => TEXT_NEWSLETTER_DATE_SENT . ' ' . oos_date_short($nInfo->date_sent));
}
}
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";
}
?>
function confirm()
{
$audience = array();
// Get database information
$dbconn =& oosDBGetConn();
$oostable =& oosDBGetTables();
$aFilename = oos_get_filename();
if ($_GET['global'] == 'true') {
$products_result = $dbconn->Execute("SELECT distinct customers_id FROM " . $oostable['products_notifications']);
while ($products = $products_result->fields) {
$audience[$products['customers_id']] = '1';
// Move that ADOdb pointer!
$products_result->MoveNext();
}
$customers_result = $dbconn->Execute("SELECT customers_info_id FROM " . $oostable['customers_info'] . " WHERE global_product_notifications = '1'");
while ($customers = $customers_result->fields) {
$audience[$customers['customers_info_id']] = '1';
// Move that ADOdb pointer!
$customers_result->MoveNext();
}
} else {
$chosen = $_POST['chosen'];
$ids = implode(',', $chosen);
$products_result = $dbconn->Execute("SELECT DISTINCT customers_id FROM " . $oostable['products_notifications'] . " WHERE products_id in (" . $ids . ")");
while ($products = $products_result->fields) {
$audience[$products['customers_id']] = '1';
$products_result->MoveNext();
}
$customers_result = $dbconn->Execute("SELECT customers_info_id FROM " . $oostable['customers_info'] . " WHERE global_product_notifications = '1'");
while ($customers = $customers_result->fields) {
$audience[$customers['customers_info_id']] = '1';
// Move that ADOdb pointer!
$customers_result->MoveNext();
}
}
$confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "\n" . ' <tr>' . "\n" . ' <td class="main"><font color="#ff0000"><b>' . sprintf(TEXT_COUNT_CUSTOMERS, count($audience)) . '</b></font></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td>' . oos_draw_separator('trans.gif', '1', '10') . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="main"><b>' . $this->title . '</b></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td>' . oos_draw_separator('trans.gif', '1', '10') . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td class="main"><tt>' . nl2br($this->content) . '</tt></td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <td>' . oos_draw_separator('trans.gif', '1', '10') . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . oos_draw_form('confirm', $aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID'] . '&action=confirm_send') . "\n" . ' <td align="right">';
if (count($audience) > 0) {
if ($_GET['global'] == 'true') {
$confirm_string .= oos_draw_hidden_field('global', 'true');
} else {
for ($i = 0, $n = count($chosen); $i < $n; $i++) {
$confirm_string .= oos_draw_hidden_field('chosen[]', $chosen[$i]);
}
}
$confirm_string .= oos_image_submit('send.gif', IMAGE_SEND) . ' ';
}
$confirm_string .= '<a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID'] . '&action=send') . '">' . oos_image_button('back.gif', IMAGE_BACK) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID']) . '">' . oos_image_button('cancel_off.gif', IMAGE_CANCEL) . '</a></td>' . "\n" . ' </tr>' . "\n" . '</table>';
return $confirm_string;
}
if ($no_js_general == '1') {
?>
<link rel="StyleSheet" href="includes/stylesheet.css" type="text/css" >
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<?php
} else {
?>
<script type="text/javascript" src="includes/general.js"></script>
<link rel="StyleSheet" href="includes/stylesheet.css" type="text/css" >
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<?php
}
?>
<?php
if ($messageStack->size > 0) {
echo $messageStack->output();
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td align="right"><?php echo '<a href="http://www.oos-shop.de/" target="_blank">' . oos_image(OOS_IMAGES . 'support.png', HEADER_TITLE_SUPPORT_SITE, '50', '50') . '</a> <a href="' . oos_catalog_link($aCatalogPage['default']) . '">' . oos_image(OOS_IMAGES . 'checkout.png', HEADER_TITLE_ONLINE_CATALOG, '50', '50') . '</a> <a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '">' . oos_image(OOS_IMAGES . 'administration.png', HEADER_TITLE_ADMINISTRATION, '50', '50') . '</a>'; ?> </td>
</tr>
<tr class="headerBar">
<td class="headerBarContent"> <?php if (isset($_SESSION['login_id'])) { echo '<a href="' . oos_href_link_admin($aFilename['admin_account'], '', 'SSL') . '" class="headerLink">' . HEADER_TITLE_ACCOUNT . '</a> | <a href="' . oos_href_link_admin($aFilename['logoff'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_LOGOFF . '</a>'; } else { echo '<a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_TOP . '</a>'; }?></td>
<td class="headerBarContent" align="right"><?php echo '<a href="http://www.oos-shop.de/" class="headerLink">' . HEADER_TITLE_SUPPORT_SITE . '</a> | <a href="' . oos_catalog_link($aCatalogPage['default']) . '" class="headerLink">' . HEADER_TITLE_ONLINE_CATALOG . '</a> | <a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_ADMINISTRATION . '</a>'; ?> </td>
</tr>
</table>
<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!
while ($products = $products_result->fields) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
?>
<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='<?php
echo oos_href_link_admin($aFilename['products'], 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . $aFilename['stats_products_purchased'] . '?page=' . $_GET['page'], 'NONSSL');
?>
'">
<td class="dataTableContent"><?php
echo $rows;
?>
.</td>
<td class="dataTableContent"><?php
echo '<a href="' . oos_href_link_admin($aFilename['products'], 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . $aFilename['stats_products_purchased'] . '?page=' . $_GET['page'], 'NONSSL') . '">' . $products['products_name'] . '</a>';
?>
</td>
<td class="dataTableContent" align="center"><?php
echo $products['products_ordered'];
?>
</td>
</tr>
<?php
// Move that ADOdb pointer!
$products_result->MoveNext();
}
// Close result set
$products_result->Close();
?>
</table></td>
<div><img src="./captcha.php" alt="CAPTCHA"></div>
<div class="inputlabel"><?php
echo SECURITYCODE;
?>
</div>
<div><?php
echo oos_draw_input_field('captchastring', '', 'class="inputbox" size="15"');
?>
</div>
<?php
}
?>
<div align="left"><input type="submit" name="submit" class="button" value="Login" /></div>
<div class="ctr"><a href="<?php
echo oos_href_link_admin($aFilename['password_forgotten'], '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN;
?>
</a></div>
</div>
</form>
</div>
<div class="login-text">
<div class="ctr"><img src="images/security.gif" width="64" height="64" alt="security" /></div>
<p><?php
echo TEXT_WELCOME;
?>
</p>
// Move that ADOdb pointer!
$attrib_result->MoveNext();
}
}
}
// END OF ATTRIBUTE DB CODE
$tprice = $tprice + ($inrec['qty'] * $sprice);
$pprice_formated = $currencies->format($sprice);
$tpprice_formated = $currencies->format(($inrec['qty'] * $sprice));
$cline = '<tr class="dataTableRow">
<td class="dataTableContent" align="left" vAlign="top" colspan="2" width="12%" nowrap> </td>
<td class="dataTableContent" align="left" vAlign="top" width="13%" nowrap>' . $inrec6['model'] . '</td>
<td class="dataTableContent" align="left" vAlign="top" colspan="2" width="55%"><a href="' . oos_href_link_admin($aFilename['products'], 'action=new_product_preview&read=only&pID=' . $inrec['pid'] . '&origin=' . $aFilename['recover_cart_sales'] . '?page=' . (int)$_GET['page'], 'NONSSL') . '"><b>' . $inrec6['name'] . '</b></a>
' . $prodAttribs . '
</td>
<td class="dataTableContent" align="center" vAlign="top" width="5%" nowrap>' . $inrec['qty'] . '</td>
<td class="dataTableContent" align="right" vAlign="top" width="5%" nowrap>' . $pprice_formated . '</td>
<td class="dataTableContent" align="right" vAlign="top" width="10%" nowrap>' . $tpprice_formated . '</td>
</tr>';
echo $cline;
}
$curcus = '';
// Move that ADOdb pointer!
$result->MoveNext();
}
$contents = array('form' => oos_draw_form('make_file_now', $aFilename['export_googlebase'], 'action=make_file_now'));
$contents[] = array('text' => TEXT_INFO_NEW_INFO);
$contents[] = array('text' => '<br />');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('backup', 'backup_off.gif', IMAGE_BACKUP) . ' <a href="' . oos_href_link_admin($aFilename['export_googlebase'], '') . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
case 'delete':
$heading[] = array('text' => '<b>' . $buInfo->date . '</b>');
$contents = array('form' => oos_draw_form('delete', $aFilename['export_googlebase'], 'file=' . $buInfo->file . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $buInfo->file . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['export_googlebase'], 'file=' . $buInfo->file) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($buInfo) && is_object($buInfo)) {
$heading[] = array('text' => '<b>' . $buInfo->date . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['export_googlebase'], 'file=' . $buInfo->file . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE . ' ' . $buInfo->date);
$contents[] = array('text' => TEXT_INFO_SIZE . ' ' . $buInfo->size);
}
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>
$amount = $currencies->format($amount);
}
if ($action == 'voucherdelete') {
$contents[] = array('text' => TEXT_CONFIRM_DELETE . '</br></br>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=confirmdelete&cID=' . $_GET['cID'], 'NONSSL') . '">' . oos_image_swap_button('confirm', 'confirm_off.gif', 'Confirm Delete Voucher') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', 'Cancel') . '</a>');
} else {
$prod_details = NONE;
if ($cInfo->restrict_to_products) {
$prod_details = '<a href="' . oos_href_link_admin($aFilename['listproducts'], 'cID=' . $cInfo->coupon_id) . '" TARGET="_blank" ONCLICK="window.open(\'' . $aFilename['listproducts'] . '?cID=' . $cInfo->coupon_id . '\', \'Valid_Categories\', \'scrollbars=yes,resizable=yes,menubar=yes,width=600,height=600\'); return false">View</A>';
}
$cat_details = NONE;
if ($cInfo->restrict_to_categories) {
$cat_details = '<a href="' . oos_href_link_admin($aFilename['listcategories'], 'cID=' . $cInfo->coupon_id) . '" TARGET="_blank" ONCLICK="window.open(\'' . $aFilename['listcategories'] . '?cID=' . $cInfo->coupon_id . '\', \'Valid_Categories\', \'scrollbars=yes,resizable=yes,menubar=yes,width=600,height=600\'); return false">View</A>';
}
$coupon_name_result = $dbconn->Execute("SELECT coupon_name\n FROM " . $oostable['coupons_description'] . "\n WHERE coupon_id = '" . $cInfo->coupon_id . "' AND\n coupon_languages_id = '" . intval($_SESSION['language_id']) . "'");
$coupon_name = $coupon_name_result->fields;
$contents[] = array('text' => COUPON_NAME . ' :: ' . $coupon_name['coupon_name'] . '<br />' . COUPON_AMOUNT . ' :: ' . $amount . '<br />' . COUPON_STARTDATE . ' :: ' . oos_date_short($cInfo->coupon_start_date) . '<br />' . COUPON_FINISHDATE . ' :: ' . oos_date_short($cInfo->coupon_expire_date) . '<br />' . COUPON_USES_COUPON . ' :: ' . $cInfo->uses_per_coupon . '<br />' . COUPON_USES_USER . ' :: ' . $cInfo->uses_per_user . '<br />' . COUPON_PRODUCTS . ' :: ' . $prod_details . '<br />' . COUPON_CATEGORIES . ' :: ' . $cat_details . '<br />' . DATE_CREATED . ' :: ' . oos_date_short($cInfo->date_created) . '<br />' . DATE_MODIFIED . ' :: ' . oos_date_short($cInfo->date_modified) . '<br /><br />' . '<center><a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=email&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('email', 'email_off.gif', 'Email Voucher') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=voucheredit&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('edit', 'edit_off.gif', 'Edit Voucher') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=voucherdelete&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('delete', 'delete_off.gif', 'Delete Voucher') . '</a>' . '<br /><a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=voucherreport&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('report', 'report_off.gif', 'Voucher Report') . '</a></center>');
}
break;
}
?>
<td width="25%" valign="top">
<?php
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
include 'includes/classes/class_' . $class_method[0] . '.php';
${$class_method[0]} = new $class_method[0]();
}
$keys .= oos_call_function($class_method[1], $value['value'], ${$class_method[0]});
} else {
$keys .= oos_call_function($use_function, $value['value']);
}
} else {
$keys .= $value['value'];
}
$keys .= '<br /><br />';
}
$keys = substr($keys, 0, strrpos($keys, '<br /><br />'));
}
} else {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['plugins'], 'plugin=' . $pInfo->instance . '&action=install') . '">' . oos_image_swap_button('module_install', 'module_install_off.gif', IMAGE_PLUGINS_INSTALL) . '</a>');
}
}
$contents[] = array('text' => $pInfo->description);
if (!empty($pInfo->preceeds)) {
$preceeds_string = '<u>Preceeds</u><br />';
if (is_string($pInfo->preceeds)) {
$preceeds_string .= $pInfo->preceeds;
} else {
foreach ($pInfo->preceeds as $preceeds) {
$preceeds_string .= $preceeds . '<br />';
}
}
$contents[] = array('text' => $preceeds_string);
}
$contents[] = array('text' => $keys);
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>
/**
* Output a form
*
* @param $name
* @param $action
* @param $parameters
* @param $method
* @param $params
* @return string
*/
function oos_draw_form($name, $action, $parameters = '', $method = 'post', $params = '') {
$form = '<form name="' . $name . '" action="';
if ($parameters) {
$form .= oos_href_link_admin($action, $parameters);
} else {
$form .= oos_href_link_admin($action);
}
$form .= '" method="' . $method . '"';
if ($params) {
$form .= ' ' . $params;
}
$form .= '>';
return $form;
}
Copyright (c) 2003 - 2007 by the OOS Development Team.
----------------------------------------------------------------------
Based on:
File: tools.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
---------------------------------------------------------------------- */
?>
<!-- tools //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => BOX_HEADING_TOOLS, 'link' => oos_href_link_admin(basename($_SERVER['PHP_SELF']), oos_get_all_get_params(array('selected_box')) . 'selected_box=tools'));
if ($_SESSION['selected_box'] == 'tools' || $menu_dhtml == true) {
$contents[] = array('text' => '<a href="' . OOS_HTTP_SERVER . OOS_SHOP . 'administrator/mysqldumper/index.php' . '" class="menuBoxContentLink">' . BOX_TOOLS_BACKUP . '</a><br />' . oos_admin_files_boxes('box_content', BOX_TOOLS_CONTENT) . oos_admin_files_boxes('banner_manager', BOX_TOOLS_BANNER_MANAGER) . oos_admin_files_boxes('define_language', BOX_TOOLS_DEFINE_LANGUAGE) . oos_admin_files_boxes('file_manager', BOX_TOOLS_FILE_MANAGER) . oos_admin_files_boxes('mail', BOX_TOOLS_MAIL) . oos_admin_files_boxes('newsletters', BOX_TOOLS_NEWSLETTER_MANAGER) . oos_admin_files_boxes('server_info', BOX_TOOLS_SERVER_INFO) . oos_admin_files_boxes('whos_online', BOX_TOOLS_WHOS_ONLINE) . oos_admin_files_boxes('keyword_show', BOX_TOOLS_KEYWORD_SHOW) . oos_admin_files_boxes('recover_cart_sales', BOX_TOOLS_RECOVER_CART));
}
$box = new box();
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- tools_eof //-->
FROM $customerstable c
WHERE c.customers_id NOT IN ( SELECT distinct(o.customers_id) FROM $orderstable o )");
$customers_result_numrows = $customers_result_numrows->RecordCount();
$customers_result = $dbconn->Execute($customers_sql_raw);
while ($customers = $customers_result->fields) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
?>
<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='<?php echo oos_href_link_admin($aFilename['customers'], 'search=' . $customers['customers_lastname'], 'NONSSL'); ?>'">
<td class="dataTableContent"><?php echo $rows; ?>.</td>
<td class="dataTableContent"><?php echo '<a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $customers['customers_lastname'], 'NONSSL') . '">' . $customers['customers_firstname'] . ' ' . $customers['customers_lastname'] . '</a>'; ?></td>
<td class="dataTableContent" align="right"><?php echo $currencies->format($customers['ordersum']); ?> </td>
</tr>
<?php
// Move that ADOdb pointer!
$customers_result->MoveNext();
}
?>
</table></td>
</tr>
<tr>
<td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText" valign="top"><?php echo $customers_split->display_count($customers_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td>
<td class="smallText" align="right"><?php echo $customers_split->display_links($customers_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?> </td>
<td valign="center">
<?php
$heading = array();
$contents = array();
$heading[] = array('params' => 'class="menuBoxHeading"', 'text' => 'OSIS online Shop');
$contents[] = array('params' => 'class="infoBox"', 'text' => '<a href="http://www.oos-shop.de/" target="_blank">' . BOX_ENTRY_HAMPEAGE . '</a><br />' . '<a href="http://developer.berlios.de/mail/?group_id=814" target="_blank">' . BOX_ENTRY_MAILING_LISTS . '</a><br />' . '<a href="http://foren.myoos.de/" target="_blank">Support Board</a><br />');
$box = new box();
echo $box->menuBox($heading, $contents);
echo '<br />';
$orders_contents = '';
$orders_status_result = $dbconn->Execute("SELECT orders_status_name, orders_status_id FROM " . $oostable['orders_status'] . " WHERE orders_languages_id = '" . intval($_SESSION['language_id']) . "'");
while ($orders_status = $orders_status_result->fields) {
$orders_pending_result = $dbconn->Execute("SELECT COUNT(*) AS count FROM " . $oostable['orders'] . " WHERE orders_status = '" . $orders_status['orders_status_id'] . "'");
$orders_pending = $orders_pending_result->fields;
if (oos_admin_check_boxes($aFilename['orders'], 'sub_boxes') == true) {
$orders_contents .= '<a href="' . oos_href_link_admin($aFilename['orders'], 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br />';
} else {
$orders_contents .= '' . $orders_status['orders_status_name'] . ': ' . $orders_pending['count'] . '<br />';
}
// Move that ADOdb pointer!
$orders_status_result->MoveNext();
}
$orders_contents = substr($orders_contents, 0, -4);
$heading = array();
$contents = array();
$heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_ORDERS);
$contents[] = array('params' => 'class="infoBox"', 'text' => $orders_contents);
$box = new box();
echo $box->menuBox($heading, $contents);
echo '<br />';
$customers_result = $dbconn->Execute("SELECT COUNT(*) AS count FROM " . $oostable['customers']);
while ($customers = $customers_result->fields) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
?>
<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='<?php
echo oos_href_link_admin($aFilename['customers'], 'search=' . $customers['customers_lastname'], 'NONSSL');
?>
'">
<td class="dataTableContent"><?php
echo $rows;
?>
.</td>
<td class="dataTableContent"><?php
echo '<a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $customers['customers_lastname'], 'NONSSL') . '">' . $customers['customers_firstname'] . ' ' . $customers['customers_lastname'] . '</a>';
?>
</td>
<td class="dataTableContent" align="right"><?php
echo $currencies->format($customers['ordersum']);
?>
</td>
</tr>
<?php
// Move that ADOdb pointer!
$customers_result->MoveNext();
}
?>
</table></td>
</tr>
<tr>
<td class="smallText"><b><?php
echo TITLE_HTTP_SERVER;
?>
</b></td>
<td colspan="3" class="smallText"><?php
echo $system['HTTP_SERVER'];
?>
</td>
</tr>
<tr>
<td class="smallText"><b><?php
echo TITLE_PHP_VERSION;
?>
</b></td>
<td colspan="3" class="smallText"><?php
echo $system['php'] . ' (' . TITLE_ZEND_VERSION . ' ' . $system['zend'] . ') » » <a href="' . oos_href_link_admin($aFilename['php_info'], '', 'NONSSL') . '" target="_blank">' . TITLE_PHP_INFORMATION . '</a>';
?>
</td>
</tr>
<tr>
<td class="smallText"><b>ADODB Version</b></td>
<td colspan="3" class="smallText"><?php
echo $ADODB_vers;
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<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);
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_HEADING_DELETE_MANUFACTURER . '</b>');
$contents = array('form' => oos_draw_form('manufacturers', $aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $mInfo->manufacturers_name . '</b>');
$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";
}
Copyright (c) 2002 osCommerce
Big Image Modification 2002/03/04
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
define('OOS_VALID_MOD', 'yes');
require 'includes/oos_main.php';
if (!isset($_SESSION['login_id'])) {
oos_redirect_admin(oos_href_link_admin($aFilename['login'], '', 'SSL'));
}
if ( !current_user_can('popup_image_news') )
oos_redirect_admin(oos_href_link_admin($aFilename['forbiden']));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<title><?php echo $_GET['title']; ?> - Administration [OOS]</title>
<base href="<?php echo (getenv('HTTPS') == 'on' ? OOS_HTTPS_SERVER : OOS_HTTP_SERVER) . OOS_SHOP; ?>">
<script language="javascript"><!--
var i=0;
function resize() {
if (navigator.appName == 'Netscape') i=40;
if (document.images[0]) window.resizeTo(document.images[0].width +30, document.images[0].height+60-i);
self.focus();
}
//--></script>
$class_method = explode('->', $use_function);
if (!is_object(${$class_method[0]})) {
include 'includes/classes/class_' . $class_method[0] . '.php';
${$class_method[0]} = new $class_method[0]();
}
$keys .= oos_call_function($class_method[1], $value['value'], ${$class_method[0]});
} else {
$keys .= oos_call_function($use_function, $value['value']);
}
} else {
$keys .= $value['value'];
}
$keys .= '<br /><br />';
}
$keys = substr($keys, 0, strrpos($keys, '<br /><br />'));
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['modules'], 'set=' . $_GET['set'] . '&module=' . $_GET['module'] . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a>');
$contents[] = array('text' => '<br />' . $mInfo->description);
$contents[] = array('text' => '<br />' . $keys);
} else {
$contents[] = array('text' => $mInfo->description);
}
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>
echo oos_draw_hidden_field('products_subimage4', stripslashes($products_subimage4_name));
echo oos_draw_hidden_field('products_subimage5', stripslashes($products_subimage5_name));
echo oos_draw_hidden_field('products_subimage6', stripslashes($products_subimage6_name));
if (isset($_POST['categories_ids'])) {
$selected_catids = $_POST['categories_ids'];
foreach ($selected_catids as $current_category_id) {
echo oos_draw_hidden_field('categories_ids[]', stripslashes($current_category_id));
}
}
echo oos_image_swap_submits('back', 'back_off.gif', IMAGE_BACK, 'name="edit"') . ' ';
if (isset($_GET['pID'])) {
echo oos_image_swap_submits('update', 'update_off.gif', IMAGE_UPDATE);
} else {
echo oos_image_swap_submits('insert', 'insert_off.gif', IMAGE_INSERT);
}
echo ' <a href="' . oos_href_link_admin($aFilename['categories'], 'categories=' . $categories . '&pID=' . $_GET['pID']) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>';
?>
</td>
</form></tr>
<?php
}
}
?>
</table></td>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
<?php
require 'includes/oos_footer.php';