Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by spoofy

  1. I am not the author of the code. I simply modified the code which was originally done by Chemo and further modified and kept up to date by Jack_mcs. This contribution is taken from http://addons.oscommerce.com/info/6583 Thanks to Jack_mcs for providing the upgraded versions. The problem with Jack_mcs contribution, which was originally authored by Chemo, was that all the links and database actions were hard-coded. This created a problem if you were trying to use this with FWR Media's Ultimate SEO URL. FWR Media does provide a Google XML Sitemap SEO however, that version is a bit outdated. The attached version is based on Jack_mcs's latest version 1.5 Code has been tested to work for v 2.2 and v 2.3 of osCommerce. Download Contribution: http://addons.oscommerce.com/info/7610
  2. Not really a solution geared for oscommerce users. We have talked about this internally within our company for months now to come up with the best possible strategy to handle multiple stores and here is what we finally decided... We are either building or converting stores from other platforms to our extremely modified oscommerce cart. What this means is that from a business perspective we are working our a*ses off to build and nurture the assets. If and when we were to decide to let go of one of the stores or some of the stores we want it to be extremely easy and simple. With that being said each of our oscommerce stores are independent and the way we will tie them all together is building a "master" admin system which will allow us to manage each store's database. Manage products, orders, customers etc. Again this was just in the discussion phase, so not really sure how practical this approach will be or if there will be any complications.
  3. Recently, while working on cutting down mysql queries, I came across 2 functions which were on php.net *I am not the author of this code* I simply changed a few things around. Installation: open up /includes/functions/html_output.php towards the end insert these 2 functions: //// // Two very nice functions for searching array by either a key or by a value function tep_search_array_by_key($array, $key, $value) { $results = array(); if (is_array($array)) { if ($array[$key] == $value) { $results[] = $array; } foreach ($array as $subarray) { $results = array_merge($results, tep_search_array_by_key($subarray, $key, $value)); } } return $results; } function tep_search_array_by_value($array, $value) { $results = array(); if (is_array($array)) { $found = array_search($value,$array); if ($found) { $results[] = $found; } foreach ($array as $subarray) { $results = array_merge($results, tep_search_array_by_value($subarray, $value)); } } return $results; } These functions are meant to be used by those who understand it's arrays. Basically the idea is that in shot you can store data from mysql queries in an array and the loop them and do a search either by key or value. I am sure there are numerous places it can be used in the admin end as well but I haven't gotten around to that yet.
  4. Hey Steve, Should we go ahead and add the new Bing/Yahoo bot called "bingbot"
  5. spoofy

    Exploded view of a product

    Yes its possible. You have to use Master Products contribution. As for linking the images so they are clickable for each part, that's something I believe has to be manually done.
  6. spoofy

    Static pages manager / v2.3

    Look up the contribution called Information Pages
  7. Robert, I understand that $_GET can be used in forms as well but login.php create_account.php and checkout related files all use the post method. Am I correct? Also, can you give some specifics as to why you feel that it is not appropriate to use Security Pro code for $_POST ? I have done a lot of testing to ensure that all the bad data is cleansed and that we do not loose any good data from the forms by using the method mentioned above. Your input is greatly appreciated. Thanks
  8. Dan, That's because Security Pro is NOT supposed to cleanse anything which is form related ($_POST). It is only meant for $_GET You will need to install the following to get the forms to work: http://forums.oscommerce.com/index.php?showtopic=313323&view=findpost&p=1477869
  9. Sorry can't help you further in terms of operations as I have not tested either of the contributions.
  10. spoofy

    Best seo addons?

    IMO Isabella, I much rather prefer to use Robert's USU5 Pro. I have tested it with over 75k products and it works flawlessly. Making modifications is a piece of cake. And it is very very stable. I haven't come across any other contribution which has interfered with USU5 Pro.
  11. In your database, you are missing the column "shipping_methods" in table "products" Please re-read the instruction for both the contributions to see how to add the column.
  12. spoofy

    ULTIMATE Seo Urls 5 - by FWR Media

    Robert, We launched the first version of our new store with your new USU5 Pro. The store has a fairly large amount of products in a very complex breakdown of categories. We easily modified quite a few thing in your USU5 Pro and so far it has been very stable. Thanks for your great efforts and contribution!! :thumbsup:
  13. spoofy

    ULTIMATE Seo Urls 5 - by FWR Media

    IMO, you are better off creating a different 404. What I have done is basically created a replicate of shipping.php into 404.php so that I can possibly do something in the future, such as catch the errors and show related products etc.
  14. spoofy

    ULTIMATE Seo Urls 5 - by FWR Media

    Shaun, You don't have to install any other contribution. Simply add the following to your .htaccess in your main folder generally /home/xxx/public_html/ ErrorDocument 404 /404.php Make sure that you have a 404.php file
  15. spoofy

    ULTIMATE Seo Urls 5 - by FWR Media

    To setup a custom 404 error page: open /catalog/includes/modules/ultimate_seo_urls5/includes/notfound_404.php
  16. Well, the error is saying that there should be a column manufacturers_id in table "products" You have to access your database (phpmyadmin) and go to the table of products and see why is that column "manufacturers_id" missing. I don't think any contribution is supposed to delete any columns. So can't tell you how it happened. A simply fix would be to add the column via phpmyadmin
  17. I have used both of these: http://addons.oscommerce.com/info/4513 http://addons.oscommerce.com/info/4385
  18. I dont think there is any addon available that can do that but if you are trying to display all the products on the front page with just the names and link to the product, then it shouldn't be that hard to do. You will need to do some basic php coding
  19. The contribution is also live in the Add-Ons sections: http://addons.oscommerce.com/info/7790
  20. Problem- Product: Running Shoes In Categories: Red Shoes Blue Shoes The issue occurs when you create a product in let's say Red Shoes and link it in Blue Shoes. When a customer is browsing the category Blue Shoes and goes to the product Running Shoes, the bread crumb trail and the menu on the left hand side is highlighted as Red Shoes. This is because the product resides in the category of Red Shoes. Accurate to an extent, but the idea of bread crumb is to show the user how he/she got there. Solution- With this small addition which checks for referers will work 97% of the time based on some stats I picked up on some webmaster blogs and forums. For the remainder 3% it won't work but you have nothing to loose. Please note that this modification only works if you are using the Ultimate SEO URLs by FWR Media. It is compatible with the old version USU5 and the new one USU5 Pro. open /catalog/includes/functions/general.php find: function tep_get_product_path($products_id) { immediately after that, paste the following code: // we will check to see if a referer is available. // if a referer is available we will explode it to ensure that any parameters such as ?action=blah are not used if (isset($_SERVER['HTTP_REFERER'])) { $referer = $_SERVER['HTTP_REFERER']; if (stristr($referer, '.html?')) { list($referer, $query_string) = explode("?", $referer); } } else { $referer = 'Referer Not Available'; } // we will check to see if the referer matches with our url // we will also check to see if the url has -c-2.html or -c-2_1.html (used for defining categories) // if it matches, then we will extract the value for the category path and assign it to $cPath if ((stristr($referer, HTTP_SERVER . DIR_WS_HTTP_CATALOG)) && (stristr($referer, '-c-')) && (stristr($referer, '.html')) && (preg_match('/-c-(\d+(?:_\d+)?)\.html$/i',$referer))) { preg_match('/-c-(\d+(?:_\d+)?)\.html$/i',$referer, $matches); if (isset($matches[1])) { $cPath = $matches[1];} else { } } else { About 14 to 18 lines below that you will find } return $cPath; } Replace that with: } } return $cPath; } And voila! you are done.
  21. spoofy

    Ultimate Seo Urls 5 Pro

    Ya. Sorry I should've clarified that I am requesting you to do any work. I just wanted to show you what I have so far and get your thoughts on it. My coding skills are nowhere close to yours but perhaps I can put together something decent and workable, so you can review it. I will give this some thought and get back to you. Thanks for your input so far!
  22. spoofy

    Ultimate Seo Urls 5 Pro

    Hey Robert, I am posting here regarding the rewrite htm module. I haven't had a lot of time to work on this but here is my initial reaction. Please feel free to provide some feedback. Priority: Category Structure Products Info Structure Category Examples: Category: Hardware Category: Music -SubCategory: Dance -SubCategory: Techno Category url structure would be: domain.com/Hardware domain.com/Music domain.com/Music_Dance domain.com/Music_Techno Product Examples: Hardware Dell XPS 5000 Microsoft Mouse Dance Dance Now Product url structure would be: domain.com/Hardware.htm domain.com/Dell-XPS-5000.htm domain.com/Microsoft-Mouse.htm domain.com/Dance-Dance-Now.htm Solution Reasoning: Notice that I have 2 identical names. One is a category and the other is a product. But by getting rid of .htm in category url we can determine if the user is trying to access a category or product. Pseudo code: if (in url exists ".htm") { it's a product } elseif (in url !exists ".html) { it's a category } else {} What are you thoughts on this so far?
  23. spoofy

    ULTIMATE Seo Urls 5 - by FWR Media

    Done. Sent you a pm with my email address. I have added watch topic for development thread and will post there
  24. Good point. You are correct. I guess I will have to extend the session life a bit more. By the way thank you for another great mod!
  25. Jim, Thanks for your support on this great add-on. I am just wondering out loud. Currently my shopping_cart session is extended to 7 days. However, recently viewed should be extended to 14 days. Wouldn't it better if the data for recently viewed was stored in cookie rather than session? What is your opinion on that?