Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PopTheTop

Archived
  • Posts

    879
  • Joined

  • Last visited

Everything posted by PopTheTop

  1. Look for this: for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) { You will see the CSS classes it is calling, I think it is <td align="right" class="smallText"> so you would edit smallText or make a new one and enter the new name in place of smallText
  2. This is NOT your correct path... /home/denterprises/desertoasismall.us/admin/includes/languages/english/invoice.php THIS is... /home/denterprises/desertoasismall.us/catalog/admin/includes/languages/english/invoice.php
  3. By the way, I received a PM from one of the team members here and this is what they had to say... "After our team meeting this morning, I've been asked to invite you to join the contributions moderator team. Your responsibilities would be..." I have accepted this invitation so you may start seeing me around more. Thanks to all of you for giving my contributions a chance and allowing me to help when I can! I am not a programmer by trade and only started with PHP last August, but learning more and more each day as you can see just from this contribution alone.
  4. I would not do that if I were you. Follow my instructions in the above post (the post just above this one) and you should be fine. If you just run the SQL command again then on some databases, those SQL commands may get imported twice into your database. If that happens, your store can and may freak out. You must delete the previous SQL imports FIRST, then import the updated ones in the install file of version 6.1
  5. Well, if you are having SQL errors, then you need to search for EMAIL_INVOICE and EMAIL_TEMPLATE_FILE in your database and delete/drop them from the database. Then import the following back in... INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Send HTML or Text Invoices to Customers', 'EMAIL_INVOICE', 'true', 'If this is enabled, order invoices will be sent to the customer in HTML format.<br><br>Enabled = true<br>Disabled = false<br><br>To use this, you must have HTML E-mails enabled.<br><br>', '12', '0', NULL , NOW( ) , '', "tep_cfg_select_option(array('true', 'false'),"); INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', ''); Then if you still have the problems, try replacing your files with the updated files in version 6.1 Then... If you still have problems, I am lost and need more info before being able to help you.
  6. Yes, this is very possible, but I am not going to be updating this contribution to do that myself so if anyone else would like a stab, please do so and post it here. I just do not have the time to do this right now as I am building 2 other websites with osC plus keeping mine going and updated.
  7. Fancier Invoice & Packingslip v6.1 Full Package Updates: - Fixed incorrect 2nd SQL import command - Fixed print_my_invoice.php, No more SQL errors when you print invoices in customer's My Account Get it at: http://www.oscommerce.com/community/contributions,2861
  8. To EVERYONE... There are NO SPELLING ERRORS in print_my_invoice.php, if you changed that file as posted to do so before by other members here, you must change them back!!!!!!!!! As far as the blank invoices printing blank, do you have any of the PayPal IPN contributions installed? If so, that is why.
  9. Ok, Ok... I finally found the error guys. Here is the fix, open print_my_invoice.php Look for: $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments, from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added"); Change to: $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added"); There was an extra comma inserted from another contribution I have on my site and when I removed it from this contribution, I forgot to delete the comma along with the deleted SQL coding. Anyway, it should be fixed now.
  10. Yep. and if you read the previous posts here and the contribution description, it also states that this is not compatable with any of the PayPal IPN contributions. But what's new, the PayPal IPN contributions conflicts with so many other contributions that one must think... Do I really need or want that?
  11. Not sure then because that is the correct SQL import commands. You may want to go into your database manually and delete them both, then import them again. 1) Load up the database, click on configuration on the left panel of the screen. 2) Then click on the BROWSE tab at the top right side of the screen. 3) Then click on the configuration_group_id column header to sort by configuration_group_id 4) Scroll down to you get to all the group 12. Find the 2 imported SQL stuff there and delete/drop them. Then re-import the SQL commands as in the installation instructions. Other than that, I do not know how to help you.
  12. What version did you install? Was it the latest version 6.0a or 6.0b?
  13. Use this one... INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Default E-Mailed HTML Invoice Template', 'EMAIL_TEMPLATE_FILE', 'html_invoice.php', 'Template file you will be using for HTML invoices to the customer<BR><BR><i>invoice.php</i> - Stock osC look<BR><i>html_invoice.php</i> - HTML version<BR><i>box_invoice.php</i> - HTML version<BR><BR>', 12, 0, NULL, NOW(), '', '');
  14. How can you save this info into the Edit Customer page inside the Admin. Some customers choose the wrong thing and I have to edit it in the database manually. That is a pain in my ^%#&*
  15. Fancier Invoice & Packingslip v6.0a Full Package Release Updates: - Added in the correct language define for print_my_invoice.php - Removed a section of coding from the Backorders MOD http://www.oscommerce.com/community/contributions,2861
  16. You are correct, I added the wrong language file to the package. I have added it in and will upload version 6.0a in a little bit...
  17. Thanks, I just updated this contribution to reflect your addition. I will have it uploaded soon. The new vrsion is 6.0
  18. No, not really because no one here knows what YOUR absolute path to your domain public_html folder is. You have to contact your hosting service provider and ask them what it is. Or go into your C-Panel for that domain and it should be shown there somewhere on the left side.
  19. What will this do? What are the changes you made?
  20. Well, it tells you right there that it can not find the language file invoice.php in the folder shop/admin/includes/languages/english Make sure you have uploaded ALL files in the correct folders. This is also in the installation file FAQ...
  21. No, no new language additions from v5.5 to v5.6. But your best bet is to use a file comparing program like WinMerge at http://winmerge.org to compare your files with the latest version files.
  22. Fancier Invoice & Packingslip v5.6 Full Release... Updates: - Added a new HTML invoice template (box_invoice.php) - Removed the stylesheet files and included the CSS code in the invoices themselves - Updated the installation file - Added a FAQ section to the installation file Download from: http://www.oscommerce.com/community/contributions,2861
  23. I am creating a new update - Version 5.6 This new update will have the new box_invoice.php with it and a new installation file. The new installation file now has a built-in FAQ to answer most of the problems posted here and how to fix them. It should be uploaded soon...
  24. It appears that multiple e-mail address can not be used here with this contribution.
×
×
  • Create New...