Can i get this information?

[aceofspades]

Hi guys!

Im trying to plan a mod, and im wondering if i can get all of the below information from the vbulletin database.

*Which was the last user to login, and how long ago was his last action (clicking a link)
*What was the last post and who made it and in what from and what date / time it was posted.
*What was the last thread, what was it called, who made it, and how long ago.
*Who made the last pm. Who it was to, and how long ago.

Does this sound possible? Would getting all this information from the database take a long time?

[MarkPW]

Yes, it's possible to retrieve all the data you want.

[Opserty]

[sql]
SELECT * FROM X ORDER BY Y DESC LIMIT 1
[/sql]

1. X = session Y = lastactivity
2. X = post Y = dateline
3. X = thread Y = dateline
4. X = pmtext Y = dateline

I think its something like that.