coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Leny on March 01, 2007, 08:03:42 PM

Title: How to reveal vote_time string to a normal data
Post by: Leny on March 01, 2007, 08:03:42 PM
Hello.

Im wondering if there is a way to know the date of a certain vote...  ???

For example:  I have CPG 1.4, statics enabled and only registered users can vote picts.

I want to know WHO did this or that vote. So, through PHPmyAdmin I get a list of votes for a certain picture. In that list I can see three items:

1) pic_id (i know this data)
2) user_md5_id (in http://md5.rednoize.com/ I can put a md5 string and see the real number)

and

3) vote_time
Here is my problem because it shows a string like 1171755820 and I dont know what it means. Obviously is a date, but HOW can I convert that string in data that I can recognize ????  :-\
Title: Re: How to reveal vote_time string to a normal data
Post by: Nibbler on March 01, 2007, 08:38:22 PM
http://www.4webhelp.net/us/timestamp.php
Title: Re: How to reveal vote_time string to a normal data
Post by: Leny on March 02, 2007, 12:01:22 AM
You are a big genious!!!!
Thanks a lottttttt