Skip to content

Instantly share code, notes, and snippets.

View hobodave's full-sized avatar
🎯
Focusing

David Abdemoulaie hobodave

🎯
Focusing
39 followers · 13 following
View GitHub Profile
@hobodave
hobodave / schema.sql
Created November 7, 2011 19:07
CREATE TABLE `survey_history` (
`schedule_history_id` int(11) NOT NULL AUTO_INCREMENT,
`schedule_id` int(11) NOT NULL DEFAULT '0',
`department_id` int(11) NOT NULL DEFAULT '0',
`iteration` int(11) NOT NULL DEFAULT '0',
`start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`due_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`completion_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`survey_user` int(11) NOT NULL DEFAULT '0',
`survey_id` int(11) NOT NULL DEFAULT '0',
@hobodave
hobodave / gist:1335302
Created November 2, 2011 23:35
220 mx.google.com ESMTP el2sm5115516ibb.10
EHLO webdev1.int.sentact.com
250-mx.google.com at your service, [207.241.32.58]
250-SIZE 35882577
250-8BITMIME
250-STARTTLS
250 ENHANCEDSTATUSCODES
@hobodave
hobodave / finfo.php
Created September 29, 2011 22:32
<?php
/** All magic files on my system */
$files = array(
'/usr/share/magic',
'/usr/share/magic.mime',
'/usr/share/file/magic',
'/usr/share/file/magic.mgc',
'/usr/share/file/magic.mime',
'/usr/share/file/magic.mime.mgc',
'/usr/share/misc/magic',
@hobodave
hobodave / gist:1187011
Created September 1, 2011 19:20
SELECT
sp.user_id
FROM shop_pagers sp
WHERE sp.user_id NOT IN (
SELECT
owner_id
FROM tickets
WHERE ticket_status NOT IN (3,4,7)
)
AND sp.shop_id = 1;
@hobodave
hobodave / gist:1186943
Created September 1, 2011 18:54
-- Abridged Schema
CREATE TABLE `tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ticket_status` smallint(6) NOT NULL DEFAULT '0',
`owner_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
CREATE TABLE `tickets_pt` (
@hobodave
hobodave / gist:1120835
Created August 2, 2011 18:23
{
"Label" = "com.apple.launchd.peruser.502";
"LimitLoadToSessionType" = "System";
"OnDemand" = true;
"LastExitStatus" = 256;
"TimeOut" = 30;
"Program" = "/sbin/launchd";
"EnableTransactions" = true;
"TransactionCount" = -1;
"MachServices" = {
@hobodave
hobodave / gist:1017243
Created June 9, 2011 17:33
document.observe('dom:loaded', function() {
if ($('action-toggle')) {
$('action-toggle').on('click', function() {
var checked = this.checked;
this.up('table').select('input.action-select').each(function(cb) {
cb.checked = checked;
})
})
}
});
@hobodave
hobodave / fastcgi_params
Created May 11, 2011 16:26
fastcgi_param QUERY_STRING $query_string;
fastcgi_param REQUEST_METHOD $request_method;
fastcgi_param CONTENT_TYPE $content_type;
fastcgi_param CONTENT_LENGTH $content_length;
fastcgi_param SCRIPT_NAME $fastcgi_script_name;
fastcgi_param REQUEST_URI $request_uri;
fastcgi_param DOCUMENT_URI $document_uri;
fastcgi_param DOCUMENT_ROOT $document_root;
@hobodave
hobodave / gist:947087
Created April 28, 2011 19:17
+-----------+-------------+---------------------+
| ticket_id | external_id | created |
+-----------+-------------+---------------------+
| 6177 | 1 | 2010-08-17 15:37:41 |
| 6178 | 1 | 2010-08-17 15:44:01 |
| 5763 | 1000055959 | 2010-06-18 10:36:17 |
| 4988 | 1000055961 | 2010-02-12 13:19:35 |
| 4983 | 1000055963 | 2010-02-12 12:13:47 |
| 4299 | 1000055967 | 2009-10-16 13:41:48 |
| 5803 | 0 | 2010-06-18 12:35:24 |
@hobodave
hobodave / gist:935437
Created April 21, 2011 20:51
array
0 =>
array
'children' =>
array
0 => &
array
'id' => string '11' (length=2)
'name' => string 'Building 1' (length=10)
'depth' => string '1' (length=1)