Display custom WebLoginPE field

- 3 Posts
vinko_p Reply #1, 17 years, 1 month ago

Hello,

I’ve setup a site with user signup and they can enter their website info in their profiles, via WebLoginPE. Is it possible to display that info on Jot comments?
"They misunderestimated me." - George W. Bush, Bentonville, Ark., Nov. 6, 2000

1 Posts

MustangUA Reply #2, 16 years, 7 months ago

Yes, it is.
You need in /manager/includes/document.parser.class.inc.php at line ~2114-2118 replace:

              SELECT wu.username, wu.password, wua.*
              FROM " . $this->getFullTableName("web_users") . " wu
              INNER JOIN " . $this->getFullTableName("web_user_attributes") . " wua ON wua.internalkey=wu.id
              WHERE wu.id='$uid'
              ";

with:

              SELECT wu.username, wu.password, wua.*, wuae.*
              FROM " . $this->getFullTableName("web_users") . " wu
              INNER JOIN " . $this->getFullTableName("web_user_attributes") . " wua ON wua.internalkey=wu.id
              INNER JOIN " . $this->getFullTableName("web_user_attributes_extended") . " wuae ON wuae.internalkey=wu.id
              WHERE wu.id='$uid'
              ";

And then you’ll can call custom fields as any others, like:

[+comment.createdby:userinfo=`website`:ifempty=`No site`+]