Mattia98
Mattia98
/ countryCodeToEmoji.php
Created
October 20, 2021 15:32
PHP function to convert country code to flag emoji
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 | |
| // Assumes country code to already be uppercase | |
| function countryCodeToEmoji($cc) { | |
| return | |
| mb_chr(127397 + ord($cc[0])) . | |
| mb_chr(127397 + ord($cc[1])); | |
| } | |
| // Makes sure the country code is uppercase | |
| function countryCodeToEmojiCaseSafe($cc) { |
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
| SteamVR System Report created Wed Apr 24 21:43:51 2019 | |
| <Report> | |
| SteamVR Version: 1.3.23 (1555289821) | |
| SteamVR Date: 2019-04-15 | |
| Steam: Public | |
| Steam Branch: | |
| Steam AppID: 250820 | |
| Tracking: lighthouse | |
| OS: Linux version 5.0.0-13-generic (buildd@lcy01-amd64-020) (gcc version 8.3.0 (Ubuntu 8.3.0-6ubuntu1)) #14-Ubuntu SMP Mon Apr 15 14:59:14 UTC 2019 |
Mattia98
/ get time before strike.sql
Last active
January 23, 2017 08:08
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
| SELECT extract(epoch FROM age(min("startDate")))/86400 FROM strikes WHERE "companyId" = 1; |