<?php

/* Require configuration */
require_once("config.php");
/* Require database */
require_once("db.php");

class Statistics {
    
    function getLastPerformedSuck($type = "post") {
        global $db;
        $query = "SELECT * FROM ".DB_PREFIX."statistics WHERE type='".$type."' ORDER BY performed DESC LIMIT 10";
        $result = $db->query($query);
        $stats = array();
        if(mysql_num_rows($result)) {
            while($stat = mysql_fetch_array($result)) {
                $stats []= $stat;
            }
        }  
        return $stats;  
    }
    
    function performSuck($type) {
        global $db;
        $query = "INSERT into ".DB_PREFIX."statistics (error, type) values (1, '".$type."')";
        $result = $db->query($query);
        if ($result) {
            return mysql_insert_id();
        }
        return 0;
    }
    function completeSuck($id, $count, $log) {
        global $db;
        $query = "UPDATE ".DB_PREFIX."statistics set completed=NOW(), count=".$count.", log='".$log."', error=0 WHERE id=".$id;
        $result = $db->query($query);
        if ($result) {
            return 1;
        }
        return 0;
    }
    
    function writeLog($log) {
        global $db;
        $query = "INSERT into ".DB_PREFIX."log (log) values ('".mysql_real_escape_string($log)."')";
        $result = $db->query($query);
        if ($result) {
            return mysql_insert_id();
        }
        return 0;
    }
    
    function readLog($id) {
        global $db;
        $query = "SELECT log FROM ".DB_PREFIX."log WHERE id=".$id;
        $result = $db->query($query);
        if(mysql_num_rows($result)) {
            while($stat = mysql_fetch_array($result)) {
                return $stat[0];
            }
        }  
        return "No log recorded with this id!";  
    }
}
?>