Support Forums


Go Back   68 Classifieds Forums > Help & Support > v4 Questions & Support

Notices

 
LinkBack Thread Tools Display Modes
Old 03-11-2009, 04:49 AM   #1
Member
 
Join Date: Jan 2009
Posts: 42
Rep Power: 2
sunshinemike is on a distinguished road
Default Re-order results in showlistings.tpl?

Hi

At the moment showlistings.tpl shows my listings with 'featured' first, and then the remaining listings in order they were added.

If possible I would like my listings to be ordered with

featured listings first
and then Product->listing package one (my most expense which shows photographs and links to customer website),
then Product->listing package two (my next most expensive package showing photogrpahs)
then Product->listing package three (text only ads)

I see in the database structure that the package used to purchase the listing is not stored - just a field for 'featured' (Y/N).

Is there any way I can order my listings in order of the 'package price' or 'package Id' (pId) ??

Am I right in assuming I would need to add a field to class_listings and pass the contents of the pPrice field in class_products to it when an order is placed? That way I could sort on the new field when showing listings?

Am I on the right track? can it be done?

Many thanks

Mike
__________________
V4.1.2 Developer

Beer.....so much more than a breakfast drink!
sunshinemike is offline   Reply With Quote
Old 03-11-2009, 10:02 AM   #2
68 Classifieds Staff
 
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,019
Rep Power: 116
Eric Barnes is a jewel in the rough
Default

Mike,

It could be done and this information is stored in the orders table. So I would probably recommend creating a join query to get this information out. Not very easy since that same query is very complex. Check Listings->getAllListings()
__________________
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 | 68 @ Twitter | My Modules
Eric Barnes 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
showlistings.tpl vs showlistings2.tpl ksuralta v4 Questions & Support 7 06-16-2009 02:40 PM
Extra Fields in showlistings.tpl skyblue v4 Questions & Support 2 09-20-2008 12:06 AM
Showlistings sql query wesse249 v4 Questions & Support 1 09-13-2008 06:50 AM
Featured ads in showlistings crystal v4 Questions & Support 5 07-18-2008 05:25 PM
Showlistings Nickb Modules / Plugins / Modifications 7 03-08-2008 05:27 AM


All times are GMT -4. The time now is 07:54 PM.


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