Postbit Ligecy need to show coustomised field value
Hi Experts
I need to show a custom column field of vb_socialgroupmember table, say field name 'member_status' which will retrieve by user id of poster. Like,
"SELECT member_status FROM vb_socialgroupmember WHERE userid='who post/reply the thread'"
it will be retrive no/one/more row, user may the member of diffrent group so can have diffrent status of diffrent group. those all status if any will show in postbit legacy.
i am trying to put the above query in showthread.php page within a loop at line 1047,
while ($post = $db->fetch_array($posts))
{
$status_show=$db->query_read("SELECT member_status FROM vb_socialgroupmember WHERE userid=".$post['userid']."");
while($poster_status=$db->fetch_array($status_show))
{
eval('$poster_group_status .= "' . fetch_template('postbit_status_show') . '";');
}
I add a template name 'postbit_status_show' and put the following code there
<div class="smallfont">
Status :$poster_status[member_status]
</div>
Then in 'postbit_legacy' template i put '$poster_group_status' above code $post[joindate] where i want to show the status.but it is not working.
Is there any problem in this code or any new way to do this task, please help.
Thankx in advance
|