Number of Own Images in MySQL

[karimun]

ascanio, its time ago when I installed it but still remember a dicussion in the disappeared thread similar to this we have here. There is indeed something strange with it: you donīt need the user_uploaders_box.html at all.

Heres the way it works in my v1.7.1:
1. In page_header.php insert the code I posted above at the end (before ?>, of course) of the file.
2. Now simply add {user_uploaders_list} into your home.html and it should display the list.

If this still doesnīt work check again your user_t_images field inside the _users table:
Type: smallint; Lenght: 6; Null: not null; Default: 0. (from my phpAdmin)
or run the table_update.php from this mod (inside the zip file):
http://www.4homepages.de/forum/index.php?topic=1954.0

Maybe you have to install the memberlist mod completely.. I have them both and as I said: it works.

[ascanio]

ok perfect now is working i got confused with index.php part that u posted thank u

[karimun]

welcome 

[karimun]

V@no, I have the mysql query which I posted above in page_header.php and I call it from home.html with {user_uploaders_list}.
No additional html templates. I tried the way JensF described above but that solution dispays nothing in my case - even not with the user_t_images field set up.

Any more suggestions for my language and sessID problem? 

[V@no]

before u'll be able use "user_t_images" field, u must visit the memberlist.php page, and visit all the members. In my oppinion using user_t_images field is not very practical, unless its being populated every time someone upload an image.
I dont know if this will work, but try this query instead (note, it does not require user_t_images field to be present):

Code: [Select]

$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";
About sessionid, I've already replyed on previous page 

[karimun]

V@no, first - the sql query you posted right above doesnīt work work for me.
With your modification of the $last_action_user_list at least the language gets appended now.

The language tag is nevertheless the more important part so I can live with this compromise. Thank you.