Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

Newest Products

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #21  
Old 07-09-2003, 10:47 PM
 
genekurtz genekurtz is offline
 

eXpert
  
Join Date: Jun 2003
Location: US
Posts: 223
 

Default

Is this supposed to work on 3.4.2 or is it just for the older version? Cyberactive...nice site.
__________________
Gene Kurtz
The Perfect Game
http://www.perfectgame.biz
866-318-BOWL
Reply With Quote
  #22  
Old 07-09-2003, 11:34 PM
 
funkydunk funkydunk is offline
 

X-Man
  
Join Date: Oct 2002
Location: Cambridge, UK
Posts: 2,210
 

Default

I haven't tested this on a 3.4.x site but there is no reason that it shouldn't work.
__________________
ex x-cart guru
Reply With Quote
  #23  
Old 08-09-2003, 05:59 PM
  DataViking's Avatar 
DataViking DataViking is offline
 

eXpert
  
Join Date: Jan 2003
Location: Las Vegas, NV
Posts: 361
 

Default I got it

Quote:
Originally Posted by cyberactive
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.

nice change, i try the first query and my home page was loaded with pictures.

thanks again, very nice mod.

by the way do anyone have a way to add this mod to a link insted of the front page?
Reply With Quote
  #24  
Old 08-25-2003, 12:00 PM
 
rodneyw rodneyw is offline
 

Senior Member
  
Join Date: Mar 2003
Posts: 162
 

Default

Just noticed I am having some problems with the script on 3.4.4

It is probablly having to do some other modifications I have done but here are my issues. If anyone would like to help me sort them out I can put the files up.

1. I modified the newest.tpl file to include featured="Y" so that I could use the multi-colum format provided by using the products_t.tpl file.

I am now getting duplicate listings, if I chose to show 6 products instead of 6 products I am getting 2 sets of 3 products.

2. The Buy Now buttom is NOT working for the NEWEST products listed by the mod. The Featured listings are still working properly though.

When I view the source after the page is displayed everything seems to be correct:
Code:
<table width=100% style="border-style: solid; border-width: 1"> <tr> <td><center> <a href=product.php?productid=2591&cat=&page=><font size="1">See Details</font> [img]../image.php?productid=2591[/img]</a> </center></td> <td valign=top> OPI - Sand-erella</font> <font size=1> Sand-erella </font> <hr size=1 noshade width=175 align=left> <font class=ProductPrice>Our Price: $ 5.67</font> <table border=0 width=100% cellpadding=0 cellspacing=0> <FORM name="orderform_2591_1061578337" method=post action="cart.php?mode=add"> <input type=hidden name=productid value="2591"> <input type=hidden name=cat value=""> <input type=hidden name=page value=""> <tr> <td height=25 nowrap>Quantity <select name=amount> <option value="1" >1</option> <option value="2" >2</option> <option value="3" >3</option> <option value="4" >4</option> <option value="5" >5</option> </select> </td> </tr> <tr> <td width=100% height=25 background-color:#FFFFFF" onMouseover="this.style.backgroundColor='#FFcc00';" onMouseout="this.style.backgroundColor='#FFFFFF';"> <input type=hidden name=mode value=add> <font class=FormButton>[img]../skin1/images/go.gif[/img]Buy Now</font> </td> </tr> </FORM> </table>

help ... anyone?
Reply With Quote
  #25  
Old 08-25-2003, 04:34 PM
 
rodneyw rodneyw is offline
 

Senior Member
  
Join Date: Mar 2003
Posts: 162
 

Default

never mind .. I found the error of my ways.

It seems that If I need to figure out any issues I have, I need to just go ahead and post it first becasue it never fails I figure it out before anyone takes pity on me and helps me

Sure makes it a tough way to learn but it sticks
Reply With Quote
  #26  
Old 09-03-2003, 08:26 PM
 
jeeya jeeya is offline
 

X-Adept
  
Join Date: May 2003
Location: USA
Posts: 807
 

Default .

Is there a Way to Display New added Products Catagorywise - If customer visits specific catagory he can see new products added in that specific main catagory?
Reply With Quote
  #27  
Old 09-03-2003, 10:49 PM
 
funkydunk funkydunk is offline
 

X-Man
  
Join Date: Oct 2002
Location: Cambridge, UK
Posts: 2,210
 

Default

yes
__________________
ex x-cart guru
Reply With Quote
  #28  
Old 10-23-2003, 06:39 PM
 
GregCroft GregCroft is offline
 

Newbie
  
Join Date: Oct 2003
Posts: 9
 

Default

Quote:
Originally Posted by funkydunk
yes

Does that mean we have to buy your module?
__________________
Greg Croft
-Webmaster for ModernPerformance.com, your domestic 4 cylinder performance specialists.
Reply With Quote
  #29  
Old 10-23-2003, 08:57 PM
 
shasan shasan is offline
 

Advanced Member
  
Join Date: Oct 2003
Location: Toronto
Posts: 74
 

Default

Was anyone successful in getting a multi-column display for this mod. I'm still trying to figure that one out.

any help would be great.

Thanks to all yallz.
__________________
X-Cart 3.4.2 - Processor: Dual Hamsters, running on tricked out 21\" version of Hamster Wheel. (tireless little buggers)

No hamsters were harmed during the making of this sig. Several were seriously offended.
Reply With Quote
  #30  
Old 10-23-2003, 10:29 PM
 
funkydunk funkydunk is offline
 

X-Man
  
Join Date: Oct 2002
Location: Cambridge, UK
Posts: 2,210
 

Default

Quote:
Originally Posted by shasan
Was anyone successful in getting a multi-column display for this mod. I'm still trying to figure that one out.

any help would be great.

Thanks to all yallz.

The mod on my site uses the normal product listing layout from the rest of your site so if you are using multi column it will display like that.
__________________
ex x-cart guru
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:13 PM.

   

 
X-Cart forums © 2001-2020