Skip to content

Instantly share code, notes, and snippets.

(ip.geoip.asnum eq 14061) or (ip.geoip.asnum eq 16276) or (ip.geoip.asnum eq 24940) or (ip.geoip.asnum eq 35540) or (ip.geoip.asnum eq 39690) or (ip.geoip.asnum eq 62567) or (ip.geoip.asnum eq 133165) or (ip.geoip.asnum eq 135340) or (ip.geoip.asnum eq 200130) or (ip.geoip.asnum eq 201229) or (ip.geoip.asnum eq 202018) or (ip.geoip.asnum eq 202109) or (ip.geoip.asnum eq 205301) or (ip.geoip.asnum eq 393406) or (ip.geoip.asnum eq 394362) or (ip.geoip.asnum eq 212317) or (ip.geoip.asnum eq 213230) or (ip.geoip.country eq "CN") or (ip.geoip.country eq "RU")
@montes
montes / gist:c51930467c2b33564b1d
Created March 25, 2015 16:35
Mysql query joining multiple cusfom fields (Wordpress)
SELECT wp_5_posts., meta1., meta2.*
FROM wp_5_posts
INNER JOIN wp_5_postmeta as meta1 ON wp_5_posts.ID = meta1.post_id
INNER JOIN wp_5_postmeta as meta2 ON meta2.meta_key = REPLACE(meta1.meta_key, 'acf_starting_date', 'acf_is_date_range')
AND meta1.post_id = meta2.post_id
WHERE wp_5_posts.post_status = 'publish'
AND wp_5_posts.post_type = 'event'
AND meta1.meta_key LIKE 'acf_date_list_%_acf_starting_date'
AND meta1.meta_value = '20150325'
GROUP BY wp_5_posts.ID ORDER BY wp_5_posts.post_date DESC;
@montes
montes / gist:07f550e24e8193037f55
Created November 14, 2014 16:18
Check if images from Google Shopping Feed exist
<?php
$googleShoppingXml = file_get_contents('http://www.url.com/googleshopping.xml');
preg_match_all('~(http://[^\s<]+jpg)~si', $googleShoppingXml, $imagesUrls);
foreach ($imagesUrls[0] as $imageUrl) {
$responseCode = get_headers($imageUrl, 1)[0];
if (stristr($responseCode, '404') !== false)
ob_start();
echo "\n>>>>>>>>>>++++++case setCartCustomerId+++++++++<<<<<<<<<\n";
echo date('d/m/Y H:i:s');
echo "\n------GET:-----\n";
var_dump($_GET);
echo "\n------POST:-----\n";
var_dump($_POST);
echo "\n------\n";
$text = ob_get_clean();
@montes
montes / Quick mysql+php script
Last active December 17, 2015 01:49
Quick mysql+php script
<?php
$mysqli = new mysqli("localhost", "root", "password", "database");
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
/*
@montes
montes / gist:3788705
Created September 26, 2012 15:28
JavaScript - Anonymous function
(function($) {
})(jQuery);