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 | |
/** CAUTION!!! | |
* You need to have a webserver running on localhost to make this work! | |
*/ | |
use GuzzleHttp\Client; | |
use GuzzleHttp\Event\AbstractRetryableEvent; | |
use GuzzleHttp\Message\Request; | |
use GuzzleHttp\Pool; |
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
https://www.aboutyou.at/ with Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) | |
HTTP/1.1 302 Found | |
Location: https://m.aboutyou.at/ | |
HTTP/1.1 200 OK | |
https://www.aboutyou.ch/ with Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) | |
HTTP/1.1 302 Found | |
Location: https://m.aboutyou.ch/ | |
HTTP/1.1 200 OK |
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
y="at | |
ch | |
de"; \ | |
x=" | |
Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.96 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) | |
Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) | |
Googlebot/2.1 (+http://www.google.com/bot.html) | |
"; \ | |
IFS="\n"; readarray -t countries <<<"$y";\ | |
readarray -t userAgents <<<"$x"; IFS=""; \ for y in ${userAgents[@]}; do for x in ${countries[@]}; do url="https://www.aboutyou.${x}/"; printf "\n$url with $y\n"; curl -sIL -H "user-agent: $y" $url 2>&1 | egrep 'HTTP/1.1|Location|Failed'; done; done; |
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 | |
echo "\n\nPHP: " . phpversion()."\n"; | |
echo "Default: " . mb_internal_encoding()."\n"; | |
echo "Old value of default_charset: ".ini_set("default_charset", "ASCII")."\n"; | |
echo "when default_charset is set to ASCII: " . mb_internal_encoding()."\n"; | |
echo "Old value of internal_encoding: ".ini_set("internal_encoding", "ASCII")."\n"; | |
echo "when internal_encoding is set to ASCII: " . mb_internal_encoding()."\n"; | |
echo "Old value of mbstring.mb_internal_encoding: ". ini_set("mbstring.internal_encoding", "ASCII")."\n"; | |
echo "when mbstring.internal_encoding is set to ASCII: " . mb_internal_encoding()."\n"; |
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 | |
/** | |
* Determine if the model or given attribute(s) have been modified. | |
* | |
* @param Model $m | |
* @param array|string|null $attributes | |
* @return bool | |
*/ | |
function _is_dirty(Model $m, $attributes = null){ |
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
#standardSQL | |
# Convert date / time to a different timezone in BigQuery; standard-sql; 2018-04-08 | |
# @see http://www.pascallandau.com/bigquery-snippets/convert-timestamp-date-datetime-to-different-timezone/ | |
WITH examples AS ( | |
SELECT TIMESTAMP("2018-04-08T15:50:10+00:00") AS timestamp # Daylight saving time | |
UNION ALL SELECT TIMESTAMP("2018-03-08T15:50:10+00:00") # Standard time | |
) | |
SELECT | |
timestamp, | |
DATETIME(timestamp) as datetime, |
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
-- Declare and use variables in BigQuery; 2020-05-29 | |
-- @see http://www.pascallandau.com/bigquery-snippets/use-variables/ | |
DECLARE foo_var STRING DEFAULT "foo"; | |
SELECT foo_var |
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
-- Using temporary tables via WITH (named subqueries) in Google BigQuery; 2020-05-29 | |
-- @see http://www.pascallandau.com/bigquery-snippets/use-temporary-tables-with-named-subquery/ | |
WITH data as ( | |
SELECT | |
1 as id, | |
DATE("2018-04-08") AS date, | |
UNION ALL SELECT 2, DATE("2018-04-09") | |
UNION ALL SELECT 3, DATE("2018-04-10") | |
UNION ALL SELECT 4, DATE("2018-04-11") | |
), |
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
-- Using expression subqueries to query nested and repeated fields in Google BigQuery; 2020-05-29 | |
-- @see http://www.pascallandau.com/bigquery-snippets/expression-subqueries-for-nested-repeated-fields/ | |
WITH example as ( | |
SELECT | |
1 as id, | |
[ | |
STRUCT("foo" as key, "foo 1" as value), | |
STRUCT("bar" as key, "bar 1" as value) | |
] AS data, | |
UNION ALL |
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
# Monitor Query costs in BigQuery; standard-sql; 2020-06-21 | |
# @see http://www.pascallandau.com/bigquery-snippets/monitor-query-costs/ | |
DECLARE timezone STRING DEFAULT "Europe/Berlin"; | |
DECLARE gb_divisor INT64 DEFAULT 1024*1024*1024; | |
DECLARE tb_divisor INT64 DEFAULT gb_divisor*1024; | |
DECLARE cost_per_tb_in_dollar INT64 DEFAULT 5; | |
DECLARE cost_factor FLOAT64 DEFAULT cost_per_tb_in_dollar / tb_divisor; | |
SELECT |
OlderNewer