Jump to content

jashelea

Members
  • Content count

    21
  • Joined

  • Last visited

  1. jashelea

    One Page Checkout Support

    Ok - still having an issue... I seem to have it nutted down to this: Customer CANNOT complete check-out if they haven't created an account. Thats a bit of a pain as i thought OPC would create the account. So I need to add a message on the top to tell them to go create and account and come back to check-out. I have "Require login" set as false. If customers are NOT logged in, an error pops up saying "ALL REQUIRED BILLING INFORMATION MUST BE COMPLETED" and the little red dot next to 'email address' is still red, not green like the rest of the "required fields". It prevents customers from checking out. If customers are logged in, and do NOT have to fill in any shipping information, they can complete checkout BUT an error still pops up, but if they click "ok" they can continue with check-out. The error tends to put them off though I think. My second issue, which I think is probably my own issue somewhere but am havign a real brain blank ... when checkout is completed and customers are redirected to my check-out success page, it is completely blank? TIA!
  2. jashelea

    One Page Checkout Support

    Hi, downloaded 1.0.7, there was no new edits..? Well, allt he 'copy and paste' was the same as what I already had? Uploaded all the files again to overwreit older files but made no difference, positive or negative... Still having the 'check' issue, with errors all over the place. Customers can still check out if they click 'OK' to the error message, but they are put off by it and I have had almost no sales since the errors started. With the includes/tld.txt file... am I supposed to edit/delete? It said nothing about it in the install instructions? I've also search this error and came up with nothing. Is there a way to turn off the check?
  3. jashelea

    One Page Checkout Support

    Needs help REALLY QUICK\. I have this installed, and its been great until yesterday :angry: when it suddenly starting throwing out a stupid "Email address could not be checked. please refer to IT web experts"... or something along those lines. Basically, it won't allow a checkout because its not able to check email addresses????? I can't work this out!!!!???!!! PLEASE help, why has this happened. I didn't update anything :huh: I'd love this contrib. to work perfectly, it seems like such a good idea, but seripusly its been nothign but headaches... :(
  4. I have just installed PWA 2.1, everything working great (once I fixed up a } issue), all good, except that it even though no account is created, it asks for a password, and also the 'newsletter' option underneath. It really confuses customers, puts them off as I think they think I'm sneakily creating an ccount even though I know I am not, and no account in admin. How can I change this? I want to keep the create account feature, and have PWA alongside that, otherwise I'd just hide the standard 'create account' details.
  5. jashelea

    [Contribution] Additional Images Module

    *SIGH* Another issue with this addon... I can't edit any products. 1146 - Table 'xxx.TABLE_ADDITIONAL_IMAGES' doesn't exist SELECT additional_images_id, medium_images, popup_images, thumb_images, images_description FROM TABLE_ADDITIONAL_IMAGES where products_id = '29' The table does exist. I have this: // BOF: Additional Images define('TABLE_ADDITIONAL_IMAGES', 'additional_images'); //additional images // EOF: Additional Images In my admin/includes/database_tables.php and this: // BOF: Additional Images define('TABLE_ADDITIONAL_IMAGES', 'additional_images'); //additional Images // EOF: Additional Images in my includes/database_files.php And this is my Additional Images Configuration Utility Checking Configuration Status Your database is up to date. Configuration Group "Additional Images" exists. Checking for items... Configuration Key "ADDITIONAL_IMAGES_AUTO_CREATE" exists. Configuration Key "ADDITIONAL_IMAGES_BACKGROUND_COLOR" exists. Configuration Key "ADDIMAGES_PREFILL_UPLOAD_DIRECTORY" exists. Configuration Key "ADDIMAGES_PREFILL_INITIAL" exists. Configuration Key "ADDIMAGES_RESTRICT_IMAGE_SIZE" exists. Configuration Key "ADDIMAGES_SHOW_ON_PRODUCT_INFO" exists. Configuration Key "ADDIMAGES_MENU_LOCATION" exists. Configuration Key "ADDIMAGES_GROUP_WITH_PARENT" exists. Configuration Key "ADDIMAGES_RESTRICT_PARENT" exists. Configuration Key "ADDIMAGES_TABLE_ALIGNMENT" exists. Configuration Key "ADDIMAGES_TABLE_LOCATION" exists. Configuration Key "ADDIMAGES_NUMBER_OF_COLS" exists. Configuration Key "ADDIMAGES_NUMBER_OF_ROWS" exists. Configuration Key "ADDIMAGES_POPUP_SHOW_ON_POPUP" exists. Configuration Key "ADDIMAGES_POPUP_GROUP_WITH_PARENT" exists. Configuration Key "ADDIMAGES_POPUP_RESTRICT_IMAGE_SIZE" exists. Configuration Key "ADDIMAGES_POPUP_TABLE_ALIGNMENT" exists. Configuration Key "ADDIMAGES_POPUP_TABLE_LOCATION" exists. Configuration Key "ADDIMAGES_POPUP_NUMBER_OF_COLS" exists. Configuration Key "ADDIMAGES_POPUP_NUMBER_OF_ROWS" exists. Configuration Group "Images" exists. Checking for items... Configuration Key "DISPLAY_IMAGE_WIDTH" exists. Configuration Key "DISPLAY_IMAGE_HEIGHT" exists. Configuration Key "POPUP_IMAGE_WIDTH" exists. Configuration Key "POPUP_IMAGE_HEIGHT" exists. Checking for Tables... Table "additional_images" found. Checking for Columns... Column "products_image_med" found in Table "products". Column "products_image_pop" found in Table "products". Column "products_image_description" found in Table "products". Column "thumb_images" found in Table "additional_images". HELP! I can't edit any products. This addon is doing my head in. I also get this error: Additional Images Thumbnail Utility 1146 - Table 'cart_alternatykes_com_au.TABLE_ADDITIONAL_IMAGES' doesn't exist select count(*) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' join TABLE_ADDITIONAL_IMAGES ai on p.products_id = ai.products_id [TEP STOP] ... when in Additional Images - Display All Images. And this error: Additional Images Thumbnail Utility 1146 - Table 'cart_alternatykes_com_au.TABLE_ADDITIONAL_IMAGES' doesn't exist select count(*) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' join TABLE_ADDITIONAL_IMAGES ai on p.products_id = ai.products_id where (ai.thumb_images IS NULL or ai.medium_images IS NULL or ai.popup_images IS NULL) and not (ai.thumb_images IS NULL and ai.medium_images IS NULL or ai.popup_images IS NULL) [TEP STOP] ...when trying to display unprocessed product images.
  6. jashelea

    [Contribution] Additional Images Module

    :blush: well thats embarrassing! Can you tell I'm new at this? lol I'm having another issue but I don't know if its AI related... I'm trying to create a category and upload a category image, but I keep getting that frustrating box with the red cross. Did this addon change anything to do with that?
  7. jashelea

    [Contribution] Additional Images Module

    Hi, can't wait to be able to use this contribution. Having an issue - I get this error... Warning: require(includes/functions/additional_images.php) [function.require]: failed to open stream: No such file or directory in xxx/www/admin/categories.php on line 17 Warning: require(includes/functions/additional_images.php) [function.require]: failed to open stream: No such file or directory in xxx/www/admin/categories.php on line 17 Fatal error: require() [function.require]: Failed opening required 'includes/functions/additional_images.php' (include_path='.:/---:/clientdata/php/lib') in /xxx/admin/categories.php on line 17 Which I know means it's trying to find additional_images.php in the Catalog->Functions folder. Except there isn't one. Am I missing a file? Or do I need to change something in admin/categories.php?
  8. I am using 'Newsletter and Subscribers' v055, tried to send an email and I am getting this error Fatal error: Call to undefined method newsletter::confirm() in /... /admin/newsletters.php on line 281 for this code <?php /* $Id: newsletters.php,v 1.17 2003/06/29 22:50:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); if (tep_not_null($action)) { switch ($action) { case 'lock': case 'unlock': $newsletter_id = tep_db_prepare_input($HTTP_GET_VARS['nID']); $status = (($action == 'lock') ? '1' : '0'); tep_db_query("update " . TABLE_NEWSLETTERS . " set locked = '" . $status . "' where newsletters_id = '" . (int)$newsletter_id . "'"); tep_redirect(tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'])); break; case 'insert': case 'update': if (isset($HTTP_POST_VARS['newsletter_id'])) $newsletter_id = tep_db_prepare_input($HTTP_POST_VARS['newsletter_id']); $newsletter_module = tep_db_prepare_input($HTTP_POST_VARS['module']); $title = tep_db_prepare_input($HTTP_POST_VARS['title']); $content = tep_db_prepare_input($HTTP_POST_VARS['content']); $newsletter_error = false; if (empty($title)) { $messageStack->add(ERROR_NEWSLETTER_TITLE, 'error'); $newsletter_error = true; } /* if (empty($module)) { $messageStack->add(ERROR_NEWSLETTER_MODULE, 'error'); $newsletter_error = true; } */ if (empty($newsletter_module)) { $messageStack->add(ERROR_NEWSLETTER_MODULE, 'error'); $newsletter_error = true; } if ($newsletter_error == false) { $sql_data_array = array('title' => $title, 'content' => $content, 'module' => $newsletter_module); if ($action == 'insert') { $sql_data_array['date_added'] = 'now()'; $sql_data_array['status'] = '0'; $sql_data_array['locked'] = '0'; tep_db_perform(TABLE_NEWSLETTERS, $sql_data_array); $newsletter_id = tep_db_insert_id(); // ################# Contribution Newsletter v050 ############## // Selectionne le pied de page à utiliser if ($newsletter_module=='newsletter_subscribers') { $news_id_subscriber = '1'; } elseif ($newsletter_module=='newsletter') { $news_id_subscriber = '2'; } elseif ($newsletter_module=='product_notification') { $news_id_subscriber = '3'; } // Insertion de la nouvelle newsletter subscribers avec entête et pied de pages par défault - Lecture base subcribers_default $latest_news_query = tep_db_query("select news_id, module_subscribers, header, status, unsubscribea, unsubscribeb from " . TABLE_SUBSCRIBERS_DEFAULT . " where news_id = '" . $news_id_subscriber . "'"); $latest_news = tep_db_fetch_array($latest_news_query); $nlatest_news = new objectInfo($latest_news); // Remplace les caractères ' par \' pour insérer dans la nouvelle newsletter $module_subscribers = ereg_replace("[']", "\'", $nlatest_news->module_subscribers); $header = ereg_replace("[']", "\'", $nlatest_news->header); $unsubscribea = ereg_replace("[']", "\'", $nlatest_news->unsubscribea); $unsubscribeb = ereg_replace("[']", "\'", $nlatest_news->unsubscribeb); // Ecriture dans la base subcribers_infos tep_db_query("insert into " . TABLE_SUBSCRIBERS_INFOS . " (news_id, newsletters_id, status, module_subscribers, header, date_added, unsubscribea, unsubscribeb ) values ('', '" . $newsletter_id . "', '1' , '" . $module_subscribers . "', '" . $header . "', now(), '" . $unsubscribea . "', '" . $unsubscribeb . "') "); // ################# END - Contribution Newsletter v050 ############## } elseif ($action == 'update') { tep_db_perform(TABLE_NEWSLETTERS, $sql_data_array, 'update', "newsletters_id = '" . (int)$newsletter_id . "'"); } tep_redirect(tep_href_link(FILENAME_NEWSLETTERS, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . 'nID=' . $newsletter_id)); } else { $action = 'new'; } break; case 'deleteconfirm': $newsletter_id = tep_db_prepare_input($HTTP_GET_VARS['nID']); tep_db_query("delete from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$newsletter_id . "'"); tep_redirect(tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'])); break; case 'delete': case 'new': if (!isset($HTTP_GET_VARS['nID'])) break; case 'send': case 'confirm_send': $newsletter_id = tep_db_prepare_input($HTTP_GET_VARS['nID']); $check_query = tep_db_query("select locked from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$newsletter_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['locked'] < 1) { switch ($action) { case 'delete': $error = ERROR_REMOVE_UNLOCKED_NEWSLETTER; break; case 'new': $error = ERROR_EDIT_UNLOCKED_NEWSLETTER; break; case 'send': $error = ERROR_SEND_UNLOCKED_NEWSLETTER; break; case 'confirm_send': $error = ERROR_SEND_UNLOCKED_NEWSLETTER; break; } $messageStack->add_session($error, 'error'); tep_redirect(tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'])); } break; } } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <div id="spiffycalendar" class="text"></div> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- 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"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </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 tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <?php if ($action == 'new') { $form_action = 'insert'; $parameters = array('newsletters_id' => '', 'module_subscribers' =>'', 'title' => '', 'header' => '', 'content' => '', 'unsubscribea' => '', 'unsubscribeb' => ''); $nInfo = new objectInfo($parameters); if (isset($HTTP_GET_VARS['nID'])) { $form_action = 'update'; $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); //$newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter_query = tep_db_query("select q.newsletters_id, q.module_subscribers, p.title, q.header, p.content, q.unsubscribea, q.unsubscribeb from " . TABLE_NEWSLETTERS . " p, " . TABLE_SUBSCRIBERS_INFOS . " q where p.newsletters_id = '" . (int)$nID . "' and p.newsletters_id = q.newsletters_id"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo->objectInfo($newsletter); } elseif ($HTTP_POST_VARS) { $nInfo->objectInfo($HTTP_POST_VARS); } $file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.')); $directory_array = array(); if ($dir = dir(DIR_WS_MODULES . 'newsletters/')) { while ($file = $dir->read()) { if (!is_dir(DIR_WS_MODULES . 'newsletters/' . $file)) { if (substr($file, strrpos($file, '.')) == $file_extension) { $directory_array[] = $file; } } } sort($directory_array); $dir->close(); } for ($i=0, $n=sizeof($directory_array); $i<$n; $i++) { $modules_array[] = array('id' => substr($directory_array[$i], 0, strrpos($directory_array[$i], '.')), 'text' => substr($directory_array[$i], 0, strrpos($directory_array[$i], '.'))); } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr><?php echo tep_draw_form('newsletter', FILENAME_NEWSLETTERS, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . 'action=' . $form_action); if ($form_action == 'update') echo tep_draw_hidden_field('newsletter_id', $nID); ?> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo TEXT_NEWSLETTER_MODULE; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('module', $modules_array, $nInfo->module); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_NEWSLETTER_TITLE; ?></td> <td class="main"><?php echo tep_draw_input_field('title', $nInfo->title, '', true); ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main" valign="top"><?php echo TEXT_NEWSLETTER_CONTENT; ?></td> <td class="main"><?php echo tep_draw_textarea_field('content', 'soft', '100%', '20', $nInfo->content); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main" align="right"><?php echo (($form_action == 'insert') ? tep_image_submit('button_save.gif', IMAGE_SAVE) : tep_image_submit('button_update.gif', IMAGE_UPDATE)). ' <a href="' . tep_href_link(FILENAME_NEWSLETTERS, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . (isset($HTTP_GET_VARS['nID']) ? 'nID=' . $HTTP_GET_VARS['nID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td> </tr> </table></td> </form></tr> <?php } elseif ($action == 'preview') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); //$newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter_query = tep_db_query("select q.newsletters_id, q.module_subscribers, p.title, q.header, p.content, q.unsubscribea, q.unsubscribeb, p.module from " . TABLE_NEWSLETTERS . " p, " . TABLE_SUBSCRIBERS_INFOS . " q where p.newsletters_id = '" . (int)$nID . "' and p.newsletters_id = q.newsletters_id"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); ?> <tr> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <tr> <td><tt><?php echo nl2br($nInfo->content); ?></tt></td> </tr> <tr> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <?php } elseif ($action == 'send') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); //$newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter_query = tep_db_query("select q.newsletters_id, q.module_subscribers, p.title, q.header, p.content, q.unsubscribea, q.unsubscribeb, p.module from " . TABLE_NEWSLETTERS . " p, " . TABLE_SUBSCRIBERS_INFOS . " q where p.newsletters_id = '" . (int)$nID . "' and p.newsletters_id = q.newsletters_id"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); //echo DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))."<br>"; include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); //echo DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.')); $module_name = $nInfo->module; $module = new $module_name($nInfo->newsletters_id, $nInfo->module_subscribers, $nInfo->title, $nInfo->header, $nInfo->content, $nInfo->unsubscribea, $nInfo->unsubscribeb); ?> <tr> <td><?php if ($module->show_choose_audience) { echo $module->choose_audience(); } else { echo $module->confirm(); } ?></td> </tr> <?php } elseif ($action == 'confirm') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); //$newsletter_query = tep_db_query("select title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter_query = tep_db_query("select q.newsletters_id, q.module_subscribers, p.title, q.header, p.content, q.unsubscribea, q.unsubscribeb, p.module from " . TABLE_NEWSLETTERS . " p, " . TABLE_SUBSCRIBERS_INFOS . " q where p.newsletters_id = '" . (int)$nID . "' and p.newsletters_id = q.newsletters_id"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $module_name = $nInfo->module; $module = new $module_name($nInfo->newsletters_id, $nInfo->module_subscribers, $nInfo->title, $nInfo->header, $nInfo->content, $nInfo->unsubscribea, $nInfo->unsubscribeb); ?> <tr> <td><?php echo $module->confirm(); ?></td> </tr> <?php } elseif ($action == 'confirm_send') { $nID = tep_db_prepare_input($HTTP_GET_VARS['nID']); //$newsletter_query = tep_db_query("select newsletters_id, title, content, module from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int)$nID . "'"); $newsletter_query = tep_db_query("select q.newsletters_id, q.module_subscribers, p.title, q.header, p.content, q.unsubscribea, q.unsubscribeb, p.module from " . TABLE_NEWSLETTERS . " p, " . TABLE_SUBSCRIBERS_INFOS . " q where p.newsletters_id = '" . (int)$nID . "' and p.newsletters_id = q.newsletters_id"); $newsletter = tep_db_fetch_array($newsletter_query); $nInfo = new objectInfo($newsletter); include(DIR_WS_LANGUAGES . $language . '/modules/newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); include(DIR_WS_MODULES . 'newsletters/' . $nInfo->module . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $module_name = $nInfo->module; $module = new $module_name($nInfo->newsletters_id, $nInfo->module_subscribers, $nInfo->title, $nInfo->header, $nInfo->content, $nInfo->unsubscribea, $nInfo->unsubscribeb); ?> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" valign="middle"><?php echo tep_image(DIR_WS_IMAGES . 'ani_send_email.gif', IMAGE_ANI_SEND_EMAIL); ?></td> <td class="main" valign="middle"><b><?php echo TEXT_PLEASE_WAIT; ?></b></td> </tr> </table></td> </tr> <?php tep_set_time_limit(0); flush(); $module->send($nInfo->newsletters_id); ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main"><font color="#ff0000"><b><?php echo TEXT_FINISHED_SENDING_EMAILS; ?></b></font></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><?php echo '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> </tr> <?php } else { ?> <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_NEWSLETTERS; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_SIZE; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_MODULE; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_SENT; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $newsletters_query_raw = "select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from " . TABLE_NEWSLETTERS . " order by date_added desc"; $newsletters_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $newsletters_query_raw, $newsletters_query_numrows); $newsletters_query = tep_db_query($newsletters_query_raw); while ($newsletters = tep_db_fetch_array($newsletters_query)) { if ((!isset($HTTP_GET_VARS['nID']) || (isset($HTTP_GET_VARS['nID']) && ($HTTP_GET_VARS['nID'] == $newsletters['newsletters_id']))) && !isset($nInfo) && (substr($action, 0, 3) != 'new')) { $nInfo = new objectInfo($newsletters); } if (isset($nInfo) && is_object($nInfo) && ($newsletters['newsletters_id'] == $nInfo->newsletters_id) ) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $newsletters['newsletters_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $newsletters['newsletters_id'] . '&action=preview') . '">' . tep_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $newsletters['title']; ?></td> <td class="dataTableContent" align="right"><?php echo number_format($newsletters['content_length']) . ' bytes'; ?></td> <td class="dataTableContent" align="right"><?php echo $newsletters['module']; ?></td> <td class="dataTableContent" align="center"><?php if ($newsletters['status'] == '1') { echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK); } else { echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS); } ?></td> <td class="dataTableContent" align="center"><?php if ($newsletters['locked'] > 0) { echo tep_image(DIR_WS_ICONS . 'locked.gif', ICON_LOCKED); } else { echo tep_image(DIR_WS_ICONS . 'unlocked.gif', ICON_UNLOCKED); } ?></td> <td class="dataTableContent" align="right"><?php if (isset($nInfo) && is_object($nInfo) && ($newsletters['newsletters_id'] == $nInfo->newsletters_id) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $newsletters['newsletters_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php } ?> <tr> <td colspan="6"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $newsletters_split->display_count($newsletters_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_NEWSLETTERS); ?></td> <td class="smallText" align="right"><?php echo $newsletters_split->display_links($newsletters_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?></td> </tr> <tr> <td align="right" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'action=new') . '">' . tep_image_button('button_new_newsletter.gif', IMAGE_NEW_NEWSLETTER) . '</a>'; ?></td> </tr> </table></td> </tr> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'delete': $heading[] = array('text' => '<b>' . $nInfo->title . '</b>'); $contents = array('form' => tep_draw_form('newsletters', FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['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>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($nInfo)) { $heading[] = array('text' => '<b>' . $nInfo->title . '</b>'); if ($nInfo->locked > 0) { $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=new') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . tep_image_button('button_preview.gif', IMAGE_PREVIEW) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=send') . '">' . tep_image_button('button_send.gif', IMAGE_SEND) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=unlock') . '">' . tep_image_button('button_unlock.gif', IMAGE_UNLOCK) . '</a>'); } else { $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . tep_image_button('button_preview.gif', IMAGE_PREVIEW) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->newsletters_id . '&action=lock') . '">' . tep_image_button('button_lock.gif', IMAGE_LOCK) . '</a>'); } $contents[] = array('text' => '<br>' . TEXT_NEWSLETTER_DATE_ADDED . ' ' . tep_date_short($nInfo->date_added)); if ($nInfo->status == '1') $contents[] = array('text' => TEXT_NEWSLETTER_DATE_SENT . ' ' . tep_date_short($nInfo->date_sent)); } break; } if ( (tep_not_null($heading)) && (tep_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> <?php } ?> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  9. I have 'Product Attributes' which allows me to set a quantity to an attribute. Is there a way to link one attribute quantity to two or more products? I need to link the attribute "Orange shirt", quantity 10, to 4 different products. Is there a way to do this?
  10. I haven't done anything to the code or anything, I installed everything as is from the add-on, but my page now looks like this..... http://www.alternatykes.com.au/product_inf.../products_id/28 The right column ends up on the left, the product and description etc end up where my logo was... and at the cottom it says "error on page" Surely I haven't been the only one with this issue as I didn't change it at all.......?
  11. Ah... don't worry... I feel like I right idiot... Thought I had updated mysql with SQL_english.sql but I hadn't... :blush: :blush: How embarrassing... lol
  12. I have installed Newsletter & Subscribers v055, installation went smoothly, everything came up nicely on the site, but when testing (after I submitted my name and email) I get taken to a page that says this... "1146 - Table 'cart_alternatykes_com_au.subscribers' doesn't exist select subscribers_id from subscribers where subscribers_email_address = '---' " What does this mean? Is this something to do with admin, or mysql? Having a total brain blank moment (plus I'm relatively new to all this...). Also, I went to admin to try and see if I could fix this, and found more error-type writing... When I clicked on "Newsletter Default" under the Newsletter heading, i get this "1146 - Table 'cart_alternatykes_com_au.subscribers_default' doesn't exist select p.news_id, p.module_subscribers, p.header, p.status from subscribers_default p order by p.date_added desc [TEP STOP]" When I clicked on "update Table" I get this... "1146 - Table 'cart_alternatykes_com_au.subscribers_update' doesn't exist select count(*) as total from subscribers_update [TEP STOP]" And when I clicked on "Sunscribers Admin" I get this... "1146 - Table 'cart_alternatykes_com_au.subscribers' doesn't exist select count(*) as total from subscribers c [TEP STOP]" I've obviously missed something, but have checked through the installation instructions and don't think I have mised anything? :blush:
×