vb.org Archive - Help with mysql select and array

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Help with mysql select and array (https://vborg.vbsupport.ru/showthread.php?t=115423)

Kirk Y

05-13-2006 01:48 AM

Help with mysql select and array

Okay, so what I'm trying to do here is have a table underneath the member.php (memberinfo template) page with game statistics that are stored in a db. I've got a profile field set up where the users put in their username for the game -- that's how their stats are pulled from the table. So, table configuration: I've got around 9 or 10 fields, with things like kills, deaths, headshots, etc. What I'm trying to do is run a select query like: "SELECT * FROM table_name WHERE name = '$post[field5]'" And from this, I want to generate an array so I can use $stat[kills] or w/e in a template to post the row data from the kills field. Does that make sense? Anyway -- thanks in advance for any help. It's much appreciated.

I've tried a bunch of codes that people have posted with similar problems -- but none of them yield any results.

Chroder

05-13-2006 05:33 PM

So the table has columns for kills, deaths etc? So all you need is a single row.

Something like this?

PHP Code:


		
			
$game_uname = $vbulletin->db->sql_prepare($userinfo['field5']);

$stats = $vbulletin->db->query_first("SELECT * FROM tablename WHERE name = $game_uname LIMIT 1");

Kirk Y

05-13-2006 06:16 PM

I tried using the code you supplied, but nothing shows up when I use the $stats var in a template. But yes, that's how my table is set up.

Chroder

05-13-2006 06:26 PM

Which hook are you using?

Kirk Y

05-13-2006 08:44 PM

global_complete

Chroder

05-13-2006 08:54 PM

global_complete is too late, and global ;)

Try using member_complete instead.

Kirk Y

05-13-2006 09:11 PM

Ah ha! That did it, that'd explain why my other codes weren't working -- he he. Thanks a lot Chroder!

Edit: Oh and Chroder -- do you by chance know how I can connect to a seperate database with this?

Kirk Y

05-15-2006 07:06 PM

Bump: Connecting to another database?

hambil

05-16-2006 11:58 AM

Quote:

Originally Posted by acidburn0520

Bump: Connecting to another database?

PHP Code:


		
			
    switch (strtolower($vbulletin->config['Database']['dbtype']))
    {
        // load standard MySQL class
        case 'mysql':
        case '':
        {
            $db_temp =& new vB_Database($vbulletin);
            break;
        }
        // load MySQLi class
        case 'mysqli':
        {
            $db_temp =& new vB_Database_MySQLi($vbulletin);
            break;
        }
    }
    
    $db_temp->connect(
        $vbulletin->config['Database']['dbname'],
        $vbulletin->config['MasterServer']['servername'],
        $vbulletin->config['MasterServer']['port'],
        $vbulletin->config['MasterServer']['username'],
        $vbulletin->config['MasterServer']['password'],
        true
    );

Kirk Y

05-16-2006 07:32 PM

What should I change my select code to?

Code:

$stats = $vbulletin->db->query_first("SELECT * FROM stats_new WHERE name = $game_uname");

Edit: Nevermind, I'm such an idiot -- lol. Thanks for the assist hambil.

All times are GMT. The time now is 05:01 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01184 seconds Memory Usage 1,740KB 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)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)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
Messages: