![]() |
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? |
الساعة الآن 12:22 PM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir