Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

monkster

Pioneers
  • Posts

    9
  • Joined

  • Last visited

About monkster

  • Birthday 03/18/1960

Profile Information

  • Real Name
    Father Parthenius
  • Gender
    Male
  • Location
    Boston

monkster's Achievements

  1. gchrt, Ever get a solution to this? I am attempting to integrate an sppc modified shopping_cart.php with Add Weight to Products v0.2. In other words, I must have separate pricing per customer and attribute weights (for shipping) working together. For catalog/includes/classes/shopping_cart.php, in the add weight contrib we have: if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $attribute_price_query = tep_db_query("select options_values_price, price_prefix, options_values_weight from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$prid . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'"); which corresponds to this in the sppc contrib: if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); $where = " AND (("; while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $where .= "options_id = '" . (int)$option . "' AND options_values_id = '" . (int)$value . "') OR ("; } $where=substr($where, 0, -5) . ')'; $attribute_price_query = tep_db_query("SELECT products_attributes_id, options_values_price, price_prefix FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = '" . (int)$products_id . "'" . $where .""); Obviously, some tweaking of $attribute_price_query is needed, but I still have not come up with the solution. Any help or pointers are appreciated.
  2. is working on a custom inventory solution

  3. A little historical note here... Oops. Posted to the wrong place. It should have gone here: http://www.oscommerce.com/forums/index.php?showtopic=299524 Of the two items mentioned, the second one was fixed in the latest version. The first item is still not fixed, but is also not hard for people to figure out themselves. Just a typo, really.
  4. I installed this recently and found 2 bugs in the latest full package v2.2. wrong path line 111 in the readme is: 5) catalog/admin/includes/categories.php it should be: 5) catalog/admin/categories.php wrong name line 42 of cron_update_bestsellers.php is: tep_db_query("UPDATE " . TABLE_PRODUCTS_YEARLY_SALES . " SET products_[b]trans[/b]_365 = '" . $best_sellers['sales_count'] . "' but it should be: tep_db_query("UPDATE " . TABLE_PRODUCTS_YEARLY_SALES . " SET products_[b]sales[/b]_365 = '" . $best_sellers['sales_count'] . "' A screenshot would also help the package. I am posting this here instead of posting to the contrib to make sure I am right about this. Maybe the maintainer would like to incorporate these into any further package changes.
  5. You don't mention the contribution's name, but if it is something like Happi Multi Pix which I use, you must manually copy the images to the /catalog/images directory on your server. Usually ftp is the best way. I use Firefox and FireFTP, a Firefox addon, and it works great.
  6. Take a look at my post (#32): http://www.oscommerce.com/forums/index.php?s=&...t&p=1067121 This allows you to have a category description for a subcategory. I haven't tried having a sub-subcategory; however this works for my purposes, hopefully for yours, too. You may want to style the description so it looks prettier, however. -monkster
  7. Take a look at my post (#32): http://www.oscommerce.com/forums/index.php?s=&...t&p=1067121 This allows you to have a category description for a subcategory. I haven't tried having a sub-subcategory; however this works for my purposes, hopefully for yours, too. You may want to style the description so it looks prettier, however. -monkster
  8. Take a look at my post (#32): http://www.oscommerce.com/forums/index.php?s=&...t&p=1067121 This allows you to have a category description for a subcategory. I haven't tried having a sub-subcategory; however this works for my purposes, hopefully for yours, too. You may want to style the description so it looks prettier, however. -monkster
  9. I inserted this: <!-- BOF Category Description for a range of products, extension of Category Descriptions --> <?php $category_query = tep_db_query("select cd.categories_name, c.categories_image,cd.categories_description,cd.categories_heading_title from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?> <tr> <td><?php echo $category['categories_description']; ?></td> </tr> <!-- EOF Category Description for a range of products, extension of Category Descriptions --> right before this: <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td> <?php } else { // default page I have just tried it and am testing it now, but it seems to be working. This was just my sloppy way of initializing the $category variable, which I think we need for this instead of the $cat_description array. The code is just copied from its earlier occurence in index.php. Joeri, thanks for the great contrib! If this isn't proper, let me know. I am not a php coder yet. Working for me, though.
×
×
  • Create New...