Custom profile field in showgroups.php

[Cold Steel]

I've added custom field 16 (Extended Biography):

Multiple-line text box
Field Required: No
Editable by user: Yes
Hidden on profile: No
Searchable on members list: No

I want this field to show up on http://forums.asiansinc.com/showgroups.php

After searching for a long time through this forum, I've tried various variations of

$user[field16]
$userinfo[field16]
etc.

Nothing worked.

Can someone tell me what code I should use to get it to display?

Thanks!

[mtha]

Idea:
- You have to edit showgroup.php file, find the part where it read the information from database for showgroup (query SELECT something)
- Add to the query so that it also read all field (or field16) from customfield table

by that time, you will be able to use field16 in your template

I didnt actually look at the file, so cant tell you excactly where it is right now.

[Cold Steel]

Thanks!

[mtha]

something like this:

$users = $DB_site->query("
	SELECT userfield.*, user.*, usergroup.usergroupid, usergroup.title, user.options
	FROM " . TABLE_PREFIX . "usergroup AS usergroup
	LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
	LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
	WHERE (usergroup.genericoptions & " . SHOWGROUP . ")
");

and

$moderators = $DB_site->query("
	SELECT userfield.*, user.*,moderator.*
	FROM " . TABLE_PREFIX . "moderator AS moderator
	INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
	INNER JOIN " . TABLE_PREFIX . "userfield AS userfield USING(userid)
	#ORDER BY user.username
");

[Cold Steel]

Since this requires code modification, maybe we should discuss it here:

http://www.vbulletin.org/forum/showthread.php?t=63795

If you have any idea on how to edit the code, can you contact me either via PM or any online chat client?