Jump to content

Patty

Members
  • Content count

    309
  • Joined

  • Last visited


Reputation Activity

  1. Like
    Patty reacted to JcMagpie in Newsletters Subscribers Manager - Oscommerce 2.3 & 2.2   
    Your best bet is to simply add the google reCAPTCHA to the form, use the info provided by google to do this,
    https://developers.google.com/recaptcha/old/docs/php
  2. Thanks
    Patty reacted to raiwa in ULTIMATE Seo Urls 5 - by FWR Media   
    I found a fix for this error:
    In all product page modules (product_info.php, product_reviews.php and product_reviews_info.php)
    Find:
    $result = Usu_Main::i()->query( $this->query ); $text_array = tep_db_fetch_array( $result ); Add below:
    if ($text_array == null) { return false; }
  3. Like
    Patty reacted to sagitario in Ultimate Seo Urls 5 Pro   
    Yes, with the osc upgrade I convert all to UTF-8. All my sql tables are all in utf8_unicode_ci
     
     
    Yehhhh... that do the trick. Thank you very much :)
     
     
    Every day a new lesson. Never eared before about BOM or without BOM. I save the file without BOM and work like a charm. Many thanks once again, you are a master ;)
  4. Like
    Patty reacted to Jack_mcs in All Customers Report   
    Replace $HTTP_POST_VARS with $_POST.
  5. Like
    Patty reacted to stu2000 in [CONTRIBUTION] Admin Change Customer Passwords   
    If anyone is interested, here is my change_password.php file with a few cosmetic changes and the ability now to automatically email the customer with the new password (please note I have removed (commented out) the auto password generation)
     
     

    <?php /* $Id: change_password.php,v 3.0 11/23/2007 kymstion osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2007 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // Include the password functions require(DIR_WS_FUNCTIONS . 'password_funcs.php'); // Include the language definitions require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHANGE_PASSWORD); // // POST target -- the POST form has been sent to change a password // If a password change has been submitted, check the results for errors $pass = 0; if ($_POST['customer_id'] != '') { $customer_id = (int)$_POST['customer_id']; if ($_POST['new_password'] == '' && $_POST['repeat_password'] == '') { // Use generated password $pass = 1; $new_password = $_POST['auto_password']; } elseif ($_POST['new_password'] == $_POST['repeat_password']) { // Use custom password $pass = 1; $new_password = $_POST['new_password']; } elseif (empty($_POST['new_password'])) { // Missing password $pass = 2; } elseif (empty($_POST['repeat_password'])) { // Missing repeat password $pass = 2; } elseif ($_POST['new_password'] != $_POST['repeat_password']) { // Mismatched passwords $pass = 3; } // If all is well, make the changes to the database if ($pass == 1) { mysql_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_password='" . tep_encrypt_password ($new_password) . "' WHERE customers_id='" . $customer_id . "'"); // Get the customer's information for the success message $customer_name_query = mysql_query("SELECT customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " WHERE customers_id='" . $customer_id . "'"); $customer_name = mysql_fetch_array ($customer_name_query); define('EMAIL_PASSWORD_REMINDER_SUBJECT', STORE_NAME . ' - New Password Generated'); define('EMAIL_PASSWORD_REMINDER_BODY', 'A new password was requested for your account at ' . STORE_NAME . '.' . "\n\n" . 'Your new password to \'' . STORE_NAME . '\' is: ' . '%s' . "\n\n" . 'If you did not authorise this, please contact us immediately.' . "\n\n" . STORE_OWNER . "\n" . STORE_OWNER_EMAIL_ADDRESS ); tep_mail($customer_name['customers_firstname'] . " " . $customer_name['customers_lastname'], $customer_name['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, nl2br(sprintf(EMAIL_PASSWORD_REMINDER_BODY, $new_password)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } } // End POST section // // GET target -- a GET form has been sent // Build a SQL string from the Search or Customer variables $search_string = ''; if (isset ($HTTP_GET_VARS['search']) && strlen ($HTTP_GET_VARS['search']) > 1) { $keywords = tep_db_input (tep_db_prepare_input ($HTTP_GET_VARS['search'])); $search_string = "where customers_lastname like '%" . $keywords . "%' or customers_firstname like '%" . $keywords . "%' or customers_email_address like '%" . $keywords . "%'"; } elseif (isset ($HTTP_GET_VARS['customer'])) { $customer_id = (int)$HTTP_GET_VARS['customer']; $search_string = "WHERE customers_id='" . $customer_id . "'"; } // End GET section // // Variable fields to insert into the page // Build an array of customers for the select pulldown $customer_data_query = mysql_query("SELECT customers_id, customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " " . $search_string . " ORDER BY customers_lastname, customers_firstname "); $customers_array = array(); while ($customer_data = mysql_fetch_array ($customer_data_query) ) { $customers_array[] = array('id' => $customer_data['customers_id'], 'text' => $customer_data['customers_firstname'] . ' ' . $customer_data['customers_lastname'] . ' (' . $customer_data['customers_email_address'] . ')' ); } // Set the correct message to display for password change or errors $message = ''; switch ($pass) { case 1: $message = '<b><font color=#009900>'; $message .= CUSTOMER_PASSWORD . $customer_name['customers_firstname'] . ' ' . $customer_name['customers_lastname']; $message .= PASSWORD_UPDATED . ' <font color=red>' . $new_password . '</font><br>An Email has been sent to ' . $customer_name['customers_firstname'] . ' ' . $customer_name['customers_lastname'] . ' to verify this change.<br>'; $message .= '</b></font><br>' . tep_black_line(); break; case 2: $message = '<b><font color=#ff0000>'. PLEASE_NEW_PASSWORD . PLEASE_REPEAT . '</b></font>'; break; case 3: $message = '<b><font color=#ff0000>'. ERROR_NEW_PASSWORD . PLEASE_REPEAT . '</b></font>'; break; case 0: default: $message = ' '; break; } // Set up the search form $search_form = tep_draw_input_field ('search'); $search_form .= tep_draw_hidden_field ('selected_box', 'customers'); $search_form .= tep_hide_session_id(); // Generate a random password and add it to the form $auto_password = tep_create_random_value (ENTRY_PASSWORD_MIN_LENGTH); $auto_form = tep_draw_hidden_field ('auto_password', $auto_password) . $auto_password; ?> <!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"> <!-- 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 ($message != ' ') { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo $message; ?></td> </tr> </table></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php echo tep_draw_form ('search', FILENAME_CHANGE_PASSWORD, '', 'get'); ?> <table border="0" width="600px" cellspacing="0" cellpadding="2"> <tr> <td width="170"><?php echo tep_draw_separator('pixel_trans.gif', '170', '1'); ?></td> <td width="150"><?php echo tep_draw_separator('pixel_trans.gif', '150', '1'); ?></td> <td width="280"><?php echo tep_draw_separator('pixel_trans.gif', '280', '1'); ?></td> </tr> <tr> <td class="main" colspan="3"><?php echo TEXT_SEARCH_INSTRUCTION; ?><br></td> </tr> <tr> <td width="170" class="main"><b><?php echo SEARCH; ?></b></td> <td width="150" class="main"><?php echo $search_form; ?></td> <td width="280" class="main"><?php echo tep_image_submit ('button_search.gif', IMAGE_SEARCH); ?></td> </tr> </form></table></td> </tr> <tr> <td><?php echo tep_draw_form ('password', FILENAME_CHANGE_PASSWORD, 'selected_box=customers', 'POST'); ?> <table border=0 width="600px" cellspacing="0" cellpadding="2"> <tr> <td width="170" class="main"><b><font color=red>OR</font><br><br><?php echo SELECT_CUSTOMER; ?></b><br><br></td> <td width="450" class="main"><br><br><?php echo tep_draw_pull_down_menu('customer_id', $customers_array);; ?><br><br></td> </tr> <tr> <td class="main"><b><?php echo NEW_PASSWORD; ?></b></td> <td class="main"><?php echo tep_draw_password_field('new_password'); ?></td> </tr> <tr> <td class="main"><b><?php echo REPEAT_NEW_PASSWORD; ?></b></td> <td class="main"><?php echo tep_draw_password_field('repeat_password'); ?></td> </tr> <!-- <tr> <td class="main"><b><?php echo AUTO_PASSWORD; ?></b></td> <td class="main"><?php echo $auto_form; ?></td> </tr> --> <tr> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '170', '1'); ?></td> <td><?php echo tep_image_submit ('button_change_password.gif', IMAGE_CHANGE_PASSWORD); ?></td> </tr> </form></table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> </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'); ?>
     
    A big thank you to Jim Keebaugh, for his help in completing this modification :)
  6. Like
    Patty reacted to exen in jQuery/Ajax Shopping Cart   
    I also struggled with this problem ... When you add a product to the cart opened up a whole page catalog in a place where it should be subtotal for shopping-cart-box.
    The solution is to change the store admin panel options
    "Show cart after adding the product" to TRUE.
     
    Regards,
×