• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About hobbzilla

  • Birthday 09/19/1977

Profile Information

  • Real Name
    Ryan Hobbs
  • Gender
  • Location
    Texas, USA
  • Interests
    Basketball, Poker, Gaming, Movies, Programming, Sleeping spending time with the family!

Contact Methods

  1. I just wanted to drop in and apologize I have not been around here for a while. I hope some of you will be able to step up and assist and answer questions. Our youngest son, James (Jay) Kelly Hobbs, was recently diagnosed with Kawasaki disease and is currently in the Pediatric ICU in Dallas, TX. We are asking for all family, friends and anyone to pray for him. He currently has a dialiated right and left anterior descending (LAD) coronary arteries as well as a medium aneurysm in his LAD. He seems to be responding well to treatment but he is just 6 months old and still in the acute stages and are praying that the aneurysms and arteries do not progress with this disease. If interested, more information on KD can be found here: http://www.kdfoundation.org/ I am asking that anyone from this point on that was planning on donating for my contributions to instead donate to The Kawasaki Disease Foundation. Thanks and again -- sorry I haven't been around for a while.
  2. Error SQL query: ALTER TABLE `products_attributes` ADD `suffix_sort_order` int( 11 ) NOT NULL default '' AFTER `code_suffix` MySQL said: #1067 - Invalid default value for 'suffix_sort_order' FYI: Can't default an int() as a string ''. Must default it as 0,1,etc.
  3. Will this contribution allow something similar to: http://www.lumens.com/lumens/product.asp?d...AAAAANDBPDELLCF I am specifically looking for a unique attribute_id and not using the "placeholder" product_id.
  4. Ringo, This was address in the patch posted on Feb. 3rd. There are additional fixes you may wish to review in that patch.
  5. I have done this. It wasn't easy -- and I am the developer of M-S. I noted this in the installation instructions it is for the "clinically insane." Seriously, it can be done -- it will take you over a week to perform on a very heavily modified shop. Personally, I would suggest that you work your way up from M-S as the foundation and apply the modifications that you have already integrated one at a time and making them M-S compatible if it is needed... M-S is unfortunately too large and touches too many files to keep track of easily. I can assure you that you will need to revert to a backup before you are done with this task. Really makes you wish the code was more modular and allowed for add-ons instead of core hacks. Good luck and please report back with any issues you have. As far as the contributions that definately won't work.. I haven't come across one that I couldn't modify to make work. M-S is really simplistic in it's approach. There is just SOOO much to update and keep track of.
  6. PATCH uploaded Please try the price patch just uploaded: http://www.oscommerce.com/community/contributions,1730 Here is a patch diff output: /catalog/includes/classes/price_schedule.php 87,93c87,89 < if (!tep_not_null($customer_group_id)) { < $customer_group_id = VISITOR_PRICING_GROUP; < $check_group_query = tep_db_query("select customers_groups_type, customers_groups_discount from " . TABLE_CUSTOMERS_GROUPS . " where customers_groups_id = '" . (int)$customer_group_id . "'"); < $check_group = tep_db_fetch_array($check_group_query); < $customer_group_type = $check_group['customers_groups_type']; < $customer_group_discount = $check_group['customers_groups_discount']; < } --- > > if (!tep_not_null($customer_group_id)) $customer_group_id = VISITOR_PRICING_GROUP; > 105,107c101,103 < $this->thePrice = $prices['products_price'] * (100 - $customer_group_discount)/100; < $this->specialPrice = $prices['specials_new_products_price']; < if ($this->thePrice < $this->specialPrice) $this->specialPrice = ""; --- > $customer_group_discount < 0 ? $this->thePrice = $prices['products_price'] * (100 - $customer_group_discount)/100 : $this->thePrice = $prices['products_price']; > $customer_group_discount < 0 ? $this->specialPrice = $prices['specials_new_products_price'] : $this->specialPrice = $this->thePrice * (100 - $customer_group_discount)/100; > if ($prices['specials_new_products_price'] < $this->specialPrice) $this->specialPrice = $prices['specials_new_products_price']; 187,188c183 < $qty = 0; < return $qty; --- > $qty = 1; and catalog/specials.php 81,82d80 < $pf->parse($specials); //rmh M-S_pricing < $new_price = $pf->getPriceStringShort(); //rmh M-S_pricing 85c83 < echo ' <td align="center" width="33%" class="smallText"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials['products_image'], $specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . $specials['products_name'] . '</a><br>' . $new_price . '</span></td>' . "\n"; //rmh M-S_pricing --- > echo ' <td align="center" width="33%" class="smallText"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials['products_image'], $specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . $specials['products_name'] . '</a><br><s>' . $currencies->display_price($specials['products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($specials['specials_new_products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</span></td>' . "\n";
  7. Sure. Query the stores table for the configuration table value for shop1. Then with that result, query the configuration table returned for the STORE_NAME value and replace the "echo STORE_NAME" with an echo $store1_query("configuration_value") Thanks. Reviews & New products/What's new, categories, search, manufacturers should all be very easy to take out for the main store the filter for only showing the current store's values. Just edit the various SQL queries and remove the references to STORES_ID. Unfortunately, I never built or designed the MS contrib to be used for a "mall" purpose (I believe there is another contrib that attempts this..) It was originally designed to ease store administrator's who wanted multiple shops to sell stuff on. The ability to have a super store (or mall) is just an implementation of another store with all products enabled for it.. however making it fully "aware" to the existance of the other stores was never intended or needed by myself, however with a little work, you should be able to transform some of the queries for the super store to not take into account the STORES_ID, you should continue to get closer to what you are needing. Sorry haven't used these specific ones, what exactly are you have issues with? Might want to discuss them with the developers of those contribs as well for their input.
  8. I am assuming the category links go to the respective store URLs.. This should be able to be accomplished with a specialized loop -- you won't be able to reference any variable in the main store for this -- it must be custom created for the page you are wanting this displayed on. Go and grab all the stores from the stores table. Looping through each store result, querey the categories table and build the category tree (there is a tep function for this) and display the result of the catgory appended to the url of the store (from the top level store query) and you should have your links to the cat's subcat's of the various stores.
  9. Your specific example is not how MS is designed. You will only have 1 database and not 4 with the big store connecting to multiple datasources. However, with MS you can have 4 different stores, that all look different, have different products, and are administrated by a single admin installation. A fifth store "BIG Store" could have all the product from all the various stores enabled for it, yes. The only thing I can suggest is that you try it. I am in the process of getting my site back online and will try and get a demo setup for the MS.
  10. English is the default language for the stores as well as the language for the admin by default in osCommerce stock. Did you double check to see that the other language for the store that you were trying to set as the default was actually enabled for the store you were trying to set for it? Also please note that currently there is a limitation with the currency class that makes you have the same currency set as the default for all stores.
  11. check price_schedule.php and make sure that the the query around line 150 isn't missing an " ' " around one of the two statments AND s.stores_id = '" . STORES_ID . "' You SQL statment is failing right there: ..IF(s.status = '1' AND s.stores_id = 1'.. (<- do you see the missing quote?)
  12. That sounds about right. I really didn't change much in the banner section so I know very little about the banners modules/files.. although they certainly don't seem that complex! Good luck with your efforts and kudos for finding the issue causing problem.
  13. Sounds like you don't have english as your default language for your admin... and have not updated your admin language files to add the MS specific entries. In English that error message indicates: "Error: The default language can not be set. Please set a language enabled for this store, and try again." Basically, you can't set the default language for a site until that language that you are trying to set as the default is actually assigned to that store (with the STORE button). HTH
  14. Can you please reply with your version of php & apache as well (or even you version of Xampp -- I think I can lookup the versions they use on their site). Again, _everytime_ I have seen the reloading of the admin page after entering the correct admin user/password and it doesn't let you in, it was a configuration issue (or someone that had updated and included another contribution and had messed something up). Double check your cookie & session paths as well. You have also verified that the password in the db is the same as the original in the update.sql? You could possibly try and change the password manually in mySQL for that specific field. Make sure you tell it to use MD5 as the function.
  15. Have you made sure that Admin-Configuration-MS has been setup for paths correctly for each store?