• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Like vs Message ratio

Onimua

Well-known member
#1
With some of you having far more active sites than I at the moment, I've been thinking about something while customizing and setting up new trophies.

What is your Likes vs Messages count look like? Are you getting one way more than the other? How fast? I'm trying to think of how high I should make some of these numbers for likes/messages in order to get trophies, and want to make sure that if I set something up it doesn't take a short amount of time to receive them when I intended it to be longer than that.

I figured it would be nice to have a place for people to post it here as well so they can compare their Like/Message count and, if they're using trophies actively, make adjustments on their own site. :)

Curious, Kier: What's yours look like on here? :p
 

Kier

XenForo Developer
Staff member
#2
Here's the current hall of fame, of active posters with their like/post ratio.

SELECT username, message_count, like_count,
(like_count / message_count) AS like_post_ratio
FROM xf_user
WHERE message_count > 250
ORDER BY like_post_ratio DESC
LIMIT 25;
Code:
+-----------------+---------------+------------+-----------------+
| username        | message_count | like_count | like_post_ratio |
+-----------------+---------------+------------+-----------------+
| Kier            |          3579 |       7660 |          2.1403 |
| Jerry           |           326 |        391 |          1.1994 |
| Fred Sherman    |           364 |        432 |          1.1868 |
| xfrocks         |           283 |        318 |          1.1237 |
| John            |           472 |        525 |          1.1123 |
| Shelley         |          2408 |       2565 |          1.0652 |
| Paul M          |           389 |        404 |          1.0386 |
| mjp             |           527 |        530 |          1.0057 |
| Jaxel           |          1302 |       1166 |          0.8955 |
| feldon30        |           448 |        379 |          0.8460 |
| Darkimmortal    |           620 |        503 |          0.8113 |
| Floren          |           298 |        231 |          0.7752 |
| Lawrence        |          1113 |        792 |          0.7116 |
| Dream           |           352 |        244 |          0.6932 |
| Ruven           |           352 |        240 |          0.6818 |
| Miko            |           433 |        291 |          0.6721 |
| The Sandman     |           566 |        376 |          0.6643 |
| Mike            |          3305 |       2162 |          0.6542 |
| bambua          |           285 |        179 |          0.6281 |
| Russ            |           703 |        438 |          0.6230 |
| EntropiaPlanets |           299 |        186 |          0.6221 |
| Mark.B          |           309 |        192 |          0.6214 |
| Erik            |          1359 |        805 |          0.5923 |
| GeeksKickAss    |           598 |        351 |          0.5870 |
| Grover          |          1428 |        837 |          0.5861 |
+-----------------+---------------+------------+-----------------+
 

dieketzer

Well-known member
#6
i have 30k posts, 140 users, no importing (community was born on xf) and it looks like the average is nearing 2 likes per 1 post. the likes definitely outnumber the posts on all but the most trollish members.
ppl click 'like' alot more than they do over here. i wouldnt assume kiers experience here is typical.
 

Brogan

XenForo moderator
Staff member
#9
Here's the current hall of fame, of active posters with their like/post ratio.
You missed this one from your list ;)

Code:
+-----------------+---------------+------------+-----------------+
| username        | message_count | like_count | like_post_ratio |
+-----------------+---------------+------------+-----------------+
| XenForo         |            78 |       2107 |         27.0128 |
+-----------------+---------------+------------+-----------------+
Although technically it doesn't qualify as there are less than 250 posts.
 

Tigratrus

Well-known member
#16
Rats... All the way down at .4945, I'm even worse off then Walter! Pah.
Clearly, I need to post less too and save it for the ones that are sure to be popular, cause it's all about popularity, right?! ;)
 

Jaxel

Well-known member
#19
I would make a mod using this... but its not very good for websites imported from VB3/4. For isntance, on my forums, I have 3000 posts from before likes were available... So those 3000 posts hinder my like/post ratio.
 

Brogan

XenForo moderator
Staff member
#20
Same situation on my forum - my post count before importing was much higher than anyone else so to even it out, it would only count posts after the import.