I need to make it so a member of a site can only view the full version of a template if they have made a post in a specific channel. So if they haven’t made a post they see a banner message telling them to do it, etc.
I have a version of this using the Query module, but it doesn’t seem to work correctly…
{exp:query sql="select count(*) as my_count from exp_channel_titles where author_id = 'CURRENT_USER' and (channel_id = '2') and (status = 'open') "}
{if my_count > 1}<div class="alertbox">You haven't created a profile yet. Click <a href="/temps/create-profile/">here</a> to make one.</div>{/if}{/exp:query}So I also need that same code to ‘hide’ parts of the profile templates as well, until they have made their own profile.
I hope that makes sense. Any help is appreciated.