#!/bin/sh

#
#      _______                          .__ .__   .__   .__                 
#      \      \    ____   __ __ _______ |__||  |  |  |  |__|  ____    ____  
#      /   |   \ _/ __ \ |  |  \\_  __ \|  ||  |  |  |  |  | /  _ \  /    \ 
#     /    |    \\  ___/ |  |  / |  | \/|  ||  |__|  |__|  |(  <_> )|   |  \
#     \____|__  / \___  >|____/  |__|   |__||____/|____/|__| \____/ |___|  /
#    =========\/======\/=================================================\/==
#  v0.01 04/JUL/2007 (C) Copyright 2007-2007 Scott D. Yelich SOME RIGHTS RESERVED
# .,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.,-*~'`^`'~*-,._.-*~'`^`'~*-,._.,-*~'`^`'~*-,. 
#
#
#  LICENSE:  Creative Commons Attribution 3.0 License.
#  SEE:      http://creativecommons.org/licenses/by/3.0/
#
#

# http://www.neurillion.com/p/33/counters/bug/v1/hits

# Fri Jul 27 21:04:44 EDT 2007, v0.01 sdy

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

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

page="${1:-}"

TABLE="counter_bug_totals"
COLUMNS="rowid,page,hits"

SQL="SELECT $COLUMNS FROM $TABLE"

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

$SQLITE3 "$DATABASE" "$SQL"