Show custom profile field on page.

[soundboy]

Ok..

It was possible in phpbb3.. and im not sure in vbulletin.. but i want to display 10 random entries from a custom profile field..

My members enter a url into a custom profile field and i want to dispaly 10 random entries from different users on my forum index..

If this is possible
Thanks in advance

[RLShare]

You could use a mysql statement like this...(I think)

"select fieldNUMBER from ".TABLE_PREFIX."userfield order by rand() limit 10"

Change NUMBER to the actual field number.

[psylenced]

You wouldnt want to run that query per post. Each page load would hit the db 10-20 times per page per user.

[RLShare]

What does that have to do with the question? He wants to show it once on his forumhome not per post.

[soundboy]

Originally Posted by RLShare

You could use a mysql statement like this...(I think)

"select fieldNUMBER from ".TABLE_PREFIX."userfield order by rand() limit 10"

Change NUMBER to the actual field number.

thanks, how would i implement this? Sorry, im only new to vbulletin (im a phpbb coder but wanting to code vb)

[RLShare]

You would use the vb database manager to run the query and gather the info like so....

PHP Code:

$fields=$vbulletin->db->query_read("select fieldNumber from ".TABLE_PREFIX."userfield order by rand() limit 10"); 


Then loop through the data and structure it however you want using the $vbulletin->db->fetch_array() function...
ex....

PHP Code:

while($field = $vbulletin->db->fetch_array($fields)){
///Process data...

} 


You would want to put this in a plugin that hooks the proper location, more then likely the forumhome_start hook location since you want to display it on the forumhome template... Usually format and place all the data into a variable and then edit the template of which your plugin is hooking and add that variable. VB also has Template hooks where you can add data to pre-defined variables that will get displayed in the templates without ever editing a template.

[RLShare]

Here is a sample plugin that draws in a profile field and places it in a table so you can get an idea of how to do it...Edit the plugin and change the field6 in the query to the one that corresponds to your forum before you import the plugin.

You would then need to edit your forumHome template and find $navbar then place $pb_fields right under it.

[soundboy]

i still dont understand..

so do i put the info in my file (index.php) ?
i need further steps, sorry

EDIT: i will try that plugin you made thanks

--------------- Added [DATE]1216356491[/DATE] at [TIME]1216356491[/TIME] ---------------

ok.. i edited the plugin and ran it..
also edited my template..
and im getting no result showing up?

[RLShare]

All that means is there is an extra '<' somewhere in the code that there should not be. Its not in the plugin unless you edited the html in the plugin.

[soundboy]

ok! i got it but.. its on the forum homepage..
I am running vbdrupal, how would i be able to get it on that page?

also its displaying empty tables.. how can i make it so it doesnt show null fields? or empty fields?
Many thanks mate