Display random products from your Zen Cart Store on your home page.
 

Whats up everybody. This isn't a major hack or anything but like some people on here I have ZenCart store system running on my site. I wanted a way to display random products onto my sites home page. So with some help from a friend we created a php file that does so. All you need to do is add your information to the variables. and then upload the php file to your modules folder. After that create a new module and use php file. I can try to help with any problems the best I can but I'm not sure how much I will be able to. However this is very straight forward. Just download the attachment and change the variables.

Awesome! Thankyou. I'm off to try it now. :)

my web guy roxors! :)

$database = 'xxxx';

$link = mysql_connect($dblocation, $dbname, $dbpw, $database) or die (mysql_error ());

????

not work

When the developer talks about the "modules"-folder he/she forgets to tell us that you actually need the vBadvanced CMPS-portal installed to use this php-file as it is. There is also some strange table-properties. Maybe its for some old version of Zencart. Usually Zencart is installed with zen_-prefix. I have done some modifications:

1. Corrected query to reflect ZenCart v1.2.6 table-properties with zen_-prefix
2. It now only displays active merchandise
3. Modified design for right column display
4. Toned down the giant letters
5. Removed hardcoded URL in the code

Yes sorry about that it was something quick. I like the way you edited the file and may use it. I didnt even think about the active and non active items. This was my first shot at a module. I also apologize about not realizing it was for just CMPS. Thought it might of been able to be used without it.

Ok. What version of ZenCart were you programming it for?

Thanks for making this guys. Any idea if there is a zen-cart and vbulletin bridge out there so they can share the same userid and password?

other??? , waiting for other cart