The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Polls - check date of votes?
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:
|