Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2002, 09:36 PM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Can this be reduced

Can this be reduced into a single query? if so how do I call each attribute?

Code:
$memhealth=$DB_site->query_first("SELECT battle_health FROM user WHERE userid='$bbuserinfo[userid]'");
      $battle_health=$memhealth[battle_health];

$memintel=$DB_site->query_first("SELECT battle_intel FROM user WHERE userid='$bbuserinfo[userid]'");
      $battle_intel=$memintel[battle_intel];

$memmagic=$DB_site->query_first("SELECT battle_magic FROM user WHERE userid='$bbuserinfo[userid]'");
      $battle_magic=$memmagic[battle_magic];

$memskill=$DB_site->query_first("SELECT battle_skill FROM user WHERE userid='$bbuserinfo[userid]'");
      $battle_skill=$memskill[battle_skill];

$memarmor=$DB_site->query_first("SELECT battle_armor FROM user WHERE userid='$bbuserinfo[userid]'");
      $battle_armor=$memarmor[battle_armor];

$DB_site->free_result($memhealth);
$DB_site->free_result($memintel);
$DB_site->free_result($memmagic);
$DB_site->free_result($memskill);
$DB_site->free_result($memarmor);

eval("\$battle_mem_stats = \"".gettemplate('battle_mem_stats')."\";");
Quote:
I think this is the first part????
$membattlestats=$DB_site->query_first("SELECT battle_armor, battle_intel, battle_magic, battle_skill, battle_armor FROM user WHERE userid='$bbuserinfo[userid]'");
but I dont know how the rest is done?

Any help greatly appreciated.
Reply With Quote
  #2  
Old 12-03-2002, 10:47 PM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The rest could be something like this:

PHP Code:
$battle_health $membattlestats['battle_health'];
$battle_intel $membattlestats['battle_intel'];
$battle_magic $membattlestats['battle_magic'];
$battle_skill $membattlestats['battle_skill'];
$battle_armor $membattlestats['battle_armor']; 
Reply With Quote
  #3  
Old 12-03-2002, 11:52 PM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks, I will try it but I thought there had to be a while statment there somewhere.
Reply With Quote
  #4  
Old 12-04-2002, 12:10 AM
JulianD's Avatar
JulianD JulianD is offline
 
Join Date: Jan 2002
Posts: 455
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Uhmmm I don't think so.. Try it yourself and post here if you have any problem.
Reply With Quote
  #5  
Old 12-04-2002, 12:33 AM
Jalrock Jalrock is offline
 
Join Date: Dec 2001
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

All is good it worked great. Thanks
Reply With Quote
Reply


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:48 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.04552 seconds
  • Memory Usage 2,201KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete