Jump to content

Kaiser Soze

Members
  • Content count

    35
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Kaiser Soze
  1. Kaiser Soze

    QuickBooks Contrib

    I'm interested in this mod too. Did you get it uploaded?
  2. Kaiser Soze

    [Contribution Update] All Prods v2.4

    Ok, here's the fix... The bold lines are the ones I added... $duplicates = array(); $languages_query = tep_db_query("select languages_id, name, code, image, directory from " . TABLE_LANGUAGES . " order by sort_order"); while ($languages = tep_db_fetch_array($languages_query)) { $languages_array[] = array('id' => $languages['languages_id'], 'name' => $languages['name'], 'code' => $languages['code'], 'image' => $languages['image'], 'directory' => $languages['directory']); } for ($i=0; $i<sizeof($languages_array); $i++) { $this_language_id = $languages_array[$i]['id']; $this_language_name = $languages_array[$i]['name']; $this_language_code = $languages_array[$i]['code']; $this_language_image = $languages_array[$i]['image']; $this_language_directory = $languages_array[$i]['directory']; echo " <tr>\n"; $products_query = tep_db_query("select p.products_id, p.products_model ,pd.products_name, p.products_thumbnail, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name"); $products_array = array(); while($products = tep_db_fetch_array($products_query)) { $id = $products['products_id']; if( !isset( $duplicates[ $id ] ) ) { $duplicates[ $id ] = true; $products_array[] = array('id'=> $products['products_id'], 'name' => $products['products_name'], 'image' => $products['products_thumbnail'], 'manufacturer' => $products['manufacturers_name'], 'price' => $products['products_price'], 'tax' => $products['products_tax_class_id'], 'special' => $products['specials_new_products_price']); } } Hope this helps. BTW, the duplicates add relevance to your page & site. I just got spidered by Google & I got ranked as #1 for the products that I had duplicated on my allprods page. e.g., http://www.google.com/search?hl=en&lr=&ie=...G=Google+Search But, I still put in the duplicates fix. I'd rather have a professional looking site.
  3. Kaiser Soze

    [Contribution Update] All Prods v2.4

    I get the same thing. It makes my site seem pretty unprofessional. I'll find out what the fix is & post it.
  4. The url's generated by the AllProds contribution have: Your_Store_Name="some product name" Why is that there?
×