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/ubbth...8239/Number/379866/fpart/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!


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts