View Single Post
  #1  
Old 08-08-2005, 10:36 AM
RaidenDAWG2 RaidenDAWG2 is offline
 
Join Date: Mar 2005
Location: THE Ohio State University
Posts: 141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Troublesome SQL queries

I'm working on a major game development project (fully vB integrated) for my site, and I'm having a problem getting a couple of functions to work.

The first one here fetches the info for a given team. I did some testing (echoed variables), and I found that while the $userid variable was set properly, the query following it wasn't functioning as designed (i.e. it returns nothing).

PHP Code:
function fetch_teaminfo($userid, &$teaminfo)
{
    global 
$vbulletin;
    
//requires that is an actual owner.
    
$userid intval($userid);
    
$teaminfo $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."fwteams WHERE ownerid = $userid");

Second one works on determining if the user is a team owner or GM (haven't implemented the second half yet, so it by default returns 0 for false).

PHP Code:
function check_status($userid$docheckon)
{
    global 
$vbulletin;
    
$userid intval($userid);
    if(
$docheckon == 'owner')
    {
        
$yayornay $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."fwowners WHERE ownerid = $userid");
        if(
$yayornay == '1')
        {
            return 
1;
        }
        else
        {
            return 
0;
        }
    }
    if(
$docheckon == 'gm')
    {
        return 
0;
    }

Again, did some testing on this, the $userid is set, but for some reason the query's not functioning.

Sorry if these are stupid questions guys. Haven't exactly had any formal training in MySQL or PHP, been basically learning on my own for the last two months or so (have experience with Java and RESOLVE/C++) through trial and error.

Thanks for any help

EDIT: Should mention, all of the above is programmed for 3.5 RC1

-RD
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01162 seconds
  • Memory Usage 1,780KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete