[MOD] Top 25 uploader

[V@no]

think!

[nacho-lopez]

I got it... 
Thank you 

think!

[colorssky]

I have this error

_______________________________
DB Error: Bad SQL Query: SELECT user_t_images, user_name, user_id FROM 4images_users WHERE user_level >= '2' ORDER BY user_t_images DESC LIMIT 10
Unknown column 'user_t_images' in 'field list'
_______________________________

[colorssky]

need soultion urgent plzzzzzzzzz 

[V@no]

Step 1

[IGC]

I have created a new TOP UPLOADERS MOD that works with versions 1.7.3 and up... When I installed this one I was getting several errors, so I decided to create my own...

It has 3 possible layouts, a small horizontal bar (just like, current users online). A vertical bar, that goes in the homepage, on the right side, including avatars and a full page with 3 different categories for the uploaders (#of images, #of hits on their images, and #rating).

You can check out the results here: http://anime.igc-web.com/gallery

And the post with the mod is here: http://www.4homepages.de/forum/index.php?topic=14173.0

If you try it and you like it, respond on the other post so the admins change it to the published mod section

I hope you guys like it.

[lemccoy]

Hi - I had this mod installed before I had to upgrade to 1.7.4

I don't have a problem getting it to work after modifyin by the third or so post.  The problem is I want to show the top 5 users by # of comments.  How do I modify this code to show it?  I am using {user_comments_list} as my call in the home.html.

here is the original code for the top uploaders:

Code: [Select]

// top uploaders

$last_action_user_list = "";
$sql = "SELECT COUNT(i.image_id) AS user_t_images, u.user_name, u.user_id
        FROM ".USERS_TABLE." u
        LEFT JOIN ".IMAGES_TABLE." i ON (i.user_id = u.user_id)
        WHERE u.user_level > ".GUEST."
        GROUP BY u.user_id
        ORDER BY user_t_images DESC
        LIMIT 5";
$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_t_images'].'</span><br>';
}

$site_template->register_vars(array(
"user_uploaders_list" => $last_action_user_list,
));
unset($user_uploaders_list);
how do I modify this to sort by the top # of comments by user?  I did it before I just can't figure out what I did!

Thanks

[lemccoy]

Code: [Select]

ok i got most of my site back except this one part as above.  here is what I tried and it didn't work - can someone please help out? 

[code}
// top commentators

$last_action_user_list = "";
$sql = "SELECT COUNT(i.image_comments) AS user_t_images, u.user_name, u.user_id
        FROM ".USERS_TABLE." u
        LEFT JOIN ".IMAGES_TABLE." i ON (i.user_id = u.user_id)
        WHERE u.user_level > ".GUEST."
        GROUP BY u.user_id
        ORDER BY user_t_comments DESC
        LIMIT 5";
$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_t_comments'].'</span><br>';
}

$site_template->register_vars(array(
"user_comments_list" => $last_action_user_list,
));
unset($user_comments_list);


any help is much appreciated!

[Mr Kennedy]

Finde den Mod klasse...
allerdings würde ich die Top 10 Uploader gerne unter Top Bilder einfügen...
gibts es da eine gute Möglichkeit für?