X-Git-Url: https://code.th-h.de/?p=usenet%2Fnewsstats.git;a=blobdiff_plain;f=doc%2FTODO;h=6f1a61b1cc4399a83ab5ac6bc8a8e4d49b52bc77;hp=444886a267863279c1816cba64f8882c53c7725d;hb=98563c619eeb66fee046c6acb3dfc0f14c442e8d;hpb=147194c1900490a15e933a3a2c79263a65b9f08e diff --git a/doc/TODO b/doc/TODO index 444886a..6f1a61b 100644 --- a/doc/TODO +++ b/doc/TODO @@ -29,6 +29,9 @@ Bug numbers refer to the Mantis issue tracker at . - Add other reports NewsStats should include some other kinds of reports (stats on used clients, on postings hosts/servers, ...) + - Add tools for database management + NewsStats should offer tools e.g. to inject postings into the 'raw' database, + or to split databases. * Individual improvements + NewsStats.pm @@ -47,34 +50,13 @@ Bug numbers refer to the Mantis issue tracker at . - General tests and optimisations + gatherstats.pl - - Fix database updates when re-running (Bug #18) - Change REPLACE to DELETE with subsequent INSERT INTO (erase wrong data, - i.e. non-existent groups) - - Enhance TLH checks to allow for more than one TLH - - Make gatherstats aware of hierarchy lists (Bug #17) - A current (!) list of existing groups (checkgroups or INN active) should - be honored, with optional modifications. Non-existing groups should be - (logged and) dropped, existing groups with no postings should be set to 0. - Hierarchy elements (*.ALL) must be taken into account. - Perhaps invalid group names should also be checked (but what characters - should be considered "invalid"?) - GroupInfo (see above) could be an alternate solution. + - Use hierarchy information (see GroupInfo above) - Add gathering of other stats (clients, hosts, ...) - better modularisation (code reuse for other reports!) - Add / enhance / test error handling - General tests and optimisations + groupstats.pl - - output: fix formatting - GetMaxLength does not work for special queries - like -l or -b - - beautify output (formats / captions) - - -a: improve code - it doesn't make that much sense to get first/last - month from database just to query that same database with a time period - that equals no time period ... this part of the WHERE clause should be - dropped instead - - change precedence handling of -m/-p/-a: drop -m if -p or -a are present, - drop -p if -a is present - - save report(s) to a file (Bug #27) - better modularisation (code reuse for other reports!) - Add / enhance / test error handling - General tests and optimisations