Want to show contents for Sponsored ONLY

[pimpmaster]

Hi, I have made a custom page (http://www.domain.com/page.php?id=custom_page) and on that page I have information I only want paying (Sponsored and maybe Premium) users to see.

As it is now it is like this:

<%if $login_status_logged_in%>
<%php%> include ("custom_page.php"); <%/php%>
<%else%>
For paying users only!
<%/if $login_status_logged_in%> 

But this only controls if the user is logged in or not. I also want to connect any of their links' status and allow them to see the contents of the page IF any of their links are Sponsored or Premium.

Is this possible?

[Bruceper]

You would not be able to determine if a logged in user is a paid listing owner without writing some PHP code and joining some database tables. There is simply no easy way to do this and IndexU doesn't record anything about payments in the users table.

By the way, you only need to end with <%/if%>

[pimpmaster]

Well, I managed to put together an SQL-query which gives me what I want.

select l.link_id, l.title, u.username from idx_link l, idx_paid_listing p, idx_users u, idx_link_user lu where l.link_id = p.link_id and p.link_id = lu.link_id and u.username = lu.username and p.sponsored = 1 

But how do I convert that to some sort of variable similar to <%if $login_status_logged_in%> to be able to check wheter true or false in a custom page? Where is this variable <%if $login_status_logged_in%> declared?

[Bruceper]

You're on your own for the programming end, I'm not a programmer, I can only hack things to death until they almost work.

[pimpmaster]

Well, at least that's an honest reply. I probably have to turn my hopes to the Helpdesk in that case...

[Bruceper]

I answer the help desk too, although I can forward your question onto the programmers, it is not their function to write code for clients, only to answer questions in regards to the existing code.