Newest Products
Cyberactive and I have been working on a module that shows up products added into the shop over the last week and have come up with the code below to show this on your home page.
Try this - it works fine and dandy in 3.2.2 First create a new php file customer/newest.php Code:
<? This is set to select 5 products added within the last week but you can change the timespan to whatever you like by changing the daterange variable. This is unix time so is calculated in seconds. Second, add into the customer/home.php file after the require featured.php bit Code:
require "./newest.php"; Third, create a newest.tpl template: Code:
{* $Id: newest.tpl,v 1.13 2002/05/20 06:55:20 lucky Exp $ *} You will note in here two extra fields to the languages part, one in labels for the heading to the section then a second one to show if there are no new prodoucts. Fourth - amend home_main.tpl to Code:
Fifth and finally - amended the welcome.tpl template to the following: Code:
{* $Id: welcome.tpl,v 1.21 2002/09/10 12:36:34 zorg Exp $ *} Not sure whether this works with 3.3. Enjoy |
Nice work funky dunk, maybe I can implement this soon in some of my upcomming carts. From the looks of it though, should work great! :D
|
Cyberactive has taken it on further now - full thread is http://forum.x-cart.com/viewtopic.php?t=1402&highlight=
He has put it in place on his site and it looks really good - would make a good standard module if the x team are watching. :lol: |
I runs smoothly over here.
And fast too.... :D I've just changed the query a bit to randomize the results. |
The randomise query is
Code:
$query = "SELECT * FROM $sql_tbl[products],$sql_tbl[pricing] WHERE forsale='Y' AND avail>0 AND $sql_tbl[products].productid=$sql_tbl[pricing].productid AND add_date > " . $oldtime . " AND add_date < " . $nowtime . " ORDER BY RAND() LIMIT 5 "; Just change the number after LIMIT to show more or less products. Good luck. |
Re: Newest Products
Quote:
Funkydunk, i copied your code (which looks good), but it doesn't run into my site. I got the following errormessage at the top of the page : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site6/fst/var/www/html/config.php on line 288 And i got the following errormessage at the footer of the page : Warning: Smarty error: unable to read template resource: "customer/main/newest.tpl" in /home/virtual/site6/fst/var/www/html/Smarty-2.1.1/Smarty.class.php on line 546 What did I wrong ? |
Can you post your exact code into the forum and I will have a peek.
Cheers |
Quote:
We are running version 3.1.3. Is that the cause of my problem ??? |
I would say yes... if you upgraded to 3.2.4 or 3.3.1 this would be workable. There seem to be quite a few changes from 3.1 to 3.2 onwards
|
Just a quick note that if you want this to show up when you are in other sections of the shop, like help.php cart.php then the thing to do is include the newest.php file in those files as per the instructions for home.php.
Code:
require "./newest.php"; |
All times are GMT -8. The time now is 08:50 PM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.