vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   User Album Conditionals? (https://vborg.vbsupport.ru/showthread.php?t=255275)

MikesSite 12-15-2010 06:12 PM

User Album Conditionals?
 
I would like to display something in postbit but only if the user has a user album. Is there a conditional for this?

Thanks!

Lynne 12-15-2010 06:19 PM

You would basically have to write a query on the table 'album' to see if they have an albumid for that userid. So, you would have to JOIN with that table ON userid to get, say MAX(albumid) and if that exists then display whatever. If it is NULL, then you wouldn't display anything.

MikesSite 12-15-2010 06:24 PM

Okay, thanks. If I were to do this in the postbit do you think it would cause a noticeable load on the server?

Lynne 12-15-2010 06:27 PM

If you do it by using a plugin to the post query, then I doubt you would notice a thing. If you do it by running a separate query per post, then you could notice something, but it's doubtful since it's such a small query, but that depends on your server really.

MikesSite 12-15-2010 06:38 PM

Lynn, you are the best!! Thanks very much, I'm going to toy with this for a bit


All times are GMT. The time now is 03: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.01117 seconds
  • Memory Usage 1,707KB
  • 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
  • (5)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