The Arcive of vBulletin Modifications Site. |
|
|
#1
|
||||
|
||||
|
Hi all
Is there anyway to check the date that someone voted on a poll? For example, if 10 members voted on a poll, can I see exactly what dates they cast their votes? Thanks. --------------- Added [DATE]1323436896[/DATE] at [TIME]1323436896[/TIME] --------------- Ok, I've found the 'pollvote' table in phpmyadmin and there is a column that says 'votedate' but the data in that column is weird, it's not in a recognisable date format. How do I decipher it? Thanks
|
|
#2
|
|||
|
|||
|
The date is a unix timestamp. You could use a query like this:
Code:
SELECT *, FROM_UNIXTIME(votedate) AS date FROM pollvote Or if you prefer there's also php functions and online converters to display unix timestamps as text. |
| Благодарность от: | ||
| viper357 | ||
|
#3
|
||||
|
||||
|
Fanstastic, thank you. I found an online converter, thanks so much for the help.
|
![]() |
|
|
| X vBulletin 3.8.12 by vBS Debug Information | |
|---|---|
|
|
More Information |
|
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|