Using Template hook for plugin development vb5

[VineetN]

Hello,

I am trying to develop a plugin compatible with vBulletin5. Since vb5 allows template hooks, I am not able to use php script. Can someone tell me as to how should I execute a SQL query. And also I am trying to do the following to store the value of current loggedin user's usergroupid in 'groupid'. But I am not able to retrieve the value in it. Please provide your assistance.

Code Snippet:
<vb:if condition="!empty($vboptions['testing'])">
{vb:set groupid, {vb:raw bbuserinfo.usergroupid}}
{vb:raw groupid}
</vb:if>