Need help
 

I have made two posts about this, but havent received any help so far, so Im providing those posts in here. Here is my situation. I am currently running a hack that shows the number of threads/posts since a persons last visit. The problem with the hack is, that it isnt done at member level meaning people who dont have permission to see certain forums are still having the hack tell them that posts are there to be seen when they arent.

Naturally this is a bit confusing, and I could use any help that someone could provide. Here is the link where I have been trying to obtain help. Thanks

Link

I don't understand...do you want something that will cut out the new posts and threads of a private forum which the user cannot access?

If you have moderation on for forums or users then this is why, you need to add:

[SQL]AND visible=1[/SQL]

To the WHERE clause of both the queries you add to index.php

ok here is what I mean. lets say you are a basic member on my boards. When you click on the new posts/new thread hack which lists exactly how many are new since your last visit if your permissions arent set to see all the forums then even if it lists posts as being new it may come up saying that their is no more new ones.

My questions is, is there a way to incorporate this hack on the member level so the hack correctly shows new posts and threads based on a person's permissions?

As for your post NTDLR..im not sure I follow if what you showed me will do this? Does it?

In your query, put what NTLDR wrote after the WHERE section of that query, so that only posts visible to the user is counted.

ok thanks Erwin for clearing that up for me. I was a little confused with what NTDLR was saying.

ok guys i finally got this up and running, but i got the following error when I ran that query:

Error

SQL-query :

AND visible = 1

MySQL said:

You have an error in your SQL syntax near 'AND visible = 1' at line 1

[sql]
AND visible = '1'
[/sql]

That should be part of the query

You shouldn't have the apostrophes in those positions

- miSt

I actually did it without apostrophes also Mist, and received the same error. Any other ideas?

Can you post the entire query from the PHP file here?