Trying to combine my game with vBulletin

[c4smok]

So far I have set it up so it uses the same logins when created but I am having a problem with setting up the checks for the game itself. That is because I need to figure how to add vars into the template from more tables I added to the vbforum database, since you can not directly put php into the template. So far I have not touched any php in the files because I can not find where to start at. I simply want it to check if the person is in the game... How big they are and so on and show it on the nav bar, but I am having an issue on finding where I need to start out to do this.

Thanks,
c4smok

[Dismounted]

Put your code in a plugin hooking at global_start. Make sure you assign the data to a variable. Then use that variable in templates.

[c4smok]

Tried this but it does not seem to work.. put it in global_start

PHP Code:

$gameuser = mysql_fetch_array($db->query("SELECT * FROM game_users WHERE username='$vbulletin->userinfo[username]';")); 


trying to match up usernames so I can import the vars for my checks..

[Dismounted]

PHP Code:

$gameuser = $vbulletin->db->query_first("
    SELECT *
    FROM `game_users`
    WHERE `username` = '" . $vbulletin->userinfo['username'] . "'
    LIMIT 1
"); 


[c4smok]

that works great =)

you own..