vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Troublesome SQL queries (https://vborg.vbsupport.ru/showthread.php?t=93853)

RaidenDAWG2 08-08-2005 09:36 AM
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

Logikos 08-08-2005 09:45 AM
I think it has to do with
PHP Code:
$vbulletin->db->query_read(); 
Have you tried:
PHP Code:
$vbulletin->db->query(); 

Marco van Herwaarden 08-08-2005 10:46 AM
If you have only row that fullfills the WHERE clause, you should use query_first instead of query_read (and not 'query' like LV suggested :P 'query' is depreciated and should be replaced by either query_read or query_write).

The 'read' in query_read only means that this query will not change any data (query_write), it is not fetching the results.

If you have more rows that will be returned, use the following construct:
PHP Code:
        $result= $vbulletin->db->query_read("SELECT * FROM table WHERE condition");
        while ($row= $vbulletin->db->fetch_array($result))
        {
            ...process row
        } 

RaidenDAWG2 08-08-2005 11:20 AM
I feel stupid now. Thanks Marco, really appreciate it man :D

-RD


All times are GMT. The time now is 11:36 AM.

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.01636 seconds
  • Memory Usage 1,726KB
  • 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
  • (5)bbcode_php_printable
  • (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