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;
}
" cellspacing="1" cellpadding="1" class="columnLeft">
<?php
require 'includes/oos_blocks.php';
?>
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php
echo HEADING_TITLE;
?>
</td>
<td class="pageHeading" align="right"><?php
echo oos_draw_separator('trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT);
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent"><?php
echo TABLE_HEADING_MODULES;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
$no_js_general = true;
require 'includes/oos_header.php';
?>
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<?php require 'includes/oos_blocks.php'; ?>
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
<td class="pageHeading" align="right"><?php echo oos_draw_separator('trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td>
<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_QTY_LEFT; ?> </td>
</tr>
<?php
if (isset($_GET['page']) && ($_GET['page'] > 1)) $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS;
</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>
</table>
<!-- body_eof //-->
<?php
require 'includes/oos_footer.php';
?>
<br />
</body>
</html>
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 ($pInfo->products_date_available > date('Y-m-d')) {
?>
<tr>
<td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_AVAILABLE, oos_date_long($pInfo->products_date_available)); ?></td>
</tr>
<?php
} else {
?>
<tr>
<td align="center" class="smallText"><?php echo sprintf(TEXT_PRODUCT_DATE_ADDED, oos_date_long($pInfo->products_date_added)); ?></td>
</tr>
<?php
}
?>
<tr>
<td><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<?php
}
if (isset($_GET['read']) && ($_GET['read'] == 'only')) {
if (isset($_GET['origin'])) {
$pos_params = strpos($_GET['origin'], '?', 0);
if ($pos_params != false) {
$back_url = substr($_GET['origin'], 0, $pos_params);
$back_url_params = substr($_GET['origin'], $pos_params + 1);
} else {
$back_url = $_GET['origin'];
$back_url_params = '';
}
} else {
$back_url = $aFilename['categories'];
</tr><tr>
<td>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => '<b>' . SIDEBAR_HEADING . '</b>');
$contents[] = array('text' => '<br />' . SIDEBAR_INFO_1);
$contents[] = array('text' => '<input type="submit" name="update" value="' . BUTTON_UPDATE_WORD_LIST . '">');
$contents[] = array('text' => oos_draw_separator());
$contents[] = array('text' => '<br /><input type="submit" name="sort_name" value="' . BUTTON_SORT_NAME . '"><br /><input type="submit" name="sort_total" value="' . BUTTON_SORT_TOTAL . '">');
$contents[] = array('text' => oos_draw_separator());
$contents[] = array('text' => '<br />' . SIDEBAR_INFO_2);
$contents[] = array('text' => '<input type="submit" value="' . BUTTON_DELETE . '" name="delete">');
$contents[] = array('text' => oos_draw_separator());
$contents[] = array('text' => SIDEBAR_INFO_3);
$contents[] = array('text' => '<input type="submit" name="update_word_list" value="' . BUTTON_VIEW_WORD_LIST . '">');
if ( (!empty($heading)) && (!empty($contents) ) ) {
$box = new box;
echo $box->infoBox($heading, $contents);
}
?>
</td></tr></table></form>
</td>
</tr>
</table>
<!-- right_column_eof //-->
<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
<td class="pageHeading" align="right"><?php echo oos_draw_separator('trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
</tr>
</table></td>
</td>
</tr>
<tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="1">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent"><?php echo oos_draw_separator('trans.gif', '100%', '1'); ?></td>
</tr>
<tr>
<td class="main"><?php echo HEADING_INTRO; ?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td>
$session_data = trim(implode('', $session_data));
}
}
$currency = unserialize(oos_get_serialized_variable($session_data, 'currency', 'string'));
$cart = unserialize(oos_get_serialized_variable($session_data, 'cart', 'object'));
if (isset($cart) && is_object($cart)) {
$products = $cart->get_products();
for ($i = 0, $n = count($products); $i < $n; $i++) {
$contents[] = array('text' => $products[$i]['quantity'] . ' x ' . $products[$i]['name']);
}
if (count($products) > 0) {
$contents[] = array('text' => oos_draw_separator('pixel_black.gif', '100%', '1'));
$contents[] = array('align' => 'right', 'text' => TEXT_SHOPPING_CART_SUBTOTAL . ' ' . $currencies->format($cart->show_total(), true, $currency));
} else {
$contents[] = array('text' => ' ');
}
}
}
if ( (!empty($heading)) && (!empty($contents) ) ) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
<tr>
<td colspan="2"><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td valign="top" class="main"><?php echo TEXT_AMOUNT; ?></td>
<td><?php echo oos_draw_input_field('amount'); ?></td>
</tr>
<tr>
<td colspan="2"><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td valign="top" class="main"><?php echo TEXT_MESSAGE; ?></td>
<td><?php echo oos_draw_textarea_field('message', 'soft', '60', '15'); ?></td>
</tr>
<tr>
<td colspan="2"><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td colspan="2" align="right"><?php echo oos_image_swap_submits('send_mail','send_mail_off.gif', IMAGE_SEND_EMAIL); ?></td>
</tr>
</table></td>
</form></tr>
<?php
}
?>
<!-- body_text_eof //-->
</table></td>
</tr>
</table></td>
</tr>
</table>
