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>