prvhk3
Pioneers-
Posts
25 -
Joined
-
Last visited
Profile Information
-
Real Name
Praveen H K
prvhk3's Achievements
-
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Hi Jack, any updates on the changes? Thanks in advance -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Thank you so much Jack. I will wait for your support. But really it is very important to me...... Thanks in advance -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Can you please let me know how did you make this change? From '-' to '/' -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Piemol can you can tell me how to make these changes? -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Hi, If i change $cName = $result['parentName'] . '-' . $cName; to $cName = $result['parentName'] . '/' . $cName; not working, please let me know what else need to be changed Thanks in Advance -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Hi, I have installed Ultimate SEO URL by Chemo 2.2 I need to change the URL Separator to '/' from '-' what should be done and where, please help me ASAP.... Please reply me, as i need help sincerely. I have seen most of the pages in this thread but was unable to find it, if you guys can help me it will be great full. Thanks in Advance.Report -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Please anyone help me to change the Separator from '-' to '/'. This is very urjent to me. Thanks in advance........................ -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Please let me know the solution to the changes separator from '-' to '/' -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
unable to find please help if possible -
[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo
prvhk3 replied to spidometrs's topic in General Add-Ons Support
Hi, please help in URL issue. I have installed Ultimate SEO URLs i need slash has a separator in the URL instead of dash, unable to do it please help me. what should i change and where should i change to get slash has the separator. Present URL: http://localhost/catalog/catgegory-sub-category-manufacturer-product-p-29.html Required URL: http://localhost/catalog/catgegory/sub-category/manufacturer/product-p-29.html please help Thanks in advance -
Solved and got what i wanted
-
New Products Box Displays By Category contribution 6339
prvhk3 replied to friendlyfriend's topic in General Add-Ons Support
Solved and got what i wanted. -
Hello all, I'm working with http://addons.oscommerce.com/info/6339 I love this add-on it is so simple to install and does exactly what I want, except for one thing. It displays the product image and then just the price underneath it. I would like it to display image, product short discription, price. I've been fiddling with the code for a day and I'm just not experienced enough to make it work. I'm sure it's simple for someone out there, Thank you, PRV Contribution Code <?php /* $Id: new_products.php 1806 2008-01-11 22:48:15Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2008 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $category_query = tep_db_query("select distinct categories_id from ". TABLE_products_TO_CATEGORIES ); $cids = array(); while ($categories = tep_db_fetch_array($category_query)) { array_push($cids, $categories["categories_id"]); } $cid = $cids[rand(0, count($cids) - 1)]; // removed order by p.products_date_added desc $new_products_query = tep_db_query( "select p.products_id, p.products_image, p.products_tax_class_id, " . "if(s.status, s.specials_NEW_products_price, p.products_price) as products_price " . "from " . TABLE_products . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id " . ", ". TABLE_products_TO_CATEGORIES . " p2c " . "where p.products_id = p2c.products_id and products_status = '1' and (p2c.categories_id = 54)" . "order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_NEW_products_price, p.products_price) as 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 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_status = '1' order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $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=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']))); $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents); ?> <!-- new_products_eof //--> Product Short Description is in different table so i have to call TABLE_PRODUCT_DESCRIPTION but if use i get the Sql Error so please help me how to call the Product Short Description in this contribution. This Product Short description is from SEO Header Tags contribution Thanks in advance
-
New Products Box Displays By Category contribution 6339
prvhk3 replied to friendlyfriend's topic in General Add-Ons Support
Same problem but instead of Product Name i need to display Product short description Product Short Description is in different table so i have to call TABLE_PRODUCT_DESCRIPTION but if use i get the Sql Error so please help me how to call the Product Short Description in this contribution. Thanks in advance. -
1064 Sql error in Short Description in Products mod
prvhk3 replied to rdranoel's topic in General Add-Ons Support
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 '' at line 1 select count(distinct p.products_date_added) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c, categories_description cd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and ((pd.products_name like '%64%' or p.products_model like '%64%' or m.manufacturers_name like '%64%') I get this error if i search any thing on my website. Please help to solve the error ASAP. Thanks in advance.