Support Forums

Old 05-26-2006, 08:49 AM   #1
Member
 
zman78's Avatar
 
Join Date: Mar 2006
Posts: 75
Rep Power: 13
zman78 is on a distinguished road
Default Help? Newest listings on homepage showing ALL Listings

Hello,
I am trying to limit the newest listing limit to 20 on my home page. It keeps showing all of them!

here is my hom.tpl file sectio for newest listings:

{new_listings number=20 table_attr='width="100%" style="border: 1px solid #000;"' td_attr='valign="middle" align="left"' img_break="

Shouldnt this show 20?

Zack
__________________
Zack

3.1 designer
zman78 is offline   Reply With Quote
Old 05-26-2006, 09:05 AM   #2
Moderator
 
Chaslie's Avatar
 
Join Date: Mar 2006
Location: Great Ocean Road - Australia
Posts: 713
Rep Power: 26
Chaslie will become famous soon enough
Default

zman78,
Agreed - there is certainly a problem with this - please be patient whilst it is been addressed.

Have added this to the 'Bug Tracker'.

In the meantime, if required, you may wish to disable your 'new listings' feature until a fix is organised.
__________________
Chaslie
V4.0.9 dev
AUSCITY

68 Classifieds Important Links
Customer Area | Issue Tracker | Knowledge Base | User Manuals

HTML Help
W3 Schools
Chaslie is offline   Reply With Quote
Old 05-26-2006, 09:13 AM   #3
The Master
 
Maffo's Avatar
 
Join Date: Mar 2006
Location: British in Argentina
Posts: 1,399
Rep Power: 41
Maffo is a jewel in the rough
Default

I ran into this problem a while ago.

A crude fix is if you open,

includes/classes/smarty/plugins/function.new_listings.php and look for this piece of code.

PHP Code:
 $sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC "
you can add LIMIT 20 to the end of the statement

PHP Code:
 ORDER BY p.dateadded DESC LIMIT 20"; 
Its not the ideal solution but it will get you through until this issue is resolved.
__________________
Super Mod v4 Is out and ready for download. DEMO
Purchase V4 Super Mod BETA at Reduced Price

Visit Me @ Classified-Sofware.co.uk

**Important** - All modules with the exceptions of the Bulk Upload System will be removed from my modshop on Tuesday September 30th. If you require a module you must get it before that date.
Maffo is offline   Reply With Quote
Old 05-26-2006, 11:17 AM   #4
Member
 
zman78's Avatar
 
Join Date: Mar 2006
Posts: 75
Rep Power: 13
zman78 is on a distinguished road
Default

I really dont mind it showing all of them for now, im just concerned for when i reach like 100 listings. Until then I am being patient!

Thanks!

Zack
__________________
Zack

3.1 designer
zman78 is offline   Reply With Quote
Old 05-26-2006, 11:24 AM   #5
68 Classifieds Staff
 
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 4,498
Rep Power: 102
Eric Barnes is a jewel in the rough
Default

v3.1.2 has this now fixed.
__________________
Eric Barnes
68 Classifieds Developer
Please do not send me a private message asking for support. Instead use these open forums or our ticket system.

Customer Area | Issue Tracker | Documentation | 68C Mods | Submit a Ticket | Twitter
Eric Barnes is online now   Reply With Quote
Old 05-26-2006, 08:47 PM   #6
Moderator
 
Chaslie's Avatar
 
Join Date: Mar 2006
Location: Great Ocean Road - Australia
Posts: 713
Rep Power: 26
Chaslie will become famous soon enough
Default

Thanks Maffo - appreciated.
__________________
Chaslie
V4.0.9 dev
AUSCITY

68 Classifieds Important Links
Customer Area | Issue Tracker | Knowledge Base | User Manuals

HTML Help
W3 Schools
Chaslie is offline   Reply With Quote

Bookmarks

Thread Tools
Display Modes

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Most Popular, Newest Listings, Highest Rated darek v3.1 Modules & Modifications 2 01-12-2007 09:34 AM
Listings not showing up chuggles v3.1 Questions & Support 5 10-05-2006 05:53 PM
Featured Listings on homepage martini55 v3.1 Questions & Support 6 09-20-2006 03:07 PM
Showing most recent listings on homepage martini55 v3.1 Questions & Support 7 08-14-2006 04:15 PM
Newest Listings On Home Page zman78 v3.1 Modules & Modifications 24 05-26-2006 09:23 AM


All times are GMT -4. The time now is 10:38 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0