How Would I pull Information From vBulletin?

[Opserty]

Something like this:

PHP Code:

// Add the usual require stuff here
$wanted_userid = 9; // The user id of the user you want the data from 
$userinfo = fetch_userinfo($wanted_userid);

$posts = $userinfo['posts'];
// $joindate = $userinfo['joindate']; // Unformatted
$joindate = vbdate($userinfo['joindate']); // Formatted date e.g. Mon 29th Aug 


ef

(Untested)

[Pc 1203]

Ok, but would I need to include any files like global.php to get that to work?

- Pc1203

[Opserty]

Yes you will need to include the global.php file from the main forum directory.

[Pc 1203]

I just get a blank page. Here is my code:

<?php
chdir('/home/penguink/public_html/forums');
require_once('/home/penguink/public_html/forums/global.php');

// Add the usual require stuff here
$wanted_userid = 9; // The user id of the user you want the data from 
$userinfo = fetch_userinfo($wanted_userid);

$posts = $userinfo['posts'];
// $joindate = $userinfo['joindate']; // Unformatted
$joindate = vbdate($userinfo['joindate']); // Formatted date e.g. Mon 29th Aug 

$joindate
?>

EDIT: Stupid Me! I forgot to use the print command. It works! Thanks Alot! Do you know how to get custom profile fields, though?

EDIT2: When I look at join date I get "1177448760" for my user....

[EnIgMa1234]

You need to add the variables to a template

[Kirk Y]

You need to use the vbdate() function to convert the timestamp into a readable format.

[Pc 1203]

Ok, I did that and I'm still getting the same thing. Here is my code:

<?php
chdir('/home/penguink/public_html/forums');
require_once('/home/penguink/public_html/forums/global.php');

// Add the usual require stuff here
$wanted_userid = $_GET['u']; // The user id of the user you want the data from 
$userinfo = fetch_userinfo($wanted_userid);

$posts = $userinfo['posts'];
$username = $userinfo['username'];
//$joindate = $userinfo['joindate']; // Unformatted
$joindate = vbdate($userinfo['joindate']); // Formatted date e.g. Mon 29th Aug 

print "<h1>$username</h1>";
print "Posts: $posts";
print "<br />";
print "$username Joined On: $joindate";
?>

It outputs:

Pc1203

Posts: 1044
Pc1203 Joined On: 1177448760

- Pc1203

[EnIgMa1234]

This is how to use vbdate.

vbdate($vbulletin->options[dateformat], $userinfo['joindate']);

[Kirk Y]

Sample query for profile fields:

$fields = $vbulletin->db->query_first("SELECT * FROM userfield WHERE userid =".$userid);

Then you can use $fields['fieldX'] to retrieve a particular field.

Also, you should look into cleaning the variables you're using in queries - or you'll leave this page open to SQL injection.

[Pc 1203]

Ok Thanks EnIgMa1234! The date works now. Any ideas on how to get some custom profile fields?

- Pc1203

EDIT: Ok, Kirk Y. I'll try that. Also you said I should change the variables, is that what you meant?