Restrict db queries ?

[katkad]

hello,

have you thought about restricting db queries to X weeks ?

I have kippo running for about 2 years, so I'd like more current statisticks.

the safest way would be to use PDO http://php.net/manual/en/book.pdo.php and bindParam, but you'd
have to rewrite most of db things in kippo-graph

I just use new variable from config.php in db_query string, but this is not the best approach
but it works.

I also use indexes on timestamp columns in db

another questions is, what the default value for this would be

[ikoniaris]

Hi @katkad, can you share any code perhaps?

[katkad]

in config.php:
define('LAST_WEEKS', '4');

then query looks like this:
$db_query = 'SELECT ip, COUNT(ip) '
. "FROM sessions "
. "WHERE starttime > DATE_SUB(now(), interval ".LAST_WEEKS." week) "
. "GROUP BY ip "
. "ORDER BY COUNT(ip) DESC "
. "LIMIT 15 ";