| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Newest Products | ||||
|
|
Thread Tools | Search this Thread |
#141
|
|||||||
|
|||||||
Just one more question: how to NOT show new products in other pages than home.php? I mean, I don't want to display products in categories..or if i display something should be new products from that category, if are not any new products in category, just show "no products" message..hope you understand me...
Thank you
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#142
|
|||||||||
|
|||||||||
Quote:
Code:
Code:
Code:
To not show the block on all pages simply remove if from the skin1/customer/home.tpl and place it where required. On interstellar its in skin1/customer/main/welcome.tpl. Other places like skin1/customer/main/subcategories.tpl is also a useable place. Thats all I can tell you - I'm sure you can follow the tpl logic of where you want things - so happy modding |
|||||||||
#143
|
|||||||
|
|||||||
Hi,
Can somebody help me out, my server has Mysql version 4.0.25 so when I follow the instructions listed by lapidarist: http://forum.x-cart.com/viewtopic.php?p=107474#107474 I get this error when calling newproducts.php: INVALID SQL: 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 'xcart_products.avail > 0 AND add_date > 1146282522 AND add_date SQL QUERY FAILURE:SELECT COUNT(xcart_products.productid) FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing WHERE xcart_products.productid=xcart_products_categories .productid AND xcart_products_categories.categoryid=xcart_categor ies.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0AND xcart_products.avail > 0 AND add_date > 1146282522 AND add_date < 1146887322 GROUP BY xcart_products.productid Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /include/func/func.db.php on line 125 I'm assuming that Code:
is not liking my msql version. Can someone tell me the correct query for mysql 4.0.25? THANKS! |
|||||||
#144
|
|||||||||
|
|||||||||
Quote:
Code:
But if thats not right, maybe run the query in phpMyAdmin and see if it works, iff not you can try building the query up or strip it down. |
|||||||||
#145
|
|||||||
|
|||||||
Hey cliff,
thanks for the help but its giving the same error. I think its just a matter of different syntax between mysql 4.0.25 and 4.1.0. But I have no idea what the syntax differences are. |
|||||||
#146
|
|||||||
|
|||||||
Internal Server Error
Hi,
I followed the step by step instructions, for this mod, didn't change a thing that I wasn't supposed to, but when I typed the URL in my browser address to get to the page for testing before inserting the live link on the site I got an Internal Server Error message... "The server encountered an internal error or misconfiguration and was unable to complete your request." Has anyone else had this problem? We've just been upgraded to V 4.0.18. Our site still works fine, no problems anywhere else. Any ideas would be welcome, before we start tinkering.
__________________
X-Cart V 4.0.18 |
|||||||
#147
|
|||||||
|
|||||||
Quote:
See page 9, (post 4 from bottom of page)
__________________
Syddos Nothing is impossible, We just don't know how to do it ........Yet! Xcart 4.1.X PRO (Testing Platform: winXP Pro) Perl 5.8.7 (win32) WINAMP 1.6.3 (win32 server package. Includes the following) - phpMyAdmin v2.8.03 - MySql 5.0.21 - Apache 2.0.55 (win32) - php 5.1.4 - SQLitemanager 1.2.0 |
|||||||
#148
|
|||||||||
|
|||||||||
Does anyone have this working with 4.1.x yet? I've installed a test version and would really like this included but don't know where to begin.
__________________
Two Separate X-Cart Stores Version 4.4.4 Gold - X-AOM - Vivid Dreams Aquamarine (modified) - Linux Mods - Newest Products - View All -, and a few others. Numerous upgrades from 4.0.x series. Integrated with Stone Edge Order Manager + POS Version 4.1.12 Gold (fresh install) - X-AOM - Linux Mods - XCSEO free |
|||||||||
#149
|
|||||||||
|
|||||||||
Hi,
I've got this working great, but I'd like to be able to put these on my frontpage too. Anyone know how I can do that? I tried adding Code:
Anyone know? tia
__________________
X-Cart version 5 (Previously 3.5-4) Previous Versions included BCSE Reward Points Mod Altered Cart On Sale Mod Wordpress Plugin Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there. Shout me a Coffee! |
|||||||||
#150
|
|||||||||
|
|||||||||
Quote:
Do you mean instead of Featured Products, or in additon to? In any case I think you need to include 'newproducts.tpl' (or whatever you named the new products template). This is a great mod, and I sure would like to get it working with version 4.1. Has anyone had any luck?
__________________
Two Separate X-Cart Stores Version 4.4.4 Gold - X-AOM - Vivid Dreams Aquamarine (modified) - Linux Mods - Newest Products - View All -, and a few others. Numerous upgrades from 4.0.x series. Integrated with Stone Edge Order Manager + POS Version 4.1.12 Gold (fresh install) - X-AOM - Linux Mods - XCSEO free |
|||||||||
|
|||
X-Cart forums © 2001-2020
|