Jump to content

galac

Members
  • Content count

    18
  • Joined

  • Last visited

  1. galac

    Automatically send data feed to Froogle

    I found ! Replace: $catIndex[$curID] = $temp . " " . $catTempDes[$curID]; With: $catIndex[$curID] = $temp . " " . $catTempDes[1][$curID]; ;)
  2. galac

    Automatically send data feed to Froogle

    Ok for my problem with language i just add: $catInfo = " SELECT //added categories_description.language_id, //end added categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id //added AND categories_description.language_id=1 //end added "; Now my problem is that the shopbot just want the Top level category for each product. I don't know how to limit the list Thx for help
  3. galac

    Automatically send data feed to Froogle

    Ok But Could you send me a link to the contribution via private message plz ? Or if you cant: Could you paste the code to integrate language option ? or default language of the shop is not integrated in this contribution ? What can i do if my shop is not in English language ? i think that : AND pd.language_id = '" . (int)$languages_id . "' is ok but i dont know how transfom it has sql query
  4. galac

    Automatically send data feed to Froogle

    Please where could i find froogle data feeder contribution ? not in contributions area....................... 69 pages of a none downloadable contribution.. it makes me creasy If someone could put a link to i will appreciate (could not find via google too..) Thx you.. i just have yahoo data feeder but it put my categories in English language. I want it in French. There's no language options in yahoo data feeder. Thx a lot I want my categories in French because its the shop default language
  5. Anyone for make it works with YASU ? i tried this, has posted bellow, but the urls are not rewrited :( googlesitemap/index.php : if ( file_exists(DIR_WS_CLASSES . 'seo.class.php') ){ require_once(DIR_WS_CLASSES . 'seo.class.php'); $seo_urls = new SEO_URL($languages_id); } else if ( file_exists(DIR_WS_CATALOG . 'rewrite.php') ){ require_once(DIR_WS_CATALOG . 'rewrite.php'); $other_rewrite = true; } Then in googlesitemap/sitemap.class.php : * Function to generate product sitemap data */ function GenerateProductSitemap(){ // SEO OTHER BEGIN global $other_rewrite; if (!$other_rewrite) { $sql = "SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered FROM " . TABLE_PRODUCTS . " WHERE products_status='1' ORDER BY products_ordered DESC"; } else { $sql = "SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered, pd.products_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " AS p LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " AS ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " AS pd ON pd.products_id=p.products_id WHERE p.products_status='1' ORDER BY p.products_ordered DESC"; } // SEO OTHER END if ( $products_query = $this->DB->Query($sql) ){ $this->debug['QUERY']['PRODUCTS']['STATUS'] = 'success'; $this->debug['QUERY']['PRODUCTS']['NUM_ROWS'] = $this->DB->NumRows($products_query); $container = array(); $number = 0; $top = 0; while( $result = $this->DB->FetchArray($products_query) ){ $top = max($top, $result['products_ordered']); // SEO OTHER BEGIN if (!$other_rewrite) $location = $this->hrefLink(FILENAME_PRODUCT_INFO, 'products_id=' . $result['pID'], 'NONSSL', false); else $location = $this->hrefLink(FILENAME_DEFAULT, 'cPath=' . tep_get_product_path($result['pID']) . '/' . $result['products_name'], 'NONSSL', false); // SEO OTHER END $lastmod = $this->NotNull($result['last_mod']) ? $result['last_mod'] : $result['date_added'];
  6. BIG PROBLEM IN THIS CONTRIB! Make a new folder via pop/insert_image.html, the folder owner = apache Try now to upload an image or to create a sub-folder in this new folder: just impossible cause the owner is not root. The new folder is chmod 777 so the problem is root owner. The only way is to be in SHH has root then CHOWN the folder owner as root owner. Anyone has go through this problem ? cause i don't find any solution...
  7. BIG PROBLEM IN THIS CONTRIB Make a folder vi
  8. In all store the products are with no tax.. but ! in checkout_confirmation.php the price is with the tax ! :) All is Ok when i uninstall this contribition but i got more queries.. so... prices without tax in the store (but less queries) or prices with tax (but more queries) ? ok not funny... but whats wrong with the code ? Don't tell i forgot the : // tax class require('includes/classes/tax.php'); $osC_Tax = new osC_Tax; ?> in application_top =)
  9. galac

    EZier New Fields

    I found for sort order by retail price (ascendent or descendant) : In catalog/index.php add: case 'PRODUCT_LIST_RETAIL_PRICE': $listing_sql .= "p.products_retail_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; For savings sort order, i think we need a tep_get function cause savings are not in the database, they are calculated
  10. galac

    EZier New Fields

    Forget my last question... its ok :'( :-" Can't we edit message ? ok now my good question: B) In product_listing, how could we ascendent or descendant sort by saving ? Exemple: 20% 15% 12% 2% or 2% 12% 15% 20% :thumbsup:
  11. galac

    EZier New Fields

    Hello, i've got a problem with Easy new fields and featured_products (featured products on the home page). Products with no retail price appears like this : I tryed all but i'm not a great coder :( I want for products with no retail price that "retail price= 0?" does not appear. Please could someone help me! Here's is the file featured.php in /catalog/includes/modules -------------------------------------------------------------------- <?php if(FEATURED_PRODUCTS_DISPLAY == 'true') { $featured_products_category_id = $new_products_category_id; $cat_name_query = tep_db_query("select categories_name from categories_description where categories_id = '" . $featured_products_category_id . "' limit 1"); $cat_name_fetch = tep_db_fetch_array($cat_name_query); $cat_name = $cat_name_fetch['categories_name']; $info_box_contents = array(); if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) { $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); list($usec, $sec) = explode(' ', microtime()); srand( (float) $sec + ((float) $usec * 100000) ); $mtm= rand(); $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, p.products_retail_price, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } else { $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name)); $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, p.products_retail_price, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } $row = 0; $col = 0; $num = 0; while ($featured_products = tep_db_fetch_array($featured_products_query)) { $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); } $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']); if($featured_products['specstat']) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<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><span class="productSpecialPrice">' . $retail . TEXT_PRODUCTS_RETAIL_PRICE_INFO . $currencies->display_price($featured_products['products_retail_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span></a><s><b>' . TEXT_PRODUCTS_PRICE_INFO . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</b></s><span class="productSpecialPrice">' . TEXT_PRODUCTS_PRICE_SPECIAL_INFO . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) .'</span>'); } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<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><span class="productSpecialPrice">' . $retail . TEXT_PRODUCTS_RETAIL_PRICE_INFO . $currencies->display_price($featured_products['products_retail_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span></a><b>' . TEXT_PRODUCTS_PRICE_INFO . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</b></span>'); } $col ++; if ($col > 2) { $col = 0; $row ++; } } if($num) { new contentBox($info_box_contents); } } else // If it's disabled, then include the original New Products box { include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } ?>
  12. The contrib : http://www.oscommerce.com/community/contributions,2337 Very nice contrib but: 1/ Hello, in advanced search the language for each droplist attributs are not separated. For color droplist i got all language translations. 2/ How can i remove some attributs from the advanced search ? 3/ How can i change the inputs type for attributs ? For exemple, for color attributs, i dont want droplist but i want check box. The code advanced_search.php <?php // ******************************************************************************** ******** // ******************************************************************************** ******** // This code has been added in order to make the attributes on products searchable by selecting // the attribute through a drop down list box, if you notice on your advanced_search.php page // that a select box is empty it means there are no option values for that option // Please leave these commented lines in this file. This contribution was built by Adam, // If it helps you, then you can help me by donating through paypal, my email address is: adamsawchuk@hotmail.com $attributes_query = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "'"); while ($attributes = tep_db_fetch_array($attributes_query)) {?> <tr> <td class="fieldKey"><?php echo $attributes["products_options_name"]; ?></td> <?php $option_values_query = tep_db_query("select pv.products_options_values_id, pv.products_options_values_name from products_options_values pv, products_options po, products_options_values_to_products_options popv where popv.products_options_id = po.products_options_id and pv.products_options_values_id = popv.products_options_values_id and popv.products_options_id =" . $attributes["products_options_id"] . " and po.language_id =". (int)$languages_id . " group by products_options_values_id, products_options_values_name"); echo '<td class="fieldValue">'; echo '<select name="'.$attributes["products_options_name"].'">'; echo '<option selected></option>'; while ($option_values = tep_db_fetch_array($option_values_query)) { echo '<option value="'.$option_values["products_options_values_id"].'">'.$option_values["products_options_values_name"].'</option>'; } echo '</select>'; ?> </td> </tr><?php } //// End of code added to advanced_search.php ///////////////////////////////////////////// // ******************************************************************************** ******** // ******************************************************************************** ******** ?>
×