Random post

This SQL report shows a random message/reply in the forum system. It will only show the approved messages and the last revision.

To make sure the visitor gets a random post on every refresh, put the 'Cache Timeout' to 0 seconds. 

SELECT
  content
FROM
  Post,
  assetData
WHERE 
  assetData.assetId = Post.assetId
AND
  assetData.status = 'approved'
AND
  Post.revisionDate = (SELECT MAX(Post.revisionDate) FROM Post WHERE assetData.assetId = Post.assetId)
ORDER BY
  RAND()
LIMIT 1

content

Hi, good job with this site! I wonder if the vCard feature you show here will make into the WebGUI core soon (maybe with the link to download the vCard integrated into each user profile...). Thanks