REQ: mod that shows users who have given most comments

[eZz]

Is there any mod that show TOP users who have commented pics? Like i can put a putton for home site like " Tops users " or smthing?

[paburmester]

im interested too

[beseech]

sounds interesting

[Loda]

ok... here we go!

In includes/page_header.php
find

Code: [Select]

?>
Add before:

Code: [Select]

$sql = "SELECT user_comments, user_name, user_id FROM ".USERS_TABLE."
WHERE user_level >= '".USER."'
ORDER BY user_comments DESC
LIMIT 25";
$result = $site_db->query($sql);

while ($row = $site_db->fetch_array($result)) {
$last_action_user_list .= '<a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_comments'].'</span><br>';
}

$site_template->register_vars(array(
"user_comments_list" => $last_action_user_list,
));
unset($user_comments_list);
insert in templates/<your templates>/home.html

Code: [Select]

<table border="0" cellspacing="1" cellpadding="1" background="{template_url}/images/cat.gif" width="100%">
  <tr>
    <td height="20" background="{template_url}/images/back1.gif">
       <b>Top 25 commenter </b></td>
  </tr>
  <tr>
    <td class="row1">{user_comments_list}</td>
  </tr>
</table>design is your part..
If u want to change from top 25 commenter to top 10 commenter just change this in page_header.php

Code: [Select]

LIMIT 25";to

Code: [Select]

LIMIT 10";

[V@no]

strongly suggest not to use page_header.php unless you want display this information on EVERY page. Otherwise use the specific file where you want it be displayed (index.php)
and another little fix:

Code: [Select]

$last_action_user_list .= '<a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_comments'].'</span><br>'; should be:

Code: [Select]

$last_action_user_list .= '<a href ="'.$site_sess->url(ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id']).'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_comments'].'</span><br>';

[paburmester]

thanks! hey V@no where do i have to put it on my index.php??

[V@no]

above

Code: [Select]

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------

[beseech]

and about the inverse ? like who have receive more comments ?

[V@no]

Try this query:

Code: [Select]

$sql = "SELECT COUNT(c.comment_id) as user_comments, u.user_id, u.user_name
        FROM ".COMMENTS_TABLE." c
        LEFT JOIN ".IMAGES_TABLE." i ON (i.image_id = c.image_id)
        LEFT JOIN ".USERS_TABLE." u ON (u.user_id = i.user_id)
        WHERE i.image_active = 1 AND u.user_level >= '".USER."'
        GROUP BY u.user_id
        ORDER BY user_comments DESC
        LIMIT 25";The number of comments will be available in $row['num'] variable.


[edit]
Query updated, no $row['num'] is needed (available) anymore

[Stoleti]

i've tried the last code, and this show the same !! only change the usernames order , not the top of ( the user with more received comments " not the comments we've wrote, but how the user have received, allmost "popularity"


 

[V@no]

And how do you check that it shows not correct users?
I've checked this query in phpmyadmin and it did showed me the correct users, the users who's picutures got in total the most comments. (well, obviosly I didn't go and count 1000+ comments for first few users, but it looked nearly right to me)

[Stoleti]

i mean this show "how many user have wrote " and not " how many comments user have receive" 

[V@no]

i mean this show "how many user have wrote " and not " how many comments user have receive"

The original code is showing "how many comments user wrote" and my query shows for "how many comments user have received from all his images"

[V@no]

Ok, I think I see why you say so.
As I mentioned in my post, the number of comments will be avalable in $row['num'] so you will need made further changes in the code to show the value of that function

I just updated my post, with new query, which will show proper names/numbers without needed change anything else in the code

[Stoleti]

thanks V@no  , now its working !!!!