Yes - the Brand New Posts - I just went back and hit refresh again and it shows

Brand New Posts
Word Associations
by skyhaven
Soap Operas
18 minutes 21 seconds ago
Town ABC Game
by skyhaven
Folklore and Mythology
19 minutes 14 seconds ago
Food Game
by skyhaven
Card Games
20 minutes 31 seconds ago
Word Association Game
by skyhaven
Walking
21 minutes 48 seconds ago

So it's showing the games as recent - it's still including them in the list.

I'm just logged in as "Lisa" - not as a site administrator - so I should be seeing what other people are seeing.

Any ideas?

Well it is Scott's hack .
But anyway I would check the post island settings.
Island Type= New topics only or Recent Posts.
It looks like it may make a difference.

Scott where are you?

From looking at your post and the IDs that your excluding those numbers are pretty big and look more like POST_IDs and not TOPIC_IDs. Maybe they really are the TOPIC_IDs but to be sure, when looking at the post, go to something like Move/Merge this topic and make sure you are using the number from there.

For my own info.
Where do you see the topic id number using the move merge option?
Depending on what method you use sometimes you see it in the browser url but not always.

Okay Bella I think I figured this out on my own, After Jake's comment.
By looking at the tables.
You can't just open a topic looking at the first post number.
While viewing the first post on a topic use the move/merge option on the manage topic tab.
You will see a different number in the url in the browser.
For me looking at a post on my site.
In the header it shows #7604 but after selecting the move merge the actual Topic id is 1718.
It is in the browser url window. And it matches the table in the database.
Or you can dig in the table in the database.

you are mixing up TOPIC_ID and POST_ID

for example, the url to THIS topic has ../topics/238341/...

in it..

that doesn't mean it is the topic id.. it is really the POST_ID for Ruben's last post.. that i am replying to

so to exclude a specific topic, you really want to look @ the 1st post in the topic (#238240 - Tue Jul 27 2010 02:11 AM -- for this topic)

and change the query to t1.POST_ID NOT IN (bla, bleh, blah)...

the ubbt_TOPICS table stores the POST_ID of the 1st post in it, so bada bing... ca ching

:2c:

I did think about the whole topic ID / post ID issue, so in each case I went back to the very first post in the thread to see what its ID was.

So let's take the "Word Association Game" in the walking forum. If you click on it to see the latest entry, you get sent to

http://forums.bellaonline.com/ubbthreads.php/topics/613941/Word_Association_Game#Post613941

So then I go to the Walking forum's main page, and I click on the thread from there, to see its main entry from the beginning. which is this -

http://forums.bellaonline.com/ubbthreads.php/topics/379866/Word_Association_Game#Post379866

I can see the post ID number in the top right corner of that very first post, and indeed its ID is 379866. The second post has an ID of 380329, the third one has an ID of 380322, and so on. So the very first post is definitely the 379866 number. The last posts in that thread are up in the 600,000 range.

So if you look at my SQL statement, the line currently reads:

and t1.TOPIC_ID NOT IN (440794,613732,613731,613729,464338,528073,440794,396215,379866,613475)

So the 379866 is definitely there in that list. But yet looking at the sidebar, that thread is being featured.

Now this still might bring up a different issue. I am comfortable that I am giving the post ID of the very first post in the entire thread - and I assumed this matched the topic ID for the whole thread. Could it be that the topic ID is NOT the post ID for the very first entry?

When I go to Topic Options and use the "Add Topic to your watched Topics" for this walking thread, the URL it gives is:

http://forums.bellaonline.com/ubbthreads...1/what/showflat

So I see the 379866 in there - but I also see a 58239. Is that 58239 the topic ID?

I'll give that a shot right now and see if that does the trick!

yes, and my post says to change the SQL from ( i highlighted it in different color above):

t1.TOPIC_ID NOT IN ...

to

to t1.POST_ID NOT IN ...

there is both a TOPIC_ID and a POST_ID in a ubbt_TOPICS record.. they are two distinct things..

- from what you have above - just change to:



Scott's post (sql syntax) is correct, if you know the topic ids, but that value isn't easy to see and POST_ID suffices just the same and is stored in the ubbt_TOPICS table as the POST_ID of the 1st post in that topic