Date Renewal = Date Added

[pipelin +]

Hi,

There is an easer way that when user upgrade an Ad or Renewal an Ad changes the Date Added by new date.

Date Added May 01 2009

Date renewal Oct 01 2009


New Date Added = Oct 01 2009

[Eric Barnes]

The only way to do it would be to manually edit the Listings class when the listing is edited. Basically update the dateadded field then.

[pipelin +]

Thanks Eric,

Do you remember the lines to modify?

[Eric Barnes]

Around line 1174:

$sSQL=sprintf("UPDATE ".PREFIX."listings SET ".$updateSQL." title=%s,shortDescription=%s,desc.......

to:

$sSQL=sprintf("UPDATE ".PREFIX."listings SET ".$updateSQL." title=%s,shortDescription=%s,dateadded=NOW(),desc.......

[pipelin +]

thank you very much.

[pipelin +]

Originally Posted by Eric Barnes

Around line 1174:

$sSQL=sprintf("UPDATE ".PREFIX."listings SET ".$updateSQL." title=%s,shortDescription=%s,desc.......

to:

$sSQL=sprintf("UPDATE ".PREFIX."listings SET ".$updateSQL." title=%s,shortDescription=%s,dateadded=NOW(),desc.......

Hi,

I found this in includes/classes/kernel/listings.php V4.1.6, around 1174, but $updateSQL isn't included. Also I added dateadded=NOW(), after that, I upgraded an Ad, but the field "Date Added" in the showlistings and viewlisting show up the older date.

I'm not sure if I did something wrong.

if(!defined('IN_ADMIN')) 
		{
			$sSQL=sprintf("UPDATE ".PREFIX."listings SET title=%s,shortDescription=%s,dateadded=NOW(),description=%s,featured=%s,price=%s,display=%s,url=%s,pBold=%s,pHighlighted=%s WHERE id=%s AND owner=%s",
		         	GetSQLValueString(htmlspecialchars($data['title']),"text"),
					GetSQLValueString(htmlspecialchars($data['shortDescription']),"text"),
					GetSQLValueString(htmlspecialchars($data['description']),"text"),
					GetSQLValueString($data['featured'], "text"),
					GetSQLValueString($data['price'], "double"),
					GetSQLValueString($data['display'], "text"),
					GetSQLValueString($data['url'], "text"),
					GetSQLValueString($data['bold'], "text"),
					GetSQLValueString($data['highlighted'], "text"),
					GetSQLValueString($data['id'], "int"),
					GetSQLValueString($data['owner'],"int"));
		}
		else
		{
			$sSQL=sprintf("UPDATE ".PREFIX."listings SET owner=%s,title=%s,section=%s,shortDescription=%s,description=%s,featured=%s,price=%s,display=%s,dateadded=%s,expiration=%s,url=%s,pBold=%s,pHighlighted=%s WHERE id=%s",
		         	GetSQLValueString($data['owner'],"int"),
		         	GetSQLValueString(htmlspecialchars($data['title']),"text"),
		         	GetSQLValueString($data['section'], "int"),

[Eric Barnes]

Sounds like you may have an old file.

At any rate for issues like this I also just add debugging code below and then run a test. Something like:
echo $sSQL;die;

Then it will print what the exact query and better show you what is going on.

[pipelin +]

Hi Eric,

I have downloaded 68Classifieds V.4.1.6 and this file comes with the same lines. I think you took the file from an older or new version.


I'm stacked in the debugging text because my localhost isn't working properly.

[pipelin +]

I tried many ways but I couldn't.
Is there something to do in the ../core/renew spet1.php or step2.php?
thanks.

[Eric Barnes]

Sorry. That was for editing only.

View original Listings.php and and change this:

PHP Code:

function addFeatures($id, $data)
    {
        global $db;
        $sSQL="UPDATE ".PREFIX."listings SET ";
        $insertSQL="display='N', "; 


To:

PHP Code:

function addFeatures($id, $data)
    {
        global $db;
        $sSQL="UPDATE ".PREFIX."listings SET ";
        $insertSQL="display='N', ";
$insertSQL.="dateadded = NOW(), "; 


Yours may be different because of this bug report:
http://www.68classifieds.com/forums/issue-361/