User Profile Field Question

[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]

Originally Posted by Paul M

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

It does. :down:

Originally Posted by Paul M

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]

Originally Posted by Pottsy

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]

Originally Posted by whitemike

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

[Pottsy]

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

[Michael Biddle]

request 3 then.