Return to convert_dgl-login.sh CVS log

Up to [contributed] / dgamelaunch-openbsd

Annotation of dgamelaunch-openbsd/convert_dgl-login.sh, Revision 1.1.1.1

1.1       rubenllo    1: #!/bin/sh
                      2: #
                      3: # This script converts the flat-text password file
                      4: # to the new sqlite3 database.
                      5: #
                      6:
                      7:
                      8: TEMPFILE="dgl-login.tmp"
                      9: FLATDB="dgl-login"
                     10: DBFILE="dgamelaunch.db"
                     11:
                     12:
                     13: if [ -e "$TEMPFILE" ]; then
                     14:     echo "$TEMPFILE already exists.";
                     15:     exit;
                     16: fi
                     17: if [ -e "$DBFILE" ]; then
                     18:     echo "$DBFILE already exists.";
                     19:     exit;
                     20: fi
                     21: if [ ! -e "$FLATDB" ]; then
                     22:     echo "$FLATDB does not exist.";
                     23:     exit;
                     24: fi
                     25:
                     26:
                     27: sqlite3 "$DBFILE" "create table dglusers (id integer primary key, username text, email text, env text, password text, flags integer);"
                     28:
                     29: cat "$FLATDB" | sed -e "s/'/''/g" -e "s/^\([^:]*\):\([^:]*\):\([^:]*\):/insert into dglusers (username, email, password, env, flags) values ('\1', '\2', '\3', '', 0); /g" > "$TEMPFILE"
                     30:
                     31: sqlite3 "$DBFILE" ".read $TEMPFILE"
                     32:
                     33: rm -f "$TEMPFILE"