I've searched for quite a bit to learn how to do two things. I'm not sure this is a modification here, so I'm posting here to get some input hopefully.

I have a fairly large site with a soon to be released vBulletien board added to it. Thankfully moving away from our current boards. Anyway since the site is made up of more then the vB boards I'd like to use some of its material elsewhere on the site.

1. Allow me to create a page outside of the boards directory that lists the avatar and name of each person in a specified usergroup. Linking back to the person's profile.
2. Allow me to randomly display a member avatar, name, selected profile fields to the front page of my site, also above the boards directory.

These two things are key to what I'm trying to design and so far I've had next to zero luck with deciphering how to play with the vB database to do this. Any input someone might have on how is has been done or might be done would be incredibly appericated.

Thanks

2. Do you have a script which randomly picks a row out of the database?

as for 1. Just add a base href tag to the header..

So for 2 I need to start first with a function to randomly select a row from the userid table?

As for one I'm looking to actually make subdomain pages for my site, for example say house.mydomain.com, trance.mydomain.com, etc. With my forums being at boards.mydomain.com. So given this setup none of the subdomains would be inside the forum directory or below. I got the idea from the Forum Leaders page. I'd like to be able to put members into the assoicated usergroup, then on say trance.mydomain.com have the page simply pull the name and profile/avatar picture of each member that was found in that usergroup. With the picture linking back to the user's profile on boards.mydomain.com.

Is that any clearer?

You don't have to use the db database handler to access the vb database. With just the username/password you can use php's mysql_connect() // mysql_query to do the trick. If you want to use the vb config,
require_once('vb_forum/includes/config.php');

For 1, assuming you only want to show members with avatars and assuming you have avatars in the filesystem:
Naturally you can format the output however you want.
usergroupid is the usergroup you want to use.


Similar for 2, but add ORDER BY RAND() LIMIT 1 to pick a random one. Also LEFT JOIN userfield USING (userid) and add the fields you want to the select range.


I know this is a bit of a throwtogether but it should get you started - it depends how much you know about mysql in general.

__________________
"When you do something right, people won't be sure you've done anything at all" - "God", Futurama

My vB hacks: Site Backup (easily backup your forum files) -- Image Status Checker / Dead Image Finder - 3.5/3.6 -- Stop people mass deleting / editing their posts plugin - 3.6 -- v3arcade reduce scores to keep arcade competitive -- Make guests give a name when posting or replying - 3.0

And curtesy of Livewire you can also use vbulletin for the whole thing:

Also by Livewire: don't use == just = it's a query!

Ah yes, just single = for sql. I've corrected a '. error too, so you'll probably want to re-quote me on the vb version.

Here's a little thing: Add this code to global_start:
Add this code: to FORUMHOME underneath: $navbar

Then you have a block on forum home with the user's avatar and name plus if it is the user browsing it the title will change. I am aware this is not user of the day but it can be made into user of the day with some tweaking.. ie. cron job. This is more User of the refresh...

You guys are outstanding I can't wait to give these a try.

I'm working on a cron job for the vb version.