Help with mysql select and array

[Kirk Y]

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]

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]

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]

Which hook are you using?

[Kirk Y]

global_complete

[Chroder]

global_complete is too late, and global

Try using member_complete instead.

[Kirk Y]

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]

Bump: Connecting to another database?

[hambil]

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]

What should I change my select code to?

$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.