Skip to content

Instantly share code, notes, and snippets.

View rfay's full-sized avatar

Randy Fay rfay

190 followers · 11 following
View GitHub Profile
@rfay
rfay / working.php
Created January 16, 2016 21:48
$cat_query = "
SELECT tct.CategoryType, tc.CategoryDescription
FROM TSL_User_Categories tuc
LEFT JOIN TSL_Categories tc ON tc.CategoryId=tuc.CategoryId
LEFT JOIN TSL_CategoryTypes tct ON tc.CategoryTypeId=tct.CategoryTypeId
WHERE tuc.SubscriberId=" . $row->SubscriberID;
try {
$result = mssql_query($cat_query);
while($row = mssql_fetch_assoc($result)) {
@rfay
rfay / stuff.sql
Created January 16, 2016 21:13
SELECT TOP 100 pi.SubscriberId,
STUFF((
SELECT ',' + tct.CategoryType + '=' + tc.CategoryDescription
FROM TSL_User_Categories tuc
LEFT JOIN TSL_Categories tc ON tc.CategoryId=tuc.CategoryId
LEFT JOIN TSL_CategoryTypes tct ON tc.CategoryTypeId=tct.CategoryTypeId
WHERE pi.SubscriberId=tuc.SubscriberId
FOR XML PATH('')),1,1, '') AS categories
FROM TES_Connect_SML.dbo.TES_PROFILE_PERSONALINFORMATION pi
GROUP BY pi.SubscriberId
@rfay
rfay / user_no_updates.patch
Created September 30, 2015 23:45
diff --git a/docroot/modules/user/user.install b/docroot/modules/user/user.install
index b573e72..e51a614 100644
--- a/docroot/modules/user/user.install
+++ b/docroot/modules/user/user.install
@@ -708,207 +708,207 @@ function user_update_7011() {
* Add the user's pictures to the {file_managed} table and make them managed
* files.
*/
-function user_update_7012(&$sandbox) {
-
@rfay
rfay / Jquery Module 1 Lab.markdown
Created September 27, 2015 17:45
Jquery Module 1 Lab
@rfay
rfay / etc_php.d_xdebug_local.ini
Last active August 29, 2015 14:02
; Configuration for xdebug; the main file is xdebug.ini
xdebug.remote_enable=1
xdebug.remote_host=10.0.2.2
; xdebug.remote_port=9000
; you can comment the next line once Xdebug is working
xdebug.remote_log=/tmp/xdebug.log
@rfay
rfay / mandrill-webhook.txt
Last active December 21, 2015 03:49
Problem files for mandrill POST truncation
mandrill_events=%5B%7B%22event%22%3A%22inbound%22%2C%22ts%22%3A1376432762%2C%22msg%22%3A%7B%22raw_msg%22%3A%22Received%3A+from+nm16-vm3.bullet.mail.ne1.yahoo.com+%28nm16-vm3.bullet.mail.ne1.yahoo.com+%5B98.138.91.146%5D%29%5Cn%5Ctby+ip-10-246-30-150+%28Postfix%29+with+ESMTPS+id+446AA4A809A%5Cn%5Ctfor+%3Cmessages%40reply.warmshowers.org%3E%3B+Tue%2C+13+Aug+2013+22%3A26%3A00+%2B0000+%28UTC%29%5CnReceived%3A+from+%5B98.138.101.130%5D+by+nm16.bullet.mail.ne1.yahoo.com+with+NNFMP%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnReceived%3A+from+%5B98.138.101.169%5D+by+tm18.bullet.mail.ne1.yahoo.com+with+NNFMP%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnReceived%3A+from+%5B127.0.0.1%5D+by+omp1080.mail.ne1.yahoo.com+with+NNFMP%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnX-Yahoo-Newman-Property%3A+ymail-3%5CnX-Yahoo-Newman-Id%3A+226712.86001.bm%40omp1080.mail.ne1.yahoo.com%5CnReceived%3A+%28qmail+32961+invoked+by+uid+60001%29%3B+13+Aug+2013+22%3A25%3A59+-0000%5CnDKIM-Signature%3A+v%3D1%3B+a%3Drsa-sha256%3B+c%3Drelaxed%5C%2Frelaxed%3B+d%3Dyaho
@rfay
rfay / gist:6066776
Created July 23, 2013 22:36
curl -XGET http://localhost:9200/logstash-2013.07.23/_mapping?pretty
{
"logstash-2013.07.23" : {
"_default_" : {
"_all" : {
"enabled" : false
},
"properties" : {
"@ message" : {
"type" : "string"
},
@rfay
rfay / gist:6066738
Created July 23, 2013 22:29
curl -XGET 'http://localhost:9200/logstash-2013.07.23/_search?sort=@timestamp:desc&pretty'
{
"took" : 34,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
},
"hits" : {
"total" : 933840,
@rfay
rfay / gist:6066691
Created July 23, 2013 22:22
curl -XGET http://util.archetypeme.com:9200/logstash-2013.07.23/_search?pretty -d'
{
"facets": {
"0": {
"date_histogram": {
"field": "@timestamp",
"interval": "30s"
},
"facet_filter": {
"fquery": {
@rfay
rfay / gist:6066673
Created July 23, 2013 22:20
{
"took" : 14,
"timed_out" : false,
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
},
"hits" : {
"total" : 933840,