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]

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....


$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....
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]

:o 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 :D thanks

--------------- Added 1216356491 at 1216356491 ---------------

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 :D

[RLShare]

ahh just seen you edited your post... I forgot to mention that you will also need to change the field6 in the 2 spots that this shows up....'$field['field6']'

[soundboy]

yup i changed that :)
its working but i wish to show it on my vbdrupal page? also its showing empty fields, how can i make it only show ones that are filled in?

[RLShare]

change the query to this but edit the field numbers again


"SELECT field6
FROM ".TABLE_PREFIX."userfield
WHERE field6 != ''
ORDER BY rand( )
LIMIT 10 "

As far as the VBDrupal page, I have never messed with drupal before.

[soundboy]

Thankyou VERY much!
I changed the hook to global_start :)
+rep

--------------- Added 1216358345 at 1216358345 ---------------

oh.. sorry again.. but i have another field i want to display..

Ive set up the url which is field7, and i wish to display field5 like..

<a href="field7">field5</a>

Thanks for your help again!

[RLShare]

Change the query to
"SELECT field5, field7
FROM ".TABLE_PREFIX."userfield
WHERE field5 != '' AND field7 !=''
ORDER BY rand( )
LIMIT 10"


And then change this part of the plug-in...
<a href=\''.$field['field6'].'\'>'.$field['field6'].'</a>

To..
<a href=\''.$field['field7'].'\'>'.$field['field5'].'</a>

[soundboy]

many thanks mate :)