Avatar Usage Statistics in AdminCP 1.0

// Avatar Usage Statistics In AdminCP
-- // A hack by N9ne
-- // Creation Date: 11th April 2003
-- // Copyright N9ne 2003+

// Description
-- // This hack will add an option in the 'Avatar' options, in your AdminCP.
The option will read 'Usage Statistics' and upon clicking on it, a page
will be brought up listing, ordered by # of users descending, avatar IDs
with the number of users using each avatar next to it. Avatars are not
displayed on the page as for some forums, this could be quite intensive!
Avatars which have no one using them will not be listed.

// What needs to be done to install this hack
-- // Modification of: admin/(index.php, avatar.php)

// Hack Requested by B Freeze

// Addons
-- // Search for avatars by avatar ID in adminCP.
-- // Show Avatar Image In Listing Too

[sabret00the]

pretty cool, could you get it to display the avatar next to the picture?

[N9ne]

sabret00the, you probably mean display the avatar next to the ID, and yes, it's possible but you must know it will be quite intensive to load up the page, but I'll post up instructions for you to do so if you wish..

[N9ne]

Addon: Display Actual Avatar too
- Firstly install the actual hack, and then do these steps.

In admin/avatar.php, find:

PHP Code:

$get_the_info=$DB_site->query("SELECT COUNT( username ) AS users, avatar.avatarid, user.avatarid 


Replace that with:

PHP Code:

$get_the_info=$DB_site->query("SELECT COUNT( username ) AS users, avatar.avatarid, avatar.avatarpath, user.avatarid 


Find:

PHP Code:

<tr class='tblhead'><td align=\"center\" colspan=2><b> 


Replace that with:

PHP Code:

<tr class='tblhead'><td align=\"center\" colspan=3><b> 


Find:

PHP Code:

<tr class='".getrowbg()."'><td align=\"center\" nowrap><font size='1'> 


Replace that with:

PHP Code:

<tr class='".getrowbg()."'><td align=\"center\" nowrap><font size='1'><b>Avatar</b></font></td><td align=\"center\" nowrap><font size='1'> 


Find:

PHP Code:

            $numberusers=$the_info['users'];
            $avatarid=$the_info['avatarid']; 


Replace that with:

PHP Code:

            $numberusers=$the_info['users'];
            $avatarid=$the_info['avatarid'];
            $avatar=$the_info['avatarpath']; 


Find:

PHP Code:

<tr class='".getrowbg()."'> 


Replace that with:

PHP Code:

<tr class='".getrowbg()."'><td align=\"center\" nowrap><img src=\"$bburl/$avatar\" border=\"0\"></td> 


Done!

[Mathiau]

how can one make this page availible to anyone when they edit their avatar - perhaps in the avatar page where you choose your avatar - place a number beside / under it saying how many people are currently using that avatar? Or is this another hack already released?

[MarkL]

After doing the add-ons, I recieved this error when trying to do anything with Avatars in the Admin CP....

"Parse error: parse error, expecting `','' or `';'' in /admin/avatar.php on line 57"

What does that mean?