getGOsaUUID(); $amount = sqlite_escape_string($amount); $duration = sqlite_escape_string($duration); $clicks = sqlite_escape_string($clicks); $res = stats::checkDatabase(); $TABLE_NAME = 'stats'; $query = " INSERT INTO {$TABLE_NAME} (ACTID, TYPE, PLUGIN, ACTION, UUID, MTIMESTAMP, TIMESTAMP, AMOUNT, DURATION) VALUES ('{$clicks}','{$type}','{$plugin}','{$action}','{$uuid}','{$mtimestamp}','{$timestamp}','{$amount}','{$duration}')"; sqlite_query($query, $res); } static function show() { $res = stats::checkDatabase(); $TABLE_NAME = 'stats'; $query = "SELECT * FROM {$TABLE_NAME} ORDER BY MTIMESTAMP"; $query = "SELECT PLUGIN, ACTION, MAX(DURATION) as 'DURATION' FROM {$TABLE_NAME} WHERE ACTION='modify' GROUP BY PLUGIN,ACTION "; $query = "SELECT * FROM {$TABLE_NAME} ORDER BY ID DESC LIMIT 20"; $res = sqlite_query($query, $res); echo "

";
        foreach(sqlite_fetch_all($res) as $entry){
            foreach($entry as $key => $str){
                if(is_numeric($key)) continue;
                
                if($key == "DURATION"){
                    $str = sprintf("%0.4f", $str);
                    echo str_pad($str,20,' ', STR_PAD_LEFT)."|"; 
                }else{
                    echo str_pad($str,20,' ')."|"; 
                }
            }
            echo "\n";
        }
        echo "

"; echo sqlite_error_string($res); } } ?>