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 | |
/** | |
* Returns UNIX timestamp from a NTP server (RFC 5905) | |
* | |
* @param string $host Server host (default is pool.ntp.org) | |
* @param integer $timeout Timeout in seconds (default is 10 seconds) | |
* @return integer Number of seconds since January 1st 1970 | |
*/ | |
function getTimeFromNTP($host = 'pool.ntp.org', $timeout = 10) |
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 | |
/** | |
* Reads data from LYWSD03MMC Xiaomi Mijia temperature sensor | |
* and stores it in a SQLite database. | |
* | |
* @author BohwaZ <https://bohwaz.net/> | |
* @see https://github.com/davi-domo/Xiaomi-Mijia-LYWSD03MMC-/blob/main/mijia_bd/MIJIA_MULTI_BD.sh | |
* @see https://smhosy.blogspot.com/2021/01/quelle-temperature-et-hydrometrie-dans.html | |
* @see https://www.fanjoe.be/?p=3911 | |
* |
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 | |
/* | |
* $db = new DB('file.sqlite'); | |
* var_dump($db->simple('SELECT * FROM table WHERE name = ?;', 'My Name')); | |
* var_dump($db->simpleSingle('SELECT * FROM table WHERE date > ? LIMIT 1;', '2020-01-01')); | |
* var_dump($db->simpleColumn('SELECT birthdate FROM table WHERE name = ?;', 'David Lynch')); | |
*/ | |
class DB extends \SQLite3 |
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
Index: src/include/lib/Garradin/Membres/Session.php | |
================================================================== | |
--- src/include/lib/Garradin/Membres/Session.php | |
+++ src/include/lib/Garradin/Membres/Session.php | |
@@ -157,10 +157,21 @@ | |
protected function deleteAllRememberMeSelectors($user_id) | |
{ | |
return $this->db->delete('membres_sessions', $this->db->where('id_membre', $user_id)); | |
} |
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 php | |
<?php | |
/* | |
This file is part of KD2FW -- <http://dev.kd2.org/> | |
Copyright (c) 2001-2019 BohwaZ <http://bohwaz.net/> | |
All rights reserved. |
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 php | |
<?php | |
/* | |
This file is part of KD2FW -- <http://dev.kd2.org/> | |
Copyright (c) 2001-2019 BohwaZ <http://bohwaz.net/> | |
All rights reserved. |
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 | |
/** | |
* Extracteur de données des relevés de compte du Crédit Mutuel | |
* à destination de Garradin (ou autre logiciel de compta) | |
* | |
* https://garradin.eu/ | |
* | |
* Ce script prend en argument un répertoire contenant des extraits | |
* de compte en PDF (ou un seul extrait de compte) et crée un fichier | |
* CSV importable directement dans Garradin. |
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 | |
/** | |
* Return number of days before certificate expiry from a HTTPS URL | |
* Usage: get_ssl_certificate_expiry('https://www.framasoft.net/') | |
* => int(45) | |
* @author bohwaz | |
*/ | |
function get_ssl_certificate_expiry(string $url): ?int | |
{ |
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
#!/bin/bash | |
which mutool &> /dev/null || (echo "mutool is not installed" && exit 1) | |
which convert &> /dev/null || (echo "imagemagick is not installed" && exit 1) | |
which zip &> /dev/null || (echo "zip is not installed" && exit 1) | |
if [ "$1" = "" ] | |
then | |
echo "Usage: $0 File.pdf" | |
exit |
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 | |
// Mode d'emploi : créer un répertoire vierge et lancer "php cavites.php" | |
const JSON_URL = 'https://www.georisques.gouv.fr/webappReport/ws/telechargement/cavites?anneemin=2003'; | |
const PROJECTIONS = [ | |
1 => 'LambertI', | |
2 => 'LambertII', | |
3 => 'LambertIII', |