Jump to content

Skittles

♥Ambassador
  • Content count

    355
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Skittles

  1. Hi all! If you are familiar with Optional Related Products Ver. 3.3, you know that I have stepped up to support and continue development of this useful contribution. There have been numerous requests for features, and I have tried to incorporate them in what is about to be a new release. I've made some serious changes to Optional Related Products for Version 4.0! There are changes in the Admin and how it works, giving you more control over the looks and function; There are display options reminiscent of the product listing options, where you can decide what details to display on the page. The Optional Related Products code is now a module called by an include statement in products_info.html. I am currently looking for a few beta testers! I need a couple of shop owners that have never installed the contribution, as well as one or two who would be upgrading. If you consider yourself a newbie to osCommerce, you're feed back could be invaluable in creating an installation guide that takes some of the pain out of the installation process. Don't be shy. I'm looking for feedback on the installation procedure: Were the instructions easy to follow? Was everything there, etc. The 'package' you'll receive is complete, except for a 'User's Guide" which I've just recently decided to create. (The user's guide is not needed to install the contribution. It will only explain what the various options are, how and why/when to use them.) If you are interested in beta testing Version 4.0, please leave a post in this thread, and I'll PM you with further information. I am hoping to release Version 4.0 no later than next Friday (02/23/2007). Thanks in advance for your time. -Skittles
  2. Within a few minutes of this post, I will be uploading the contribution "Zone Shipping by State, Ver. 1.0". I am starting this thread first so I can include the URL of this topic with the contribution description. Once the file is posted, I'll come back and include a link to the contribution. This contribution is specifically for shipping within the United States and the only language file included is for English. (Sorry, I'm not bi-lingual...) However, it should be relatively easy to modify for use in other countries. This contribution can be used alone, or with the standard zones.php included with osCommerce, with a simple one line modification to zones.php. When used together, only one or the other will display, based on the country of the shipping address. This contribution is working on a site that is days away from going live, at which time I'll post the URL. -Skittles The contribution is here: http://www.oscommerce.com/community/contributions,4703
  3. Skittles

    FedEx - Web Services v9

    Thank you for that. And perfect timing for me. I hadn't tried to use Order Editor since getting this installed. But I use OE whenever I ship an order. (I've rearranged things on the page, a bit, so I can just tab through the fields and copy the information in the order I need it to create a shipment online.) I'd have been very unhappy to lose OE's function. After applying the fix, I tested the checkout_shipping page, and everything there worked just as it did before the fix. I figured you had tested that, but I hate to assume things... :) I'm sure there are a lot of others who will be just as happy to find your fix. Kudos. And thanks again.
  4. Skittles

    FedEx - Web Services v9

    I ran into a bit of a problem when I first installed this, but it's working now. I think I may know what that problem was, and I'm putting it up here in case anyone else is having touble getting this contribution to work. First, I installed the contribution, and had FedEx tech support on the line as I filled out their forms and got the module installed. (By the way, if you are installing this for your own website, you select "Corporate Developer". Not particularly intuitive there...) Attempts to get a rate quote sent the FedEx Web Services Key, Password, Account Number, and Meter Number. However, according to the technician, there were no rate requests. He told me that even if there was an error in the request, any request at all would have shown up. As far as I could tell, the only thing the install instructions said to do that I hadn't done, was to remove the old FedEx module. I had set it to 'false', but not actually removed it from the database. After I removed the old FedEx Shipping module, the FedEx Quotes started working.
  5. Skittles

    Multi_Vendor_Shipping new thread

    I just pulled the checkout_process file from the mvs_1.3_for_osC2.3.1.tar archive, and could not find "$order_id = $insert_id;" any where in the file. Files in the archive are dated early February. Yes, our line numbers are different, sorry... in the file from the archive, it is line 240 where 'vendors_id' => $order->products[$i]['vendors_id'] is added but not commented: // Update products_ordered (for bestsellers list) tep_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . tep_get_prid($order->products[$i]['id']) . "'"); $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty'], 'vendors_id' => $order->products[$i]['vendors_id'] ); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $order_products_id = tep_db_insert_id(); //------insert customer choosen option to order-------- Maybe seeing it in the surrounding code will help. This is only an issue, of course, for people who need to modify the file as they've already modified it for other addons. Anyone just uploading the files won't have the line missing. Is there a later archive than February 5, 2012? -Anita
  6. Skittles

    Multi_Vendor_Shipping new thread

    Bug report for checkout_process.php, MVS for osC 2.3.1 MVS edits refer to the order ID as $order_id. However, osC is using the variable $insert_id. A quick find and replace, and now the order IDs are being stored correctly. Also, around line 254, $sql_data_array for orders_products has the vendor_id added to the array. However, there is no "//MVS" to help you find it when making mods to existing files by searching on "MVS". I have admin/vendor_email_send.php working: sending emails, and updating the database to show vendor email has been sent. I'll be emailing you that file later today, Jim. Back to the grindstone. :) -Anita
  7. Skittles

    Multi_Vendor_Shipping new thread

    Jim, Thanks to your help, I located the troublesome bit of code and I've created a work-around. Last year, I spent about six months modifying a number of 2.2 contributions for osC 2.3.1 and created my own install version. One of the addons is Order Editor. As you may already know, Order Editor stores the shipping method along with the order. That one line of code was the problem. It wants to put $shipping['id'] into the $sql_data_array for the order table, but with MVS enabled, $shipping['id'] is empty. so I changed 'shipping_module' => $shipping['id'], to 'shipping_module' => (SELECT_VENDOR_SHIPPING == 'true' ? 'MVS' : $shipping['id']), and the error is no longer showing up. I've learned an invaluable troubleshooting trick. Die; Something so simple, I feel rather sheepish it never occurred to me. In my defense, I admit, I was pretty frantic... not much of an excuse, but the only one I've got... :) Thanks again for your timely help, and the generosity of your time. -Anita
  8. Skittles

    Multi_Vendor_Shipping new thread

    As I mentioned before, the code works on my XAMPP server, so I decided to run the debug code there. I get the same thing. So on one server, an empty array is ignored, on another server, it causes an error. So I'm thinking in the long run, it's a good thing it caused the error now, instead of somewhere else down the line. In spite of how annoying it is. Thanks for you help. I'll keep you posted. Still chuckling, -Anita
  9. Skittles

    Multi_Vendor_Shipping new thread

    Well, it didn't give me much... lol... Array found! ;Array ( ) ; I guess I'm going to need to try something else... After I stop laughing. -Anita
  10. Skittles

    Multi_Vendor_Shipping new thread

    Thank you. I'll go try it now... -Anita
  11. Skittles

    Multi_Vendor_Shipping new thread

    Hi JIm, Thanks again for the speedy response. MVS is the only addon I used that modified the checkout_process. When I put back the unmodified file, the order goes through without any problems. The PHP on the HG server is actually 5.2.17. My XAMPP server is running 5.3.0. The mysql on the HG server is newer, 5.5.19, whereas I'm still running 5.1.37... As I'm completely self-taught at PHP, (and only proficient with osCommerce,) I have no 'debug code' experience. Do you have a script or something that you could share? Thanks, -Anita
  12. Skittles

    Multi_Vendor_Shipping new thread

    Hi Jim, Sorry I haven't been back sooner. Between work and virus (human variety) I haven't had a chance to work on any of the files. I have a bug report: in both the checkout_confirmation and checkout_process files, there is an if/elseif statement that is a problem if (($total_weight &--#62; 0 ) || (SELECT_VENDOR_SHIPPING == 'true') ) { include_once(DIR_WS_CLASSES . 'vendor_shipping.php'); } elseif ( ($total_weight &--#62; 0 ) || (SELECT_VENDOR_SHIPPING == 'false') ) { include_once(DIR_WS_CLASSES . 'shipping.php'); } As an OR statement in the first condition, the first if will always be true when there is any weight to the order, regardless of whether MVS is enabled or disabled. I removed the weight statement completely, but if you need it in there, then it should be an AND statement if (($total_weight &--#62; 0 ) && (SELECT_VENDOR_SHIPPING == 'true') ) However the second condition should probably just be an 'else' as osCommerce needs the shipping class to continue the checkout process. That code is added towards the top of both files. And I have a question. I have MVS working just fine on my XAMPP development server on my own computer. Because the client "absolutely" requires this functionality, and MVS is the only addon that does it, this is also on a HostGator server where we've been developing a site for the client. And finally, it is on yet another HostGator server where the site is poised to go live... But we've run into a snafu... The checkout process appears to be adding everything to the database as expected. It is sending the customer email. We do not have it set to send vendor emails. In fact, all the options are set to false. Before redirecting to checkout_success, however, it sends the error "Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/username/public_html/catalog/includes/functions/database.php on line 132" I've never seen this error before, and while I understand what it wants, I have no idea where to start looking. As I said, I do not get the error on my XAMPP server with the exact same files. Any light you can shed on this would be greatly appreciated. Thank you again, -Anita
  13. Skittles

    Multi_Vendor_Shipping new thread

    You're welcome. I'll keep in touch as I go along. Talk to you soon, -Anita
  14. Skittles

    Multi_Vendor_Shipping new thread

    Jim, I have spent over 8 months, now, converting 2.2 contributions over to 2.3.1 for client work. I'd be happy to help with this project. If you'd like, I can convert the admin files ('Vendor Manager', 'Product Reports', 'Vendors Orders List', 'Move Products between Vendors') over to use the jquery buttons and so on. I'm not familiar with this contribution except for this recent install, so I'm not comfortable working on the code side of things (yet.) But I can take some of the pressure off by getting these files up to par with the current osC Admin environment. I'll be doing it anyway, with some modifications for my client, and it wouldn't take much to come up with these files for your next distro of this addon. Just let me know. -Anita
  15. Skittles

    Multi_Vendor_Shipping new thread

    I'm sorry, Jim, I didn't see an email in your profile. Here are the line numbers where these two fields are used: 376, 377, 393, 394, 952, 954, 964, 981, 983, 993 -Anita
  16. Skittles

    Multi_Vendor_Shipping new thread

    Brian, The easiest way I have found to 'remove' a module (shipping, payment, etc.) is to change the extension from php to txt. In the case of this file, you would go to [path/]catalog/includes/modules/vendors_shipping and change upsxml.php to upsxml.txt. (Do not leave .php as part of the filename, or the code will still 'see' the file.) Now you have effectively removed the file from your osCommerce install, without actually removing the file. Then when you need it, it's not hard to find. Jim, I found two product table fields in categories.php that aren't used anywhere else on my install, `products_sort_order` and `products_qty_blocks`. They only show up in this file, and I don't see them actually being used. I assume then, that they are support for other contributions. I removed them from my heavily modified copy of categories.php. If you'd like, I can modify a copy of your file, and email it to you. Just PM me at your convenience with an email address, and I'll get it to you shortly. -Anita
  17. Skittles

    Admin Panel format broken

    The Admin Theme Switcher can be downloaded from here: http://addons.oscommerce.com/info/7749 I installed it on non-modified development install and it works like a charm. -Anita
  18. Hi All, It's been a long time since I was active here. Just been busy doing non-osc stuff. But... I'm back to working on osCommerce, and I'm modifying a number of contributions to work with my v2.3.1 install. Among other things, I've installed the Admin Theme Switcher and I've been changing image 'submit' buttons over to the new jquery buttons to take full advantage of the switcher. I ran into a big snafu with Header Tags SEO, though. Turns our the update function on one of the pages uses the 'x' value sent when clicking on the image... but there isn't an 'x' value sent with the jquery button. I'm sure most contributions do not utilize this technique, but it is something to look for if your jquery submit button doesn't work. In this case the code was if (isset($_POST['x']) But it could just as easily have been if (isset($HTTP_POST_VARS['x']) and of course, such a 'flag' could also use the y coordinate. So if your converted button doesn't submit, I recommend doing a quick search for ['x'] or ['y'] (including the brackets,) to eliminate that possibility from the list of things that could be wrong. If you find it is being used, you'll have to find something else to replace it with. You may be able to find a key/value that is being used as part of the if/elseif statement, like I did. Or you may need to add a hidden input with a value to test for. I hope this information will save some of you from the hours of frustration I went through where none of the 'usual suspects' were causing my problem. And if anyone else has an image-to-button 'ah-ha' moment, please feel free to add it here. It would be cool to have a single thread that answers our questions about converting over to the jquery button. Cheers, -Anita
  19. Skittles

    ULTIMATE Seo Urls 5 - by FWR Media

    I found my problem. The last php end tag was missing in additional_uploads\version2.3\catalog\includes\modules\boxes\bm_languages.php (I checked, and it's missing from the file in the archive I downloaded.) Originally, after completing the install, the site wouldn't open at all. I commented out sections of code until I found the one that was causing the problem. That was the code added to application_top.php placed just above "require(DIR_WS_LANGUAGES . $language . '.php');". That should have clued me in... Anyway, once the end tag was added to the bm_language.php file, and the the additional code in application_top.php was active, the seo urls started working. Thankfully, I didn't have to start over with installing contributions... Robert, this is a massive undertaking, and I appreciate all the hard work you've put into it. It was inevitable that a few small things would show up. I found it, I fixed it, I'm a happy camper. Thank you, thank you, thank you! -Anita Cross
  20. Skittles

    ULTIMATE Seo Urls 5 - by FWR Media

    Just to be thorough, I setup a clean install, and followed the directions for the "Drop on Top Quick Install". With this install, the SEO URLs are working. I'm off to see if there is anything different in the install files. If not, I'll reinstall each of the contributions on this new install until I find the conflict. I'll let you know what I discover... Thanks for you time, -Anita Cross
  21. Skittles

    ULTIMATE Seo Urls 5 - by FWR Media

    Hi Robert. Thank you for the work you have put into this contribution. This is my first time working with any version beyond Chemo's version 2.2d and I'm running into a problem. First, this is a new site. I am using osC v2.3.1, and installed the following add-ons prior to installing ULTIMATE Seo Urls 5 Pro - by FWR Media (r205): AJAX-AttributeManager-V2.8.9.2 ot_discount_coupon_codes_3_34_osc2.3 GoogleFeeder_V_2.8 HeaderTags_SEO_V_3.2.5 Monthly Sales Report V 1.6 order_editor_for2.3_v1.1 priceSort Supertracker v3.2b I have been doing the work on an XAMPP local development server. After completing the installation following your instructions for "installing to a modified osCommerce version 2.3 ( no existing Ultimate Seo Urls present )", I opened the install_complete.htm file. Following the instruction on that page, I visited the front page of the store, but no SEO URLs were displaying when hovering over links. I am using Firefox v3.6.17 for site development. I've closed the browser (which in my case, clears the cache) and reopened it, then reopened the front page, but the SEO URL links are still not there. I've tried changing various settings in configuration, but see no changes to the links. Following your instructions, I updated my .htaccess file and tried the rewrite options in the configuration settings. At this point, I decided to see if it was something to do with a local install, so I installed this site in it's current state to my server. However, I'm having the exact same problem. (Here's the test domain-- http://www.treasuredsilkflowers.com ) I've accessed the site from the following os/browsers: WinXP/Firefox v3.6.17 WinXP/Internet Explorer v8.0 Win7/Firefox v4.0.1 Win7/Google Chrome v11.0 Win7/Internet Explorer v8.0 And I've accessed the local on WinXP from these browsers: Firefox v3.6.17 Internet Explorer v8.0 The links do not seem to work anywhere. So the question is, have I managed to screw up the install, or is there something different in v2.3.1 over 2.3 that I need to change? Thank you in advance for you help. -Anita Cross
  22. Skittles

    Optional Related Products, Version 4.0

    The mws_header function is part of the Graphical Borders contribution. Without spending time digging through code I haven't looked at for months, I'd say you installed the optional code found in the Graphical Borders 2.1 folder instead of the core code. Try replacing the installed module with the module located in the catalog/includes/modules folder of the installation files. -Skittles
  23. Skittles

    Optional Related Products, Version 4.0

    For anyone following along with this thread, Kona Bean contacted me by PM and we discovered the source of his problem. Somehow, he managed to be working from version 3.3-c instead of 4.0. After jumping through a couple of hoops, he has it up and running. -Skittles
  24. Skittles

    Optional Related Products, Version 4.0

    jond, Try downloading Optional Related Products 3.0.1 from the contribution page. It looks like that was the last version before the layout was changed from a product listing type display. You will need to integrate the options from version 4 with the old layout. Keep us posted as to how it's going, and ask questions here if you get stuck. -Skittles
  25. Skittles

    Optional Related Products, Version 4.0

    jond, The layout is essentially controlled by options in the Configuration: "Define Number of Items Per Row", "Define Number of Items to Display", and "Split Display Into Rows". "Split Display Into Rows" should be set to 'true' for multiple rows. Any number greater than 1 in the "Define Number of Items Per Row" will produce a Horizontal (left to right) display of products. To get a Vertical (top to bottom) display, set the "Define Number of Items Per Row" to 1, then use the "Define Number of Items to Display" to set the total products displayed. For example, if you want 3 products showing, set the "Define Number of Items to Display" to 3. Horizontal works well under the product listing, while vertical works well in the right or left column. -Skittles
×