Skip to content

Instantly share code, notes, and snippets.

View chrisarusso's full-sized avatar

Chris Russo chrisarusso

View GitHub Profile
mysql> select tv.name as Vocab, ttd.name as Term_name, ti.nid from taxonomy_vocabulary tv, taxonomy_term_hierarchy tth, taxonomy_term_data ttd, taxonomy_index ti where ti.tid = ttd.tid and ttd.tid = tth.tid and tv.vid = ttd.vid and tth.parent = 0 and tv.vid = 11;
+---------+----------------------------+------+
| Vocab | Term_name | nid |
+---------+----------------------------+------+
| Sectors | Consumer Discretionary | 1436 |
| Sectors | Consumer Staples | 1436 |
| Sectors | Energy | 1436 |
| Sectors | Financials | 1436 |
| Sectors | Health Care | 1436 |
| Sectors | Industrials | 1436 |
mysql> select ttd.tid Term_ID, tv.name AS Vocabulary, ttd.name as Term_Name from taxonomy_term_data ttd, taxonomy_vocabulary tv where tv.vid = ttd.vid and ttd.name in (select name from taxonomy_term_data ttd2 group by name having count(*) > 1) order by Term_Name;
+---------+-----------------------+-----------------------------------------+
| Term_ID | Vocabulary | Term_Name |
+---------+-----------------------+-----------------------------------------+
| 601 | Article Tags | Antitrust |
| 451 | Professional Practice | Antitrust |
| 1036 | Sectors | Capital Markets |
| 214 | Professional Practice | Capital Markets |
| 456 | Sectors | Consumer Discretionary |
html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,input,select,textarea,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{margin:0px;padding:0px;border:0px;outline:0px;font-size:100%;vertical-align:baseline;background:transparent;line-height:inherit;}ol,ul,ul,ul li{list-style:none;}blockquote,q{quotes:none;}blockquote:before,blockquote:after,q:before,q:after{content:'';content:none;}:focus{outline:0px;}ins{text-decoration:none;}del{text-decoration:line-through;}table{border-collapse:collapse;border-spacing:0px;}input,select,textarea,body{font:13px/20px "Helvetica Neue",Helvetica,Arial,sans-serif;}
#blocks td.region{font-weight:bold;}#blocks tr.region-message{font-weight:normal;color:#999;}#blocks tr.region-populated{display:none;}div#edit-openid-identifier-wrapper{display:block;}html.js #user-login-form div#edit-openid-identif
549 drush sqlsan -y
550 ls
551 git status
552 git diff
553 ls
554 cd sites/localhost/
555 drush sqlsan -y
556 ls
557 ls
558 drush uli -l crown.l
Chriss-MacBook-Pro:drupalroot chris$ git remote -v
origin git@github.com:AnneTee/Tilthy-Rich-Compost-Website.git (fetch)
origin git@github.com:AnneTee/Tilthy-Rich-Compost-Website.git (push)
upstream git@github.com:illmasterc/Tilthy-Rich-Compost-Website.git (fetch)
upstream git@github.com:illmasterc/Tilthy-Rich-Compost-Website.git (push)
/**
* Function to queue up text and email reminders from cron runs.
*/
function compost_customizations_queue_reminders() {
$now = time();
$tomorrow_timestamp = $now + 60 * 60 * 24;
$tomorrow = date('l', $tomorrow_timestamp);
// Somewhat arbitrary. Reminders ought to be once a week, but on certain
// weeks, like holidays, the gap will be larger or smaller. Three days seems
ubuntu@ip-10-185-213-32:~$ composer global require drush/drush:dev-master
Changed current directory to /home/ubuntu/.composer
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
- Installing pear/console_table (1.2.0)
PHP Fatal error: Uncaught exception 'ErrorException' with message 'proc_open(): fork failed - Cannot allocate memory' in phar:///usr/local/bin/composer/vendor/symfony/console/Symfony/Component/Console/Application.php:983
Stack trace:
#0 [internal function]: Composer\Util\ErrorHandler::handle(2, 'proc_open(): fo...', 'phar:///usr/loc...', 983, Array)
#1 phar:///usr/local/bin/composer/vendor/symfony/console/Symfony/Component/Console/Application.php(983): proc_open('stty -a | grep ...', Array, NULL, NULL, NULL, Array)
@chrisarusso
chrisarusso / gist:c75ce89616499a10585e
Created October 17, 2014 15:59
Test POST from Stripe
{
"created": 1326853478,
"livemode": false,
"id": "evt_00000000000000",
"type": "invoice.payment_failed",
"object": "event",
"request": null,
"data": {
"object": {
"date": 1413483530,
Chriss-MacBook-Pro:drupalroot chris$ nslookup bikedurham.org
Server: 192.168.1.1
Address: 192.168.1.1#53
Non-authoritative answer:
Name: bikedurham.org
Address: 54.235.218.55
Chriss-MacBook-Pro:drupalroot chris$ cd trc/c
Chriss-MacBook-Pro:drupalroot chris$ host bikedurham.org
Chriss-MacBook-Pro:drupalroot chris$ ping 54.227.113.247
PING 54.227.113.247 (54.227.113.247): 56 data bytes
Request timeout for icmp_seq 0
Request timeout for icmp_seq 1
Request timeout for icmp_seq 2
Request timeout for icmp_seq 3
Request timeout for icmp_seq 4
Request timeout for icmp_seq 5
Request timeout for icmp_seq 6
Request timeout for icmp_seq 7