Avatar Gallery Hack

_/?\_/?\_/?\_/?\_/?\_/?\_

Avatar Gallery Hack
Version 1.2.1
26/10/03

By Hwulex

?\_/?\_/?\_/?\_/?\_/?\_/?


History
=======
One of the users on my board requested this earlier today, and rather than doing my uni work, thought I'd tuck into a bit of vBulletin.
Strange request, but it's interesting, and useful imo being able to browse through seeing who's using what.

All this hack does is display a list of your forum member's avatars.
Unlike v1.1, there is now only the one option; view only those with an avatar set.

This hack has not been tested on a large scale but worked perfectly on a local test installation of vB 2.3.2.


Working Example:
=================
At present, I do not have an online demo of version 1.2 of this hack working.
You can see version 1.1 of this hack working on my forums:
Xaprief Forum's Avatar Gallery.


Contents
=========
Contained in the .zip file are an example image, and instructions.txt (this file)
- instructions.txt -> Instructions for hack installation.
- example.gif -> Shows how the hack is used on the forum.


Use
====
Tested on vBulletin 2.3.2

Files to modify:
- memberlist.php

Templates to modify:
- memberlist

Templates to add:
- memberavatarlist
- memberavatarlistbit

Estimated Install Time: 3 minutes.


Support:
==========
I am a full time university student reading computing so I'm not always available, but I will offer support as much as possible.


Contact:
=========
Email: vbhacks (at) hwulex (dot) com


Updates
========
- 1.2.1: 2-per-page and if problem fixed.


Version History
==============
- 1.1 - Designed for vB 2.2.6, works up to 2.2.9.
- 1.2 - Fixed for 2.3.2, but two errors in code.
- 1.2.1 - Fixed errors from v1.2.


NB: If you do install this hack, please click on the INSTALL button. You will receive updates in your e-mail whenever I add new features to it. Also post a reply with your comments, they are appreciated.

[Hwulex]

Fixed

In the MySQL query I had; SELECT * FROM user. And because of the JOIN to the avatar table, the userid field was ambiguous.

To fix the problem, find:

$users=$DB_site->query("
	SELECT *
	".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
	FROM user
	".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
		LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
	WHERE $condition
	".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
	ORDER BY $orderby $direction
	LIMIT ".($limitlower-1).",$limitupper
");

And replace it with:

$users=$DB_site->query("
	SELECT user.*
	".iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
	FROM user
	".iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
		LEFT JOIN customavatar ON customavatar.userid=user.userid","")."
	WHERE $condition
	".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
	ORDER BY $orderby $direction
	LIMIT ".($limitlower-1).",$limitupper
");

The instructions and zip have been updated

[WitchyT]

Great. It works. Thanks!

[jamoss]

Cool! Installed and working great. I changed "Member's Avatars" (improper grammar) to "Avatar Gallery" in the templates.

I also changed the php code to include only those usergroupids that represent admins and subscribed members.

Thanks!
Jennifer

[monstergamer]

Cool hack! Installed and working great on 2.3.0

[Alien]

Works nicely, thanks a bunch for this!

[Tigga]

I doubt this is something I'd use, but still a nice job.

[Alien]

While playing with this, this hack when put into "show only users with avatars" mode will not work if you use general/non-custom avatars on your site.

If a user has a custom one uploaded that they're using it works perfectly fine. The minute you go into your admin cp and add an avatar you want to make available to all users, and they select it, then they will never show in the "show only users with avatars" list.

There is one other hack that has this exact same problem, and that is this hack:

UserCP Stats Panel
https://vborg.vbsupport.ru/showthrea...threadid=51301

I'm going to post this to hopefully be corrected there as well.

I hope this can be fixed, I won't be able to use this if it won't work with my 100 available avatars.

-Jason

[enny2]

Your wrote in instructions.txt :

Create a new replacement:

but is template not replacement !?

[Alien]

Yes, he meant template down on the bottom where he said replacements...

[gmarik]

Nothing works on 2.3
Can somebody fix that?