Re: [Openaaq-discuss] Statistics Module

[Alex P. <ale...@zw...>]

You can invoke any script from a command line or cron to build pages
periodically with something like:
mysql -pPASSWORD -uUSER DATABASE -t < /PATH/sql/total.sql > summary.txt

To build a real time summary format a web page with the code below for
every item you wish to use. You can format one or more pages this way.
This is an Apaches serverside include executing mysql with the -t
option to create a table display.

The link to this was from a staff support page, not inside the AAQ
interface. 

<h3>Total Answered Questions</h3>
<pre>
<!--#exec cmd="/usr/local/bin/mysql -pPASSWORD -uUSER DATABASE -t <
/PATH/sql/total.sql" -->
</pre>

Alex








ope...@li... wrote:
> 
> Hi there everybody... again!  :)
> 
> I have AAQ up and running (thanks to all of you!) and now we're 
> finishing the test period....
> 
> In the meantime... I've found an 'a/sql' directory, with SQLs for a 
> variety of statistics....   The question is... Are they usable from 
> within AAQ web?... or must they be used another way... like cron or 
> something?
> 
> Thanks again!
> 
> 
> -- 
> J. Martin Longo
> Informática
> SID-UNCuyo
> http://sid.uncu.edu.ar
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Openaaq-discuss mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openaaq-discuss
>