Best way to count total answered questions?

Question

As I could not find a cached value, I am using:

                // get number of answered questions total
                $quAnswered = qa_opt('cache_qcount')-qa_opt('cache_unaqcount');
 

Is there another way?

Answer 1

Okay, just needed to modify the cache_unaqcount query with acount>0

SELECT COUNT(*) FROM qa_posts WHERE type="Q" AND acount>0 AND closedbyid IS NULL

That solution does not rely on cached values ;-)

 

PS: AND closedbyid IS NULL is optional, as I never count closed questions.

Comments

Is your problem solved ?

---

I just thought there is something like qa_opt('cache_qanswcount'). But does not seem so ;)

Answer 2

I am not sure, but are you looking for:

qa_opt('cache_qcount')

qa_opt('cache_acount')

qa_opt('cache_ccount')

qa_opt('cache_userpointscount')

 

Comments

It is fine, I am using my first idea now to see how many questions have been answered already:
$quAnswered = qa_opt('cache_qcount')-qa_opt('cache_unaqcount');
 
answered questions = all questions - unanswered questions