Accessing vBulletin Membership Data

[MacroPhotoPro]

I have an independent database application, within a custom vBulletin page, which accesses a separate database table. Yet I am trying to integrate the vBulletin membership names to this custom table. When I, as the administrator, attempt to work with this data table, while logged into vBulletin, I get the following error message:

http://www.macrophotopro.com/problems/database.jpg

It is trying to use the vBulletin Member ID as a foreign key. How do I access this data? What is the datatype? This data must be stored in the session somehow, since vBulletin knows persistently when the active user is logged in or not, etc.

Any help in how to access and integrate this information into my custom data table would be much appreciated.

Jack

[kh99]

That message appears when you post data to a vb script without including the security token value in your form. If the page with the form is a vb page made from a template you could use this:

<input type="hidden" name="securitytoken" value="{vb:raw bbuserinfo.securitytoken}" />


Or if you're including global.php in your page you can get the value from $vbulletin->userinfo['securitytoken'].

If you need any more help you'll have to explain what you're doing in more detail.

[MacroPhotoPro]

Thank you very much for your time and info. I will show this to my brother (who is doing the coding/programming), and if any further issues pop up, I will post.

Thanks again!

[MacroPhotoPro]

Okay, sir, this is the feedback my brother was hoping you'd be kind enough to clarify:


Is this the php code I need to use in order to access the primary index that identifies which user is currently logged in?:

// Include global data
include("global.php");

// Grab the current user for future use
$current_user = $vbulletin->userinfo['userid'];

(The security token is a hash code, and not what I am looking for.)

If this is the case, what is the name of the table that stores the user data? I need to know where the data is actually defined in the MySQL database in order to mirror the data type and use for future reference.


Thank you very much for your time!

Jack

[kh99]

Okay, sir, this is the feedback my brother was hoping you'd be kind enough to clarify:


Is this the php code I need to use in order to access the primary index that identifies which user is currently logged in?:

// Include global data
include("global.php");

// Grab the current user for future use
$current_user = $vbulletin->userinfo['userid'];

(The security token is a hash code, and not what I am looking for.)

If this is the case, what is the name of the table that stores the user data? I need to know where the data is actually defined in the MySQL database in order to mirror the data type and use for future reference.


Thank you very much for your time!

Jack


Yes, that code should give you what is called the userid (a positive integer, or 0 for a guest). I believe you want to look at the "user" table.

Hopefully that's what he wants to know - sounds like your brother knows a lot more about databases than I do.

[MacroPhotoPro]

Yes, that code should give you what is called the userid (a positive integer, or 0 for a guest). I believe you want to look at the "user" table.

Hopefully that's what he wants to know - sounds like your brother knows a lot more about databases than I do.


Yes, that did the trick, good sir, thank you :D

My brother is a top financial software developer, implementing solutions for huge banks/corporations and whatnot, but with only a so-so background on HTML/php, but an expert understanding of programming language in general.

Thanks once again for your guidance!

Cheers,