#!/bin/sh
#
# This script converts the flat-text password file
# to the new sqlite3 database.
#
TEMPFILE="dgl-login.tmp"
FLATDB="dgl-login"
DBFILE="dgamelaunch.db"
if [ -e "$TEMPFILE" ]; then
echo "$TEMPFILE already exists.";
exit;
fi
if [ -e "$DBFILE" ]; then
echo "$DBFILE already exists.";
exit;
fi
if [ ! -e "$FLATDB" ]; then
echo "$FLATDB does not exist.";
exit;
fi
sqlite3 "$DBFILE" "create table dglusers (id integer primary key, username text, email text, env text, password text, flags integer);"
cat "$FLATDB" | sed -e "s/'/''/g" -e "s/^\([^:]*\):\([^:]*\):\([^:]*\):/insert into dglusers (username, email, password, env, flags) values ('\1', '\2', '\3', '', 0); /g" > "$TEMPFILE"
sqlite3 "$DBFILE" ".read $TEMPFILE"
rm -f "$TEMPFILE"