Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SnatchTease

Pioneers
  • Posts

    8
  • Joined

  • Last visited

Everything posted by SnatchTease

  1. 1. I wanted to get the images off the buttons. I found I can either set the padding past 35 in scroller.php under... $header .= '#scroller {' . "\n"; ...and then ditch the border, or I can lower the width in ... $header .= 'div.scrollWrapper {' . "\n"; ...and then center it. 2, 3, 4, spent 13 hrs in threads today, I'll get back to you on those. Thanks again.
  2. At first it didn't work, but then I say I needed a comma under the last entry 'select' before my new entry. Brilliant work, Jim. Your contributions and this thread have brought me great joy now and in the past. Your continued commitment to the forum and thread is very appreciated. That being said, I have four questions. What changes do I have to make to scroller.php to fit the images between the scroller images? What do I need to do to make it scroll via clicking only? What do I need to do to make it scroll x amount of pixels per click? Pretty much, I'd like it to scroll pages from clicks on the arrows. Finally, can I enlarge the images beyond what's set in the admin 'images' menu? Thanks again, Jim. For everything.
  3. Sorry, I must admit that I am limited in my PHP usage. Jim, I believe I've been on track towards the later. I know that the changes need to be made to the php files under catalog/includes/modules/front_page/ (anywhere else?). Currently I'm testing featured.php, and tried modifying the following.... featured.php, around line 98: ------------------------------------- $featured__content .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br /><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br />' . $featured_products['manufacturers_name'] . '</a><br />' . $manufacturers_name . '</a><br />' .$products_price; ---------------------------- So, of course those calls to manufacturers_name I tried didn't work, <br />'s worked like a charm though, so I have been eyeballing above lines... featured.php, around line 60 ------------------------------------ select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.status from " . TABLE_PRODUCTS . " p join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id left join " . TABLE_SPECIALS . " s on s.products_id = p.products_id where p.products_id = '" . $products_id . "' and pd.language_id = '" . ( int ) $languages_id . "' "; ---------------------------------------- From what you posted, Jim, looks like I'm headed in the right direction. So to pull of the left join, do I just have to add 'm.manufacturers_name' under 'select' and then add the following... left join " . TABLE_MANUFACTURERS . " m on m.products_id = p.products_id ...under 'from'? Then I can make the call for manufacturers_name? Update: Nope, tried, returns the following on storefront: -------------------------------------------------- 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.manufacturers_name from pro' at line 9 select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.status m.manufacturers_name from products p join products_description pd on pd.products_id = p.products_id left join specials s on s.products_id = p.products_id left join manufacturers m on m.products_id = p.products_id where p.products_id = '5' and pd.language_id = '1' [TEP STOP]
  4. How would I go about inserting the Manufacturer's Name (which we use to list product/book authors) between the Product Name and the Price in the modules (featured, specials, etc...)?
  5. Same here. My organization would be happy to donate money to an individual that can make this contribution working in 2.3.1. We've been considering hiring someone to do this for us, but that wouldn't be replicable or help the OSC community at large. Without the OSC community and their contributions, we'd never have considered OSC in the first place.
×
×
  • Create New...