Postbit Ligecy need to show coustomised field value

[Saintless]

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

[Dismounted]

You can just hook into the big query, and add a join. (Hook: showthread query)

[Saintless]

Originally Posted by Dismounted

You can just hook into the big query, and add a join. (Hook: showthread query)

Many many Thankx for reply.

i am tired with this issue, i am trying to add new plugin with hooklocation 'showthread_query'
with the query (for test perpuse)

"LEFT JOIN vb_socialgroupmember AS socialgroupmember ON(socialgroupmember.userid=post.userid)"

actually i need this query "SELECT sg.name, sgm.member_status FROM vb_socialgroup AS sg, vb_socialgroupmember AS sgm WHERE sg.groupid=sgm.groupid AND sgm.userid='user id who post the thread/reply'"

user(who post the thread/reply) may be member of no/one/more social group. i need to show all group name and their custom status(member_status) in postbit legacy.

i am tired with this last 3 days, please describe with details (if possible with code), what is the process to finish this task.

Thankx again in advance.

[Dismounted]

Go into showthread.php and I can assure you, you will be able to easily see how it's done.

[Saintless]

Originally Posted by Dismounted

Go into showthread.php and I can assure you, you will be able to easily see how it's done.

I am trying last 3 days with it and testing by adding code in showthread.php , i tried with add query in big query near line 1000, but fail, tried with create new plugin with hooke location showthread_query but fail, now i am fed up. please help.

[Dismounted]

Look at the query. The variables you need to use are $hook_query_fields and $hook_query_joins. Look at where they are placed.

[Saintless]

Originally Posted by Dismounted

Look at the query. The variables you need to use are $hook_query_fields and $hook_query_joins. Look at where they are placed.

Thankx, i will try with this and inform you about result