Need help

[Roody]

ok I used this query : AND visible=1

and got this result: Error

SQL-query :

AND visible = 1

MySQL said:

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

word of note - I got this error when I did it with apostrophes and without.

[NTLDR]

The problem is:

[sql]AND visible = 1 [/sql]

Isn't a query. Post the origional code that you were trying to change so we can see how it needs to be changed

[Roody]

ok im confused now. I asked in my very first post in this thread what needed to be done so that the new thread/new posts hack would read at a member level instead of the way it currently does.

at the moment when a person clicks on the new threads/posts link that shows how many new threads/posts are there its possible even if it lists new ones that they wont see them due to permissions. When I asked how I could put it at a member level I was told to run a query like this: AND visible=1

[NTLDR]

Originally posted by Roody
When I asked how I could put it at a member level I was told to run a query like this: AND visible=1

No where in this thread were you told to run that query (as its only part of one).

This is the PHP to add instead:

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE visible=1 AND lastpost > '$bbuserinfo[lastvisit]'");
$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE visible=1 AND dateline > '$bbuserinfo[lastvisit]'"); 


This will take care of posts in the moderation queue, however taking forum permissions into account invloves significate changes to index.php which can't be posted here.

[Roody]

ok sorry about that NTDLR. I apparently misunderstood since this stuff is a little over my head. As for your php info, is that what I put in my index.php in place of the current changes to it to achieve this hack?

Also, what is it again that this code will specifically do?

oh and one last question where do i find out about the kind of changes to be done to index.php that cant be posted here?

[NTLDR]

No problem, yes just replace the code with that I posted above.

That will remove new posts and threads in the count that arn't visible on the forums, ie in a moderation queue.

Looking at the permissions it looks harder than I first thought, I remember now trying to do this in the past. If its just a few forums then you can manually add them to not be included, however if you have many different access levels above 2 or more, then the amount of code increses quite a bit and IMO probably wouldn't be worth it.

[Roody]

ok NTLDR. here is an update on this situation. I installed that line of code on my test forums. Then using the Admin account I made a post in a private forum, and then I signed into a regular "Registered" user account that didn't have permissions to see the forum where the admin account posted in.

Unfortunately it listed the regular "Registered" user account as having a new thread/post, but when I clicked on that link I got the following message: "Sorry - no matches. Please try some different terms."

Any suggestions on my next move? Did I misunderstand something here?

[NTLDR]

That only excludes posts in the moderation queue. With alot a lot of hacking and changes (which I've never got to work) you can get forum permissions to apply automatically.

Which leaves 2 choices IMO, 1, Leave it as is 2, manually exclude every forum thats private for all users (or non-mods/admins).

[Roody]

Originally posted by NTLDR
That only excludes posts in the moderation queue.

2, manually exclude every forum thats private for all users (or non-mods/admins).

okay, here is my newbie questions. explain the moderation queue thing. im guessing this is the function that if enabled would prevent users from having posts applied to the forums until moderated by an admin? Second, im not sure Im following how to manually exclude a forum that is private for all non-mods admin. Can you break this down for me some?

[Roody]

Im bumping this up to make sure someone sees my question.