| ||||||||||
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 |
#131
|
|||||||
|
|||||||
Hello.
I have some errors when acces http://mallromania.ro/newproducts.php INVALID SQL: 0 : 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_products.avail>0 AND xcart_pricing.variantid = 0AND xcart_products.avail > 0 AND add_date > 1143817094 AND add_date < 1144421894 GROUP BY xcart_products.productid Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mallroma/public_html/include/func.php on line 102 I added latest code and corection for it but still have this error. Also, no products are show when select 24 hours, 3 days etc Thanks
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#132
|
|||||||||
|
|||||||||
Quote:
|
|||||||||
#133
|
|||||||
|
|||||||
Hmm...i must clean up my oculars Thank you
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#134
|
|||||||
|
|||||||
Ok, everything it's ok when i visit newproducts.php..but how to show newproducts in main page? I added in customer/home_main.tpl this code
{elseif $main eq "newproducts"} {include file="customer/main/newproducts.tpl"} and in welcome.tpl {include file="customer/main/newest.tpl" newproducts=$newproducts} but only new product box appear with no products in. see here: http://mallromania.ro/home.php?shopkey=1086
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#135
|
|||||||
|
|||||||
Can somebody help me, please? I want to open site for users tomorow and this option will be useful for me.
Thanks
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#136
|
|||||||||
|
|||||||||
Quote:
Hope that helps to give you some ideas to extend and integrate to your cart/site[/url] |
|||||||||
#137
|
|||||||
|
|||||||
All i want is to display newest products in main page, not only when press link. Something similar with featured products will be be very good. Can you send me your code please? (admin@mallromania.ro)
Thank you
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#138
|
|||||||||
|
|||||||||
Quote:
Well in the spirit of sharing here is the basis of thing. Do take into account that I have taken out some of the more specific requirements of my development to give a basis to be working on. Code based on Xcart Gold 4.0.18 /modules/Bestsellers/bestsellers.php. Code:
You may want to pay attention to the query2 string above in relation to column "add_date" as my system uses a different column due to other mods I have made on cart. skin1/modules/Newitems/newitems.tpl Code:
Edit skin1/customer/home.tpl Code:
Upto you how and where you place the block - it should come out as a horizontol block with 5 items listed. It can be added elsewhere and will be category sensitive (like bestsellers is). Meaning it will show newest 5 items in currently selected category or if there are none, will do a global search. Add some sql to xcart: Code:
Think thats about it. Can't promise it will work as it is as I've had to pull it all out from my mods - Good luck - and the fun is when you do get it to happen |
|||||||||
#139
|
|||||||
|
|||||||
THANK YOU! You are the best!
__________________
Mircea Teleleu Shopedia.ro-la cumparaturi www.shopedia.ro ______________________ x-cart gold 4.1.6 Linux |
|||||||
#140
|
|||||||||
|
|||||||||
Quote:
|
|||||||||
|
|||
X-Cart forums © 2001-2020
|