vb.org Archive - How Would I pull Information From vBulletin?

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - How Would I pull Information From vBulletin? (https://vborg.vbsupport.ru/showthread.php?t=154021)

Opserty

08-02-2007 08:12 PM

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

08-02-2007 08:23 PM

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

- Pc1203

Opserty

08-02-2007 08:27 PM

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

Pc 1203

08-02-2007 08:33 PM

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

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

08-02-2007 08:36 PM

You need to add the variables to a template

Kirk Y

08-02-2007 08:38 PM

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

Pc 1203

08-02-2007 08:41 PM

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

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

08-02-2007 08:41 PM

This is how to use vbdate.

Code:

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

Kirk Y

08-02-2007 08:44 PM

Sample query for profile fields:

Code:

$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

08-02-2007 08:45 PM

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?

All times are GMT. The time now is 07:55 AM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01096 seconds Memory Usage 1,736KB 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 (4)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: