<?php

require('config.php');
require(WWW_DIR.'/lib/postprocess.php');
$_DB_NAME = getenv('DB_NAME');
$db = new DB();

//totals per category in db, results by parentID
$qry="SELECT COUNT( releases.categoryID ) AS cnt, parentID FROM releases JOIN category ON releases.categoryID = category.ID GROUP BY parentID;";

//needs to be processed query
$proc="SELECT ( SELECT COUNT( releasenfoID ) AS cnt from releases where consoleinfoID IS NULL and categoryID BETWEEN 1000 AND 1999 ) AS console, ( SELECT COUNT( releasenfoID ) AS cnt from releases where imdbID IS NULL and categoryID BETWEEN 2000 AND 2999 ) AS movies, ( SELECT COUNT( releasenfoID ) AS cnt from releases where musicinfoID IS NULL and categoryID BETWEEN 3000 AND 3999 ) AS audio, ( SELECT COUNT( releasenfoID ) AS cnt from releases r left join category c on c.ID = r.categoryID where (categoryID BETWEEN 4000 AND 4999 and ((r.passwordstatus between -6 and -1) or (r.haspreview = -1 and c.disablepreview = 0)))) AS pc, ( SELECT COUNT( releasenfoID ) AS cnt from releases where rageID = -1 and categoryID BETWEEN 5000 AND 5999 ) AS tv, ( SELECT COUNT( releasenfoID ) from releases where bookinfoID IS NULL and categoryID = 7020 ) AS book, (SELECT COUNT( releasenfoID ) AS cnt from releases r left join category c on c.ID = r.categoryID where (r.passwordstatus between -6 and -1) or (r.haspreview = -1 and c.disablepreview = 0)) AS work, (SELECT COUNT( releasenfoID ) AS cnt from releases) AS releases, (SELECT COUNT( releasenfoID ) AS cnt FROM releases r WHERE r.releasenfoID = 0) AS nforemains, (SELECT count( releasenfoID ) AS cnt FROM releases WHERE releasenfoID not in (0, -1)) AS nfo, (SELECT table_rows AS cnt FROM information_schema.TABLES where table_name = 'parts' AND TABLE_SCHEMA = '".$_DB_NAME."') AS parts, (SELECT concat(round((data_length+index_length)/(1024*1024*1024),2),'GB') AS cnt FROM information_schema.tables where table_name = 'parts' AND TABLE_SCHEMA = '".$_DB_NAME."') AS partsize;";