I just found that the TOTALS table works in a different manner regarding live or archived posts. The P_COUNT field holds the value for live replies only, while the T_COUNT field holds the value for live topics. However, the P_A_COUNT has a value that is equal to the sum of archived topics and replies (T_A_COUNT holds the correct value for archived topics). Anyone knows the reason for this discrepancy?<
Yes, Huw, you are right. I guess I was mislead by the way the totals are shown in default.asp, where for live posts topic count is not added to the replies count.<