Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Aug 2007
Posts: 5
Lurker
Lurker
Offline
Joined: Aug 2007
Posts: 5
'O' and 'C' are obvious, but it seems that when threads get moved, reopened, etc. that there are other codes. A review of the table shows 'M' and some that are blank.

Does anyone perhaps have a list of all the possible codes and their "meanings"? What does an empty status get treated as? Is an 'M' treated as an Open/Unlocked topic?

I'm sure I can go digging through all the code, but was thinking someone here might know this off the top of their heads. We do some read-only reporting on our forums as we use them for support, and these "other" status situations need to be handled.

Thanks much!

Sponsored Links
Joined: Aug 2007
Posts: 5
Lurker
Lurker
Offline
Joined: Aug 2007
Posts: 5
Actually, I think I figured out what I needed to know, but discovered a possible "opportunity" in the software.

It appears that there are the obvious ones of 'O'pen, 'C'losed, and 'M'oved. But, I also discovered that in a case where a closed topic is re-opened, the TOPIC_STATUS is cleared leaving a non-existent status. Don't know if this is on purpose, or a bug.

But, in my reporting, as opposed to doing an IN with O, M, etc., I just now ask for records with a topic status of other than C and it seems to be working the way we like.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)