[phpbb3] Like system that shows who liked a post

First topic message reminder :

The content in this test is experimental, and all instructions SHOULD be READ and FOLLOWED. Failure to do so may cause unwanted side effects. USE WITH CAUTION !!

As many people want a like system to show who liked posts, I'll give you the chance to test it. You should know already that our forums do not have databases which we can interact with and the majority have no idea how to use a database. This plugin will make use of a topic as a database to store like information. This will require a group with moderation privileges. Before you continue, please take note of the following.

• This was developed for phpbb3 and is not guaranteed to work on other versions
  
• The method to store data is not secure, and can be overwritten or deleted ( it's recommended to keep backups of DBs )
  

This test should help you achieve the following, if done correctly.



Creating a new table

To create a new table in your database, you first need to follow the installation process here : https://fmdesign.forumotion.com/t281-fa_db-database-installation

If you followed the tutorial above, paste the code below as the topic contents. Otherwise if you've already set your database up, click "edit database" and scroll down to the quick reply to add a new table.

Code:

[table class="database_table" id="fa_likes"][tr][td]Post ID[/td][td]Users[/td][/tr][/table]

Installation

So our like button has a style go to Administration Panel > Display > Colors > CSS stylesheet, and paste the following codes.

Code:

/* START fa_like */
.fa_like_row { margin-top:6px }
.fa_like_list { font-style:italic; min-height:25px; }
a.fa_like_button, .fa_like_button, .fa_liked { color:#FFF; font-size:10px; background:#6A6; border:1px solid #686; border-radius:3px; display:inline-block; padding:3px 6px; cursor:default; }
.fa_liked { cursor:default; opacity:0.3; }
a.fa_like_button:hover { background:#3A3; border:1px solid #383; cursor:pointer; }
/* END fa_like */

Finally the last part you've been waiting for, the like system. Create another script :

Title : fa_likes
Placement : In the topics

Code:

$(function(){
  var pid = 270,
  i = 0,
  lang = {
    like : 'Like',
    loading : 'Loading...',
    people : 'People like this post.',
    person : 'Person likes this post.'
  };
 
  $('.post').each(function() {
    var plus = $(this).find('.vote-button:first a'), id = $(this).attr('id').slice(1), clear = $(this).find('.clear'), votes = 0, text = lang.people;
 
    if (plus.length) clear.after('<div class="fa_like_row"><a class="fa_like_button" href="'+plus.attr('href')+'">'+lang.like+'</a></div>');
    else clear.after('<div class="fa_like_row"><span class="fa_liked">'+lang.like+'</span></div>');
 
    if ($(this).find('.vote-bar').length) {
      votes = Number($(this).find('.vote-bar').attr('title').replace(/.*?\((\d+)\s.*/,'$1'));
      if (votes == 1) text = lang.person;
    }
 
    $(this).find('.fa_like_row').append('<div class="fa_like_text">'+votes+' '+text+'</div><div class="fa_like_list" id="fa_like_list'+id+'">Loading...</div>');
    $(this).find('.vote').remove();
 
  i++;
  if (i==$('.post').length) {
      $.get(_database.tid, function(data) {
      $('.post').each(function() {
        var id = $(this).attr('id').slice(1), dblikes;
          $('#fa_like_list'+id).html('');
          if ($('#fa_likes #likes'+id,data).length) {
            dblikes = $('#fa_likes #likes'+id,data).text().replace(/likes=\{(.*?)\}/,'$1').split(',');
            for (var i=0; i<dblikes.length; i++) {
              var comma = ', ';
              if (i==dblikes.length-1) comma = '';
              $('#fa_like_list'+id).append(dblikes[i].replace(/^(.*?):(.*?)$/,'<a href="/u$1">$2</a>'+comma))
            }
          }
      });
    });
  }
  });
 
  $('.fa_like_button').on('click', function() {
    var id = $(this).attr('href').replace(/^.*?p\_vote=(\d+)$/,'$1');
    $(this).after('<span class="fa_like_button">'+lang.loading+'</span>').hide();
    $.get($(this).attr('href'), function() {
    _database.post({
        pid : pid,
        tableid : 'likes'+id,
        update : ['\\[td id="likes'+id+'"\\]likes=\\{(.*?)\\}\\[/td\\]','[td id="likes'+id+'"]likes={$1,'+_userdata.user_id+':'+_userdata.username+'}[/td]'],
        newRow : '[tr][td]t'+window.location.pathname.replace(/\/t(\d+).*/,'$1')+'p'+id+'[/td][td id="likes'+id+'"]likes={'+_userdata.user_id+':'+_userdata.username+'}[/td][/tr]',
        reload : true
      });
    });
    return false;
  });
});

You must make sure to change the pid to your database table ID. To do that, edit the post which contains your like table, and copy / paste the following portion of the URL as the PID value.


When finished, it should look like the following, except a different ID.

Code:

pid = 270,

Save the script, and it should now be setup if you followed all steps correctly !! Go like some posts and the database should then update with a new table row for posts that haven't been liked. When you visit posts, they should display who liked them if it's logged within the database.


If you have any questions or comments you may leave them below. Have fun with this experimental system !

I have problem:
Like
8 People like this post.

But don't show names:
Ch@lo Valdez, Rhino.Freak, Grow, Niko!, AlexisMcDevin, Ikerepc, smejker

Is it a post that has been liked before the installation of this script ?

I try like new post now and it saying loading... for few sec but don't show names.

It's most likely because of this : https://fmdesign.forumotion.com/t318p105-forumotion-shoutbox#2716

Done but still loading... for few sec and not show names who like, and here i am using same pid as in the Shoutbox?

You should make a new reply to the database topic with the correct database table as the message content. E.G. :

Code:

[table class="database_table" id="fa_likes"][tr][td]Post ID[/td][td]Users[/td][/tr][/table]

If you're using the same post it's going to cause problems.

Ange Tuteur wrote:You should make a new reply to the database topic with the correct database table as the message content. E.G. :

Code:

[table class="database_table" id="fa_likes"][tr][td]Post ID[/td][td]Users[/td][/tr][/table]

If you're using the same post it's going to cause problems.

i have x3 of this now

You only need one for each table, so delete the extra tables of this.

ok i deleted 2 and i have 2, but it still not showing names

Click the edit button on your likes table and replace the contents with this :

Code:

[table class="database_table" id="fa_likes"][tr][td]Post ID[/td][td]Users[/td][/tr][/table]

That looks like chatbox message data from your screen shot. Make sure the PID for the script is the same as your likes table, and that the reputation system is enabled. Furthermore a group for members is needed for them to modify the table.

meh not work

hi again
is this project ready for other versions like phpbb2 ?

hello there , any chance to make this system for punbb?

i think our legendary coder is busy these days
we need to wait i guess
take your time boss

Miltonius wrote:hello there , any chance to make this system for punbb?

The script above is only for phpbb3. Unfortunately I've not rewrote the script for all versions, yet.

okay ill wait
i hope it been soon
thanks again our legendary coder

Yo it almost work almost because it show only me - my name when i like posts, for other users it not work

Theshaka wrote:Yo it almost work almost because it show only me - my name when i like posts, for other users it not work

up up?

What problem precisely do your users have with it?

don't ask me what i did wrong but for some reason members that aren't me can't use the like button so i did something to make it admins only but they can still see the button

Are they trying to like someone else's posts or their own? Because if it is their own, they will not be able to. This is supposed happen.

If this is not the case, may you please include the following info in your post:
->The current code for your like system
->A screenshot of what the members' having trouble are seeing

this way we can better assist you.

-Brandon

the code for the like button is the exact same as here except with my info i know i did the database right because the shoutbox and views work perfectly but for some reason only admins on my forum can use the like button but everyone can see it

Are you sure only admins can use it? I am not sure if that is even possible. It might be, would have to wait for @Ange Tuteur to reply though.

Meanwhile, may you ask your users for a screenshot of what they see?

hi Ange Tuteur!
if u remmember i needed this system alot!
now i cant use it
it dont write name of who like it just write 1 person like it

Hello @qmars(pkq) ,

What is exactly is your problem? Have you installed the database topic? That is needed for this to work.

-Brandon