vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Accessing vBulletin Membership Data (https://vborg.vbsupport.ru/showthread.php?t=281216)

MacroPhotoPro 04-06-2012 10:06 PM

Accessing vBulletin Membership Data
 
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:


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 04-06-2012 11:03 PM

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:

Code:

<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 04-06-2012 11:15 PM

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 04-09-2012 05:59 PM

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 04-09-2012 06:39 PM

Quote:

Originally Posted by MacroPhotoPro (Post 2318404)
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 04-10-2012 02:30 AM

Quote:

Originally Posted by kh99 (Post 2318418)
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,


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

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.00989 seconds
  • Memory Usage 1,727KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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