[MOD] [3.0.X] Like Mod (Beğeni Modu)

CREATE TABLE `phpbb_likes` (
  `like_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `forum_id` MEDIUMINT UNSIGNED NOT NULL,
  `topic_id` MEDIUMINT UNSIGNED NOT NULL,
  `user_id` MEDIUMINT UNSIGNED NOT NULL,
  `username` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`like_id`)
);

viewtopic.php

'U_POST_REPLY_TOPIC'    => ($auth->acl_get('f_reply', $forum_id) || $user->data['user_id'] == ANONYMOUS) ? append_sid("{$phpbb_root_path}posting.$phpEx", "mode=reply&f=$forum_id&t=$topic_id") : '',

'U_LIKE_TOPIC'          => ($phpbb_root_path."posting.".$phpEx."?mode=like&f=".$forum_id."&t=".$topic_id),
'U_LIKE_USERS_LIST'     => (get_like_list($forum_id, $topic_id)),

styles/prosilver/template/viewtopic_body.html (Tüm stiller için geçerlidir.)

<!-- IF S_DISPLAY_SEARCHBOX -->
      <div class="search-box">
         <form method="post" id="topic-search" action="{S_SEARCHBOX_ACTION}">
         <fieldset>
            <input class="inputbox search tiny"  type="text" name="keywords" id="search_keywords" size="20" value="{L_SEARCH_TOPIC}" onclick="if(this.value=='{LA_SEARCH_TOPIC}')this.value='';" onblur="if(this.value=='')this.value='{LA_SEARCH_TOPIC}';" />
            <input class="button2" type="submit" value="{L_SEARCH}" />
            <input type="hidden" value="{TOPIC_ID}" name="t" />
            <input type="hidden" value="msgonly" name="sf" />
         </fieldset>
         </form>
      </div>
   <!-- ENDIF -->

<div class="search-box" valign="bottom">
          <form method="post" id="like-button" action="{U_LIKE_TOPIC}">
                <input class="buttonlike" type="submit" value="" />
          </form>
    </div>

<!-- IF PAGINATION or TOTAL_POSTS -->
      <div class="pagination">
         <!-- IF U_VIEW_UNREAD_POST and not S_IS_BOT --><a href="{U_VIEW_UNREAD_POST}">{L_VIEW_UNREAD_POST}</a> &bull; <!-- ENDIF -->{TOTAL_POSTS}
         <!-- IF PAGE_NUMBER --><!-- IF PAGINATION --> &bull; <a href="#" onclick="jumpto(); return false;" title="{L_JUMP_TO_PAGE}">{PAGE_NUMBER}</a> &bull; <span>{PAGINATION}</span><!-- ELSE --> &bull; {PAGE_NUMBER}<!-- ENDIF --><!-- ENDIF -->
      </div>
   <!-- ENDIF -->
    
</div>

<!-- IF U_LIKE_USERS_LIST --> 
<div class="panel">
    <div class="inner">
        <span class="corners-top"><span></span></span>    
        <div style="width:100%">        
            {U_LIKE_USERS_LIST} like this Topic.
        </div>
        <span class="corners-bottom"><span></span></span>
    </div>
</div>
<!-- ENDIF -->

includes/functions_display.php

?>

function get_like_list($forum_id, $topic_id)
{
    global $db, $config;
            
    $sql = "SELECT user_id, username FROM phpbb_likes
            WHERE forum_id=$forum_id AND topic_id=$topic_id
            ORDER BY username ASC;";

    $result = $db->sql_query($sql);
    
    $result_set = $db->sql_fetchrowset($result);
    
    for($i = 0; $i < sizeof($result_set); $i++)
    {
        $like_list .= "<a href=\"memberlist.php?mode=viewprofile&u=".$result_set[$i]['user_id']."\">".$result_set[$i]['username']."</a>";
        
        if ($i < sizeof($result_set) - 1)
        {
            $like_list .= ", ";   
        }
    }

    return $like_list;   
}

posting.php

default:
      $sql = '';
   break;

case 'like':
          if ($user->data['username'] != "Anonymous")
          {
            submit_like($forum_id, $topic_id, $user->data['user_id'], $user->data['username']);
          }
          
          redirect(append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&t=$topic_id"));
    break;

styles/prosilver/templates/overall_header.html

</head>

<link href="{T_THEME_PATH}/mods.css" rel="stylesheet" type="text/css" />

styles/prosilver/theme/mods.css

/* Like Mod Styles */

.buttonlike {
   background-image: url('images/thumbs_up2_22x20.jpg'); 
   background-color:Transparent;
   width:28px;
   height:25px;
   padding:0px 0px 0px 0px;
   background-repeat:no-repeat;
}

styles/prosilver/theme/images/thumbs_up2_22x20.jpg