[MOD] Top 25 uploader

[ascanio]

Hi Every one this MOD was here before the hack attack but then disapear so I'm going to re-post it I not the one who made this MOD so don't ask me for Support.

  Files to edit:

includes/page_header.php
templates/<your templates>/home.html

  Step 1 If you have The MOD Memberlist you don't need to do this step. Add a new field in the database called user_t_images [Propieties: Type: smallint; Lenght: 6; Null: not null; Default: 0. (from my phpAdmin)]

Or

you can use the table update from the MOD Memberlist.

  Step 2

In includes/page_header.php

Find:

Code: [Select]

?>
Add before:

Code: [Select]

$last_action_user_list = "";
$sql = "SELECT user_t_images, user_name, user_id FROM ".USERS_TABLE."
WHERE user_level >= '".USER."'
ORDER BY user_t_images 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_t_images'].'</span><br>';
}

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

  Step 3:

 In templates/<your templates>/home.html:

Add this:

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 Usuarios</b></td>
  </tr>
  <tr>
    <td class="row1">{user_uploaders_list}<br></td>
  </tr>
</table>

If u want to change from top 25 uploader to top 10 uploader just change this

Code: [Select]

LIMIT 25"; to this

Code: [Select]

LIMIT 10";

[ascanio]

I have try to upgrade the list to show the image gender of the user but i don't how so if any body knows please post it this can be useful to others too

[mightyaf]

The problem is I see 25 users with zeros next to the usernames like this
Guest 0
admin 0
phantom 0
mwenja 0
dhakari 0
bensonn 0
Even after installation I tried to upload pictures to see if the count would increment but no luck. Isn't the zero suppossed to be replaced by the number of pictures uploaded?
I wonder what I did wrong. All the help is greatly appreciated.

[JensF]

Hi you can test this....


http://www.4homepages.de/forum/index.php?topic=7289.0

[mightyaf]

Thanks I had to replace the code

$sql = "SELECT user_t_images, user_name, user_id FROM ".USERS_TABLE."
WHERE user_level >= '".USER."'
ORDER BY user_t_images DESC
LIMIT 25";

with this one

$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";

in page_header.php

Thank you very much.

[mightyaf]

I have the top 25 mod working, but how do I not include admin and Guest?
Thank you.

[V@no]

replace

Code: [Select]

        WHERE u.user_level > ".GUEST."with

Code: [Select]

        WHERE u.user_level = ".USER."

[mightyaf]

That got rid of admin. Thanks. I can live with that however how can I also remove Guest? Is guest considered a user? (technically). Can i fake the database by addind a zero so that guest does not appear. How do i do this?
Thank you V@no!!!

[V@no]

alright, then use >= instead of =

no, guests are guests, users are registered members and admins are administrators - three different groups (well, there is one more group: not activated registered members but that group has no affect on anything in 4images )

[terryjianlin]

This mod does not work in my site, which is Integration 4images 1.7 / phpBB . Unfortunally, the data does not update after uploaded more pictures after installed the mod.   any way to get it work?

$sql = "SELECT user_t_images, username, user_id FROM ".USERS_TABLE."
WHERE user_level ='".USER."'
ORDER BY user_t_images DESC
LIMIT 10";

[Michael]

Hallo, wie bekommt man das mit den Top Kommentaren hin?
Ich habe versucht user_t_images gegen user_comments auszutauschen doch das klappte leider nicht.

Gruß, Michael

[Nasser]

wonderful MOD .. thanks

[zaisk]

I have tried all the thing like <= ;  =  ;  >= ;

but the Guest from the top do not disapear :/

What to write in this line: WHERE u.user_level <= ".USER." that the top 25 do not show admin and guest

Thanks.

[IcEcReaM]

use this (as vano already mentioned)

Code: [Select]

WHERE u.user_level = ".USER."if you want that only users/members are displayed

[zaisk]

use this (as vano already mentioned)

Code: [Select]

WHERE u.user_level = ".USER."if you want that only users/members are displayed

I tried this also, but guest is still showen :/ Maybe it is happening for the reason, that the Guests can upload images at my website ? o
Is there any other way to do that ?

And it will be perfect if it is possible to make a top in this way:

Top 25 users:
Member 1 (124)
Member 2 (68)
Member 3 (44)
Member 4 (21)
<..others>
and Guests (7893)

I need this to show that all images are uploaded by users.


Thank you.