#!/bin/sh

# Fri Aug  3 11:27:36 EDT 2007, v0.01 

DEFAULT_DATABASE="data.db";
DEFAULT_DATABASE="/neurillion/www/p/33/databases/uniquehits.sq3"

SQLITE3=sqlite3 # rely on path
DATABASE="${2:-$DEFAULT_DATABASE}"

page="${1:-}"

TABLE="counter_unique_totals"
COLUMNS="rowid,page,hits" # ip time

SQL="SELECT $COLUMNS FROM $TABLE"

test "z$page" != "z"  && {
  SQL="$SQL WHERE page='$page';"
}

$SQLITE3 "$DATABASE" "$SQL"