Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default How to display artist name in product listing?

    I have an online music shop (http://ethnosuperlounge.com/eslshop)

    I would like to display the artist name with each product in the product listings, but can't find how to do it. I have used the Music Product Type.

  2. #2
    Join Date
    Mar 2007
    Location
    Cheshire
    Posts
    81
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    If you are using the music product type is it not just a case of defining all the artist names (extras/record artists) and then selecting them from the drop down box when you add a new product.

  3. #3
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    You would think so, however I have done that and as you can see on my website, artist name is not displayed.

  4. #4
    Join Date
    Mar 2007
    Location
    Cheshire
    Posts
    81
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    I take it you have set the following to true in your admin panel:

    Catalog/product types/Product - Music/Show Artist

  5. #5
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    That causes the artist to be displayed on each music product's specific page, but not on product listing pages.

  6. #6
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    So does anyone have any ideas on this?

  7. #7
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    Hello, can anyone please help?

  8. #8
    Join Date
    May 2008
    Posts
    2
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    I've been scouring the threads too for an answer....

  9. #9
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    Hi there,
    Still hoping for leads on this one...
    Can anyone give me some pointers as to how to go about coding this?

  10. #10
    Join Date
    Nov 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: How to display artist name in product listing?

    Mmm... I seem to have cracked it!

    I copied new_products.php to includes/modules/custom/new_products.php (where custom is my template)
    and modified it to include artist name where relevant.

    Here's the new file:

    <?php
    /**
    * new_products.php module
    *
    * @package modules
    * @copyright Copyright 2003-2006 Zen Cart Development Team
    * @copyright Portions Copyright 2003 osCommerce
    * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    * @version $Id: new_products.php 4629 2006-09-28 15:29:18Z ajeh $
    */
    if (!defined('IS_ADMIN_FLAG')) {
    die('Illegal Access');
    }
    // display limits
    //$display_limit = zen_get_products_new_timelimit();
    $display_limit = zen_get_new_date_range();

    // get artist name info
    $artists_array = array(array('id' => '', 'text' => TEXT_NONE));
    $artists = $db->Execute("select artists_id, artists_name
    from " . TABLE_RECORD_ARTISTS);
    while (!$artists->EOF) {
    $artists_array[] = array('id' => $artists->fields['artists_id'],
    'text' => $artists->fields['artists_name']);
    $artists->MoveNext();
    }

    // get product info
    if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
    $new_products_query = "select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_date_added, pe.artists_id
    from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCT_MUSIC_EXTRA . " pe
    where p.products_id = pe.products_id and p.products_status = 1 " . $display_limit;
    } else {
    $new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added,
    p.products_price, pe.artists_id
    from " . TABLE_PRODUCTS . " p
    left join " . TABLE_SPECIALS . " s
    on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " .
    TABLE_CATEGORIES . " c, " . TABLE_PRODUCT_MUSIC_EXTRA . " pe
    where p.products_id = p2c.products_id
    and p2c.categories_id = c.categories_id
    and c.parent_id = '" . (int)$new_products_category_id . "'
    and p.products_id = pe.products_id
    and p.products_status = 1 " . $display_limit;
    }
    $new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS);

    $row = 0;
    $col = 0;
    $list_box_contents = array();
    $title = '';

    $num_products_count = $new_products->RecordCount();

    // show only when 1 or more
    if ($num_products_count > 0) {
    if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS == 0 ) {
    $col_width = floor(100/$num_products_count);
    } else {
    $col_width = floor(100/SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS);
    }

    while (!$new_products->EOF) {

    $products_price = zen_get_products_display_price($new_products->fields['products_id']);

    $new_products->fields['products_name'] = zen_get_products_name($new_products->fields['products_id']);
    $list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsNew centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',
    'text' => (($new_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'products_id=' . $new_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $new_products->fields['products_image'], $new_products->fields['products_name'], IMAGE_PRODUCT_NEW_WIDTH, IMAGE_PRODUCT_NEW_HEIGHT) . '</a><br />') . (($new_products->fields['artists_id'] == '') ? '' : $artists_array[$new_products->fields['artists_id']]['text'] . '<br />') . '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'products_id=' . $new_products->fields['products_id']) . '">' . $new_products->fields['products_name'] . '</a><br />' . $products_price);

    $col ++;
    if ($col > (SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS - 1)) {
    $col = 0;
    $row ++;
    }
    $new_products->MoveNextRandom();
    }

    if ($new_products->RecordCount() > 0) {
    if (isset($new_products_category_id) && $new_products_category_id != 0) {
    $category_title = zen_get_categories_name((int)$new_products_category_id);
    $title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . ($category_title != '' ? ' - ' . $category_title : '' ) . '</h2>';
    } else {
    $title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . '</h2>';
    }
    $zc_show_new_products = true;
    }
    }
    ?>

    NB The part which actually outputs the artist name is

    . (($new_products->fields['artists_id'] == '') ? '' : $artists_array[$new_products->fields['artists_id']]['text'] . '<br />')


    (in case you want to add a span tag or something)

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. How to display Category name or Product name as a tagline?
    By ttmb33 in forum General Questions
    Replies: 0
    Last Post: 19 Jan 2010, 05:47 PM
  2. Sitewide Artist Name Display
    By exoticcorpse in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 18 Jun 2009, 05:39 AM
  3. Replies: 5
    Last Post: 4 Feb 2008, 06:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR