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

Like vs Message ratio

Discussion in 'Forum Management' started by Onimua, Mar 4, 2011.

  1. Onimua

    Onimua Well-Known Member

    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
     
  2. Kier

    Kier XenForo Developer Staff Member

    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 |
    +-----------------+---------------+------------+-----------------+
     
    krstep, Darkimmortal, random and 3 others like this.
  3. Onimua

    Onimua Well-Known Member

    Very nice snapshot of that, Kier, thanks!
     
  4. Walter

    Walter Well-Known Member

    Damn, my own ratio is 0.52, didn't make it into the list. Now my ego cries :D
     
    bambua likes this.
  5. bambua

    bambua Well-Known Member

    There's a like to help you Walter! :)
     
    Walter likes this.
  6. dieketzer

    dieketzer Well-Known Member

    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.
     
  7. AnthonyCea

    AnthonyCea Well-Known Member

    I'd like spam you if I could Walter !!
     
  8. Walter

    Walter Well-Known Member

    I have to stop posting, otherwise my ratio gets worse :(
     
    tickedon likes this.
  9. Brogan

    Brogan XenForo Moderator Staff Member


    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.
     
    Jeffin likes this.
  10. dutchbb

    dutchbb Well-Known Member

    0.4543 ... I need to do less posting or be even nicer I guess.
     
  11. Wuebit

    Wuebit Well-Known Member

    How the hell is Mike all the way down there! *runs to like all Mike's posts*
     
  12. AnthonyCea

    AnthonyCea Well-Known Member

    Kier has taken all the like abuse fun right out of this forum !! [​IMG]
     
  13. Luke F

    Luke F Well-Known Member

    11th, not bad I suppose :p
     
    Vodkaholic likes this.
  14. Wuebit

    Wuebit Well-Known Member

    12th you mean :p
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    Ratio, smatio.

    It's the total that counts :D
     
  16. Tigratrus

    Tigratrus Well-Known Member

    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?! ;)
     
  17. mjp

    mjp Well-Known Member

    I think it has more to do with the recognition of genius, near as I can tell.
     
  18. Dean

    Dean Well-Known Member

    sooo... will anyone like mjp's post? That is the question. ;)
     
  19. Jaxel

    Jaxel Well-Known Member

    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.
     
  20. Brogan

    Brogan XenForo Moderator Staff Member

    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.
     

Share This Page