Modify listing - reset dateadded

[mark +]

All

When a user renews their ad, we want to set the date added to the date renewed so that the ad appears at the top of the listings for that category and new listings etc. I think that I may have found a way to achieve this with minimal coding and was looking for some input from the experts out there.

In listings.php, the function editListing($data) updates the listing after an edit. I was hoping to
slot in : $now=date_now();
and replace: GetSQLValueString($data['dateadded'], "text"),
with: GetSQLValueString($now, "text"),
for the $sSQL UPDATE statement.

I am aware that this would populate any modified listing with the new dateadded but I think we could live with this.

Any thoughts?

Cheers

Mark
4... Developer

[Lhotch +]

If I was a user on your site and I knew I could just edit my ad to get its dateadded changed so it stayed at the top of things like recent ad listings etc I would be editing it every day.

[mark +]

Yes I can see that. But they could renew everyday and do the same.

I was going to implement and see what the result would be. If users were modfying every day, we could just turn it off and find another solution. It's finding the other solution that I am struggling to find.

Mark

[MrGForce +]

Good Morning Mark;

I've asked the same question several times in the forum and get the same response that you are getting. It shouldn't matter that others don't like the idea of changing the date added when a listing is edited, but there are those like us that would like this to be the case.

If I'm able to come up with a solution, I'll let you know. If you do, please let me know. Thanks.

[Lhotch +]

Originally Posted by MrGForce

Good Morning Mark;

I've asked the same question several times in the forum and get the same response that you are getting. It shouldn't matter that others don't like the idea of changing the date added when a listing is edited, but there are those like us that would like this to be the case.

If I'm able to come up with a solution, I'll let you know. If you do, please let me know. Thanks.

Personally I am a bit confused by the question in this thread. I understand what you want to do and Marks method should work. He should try it and find out. I assumed he was asking more for input on the why and if anyone saw a problem with it.

With coding its not always as simple as asking for an answer to the question of "whats 2 + 2?" and sometimes the best thing to do is try it. We have files nested in files and functions that call functions so sometimes the obvious answer doesnt always work as planned.

With that being said, you have been given a few pointers on how to accomplish your goal, you reported they didnt work but at the end of the day you are asking someone to cough up some code that works which means you want someone to dream up the code, implement it in a site, create an ad, edit the ad and just flat out test it for you.

If this functionality is so important to you then why dont you learn to use PHP?

[MrGForce +]

Didn't think we were asking for the world. Sorry it caused such a negative response.

I won't ask again, ever.

Have a great day.

[Eric Barnes +]

Things like this are why we added the new feedback system. Just make a request for a new date modified field and then if that is added it would be very easy to work with.

[Lhotch +]

Originally Posted by MrGForce

Didn't think we were asking for the world. Sorry it caused such a negative response.

I won't ask again, ever.

Have a great day.

Asking a question is fine and dandy, thats what the forum is for.

But then you go on to complain that you have asked many times before and still dont have an answer. It comes across like you expect people here to drop what they are doing and whip up some tested custom code for you. No where does it state that all of your custom coding needs will be freely given in a timely fashion.

The world revolves around knowledge. If you dont know how to replace your water heater you learn how or pay someone to do it for you. If your car breaks down you learn to fix it or pay someone to do it. When it comes to running a web site why do people assume that someone else should take time to solve their problem?

Have YOU tried Marks method above? I said above that it should work but you seem upset that I am not taking the time to implement and test it for you.

Where is your ownership of finding a solution to your problem? You dont seem to be taking any responsibility for finding a solution yourself beyond asking others to do it for you.

[mark +]

Been busy today with a featured listing problem and should have it sorted soon.

I will try my proposed changes in the morning and let you all know.

Mark

[mark +]

All

Unfortunately the code:
In listings.php, the function editListing($data) updates the listing after an edit. I was hoping to
slot in : $now=date_now();
and replace: GetSQLValueString($data['dateadded'], "text"),
with: GetSQLValueString($now, "text"),
for the $sSQL UPDATE statement.

Had no effect whatsoever. I even replaced the expiration date to date_now() and this had no effect either. Seems as though the function editListing($data) in Listings.php is not called when renewing the listing.

However, I did notice that when renewing a listing it is labeled as Upgrade in the user browse listings.

I have tried this through user->browse my listings and also by following the link given in the renewal email and both had no change in dateadded.

Does anyone know which function is called when an upgrade/renew is performed?

Mark