User Profile Field Question

[sunilvarma]

I created a user profile field and want to use it in the FORUMHOME template.

To show it in the postbit I used $post[field6] and it works. But if I use this in the FORUMHOME template, it doesn't work.

I know I'm missing something here. Can someone help me with this?

[nico_swd]

Try

$vbulletin->userinfo['field6'];

[sunilvarma]

nope, that didn't work.

[Opserty]

<font face="Courier New">$bbuserinfo['field6']</font>

[sunilvarma]

this shows only the info for the logged in user. but i want to work i a slightly different way.

in the who's online list i want to show the field6 of each loggedin user against their username.

[sunilvarma]

anyone?

[Opserty]

You'd have to write a plugin then since I don't think userfields are fetched in the "Whats Going On" but. If you know the PHP side of vBulletin then you'd need to find the correct hook location (the one inside the user display loop) and use $userinfo = fetch_userinfo($userid) to fetch the info for the specified user. Then use $userinfo['field6'] to access the data.

[sunilvarma]

well, unfortunately i am not that good at PHP. so could you elaborate further?

Thanks

[Opserty]

Add a new plugin

With hook location forumhome_loggedinuser


$online_userinfo = fetch_userinfo($loggedin['userid']);


The in Style Manger Go to Edit Templates -> Forum Home Templates -> forumhome_loggeninuser

Add $online_userinfo[field6] to the end of it.

Don't know if that is the most efficient way to do it, but it works. Hopefully :)

[sunilvarma]

thanks a lot Opserty. it worked.

[Paul M]

I think that method will query the database for each user on the page.

Try this ;

Create a plugin using the "online_query" hook - with this in it ;

$hook_query_fields .= ' , userfield.* ';

You should then have the userfields in the $userinfo array ( e.g. $userinfo['field6'] );

[Pottsy]

I think that method will query the database for each user on the page.

It does. :down:


e.g. $userinfo['field6'] );

Paul - can't get yours to work, but this is not helped by me not understanding your method exactly! One thing is I can't enter the single quotes you use (around field6). And it seems to only affect the WOL page, which just returns a database error.

Any advances?

[WhaLberg]

Please note that do not use ' (single quote) in templates.

[Pottsy]

Indeed not.

I suspect the solution is to add a bit to the query in index.php, but I'm not having much luck so far.

[Michael Biddle]

Paul - can't get yours to work, but this is not helped by me not understanding your method exactly! One thing is I can't enter the single quotes you use (around field6). And it seems to only affect the WOL page, which just returns a database error.

Any advances?

Paul is right. The hook is already inside of the query so you are just adding more things for it to select out of the database for instance, fielf6.

In your template you should then use $userinfo[field6]

[Pottsy]

Paul is right. The hook is already inside of the query so you are just adding more things for it to select out of the database for instance, fielf6.

In your template you should then use $userinfo[field6]

If I reproduce what Paul suggests, then using $userinfo[field6] in the template forumhome_loggedinuser has no effect (what we're trying to do is get stuff to show in the list of users in "What's going on".

Furthermore, the WOL page (online.php, which we are not trying to modify) shows:


Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, userfield.*
FROM session AS session
LEFT JOIN user AS user USING (userid)

WHERE session.lastactivity > 1191867322


ORDER BY user.username asc;

MySQL Error : Unknown table 'userfield'
Error Number : 1051
Date : Monday, October 8th 2007 @ 07:30:22 PM
Script : http://localhost/forum/online.php
Referrer : http://localhost/forum/index.php
IP Address : 127.0.0.1
Username : Pottsy
Classname : vB_Database

--------------- Added at 10:26 ---------------

I now have this working, but it would be great if an SQL person could check my code for me.

In index.php, there is the query in "logged in users" that pulls the stuff up for WGO. I have added the stuff in red:

$forumusers = $db->query_read_slave("
SELECT
user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity, userfield.field6, userfield.userid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM " . TABLE_PREFIX . "session AS session
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(user.userid = userfield.userid)
WHERE session.lastactivity > $datecut


I have also added the line in red just below:

'invisible' =>& $vbulletin->userinfo['invisible'],
'field6' =>& $vbulletin->userinfo['field6'],



And I can now use $loggedin[field6] in forumhome_loggedinuser. I know this is poor because it modifies php, but in the absence of a hook in that query I can't see another way.

[Michael Biddle]

Request a hook location at vb.com :D

[Pottsy]

As I see it, it would require three...

[Michael Biddle]

request 3 then.