View Single Post
Old September 7th, 2011, 01:21 AM   #9 (permalink)
gmptp
Member
Verified Customer
 
Join Date: Mar 2010
Posts: 116
Quote:
Originally Posted by Chuck S View Post
yes relisting them is not going to bump them to the top cause all your doing is changing the expire date not the date posted etc.
Is there an expiration variable in the db to show the expire date in showcat, I know there's a duration variable in db that can be retreive that show 7 days 10 days, 15 days etc

Instead of displaying the duration of the ad in showcat, I like to display the expire date in addition to the date posted.

I found the enddate below, but the format for the enddate is "1315249683" <- what format is this and how can I convert to normal day, yy and month?

I've added below line to showcat.php and showcat.tmpl, but the output is in 1315249683 on my website, how can I convert 1315249683 to ->day yy and month? Help.


$ppdate = formatppdate( $date );
$pptime = formatpptime( $date );
$ppenddate = formatppenddate( $enddate ); <- I added this in showcat.php but doesn't convert.

--------dbase
SELECT *
FROM `pp_products`
ORDER BY `pp_products`.`enddate` ASC
LIMIT 0 , 30

-------- showcat.php
$gallery['ppenddate'][$count] = "$enddate";

-------- showcat.tmpl
{$gallery['ppenddate'][$x]}

Last edited by gmptp; September 7th, 2011 at 04:44 AM.
gmptp is offline   Reply With Quote