Jump to content

Paulz

Members
  • Content count

    87
  • Joined

  • Last visited

Everything posted by Paulz

  1. Trying to produce a better option than Products Attributes in Admin. ie: 1 main product with multiple sizes available but each with an individual product_id ? Please see example: http://shop.canonical.com/product_info.php?products_id=767 each size adds a individual product to cart Is there any contribution available to do this?
  2. When i Enable SEO URLs 5, & select the product in product info i get: Product not found the Address bar shows the changed url ok but no product info, Ive checked all files over & over again without any errors? Any ideas what may be wrong?
  3. Paulz

    Product not found

    Ive upgraded to latest: Ultimate_Seo_Urls_5_PRO_r205
  4. Paulz

    Dynamic SiteMap

    Ive got the same problem, any help with a solution Thanks
  5. My standard categories list the products in 3 columns with images etc & this looks good. I need a different category format that will list each product on a single line (just 1 column) without any images, just model number title price & small buy now button. This would be used to list complete manufacturers price lists. Possible 100 or 200 at a time, a good idea would be to have check boxes for multiple selection & a buy it now button. Any Suggestions appreciated
  6. Paulz

    Official PayPal IPN Support Thread

    Paypal Transaction ID recorded in database, Has anyone got a solution on how to do this: I want to record the Paypal Unique Transaction ID : 17 characters as example 23Q183171B041133K Regards Paul
  7. Paulz

    Country-State Selector

    Upgraded and still got the same problem with the Primary address,, Ive added a note for the customer to log out after editing there primary address. Has anyone else tested for this problem?
  8. Paulz

    Country-State Selector

    Thanks for your help Steve, Just tried this update, didnt make any difference ? The initial version I used was: country-state-selector_1_2_3_4_5_6_7.zip What do you recommend? Regards Paul
  9. Paulz

    Country-State Selector

    when a customer logs on my site displays product prices including tax but when they make any changes to the Primary Address, ie: address line 1 (say, house number to 47 instead of 7) and stays logged on, it changes the site prices to exclude tax instead of include tax? when the customer logs off and back on again its back to normal? Ive come to the conclusion this has something to do with the..Country-State Selector module. Please help !!
  10. Paulz

    Delete product with search

    Im still unsure on what other product tables to delete the unwanted items from, can anyone help on that. Ive added 'Delete from products_description' to the script, i dont think it looks right but it works ok! Id apreciate if someone could tidy the code. if ($action == "update_prices") { foreach($HTTP_POST_VARS['product_new_price'] as $id => $cancella) { echo "id: $id -> $cancella<br>"; mysql_query("DELETE FROM products WHERE products_id=$id"); mysql_query("DELETE FROM products_description WHERE products_id=$id"); $count++; }
  11. I had the problem of deleting a large number of discontinued products, as quick and simple as possible. Found this contribution: Delete product with search, http://www.oscommerce.com/community/contri...+product+search It allows a type of wild card search lists all matching products with check boxes enabling multiple deletion. However It only deletes from the products table.. I want it to delete from all the other product tables, one question though will any of the products tables effect the customer account_history_info.php for deleted products? Ive deleted items from the product table and the products_description table and they still appear OK in the customer account_history_info. Cannot find any feedback on this contribution in the forum, has anyone modified it or had any provlems. or could anyone help with modifying. p.s. Another advantage compared with similar contributions is it doesnt effect the categories and you dont have to search through the cats either!
  12. Paulz

    Country-State Selector

    Did anyone get a solution to the "Please select" as an option for states ? Regards Paul :huh:
  13. Paulz

    Register Globals Support

    Im currently reloading my site on a new server and Ive got the Register globals problem, My version of OSC is 2.2-MS1 will this contribution work with it. ? Anyone had any success with 2.2-MS1 or are there any alternative options? Thanks
  14. There is no 'Payment Zone' option in the Worldpay module. I need to have this as I will be accepting credit cards for the UK only. Can anyone help please.
  15. Paulz

    WorldPay has no Payment Zone option

    Fame at last, my first contribution: http://www.oscommerce.com/community/contributions,882 :D
  16. Paulz

    WorldPay has no Payment Zone option

    Got it working I had this missing line: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Payment Zone', 'MODULE_PAYMENT_WORLDPAY_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); Thanks
  17. Paulz

    WorldPay has no Payment Zone option

    Im using 2.2 ver 1, on an internal web server. Im sure it must be a simple problem, in admin when I set the Payment zone to anything but none the world pay module is unavailable at checkout no matter what country, when i set it to -none- it appears on any country i set the billing address to?. heres the full code: <?php /* $Id: worldpay.php,v MS1a 2003/04/06 21:30 Author : Graeme Conkie (graeme@conkie.net) Title: WorldPay Payment Callback Module V4.0 Version 1.4 Revisions: Version MS1a Cleaned up code, moved static English to language file to allow for bi-lingual use, Now posting language code to WP, Redirect on failure now to Checkout Payment, Reduced re-direct time to 8 seconds, added MD5, made callback dynamic NOTE: YOU MUST CHANGE THE CALLBACK URL IN WP ADMIN TO <wpdisplay item="MC_callback"> Version 1.4 Removes boxes to prevent users from clicking away before update, Fixes currency for Yen, Redirects to Checkout_Process after 10 seconds or click by user Version 1.3 Fixes problem with Multi Currency Version 1.2 Added Sort Order and Default order status to work with snapshots after 14 Jan 2003 Version 1.1 Added Worldpay Pre-Authorisation ability Version 1.0 Initial Payment Module osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 Released under the GNU General Public License */ class worldpay { var $code, $title, $description, $enabled; // class constructor function worldpay() { $this->code = 'worldpay'; $this->title = MODULE_PAYMENT_WORLDPAY_TEXT_TITLE; $this->description = MODULE_PAYMENT_WORLDPAY_TEXT_DESCRIPTION; $this->sort_order = MODULE_PAYMENT_WORLDPAY_SORT_ORDER; $this->enabled = ((MODULE_PAYMENT_WORLDPAY_STATUS == 'True') ? true : false); if ((int)MODULE_PAYMENT_WORLDPAY_ORDER_STATUS_ID > 0) { $this->order_status = MODULE_PAYMENT_WORLDPAY_ORDER_STATUS_ID; } if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_WORLDPAY_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_WORLDPAY_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } $this->form_action_url = 'https://select.worldpay.com/wcc/purchase'; } // class methods function javascript_validation() { return false; } function selection() { return array('id' => $this->code, 'module' => $this->title); } function pre_confirmation_check() { return false; } function confirmation() { return false; } function process_button() { // Ian-san: Need to declare language_id global here 6/4/2003: global $HTTP_POST_VARS, $languages_id, $shipping_cost, $total_cost, $shipping_selected, $shipping_method, $currencies, $currency, $customer_id , $order; $worldpay_url = tep_session_name() . '=' . tep_session_id(); // Multi Currency - Graeme Conkie ver 1.3 - Set up variable // Added decimal point code - contributed by Ian Davidson (Feb 08,2003) - For Yen currency $OrderAmt = number_format($order->info['total'] * $currencies->get_value($currency), $currencies->get_decimal_places($currency), '.', '') ; // Multi Currency - ver 1.3 $process_button_string = tep_draw_hidden_field('instId', MODULE_PAYMENT_WORLDPAY_ID) . tep_draw_hidden_field('currency', $currency) . tep_draw_hidden_field('desc', 'Purchase from '.STORE_NAME) . // Send URL and session name - contributed by Nick Vermeulen 08 Feb, 2003 tep_draw_hidden_field('cartId', $worldpay_url ) . // Assign Multi Currency Variable to Amount tep_draw_hidden_field('amount', $OrderAmt) ; // Pre Auth Mod 3/1/2002 - Graeme Conkie if (MODULE_PAYMENT_WORLDPAY_USEPREAUTH == 'True') $process_button_string .= tep_draw_hidden_field('authMode', MODULE_PAYMENT_WORLDPAY_PREAUTH); // Ian-san: Create callback and language links here 6/4/2003: //$callback_url = tep_href_link(FILENAME_WPCALLBACK); //$worldpay_callback = explode('http://', $callback_url); // Nimmit: Duplicate entry problem fix 18/2/04 if(ENABLE_SSL){ if(HTTP_SERVER != HTTPS_SERVER){ // if servers are different use the https one to create the callback url $callback_url = tep_href_link(FILENAME_WPCALLBACK,'','SSL',false); $worldpay_callback = explode('https://', $callback_url); } else{ // otherwise use the http $callback_url = tep_href_link(FILENAME_WPCALLBACK); $worldpay_callback = explode('http://', $callback_url); } } else{ $callback_url = tep_href_link(FILENAME_WPCALLBACK); $worldpay_callback = explode('http://', $callback_url); } // end Nimmit $language_code_raw = tep_db_query("select code from " . TABLE_LANGUAGES . " where languages_id ='$languages_id'"); $language_code_array = tep_db_fetch_array($language_code_raw); $language_code = $language_code_array['code']; $address = htmlspecialchars($order->customer['street_address'] . "\n" . $order->customer['suburb'] . "\n" . $order->customer['city'] . "\n" . $order->customer['state'], ENT_QUOTES); $process_button_string .= tep_draw_hidden_field('testMode', MODULE_PAYMENT_WORLDPAY_MODE) . tep_draw_hidden_field('name', $order->customer['firstname'] . ' ' . $order->customer['lastname']) . tep_draw_hidden_field('address', $address) . tep_draw_hidden_field('postcode', $order->customer['postcode']) . tep_draw_hidden_field('country', $order->customer['country']['iso_code_2']) . tep_draw_hidden_field('tel', $order->customer['telephone']) . tep_draw_hidden_field('myvar', 'Y') . tep_draw_hidden_field('fax', $order->customer['fax']) . tep_draw_hidden_field('email', $order->customer['email_address']) . // Ian-san: Added dynamic callback and languages link here 6/4/2003: tep_draw_hidden_field('lang', $language_code) . tep_draw_hidden_field('MC_callback', $worldpay_callback[1] . '?language=' . $language_code) . tep_draw_hidden_field('MC_oscsid', $oscSid); // Ian-san: Added MD5 here 6/4/2003: if (MODULE_PAYMENT_WORLDPAY_USEMD5 == '1') { $md5_signature_fields = 'amount:language:email'; $md5_signature = MODULE_PAYMENT_WORLDPAY_MD5KEY . ':' . (number_format($order->info['total'] * $currencies->get_value($currency), $currencies->get_decimal_places($currency), '.', '')) . ':' . $language_code . ':' . $order->customer['email_address']; $md5_signature_md5 = md5($md5_signature); $process_button_string .= tep_draw_hidden_field('signatureFields', $md5_signature_fields ) . tep_draw_hidden_field('signature',$md5_signature_md5); } return $process_button_string ; } function before_process() { global $HTTP_POST_VARS; } function after_process() { return false; } function output_error() { return false; } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_WORLDPAY_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable WorldPay Module', 'MODULE_PAYMENT_WORLDPAY_STATUS', 'True', 'Do you want to accept WorldPay payments?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Worldpay Installation ID', 'MODULE_PAYMENT_WORLDPAY_ID', '00000', 'Your WorldPay Select Junior ID', '6', '2', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Mode', 'MODULE_PAYMENT_WORLDPAY_MODE', '100', 'The mode you are working in (100 = Test Mode Accept, 101 = Test Mode Decline, 0 = Live', '6', '5', now())"); // Ian-san: Added MD5 here 6/4/2003: tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Use MD5', 'MODULE_PAYMENT_WORLDPAY_USEMD5', '0', 'Use MD5 encyption for transactions? (1 = Yes, 0 = No)', '6', '4', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('MD5 secret key', 'MODULE_PAYMENT_WORLDPAY_MD5KEY', '', 'MD5 secret key. Must also be entered into Worldpay installation config', '6', '5', now())"); // Pre Auth Mod - Graeme Conkie 13/1/2003 tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_PAYMENT_WORLDPAY_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Use Pre-Authorisation?', 'MODULE_PAYMENT_WORLDPAY_USEPREAUTH', 'False', 'Do you want to pre-authorise payments? Default=False. You need to request this from WorldPay before using it.', '6', '3', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Set Order Status', 'MODULE_PAYMENT_WORLDPAY_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Pre-Auth', 'MODULE_PAYMENT_WORLDPAY_PREAUTH', 'A', 'The mode you are working in (A = Pay Now, E = Pre Auth). Ignored if Use PreAuth is False.', '6', '4', now())"); // Ian-san: Added MD5 here 6/4/2003: tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_WORLDPAY_USEMD5'"); tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_WORLDPAY_MD5KEY'"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { return array('MODULE_PAYMENT_WORLDPAY_STATUS', 'MODULE_PAYMENT_WORLDPAY_ID','MODULE_PAYMENT_WORLDPAY_MODE','MODULE_PAYMENT_WORLDPAY_USEPREAUTH','MODULE_PAYMENT_WORLDPAY_PREAUTH','MODULE_PAYMENT_WORLDPAY_SORT_ORDER','MODULE_PAYMENT_WORLDPAY_ORDER_STATUS_ID'); } } ?>
  18. Paulz

    WorldPay has no Payment Zone option

    I tried the update_status function in the worldpay.php module but it didnt work. Im lost with this could you give me an example please
  19. Paulz

    WorldPay has no Payment Zone option

    Ive tried using the following from the nochex module, but have had no success, can you help NOCHEX ********************************** class nochex { var $code, $title, $description, $enabled; // class constructor function nochex() { global $order; $this->code = 'nochex'; $this->title = MODULE_PAYMENT_NOCHEX_TEXT_TITLE; $this->description = MODULE_PAYMENT_NOCHEX_TEXT_DESCRIPTION; $this->sort_order = MODULE_PAYMENT_NOCHEX_SORT_ORDER; $this->enabled = ((MODULE_PAYMENT_NOCHEX_STATUS == 'True') ? true : false); if ((int)MODULE_PAYMENT_NOCHEX_ORDER_STATUS_ID > 0) { $this->order_status = MODULE_PAYMENT_NOCHEX_ORDER_STATUS_ID; } if (is_object($order)) $this->update_status(); $this->form_action_url = 'https://www.nochex.com/nochex.dll/checkout'; } // class methods function update_status() { global $order; if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_NOCHEX_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_NOCHEX_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } } ************************************************************ WORLDPAY *********************************************************** // class constructor function worldpay() { $this->code = 'worldpay'; $this->title = MODULE_PAYMENT_WORLDPAY_TEXT_TITLE; $this->description = MODULE_PAYMENT_WORLDPAY_TEXT_DESCRIPTION; $this->sort_order = MODULE_PAYMENT_WORLDPAY_SORT_ORDER; $this->enabled = ((MODULE_PAYMENT_WORLDPAY_STATUS == 'True') ? true : false); if ((int)MODULE_PAYMENT_WORLDPAY_ORDER_STATUS_ID > 0) { $this->order_status = MODULE_PAYMENT_WORLDPAY_ORDER_STATUS_ID; } if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_WORLDPAY_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_WORLDPAY_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } $this->form_action_url = 'https://select.worldpay.com/wcc/purchase'; }
  20. Paulz

    WorldPay has no Payment Zone option

    Ive compared with secpay and tried various changes without any success.
  21. Thanks for the contribution. Ive added a few fields to my form (dont know if Ive done it the right way but anyhow it works). However I cant find a way of sending the title of the email ie sales so it is recieved in the body of the email as per my other form data . can you please help. My modification as below: if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'send')) { if (tep_validate_email(trim($HTTP_POST_VARS['email']))) { if (CONTACT_US_LIST !=''){ $send_to_array=explode("," ,CONTACT_US_LIST); preg_match('/\<[^>]+\>/', $send_to_array[$send_to], $send_email_array); $send_to_email= eregi_replace (">", "", $send_email_array[0]); $send_to_email= eregi_replace ("<", "", $send_to_email); $email_address = ' Email: ' . tep_db_prepare_input($HTTP_POST_VARS['email']); $enquiry = '' . tep_db_prepare_input($HTTP_POST_VARS['firstname']); $enquiry .= ':' . tep_db_prepare_input($HTTP_POST_VARS['lastname']) . "\n"; $enquiry .= ' Company: ' . tep_db_prepare_input($HTTP_POST_VARS['company']) . "\n"; $enquiry .= ' PostCode: ' . tep_db_prepare_input($HTTP_POST_VARS['postcode']) . "\n"; $enquiry .= ' Invoice/Order Number: ' . tep_db_prepare_input($HTTP_POST_VARS['invoice']) . "\n"; $enquiry .= ' Enquiry: ' . tep_db_prepare_input($HTTP_POST_VARS['enquiry']);
  22. I noticed there are spaces after ?> at the end of each file in the module. Im having the same problems as mark though. Anyone got a solution ? Paul
×