truedat101

# .gitignore for IDE users


#
# .gitignore for eclipse
# 
.settings

#
# .gitignore for XCode users

truedat101

/* Simple query to convert dob (date) into number) */
SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl

/* Simple query to add WHERE clause into above computed field, get all aged above 50 */
select age from (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl) bar where age > 50;

/* Simple query to add WHERE clause into above computed field, get all aged above 25 and less than 70 */
select age from (SELECT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(dob)), '%Y')+0 AS age FROM my_tbl) bar 
WHERE age > 25 
AND age < 70

truedat101

SMILE Plug is running:
Linux SMILEplug 2.6.35.9-ARCH #7 PREEMPT Wed Sep 19 14:07:47 MDT 2012 armv7l GNU/Linux
root@SMILEplug:~/spdist# cat /proc/cpuinfo 
Processor	: Marvell PJ4Bv7 Processor�� rev 1 (v7l)
BogoMIPS	: 1199.30
Features	: swp half thumb fastmult vfp edsp vfpv3 vfpv3d16 
CPU implementer	: 0x56
CPU architecture: 7
CPU variant	: 0x1
CPU part	: 0x581

truedat101

# /etc/init/graylog-webrick.conf
# attribution:
# http://blog.joshsoftware.com/2012/02/14/upstart-scripts-in-ubuntu/
#
# More on upstart for dummies: http://upstart.ubuntu.com/getting-started.html
#
description "graylog2 webrick service"
author      "foo"

# used to be: start on startup

truedat101

---
# ^^^ YAML documents must begin with the document separator "---"
#
#### Example docblock, I like to put a descriptive comment at the top of my 
#### playbooks.
#
# Overview: Playbook to bootstrap a new host for configuration management.
# Applies to: production
# Description: 
#   Ensures that a host is configured for management with Ansible.

truedat101

                           Apache License
                        Version 2.0, January 2004
                     http://www.apache.org/licenses/

TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION

1. Definitions.

   "License" shall mean the terms and conditions for use, reproduction,
   and distribution as defined by Sections 1 through 9 of this document.

truedat101

question,choice1,choice2,choice3,choice4,has_image,answers
What color is the sky?,Blue,Green,Yellow,Orange,,choice1

truedat101

Sign up here

http://zc.qq.com/en/index.html

You will be required to provide a valid email to allow you to validate the account.  Also annoying, you don't get to choose your email account name, it gets assigned.

Sign in, english: https://en.mail.qq.com/cgi-bin/loginpage

For configuration,  I could not get pop3 working.  It's unclear why.  IMAP did work, using:

truedat101

Script started on Thu 29 Aug 2013 03:40:33 PM PDT
root@SMILEplug:~# ip##[Kwpriv wdev0ap0 wpawpa2mode 3
root@SMILEplug:~# iwpriv wdev0ap0 wpawpa2mode 3##[K##[K##[K##[K##[K##[K##[K##[K##[K##[K##[K##[K##[Kpassphrase "wpa2 mysecret"
root@SMILEplug:~# ip##[Kwpriv wdev0ap0 ciphersuite "wpa2 aes-ccmp"
root@SMILEplug:~# w##[Kiwconfig de##[K##[Kwe##[Kdev0ap0 commit
root@SMILEplug:~# iwconfig wdev0ap0 commit
root@SMILEplug:~# iwpriv wdev0ap0 wpawpa2mode 3
lo        no private ioctls.

eth0      no private ioctls.

truedat101

[
   {
      "TYPE":"QUESTION",
      "IP":"127.0.0.1",
      "NAME":"teacher",
      "O1":"Person from outer space",
      "O2":"Both  answers in 3) and 4)",
      "O3":"Non-citizen",
      "O4":"A first generation of Japanese (Issei) who came to the U.S.A.",
      "Q":"When referring to Japanese Americans, what was an Alien?",