SELECT node_field_data.title AS Title,
node_field_data.type AS Type,
node_counter.daycount AS Today,
node_counter.totalcount AS Alltime,
DATE_FORMAT(FROM_UNIXTIME(node_counter.timestamp), '%y-%m-%d %T') AS Latest,
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<!-- | |
# Quick'n'Dirty Intranet Mail Search | |
1) Have dovecot index mails in SOLR | |
2) Configure the doveadm HTTP API | |
3) Create proxies for SOLR and DOVEADM | |
4) Search and find! |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/perl | |
# Quorion Registrierkasse fernsteuern | |
# - Berichte holen | |
# - Uhr stellen | |
# und vielleicht auch anderes | |
# | |
# Braucht ein POSIX System | |
# Konfiguration wie Windows QDriver |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/* | |
* The fine app https://github.com/mathisdt/trackworktime can save reports to CSV. | |
* Below script transforms the raw all data export for printing from a spreadsheet e.g. | |
*/ | |
// Wrap library call | |
function my_getcsv($line) { | |
return str_getcsv($line, ';'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python3 | |
# make a table of speed modifiers depending on slope | |
# based on the DIN 33466 formula | |
# output reverse value, for use in a router costing function | |
# estimates are quite high, an interesting tweak would be setting | |
# ascent=400 and descent=600 thereby adapting to fitter persons |