vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   get avatar from database (https://vborg.vbsupport.ru/showthread.php?t=80494)

gspot 04-24-2005 10:33 PM
get avatar from database
 
I'm working on a script trying to get all members avatars from the database. I see that they are being listed and stored through mysql in the table "customavatar" how can I call the images from this database? since they actually do no reside on the server or at least i cant seem to find them. I know how to do sql queries ect, but I need to be able to call members avatars. ANY HELP MUCH APPRECIATED...

DRJ 04-25-2005 12:21 AM
Call the image like:

http://www.YourSite.com/forum/image.php?u=USERID

gspot 04-25-2005 12:37 AM
but if they dont have an avatar how can i make it so it just shows nothing and not a missing image? THX FOR THE HELP TOO

Im trying to make an conditional statement in order to show the avatar for the members who have avatars and for the ones that don't it shows nothing...

DRJ 04-25-2005 01:23 AM
When you make your Query use Count(*) for the Selection portion. then you can check if the count is 0 or not with an if statement. If it is 0 show a specific image, otherwise show the avatar.


All times are GMT. The time now is 04:51 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00929 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete