The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
08-01-2007, 04:33 PM
|
|||
|
|||
How Would I pull Information From vBulletin?
Hi All,
I'm wondering how would I pull information from vBulletin? I would like to pull: Username Posts And Some Additional Information - Pc1203 [EDIT]Sorry, the pages are outside of vBulletin.[/EDIT] 
|
|
#4
08-01-2007, 06:25 PM
|
||||
|
||||
|
This might of use to you: https://vborg.vbsupport.ru/showthread.php?t=108026
|
|
#6
08-01-2007, 06:35 PM
|
||||
|
||||
|
What are you trying to do specifically, because I've used a modified vBExternal in the past to display trimmed posts, with the Author's Username, and date of posting on an external page.
|
|
#7
08-01-2007, 06:38 PM
|
|||
|
|||
|
Ok, this is what I'm trying to do. I'm trying to create a small profile system for my website. In it somewhere, it says the users posts, join date, username, and some custom profile fields. Hope this is better.
- Pc1203
|
|
#8
08-01-2007, 06:44 PM
|
||||
|
||||
|
Well it's really just a matter of querying the database for the relevant information.
Place the following at the very top of the pages you're displaying information on; make sure they're PHP files as well. Code:
<?php
chdir('/path/to/forum');
require_once('/path/to/global.php');
?>
Example: Code:
$stats = $db->query_read("SELECT threadcount, replycount FROM " . TABLE_PREFIX . "forum");
while ($forum = $db->fetch_array($stats))
{
$threads += $forum['threadcount'];
$posts += $forum['replycount'];
}
$threads = vb_number_format($threads);
$posts = vb_number_format($posts);
|
|
#9
08-01-2007, 06:46 PM
|
|||
|
|||
|
Ok, Thanks alot!
// I would add rep but I guess it's disabled. - Pc1203 EDIT: I get a blank page after trying this code: Code:
<?php
chdir('/home/penguink/public_html/forums');
require_once('/home/penguink/public_html/forums/global.php');
?>
<html>
<head>
</head>
<body>
Test
<?php
$stats = $db->query_read("SELECT threadcount, replycount FROM " . TABLE_PREFIX . "forum");
while ($forum = $db->fetch_array($stats))
{
$threads += $forum['threadcount'];
$posts += $forum['replycount'];
}
$threads = vb_number_format($threads);
$posts = vb_number_format($posts);
$stats
?>
</body>
</html>
- Pc1203
|
 |
«
Previous Thread
|
Next Thread
»
Linear Mode
|
|
All times are GMT. The time now is 06:31 PM.