Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Beta Releases

Reply
 
Thread Tools
Avatar Gallery Hack Details »»
Avatar Gallery Hack
Version: 1.00, by Hwulex Hwulex is offline
Developer Last Online: Jul 2006 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 02-07-2003 Last Update: Never Installs: 28
Is in Beta Stage  
No support by the author.

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

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 02-09-2003, 11:12 PM
Hwulex's Avatar
Hwulex Hwulex is offline
 
Join Date: Mar 2002
Location: Manchester, UK
Posts: 97
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
Code:
$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:
Code:
$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
Reply With Quote
  #13  
Old 02-10-2003, 03:29 PM
WitchyT WitchyT is offline
 
Join Date: Jan 2002
Location: LA
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Great. It works. Thanks!
Reply With Quote
  #14  
Old 02-12-2003, 04:51 AM
jamoss's Avatar
jamoss jamoss is offline
 
Join Date: Apr 2002
Location: Los Angeles
Posts: 81
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #15  
Old 04-05-2003, 10:31 PM
monstergamer's Avatar
monstergamer monstergamer is offline
 
Join Date: Feb 2003
Location: around the corner
Posts: 433
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Cool hack! Installed and working great on 2.3.0
Reply With Quote
  #16  
Old 05-04-2003, 03:18 AM
Alien's Avatar
Alien Alien is offline
 
Join Date: Oct 2001
Posts: 827
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Works nicely, thanks a bunch for this!
Reply With Quote
  #17  
Old 05-04-2003, 07:07 AM
Tigga's Avatar
Tigga Tigga is offline
 
Join Date: Dec 2001
Location: Atlanta
Posts: 1,061
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I doubt this is something I'd use, but still a nice job.
Reply With Quote
  #18  
Old 05-14-2003, 11:03 PM
Alien's Avatar
Alien Alien is offline
 
Join Date: Oct 2001
Posts: 827
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #19  
Old 05-17-2003, 03:16 PM
enny2 enny2 is offline
 
Join Date: Feb 2002
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your wrote in instructions.txt :

Quote:
Create a new replacement:
but is template not replacement !?
Reply With Quote
  #20  
Old 05-17-2003, 07:12 PM
Alien's Avatar
Alien Alien is offline
 
Join Date: Oct 2001
Posts: 827
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, he meant template down on the bottom where he said replacements...
Reply With Quote
  #21  
Old 05-24-2003, 11:16 AM
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Location: Mocsow
Posts: 1,288
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nothing works on 2.3
Can somebody fix that?
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:58 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04445 seconds
  • Memory Usage 2,303KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete