Jump to content

bhbilbao

Members
  • Content count

    308
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by bhbilbao

  1. bhbilbao

    Seperate Pricing Per Customer v3.5

    For the moment I got the name_trail working with this code: // add the products model to the breadcrumb trail KISSMT if (isset($HTTP_GET_VARS['products_id'])) { $name_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND language_id=" . (int)$languages_id . ""); if (tep_db_num_rows($name_query)) { $name = tep_db_fetch_array($name_query); $breadcrumb->add($name['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } But I dont know how to integrate the sppc code, specially the followith code: ref: // BOF SPPC Hide products and categories from groups // $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); // EOF SPPC Hide products and categories from groups I need a name_query not the model_query. What could be the coorect code for this??
  2. bhbilbao

    Seperate Pricing Per Customer v3.5

    Sppc Breadcrumb trail help original code: // add the products model to the breadcrumb trail // if (isset($HTTP_GET_VARS['products_id'])) { // BOF SPPC Hide products and categories from groups // $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); // EOF SPPC Hide products and categories from groups // if (tep_db_num_rows($model_query)) { // $model = tep_db_fetch_array($model_query); // $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); // } // } working: // add the products name to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { $crumb_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . $languages_id . "'"); if (tep_db_num_rows($crumb_query)) { $crumb = tep_db_fetch_array($crumb_query); $breadcrumb->add($crumb['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } not working: // add the products name to the breadcrumb trail sppc if (isset($HTTP_GET_VARS['products_id'])) { // BOF SPPC Hide products and categories from groups $crumb_query = tep_db_query("select p.products_model, p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0"); // EOF SPPC Hide products and categories from groups if (tep_db_num_rows($crumb_query)) { $model = tep_db_fetch_array($crumb_query); $breadcrumb->add($crumb['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } some suggestion?
  3. bhbilbao

    Dynamic SiteMap

    Other question: ref: What about http : // www . sample . com / catalog / sitemaps.xml ???
  4. bhbilbao

    Dynamic SiteMap

    Need help with this error in dynamic_sitemap.php The code: $category_status_check = ''; $check_query = tep_db_query("select * from " . TABLE_CATEGORIES); $check = tep_db_fetch_array($check_query); if (isset($check['status_categ'])) { // skip if this is not set to avoid SQL error $category_status_check = ' and status_categ = 1'; } elseif (isset($check['categories_status'])) { // [b]skip if this is not set to avoid SQL error[/b] $category_status_check = ' and categories_status = 1'; } function getFileName($file, $define) //retrieve the defined filename { $fp = file($file); for ($idx = 0; $idx < count($fp); ++$idx) { if (!(strpos($fp[$idx], $define) === FALSE)) { $parts = explode("'", $fp[$idx]); return $parts[3]; } } return NULL; }
  5. @josejolls Start removing <title><?php echo TITLE; ?></title> with HeaderTagsSeo. This post is for KissMT. Robert , I have a new dude: ref: I changed specials.php and products_new.php, but then all pages have the same meta_name, meta_descript and meta_keywords. I don´t know if this is right.
  6. bhbilbao

    edgeoi feed error

    for roquetsynce: I had the similar error I fix it changing rss_edgeio.php file from admin/ folder to root. I use rhe script but it generates an empty .xml file with NO PRODUCTS. Knows anybody how to fix??
  7. bhbilbao

    ULTIMATE Seo Urls 5 - by FWR Media

    Thanks Robert, I fixed the problem renaming the cache files. I will delete the popupimage file as you say. There is also an option in Configuration>KissMT Meta Tags Reset KissMT Cache false I don´t know whant makes this option exactly . I turn it on to reset and then I refreshed the index page, but other pages don´t change their metas decrip.
  8. bhbilbao

    Multi_Vendor_Shipping new thread

    I will try, I will try :'( Thanks.
  9. Hi all, need some suggestion about this in index header, i dont know if right or not. This is what I want: <title>Welcome to STORE</title> <meta name="description" content="We sell wooden products of varius bla bla bla..... "> This is the thing i gets: <title>Welcome to STORE - We sell wooden products of varius bla bla bla.....</title> <meta name="description" content="Welcome to STORE, We sell wooden products of varius bla bla bla....."> When google indexes the page the content are repeated. I dont know if this is right. I would like to modify it. This is de devil code: /** * Root index page */ default: KissMT::init()->setCanonical( $this->checkCanonical() ); $this->parse( KissMT::init()->entities( sprintf( KISSMT_HOMEPAGE_TITLE, STORE_NAME ), $decode = true ), KissMT::init()->entities( sprintf( KISSMT_HOMEPAGE_DESCRIPTION, STORE_NAME ), $decode = true ) ); break; } } // end method
  10. bhbilbao

    Multi_Vendor_Shipping new thread

    Hi Jim, I need some help. In checkout_shipping.php page, I need to add the vendor_name and vendor_city where says "Products from this vendor" Something like "Products to ship from "vendor_name" on "vendor_city"" I don´t know if I must add code in the following lines: $quote[0]['methods'][0]['title'] = FREE_SHIPPING_TITLE; $quote[0]['methods'][0]['cost'] = '0'; } else { $total_weight = $vendor_shipping[$vendor_id]['weight']; $shipping_weight = $total_weight; $cost = $vendor_shipping[$vendor_id]['cost']; $total_count = $vendor_shipping[$vendor_id]['qty']; $quote = $shipping_modules->quote($method, $module, $vendor_id); } if (isset($quote['error'])) { tep_session_unregister('shipping'); } else { if ( (isset($quote[0]['methods'][0]['title'])) && (isset($quote[0]['methods'][0]['cost'])) ) { $output[$vendor_id] = array('id' => $module . '_' . $method, 'title' => $quote[0]['methods'][0]['title'], 'ship_tax' => $ship_tax, 'products' => $products_array, 'cost' => $quote[0]['methods'][0]['cost'] Thanks in advance.
  11. bhbilbao

    ULTIMATE Seo Urls 5 - by FWR Media

    In /includes/modules/ultimate_seo_urls5/cache/ I renamed 1_usucache.cache 48KB 2_usucache.cache 170KB 3_usucache.cache 239KB to backup_1_usucache.cache backup_2_usucache.cache backup_3_usucache.cache refreshed the page and now there in no error. I don´t know if this could be right or not. New file appeared 3_usucache.cache 9KB
  12. bhbilbao

    ULTIMATE Seo Urls 5 - by FWR Media

    I already have readed the posts before. I get this error: Fatal error: Out of memory (allocated 27262976) (tried to allocate 4760500 bytes) in /homepages/6/xxxxxxxxxx/htdocs/includes/modules/ultimate_seo_urls5/classes/Usu_Cache_FileSystem.php on line 32 I replaced the line 32 of that file by a big number. 2048, 4096 but nothing. Started to give this error after I changed by error the products_description column by products_head_desc_tag column. or probably of big number of items. I don´t know. What could be the solution. How can be reset the caché???
  13. bhbilbao

    jQuery Banner Rotator

    1. ok. is because the stop-play button sometimes stay infront of the text or the price of the banner and hide them. I will try repositing the button to one corner. 2. Yes, using URL rewrite in httaccess. I will remove the htlm links. 3. normaly using clasic 468px × 60px, but for your new contrib I use an extralarge 650px × 80px bann. I don't want to break your new contrib but i think the stop-play button is a nuisance thing. I will try to changing it more transparent. Thanks for all.
  14. bhbilbao

    jQuery Banner Rotator

    Thanks Jim, great and usefull contribution! But... 1.How to remove the play-stop button over the images??? (I want to remove the button, only images) 2.In banner manager if I insert a link url, then clicking in rotator always goes to the index page. 3.How lo align the diferent images of the rotator banner to the center??? (With diferent images of diferent sizes they are aligned to the left) Regards.
  15. After instaling: In admin>configuration>Slideshow>Loading Div *Modify Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /homepages/*/htdocs/admin/configuration.php(125) : eval()'d code on line 1 Parse error: syntax error, unexpected ')' in /homepages/*/htdocs/admin/configuration.php(125) : eval()'d code on line 1 On the mail page, index.php there is no slideshow of any tipe.
  16. I have a new problem with the Redeem button in checkout_payment.php Ref: I enter the code of the GiftVouncher and click on the button, but it makes nothing. It seems to be bloqued. Can somebody where to change the code for that issue??
  17. Ok, now I understand. I didnt found information in any place and i had doubt about it. If you say that there is no diferences on extensions .php or .html with search engines, I will stay with my static pages unmodified. Thanks!
  18. Ok, I understand. The documentation says: Then if you say that the search engines don´t care of the type of pages, i dont need to modify the 5 pages. Are they right?
  19. bhbilbao

    Seperate Pricing Per Customer v3.5

    Hi Jan, I readed posts #5530 and #5531 of this thread and I need support to Display MSRP & Savings (http://addons.oscommerce.com/info/3574) on product_info.php My code with SPPC: if ($new_price = tep_get_products_special_price($product_info['products_id'])) { // BOF Separate Pricing per Customer if ($customer_group_id > 0) { // only need to check products_groups if customer is not retail $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } } // end if ($customer_group_id > 0) // EOF Separate Pricing per Customer $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; $products_price_ex = ' ' . $currencies->display_price_ex($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . ' '; } else { // BOF Separate Pricing per Customer if ($customer_group_id > 0) { // only need to check products_groups if customer is not retail $scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'"); if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) { $product_info['products_price']= $scustomer_group_price['customers_group_price']; } } // end if ($customer_group_id > 0) // EOF Separate Pricing per Customer $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); $products_price_ex = $currencies->display_price_ex($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } $products_name = $product_info['products_name']; $products_qty = $product_info['products_quantity']; ?> Original instructions of MSRP & Savings I tried changing code in diferent ways but all were a disaster.
  20. Thanks Jack_mcs, in includes/aplication_top.php // set the HTTP GET parameters manually if search_engine_friendly_urls is enabled // if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { // ADDED FOR DINAMIC SITEMAP That way if the setting for "Use Search-Engine Safe URLs" gets changed in admin from true to false and a new XML sitemap is not generated osCommerce will still be able to understand the search engine safe URLs that may get used after the change // If you are certain PHP version 5 or higher will be used you can simplify the "strpos(strtolower($PHP_SELF)," to " stripos($PHP_SELF, " if ((SEARCH_ENGINE_FRIENDLY_URLS == 'true') || (strpos(strtolower($PHP_SELF), '.php/') > 0)) { // PHP V5.0 if ((SEARCH_ENGINE_FRIENDLY_URLS == 'true') || stripos($PHP_SELF, '.php/') > 0)) { // PHP V5.0 if ((SEARCH_ENGINE_FRIENDLY_URLS == 'true') || (stripos($PHP_SELF, '.php/') > 0) { I activated "Enable Search-Engine Safe URLs" in admin>configuration. I dont know if I must change the commented lines in aplication_top. Why did you said that?. I use Seo-Doctor addon of Firefox , and all flags are green except for the Seo Friendly Url pages with xxx.php I need to convert 5 pages that ends with .php (because as i readed Google penalizes them). services.php consulting.php rma.hph security.php new.php I don´t know how to modify the .htaccess file to include them, or if I need to use other contribution.
  21. All working 100% except for the normal pages of OSC. I created various pages duplicating contact_us.php and modifing them. page1.php page2.php The problem is the url doesnt translate to page1.html or page2.html I use mod_rewrite in .htaccess RewriteCond %{QUERY_STRING} ^options\=(.*)$ RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2%1 RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING} # Added polls and newsdesk #RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING} RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING} # BOF: Faqdesk support added by faaliyet RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING} # EOF: Faqdesk support added by faaliyet # Ultimate SEO URLs END any suggestion?
  22. bhbilbao

    Ultimate Osc Translator

    Hi again Ronrrico, finally working with the last release. The problem was a conflict with other contribution: Increase and decrease the size of the text in the description of the products http://addons.oscommerce.com/info/7095 here: <ul type="square"> <span class="ft1"><a onclick="TamFonte(1, 'noticia')"><img src="images/diminui_fonte.jpg" border="0"></a></span> <span class="ft3"><a onclick="TamFonte(3, 'noticia')"><img src="images/aumenta_fonte.jpg" border="0"></a></span> <span class="blue"><h2><?php echo TEXT_INFO;?><?php echo $products_name; ?></h2></span> <div id="noticia" class="ft1"><?php echo stripslashes($product_info['products_description']); ?></div> I replaced the id="noticia" for the translator code id="source" and working. (but the html <td> ul and li remains without translation). Other question. Now that we have the translator working I need to delete the other languges products description and only use the spanish description. I need this to reduce the database size. I use Spanish(default), english, and euskara. I don´t kwon what line to modify but i think it should be something like this ( products_description.... and language_id=xxx). Thanks in advance.
  23. bhbilbao

    Newsletter products, HTML email

    Finally solved. I returned to the original code and it began to work. /admin/includes/modules/newsletters/newsletter_products.php for ($i=0, $n=sizeof($this->productsInfo); $i<$n; $i++) { if ($col > COLS-1) { $html_content .= '</tr><tr><td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], 120, 92) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br>'; $price = ($this->productsInfo[$i]['specials_price']) ? '<span style="'. $cssMarkdown . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span> <span style="' . $cssSale . '">' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>' : '<span style="' . $cssPrice . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>'; $html_content .= $price . '</td>'; $col = 0; } else { $html_content .= '<td align="center" width="' . $width . '%"><a href="' . tep_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $this->productsInfo[$i]['products_id']) . '" style="' . $cssLink . '">' . tep_image(HTTP_CATALOG_SERVER . DIR_WS_CATALOG_IMAGES . $this->productsInfo[$i]['products_image'], $this->productsInfo[$i]['products_name'], 120, 92) . '<br>' . $this->productsInfo[$i]['products_name'] . '</a><br>'; $price = ($this->productsInfo[$i]['specials_price']) ? '<span style="' . $cssMarkdown . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span> <span style="' . $cssSale . '">' . $currencies->display_price($this->productsInfo[$i]['specials_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>' : '<span style="' . $cssPrice . '">' . $currencies->display_price($this->productsInfo[$i]['products_price'], tep_get_tax_rate($this->productsInfo[$i]['products_tax_class_id'])) . '</span>'; $html_content .= $price . '</td>'; } $col++; } 1.You must modify configure.php 2.Replace SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT with the numbers of your needs. If you dont change it by numbers there will no any images. 3.Dont use 0 as number. If you use 100,0 or 0,100 as image width and height , the images will be send as the original size(and correct proportions). I don´t know how to resolve this. Do anybody knows how to send and email to a particular customer and not to all customers that receives newsletters??? Is there any button in admin panel to change that, before sending a newsletter(without enter phpmyadmin)???
  24. bhbilbao

    Multi_Vendor_Shipping new thread

    No, when and order is placed, you can edit it as standard-order or mvs-order, not both. Ref: <?php // MVS start if (tep_not_null($order->orders_shipping_id)) { require_once ('vendor_order_info.php'); } else { // MVS end ?> I also use a modification in checkout process, I use the old checkout and the mvs checkout process. You can read of if in this thread weeks ago. Mvs orders are writing in the orders and orders_shipping tables. The clasical orders of oscommerce are writing in the orders table only. If you installed and working MVS, continue using it without problems, all of your orders will be MVS-orders. ... advantage? .... should be ADVANTAGES!! If you have vendors (shops), you can administrate the orders from your web shop to the diferent vendors. or if you have suppliers, also you can administrate the orders to the diferent suppliers. Try to acomodate MVS acording your needs.
×