custom profile fields in printable version...Will Pay!

[btappan]

does anybody know how to get the same custom user profile fields i have in my postbit to show in the printable version? I use this:

<if condition="$post[fieldX]"><div align="left">$post[fieldX]</div></if>

in my postbit and it works fine, however when put in the printthreadbit template, it does nothing. The team over at VB.com said it will not work that way either, and to try asking here. I am desperate to do this as 90 % of my users print threads for use as notes and i have contact info for the user show up in these fields that has to be on there somehow. thanks ahead for your help.

I'll paypal or mail a check for $30 to the first person with a working soloution!

[btappan]

any takers?

[Boofo]

Try this:

<if condition="$post['fieldX']"><div align="left">$post[fieldX]</div></if>

and let me know if that works.

[Zachery]

Originally Posted by Boofo

Try this:

<if condition="$post['fieldX']"><div align="left">$post[fieldX]</div></if>

and let me know if that works.

It doesnt, the data is not there to be called.



line 844 has the massive query to get the info, but i cant make any sense of it. for showthread.

[Boofo]

Originally Posted by btappan

does anybody know how to get the same custom user profile fields i have in my postbit to show in the printable version? I use this:

<if condition="$post[fieldX]"><div align="left">$post[fieldX]</div></if>

in my postbit and it works fine, however when put in the printthreadbit template, it does nothing. The team over at VB.com said it will not work that way either, and to try asking here. I am desperate to do this as 90 % of my users print threads for use as notes and i have contact info for the user show up in these fields that has to be on there somehow. thanks ahead for your help.

I'll paypal or mail a check for $30 to the first person with a working soloution!

Ok, I got it. Thanks to Zach for finding the query I needed to edit.

In the printthread.php file

Find:

PHP Code:

$posts = $DB_site->query("
SELECT post.*,post.username AS postusername,user.username
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE post.threadid=$threadid AND post.visible=1 AND deletionlog.primaryid IS NULL
ORDER BY dateline $postorder
LIMIT $startat, $perpage
"); 


and replace it with:

PHP Code:

$posts = $DB_site->query("
SELECT post.*,post.username AS postusername,user.username,userfield.*
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE post.threadid=$threadid AND post.visible=1 AND deletionlog.primaryid IS NULL
ORDER BY dateline $postorder
LIMIT $startat, $perpage
"); 


and voila! Your if condition should now work.

[vbmechanic]

Open printthread.php, change query on line 126 to:

PHP Code:

$posts = $DB_site->query("
    SELECT post.*,post.username AS postusername,user.username,userfield.* 
    FROM " . TABLE_PREFIX . "post AS post
    LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
    LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(user.userid = userfield.userid)
    LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
    WHERE post.threadid=$threadid AND post.visible=1 AND deletionlog.primaryid IS NULL
    ORDER BY dateline $postorder
    LIMIT $startat, $perpage
"); 


Then add the fields as normal to the template.

[vbmechanic]

hey you beat me by a minute

[Boofo]

Sometimes that's all it takes. I guess great minds DO think alike, huh? LOL

Your line is different than mine here. Mine works, I tested it. Which one is correct?

PHP Code:

 LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid) 


[vbmechanic]

They are transposable, both are correct and usable

[Boofo]

I thought so. Thanks for confirming it. I just copied that line from the post query in the showthread as it was.