Do your users like visitor messages? Here you can check it out

[محروم.كوم]

Do your users like Visitor Messages? My don't. They rarely use them as I noticed with this query. This gives you the list of visitor messages per day: admincp>maintenance>run sql query
Code:
SELECT count( * ) , DATE_FORMAT( from_unixtime( dateline ) , '%d %m %Y' ) AS formatted_date
FROM visitormessage
GROUP BY formatted_date
ORDER BY dateline DESC
Who posts the most? On my board, female members post most messages
Code:
SELECT username, count( * ) AS number_messages
FROM user, visitormessage

WHERE user.userid = visitormessage.postuserid
GROUP BY user.username
ORDER BY number_messages DESC
Whoms wall is filled with most posts?
Code:
SELECT username, count( * ) AS number_messages
FROM user, visitormessage
WHERE user.userid = visitormessage.userid
GROUP BY user.username
ORDER BY number_messages DESC

What about your users? __DEFINE_LIKE_SHARE__