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

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.

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.

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