Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

About DuFF1

  • Birthday 10/26/1976

Profile Information

  1. DuFF1

    Country-State Selector

    Here's what's on line 163 (in HTML result) request.open("POST", 'create_account.php', true);
  2. DuFF1

    Country-State Selector

    Anyone having problem with Country-State Selector v1.5.5 (AJAX) since upgraded to PHP 5.2.8 and MySQL 5.1.30 or maybe when using mysqli? The country list is displayed, I can change country, but nothing happen on State list.
  3. DuFF1

    [Contribution] Purchase Order V2.3

    I solved my problem by changing my sql-mode in my.ini sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Give me a feedback by PM with your sql-mode before if it's working for you too!
  4. DuFF1

    [Contribution] U HTML Emails

    How can I add Ultimate Html Emails v2.1 in admin/mail.php?
  5. DuFF1

    [Contribution] U HTML Emails

    How can I add Ultimate Html Emails v2.1 in admin/mail.php?
  6. I added a dropdown field where the customer can choose his Job Title... Presently, the field number is stored instead of the field name. How can I store the field name instead the field number? <...> $job_title = tep_db_prepare_input($HTTP_POST_VARS['job_title']); <...> $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_job_title' => $job_title, 'customers_email_address' => $email_address, 'customers_telephone' => $telephone, 'customers_fax' => $fax, 'customers_newsletter' => $newsletter, 'customers_password' => tep_encrypt_password($password), 'customers_status' => $cust_status); <...> <tr> <td class="main"><?php echo ENTRY_JOB_TITLE; ?></td> <td class="main"><?php $job_title_array = array(); $job_title_query = tep_db_query("select job_title_id, job_title_name from " . JOB_TITLE . " order by job_title_name"); while ($job_title_values = tep_db_fetch_array($job_title_query)) { $job_title_array[] = array('id' => $job_title_values['job_title_id'], 'text' => $job_title_values['job_title_name']); } if (count($job_title_array) > 0) { echo tep_draw_pull_down_menu('job_title', $job_title_array); } else { echo tep_draw_input_field('job_title'); } if (tep_not_null(ENTRY_JOB_TITLE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_JOB_TITLE_TEXT; ?></td> </tr> <...>
  7. DuFF1

    [Contribution] Purchase Order V2.3

    Since I upgraded to MySQL 5.1 (from 4.0), here's the error I'm having at the checkout if the customer don't use credit account: 1265 - Data truncated for column 'customers_credit_left' at row 1 insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, purchase_order_number, customers_credit_left, customers_credit_amount, currency, currency_value) values ('2', 'Patrick Dufresne', '', '1488 Sherbrooke', '', 'Montréal', 'H2L 2K8', 'Québec', 'Canada', '514-555-5555', 'nomail@hotmail.com', '2', 'Patrick Dufresne', '', '1488 Sherbrooke', '', 'Montréal', 'H2L 2K8', 'Québec', 'Canada', '2', 'Patrick Dufresne', '', '1488 Sherbrooke', '', 'Montréal', 'H2L 2K8', 'Québec', 'Canada', '2', 'Paiement comptant à la livraison', '', '', '', '', now(), '1', '', '', '', 'CAD', '1.00000000') If I use the credit account, the order is correctly sent because there's a value in the customers_credit_left. I know that MySQL5 no more accept empty field but I don't know how to solve this problem. Here is the field in MySQL: `customers_credit_left` decimal(9,2) NOT NULL DEFAULT '250.00'
  8. DuFF1

    Canada Post Shipping Module

    It only happen when I select the 'fr' (instead of 'en') language in the module setting.
  9. I installed the Canada Post Shipping Module v3.9 but I'm getting a problem when choosing expedition mode. In the checkout, I have three choice: Priority Courier, 2008-05-27 14.30$ Expedited, 2008-05-27 6.80$ Regular, 2008-05-28 6.80$ But if I select Expedited and press for the next step, the page load and come back to the expedition page. All the others choice are going to the next step. Anybody already solved this problem? Thanks!
  10. DuFF1

    PDF Catalog v.1.5

    I asked this question in the FPDF.ORG forum and the answer is: "HTML code are not supported in FPDF." If you are using a WYSIWYG editor for your description, any characters with accent are translated in HTML code. On my side, I decided to remove the WYSIWYG editor to solve the problem. But here's a solution somebody post me but I did not tried it! Try get_html_translation_table() before sending the strings. Exemple "não" into "não": $string = "não"; $entities = get_html_translation:tabe(HTML_ENTITIES); $translate = array_flip($entities); echo strstr( $string, $translate);
  11. The contrib seem to work well but I'm having this little problem: No visitor or customer are listed in the list until I press the green light for "Include Robot".
  12. I solved my problem, I needed to remove "$" in front of "$parent_category_name" in catalog/pdf_catalogue_info2.php like in catalog/admin/pdf_catalogue.php as mentionned somewhere in the forum. Using PHP5 cause this problem. http://forums.oscommerce.com/index.php?sho...d=1037669
  13. DuFF1

    PDF Catalog v.1.5

    I found the problem on my side. I needed to remove "$" in front of every: $parent_category_name to parent_category_name in /catalog/pdf_catalogue_info2.php like done on my /catalog/admin/pdf_catalogue.php All this cause by PHP5
  14. I'm having problem with CanadaPost Shipping Module. Here's the choice I have for expedition: If I select the first or third choice, everything is correct. If I select the second choice, when pressing the next step, it always get me back to the shipping page without any selection of expedition. Anyone have an idea of the problem?
  15. Anyone know how to transform this contribution to show horizontal list of each options instead of a drop-down list? http://www.oscommerce.com/community/contributions,4174 Color: Blue, Red, Green Size: Small, Medium, Large Sex: Male, Female Thanks!