[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.