Modified Date and Time changing on multiple listings at the same time

[MrGForce]

Just curious if someone knows the answer to this ....

I just went into my phpadmin to see what the field was named that holds the time and date for when a listing is modified and found something very interesting, but also confusing.

The "modified" field is showing the same EXACT date and time for multiple listings when only ONE listing is modified. One of my categories has 20+ items in it, and when I look at the modified field, all but 2 of the listings have the EXACT date and time indicated. Two stayed as they were. Only one (1) was modified.

I wanted to use that field to display my listings, as I wanted modified listings to again appear at the top of the list just under the featured listings, so that folks would see the new info. I know some don't like that idea, but that's the way this forum works in a round about way. You'd never know something was added unless it was brought back to the top.

After seeing that the date and time are being changed for multiple listings at the same time, using this field as a sort field would be useless.

Does anyone have any ideas that would allow me to show modified listings at the top of the list. Maybe an idea that would change the date added field when it is modified.

Any ideas would be greatly appreciated.


.

[Blair]

Strange!

Have you run any queries in phpmyadmin recently? What table and field did you find these values in?

[MrGForce]

Hi Blair;

Under structure, I clicked on "listings". And then I went to the field called .... "modified".

I thought I could use this field to display my listings. If you want to see for yourself, simply modify just one of your listings, then go into your phpmyadmin and check it out for yourself. You'll see that all, or almost all, of the listings in that particular category have had their modified field changed to exactly the same time and date. I don't think it should be doing that, and would like to find out how to stop that, if possible, so that I can possibly use that field to sort listings in the .... "showlistings.tpl" display.

And if this can't be done, would you know how to tell the program to reset the listings "dateadded" field to the current date and time when someone modifies their listing? That would solve my showlistings issue.

Any thoughts?

[Mike-N-Tosh]

I'm not sure what you are looking at as there is no "modified" field in the listings table. Do you have a module installed that perhaps altered the table and added that field?

These are the fields that are in the listings table by default:
id, owner, title, section, shortDescription, description, featured, price, display, hitcount, dateadded, expiration, url, notified, searchcount, repliedcount, pBold, pHighlighted, notes, orderID

[MrGForce]

Mike;

I have no clue where the modified field came from.

I have a bunch of modules activated including all of the templatecodes, youtube, membership, newsletter, comments, twitter and the seller store. I believe all the rest came with 68c.

Maybe one of those programers will let us know if one of their modules added that field. I just activated them, and that's it.

I haven't changed or added anything in the database myself. I just saw that field and thought it was added by 68c, and thought I could use it.


.

[Lhotch]

What was the name of the table that has the "modified" column in it?

I make it a habit to not alter the default 68C database tables at all and if I need additional data associated with something I create my own database table and use a join.

[MrGForce]

The "modified" field is under the .... "listings" table as I mention previously. It is right there along side all the ones Mike indicated in his reply.

[Lhotch]

Well, I can tell you that neither the membership nor youtube mod alter the default tables so it must be from somewhere else.

[MrGForce]

Thanks Larry.

Maybe Eric has an idea as to where it may have come from. I would have sworn it was a 68c field, but Mike said no. So now, the only other modules, other than eric's would be from the templatecodes.

And to be honest, right now I'm really not concerned anymore with that modified field, as it's definitely being used for something, because it is changing. What I'd really like to know is if someone knows how to change the dateadded field when a listing is modified. That way I wouldn't have to mess with any other functions to have my listings show the way I want them to.

You actually told me how to populate a hidden file with the coupon code, which was done in the includes/core/checkout/step3submit.php file .... and it works great by the way. Your response that told me how to do that is located at .... http://www.68classifieds.com/forums/...ing-field.html

Could I do the same thing with the dateadded field when a listing is modified? Could I have it change to the current date and time? And if so, do you know what file I would have to modify. I've tried finding it myself, but so far I can't seem to locate what the modifying process is using.


.

[seymourjames]

Are you talking about this

`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

I think this is coming from the sitemap generator to time stamp pages which have been change. I don't think you can use it for the purpose you are thinking of.