hodadgists

SELECT t.id, e.id, e.name, e.date, e.time, t.purchase_order_id, t.section, t.row, t.seat, t.updated_at, u1.username, t.created_at, u2.username
FROM j_ticket t
INNER JOIN j_event e on e.id = t.event_id
INNER JOIN users u1 on u1.id = t.mod_user_id
INNER JOIN users u2 on u2.id = t.created_user_id
WHERE e.date > '2009-01-01' and t.id in
(
    SELECT id FROM j_ticket WHERE sold=true AND id NOT IN
    (
        SELECT ticket_id FROM j_invoice_ticket WHERE ticket_id=j_ticket.id

hodadgists

$missingtickets = DB::table('j_ticket AS t')
		->join('j_event AS e', 'e.id', '=', 't.event_id')
		->join('users AS mu', 'mu.id', '=', 't.mod_user_id')
		->join('users AS mc', 'mc.id', '=', 't.created_user_id')
		->select(
			't.id AS t_id', 't.eventDate', 't.purchase_order_id', 't.section', 't.row', 't.seat', 't.updated_at', 't.created_at',
			'e.id AS e_id', 'e.name AS eventname',
			'mu.username AS mod_username',
			'mc.username AS created_username'
			)

hodadgists

Install MAMP stack on Mountain Lion using MacPorts

NOTE: I keep most of my Apache/PHP/MySQL configuration stuff in a local Git repository so I can track changes and I symlink to those from where they should be so you will see commands such as sudo ln -s ~/Documents/configs/PHP/fat-tony.local.php55.ini /opt/local/etc/php55/php.ini. If you don’t have a similar setup, just copy your configuration files to where they need to be.

ALSO: I like to prepend some of the commands with time just for curiosity’s sake to see how long it takes.

Turn off the built-in Apache

Go to System Preferences -> Sharing and uncheck the Personal Web sharing. You will never turn Apache on/off here again.

hodadgists

    .featureBanner {  
        position: relative;  
        margin: 20px  
    }  
    .featureBanner:before {  
        content: "Featured";  
        position: absolute;  
        top: 5px;  
        left: -8px;  
        padding-right: 10px;  

hodadgists

    a {  
        color: #00e;  
    }  
    a:visited {  
        color: #551a8b;  
    }  
    a:hover {  
        color: #06e;  
    }  
    a:focus {  

hodadgists

    .ribbon {  
        background-color: #a00;  
        overflow: hidden;  
        /* top left corner */  
        position: absolute;  
        left: -3em;  
        top: 2.5em;  
        /* 45 deg ccw rotation */  
        -moz-transform: rotate(-45deg);  
        -webkit-transform: rotate(-45deg);  

hodadgists

body {  
    -webkit-touch-callout: none;  
    -webkit-user-select: none;  
    -khtml-user-select: none;  
    -moz-user-select: none;  
    -ms-user-select: none;  
    user-select: none;  
} 

hodadgists

    .graybtn {  
        -moz-box-shadow:inset 0px 1px 0px 0px #ffffff;  
        -webkit-box-shadow:inset 0px 1px 0px 0px #ffffff;  
        box-shadow:inset 0px 1px 0px 0px #ffffff;  
        background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #ffffff), color-stop(1, #d1d1d1) );  
        background:-moz-linear-gradient( center top, #ffffff 5%, #d1d1d1 100% );  
        filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#ffffff', endColorstr='#d1d1d1');  
        background-color:#ffffff;  
        -moz-border-radius:6px;  
        -webkit-border-radius:6px;  

hodadgists

background-image: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAMAAAAp4XiDAAAAUVBMVEWFhYWDg4N3d3dtbW17e3t1dXWBgYGHh4d5eXlzc3OLi4ubm5uVlZWPj4+NjY19fX2JiYl/f39ra2uRkZGZmZlpaWmXl5dvb29xcXGTk5NnZ2c8TV1mAAAAG3RSTlNAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEAvEOwtAAAFVklEQVR4XpWWB67c2BUFb3g557T/hRo9/WUMZHlgr4Bg8Z4qQgQJlHI4A8SzFVrapvmTF9O7dmYRFZ60YiBhJRCgh1FYhiLAmdvX0CzTOpNE77ME0Zty/nWWzchDtiqrmQDeuv3powQ5ta2eN0FY0InkqDD73lT9c9lEzwUNqgFHs9VQce3TVClFCQrSTfOiYkVJQBmpbq2L6iZavPnAPcoU0dSw0SUTqz/GtrGuXfbyyBniKykOWQWGqwwMA7QiYAxi+IlPdqo+hYHnUt5ZPfnsHJyNiDtnpJyayNBkF6cWoYGAMY92U2hXHF/C1M8uP/ZtYdiuj26UdAdQQSXQErwSOMzt/XWRWAz5GuSBIkwG1H3FabJ2OsUOUhGC6tK4EMtJO0ttC6IBD3kM0ve0tJwMdSfjZo+EEISaeTr9P3wYrGjXqyC1krcKdhMpxEnt5JetoulscpyzhXN5FRpuPHvbeQaKxFAEB6EN+cYN6xD7RYGpXpNndMmZgM5Dcs3YSNFDHUo2LGfZuukSWyUYirJAdYbF3MfqEKmjM+I2EfhA94iG3L7uKrR+GdWD73ydlIB+6hgref1QTlmgmbM3/LeX5GI1Ux1RWpgxpLuZ2+I+IjzZ8wqE4nilvQdkUdfhzI5QDWy+kw5Wgg2pGpeEVeCCA7b85BO3F9DzxB3cdqvBzWcmzbyMiqhzuYqtHRVG2y4x+KOlnyqla8AoWWpuBoYRxzXrfKuILl6SfiWCbjxoZJUaCBj1

hodadgists

h1,h2,h3,h4,h5{  
    color: #005a9c;  
}  
h1{  
    font-size: 2.6em;  
    line-height: 2.45em;  
}  
h2{  
    font-size: 2.1em;  
    line-height: 1.9em;