Tech Blog

TABLE _SqliteDatabaseProperties

your values will certainly be different here…when you “restore” your iPhone from iTunes the counters all reset

key (TEXT) value (TEXT)

call_history_limit 100

timer_last 60

timer_outgoing 900

timer_incoming 540

timer_all 1440

timer_lifetime 1440

timer_last_reset

data_up_last 2.5439454125

data_down_last 20.86328125

data_up_all 719.9228515625

data_down_all 8677.8427734375

data_up_lifetime 719.9228515625

data_down_lifetime 8677.8427734375

data_last_reset

_ClientVersion 3

_UniqueIdentifier GUID

TABLE call

ROWID (INTEGER PRIMARY KEY AUTOINCREMENT)

Auto-incrementing field/counter

address (TEXT)

International-formatted foreign address

(18005551212)

date (INTEGER)

OSX-epoch based datetime, convertable via date -r

(1187200801)

duration (INTEGER)

Length of call in seconds rounded to next minute, 0 = missed call

(60)

flags (INTEGER)

Flags controlling the type of record

5 - Outgoing call

4 - Incoming call

id (INTEGER)

AddressBook ID for outgoing calls selected from AddressBook, otherwise -1

(67)

INDEX date_index

call (date)

/*
 * Magnetic Stripe Reader
 * by Stephan King http://www.kingsdesign.com
 *
 * Reads a magnetic stripe.
 *
 */
 
int cld1Pin = 5;            // Card status pin
int rdtPin = 2;             // Data pin
int reading = 0;            // Reading status
volatile int buffer[400];   // Buffer for data
volatile int i = 0;         // Buffer counter
volatile int bit = 0;       // global bita
char cardData[40];          // holds card info
int charCount = 0;          // counter for info
int DEBUG = 0;
 
void setup() {
  Serial.begin(38400);
 
  // The interrupts are key to reliable
  // reading of the clock and data feed
  attachInterrupt(0, changeBit, CHANGE);
  attachInterrupt(1, writeBit, FALLING);
}
 
void loop(){
 
  // Active when card present
  while(digitalRead(cld1Pin) == LOW){
    reading = 1;
  }    
 
  // Active when read is complete
  // Reset the buffer
  if(reading == 1) { 
 
    if (DEBUG == 1) {
      printBuffer();
    }
 
    decode();
    reading = 0;
    i = 0;
 
    int l;
    for (l = 0; l < 40; l = l + 1) {
      cardData[l] = '\n';
    }
 
    charCount = 0;
  }
}
 
// Flips the global bit
void changeBit(){
  if (bit == 0) {
    bit = 1;
  } else {
    bit = 0;
  }
}
 
// Writes the bit to the buffer
void writeBit(){
  buffer[i] = bit;
  i++;
}
 
// prints the buffer
void printBuffer(){
  int j;
  for (j = 0; j < 200; j = j + 1) {
    Serial.println(buffer[j]);
  }
}
 
int getStartSentinal(){
  int j;
  int queue[5];
  int sentinal = 0;
 
  for (j = 0; j < 400; j = j + 1) {
    queue[4] = queue[3];
    queue[3] = queue[2];
    queue[2] = queue[1];
    queue[1] = queue[0];
    queue[0] = buffer[j];
 
    if (DEBUG == 1) {
      Serial.print(queue[0]);
      Serial.print(queue[1]);
      Serial.print(queue[2]);
      Serial.print(queue[3]);
      Serial.println(queue[4]);
    }
 
    if (queue[0] == 0 & queue[1] == 1 & queue[2] == 0 & queue[3] == 1 & queue[4] == 1) {
      sentinal = j - 4;
      break;
    }
  }
 
  if (DEBUG == 1) {
    Serial.print("sentinal:");
    Serial.println(sentinal);
    Serial.println("");
  }
 
  return sentinal;
}
 
void decode() {
  int sentinal = getStartSentinal();
  int j;
  int i = 0;
  int k = 0;
  int thisByte[5];
 
  for (j = sentinal; j < 400 - sentinal; j = j + 1) {
    thisByte[i] = buffer[j];
    i++;
    if (i % 5 == 0) {
      i = 0;
      if (thisByte[0] == 0 & thisByte[1] == 0 & thisByte[2] == 0 & thisByte[3] == 0 & thisByte[4] == 0) {
        break;
      }
      printMyByte(thisByte);
    }
  }
 
  Serial.print("Stripe_Data:");
  for (k = 0; k < charCount; k = k + 1) {
    Serial.print(cardData[k]);
  }
  Serial.println("");
 
}
 
void printMyByte(int thisByte[]) {
  int i;
  for (i = 0; i < 5; i = i + 1) {
    if (DEBUG == 1) {
      Serial.print(thisByte[i]);
    }
}
    if (DEBUG == 1) {
      Serial.print("\t");
      Serial.print(decodeByte(thisByte));
      Serial.println("");
    }
 
    cardData[charCount] = decodeByte(thisByte);
    charCount ++;
}
 
char decodeByte(int thisByte[]) {
    if (thisByte[0] == 0 & thisByte[1] == 0 & thisByte[2] == 0 & thisByte[3] == 0 & thisByte[4] == 1){
      return '0';
    }
    if (thisByte[0] == 1 & thisByte[1] == 0 & thisByte[2] == 0 & thisByte[3] == 0 & thisByte[4] == 0){
      return '1';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 1 & thisByte[2] == 0 & thisByte[3] == 0 & thisByte[4] == 0){
      return '2';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 1 & thisByte[2] == 0 & thisByte[3] == 0 & thisByte[4] == 1){
      return '3';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 0 & thisByte[2] == 1 & thisByte[3] == 0 & thisByte[4] == 0){
      return '4';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 0 & thisByte[2] == 1 & thisByte[3] == 0 & thisByte[4] == 1){
      return '5';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 1 & thisByte[2] == 1 & thisByte[3] == 0 & thisByte[4] == 1){
      return '6';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 1 & thisByte[2] == 1 & thisByte[3] == 0 & thisByte[4] == 0){
      return '7';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 0 & thisByte[2] == 0 & thisByte[3] == 1 & thisByte[4] == 0){
      return '8';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 0 & thisByte[2] == 0 & thisByte[3] == 1 & thisByte[4] == 1){
      return '9';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 1 & thisByte[2] == 0 & thisByte[3] == 1 & thisByte[4] == 1){
      return ':';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 1 & thisByte[2] == 0 & thisByte[3] == 1 & thisByte[4] == 0){
      return ';';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 0 & thisByte[2] == 1 & thisByte[3] == 1 & thisByte[4] == 1){
      return '<';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 0 & thisByte[2] == 1 & thisByte[3] == 1 & thisByte[4] == 0){
      return '=';
    }
 
    if (thisByte[0] == 0 & thisByte[1] == 1 & thisByte[2] == 1 & thisByte[3] == 1 & thisByte[4] == 0){
      return '>';
    }
 
    if (thisByte[0] == 1 & thisByte[1] == 1 & thisByte[2] == 1 & thisByte[3] == 1 & thisByte[4] == 1){
      return '?';
    }
}

/*
 * PD2437 Test
 */

/*

 - Addressing
  0xx : control word
  100 : digit 0 (rightmost)
  101 : digit 1
  110 : digit 2
  111 : digit 3 (leftmost)

 - Control Word
  b7 : clear
       0 standard operation
       1 clear entire display
  b6 : lamp test
       0 standard operation
       1 display all dots at 50% brightness
  b5 : blink
       0 blink attribute disabled
       1 blink entire display
  b4 : attribute enable
       0 disable above attributes
       1 enable above attributes
  b3,b2: attributes
       00 display cursor instead of character
       01 blink character
       10 display blinking cursor instead of character
       11 alternate character with cursor
  b1,b0: brightness
       00 0% (black)
       01 25%
       10 50%
       11 100%
      
  -----------------------------------------------------
  how to load information into the display
 
    SET BRIGHTNESS
  1. set brightness level of the entire display to your preference, (000) <- 0x02 (50%)
   
    LOAD FOUR CHARACTERS
  2. load "S" in the left hand digit, (111) <- 'S'
  3. load "T" in the next digit, (110) <- 'T'
  4. load "O" in the next digit, (101) <- 'O'
  5. load "P" in the right hand digit, (100) <- 'P'
 
    BLINK A SINGLE CHARACTER
  6. into the digit, second from the right, load the hex code 0xcf, which is the code for an 'O' with the d7 bit added as a control bit, (101) <- 0xcf
  7. load enabled blinking character into the control word register. the display should show "STOP" with a flashing "O", (000) <- 0x17
 
    ADD ANOTHER BLINKING CHARACTER
  8. into the left hand digit, load the he code 0xd3 which gives an 'S' with d7 bit added as a control bit, (111) <- 0xd3
 
    ALTERNATE CHARACTER/CURSOR ENABLE
  9. load enable alternate character/cursor into the control word register. the display now should show "STOP" with the 'O' and the 'S' alternating between the letter and cursor. (000) <- 1f
 
    INITIATE FOUR CHARACTER BLINKING
  10. load enable display blinking. the display now should show the entire word "STOP" blinking, (000) <- 0x23
*/

// Connected to LS164
int DATA = 2;    // LS164 Din  (pin 1&2)
int CLK = 3;     // LS164 Clk  (pin 8)

// Connected to PD2437
int A0 = 6;   // Address 0 (pin 7)
int A1 = 5;   // Address 1 (pin 8)
int A2 = 4;   // Address 2 (pin 9)

int WR = 7;   // Write (pin 11)
int CE = 8;   // Chip Enable (NEG, pin 6)
int RST = 9;  // Reset (NEG, pin 4)

void setup()                    // run once, when the sketch starts
{
  Serial.begin(38400);
 
  // pins for LS164
  pinMode(DATA, OUTPUT);      // sets the digital pin as output
  pinMode(CLK, OUTPUT);      // sets the digital pin as output
 
  // pins for PD2437
  pinMode(A0, OUTPUT);
  pinMode(A1, OUTPUT);
  pinMode(A2, OUTPUT);
  pinMode(WR, OUTPUT);
  pinMode(CE, OUTPUT);
  pinMode(RST, OUTPUT);
 
  // Reset PD2437
  digitalWrite(CE, HIGH);
  digitalWrite(WR, HIGH);

  digitalWrite(RST, LOW);
  digitalWrite(RST, HIGH);
}

void loop()                     // run over and over again
{
  putChar(0, 0x83);
  delay(100);
  putChar(7,'S');
  delay(100);
  putChar(6,'T');
  delay(100);
  putChar(5,'O');
  delay(100);
  putChar(4,'P');
  delay(100);
 
  putChar(4, 'P' | 0x80);    // 'P' w/ MSB
  delay(100);
  putChar(0, 0x17);
  delay(100);
  putChar(7, 'S' | 0x80);    // 'S' w/ MSB
  delay(100);
  putChar(0, 0x1f);
  delay(100);
  putChar(0, 0x23);
 
  delay(1000); 
}

//
// Subroutine for LS164
//

// Send byte to LS164
void sendByte(int d)
{
  shiftOut(DATA, CLK, MSBFIRST, d);
}

//
// Subroutine for PD2437
//

// set address for PD2437
void setAddr(int adr)
{
  digitalWrite(A0, (adr&0x1));
  digitalWrite(A1, (adr&0x2));
  digitalWrite(A2, (adr&0x4));
} 

void putChar(int pos, int ch)
{
  digitalWrite(CE, LOW);

  setAddr(pos);
  sendByte(ch);
  digitalWrite(WR, LOW);
  digitalWrite(WR, HIGH); 
  digitalWrite(CE, HIGH);
}